diff options
| author | fisharebest <fisharebest@gmail.com> | 2010-06-04 20:02:57 +0000 |
|---|---|---|
| committer | fisharebest <fisharebest@gmail.com> | 2010-06-04 20:02:57 +0000 |
| commit | 670c51ac6ffe4d7f25fba8a5cd7d649ca1a7c455 (patch) | |
| tree | 4327562278ce171431e0c7478684a47303bd0ad5 /includes/functions/functions_db.php | |
| parent | 862b8d712c1f53141374d30f62a884bb5939d2b9 (diff) | |
| download | webtrees-670c51ac6ffe4d7f25fba8a5cd7d649ca1a7c455.tar.gz webtrees-670c51ac6ffe4d7f25fba8a5cd7d649ca1a7c455.tar.bz2 webtrees-670c51ac6ffe4d7f25fba8a5cd7d649ca1a7c455.zip | |
Use "0" and "1" consistently for user-settings, instead of a mixture of 0/1, y/n and yes/no
Diffstat (limited to 'includes/functions/functions_db.php')
| -rw-r--r-- | includes/functions/functions_db.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/includes/functions/functions_db.php b/includes/functions/functions_db.php index 204ebe9184..06e4a372dc 100644 --- a/includes/functions/functions_db.php +++ b/includes/functions/functions_db.php @@ -2245,14 +2245,14 @@ function get_user_count() { function get_admin_user_count() { return WT_DB::prepare("SELECT COUNT(*) FROM `##user_setting` WHERE setting_name=? AND setting_value=?") - ->execute(array('canadmin', 'Y')) + ->execute(array('canadmin', '1')) ->fetchOne(); } function get_non_admin_user_count() { return WT_DB::prepare("SELECT COUNT(*) FROM `##user_setting` WHERE setting_name=? AND setting_value<>?") - ->execute(array('canadmin', 'Y')) + ->execute(array('canadmin', '1')) ->fetchOne(); } @@ -2265,7 +2265,7 @@ function get_logged_in_users() { " JOIN `##user_setting` us USING (user_id)". " WHERE setting_name=? AND setting_value=?" ) - ->execute(array('loggedin', 'Y')) + ->execute(array('loggedin', '1')) ->fetchAssoc(); } @@ -2280,7 +2280,7 @@ function get_idle_users($time) { " WHERE us1.setting_name=? AND us1.setting_value=? AND us2.setting_name=?". " AND CAST(us2.setting_value AS UNSIGNED) BETWEEN 1 AND ?" ) - ->execute(array('loggedin', 'Y', 'sessiontime', $time)) + ->execute(array('loggedin', '1', 'sessiontime', $time)) ->fetchAssoc(); } |
