PHP db::get方法代码示例

function sitemap_forum_get_threads($forum_fid)
{
    if (!($db = db::get())) {
        return false;
    }
    // If there are any problems with the function arguments we bail out.
    if (!is_numeric($forum_fid)) {
        return false;
    }
    // Constant for Guest access.
    $user_perm_guest_access = USER_PERM_GUEST_ACCESS;
    // Get the table prefix from the forum fid
    if (!($table_prefix = forum_get_table_prefix($forum_fid))) {
        return false;
    }
    $sql = "SELECT THREAD.TID, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED ";
    $sql .= "FROM `{$table_prefix}THREAD` THREAD ";
    $sql .= "INNER JOIN `{$table_prefix}FOLDER` FOLDER ";
    $sql .= "ON (FOLDER.FID = THREAD.FID) ";
    $sql .= "WHERE FOLDER.PERM & {$user_perm_guest_access} > 0 ";
    $sql .= "ORDER BY THREAD.TID";
    if (!($result = $db->query($sql))) {
        return false;
    }
    if ($result->num_rows == 0) {
        return false;
    }
    return $result;
}

function user_get_relationship($uid, $peer_uid)
{
    if (!($db = db::get())) {
        return 0;
    }
    if (!is_numeric($uid)) {
        return 0;
    }
    if (!is_numeric($peer_uid)) {
        return 0;
    }
    if (!($table_prefix = get_table_prefix())) {
        return 0;
    }
    $sql = "SELECT RELATIONSHIP FROM `{$table_prefix}USER_PEER` ";
    $sql .= "WHERE UID = '{$uid}' AND PEER_UID = '{$peer_uid}'";
    if (!($result = $db->query($sql))) {
        return 0;
    }
    if ($result->num_rows == 0) {
        return 0;
    }
    list($peer_relationship) = $result->fetch_row();
    return $peer_relationship;
}

 public static function saveSession()
 {
     $engine = EngineAPI::singleton();
     $localvars = localvars::getInstance();
     $db = db::get($localvars->get('dbConnectionName'));
     $sql = "INSERT INTO `session`(username,sessionPages,ipAddr) VALUES(?,?,?)";
     $validate = new validate();
     $username = session::get('username');
     $pages = session::get('loggedPages');
     $pages = dbSanitize(implode(',', $pages));
     $ip = $_SERVER['REMOTE_ADDR'];
     $sqlArray = array($username, $pages, $ip);
     $db->beginTransaction();
     try {
         $sqlResult = $db->query($sql, $sqlArray);
         if ($sqlResult->error()) {
             throw new Exception("ERROR SQL" . $sqlResult->errorMsg());
         }
         $db->commit();
     } catch (Exception $e) {
         $db->rollback();
         $localvars->set('feedback', $e->getMessage());
         errorHandle::errorMsg($e->getMessage());
     }
 }

 public function getRecords($id = null)
 {
     try {
         // call engine
         $engine = EngineAPI::singleton();
         $localvars = localvars::getInstance();
         $db = db::get($localvars->get('dbConnectionName'));
         $sql = "SELECT * FROM `timeTracking`";
         $validate = new validate();
         // test to see if Id is present and valid
         if (!isnull($id) && $validate->integer($id)) {
             $sql .= sprintf('WHERE timeID = %s LIMIT 1', $id);
         }
         // if no valid id throw an exception
         if (!$validate->integer($id) && !isnull($id)) {
             throw new Exception("An invalid ID was given!");
         }
         // get the results of the query
         $sqlResult = $db->query($sql);
         // if return no results
         // else return the data
         if ($sqlResult->rowCount() < 1) {
             return "There has been no time tracking done up to this point.";
         } else {
             $data = array();
             while ($row = $sqlResult->fetch()) {
                 $data[] = $row;
             }
             return $data;
         }
     } catch (Exception $e) {
         errorHandle::errorMsg($e->getMessage());
     }
 }

