private static function connection() { static $conn; if (!$conn) { $conn = SiteDB::connection(); } return $conn; }
protected function createDatabaseTables() { includePackage('db'); $sql = "SELECT 1 FROM mobi_web_page_views"; $conn = SiteDB::connection(); if (!$result = $conn->query($sql, array(), db::IGNORE_ERRORS)) { $sqls = array( "CREATE TABLE mobi_web_page_views ( day date, platform char(31) NOT NULL, module char(31) NOT NULL, viewcount int NOT NULL)", "CREATE TABLE mobi_api_requests ( day date default NULL, platform char(31) default NULL, module char(31) default NULL, viewcount int default NULL, UNIQUE (day,platform,module) )" ); foreach ($sqls as $sql) { $conn->query($sql); } } }
public function sess_gc($max_time=null) { $conn = SiteDB::connection(); $sql = "DELETE FROM sessions WHERE ts < ?"; $result = $conn->query($sql, array(time() - $max_time), db::IGNORE_ERRORS); return $result ? true : false; }
public static function count_iphone_tokens() { $sql = "SELECT count(*) FROM AppleDevice WHERE device_token IS NOT NULL and active = 1"; $conn = SiteDB::connection(); $result = $conn->query($sql); $row = $result->fetch_assoc(); return $row; }
public function sess_open($path, $name) { $this->conn = SiteDB::connection(); return true; }
public static function connection() { if (self::$db === null) { // TODO: get other db config values self::$db = SiteDB::connection(); self::createTables(); } return self::$db; }