protected function _analytics_store()
{
global $bio, $core;
list($h, $d, $m, $y) = explode(' ', gmdate('G j n Y', _localtime()));
$sql = 'SELECT *
FROM _stats
WHERE stat_page = ?
AND stat_hour = ?
AND stat_day = ?
AND stat_month = ?
AND stat_year = ?';
if ($stat = sql_fieldrow(sql_filter($sql, $bio->page, $h, $d, $m, $y))) {
$field_stat = $bio->v('auth_member') ? 'member' : 'guest';
$sql = 'UPDATE _stats SET stat_' . $field_stat . ' = stat_' . $field_stat . ' + 1
WHERE stat_id = ?';
$sql = sql_filter($sql, $stat->stat_id);
sql_run($sql);
} else {
if ($bio->v('auth_member')) {
$sql_insert = array();
} else {
$sql_insert = array();
}
sql_put('_stats', $sql_insert);
}
return;
}
$conn = $db->connect($dbname, $dbhost, $dbuser, $dbpasswd);
$tpl_file = "db";
if (!($backupdir = $pdb->GetOne("SELECT valued FROM {$tb_prefix}settings WHERE variable='backup_dir'"))) {
$backupdir = pb_radom(6);
$db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) values ('backup_dir', '{$backupdir}')");
}
require LIB_PATH . "func.db.php";
require LIB_PATH . "func.sql.php";
if (isset($_POST['do'])) {
$do = trim($_POST['do']);
if (!file_exists(DATA_PATH . "backup_" . $backupdir)) {
pb_create_folder(DATA_PATH . "backup_" . $backupdir);
}
if ($do == "query" && !empty($_POST['sql_content'])) {
if ($admin_runquery) {
$result = sql_run($_POST['sql_content']);
if ($result) {
flash("success");
} else {
flash();
}
} else {
flash("admin_runquery_forbidden");
}
}
if ($do == "backup") {
$filename = date('ymd') . '_' . pb_radom(6);
$db->query('SET SQL_QUOTE_SHOW_CREATE=0', 'SILENT');
$time = gmdate("M d Y H:i:s", mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y")));
$tables = arraykeys2(fetchtablelist($tb_prefix), 'Name');
if (mysql_get_server_info() > '4.1') {
$must_sql_data = file_get_contents($schema_path . "mysql.data.sql");
$r = sql_run($must_sql_data);
if (!$r) {
Errors::showError(mysql_error(), 'db');
exit;
}
$structure_sql_data1 = file_get_contents($schema_common_path . "mysql.data.area.sql");
$r = sql_run($structure_sql_data1);
$structure_sql_data2 = file_get_contents($schema_common_path . "mysql.data.industry.sql");
$r = sql_run($structure_sql_data2);
@touch(PHPB2B_ROOT . './data/install.lock');
if (!empty($testdata)) {
$source = "data/attachment/sample";
$dest = "../attachment/sample";
$sqls = file_get_contents($schema_path . "mysql.sample.sql");
sql_run($sqls);
dir_copy($source, $dest, 1);
} else {
//basic datas
$source = "data/attachment/sample/banner";
$dest = "../attachment/sample/banner";
dir_copy($source, $dest);
}
//language:~
$show_languages = showLanguages(true);
$languages = serialize($show_languages);
$db->query(sprintf("REPLACE INTO {$tb_prefix}settings (variable, valued) VALUES ('languages', '%s')", $languages));
//:~
$db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) VALUES ('install_dateline', '" . $time_stamp . "')");
$db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) VALUES ('site_name', '{$sitename}')");
$db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) VALUES ('site_title', '" . htmlspecialchars($sitetitle) . " - Powered By " . $software_name . "')");
