View file testim.wmzo.ru/ads_stat.php

<?php
$title = 'Статистика рекламы';
include("Sys/connect.php");
include("Sys/core.php");
include("Sys/function.php");
require_once ('Sys/head.php');
$code = $mysqli->real_escape_string($_GET['code']);
$row = $mysqli->query("SELECT *, DATE_FORMAT(date,'%d.%m.%Y %H:%i') AS `date1` FROM `ads` WHERE `hash` = '$code'")->fetch_assoc();
if(empty($row['id'])) {
	echo '<div class="l1">Такого сайта нет</div>';
	require_once ('Sys/foot.php');
	exit();
}

echo '<div class="l1">
Площадка: <a href="'.htmlspecialchars($row['url']).'">'.htmlspecialchars($row['url']).'</a><br />';
if($row['type'] == 1) {
	$cl = ($row['total'] < 1) ? 0 : $row['total'];
	echo 'Оставшееся кол-во кликов: '.$cl.'</div>';
}
else {
	echo 'Реклама оплачена до: '.$row['date1'].'</div>';
}

$mstat = $mysqli->query("SELECT COUNT(`id`) AS `cnt`, DATE_FORMAT(date,'%d.%m.%Y') AS `date1` FROM `ads_logs` WHERE `user_id` = '".$row['id']."' GROUP BY `date1`");
echo '<div class="l1"><center>Сводная статистика</center><br />
<table><tr><td>Дата</td><td>Переходов всего</td><td>Из них мобильных</td></tr>';
while($row2 = $mstat->fetch_assoc()) {
	$db_date = date('Y-m-d', strtotime($row2['date1']));
	$m = $mysqli->query("SELECT COUNT(`id`) AS `cnt` FROM `ads_logs` WHERE `user_id` = '".$row['id']."' AND DATE(`date`) = '$db_date' AND `mob` = '1'")->fetch_assoc();
	echo '<tr><td>'.$row2['date1'].'</td><td>'.$row2['cnt'].'</td><td>'.$m['cnt'].'</td></tr>';
}
echo '</table></div>';
require_once ('Sys/foot.php');
?>