function fs_create_sites_table(&$fsdb) { $sites = fs_sites_table(); $sql = "CREATE TABLE IF NOT EXISTS `{$sites}` (\n\t\t`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY " . fs_comment('Site ID') . ",\n\t\t`type` INT NOT NULL DEFAULT '0' " . fs_comment('Site type') . ",\n\t\t`name` VARCHAR( 100 ) NOT NULL " . fs_comment('Site name') . "\n\t\t)" . fs_comment('FireStats options table') . fs_engine("InnoDB"); $r = $fsdb->query($sql); if ($r === false) { $fsdb->debug(); return false; } return true; }
/** * System information includes: * Unique firestats id * FireStats version * Installation time * PHP version * MySQL version * Server software (apache? IIS? which version?) * Memory limit * Number of sites monitored * Number of sites monitored from each type (how many wordpress blogs, how many drupals etc). */ function fs_get_sysinfo() { require_once dirname(__FILE__) . '/db-common.php'; $s = array(); $s["FIRESTATS_ID"] = fs_get_system_option('firestats_id'); $s["FIRESTATS_VERSION"] = FS_VERSION; $s["INSTALLATION_TIME"] = fs_get_system_option('first_run_time'); $s["PHP_VERSION"] = phpversion(); $s["MYSQL_VERSION"] = fs_mysql_version(); $s["SERVER_SOFTWARE"] = $_SERVER["SERVER_SOFTWARE"]; $s["MEMOEY_LIMIT"] = ini_get('memory_limit'); $sites_table = fs_sites_table(); $sql = "SELECT type,COUNT(type) c from {$sites_table} GROUP BY type"; $fsdb =& fs_get_db_conn(); $res = $fsdb->get_results($sql); if ($res === false) { return $s; } $total = 0; if (count($res) > 0) { foreach ($res as $r) { $s["NUM_SITES_{$r->type}"] = $r->c; $total += $r->c; } } $s["NUM_SITES"] = $total; return $s; }
function fs_get_sites() { $fsdb =& fs_get_db_conn(); $sites = fs_sites_table(); $sql = "SELECT * FROM {$sites}"; return $fsdb->get_results($sql, ARRAY_A); }
function fs_get_tables_list() { $a = array(fs_version_table(), fs_hits_table(), fs_useragents_table(), fs_urls_table(), fs_excluded_ips_table(), fs_bots_table(), fs_options_table(), fs_sites_table(), fs_archive_ranges(), fs_archive_sites(), fs_archive_pages(), fs_archive_referrers(), fs_archive_useragents(), fs_archive_countries(), fs_users_table(), fs_pending_date_table(), fs_url_metadata_table()); return $a; }