function word_filter_get($uid, &$word_filter_array)
{
    if (!($db = db::get())) {
        return false;
    }
    if (!is_numeric($uid)) {
        return false;
    }
    if (!is_array($word_filter_array)) {
        $word_filter_array = array();
    }
    if (!($table_prefix = get_table_prefix())) {
        return false;
    }
    $sql = "SELECT FID, MATCH_TEXT, REPLACE_TEXT, FILTER_TYPE ";
    $sql .= "FROM `{$table_prefix}WORD_FILTER` ";
    $sql .= "WHERE UID = '{$uid}' AND FILTER_ENABLED = 1 ";
    $sql .= "ORDER BY FID ";
    if ($uid != 0) {
        $sql .= "LIMIT 0, 20";
    }
    if (!($result = $db->query($sql))) {
        return false;
    }
    if ($result->num_rows == 0) {
        return false;
    }
    while ($word_filter_data = $result->fetch_assoc()) {
        $word_filter_array[] = $word_filter_data;
    }
    return true;
}

 public static function init()
 {
     session::$db = db::get(true);
     if (!ini_get('session.gc_probability')) {
         @ini_set('session.gc_probability', 1);
     }
     if (!ini_get('session.gc_divisor')) {
         @ini_set('session.gc_divisor', 100);
     }
     session_set_save_handler(array('session', 'open'), array('session', 'close'), array('session', 'read'), array('session', 'write'), array('session', 'destroy'), array('session', 'gc'));
     $hash = null;
     session_name('sess_hash');
     if (!html_get_cookie('sess_hash')) {
         if ($hash = session::restore()) {
             session_id($hash);
         } else {
             html_set_cookie('user_logon', '', time() - YEAR_IN_SECONDS);
             html_set_cookie('user_token', '', time() - YEAR_IN_SECONDS);
         }
     }
     session_start();
     if (!isset($_SESSION['UID'])) {
         $_SESSION['UID'] = 0;
     }
     if (!is_null($hash)) {
         session::refresh_csrf_token();
     }
 }

 public static function get_version()
 {
     $db = db::get();
     $sql = "SELECT VERSION() AS version";
     if (!($result = $db->query($sql))) {
         return false;
     }
     if (!($version_data = $result->fetch_assoc())) {
         $sql = "SHOW VARIABLES LIKE 'version'";
         if (!($result = $db->query($sql))) {
             return false;
         }
         $version_data = $result->fetch_assoc();
     }
     $version_array = explode('.', $version_data['version']);
     if (!isset($version_array[0])) {
         $version_array[0] = 3;
     }
     if (!isset($version_array[1])) {
         $version_array[1] = 21;
     }
     if (!isset($version_array[2])) {
         $version_array[2] = 0;
     }
     return sprintf('%d.%d.%d', $version_array[0], $version_array[1], intval($version_array[2]));
 }

function mods_list_forum_leaders()
{
    if (!($db = db::get())) {
        return false;
    }
    $mod_list_array = array();
    if (!($table_prefix = get_table_prefix())) {
        return false;
    }
    if (!($forum_fid = get_forum_fid())) {
        return false;
    }
    $user_perm_admin_tools = USER_PERM_ADMIN_TOOLS;
    $sql = "SELECT USERS.UID, USERS.LOGON, COALESCE(USER_PEER.PEER_NICKNAME, USERS.NICKNAME) AS NICKNAME ";
    $sql .= "FROM ((SELECT DISTINCT USER.UID, USER.LOGON, USER.NICKNAME FROM USER INNER JOIN GROUP_USERS ";
    $sql .= "ON (GROUP_USERS.UID = USER.UID) INNER JOIN GROUP_PERMS ON (GROUP_PERMS.GID = GROUP_USERS.GID) ";
    $sql .= "INNER JOIN GROUPS ON (GROUPS.GID = GROUP_PERMS.GID) WHERE GROUPS.FORUM IN (0, {$forum_fid}) ";
    $sql .= "AND GROUP_PERMS.FID IN (0) AND GROUP_PERMS.PERM & {$user_perm_admin_tools}) UNION ALL ";
    $sql .= "(SELECT DISTINCT USER.UID, USER.LOGON, USER.NICKNAME FROM USER INNER JOIN USER_PERM ";
    $sql .= "ON (USER_PERM.UID = USER.UID) WHERE USER_PERM.FORUM IN (0, {$forum_fid}) AND USER_PERM.FID IN (0) ";
    $sql .= "AND USER_PERM.PERM & {$user_perm_admin_tools} > 0)) AS USERS LEFT JOIN `{$table_prefix}USER_PEER` USER_PEER ";
    $sql .= "ON (USER_PEER.PEER_UID = USERS.UID AND USER_PEER.UID = {$_SESSION['UID']})";
    if (!($result = $db->query($sql))) {
        return false;
    }
    if ($result->num_rows == 0) {
        return false;
    }
    while (($mod_list_data = $result->fetch_assoc()) !== null) {
        $mod_list_array[$mod_list_data['UID']] = $mod_list_data;
    }
    return $mod_list_array;
}

	protected function afterInit() {
		parent::afterInit();
		$this->session = session::getInstance(array(
			'nameSpace'=>$this->cfg->sessionNameSpace
		));
		$this->table = db::get('table', $this->cfg->table);
		$this->autoLogin();
	}

 function replace()
 {
     $page_id = params::get('page_id');
     db::table('pages');
     db::limit(1);
     db::where('page_id', $page_id);
     $page_folder = db::get('page_folder');
     headers::url($page_folder);
     //self::loadPage();
 }

 static function getNameByID($db = NULL, $fach_id)
 {
     require_once '/../db/db.class.php';
     if ($db == NULL) {
         $db = new db();
     }
     $result = $db->get('fach_name', 'fach', 'fach_id=' . $fach_id);
     while ($row = mysql_fetch_assoc($result)) {
         return $row['fach_name'];
     }
 }

