$contents['rows'][] = array($lang_module['click_url'], $click_url);
$contents['rows'][] = array($lang_module['add_date'], date("d/m/Y H:i", $row['add_time']));
$contents['rows'][] = array($lang_module['publ_date'], date("d/m/Y H:i", $row['publ_time']));
$contents['rows'][] = array($lang_module['exp_date'], !empty($row['exp_time']) ? date("d/m/Y H:i", $row['exp_time']) : $lang_module['unlimited']);
$contents['rows'][] = array($lang_global['status'], $lang_module['act' . $row['act']]);
$contents['rows'][] = array($lang_module['hits_total'], $row['hits_total']);
$current_month = date("n");
$current_year = date("Y");
$publ_month = date("n", $row['publ_time']);
$publ_year = date("Y", $row['publ_time']);
$bymonth = array();
for ($i = $current_month; $i > 0; --$i) {
if ($i < $publ_month and $current_year == $publ_year) {
break;
}
$bymonth[$i] = nv_monthname($i) . " " . date("Y");
}
$exts = array();
$exts['day'] = $lang_module['exts_day'];
$exts['country'] = $lang_module['exts_country'];
$exts['browse'] = $lang_module['exts_browse'];
$exts['os'] = $lang_module['exts_os'];
$contents['stat'] = array($lang_module['info_stat_caption'], $lang_module['please_select_month'], 'select_month', $bymonth, 'select_ext', $exts, $lang_module['select'], 'submit_stat', "nv_show_stat(" . $id . ",'select_month','select_ext', 'submit_stat','statistic');");
$contents['containerid'] = "statistic";
$contents = call_user_func("nv_info_b_theme", $contents);
$page_title = $lang_module['info_banner_title'];
$my_head = "<script type=\"text/javascript\" src=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.js\"></script>\n";
$my_head .= "<link rel=\"stylesheet\" type=\"text/css\" href=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.css\" />\n";
$my_head .= "<script type=\"text/javascript\">\n";
$my_head .= "Shadowbox.init();\n";
$my_head .= "</script>\n";
$key = "nv_show_list_stat(" . $id . "," . $data_month . ",'" . $ext . "','Unspecified','statistic',0);";
$cts[$key][0] = $lang_module['unknown'];
$cts[$key][1] = $sum > 0 ? round($unknown * 100 / $sum) : 0;
$cts[$key][2] = $unknown;
}
$caption = sprintf($lang_module['info_stat_byos_caption'], nv_monthname($data_month), $current_year);
} else {
$sql = 'SELECT click_time FROM ' . NV_BANNERS_GLOBALTABLE . '_click WHERE bid=' . $id . ' AND click_time>=' . $minday . ' AND click_time<=' . $maxday . ' ORDER BY click_time DESC';
$result = $db->query($sql);
$bd = array();
if (!empty($result)) {
while ($row = $result->fetch()) {
if (!isset($bd[date('d', $row['click_time'])])) {
$bd[date('d', $row['click_time'])] = 0;
}
$bd[date('d', $row['click_time'])] = $bd[date('d', $row['click_time'])] + 1;
}
}
for ($i = $day_max; $i >= $day_min; --$i) {
$c = isset($bd[$i]) ? $bd[$i] : 0;
$key = isset($bd[$i]) ? "nv_show_list_stat(" . $id . "," . $data_month . ",'day','" . $i . "','statistic',0);" : $i;
$cts[$key][0] = str_pad($i, 2, '0', STR_PAD_LEFT) . ' ' . nv_date('F Y', $time);
$cts[$key][1] = $sum > 0 ? round($c * 100 / $sum, 1) : 0;
$cts[$key][2] = $c;
}
$caption = sprintf($lang_module['info_stat_byday_caption'], nv_monthname($data_month), $current_year);
}
$contents = nv_show_stat_theme(array($caption, $sum, $cts));
include NV_ROOTDIR . '/includes/header.php';
echo $contents;
include NV_ROOTDIR . '/includes/footer.php';
$contents['rows'][] = array($lang_module['target'], $targets[$row['target']]);
$contents['rows'][] = array($lang_module['add_date'], date('d/m/Y H:i', $row['add_time']));
$contents['rows'][] = array($lang_module['publ_date'], date('d/m/Y H:i', $row['publ_time']));
$contents['rows'][] = array($lang_module['exp_date'], !empty($row['exp_time']) ? date('d/m/Y H:i', $row['exp_time']) : $lang_module['unlimited']);
$contents['rows'][] = array($lang_global['status'], $lang_module['act' . $row['act']]);
$contents['rows'][] = array($lang_module['hits_total'], $row['hits_total']);
$current_month = date('n');
$current_year = date('Y');
$publ_month = date('n', $row['publ_time']);
$publ_year = date('Y', $row['publ_time']);
$bymonth = array();
for ($i = $current_month; $i > 0; --$i) {
if ($i < $publ_month and $current_year == $publ_year) {
break;
}
$bymonth[$i] = nv_monthname($i) . ' ' . date('Y');
}
$exts = array();
$exts['day'] = $lang_module['exts_day'];
$exts['country'] = $lang_module['exts_country'];
$exts['browse'] = $lang_module['exts_browse'];
$exts['os'] = $lang_module['exts_os'];
$contents['stat'] = array($lang_module['info_stat_caption'], $lang_module['please_select_month'], 'select_month', $bymonth, 'select_ext', $exts, $lang_module['select'], 'submit_stat', "nv_show_stat(" . $id . ",'select_month','select_ext', 'submit_stat','statistic');");
$contents['containerid'] = 'statistic';
$contents = call_user_func('nv_info_b_theme', $contents);
$page_title = $lang_module['info_banner_title'];
$my_head = "<script type=\"text/javascript\" src=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.js\"></script>\n";
$my_head .= "<link rel=\"stylesheet\" type=\"text/css\" href=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.css\" />\n";
$my_footer = "<script type=\"text/javascript\">\n";
$my_footer .= "Shadowbox.init();\n";
$my_footer .= "</script>\n";
case 'browse':
if ($nv_Request->isset_request('val', 'get') and preg_match('/^[a-zA-Z0-9]+$/', $nv_Request->get_string('val', 'get'))) {
$data_ext = 'browse';
$data_val = $nv_Request->get_string('val', 'get');
$where .= ' AND click_browse_name= ?';
$base_url .= '&ext=' . $data_ext . '&val=' . $data_val;
$caption = sprintf($lang_module['show_list_stat4'], '{pattern}', nv_monthname($data_month), $current_year);
}
break;
case 'os':
if ($nv_Request->isset_request('val', 'get') and preg_match('/^[a-zA-Z0-9-\\s]+$/', $nv_Request->get_string('val', 'get'))) {
$data_ext = 'os';
$data_val = $nv_Request->get_string('val', 'get');
$where .= ' AND click_os_name= ?';
$base_url .= '&ext=' . $data_ext . '&val=' . $data_val;
$caption = sprintf($lang_module['show_list_stat5'], '{pattern}', nv_monthname($data_month), $current_year);
}
break;
}
}
$db->sqlreset()->select('COUNT(*)')->from(NV_BANNERS_GLOBALTABLE . '_click')->where($where);
$stmt = $db->prepare($db->sql());
$stmt->bindParam(1, $data_val, PDO::PARAM_STR, strlen($data_val));
$stmt->execute();
$num_items = $stmt->fetchColumn();
if (empty($num_items)) {
die('Wrong URL');
}
$page = $nv_Request->get_int('page', 'get', 1);
$per_page = 50;
$db->where('*')->order('click_time DESC')->limit($per_page)->offset(($page - 1) * $per_page);
