Просмотр файла stats.php

Конкурс дизайнеров на 15000 рублей
Милый пушистый сайт !!!!
Размер файла: 2.92Kb 
  1. <?php 
  2.  
  3. include "header/config.inc.php";
  4. include "header/function.inc.php";
  5. include "header/header.inc.php";
  6. include "header/connect.inc.php";
  7. include "header/click-club.class.php";
  8. include "header/enter.inc.php";
  9. include "header/ban.php";
  10.  
  11. @mysql_query("update `".prefix."users` set `mesto`='В статистике по кликам' where `id` = '".$_USER['id']."'");
  12.  
  13. $q = ''; $q2=''; $q3='';
  14. $z = 'stats.php'.$_zapros;
  15. $fs_from = 0; 
  16.  
  17. if(isset($_GET['year']) && ctype_digit($_GET['year']) && $_GET['year']>2000 && $_GET['year']<2015)
  18. $q = " AND YEAR(`ts`)=".$_GET['year']." ";
  19. else
  20. {
  21. 	echo '<div class="header_rek"><b>Общая статистика</b></div>';
  22. 	if(!isset($_GET['today'])) 	echo  '<a href="index.php?mode=r_day">'."Лучшие сегодня</a><br/>";
  23. 	echo "Выберите год: ";
  24. 	$fs_years = mysql_query("SELECT DISTINCT(YEAR(`ts`)) as 'y' FROM `cclub_stats` ORDER BY `ts`");
  25. 		while( $fs_year = mysql_fetch_assoc($fs_years) ) 
  26. 			echo '<a href="'.$z.'year='.$fs_year['y'].'">'.$fs_year['y'].'</a> ';
  27. }
  28.  
  29. if(isset($_GET['month']) && ctype_digit($_GET['month']) && $_GET['month']>0 && $_GET['month']<13 && $q!="")
  30. {	$q .= " AND MONTH(`ts`)=".$_GET['month']." ";	$q2=' ';	}
  31. elseif($q!="")
  32. {
  33. 	echo "Статистика за <b>".$_GET['year']." год</b> <br/> Выберите месяц: ";
  34. 	$fs_years = mysql_query("SELECT DISTINCT(MONTH(`ts`)) as 'y' FROM `cclub_stats` WHERE YEAR(`ts`)=".mysql_escape_string($_GET['year'])."  ORDER BY `ts`");
  35. 		while( $fs_year = mysql_fetch_assoc($fs_years) ) 
  36. 			echo '<a href="'.$z.'year='.$_GET['year'].'&amp;month='.$fs_year['y'].'">'.$fs_year['y'].'</a> ';
  37. }
  38.  
  39. if(isset($_GET['day']) && ctype_digit($_GET['day']) && $_GET['day']>0 && $_GET['day']<32 && $q!="" && $q2!="")
  40. 	{ $q .= " AND DAYOFMONTH(`ts`)=".$_GET['day']." "; $q3 = " ";}
  41. elseif($q2!="")
  42. {
  43. 	echo "Статистика за <b>".$_GET['month'].".".$_GET['year']."</b> <br/> Выберите день: ";
  44. 	$fs_years = mysql_query("SELECT DISTINCT(DAYOFMONTH(`ts`)) as 'y' FROM `cclub_stats` WHERE YEAR(`ts`)=".mysql_escape_string($_GET['year']) ." AND MONTH(`ts`)=".mysql_escape_string($_GET['month'])."  ORDER BY `ts`");
  45. 		while( $fs_year = mysql_fetch_assoc($fs_years) ) 
  46. 			echo '<a href="'.$z.'year='.$_GET['year'].'&amp;month='.$_GET['month'].'&amp;day='.$fs_year['y'].'">'.$fs_year['y'].'</a> ';
  47. }
  48.  
  49. if($q3!="") echo "Статистика за <b>".$_GET['day'].".".$_GET['month'].".".$_GET['year']."</b> ";
  50.  
  51. if(isset($_GET['today'])) 
  52.  
  53. $fs_query = mysql_query("SELECT *,COUNT(`cn`) AS cn FROM `".prefix."stats` WHERE `ts`=CURDATE() GROUP BY `who` ORDER BY cn DESC LIMIT 50");
  54. else
  55. $fs_query = mysql_query("SELECT *,SUM(`cn`) AS cn FROM `".prefix."stats` WHERE 1 ".$q.
  56. " GROUP BY `who` ORDER BY cn DESC LIMIT 30"); 
  57.  
  58. echo '<br/><div class="contur_rek"><b>Top '.mysql_num_rows($fs_query).':</b></div>';
  59.  
  60. echo mysql_error();
  61. $fs_i = 0;
  62. while( $fs_user = mysql_fetch_assoc($fs_query) )
  63. 	{	$fs_i++;	echo '<b>'.$fs_i.'</b>. '.$fs_user['who'].'  <b>['.$fs_user['cn'].']</b><br/>';		}
  64.  
  65. include "header/end.inc.php";
  66. ?>