function ajax_chat_online_user_count()
{
    if (!($db = db::get())) {
        return 0;
    }
    $config = ajax_chat_get_config();
    $ajax_chat_online = $db->escape($config['dbTableNames']['online']);
    $sql = "SELECT COUNT(*) FROM `{$ajax_chat_online}`";
    $result = $db->query($sql);
    list($ajax_chat_online_users) = $result->fetch_row();
    return $ajax_chat_online_users;
}

 function start()
 {
     db::connect();
     if (!router::get(1)) {
         return true;
     }
     self::$map = array('mode' => router::get(0), 'app' => router::get(1), 'module' => 'main', 'action' => router::get(2), 'id' => router::get(4));
     s::set('SYS_PATH', 'http://' . SERVER . SYS_DIR);
     define('APP', APPS . self::get('app') . '/');
     s::set('APP', APP);
     define('MODULE', APP . self::get('module') . '/');
     s::set('MODULE', MODULE);
     if (stristr(self::$map['mode'], 'admin')) {
         self::$map['mode'] = 'admin';
     } else {
         self::$map['mode'] = 'web';
     }
     if (self::$map['mode'] == 'admin') {
         if (defined('ADMIN_USER_SITE_ID')) {
             admin::observer();
             define('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
             s::set('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
             db::table('admin_sites');
             db::where('site_id', ADMIN_USER_SITE_ID);
             db::limit(1);
             $row = db::select();
             define('ADMIN_SITE', db::get('site_domain'));
             s::set('ADMIN_SITE', ADMIN_SITE);
         }
     } else {
         web::getSite();
         $lang = lang::gets(LANG_INDEX, SITE_ID);
         /*
         	Authentification webUser
         */
         web::observer();
     }
     /*
     	Set params
     */
     params::send();
     if (router::get(0) == 'feed' || router::get(0) == 'rss') {
         self::$map['module'] = 'feed';
     }
     if (self::$map['mode'] == 'admin') {
         load::module(self::get('app'), self::get('module'), self::get('action'));
     } else {
         load::handler(self::get('app'), self::get('module'), self::get('action'));
     }
 }

 static function user()
 {
     if (!self::$optionsset) {
         self::$optionsset = true;
         $options = db::get()->assoc('SELECT name, value FROM options WHERE user_id = :user_id', array('user_id' => self::$user->id));
         foreach ($options as $k => $v) {
             $k = strtolower($k);
             self::$user->{$k} = $v;
         }
     }
     if (self::$user->nickname == '') {
         self::$user->nickname = self::$user->username;
     }
     return self::$user;
 }

 function auth($username, $password)
 {
     $db = new db("users");
     $query = $db->get($username);
     if (is_array($query)) {
         if (sha1($password) == $query['password']) {
             $this->session($query);
             return true;
         } else {
             return false;
         }
     } else {
         return false;
     }
 }