<?php
header('Content-type: text/html; charset=utf-8');
require_once dirname(__FILE__) . '/init.php';
require_once FS_ABS_PATH . '/php/html-utils.php';
require_once FS_ABS_PATH . '/php/db-sql.php';
$site_id = isset($_GET['site_id']) ? $_GET['site_id'] : null;
$views = '';
$visits = '';
if (isset($site_id)) {
$site = fs_get_site($site_id);
$baseline = fs_get_site_baseline_values($site_id);
$views = $baseline->views;
$visits = $baseline->visits;
}
?>
<div class='<?php
echo fs_lang_dir();
?>
'>
<h3><?php
isset($site_id) ? fs_e('Edit site') : fs_e('Create a new site');
?>
</h3>
<table>
<tr>
<td><label for='new_username'><?php
fs_e('ID');
?>
</label></td>
<td>
function fs_transfer_site_hits($old_sid, $new_sid)
{
$fsdb =& fs_get_db_conn();
if ($fsdb->query("START TRANSACTION") === false) {
return fs_db_error();
}
$archive_sites = fs_archive_sites();
$base_old = fs_get_site_baseline_values($old_sid);
$base_new = fs_get_site_baseline_values($new_sid);
$visits = $base_new->visits + $base_old->visits;
$views = $base_new->views + $base_old->views;
$sql = "DELETE FROM `{$archive_sites}` WHERE `range_id` = '1' AND `site_id` = '{$old_sid}'";
$r = $fsdb->query($sql);
if ($r === false) {
$fsdb->query("ROLLBACK");
return false;
}
$sql = "REPLACE INTO `{$archive_sites}` (`range_id`,`site_id`,`views`,`visits`) VALUES(1,{$new_sid},{$views},{$visits})";
$r = $fsdb->query($sql);
if ($r === false) {
$fsdb->query("ROLLBACK");
return false;
}
$archives = array();
$archives[] = fs_hits_table();
$archives[] = fs_archive_sites();
$archives[] = fs_archive_pages();
$archives[] = fs_archive_referrers();
$archives[] = fs_archive_useragents();
$archives[] = fs_archive_countries();
foreach ($archives as $archive) {
$sql = "UPDATE `{$archive}` SET `site_id` = '{$new_sid}' WHERE `site_id` = {$old_sid}";
$r = $fsdb->query($sql);
if ($r === false) {
$fsdb->query("ROLLBACK");
return false;
}
}
$fsdb->query("COMMIT");
return true;
}
