forked from opencaching/opencaching-pl
-
Notifications
You must be signed in to change notification settings - Fork 0
/
event_attendance.php
121 lines (94 loc) · 4.38 KB
/
event_attendance.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
<?php
/* * *************************************************************************
./event_attendance.php
-------------------
begin : June 24 2004
copyright : (C) 2004 The OpenCaching Group
forum contact at : http://www.opencaching.com/phpBB2
* ************************************************************************* */
/* * *************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* ************************************************************************* */
/* * **************************************************************************
Unicode Reminder メモ
show who attends an events
used template(s): event_attendance
GET Parameter: id
* ************************************************************************** */
//prepare the templates and include all neccessary
$tplname = 'event_attendance';
require_once('./lib/common.inc.php');
require($stylepath . '/event_attendance.inc.php');
tpl_set_var('nocacheid_start', '<!--');
tpl_set_var('nocacheid_end', '-->');
tpl_set_var('owner', '');
tpl_set_var('cachename', '');
tpl_set_var('event_date', '');
// id gesetzt?
$cache_id = isset($_REQUEST['id']) ? $_REQUEST['id'] + 0 : 0;
if ($cache_id != 0) {
$rs = sql("SELECT `caches`.`name`, `user`.`username`, `caches`.`date_hidden`
FROM `caches`
INNER JOIN `user` ON (`user`.`user_id`=`caches`.`user_id`)
WHERE `caches`.`cache_id`='&1'", $cache_id);
// $rr = sql("SELECT DATE_FORMAT(`caches`.`date_hidden`,'%Y%m%d') `date_hidden`, DATE_FORMAT(CURDATE(),'%Y%m%d') `date_current` FROM `caches` WHERE `caches`.`cache_id`='&1'", $cache_id);
$rr = sql("SELECT `caches`.`date_hidden` `date_hidden`, CURDATE() `date_current` FROM `caches` WHERE `caches`.`cache_id`='&1'", $cache_id);
$dd = sql_fetch_array($rr);
$v1 = strtotime($dd['date_hidden']);
$v2 = strtotime($dd['date_current']);
if ("$v1" < "$v2") {
if ($r = sql_fetch_array($rs)) {
tpl_set_var('nocacheid_start', '');
tpl_set_var('nocacheid_end', '');
tpl_set_var('owner', htmlspecialchars($r['username'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('cachename', htmlspecialchars($r['name'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('event_date', htmlspecialchars(strftime($dateformat, strtotime($r['date_hidden'])), ENT_COMPAT, 'UTF-8'));
}
// log_type 8 will attended, 7 attended
$rs = sql("SELECT DISTINCT `user`.`username`
FROM `cache_logs`
INNER JOIN `user` ON (`user`.`user_id`=`cache_logs`.`user_id`)
WHERE `cache_logs`.`type`=7
AND `cache_logs`.`deleted`=0
AND `cache_logs`.`cache_id`='&1'
ORDER BY `user`.`username`", $cache_id);
$attendants = '';
$count = 0;
while ($r = sql_fetch_array($rs)) {
$attendants .= $r['username'] . '<br />';
$count++;
}
} else {
if ($r = sql_fetch_array($rs)) {
tpl_set_var('nocacheid_start', '');
tpl_set_var('nocacheid_end', '');
tpl_set_var('owner', htmlspecialchars($r['username'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('cachename', htmlspecialchars($r['name'], ENT_COMPAT, 'UTF-8'));
tpl_set_var('event_date', htmlspecialchars(strftime($dateformat, strtotime($r['date_hidden'])), ENT_COMPAT, 'UTF-8'));
}
// log_type 8 will attended, 7 attended
$rs = sql("SELECT DISTINCT `user`.`username`
FROM `cache_logs`
INNER JOIN `user` ON (`user`.`user_id`=`cache_logs`.`user_id`)
WHERE `cache_logs`.`type`=8
AND `cache_logs`.`deleted`=0
AND `cache_logs`.`cache_id`='&1'
ORDER BY `user`.`username`", $cache_id);
$attendants = '';
$count = 0;
while ($r = sql_fetch_array($rs)) {
$attendants .= $r['username'] . '<br />';
$count++;
}
}
tpl_set_var('attendants', $attendants);
tpl_set_var('att_count', $count);
}
//make the template and send it out
tpl_BuildTemplate();
?>