public static function connection()
{
if (!($connection = self::$db)) {
self::$db = new db();
$connection = self::$db;
}
return $connection;
}
private static function connection()
{
static $conn;
if (!$conn) {
$conn = SiteDB::connection();
}
return $conn;
}
public static function connection()
{
if (!$connection = self::$db) {
self::$db = new db($GLOBALS['siteConfig']);
$connection = self::$db;
}
return $connection;
}
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;
}
