forked from opencaching/opencaching-pl
/
ustatsg2.php
122 lines (98 loc) · 5.05 KB
/
ustatsg2.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
<?php
use src\Utils\Database\XDb;
use src\Models\OcConfig\OcConfig;
use src\Models\ApplicationContainer;
require_once (__DIR__.'/lib/common.inc.php');
//user logged in?
if (!ApplicationContainer::GetAuthorizedUser()) {
$target = urlencode(tpl_get_current_page());
tpl_redirect('login.php?target=' . $target);
exit;
}
// check for old-style parameters
if (isset($_REQUEST['userid'])) {
$user_id = $_REQUEST['userid'];
}
/** @var View */
$view->setTemplate('ustat');
$view->setVar('userId', $user_id);
$view->setVar('displayCreatedStats', true);
$content = "";
$rsGeneralStat = XDb::xSql(
"SELECT hidden_count, founds_count, log_notes_count, notfounds_count, username
FROM `user` WHERE user_id= ? LIMIT 1", $user_id);
$user_record = XDb::xFetchArray($rsGeneralStat);
tpl_set_var('username', htmlspecialchars($user_record['username']));
if ($user_record['founds_count'] == 0) {
$content .= '<p> </p><p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr("graph_find") . '</p></div><br /><br /><p> <b>' . tr("there_is_no_caches_found") . '</b></p>';
} else {
// calculate diif days between date of register on OC to current date
$ddays = XDb::xMultiVariableQueryValue(
"SELECT TO_DAYS( NOW() ) - TO_DAYS(`date_created`) `diff` FROM `user` WHERE user_id= :1 LIMIT 1 ", 0, $user_id);
$rsGeneralStat = XDb::xSql(
"SELECT YEAR(`date_created`) usertime,hidden_count, founds_count, log_notes_count, username
FROM `user` WHERE user_id= ? LIMIT 1", $user_id);
if ($rsGeneralStat !== false) {
$user_record = XDb::xFetchArray($rsGeneralStat);
XDb::xFreeResults($rsGeneralStat);
tpl_set_var('username', htmlspecialchars($user_record['username']));
}
$content .='<p> </p><p> </p><div class="content2-container bg-blue02"><p class="content-title-noshade-size1"> <img src="/images/blue/logs.png" class="icon32" alt="Caches Find" title="Caches Find" /> ' . tr("graph_find") . '</p></div><br />';
$content .= '<p><img src="graphs/PieGraphustat.php?userid=' . $user_id . '&t=cf" border="0" alt="" width="500" height="300" /></p>';
$year = date("Y");
$content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfm' . $year . '" border="0" alt="" width="500" height="200" /></p>';
if ($user_record['usertime'] != $year) {
$yearr = $year - 1;
$content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfm' . $yearr . '" border="0" alt="" width="500" height="200" /></p>';
}
$content .= '<p><img src="graphs/BarGraphustat.php?userid=' . $user_id . '&t=cfy" border="0" alt="" width="500" height="200" /></p>';
}
// Parameter
$jpeg_qualitaet = 80;
$fontfile = "./resources/fonts/arial.ttf";
$tplpath = 'images/PLmapa.gif';
$im = ImageCreateFromGIF($tplpath);
$clrWhite = ImageColorAllocate($im, 255, 255, 255);
$clrBorder = ImageColorAllocate($im, 70, 70, 70);
$clrBlack = ImageColorAllocate($im, 0, 0, 0);
$clrRed = ImageColorAllocate($im, 255, 0, 0);
$clrBlue = ImageColorAllocate($im, 0, 0, 255);
$fontsize = 18;
$wojewodztwa = array(
'PL11' => array(110, 138), // Lodzkie
'PL12' => array(155, 108), // Mazowieckie
'PL21' => array(135, 208), // Malopolskie
'PL22' => array(103, 188), // Slaskie
'PL31' => array(200, 150), // Lubelskie
'PL32' => array(180, 200), // Podkarpackie
'PL33' => array(146, 170), // Swietokrzyskie
'PL34' => array(195, 75), // Podlaskie
'PL41' => array(65, 115), // Wielkopolskie
'PL42' => array(26, 55), // Zachodniopmorskie
'PL43' => array(19, 100), // Lubuskie
'PL51' => array(35, 149), // Dolnoslaskie
'PL52' => array(78, 169), // Opolskie
'PL61' => array(90, 85), // Kujawskie
'PL62' => array(145, 50), // Warminskie
'PL63' => array(85, 43) // Pomorskie
);
$wyniki = XDb::xSql(
"SELECT cache_location.code3 wojewodztwo, COUNT(*) ilosc FROM cache_logs, cache_location
WHERE cache_logs.user_id= ? AND cache_logs.type='1'
AND cache_logs.deleted='0'
AND cache_location.code3 IN ('PL11','PL12','PL21','PL22','PL31','PL32','PL33','PL34','PL41','PL42','PL43','PL51','PL52','PL61','PL62','PL63')
AND cache_logs.cache_id=cache_location.cache_id
GROUP BY cache_location.code3", $user_id );
while ($wynik = XDb::xFetchArray($wyniki)) {
$text = $wynik['ilosc'];
if ($text != "0")
ImageTTFText($im, 14, 0, $wojewodztwa[$wynik['wojewodztwo']][0], $wojewodztwa[$wynik['wojewodztwo']][1], $clrBlack, $fontfile, $text);
};
// write output
Imagejpeg($im, OcConfig::getDynFilesPath() . 'images/statpics/mapstat' . $user_id . '.jpg', $jpeg_qualitaet);
ImageDestroy($im);
// generate number for refresh image
$rand = rand();
$content .= '<p style="margin-left: 125px;"><img src="/images/statpics/mapstat' . $user_id . '.jpg?rand=' . $rand . '" border="0" alt="" width="250" height="235" /></p>';
tpl_set_var('content', $content);
tpl_BuildTemplate();