$sql = 'SELECT option_value FROM _prefix_options WHERE option_name = :OPT_NAME'; $db = _db(); $db->prepare($sql); $db->bindValue(':OPT_NAME', $name, PARAM_STR); $db->execute(); $values = ''; if ($value = $db->fetch()) { $value = $value['option_value']; } $_values[$name] = $value; } else { $value = $_values[$name]; } return $value; } $_date_format = _db_option_value('date_format'); function _date_format() { global $_date_format; return $_date_format; } function _checkLogin() { if (!empty($_SESSION['_user_id'])) { $userId = $_SESSION['_user_id']; $db = _db(); $sql = 'SELECT * FROM _prefix_users WHERE user_id = :ID AND usergroup_id <= :REQUIRE_GROUP AND is_enabled = 1'; $db->prepare($sql); $db->bindValue(':ID', $userId, PARAM_INT); $db->bindValue(':REQUIRE_GROUP', REQUIRE_GROUP, PARAM_INT); $db->execute();
public static function online() { $db = _db(); $sql = 'SELECT COUNT(*) as user_online FROM session'; $db->query($sql); $db->execute(); $useronline = $db->fetch(); $useronline = $useronline['user_online']; $min = _db_option_value('default_visitor_online'); if ($min > $useronline) { $useronline = $min; } return $useronline; }
function welcome_admin_main() { $data['name'] = _db_option_value('name'); return $data; }