-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathcounter_stats.php
156 lines (132 loc) · 7.24 KB
/
counter_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
<?php
/*
##########################################################################
# #
# Version 4 / / / #
# -----------__---/__---__------__----__---/---/- #
# | /| / /___) / ) (_ ` / ) /___) / / #
# _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___ #
# Free Content / Management System #
# / #
# #
# #
# Copyright 2005-2011 by webspell.org #
# #
# visit webSPELL.org, webspell.info to get webSPELL for free #
# - Script runs under the GNU GENERAL PUBLIC LICENSE #
# - It's NOT allowed to remove this copyright-tag #
# -- http://www.fsf.org/licensing/licenses/gpl.html #
# #
# Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at), #
# Far Development by Development Team - webspell.org #
# #
# visit webspell.org #
# #
##########################################################################
##########################################################################
# #
# Version 4 / / / #
# -----------__---/__---__------__----__---/---/- #
# | /| / /___) / ) (_ ` / ) /___) / / #
# _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___ #
# Society / Edition #
# / #
# #
# modified by webspell|k3rmit (Stefan Giesecke) in 2009 #
# #
# - Modifications are released under the GNU GENERAL PUBLIC LICENSE #
# - It is NOT allowed to remove this copyright-tag #
# - http://www.fsf.org/licensing/licenses/gpl.html #
# #
##########################################################################
*/
$_language->read_module('counter');
eval ("\$title_counter_stats = \"".gettemplate("title_counter_stats")."\";");
echo $title_counter_stats;
$pagebg=PAGEBG;
$border=BORDER;
$bghead=BGHEAD;
$bg1=BG_1;
$bg2=BG_1;
$bg3=BG_1;
$bg4=BG_1;
$time = time();
$date = date("d.m.Y", $time);
$dateyesterday = date("d.m.Y", $time-(24*3600));
$datemonth = date(".m.Y", time());
$ergebnis=safe_query("SELECT hits FROM ".PREFIX."counter");
$ds=mysql_fetch_array($ergebnis);
$us = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."user"));
$total=$ds['hits'];
$dt = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates='$date'"));
if($dt['count']) $today = $dt['count']; else $today = 0;
$dy = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates='$dateyesterday'"));
if($dy['count']) $yesterday = $dy['count']; else $yesterday = 0;
$month=0;
$monthquery = safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates LIKE '%$datemonth'");
while($dm=mysql_fetch_array($monthquery)) {
$month = $month+$dm['count'];
}
if($month == 0) $month = 1;
$monatsstat = '';
for($i = date("d",time());$i>0;$i--) {
if(mb_strlen($i)<2) $i = "0".$i;
$tmp = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates='".$i.$datemonth."'"));
if($tmp['count']) $visits = $tmp['count']; else $visits=0;
$i%2 ? $backgroundcolor1=BG_1 : $backgroundcolor1=BG_1;
$i%2 ? $backgroundcolor2=BG_1 : $backgroundcolor2=BG_1;
$prozent = $visits*95/$month;
$monatsstat .= '<tr>
<td width="35%" bgcolor="'.$backgroundcolor1.'">'.$i.$datemonth.':</td>
<td width="65%" bgcolor="'.$backgroundcolor2.'">'.$visits.' <img src="images/icons/poll.gif" height="5" width="'.(round($prozent)+1).'%" alt="'.$_language->module['visits'].'" title="'.$_language->module['visits'].'" /></td>
</tr>';
}
$tmp = mysql_fetch_array(safe_query("SELECT online FROM ".PREFIX."counter"));
$days_online = round((time()-$tmp['online'])/(3600*24));
if(!$days_online) $days_online = 1;
$perday = round($total/$days_online,2);
$perhour = round($total/$days_online/24,2);
$permonth = round($total/$days_online*24,2);
$tmp = mysql_fetch_array(safe_query("SELECT max(count) as MAXIMUM FROM ".PREFIX."counter_stats"));
$maxvisits = $tmp['MAXIMUM'];
$online_lasthour = mysql_num_rows(safe_query("SELECT ip FROM ".PREFIX."counter_iplist WHERE del>".(time()-3600)));
$online = mysql_num_rows(safe_query("SELECT time FROM ".PREFIX."whoisonline"));
$dm=mysql_fetch_array(safe_query("SELECT maxonline FROM ".PREFIX."counter"));
$maxonline=$dm['maxonline'];
$guests = mysql_num_rows(safe_query("SELECT ip FROM ".PREFIX."whoisonline WHERE userID=''"));
$user = mysql_num_rows(safe_query("SELECT userID FROM ".PREFIX."whoisonline WHERE ip=''"));
$useronline = $guests + $user;
if($user==1) $user_on='1 '.$_language->module['user'];
else $user_on=$user.' '.$_language->module['users'];
if($guests==1) $guests_on='1 '.$_language->module['guest'];
else $guests_on= $guests.' '.$_language->module['guests'];
// average age of all users
$get = mysql_fetch_assoc(safe_query("SELECT ROUND(SUM(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(birthday)), '%y')) / COUNT(userID)) as 'avg_age' FROM ".PREFIX."user WHERE birthday > 0"));
$avg_age_user = $get['avg_age'];
// average age of clanmembers
$avg_age_member = 0;
$get = safe_query("SELECT SUM(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(u.birthday)), '%y')) / COUNT(u.userID) as 'avg_age'
FROM ".PREFIX."squads_members m
JOIN ".PREFIX."user u ON u.userID = m.userID
WHERE u.birthday > 0
GROUP BY m.userID");
if(mysql_num_rows($get)){
while($ds = mysql_fetch_assoc($get)){
$avg_age_member += $ds['avg_age'];
}
$avg_age_member = ROUND($avg_age_member/mysql_num_rows($get),0);
}
// get oldest/youngest member
$get_young = mysql_fetch_assoc(safe_query("SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(birthday)), '%y') as 'age', nickname, userID
FROM ".PREFIX."user
WHERE birthday > 0
ORDER BY birthday DESC
LIMIT 0,1"));
$get_old = mysql_fetch_assoc(safe_query("SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(birthday)), '%y') as 'age', nickname, userID
FROM ".PREFIX."user
WHERE birthday > 0
ORDER BY birthday ASC
LIMIT 0,1"));
eval ("\$stats = \"".gettemplate("counter_stats")."\";");
echo $stats;
?>