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']); } } }