مشكله في ادارة المشتركين \ الصلاحيات [ مجابة ]
المشرف: alhitary
قوانين المنتدى
فضلاً قبل وضع أي مشكلة تأكد من استخدام البحث ومن ثم ملء استمارة الدعم إذا لم تجد حلا لمشكلتك.
فضلاً قبل وضع أي مشكلة تأكد من استخدام البحث ومن ثم ملء استمارة الدعم إذا لم تجد حلا لمشكلتك.
????? ?? ????? ????????? \ ????????? [ ????? ]
?????? ?????
?????
???? ?????
??? ???? ????????? ?? ??? ??????? ???? ???? ??????
??? ???? ???
???? ???? ?? ???? ????
????? ???
?????
???? ?????
??? ???? ????????? ?? ??? ??????? ???? ???? ??????
كود: تحديد الكل
??? ???
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 (22, , 1)
Line : 397
File : admin_ug_auth.php
??? ???? ???
كود: تحديد الكل
???
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, 1, 1, 1, 1, 1, 1, 0)' at line 2
INSERT INTO phpbb_auth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (13, , 1, 1, 1, 1, 1, 1, 1, 0)
Line : 397
File : admin_ug_auth.php
???? ???? ?? ???? ????
????? ???

آخر تعديل بواسطة elbadawy في السبت نوفمبر 18, 2006 12:23 am، تم التعديل مرة واحدة.
????? ??? ?? ????? ?????
???? :
??? ??? ????? ?? ??? ?????? groupfix.php
????? ????? ????
http://www.*********.com/phpbb/groupfix.php
???? ?? ????? ???? ???? ??????
?????? ???
???? ??? ???? ????? ??? ??????? ?????
??? ???? ??? ?????
????? ??????
???? :
??? ??? ????? ?? ??? ?????? groupfix.php
????? ????? ????
http://www.*********.com/phpbb/groupfix.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);
?>
???? ??? ???? ????? ??? ??????? ?????
??? ???? ??? ?????

????? ??????
الموجودون الآن
المتصفحون للمنتدى الآن: لا يوجد أعضاء مسجلين متصلين و 6 زوار