لا يمكن إعطاء صلاحيات لا للأعضاء ولا للمجموعات.

[Chaos]

?????? ????? ? ???? ???? ..


???? ????? ????? ?? ??? ??? ??????? ?? ?? ???? ?? ???? ? ??????? ?? ????? ? ???? ??? ???? ? ???? ????? ?? ?????? ???? ??????? ?????? ? ?? ???? ????? ?? ?????? ????? ??? ?????? ???? ????? ???? ?? ???????? ?? ??? ????? ????.

??????? ?? ???? ?? ?????? ??? ?? ??? ?? ?????? ????? ??????? ??? ?? ??? .

? ???? ?? ?????? ??? ?????? ??? ????????? ???? ??? ??? :

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 phpbb_auth_access (forum_id, group_id, auth_mod) VALUES (11, , 1)

Line : 391
File : admin_ug_auth.php



??? ????? ????? ??? ?????? ??????? ????? ?? ??????:

Could not obtain moderator status

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.use' at line 3

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM phpbb_auth_access aa, phpbb_user_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 : 532
File : admin_ug_auth.php



? ????? ?????? ????????




???? ???? ?????

[(SKAY)]

?????? ?????? ????? ???? ???????
??? ??? ??? ???????? ????? ???? ? ?? ???? ??? ????? ??? ???? ? ?? ???? ???? ????? ? ??? ???? ?????? ???? ??????? ???????
?? ??????

[Chaos]

?????? ????? ..

?????? ???? ????? ??? ???? ?????? ..

?????? ??? ??????? ????? ???? ??? ?? ???? ??? ????? ??????? ? ????? ?????????? ??????? ?????? !

???? ??? ???? ????? ??? ???? ????? ?? ?? ?? ????? ????? ?? ?? ????? ?? ??? ?? ??? ????? ???? ???? ?? ????? "funcion_search error" ??????? ????incluedes .. ?????? ????? ??????? ?? ???? fixtables.php ? ?? ???? ???? ?? ???? ??????? ?? 1.9 ??? 2.0 ????? ??? ??????? .. ? ???? ??????? ?????? ???.

?? ???? backup ????? ????? ???????? ?? phpMyAdmin ? ?????? ????? .. ? ?? ?? ???? ????? ???? (new installation) ??????? ???????? ?? ????? .. ? ?? ?? ????? ?????? ????? ?? (???? ???????) ???? ?? ???default ???? ?? Subsilver .. ? ?? ?? ??? ???????? ????? ???????? ??? ???Auth Access ? ???Config .. ?????? ??? ?? (?? ??????)

? ?? ???? ??????? ??? ?? ..

?? ???? ??????? (auth access ? config) ??????? ??? ???? .. ?? ???? ??? ???????? ??????? ? ??????? (all tables) ???? ??? ??.

? ????? ?? ????? ???search ????? ? ?? ????? ???auth access ?????? !!!! (????? ???? ??????? ??????? ???? ??? ?? )

? ??? ?? ??? ????? ! ??? ?? ????? ???Search ???? ????? ? ?? ????? ???auth ug ????.


? ????? ?????? ?? ?? ?? ??? ??? ????? ????? ?? ?? ????? ?????? ? ??? ????? ???????.

? ?? ?? ????????? ?????? ??? ?? ? ??? ??? ????? ??????? ? ????? ?????.

? ?? ??????? ?? ???? ??? ??????.

? ???? ????? ??? ?????? "???????" ??????? ????? ? ???? ?? ???? ??? !!

???? ?????? ????? ???????? ??? ???????? ? ?????? ????? ????? ????????????



?? ???? ????? ? ???????

[Chaos]

????? ??????? ? ????????.

???? ????? ?????? ?? ??? ? ????? fix.php :

كود: تحديد الكل

<?php
//*****  check users and user groups ****//

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_search.'.$phpEx);

// Start session management
$userdata = session_pagestart($user_ip, PAGE_SEARCH);
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);

?>

? ????? ?????? ??????? ??????? ? ???????? ??? ?????? ?? ??????.


?????