Experience Battlefield 3 like never before!
https://forums.veniceunleashed.net/
https://forums.veniceunleashed.net/viewtopic.php?f=22&t=2718
Lapin wrote:(En C# à mon avis)
snakeyes76 wrote:Lapin t'es développeur ?
Code: Select all
$sql = 'SELECT a.user_id, a.user_colour, a.username, a.group_id, a.ums_kick_owner, a.ums_kick,
b.group_name, b.group_id, b.group_colour,
c.user_id AS owner_user_id, c.user_colour AS owner_user_colour, c.username AS owner_username, c.group_id AS owner_group_id,
d.group_name AS owner_group_name, d.group_id AS owner_group_id, d.group_colour AS owner_group_colour
FROM ' . USERS_TABLE . ' a
INNER JOIN ' . GROUPS_TABLE . ' b
INNER JOIN ' . USERS_TABLE . ' c
INNER JOIN ' . GROUPS_TABLE . ' d
ON (b.group_id = a.group_id
AND d.group_id = c.group_id
AND ' . ($kick_edit ? '(c.user_id = a.ums_kick_owner )' : '(c.user_id = a.ums_kick_owner' .
($uname_search || $kick_set ? ' OR a.ums_kick_owner = 0' : '') . ')') . ') ' . $sql_where;
$result = $db->sql_query_limit($sql, 1);
$user_search = $db->sql_fetchrow($result);
$db->sql_freeresult($result);