コード例 #1
0
 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']);
         }
     }
 }