View file testim.wmzo.ru/Modules/allStats.php

<?php
$title = 'Полная статистика рейтинга';
require_once ('Sys/head.php');
if (file_exists('Cache/statsAllTop.cache') AND ($time-360) < filemtime('Cache/statsAllTop.cache') AND $cache['AllTopStats'] > 0)
	{
		echo implode('', file ('Cache/statsAllTop.cache'));
	}
else
	{
		ob_start();
		$stats = array();
		$query = $mysqli->query("SELECT * FROM `".$prefix."stats`");
		while($queryy = $query->fetch_assoc())
			{
				$stats[$queryy['name']] = $queryy['value'];
			}
		$plaformsNoMod = $mysqli->query("SELECT `id` FROM `".$prefix."sait` WHERE `status` = '0'")->num_rows;
		$plaformsMod = $mysqli->query("SELECT `id` FROM `".$prefix."sait` WHERE `status` = '1'")->num_rows;
		$plaformsAll = $mysqli->query("SELECT `id` FROM `".$prefix."sait`")->num_rows;
		$usersAll = $mysqli->query("SELECT `id` FROM `".$prefix."users`")->num_rows;
		$newsAll = $mysqli->query("SELECT `id` FROM `".$prefix."news`")->num_rows;
		$catAll = $mysqli->query("SELECT `id` FROM `".$prefix."cat`")->num_rows; 
    $banAll = $mysqli->query("SELECT `id` FROM `".$prefix."sait` WHERE `ban` = '1'")->num_rows;


								$daym = date("d");
								$yesterdayHosts = 0;
								$yesterdayHits = 0;
								$yesterdayIn = 0;
								$yesterdayOut = 0;
								if($daym - 1 > 0)
									{
										$yd = $daym - 1;
										if(strlen($yd) == 1)
											{
												$yd = '0'.$yd;
											}
										$month = date("m");
										$yday1 = $mysqli->query("SELECT * FROM `".$prefix."days` WHERE `month` = '".$month."'");
										if($yday1->num_rows > 0)
											{
												while($row = $yday1->fetch_assoc())
													{
														if(!empty($row[''.$yd.'']))
															{
																$yday = explode('|',$row[''.$yd.'']);
																$yesterdayHosts += $yday[0];
																$yesterdayHits += $yday[1];
																$yesterdayIn += $yday[2];
																$yesterdayOut += $yday[3];
															}
													}
											}
									}
								else
									{
										if(date("m") - 1 > 0)
											{
												$month = date("m") - 1;
												if(strlen($month) == 1)
													{
														$month = '0'.$month;
													}
													$yd = cal_days_in_month(CAL_GREGORIAN, $month, date("Y"));
													$yday1 = $mysqli->query("SELECT * FROM `".$prefix."days` WHERE `month` = '".$month."'");
													if($yday1->num_rows > 0)
														{
															while($row = $yday1->fetch_assoc())
																{
																	if(!empty($row[''.$yd.'']))
																		{
																			$yday = explode('|',$row[''.$yd.'']);
																			$yesterdayHosts += $yday[0];
																			$yesterdayHits += $yday[1];
																			$yesterdayIn += $yday[2];
																			$yesterdayOut += $yday[3];
																		}
																}
														}
											}
									}




										$daym7 = date("d");
								$dayHosts = 0;
								$dayHits = 0;
								if($daym7  > 0)
									{
										$yd7 = $daym7 ;
										if(strlen($yd) == 1)
											{
												$yd7 = '0'.$yd7;
											}
										$month7 = date("m");
										$yday17 = $mysqli->query("SELECT * FROM `".$prefix."days` WHERE `month` = '".$month7."'");
										if($yday17->num_rows > 0)
											{
												while($row = $yday17->fetch_assoc())
													{
														if(!empty($row[''.$yd7.'']))
															{
																$yday7 = explode('|',$row[''.$yd7.'']);
																$dayHosts += $yday7[0];
																$dayHits += $yday7[1];

															}
													}
											}
									}
								else
									{
										if(date("m")  > 0)
											{
												$month7 = date("m");
												if(strlen($month7) == 1)
													{
														$month7 = '0'.$month7;
													}
													$yd7 = cal_days_in_month(CAL_GREGORIAN, $month7, date("Y"));
													$yday17 = $mysqli->query("SELECT * FROM `".$prefix."days` WHERE `month` = '".$month7."'");
													if($yday17->num_rows > 0)
														{
															while($row = $yday17->fetch_assoc())
																{
																	if(!empty($row[''.$yd7.'']))
																		{
																			$yday7 = explode('|',$row[''.$yd7.'']);
																			$dayHosts += $yday7[0];
																			$dayHits += $yday7[1];


																		}
																}
														}
											}
									}



		$online = $mysqli->query("SELECT * FROM `".$prefix."saitsOnline`")->num_rows;
		echo '<div class="block">Общее<br/></div>';
		echo '<div class="l1">';
		echo '&#149; Всего пользователей: <strong>'.$usersAll.'</strong><br/>';
		echo '&#149; Всего площадок: <strong>'.$plaformsAll.'</strong><br/>';
		echo '&#149; Активированных площадок: <strong>'.$plaformsMod.'</strong><br/>';
		echo '&#149; Неактивированных: <strong>'.$plaformsNoMod.'</strong><br/>';
   echo '&#149; Заблокированых: <strong> <a href="http://'.$_SERVER['HTTP_HOST'].'/m/ban">'.$banAll.'</a></strong><br/>';


		echo '&#149; Всего категорий: <strong>'.$catAll.'</strong><br/>';
		echo '&#149; Всего новостей: <strong>'.$newsAll.'</strong><br/>';
        echo '&#149; Сейчас на сайтах сидит: <strong>'.$online.'</strong> человек(а)';
		echo '</div>';
		echo '<div class="block">Сегодня<br/></div>';
		echo '<div class="l1">';
		//echo 'Хостов: <strong>'.$stats['hosts'].'</strong><br/>';
		//echo 'Хитов: <strong>'.$stats['hits'].'</strong><br/>';
		echo '&#149; Хостов: <strong>'.$dayHosts.'</strong><br/>';
		echo '&#149; Хитов: <strong>'.$dayHits.'</strong><br/>';
		echo '&#149; Пришло в топ: <strong>'.$stats['in'].'</strong><br/>';
		echo '&#149; Ушло из топа: <strong>'.$stats['out'].'</strong></div>';
		echo '<div class="block">Вчера<br/></div>';
		echo '<div class="l1">';
		echo '&#149; Хостов: <strong>'.$yesterdayHosts.'</strong><br/>';
		echo '&#149; Хитов: <strong>'.$yesterdayHits.'</strong><br/>';
		echo '&#149; Пришло в топ: <strong>'.$yesterdayIn.'</strong><br/>';
		echo '&#149; Ушло из топа: <strong>'.$yesterdayOut.'</strong>';
		echo '</div>';
		echo '<div class="block">За весь период<br/></div>';
		echo '<div class="l1">';
		echo '&#149; Хостов: <strong>'.$stats['allHosts'].'</strong><br/>';
		echo '&#149; Хитов: <strong>'.$stats['allHits'].'</strong><br/>';
		echo '&#149; Пришло в топ: <strong>'.$stats['allIn'].'</strong><br/>';
		echo '&#149; Ушло из топа: <strong>'.$stats['allOut'].'</strong><br/>';
		echo '</div>';
		$body = ob_get_contents();
		ob_end_clean();
		if($cache['AllTopStats'] > 0)
			{
				wCache($body, 'statsAllTop.cache');
				echo $body;
			}
		else
			{
				echo $body;
			}
	}
?>