-
Notifications
You must be signed in to change notification settings - Fork 1
/
stats.php
160 lines (90 loc) · 3.01 KB
/
stats.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
<?
require('config.php');
//require($engine_path."cls/auth/session.php");
$q=select("select avg(DATE_FORMAT(DATE_SUB(FROM_DAYS(TO_DAYS(NOW()) -
TO_DAYS(BirthDate)), INTERVAL 1 MONTH ), '%y')) Age
from ut_users
where BirthDate <> '0000-00-00'");
print "Ñðåäíèé âîçðàñò: ".$q[0]."<br>";
$q=select("select count(*) from ut_users");
print "×èñëî èãðîêîâ: ".$q[0]."<br>";
print "<h2>Ðåãèñòðàöèè</h2>";
$d=date("d",mktime());
$m=date("m",mktime());
$prev=mktime();
//$prev=mktime(0,0,0,$m,$d,date("Y",mktime()));
//print date("d.m.Y H:i",1143101959);
for($i=$d;$i>$d-6;$i--)
{
if($d==0) {$d=31;$m--;}
$day=mktime(0,0,0,$m,$i,date("Y",mktime()));
print date("d.m.Y",$day)."<br>";
$r=select("select count(*) from ut_users where Date<$prev and Date>=$day");
$r3=select("select avg(Year(BirthDate)) from ut_users u where Year(BirthDate)>1940 and Year(BirthDate)<1997 and u.Date<$prev and u.Date>$day");
print "Çàðåãèñòðèðîâàëèñü: <b>$r[0]</b> (ñðåäíèé âîçðàñò <b>".round(date("Y",mktime())-$r3[0])."</b>)<br>";
print "Â ïðîöåíòàõ: ".round(100*$r1[0]/$r[0],0)."%<br><br>";
$prev=$day;
}
exit;
$type="office/organizer";
$act="panel";
require($site_path."up.php");
$form_title="Äåðåâî ñàéòà";
function printmenu($r)
{
$r[Url]=set_params($r[Url]);
if(!strstr($r[Url],"http://")) $r[Url]="$site_url".$r[Url];
if($r[Target]) $r[Target]=" target=\"_$r[Target]\"";
else unset($target);
return $r;
}
require($site_path."left.php");
function drawpanel($id,$blocks)
{
global $auth,$lang;
print "<center><table border=0 cellspacing=0 cellpadding=5><td valign=top width=160px>";
$res=runsql("select m1.*,m1.Name_$lang as name,count(m2.MenuID) as cnt from en_menu m1
left outer join en_menu m2 on m2.Parent=m1.MenuID
where m1.Parent='$id'
group by m1.MenuID
order by Rang");
$num=0;
while($r=mysql_fetch_array($res))
{
if($r[cnt]>0)
{
if($num>0&&$num%$blocks==0&&$num<$blocks*3) print "</td><td valign=top width=160px>";
$num++;
print "<table border=0 width=100% cellspacing=1 cellpadding=3 bgcolor=d3d3d3 ><td class=header>";
$r=printmenu($r);
print "<center><b>$r[name]</b></a></center>";
print "</td></table>";
$res1=runsql("select m1.*,m1.Name_$lang as name,count(m2.MenuID) as cnt from en_menu m1
left outer join en_menu m2 on m2.Parent=m1.MenuID
where m1.Parent='$r[MenuID]'
group by m1.MenuID
order by Rang");
while($r1=mysql_fetch_array($res1))
{
print "<table border=0 width=100% cellspacing=1 cellpadding=3 bgcolor=d3d3d3 ><td bgcolor=FFFAE4>";
$r1=printmenu($r1);
if(!$r1[cnt]) print "» <a href=\"$r1[Url]\" $r1[Target]>$r1[name]</a><br>";
else print "» $r1[name]<br>";
$res2=runsql("select *,Name_$lang as name from en_menu where Name_$lang<>'$r1[Name]' and Parent='$r1[MenuID]' order by Rang");
while($r2=mysql_fetch_array($res2))
{
$r2=printmenu($r2);
print " - <a href=\"$r2[Url]\" $r2[Target]>$r2[name]</a><br>";
}
print "</td></table>";
}
print "<br>";
}
}
print "</table>";
}
drawpanel(2,2);
drawpanel(49,3);
require($site_path."bottom.php");
$db->close();
?>