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
|
<?php
/******************************
* EQdkp
* Copyright NONE!!!!
* Licensed under the WTFPLS - just do whatever the fuck you want with this.
* ------------------
* August 2014
*
******************************/
define('EQDKP_INC', true);
$eqdkp_root_path = './';
include_once($eqdkp_root_path . 'common.php');
$user->check_auth('u_member_list');
$thirty_days = mktime(0, 0, 0, date('m'), date('d')-30, date('Y'));
$sixty_days = mktime(0, 0, 0, date('m'), date('d')-60, date('Y'));
$ninety_days = mktime(0, 0, 0, date('m'), date('d')-90, date('Y'));
$raid_count_30 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$thirty_days.' AND '.time());
$raid_count_60 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$sixty_days.' AND '.time());
$raid_count_90 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$ninety_days.' AND '.time());
// Build SQL query based on GET options
$sql = 'SELECT
m.member_name,
member_earned,
member_spent,
member_adjustment,
(member_earned-member_spent+member_adjustment) AS member_current,
member_firstraid,
member_lastraid,
member_raidcount,
raid_count_30,
raid_count_60,
raid_count_90,
c.class_name AS member_class
FROM ' . MEMBERS_TABLE . ' m
LEFT JOIN ' . MEMBER_RANKS_TABLE . ' r
ON (m.member_rank_id = r.rank_id)
LEFT JOIN ' . CLASS_TABLE . ' c
ON (m.member_class_id = c.class_id)
LEFT JOIN R30 r30
ON (m.member_name = r30.member_name)
JOIN R60 r60
ON (m.member_name = r60.member_name)
LEFT JOIN R90 r90
ON (m.member_name = r90.member_name)
WHERE r.rank_name = "Guest"
ORDER BY member_lastraid desc, member_name';
if ( !($members_result = $db->query($sql)) )
{
message_die('Could not obtain member information', '', __FILE__, __LINE__, $sql);
}
// Print stuff
printf("[table]<br/>");
printf("[tr]");
printf("[td]Name[/td]");
printf("[td]Class[/td]");
printf("[td]First[/td]");
printf("[td]Last[/td]");
printf("[td]30 days[/td]");
printf("[td]60 days[/td]");
printf("[td]90 days[/td]");
printf("[td]Earned[/td]");
printf("[td]Spent[/td]");
printf("[td]Adjustment[/td]");
printf("[td]Current[/td]");
printf("[/tr]<br/>");
while ( $row = $db->fetch_record($members_result) )
{
$attended_percent_30 = ( $raid_count_30 > 0 ) ? round(($row['raid_count_30'] / $raid_count_30) * 100) : 0;
$attended_percent_60 = ( $raid_count_60 > 0 ) ? round(($row['raid_count_60'] / $raid_count_60) * 100) : 0;
$attended_percent_90 = ( $raid_count_90 > 0 ) ? round(($row['raid_count_90'] / $raid_count_90) * 100) : 0;
// TODO: add colors
printf("[tr]");
printf("[td]%s[/td]", $row['member_name']);
printf("[td]%s[/td]", $row['member_class']);
printf("[td]%s[/td]", date($user->style['date_notime_short'], $row['member_firstraid']));
printf("[td]%s[/td]", date($user->style['date_notime_short'], $row['member_lastraid']));
printf("[td]%s%%[/td]", $attended_percent_30);
printf("[td]%s%%[/td]", $attended_percent_60);
printf("[td]%s%%[/td]", $attended_percent_90);
printf("[td][color=green]%s[/color][/td]", $row['member_earned']);
printf("[td][color=red]%s[/color][/td]", $row['member_spent']);
printf("[td]%s[/td]", $row['member_adjustment']);
printf("[td][color=%s]%s[/color][/td]", $row['member_current'] > 0 ? 'green' : 'red', $row['member_current']);
printf("[/tr]<br/>");
}
printf("[/table]<br/>");
$db->free_result($members_result);
?>
|