- Code: Select all
in file privmsg.php
[FIND]
$sql = "SELECT DISTINCT g.group_id, g.group_name
FROM ".GROUPS_TABLE . " g, ".USER_GROUP_TABLE . " ug
WHERE g.group_single_user <> 1
AND (
(g.group_allow_pm='".AUTH_MOD."' AND g.group_moderator = '" . $userdata['user_id']."') OR
(g.group_allow_pm='".AUTH_ACL."' AND ug.user_id = " . $userdata['user_id'] . " AND ug.group_id = g.group_id ) OR
(g.group_allow_pm='".AUTH_REG."')
)" ;
if( !$g_result = $db->sql_query($sql) ) message_die(GENERAL_ERROR, "Could not select group names!", __LINE__, __FILE__, $sql);
[REPLACE WITH]
$sql_g = "SELECT DISTINCT g.group_id, g.group_name
FROM ".GROUPS_TABLE . " g, ".USER_GROUP_TABLE . " ug
WHERE g.group_single_user <> 1
AND (
(g.group_allow_pm='".AUTH_MOD."' AND g.group_moderator = '" . $userdata['user_id']."') OR
(g.group_allow_pm='".AUTH_ACL."' AND ug.user_id = " . $userdata['user_id'] . " AND ug.group_id = g.group_id ) OR
(g.group_allow_pm='".AUTH_REG."')
)" ;
if( !$g_result = $db->sql_query($sql_g) ) message_die(GENERAL_ERROR, "Could not select group names!", __LINE__, __FILE__, $sql_g);
i have search GROUPS_TABLE but no answer. Plz someone help me
