function __construct()
{
parent::__construct();
$table = 'lib_statistics';
$sqlite = new sqlite($table);
$this->sqlite = $sqlite;
$data = $sqlite->select();
if (isset($_SERVER['HTTP_USER_AGENT'])) {
$this->user_agent = $_SERVER['HTTP_USER_AGENT'];
$this->language = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
} else {
$this->user_agent = 'UPDATING';
$this->language = 'UPDATING';
}
if (!$data) {
$stmt = "CREATE TABLE IF NOT EXISTS {$table} (\n\t\t\t\t\t\tid INTEGER NOT NULL,\n\t\t\t\t\t\tip TEXT(15) NOT NULL,\n\t\t\t\t\t\tuser_agent TEXT(100) NOT NULL,\n\t\t\t\t\t\tlanguage TEXT(100) NOT NULL,\n\t\t\t\t\t\tfirst_access TEXT(19) NOT NULL,\n\t\t\t\t\t\tlast_access TEXT(19) NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY ('id')\n\t\t\t\t\t);";
$sqlite->exec($stmt);
}
$data = $sqlite->selectWhere('ip = "' . $_SERVER['REMOTE_ADDR'] . '"');
if (!$data) {
$this->insert();
} else {
if ($data['user_agent'] != $this->user_agent) {
$this->insert();
} else {
$this->update($data['id']);
}
}
}
public static function delete()
{
$input = json_decode(file_get_contents('php://input'));
$statement = 'DELETE FROM tasks WHERE taskId = :taskId';
$parameters = array(':taskId' => $input->taskId);
$sqlite = new sqlite();
return $sqlite->exec($statement, $parameters);
}
public static function convert_table($source, $target)
{
$sqlite = new sqlite();
// Get source fields
$pragma = $sqlite->query("PRAGMA table_info({$source})");
foreach ($pragma as $k => $v) {
$fieldcsv .= $v->name . ',';
}
$fieldcsv = rtrim($fieldcsv, ",");
// Copy records
$sql = "INSERT INTO {$target} ({$fieldcsv}) SELECT {$fieldcsv} FROM {$source}";
$sqlite->exec($sql);
echo "{$sql} \r\n";
echo "Table {$source} converted to {$target}.\r\n";
}
public static function create_table()
{
$sqlite = new sqlite();
return $sqlite->exec("\n create table tokens (\n tokenid INTEGER PRIMARY KEY,\n username varchar(255) NULL DEFAULT '',\n token varchar(255) NULL DEFAULT '',\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL\n )\n ");
}
public static function create_table()
{
$sqlite = new sqlite();
return $sqlite->exec("\n create table users (\n UserId INTEGER PRIMARY KEY,\n Username varchar(255) NULL DEFAULT '',\n Password varchar(255) NULL DEFAULT ''\n )\n ");
}
