示例#1
0
 public static function initDB()
 {
     if (!class_exists('sqliteDB')) {
         main::log('ERROR', 'sqliteDB class not loaded', true);
     }
     if (!is_file(wm_db_file)) {
         if (!fclose(fopen(wm_db_file, 'w'))) {
             main::log('ERROR', sprintf('can\' create db file %s', wm_db_file));
         }
     }
     $db = new sqliteDB(wm_db_file);
     $db_connect = $db->connect();
     if (!($db_connect['status'] == 'OK')) {
         main::log('ERROR', 'database connection failed', true);
     }
     $query = "CREATE TABLE IF NOT EXISTS 'sites' (\n      `id`\tINTEGER PRIMARY KEY AUTOINCREMENT,\n      `hostname`\tTEXT UNIQUE,\n      `template_id`\tINTEGER,\n      `template_data`\tTEXT,\n      `pinged`\tINTEGER DEFAULT '0'\n    );";
     $db_query = $db->query($query);
     if ($db_query['status'] != 'OK') {
         main::log('ERROR', $db_query['message'], true);
     }
     $query = "CREATE TABLE IF NOT EXISTS `templates` (\n      `id`\tINTEGER PRIMARY KEY AUTOINCREMENT,\n      `name`\tTEXT,\n      `path`\tTEXT\n    );";
     $db_query = $db->query($query);
     if ($db_query['status'] != 'OK') {
         main::log('ERROR', $db_query['message'], true);
     }
 }
示例#2
0
 private function hostData($hostname)
 {
     $db = new sqliteDB(wm_db_file);
     $db_connect = $db->connect();
     if (!($db_connect['status'] == 'OK')) {
         return $this->response('ERROR', 'database connection failed');
     }
     $query = "SELECT a.id as site_id, a.hostname, a.template_data,\n    b.id as template_id, b.name as template_name, b.path as template_path\n    FROM sites a\n    LEFT JOIN templates b\n    ON b.id = a.template_id\n    WHERE hostname = '" . $hostname . "'";
     $db_query = $db->query($query);
     if ($db_query['status'] != 'OK') {
         return false;
     }
     $rows = utils::dbObject($db_query['data']);
     if (count($rows) == 0) {
         return false;
     }
     $data = $rows[0];
     if (!($data['template_data'] = json_decode($data['template_data'], true))) {
         return false;
     }
     return ['request' => ['site_id' => $data['site_id'], 'hostname' => $data['hostname']], 'template' => ['id' => $data['template_id'], 'path' => wm_templates_path . $data['template_path'], 'name' => $data['template_name'], 'data' => $data['template_data']]];
 }