diff options
| author | Aleksander Machniak <alec@alec.pl> | 2014-09-22 09:31:11 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2014-09-22 09:31:11 +0200 |
| commit | ff767a14ff7675fce7b23b918f41fa92157dd0c0 (patch) | |
| tree | f7a1ed9a6c7d5ec02e967278ff6301019258ead5 /bin/moduserprefs.sh | |
| parent | 13bbcd0f59ef7a4459a6909079f0a558913e808a (diff) | |
| parent | abc00f27c5d923a02c946a634e158dfe9f20974e (diff) | |
Merge branch 'oracle'
Diffstat (limited to 'bin/moduserprefs.sh')
| -rwxr-xr-x | bin/moduserprefs.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/moduserprefs.sh b/bin/moduserprefs.sh index 8a9725fa4..e892b1f4d 100755 --- a/bin/moduserprefs.sh +++ b/bin/moduserprefs.sh @@ -58,10 +58,10 @@ if (!$db->is_connected() || $db->is_error()) $query = '1=1'; if ($args['user']) - $query = 'user_id=' . intval($args['user']); + $query = '`user_id` = ' . intval($args['user']); // iterate over all users -$sql_result = $db->query("SELECT * FROM " . $db->table_name('users') . " WHERE $query"); +$sql_result = $db->query("SELECT * FROM " . $db->table_name('users', true) . " WHERE $query"); while ($sql_result && ($sql_arr = $db->fetch_assoc($sql_result))) { echo "Updating prefs for user " . $sql_arr['user_id'] . "..."; |