zapytanie wygląda tak
$sql = "SELECT u.user_id FROM (" . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u) WHERE ug.group_id = aa.group_id AND u.user_id = ug.user_id AND ug.user_pending = 0 AND u.user_level NOT IN (" . MOD . ", " . ADMIN . ") GROUP BY u.user_id HAVING SUM(aa.auth_mod) > 0";
a błąd tak
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 (54, , 1)
Line : 367
File : admin_ug_auth.php
niewiem co jest nietal;/
jeszcze tu mam fragment kodu z zapytaniem
$sql_field .= ( ( $sql_field != '' ) ? ', ' : '' ) . 'auth_mod'; $sql_value .= ( ( $sql_value != '' ) ? ', ' : '' ) . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]); $sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (forum_id, group_id, $sql_field) VALUES ($forum_id, $group_id, $sql_value)";