CREATE TABLE `nuke_authors` (


  `aid` varchar(25) NOT NULL default '',


  `name` varchar(50) default NULL,


  `url` varchar(255) NOT NULL default '',


  `email` varchar(255) NOT NULL default '',


  `pwd` varchar(40) default NULL,


  `counter` int(11) NOT NULL default '0',


  `radminsuper` tinyint(1) NOT NULL default '1',


  `admlanguage` varchar(30) NOT NULL default '',


  PRIMARY KEY  (`aid`),


  KEY `aid` (`aid`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1;





-- 


-- Dumping data for table `nuke_authors`


-- 





INSERT INTO `nuke_authors` VALUES ('bsr', 'God', 'http://www.domain.com', 'contact@domain.com', 'md5pass', 35, 1, '');

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 ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.' at line 3





SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id





Line : 528


File : admin_ug_auth.php

<?php 


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


if (!eregi("modules.php", $PHP_SELF)) {


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


}


if ($popup != "1"){


    $module_name = basename(dirname(__FILE__));


    require("modules/".$module_name."/nukebb.php");


}


else


{


    $phpbb_root_path = 'modules/Forums/';


}





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); 





?>