summaryrefslogtreecommitdiffstats
path: root/listguests.php
blob: 70a46db140164fde822db97b932ebfab452201a8 (plain)
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);

?>