summaryrefslogtreecommitdiff
path: root/includes/functions/functions_db.php
diff options
context:
space:
mode:
authorfisharebest <fisharebest@gmail.com>2010-06-04 20:02:57 +0000
committerfisharebest <fisharebest@gmail.com>2010-06-04 20:02:57 +0000
commit670c51ac6ffe4d7f25fba8a5cd7d649ca1a7c455 (patch)
tree4327562278ce171431e0c7478684a47303bd0ad5 /includes/functions/functions_db.php
parent862b8d712c1f53141374d30f62a884bb5939d2b9 (diff)
downloadwebtrees-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.php8
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();
}