<?php 


//*****  check users and user groups ****// 





if (!eregi("modules.php", $_SERVER['PHP_SELF'])) { 


    die ("You can't access this file directly..."); 


} 


$module_name = basename(dirname(__FILE__)); 


require("modules/Forums/nukebb.php"); 





define('IN_PHPBB', true); 


include($phpbb_root_path . 'extension.inc'); 


include($phpbb_root_path . 'common.'.$phpEx); 


include('includes/functions_search.'.$phpEx); 





// Start session management 


$userdata = session_pagestart($user_ip, PAGE_SEARCH, $nukeuser); 


init_userprefs($userdata); 


// End session management 





$sql = "SELECT user_id, username 


    FROM " . USERS_TABLE ." 


    WHERE user_id > 0"; 


if ( !($result = $db->sql_query($sql)) ) 


{ 


    message_die(GENERAL_ERROR, 'Could not obtain user list', '', __LINE__, __FILE__, $sql); 


} 





$liste =''; 


while ( $row = $db->sql_fetchrow($result) ) 


{ 


   $username = $row['username']; 


   $user_id = $row['user_id']; 


   $usergroup = ''; 


    


   $sql1 = "SELECT ug.group_id 


          FROM " . USER_GROUP_TABLE ." ug, ". GROUPS_TABLE. " g  


          WHERE ug.user_id = $user_id 


            AND ug.group_id = g.group_id 


            AND g.group_single_user  = 1 


            "; 


              


   if ( ($result1 = $db->sql_query($sql1)) ) 


   { 


       $row1 = $db->sql_fetchrow($result1); 


          $usergroup =( ( $row1['group_id'] != '' ) ? $row1['group_id'] : 'User has no user group'.$row1 ); 


          


   } 





          if (!($row1['group_id'] != '')) 


          { 


              


         $sql2 = "SELECT MAX(group_id) AS total 


            FROM " . GROUPS_TABLE; 


         if ( !($result2 = $db->sql_query($sql2)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sq2l); 


         } 





         if ( !($row2 = $db->sql_fetchrow($result2)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sql2); 


         } 


         $group_id = $row2['total'] + 1; 


          


          


         $sql3 = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator) 


            VALUES ($group_id, '', 'Personal User', 1, 0)"; 


         if ( !($result3 = $db->sql_query($sql3, BEGIN_TRANSACTION)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql3); 


         } 





         $sql4 = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending) 


            VALUES ($user_id, $group_id, 0)"; 


         if( !($result4 = $db->sql_query($sql4, END_TRANSACTION)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not insert data into user_group table', '', __LINE__, __FILE__, $sql4); 


         } 





              


             $usergroup = $usergroup.', adding user group '.$group_id; 


          } 








   $liste .= ( ( $liste != '' ) ? '<br> ' : '' ) . $username.' <b>'.$usergroup.'</b>'; 


} 





message_die(GENERAL_MESSAGE,'Users:<br>'.$liste); 





?>

Couldn't update private forum permissions





DEBUG MODE





SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1)' at line 2





INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (25, , 1)





Line : 425


File : /home/nuclearx/public_html/modules/Forums/admin/admin_ug_auth.php

Internal Server Error


The server encountered an internal error or misconfiguration and was unable to complete your request.


Please contact the server administrator, webmaster@nukeweb.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.





More information about this error may be available in the server error log.








Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.