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
|
<?php
/******************************
* EQdkp
* Copyright 2002-2003
* Licensed under the GNU GPL. See COPYING for full terms.
* ------------------
* mm_listmembers.php
* Began: Thu January 30 2003
*
* $Id: mm_listmembers.php 46 2007-06-19 07:29:11Z tsigo $
*
******************************/
// Shows a list of members, basically just an admin-themed version of
// /listmembers.php
if ( !defined('EQDKP_INC') )
{
die('Hacking attempt');
}
$sort_order = array(
0 => array('member_name', 'member_name desc'),
1 => array('member_earned desc', 'member_earned'),
2 => array('member_spent desc', 'member_spent'),
3 => array('member_adjustment desc', 'member_adjustment'),
4 => array('member_current desc', 'member_current'),
5 => array('member_lastraid desc', 'member_lastraid'),
6 => array('member_level desc', 'member_level'),
7 => array('member_class', 'member_class desc'),
8 => array('rank_name', 'rank_name desc'),
9 => array('class_armor_type', 'class_armor_type desc')
);
$current_order = switch_order($sort_order);
$member_count = 0;
$previous_data = '';
// Figure out what data we're comparing from member to member
// in order to rank them
$sort_index = explode('.', $current_order['uri']['current']);
$previous_source = preg_replace('/( (asc|desc))?/i', '', $sort_order[$sort_index[0]][$sort_index[1]]);
$show_all = ( (!empty($_GET['show'])) && ($_GET['show'] == 'all') ) ? true : false;
$sql = 'SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
c.class_name AS member_class,
r.rank_name, r.rank_prefix, r.rank_suffix,
c.class_armor_type AS armor_type
FROM ' . MEMBERS_TABLE . ' m, ' . MEMBER_RANKS_TABLE . ' r, ' .CLASS_TABLE. ' c
WHERE (m.member_rank_id = r.rank_id)
AND (m.member_class_id = c.class_id)
ORDER BY ' . $current_order['sql'];
if ( !($members_result = $db->query($sql)) )
{
message_die('Could not obtain member information', '', __FILE__, __LINE__, $sql);
}
while ( $row = $db->fetch_record($members_result) )
{
$member_count++;
$tpl->assign_block_vars('members_row', array(
'ROW_CLASS' => $eqdkp->switch_row_class(),
'ID' => $row['member_id'],
'COUNT' => ($row[$previous_source] == $previous_data) ? ' ' : $member_count,
'NAME' => $row['rank_prefix'] . $row['member_name'] . $row['rank_suffix'],
'RANK' => stripslashes($row['rank_name']),
'LEVEL' => ( $row['member_level'] > 0 ) ? $row['member_level'] : ' ',
'ARMOR' => ( !empty($row['armor_type']) ) ? $row['armor_type'] : ' ',
'CLASS' => ( $row['member_class'] != 'NULL' ) ? $row['member_class'] : ' ',
'EARNED' => $row['member_earned'],
'SPENT' => $row['member_spent'],
'ADJUSTMENT' => $row['member_adjustment'],
'CURRENT' => $row['member_current'],
'LASTRAID' => ( !empty($row['member_lastraid']) ) ? date($user->style['date_notime_short'], $row['member_lastraid']) : ' ',
'C_ADJUSTMENT' => color_item($row['member_adjustment']),
'C_CURRENT' => color_item($row['member_current']),
'C_LASTRAID' => 'neutral',
'U_VIEW_MEMBER' => 'manage_members.php'.$SID . '&mode=addmember&' . URI_NAME . '='.$row['member_name'])
);
// So that we can compare this member to the next member,
// set the value of the previous data to the source
$previous_data = $row[$previous_source];
}
$footcount_text = sprintf($user->lang['listmembers_footcount'], $db->num_rows($members_result));
$tpl->assign_vars(array(
'F_MEMBERS' => 'manage_members.php' . $SID . '&mode=addmember',
'L_NAME' => $user->lang['name'],
'L_RANK' => $user->lang['rank'],
'L_LEVEL' => $user->lang['level'],
'L_CLASS' => $user->lang['class'],
'L_EARNED' => $user->lang['earned'],
'L_SPENT' => $user->lang['spent'],
'L_ARMOR' => $user->lang['armor'],
'L_ADJUSTMENT' => $user->lang['adjustment'],
'L_CURRENT' => $user->lang['current'],
'L_LASTRAID' => $user->lang['lastraid'],
'BUTTON_NAME' => 'delete',
'BUTTON_VALUE' => $user->lang['delete_selected_members'],
'O_NAME' => $current_order['uri'][0],
'O_RANK' => $current_order['uri'][8],
'O_LEVEL' => $current_order['uri'][6],
'O_CLASS' => $current_order['uri'][7],
'O_ARMOR' => $current_order['uri'][9],
'O_EARNED' => $current_order['uri'][1],
'O_SPENT' => $current_order['uri'][2],
'O_ADJUSTMENT' => $current_order['uri'][3],
'O_CURRENT' => $current_order['uri'][4],
'O_LASTRAID' => $current_order['uri'][5],
'U_LIST_MEMBERS' => 'manage_members.php'.$SID.'&mode=list&',
'S_COMPARE' => false,
'S_NOTMM' => false,
'LISTMEMBERS_FOOTCOUNT' => $footcount_text)
);
$eqdkp->set_vars(array(
'page_title' => sprintf($user->lang['title_prefix'], $eqdkp->config['guildtag'], $eqdkp->config['dkp_name']).': '.$user->lang['listmembers_title'],
'template_file' => 'listmembers.html',
'display' => true)
);
?>
|