diff options
| author | Aleksander Machniak <alec@alec.pl> | 2014-09-12 14:37:51 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2014-09-12 14:37:51 +0200 |
| commit | 34a0902089a410d1f7dda78d1f8b0771333c09df (patch) | |
| tree | 729c7a994d64b7dbf9f78656d95b34846cae58ba /bin/moduserprefs.sh | |
| parent | 8cc65d1f5fae71e2ee07748e82ab274d8d45304b (diff) | |
Use consistent column/table quoting in sql queries
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'] . "..."; |