emsee_w
asked on
PHP file shows tables / charts on the screen, I need it to show one table and not another by remming out code. Need idea of syntax to look for.
Hello,
I am learning bits and pieces about PHP but I know very little. a particular PHP file in the EQdkp Plus package I have installed on my site shows 2 main charts / tables on it. One is a horisontal single row table of big blocks of data (Members by class) and the other is a list / like table showing data (all members in one list)
I am making a new copy of this file which only shows the first of the two tables.
I Think I have found the code that makes the table I need from it:
The section I found that seems to be related to it (by remming out it disappears etc)
code:
//leaderboard
if ($conf_plus['pk_leaderboar
{
// Load Default Leaderboard Pool from Plus Config
if(($conf_plus['pk_default
$dkpplus->showDKPLeaderboa
}
else{
$dkpplus->showDKPLeaderboa
}
I tried (for fun) pasting the 1 line below from the above code a few times to see what happens and it made the table I want appear the number of times I pasted the line:
$dkpplus->showDKPLeaderboa
However this section of code did not work by it's self in a new file.
I ave also attached the entire code from the ".php" file, not because I want you to do the work for me, but in case a glance at it might make the solution look clearer.
it is live on my site at:
http://www.hordecore.net/hcdkp/listmembers.php
How can I show this table on it's own?
Thank you,
Michael A.
P.S. Let me know if this should be worth more points.
I am learning bits and pieces about PHP but I know very little. a particular PHP file in the EQdkp Plus package I have installed on my site shows 2 main charts / tables on it. One is a horisontal single row table of big blocks of data (Members by class) and the other is a list / like table showing data (all members in one list)
I am making a new copy of this file which only shows the first of the two tables.
I Think I have found the code that makes the table I need from it:
The section I found that seems to be related to it (by remming out it disappears etc)
code:
//leaderboard
if ($conf_plus['pk_leaderboar
{
// Load Default Leaderboard Pool from Plus Config
if(($conf_plus['pk_default
$dkpplus->showDKPLeaderboa
}
else{
$dkpplus->showDKPLeaderboa
}
I tried (for fun) pasting the 1 line below from the above code a few times to see what happens and it made the table I want appear the number of times I pasted the line:
$dkpplus->showDKPLeaderboa
However this section of code did not work by it's self in a new file.
I ave also attached the entire code from the ".php" file, not because I want you to do the work for me, but in case a glance at it might make the solution look clearer.
it is live on my site at:
http://www.hordecore.net/hcdkp/listmembers.php
How can I show this table on it's own?
Thank you,
Michael A.
P.S. Let me know if this should be worth more points.
<?php
/******************************
* EQdkp
* Copyright 2002-2005
* Licensed under the GNU GPL. See COPYING for full terms.
* ------------------
* listmembers.php
* begin: Wed December 18 2002
*
* $Id: listmembers.php 2366 2008-07-14 09:01:02Z wallenium $
*
******************************/
define('EQDKP_INC', true);
$eqdkp_root_path = './';
include_once($eqdkp_root_path . 'common.php');
$user->check_auth('u_member_list');
$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'),
10 => array('last_loot desc', 'last_loot'),
11 => array('frr desc', 'frr'),
12 => array('ar desc', 'ar'),
13 => array('sr desc', 'sr'),
14 => array('nr desc', 'nr'),
15 => array('fir desc', 'fir'),
);
$current_order = switch_order($sort_order);
$cur_hash = hash_filename("listmembers.php");
if ( isset($_POST['submit']) && ($_POST['submit'] == $user->lang['compare_members']) && isset($_POST['compare_ids']) )
{
// To compare members, we take the post checkboxes,
// serialize them and pass them to the script again through _GET
redirect('listmembers.php?compare=' . implode(',', $_POST['compare_ids']));
}
elseif ( isset($_GET['compare']) )
{
$member_count = 0; ##custom
$s_compare = true;
$uri_addon = '';
$compare = validateCompareInput($_GET['compare']);
// Find 30 days ago, then find how many raids occurred in those 30 days
// Do the same for 60 and 90 days
$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());
$raid_count_all = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE ) ;
$sql = "SELECT *, (member_earned-member_spent+member_adjustment) AS member_current, c.class_name AS member_class
FROM " . MEMBERS_TABLE . " m, " . CLASS_TABLE . " c
WHERE (m.member_class_id = c.class_id)
AND (member_id IN (" . $compare . "))
ORDER BY " . $current_order['sql'];
$result = $db->query($sql);
// Output each row
while ( $row = $db->fetch_record($result) )
{
$individual_raid_count_30 = 0;
$individual_raid_count_60 = 0;
$individual_raid_count_90 = 0;
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$thirty_days.' AND '.time().')';
$individual_raid_count_30 = $db->query_first($rc_sql);
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$sixty_days.' AND '.time().')';
$individual_raid_count_60 = $db->query_first($rc_sql);
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$ninety_days.' AND '.time().')';
$individual_raid_count_90 = $db->query_first($rc_sql);
// Prevent division by 0
$percent_of_raids_30 = ( $raid_count_30 > 0 ) ? round(($individual_raid_count_30 / $raid_count_30) * 100) : 0;
$percent_of_raids_60 = ( $raid_count_30 > 0 ) ? round(($individual_raid_count_60 / $raid_count_60) * 100) : 0;
$percent_of_raids_90 = ( $raid_count_90 > 0 ) ? round(($individual_raid_count_90 / $raid_count_90) * 100) : 0;
// If the member's spent is greater than 0, see how long ago they looted an item
if ( $row['member_spent'] > 0 and $conf_plus['pk_lastloot']==1)
{
$ll_sql = 'SELECT max(item_date) AS last_loot
FROM ' . ITEMS_TABLE . "
WHERE item_buyer='".$row['member_name']."'";
$last_loot = $db->query_first($ll_sql);
}
unset($last_loot);
}
$sordoptions = split(" ", $current_order['sql']);
$sortcol = $sordoptions[0];
if($sordoptions[1] == "desc")
{
$sortascdesc = SORT_DESC;
}
else
{
$sortascdesc = SORT_ASC;
}
$members_rows_fsort = array();
foreach($members_rows as $members_line)
{
$members_rows_fsort[] = $members_line[$sortcol];
}
array_multisort($members_rows_fsort, $sortascdesc, $members_rows);
foreach($members_rows as $row)
{
$member_count++;
$mclass = renameClasstoenglish($row['member_class']) ;
$row['member_class'] = get_classNameImgListmembers($row['member_class'],$row['member_class_id']);
$race_img = $eqdkp_root_path.'images/races/'.strtolower($row['member_race_id']).'.gif';
if(file_exists($race_img))
{
$row['member_class'] = '<img src='.$race_img.'>'.$row['member_class'];
}
$rank_img = $eqdkp_root_path.'images/rank/'.strtolower($row['rank_name']).'.gif';
if(file_exists($rank_img))
{
$rankimg = '<img src='.$rank_img.' alt="Rank='.$row['rank_name'].'">';
}
else
{
$rankimg = '';
}
$line_array = array(
'ROW_CLASS' => $eqdkp->switch_row_class(),
'ID' => $row['member_id'],
'NAME' => $row['member_name'],
'LEVEL' => ( $row['member_level'] > 0 ) ? $row['member_level'] : ' ',
'CLASS' => ( !empty($row['member_class']) ) ? $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']) : ' ',
'LASTLOOT' => ( isset($row['last_loot']) ) ? date($user->style['date_notime_short'], $row['last_loot']) : ' ',
'RAIDS_30_DAYS' => sprintf($user->lang['of_raids'], $row['percent_of_raids_30']),
'RAIDS_60_DAYS' => sprintf($user->lang['of_raids'], $percent_of_raids_60),
'RAIDS_90_DAYS' => sprintf($user->lang['of_raids'], $row['percent_of_raids_90']),
'C_ADJUSTMENT' => color_item($row['member_adjustment']),
'C_CURRENT' => color_item($row['member_current']),
'C_LASTRAID' => 'neutral',
'C_RAIDS_30_DAYS' => color_item($row['percent_of_raids_30'], true),
'C_RAIDS_90_DAYS' => color_item($row['percent_of_raids_90'], true),
#'U_VIEW_MEMBER' => 'viewmember.php'.$SID . '&' . URI_NAME . '='.$row['member_name']
'U_VIEW_MEMBER' => 'viewmember.php'.$SID . '&' . URI_NAME . '='.$row['member_name'] . '" class="' . get_classColorChecked($mclass)
);
$tpl->assign_block_vars('members_row', $line_array );
}
$db->free_result($result);
$footcount_text = $user->lang['listmembers_compare_footcount'];
#$encoded_ids = urlencode(serialize($compare_ids));
$encoded_ids = $compare;
$tpl->assign_vars(array(
'U_COMPARE_MEMBERS' => 'listmembers.php' . $SID . '&compare=' . $encoded_ids . '&')
);
}
//
// Normal member display
//
else
{
$s_compare = false;
$member_count = 0;
$previous_data = '';
// Find 30 days ago, then find how many raids occurred in those 30 days
// Do the same for 60 and 90 days
if($conf_plus['pk_attendance30']==1)
{
$thirty_days = mktime(0, 0, 0, date('m'), date('d')-30, date('Y'));
$raid_count_30 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$thirty_days.' AND '.time());
}
if($conf_plus['pk_attendance60']==1)
{
$sixty_days = mktime(0, 0, 0, date('m'), date('d')-60, date('Y'));
$raid_count_60 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$sixty_days.' AND '.time());
}
if($conf_plus['pk_attendance90']==1)
{
$ninety_days = mktime(0, 0, 0, date('m'), date('d')-90, date('Y'));
$raid_count_90 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date BETWEEN '.$ninety_days.' AND '.time());
}
if($conf_plus['pk_attendanceAll']==1)
{
$raid_count_all = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE) ;
}
// 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;
//
// Filtering
//
$filter = ( isset($_GET['filter']) ) ? urldecode($_GET['filter']) : 'none';
$filter = ( preg_match('#\-{1,}#', $filter) ) ? 'none' : $filter;
//
// MultiDKP Filtering
//
$multifilter = ( isset($_GET['multifilter']) ) ? urldecode($_GET['multifilter']) : 'none';
$multifilter = ( preg_match('#\-{1,}#', $multifilter) ) ? 'none' : $multifilter;
// Grab class_id
$temp_filter = '';
if ( isset($_GET['filter']) )
{
$temp_filter = $_GET['filter'];
// Just because filter is set doesn't mean its valid - clear it if its set to none
if ( preg_match('/ARMOR_/', $temp_filter) )
{
$temp_filter = preg_replace('/ARMOR_/', '', $temp_filter);
$query_by_armor = 1;
$query_by_class = 0;
$id = $temp_filter;
}
elseif( $temp_filter == "none" )
{
$temp_filter = "";
$query_by_armor = 0;
$query_by_class = 0;
}
else
{
$query_by_class = 1;
$query_by_armor = 0;
$id = $temp_filter;
}
if(preg_match('/pool/', $temp_filter))
{
$query_by_armor = 0;
$query_by_class = 0;
$query_by_pool = 1;
}
}
// Add in the cute ---- line, filter on None if some idiot selects it
$tpl->assign_block_vars('filter_row', array(
'VALUE' => strtolower("None"),
'SELECTED' => ( $filter == strtolower("NULL") ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', "--------")));
// Grab generic armor information
$sql = 'SELECT class_armor_type FROM ' . CLASS_TABLE .'';
$sql .= ' GROUP BY class_armor_type';
$result = $db->query($sql);
while ( $row = $db->fetch_record($result) )
{
// fixed by WalleniuM: $filter must be $temp_filter, because of the ARMOR_ prefix
$tpl->assign_block_vars('filter_row', array(
'VALUE' => "ARMOR_" . strtolower($row['class_armor_type']),
'SELECTED' => ( $temp_filter == strtolower($row['class_armor_type']) ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', $row['class_armor_type']))
);
}
// Add in the cute ---- line, filter on None if some idiot selects it
$tpl->assign_block_vars('filter_row', array(
'VALUE' => strtolower("None"),
'SELECTED' => ( $filter == strtolower("NULL") ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', "--------")));
// Moved the class/race/faction information to the database
$sql = 'SELECT class_name, class_id, class_min_level, class_max_level FROM ' . CLASS_TABLE .'';
$sql .= ' GROUP BY class_name';
$result = $db->query($sql);
while ( $row = $db->fetch_record($result) )
{
// fixed by WalleniuM: $filter must be lower, because of the lower db entry!
$tpl->assign_block_vars('filter_row', array(
'VALUE' => $row['class_name'],
'SELECTED' => ( strtolower($filter) == strtolower($row['class_name']) ) ? ' selected="selected"' : '',
'OPTION' => ( !empty($row['class_name']) ) ? stripslashes($row['class_name']) : '(None)' )
);
}
if($eqdkp->config['default_game'] == 'WoW')
{
#DKP Pools
###########
$tpl->assign_block_vars('filter_row', array(
'VALUE' => strtolower("None"),
'SELECTED' => ( $filter == strtolower("NULL") ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', "--------")));
#Pool1: Rogue, Shaman, Paladin = 1,12,6,7
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=5)';
$a_filterIds[] = 'or (class_id=13)';
$a_filterIds[] = 'or (class_id=2)';
$a_filterIds[] = 'or (class_id=8)';
$a_filterIds[] = 'or (class_id=9)';
$poolsql_1 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool1','[Tier4+5 Pool1]');
#Pool2: Warrior, Priest, Druid = 1,12,6,7
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=1)';
$a_filterIds[] = 'or (class_id=12)';
$a_filterIds[] = 'or (class_id=6)';
$a_filterIds[] = 'or (class_id=7)';
$poolsql_2 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool2','[Tier4+5 Pool2]');
#Pool3: hunter, mage, = 3,4,11,10
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=3)';
$a_filterIds[] = 'or (class_id=4)';
$a_filterIds[] = 'or (class_id=11)';
$a_filterIds[] = 'or (class_id=10)';
$poolsql_3 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool3','[Tier4+5 Pool3]');
#Pool4: Tier6 warrior, hunter, shaman
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=3)';
$a_filterIds[] = 'or (class_id=4)';
$a_filterIds[] = 'or (class_id=1)';
$a_filterIds[] = 'or (class_id=12)';
$a_filterIds[] = 'or (class_id=8)';
$a_filterIds[] = 'or (class_id=9)';
$poolsql_4 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool4','[Tier6 Pool1]');
#Pool5: Tier6 rogue, mage, druid
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=2)';
$a_filterIds[] = 'or (class_id=11)';
$a_filterIds[] = 'or (class_id=7)';
$poolsql_5 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool5','[Tier6 Pool2]');
#Pool6: Tier6 Paladin, priest, warlock
###############################################
$a_filterIds = array();
$a_filterIds[] = '(class_id=5)';
$a_filterIds[] = 'or (class_id=13)';
$a_filterIds[] = 'or (class_id=6)';
$a_filterIds[] = 'or (class_id=10)';
$poolsql_6 = assing_filter_rows($a_filterIds,'filter_row',$filter,'pool6','[Tier6 Pool3]');
} #end if wow
$db->free_result($result);
// end database move of race/class/faction
// Build SQL query based on GET options
$sql = 'SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current,
member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class,
c.class_armor_type AS armor_type,
c.class_min_level AS min_level,
c.class_max_level AS max_level
FROM ' . MEMBERS_TABLE . ' m, ' . MEMBER_RANKS_TABLE . ' r, ' . CLASS_TABLE . ' c
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)';
if ($pm->check(PLUGIN_INSTALLED, 'charmanager'))
{
if (!defined('MEMBER_ADDITION_TABLE')) { define('MEMBER_ADDITION_TABLE', $table_prefix . 'member_additions'); }
$sql = 'SELECT m.*, ma.*, c.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current, m.member_id AS mid,
member_status, m.member_race_id, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix,
c.class_name AS member_class,
c.class_armor_type AS armor_type,
c.class_min_level AS min_level,
c.class_max_level AS max_level
FROM ' . MEMBER_RANKS_TABLE . ' r, ' . CLASS_TABLE . ' c, ' . MEMBERS_TABLE . ' m
LEFT JOIN ' . MEMBER_ADDITION_TABLE . ' ma ON (ma.member_id=m.member_id)
WHERE c.class_id = m.member_class_id
AND (m.member_rank_id = r.rank_id)';
}
if ( !empty($_GET['rank']) and validateRank($_GET['rank']) )
{
$sql .= " AND r.rank_name='" . urldecode($_GET['rank']) . "'";
}
if ( isset($query_by_class) && $query_by_class == '1' )
{
$sql .= " AND c.class_name = '$id'";
}
if ( isset($query_by_armor) && $query_by_armor == '1' )
{
$sql .= " AND c.class_armor_type = '".$temp_filter."'";
}
if ($filter == 'pool1'){$sql .= " AND ( $poolsql_1 )";}
if ($filter == 'pool2'){$sql .= " AND ( $poolsql_2 )";}
if ($filter == 'pool3'){$sql .= " AND ( $poolsql_3 )";}
if ($filter == 'pool4'){$sql .= " AND ( $poolsql_4 )";}
if ($filter == 'pool5'){$sql .= " AND ( $poolsql_5 )";}
if ($filter == 'pool6'){$sql .= " AND ( $poolsql_6 )";}
$sql .= ' ORDER BY '.$current_order['sql']; #original
if ( !($members_result = $db->query($sql)) )
{
message_die('Could not obtain member information', '', __FILE__, __LINE__, $sql);
}
//
// Member Schleife
//
while ( $row = $db->fetch_record($members_result) )
{
unset($event_data) ;
// Figure out the rank search URL based on show and filter
$u_rank_search = 'listmembers.php' . $SID . '&rank=' . urlencode($row['rank_name']);
$u_rank_search .= ( ($eqdkp->config['hide_inactive'] == 1) && (!$show_all) ) ? '&show=' : '&show=all';
$u_rank_search .= ( $filter != 'none' ) ? '&filter=' . $filter : '';
if($conf_plus['pk_attendance30']==1)
{
$individual_raid_count_30 = 0;
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$thirty_days.' AND '.time().')';
$individual_raid_count_30 = $db->query_first($rc_sql);
$percent_of_raids_30 = ( $raid_count_30 > 0 ) ? round(($individual_raid_count_30 / $raid_count_30) * 100) : 0;
}
if($conf_plus['pk_attendance60']==1)
{
$individual_raid_count_60 = 0;
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$sixty_days.' AND '.time().')';
$individual_raid_count_60 = $db->query_first($rc_sql);
$percent_of_raids_60 = ( $raid_count_30 > 0 ) ? round(($individual_raid_count_60 / $raid_count_60) * 100) : 0;
}
if($conf_plus['pk_attendance90']==1)
{
$individual_raid_count_90 = 0;
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')
AND (r.raid_date BETWEEN ".$ninety_days.' AND '.time().')';
$individual_raid_count_90 = $db->query_first($rc_sql);
$percent_of_raids_90 = ( $raid_count_90 > 0 ) ? round(($individual_raid_count_90 / $raid_count_90) * 100) : 0;
}
if($conf_plus['pk_attendanceAll']==1)
{
$individual_raid_count_all = 0;
$rc_sql = 'SELECT count(*)
FROM ' . RAIDS_TABLE . ' r, ' . RAID_ATTENDEES_TABLE . " ra
WHERE (ra.raid_id = r.raid_id)
AND (ra.member_name='".$row['member_name']."')";
$individual_raid_count_all = $db->query_first($rc_sql);
$percent_of_raids_all = ( $raid_count_all > 0 ) ? round(($individual_raid_count_all / $raid_count_all ) * 100) : 0;
}
if ( member_display($row) )
{
$member_count++;
$members_rows[$member_count] = $row;
$members_rows[$member_count]['u_rank_search'] = $u_rank_search;
$members_rows[$member_count]['member_count'] = $member_count;
$members_rows[$member_count]['individual_raid_count_30'] = $individual_raid_count_30;
$members_rows[$member_count]['individual_raid_count_60'] = $individual_raid_count_60;
$members_rows[$member_count]['individual_raid_count_90'] = $individual_raid_count_90;
$members_rows[$member_count]['individual_raid_count_all'] = $individual_raid_count_all;
$members_rows[$member_count]['percent_of_raids_30'] = $percent_of_raids_30;
$members_rows[$member_count]['percent_of_raids_60'] = $percent_of_raids_60;
$members_rows[$member_count]['percent_of_raids_90'] = $percent_of_raids_90;
$members_rows[$member_count]['percent_of_raids_all'] = $percent_of_raids_all;
$members_rows[$member_count]['last_loot'] = $last_loot;
$members_rows[$member_count]['member_earned'] = runden($row['member_earned']);
$members_rows[$member_count]['member_spent'] = runden($row['member_spent']);
$members_rows[$member_count]['member_adjustment'] = runden($row['member_adjustment']);
$members_rows[$member_count]['member_current'] = runden($row['member_current']);
// MultiDKP
// #####################################
//
if($conf_plus['pk_multidkp'] == 1)
{
//
// earned
// ###############################################################
$pv_sql = "SELECT " . RAIDS_TABLE .".raid_name, SUM(raid_value)
FROM
". RAID_ATTENDEES_TABLE ." LEFT JOIN " . RAIDS_TABLE ." ON ". RAID_ATTENDEES_TABLE .".raid_id=" . RAIDS_TABLE .".raid_id
WHERE ". RAID_ATTENDEES_TABLE .".member_name = '".$row['member_name']."' GROUP by " . RAIDS_TABLE .".raid_name";
$pv_result = $db->query($pv_sql);
while( $pv_row = $db->fetch_record($pv_result, false) )
{
$event_data[$pv_row[0]]['earned'] = $pv_row[1] ;
}
# end earned
###############################################################
//
// spend
// ###############################################################
$ps_sql = "SELECT ". RAIDS_TABLE .".raid_name, SUM(". ITEMS_TABLE .".item_value)
FROM
". ITEMS_TABLE ." LEFT JOIN ". RAIDS_TABLE ." ON ". ITEMS_TABLE .".raid_id=". RAIDS_TABLE .".raid_id
WHERE
". ITEMS_TABLE .".item_buyer = '".$row['member_name']."' GROUP by ". RAIDS_TABLE .".raid_name;";
$ps_result = $db->query($ps_sql);
while( $ps_row = $db->fetch_record($ps_result, false) )
{
$event_data[$ps_row[0]]['spend'] = $ps_row[1] ;
}
# end spend
###############################################################
//
// Adjust
// ###############################################################
$pa_sql = "SELECT adjustment_reason, adjustment_value, raid_name
FROM ". ADJUSTMENTS_TABLE . "
WHERE member_name = '".$row['member_name']."';";
#echo $pa_sql.'<br>' ;
$pa_result = $db->query($pa_sql);
while( $pa_row = $db->fetch_record($pa_result) )
{
$event_data[$pa_row['raid_name']]['adjust'] += $pa_row['adjustment_value'] ;
}
# end Adjust
###############################################################
//
// get MultiDKP Data from eqdkp_multidkp
$sql = 'SELECT multidkp_id, multidkp_name
FROM ' . MULTIDKP_TABLE ;
if ( !($multi_results = $db->query($sql)) )
{
message_die('Could not obtain MultiDKP information', '', __FILE__, __LINE__, $sql);
}
//
// Konten
// ###############################################################
$multicount = 0 ;
while ( $a_multi = $db->fetch_record($multi_results) )
{
$multicount++;
// namen speichern fürs template
$multi_name[$multicount]['name'] = $a_multi['multidkp_name'];
$multi_name[$multicount]['id'] = $a_multi['multidkp_id'];
$tempmultiname = $a_multi['multidkp_name']; // for the sort array
$members_rows[$member_count]['dkp_tooltip'] .= "Konto - ".$a_multi['multidkp_name']."<br>";
$sql_events = 'SELECT multidkp2event_multi_id, multidkp2event_eventname
FROM ' . MULTIDKP2EVENTS_TABLE
.' WHERE multidkp2event_multi_id ='.$a_multi['multidkp_id'] ;
if ( !($multi2event_results = $db->query($sql_events)) )
{
message_die('Could not obtain MultiDKP -> Event information ', '', __FILE__, __LINE__, $sql_events);
}
//Konten2Events
//Konten verknüpft mit Events den Multikonten des Member zuweisen
//###############################################################
// SmartTooltip
if ($conf_plus['pk_multiSmarttip'] == 1)
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
'<table cellpadding=2 cellspacing=10>
<tr>
<td>'.$user->lang['event'].'</td>
<td>'.$user->lang['earned'].'</td>
<td>'.$user->lang['spent'].'</td>
<td>'.$user->lang['adjustment'].'</td>
<td>'.$user->lang['current'].'</td>
</tr>';
}
while ( $a_multi = $db->fetch_record($multi2event_results) )
{ // gehe alle Events durch, die einem Konto zugewiesen wurden
$current = 0 ;
// current wert berechnen
// ###############################################################
$current = $event_data[$a_multi['multidkp2event_eventname']]['earned'] -
$event_data[$a_multi['multidkp2event_eventname']]['spend'] +
$event_data[$a_multi['multidkp2event_eventname']]['adjust'] ;
//Generate DKP Tooltip
//###############################################################
if ($conf_plus['pk_multiTooltip'] == 1) // Tooltip on/off
{
if ($conf_plus['pk_multiSmarttip'] == 1) // SmartTooltip
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
'<tr>
<td>'.$a_multi['multidkp2event_eventname']."</td>
<td><span class=".color_item($event_data[$a_multi['multidkp2event_eventname']]['earned'])."> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['earned'])."</span></td>
<td><span class=negative> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['spend'])."</span></td>
<td> <span class=".color_item($event_data[$a_multi['multidkp2event_eventname']]['adjust'])."> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['adjust'])."</span></td>
<td><span class=".color_item($current)."> "
.runden($current)."</span></td>
</tr> ";
}
else if ($conf_plus['pk_multiSmarttip'] == 0) // normal Tooltip)
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
'<span class=itemdesc>'.$user->lang['event'].': '.$a_multi['multidkp2event_eventname']."</span><br>" ;
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
" ".$user->lang['earned'].": <span class=".color_item($event_data[$a_multi['multidkp2event_eventname']]['earned'])."> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['earned'])."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
" ".$user->lang['spent'].": <span class=negative> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['spend'])."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
" ".$user->lang['adjustment'].": <span class=".color_item($event_data[$a_multi['multidkp2event_eventname']]['adjust'])."> "
.runden($event_data[$a_multi['multidkp2event_eventname']]['adjust'])."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
" ".$user->lang['current'].": <span class=".color_item($current)."> "
.runden($current)."</span><br><br>";
}
}
//Array for the template
//$member_count = spielernummer
//multicount = Account (konto)
//Die Werte werden einfach aufaddiert
//###############################################################
$members_rows_multidkp[$member_count][$multicount]['earned'] += runden($event_data[$a_multi['multidkp2event_eventname']]['earned']);
$members_rows_multidkp[$member_count][$multicount]['spend'] += runden($event_data[$a_multi['multidkp2event_eventname']]['spend']);
$members_rows_multidkp[$member_count][$multicount]['adjust'] += runden($event_data[$a_multi['multidkp2event_eventname']]['adjust']);
$members_rows_multidkp[$member_count][$multicount]['current'] += runden($current, 2);
}
// Generate the Sort string
$sort_current[strtolower($tempmultiname)][$member_count] = $members_rows_multidkp[$member_count][$multicount]['current'];
// Generate DKP Tooltip
// ###############################################################
if ($conf_plus['pk_multiTooltip'] == 1) // Tooltip on/off
{
if ($conf_plus['pk_multiSmarttip'] == 1) // SmartTooltip
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
'<tr>
<td><span class=itemdesc>'.$user->lang['Multi_total_cost'].": </span></td>
<td><span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['earned']).">"
.$members_rows_multidkp[$member_count][$multicount]['earned']."</span></td>
<td><span class=negative>"
.$members_rows_multidkp[$member_count][$multicount]['spend']."</span></td>
<td><span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['adjust']).">"
.$members_rows_multidkp[$member_count][$multicount]['adjust']."</span></td>
<td><span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['current']).">"
.$members_rows_multidkp[$member_count][$multicount]['current']."</span></td>
</tr> ";
}
else if ($conf_plus['pk_multiSmarttip'] == 0) // normal Tooltip)
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .=
"<span class=itemdesc><b>".$user->lang['Multi_total_cost'].":</b> </span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .= " ".$user->lang['earned'].": <span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['earned']).">"
.$members_rows_multidkp[$member_count][$multicount]['earned']."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .= " ".$user->lang['spent'].": <span class=negative>"
.$members_rows_multidkp[$member_count][$multicount]['spend']."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .= " ".$user->lang['adjustment'].": <span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['adjust']).">"
.$members_rows_multidkp[$member_count][$multicount]['adjust']."</span><br>";
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .= " ".$user->lang['current'].": <span class="
.color_item($members_rows_multidkp[$member_count][$multicount]['current']).">"
.$members_rows_multidkp[$member_count][$multicount]['current']."</span><br>";
} // end if smart tooltip
} // end if tooltip
if ($conf_plus['pk_multiSmarttip'] == 1 and $conf_plus['pk_multiTooltip'] == 1)
{
$members_rows_multidkp[$member_count][$multicount]['dkp_tooltip'] .= '</table>';
}
}; // end while konten
} ; // End If MultiDKP
###############################################################
// If the member's spent is greater than 0, see how long ago they looted an item
if ( $row['member_spent'] > 0 and $conf_plus['pk_lastloot']==1)
{
$ll_sql = 'SELECT max(item_date) AS last_loot
FROM ' . ITEMS_TABLE . "
WHERE item_buyer='".$row['member_name']."'";
$last_loot = $db->query_first($ll_sql);
$members_rows[$member_count]['last_loot'] = $last_loot ;
}
#$tpl->assign_block_vars('members_row', $line_array );
$u_rank_search = '';
unset($last_loot);
// 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];
}
}
if(trim(strtolower($_GET['sortorder'])) == 'asc'){
$_GET['sortorder'] = 'desc';
$plus_sortorder = SORT_ASC;
}else{
$_GET['sortorder'] = 'asc';
$plus_sortorder = SORT_DESC;
}
if (isset($_GET['sortby'])){
$members_rows_fsort = array();
$sort_value = trim(strtolower($_GET['sortby']));
if(isset($sort_current[$sort_value]))
{
foreach($sort_current[$sort_value] as $key => $row)
{
$members_rows_fsort[$key] = intval($row);
}
array_multisort($members_rows_fsort, $plus_sortorder, SORT_NUMERIC, $members_rows);
}
}
if(isset($members_rows))
{
foreach($members_rows as $row)
{
// class img
$mclass = renameClasstoenglish($row['member_class']) ;
$rankimg = get_RankIcon($row['rank_name']);
$class_icon = get_classImgListmembers($row['member_class'] , $row['member_class_id']) ;
$race_icon = get_RaceIcon($row['member_race_id'],$row['member_name'] );
$rank_icon = get_RankIcon($row['rank_name']);
$class_icons_text = $race_icon.$class_icon." ".$row['member_class'];
$skill = "";
# Amory Link code by Wallenium
#####################################
if(isset($conf_plus['pk_servername']) && isset($conf_plus['pk_server_region']) && $eqdkp->config['default_game'] == 'WoW')
{
include_once($eqdkp_root_path.'pluskernel/include/armory.class.details.php');
$armory_light = new ArmoryCharLoader('äüö');
// build the link: $armory_light->BuildLink($conf_plus['pk_server_region'], $row['member_name'], $conf_plus['pk_servername'])
$menulink = array();
$menulink[1] = $armory_light->BuildLink($conf_plus['pk_server_region'], $row['member_name'], $conf_plus['pk_servername']);
$menulink[2] = $armory_light->BuildLink($conf_plus['pk_server_region'], $row['member_name'], $conf_plus['pk_servername'], 'talent');
if(($pm->check(PLUGIN_INSTALLED, 'charmanager')) and ($row['member_id'] > 0))
{
if (!defined('MEMBER_ADDITION_TABLE')) { define('MEMBER_ADDITION_TABLE', $table_prefix . 'member_additions'); }
$ma_sql = 'SELECT guild
FROM ' . MEMBER_ADDITION_TABLE . "
WHERE id =".$row['member_id'];
$guild = $db->query_first($ma_sql);
$menulink[3] = ($guild) ? $armory_light->BuildLink($conf_plus['pk_server_region'], $guild, $conf_plus['pk_servername'], 'guild') : '';
$ma_sql = 'SELECT last_update
FROM ' . MEMBER_ADDITION_TABLE . "
WHERE id =".$row['member_id'];
$last_update = date($user->lang['uc_changedate'],$db->query_first($ma_sql));
$skill = get_wow_talent_spec(ucwords(renameClasstoenglish($row['member_class'])), $row['skill_1'],$row['skill_2'] ,$row['skill_3'], $row['member_name'], $last_update);
}
$tpl->assign_vars(array('SHOW_AMORY' => TRUE));
}# end if
$line_array = array(
'ROW_CLASS' => $eqdkp->switch_row_class(),
'ID' => $row['member_id'],
//'COUNT' => ($row[$previous_source] == $previous_data) ? ' ' : $member_count,
'COUNT' => $row['member_count'],
'NAME' => $row['rank_prefix'] . (( $row['member_status'] == '0' ) ? '<i>' . $row['member_name'] . '</i>' : $row['member_name']) . $row['rank_suffix'],
'RANK' => ( !empty($row['rank_name']) ) ? (( $row['rank_hide'] == '1' ) ? '<i>' . '<a href="'.$u_rank_search.'">' . '</a>' . '</i>' : '<a href="'.$u_rank_search.'">' .$rank_icon.'</a>') : ' ',
'RAICON' => ( !empty($row['rank_name']) ) ? $row['rank_name'] : ' ',
'LEVEL' => ( $row['member_level'] > 0 ) ? $row['member_level'] : ' ',
'CLASS' => ( !empty($row['member_class']) ) ? $class_icons_text : ' ',
'CLASS_ICONS' => $class_icon.$race_icon ,
'CLASSENG' => (!strpos(strtolower($eqdkp->config['default_game']),'wow') > 0 ) ? get_classColorChecked($mclass) : '',
#'CLASSENG' => $mclass,
'ARMOR' => ( !empty($row['armor_type']) ) ? $row['armor_type'] : ' ',
'EARNED' => runden($row['member_earned']),
'SPENT' => runden($row['member_spent']),
'ADJUSTMENT' => runden($row['member_adjustment']),
'CURRENT' => runden($row['member_current']),
'RAIDS_30_DAYS' => $row['percent_of_raids_30'],
'RAIDS_60_DAYS' => $row['percent_of_raids_60'],
'RAIDS_90_DAYS' => $row['percent_of_raids_90'],
'RAIDS_ALL' => $row['percent_of_raids_all'],
'RAIDS_30_DAYS_C' => $row['individual_raid_count_30'],
'RAIDS_60_DAYS_C' => $row['individual_raid_count_60'],
'RAIDS_90_DAYS_C' => $row['individual_raid_count_90'],
'RAIDS_ALL_C' => $row['individual_raid_count_all'],
'FIRE' => ( $row['fir'] ) ? $row['fir'] : 0,
'ARCANE' => ( $row['ar'] ) ? $row['ar'] : 0,
'FROST' => ( $row['frr'] ) ? $row['frr'] : 0,
'NATURE' => ( $row['nr'] ) ? $row['nr'] : 0,
'SHADOW' => ( $row['sr'] ) ? $row['sr'] : 0,
'SKILL' => ( $skill ) ? $skill : "" ,
'BLASC_ID' => $row['blasc_id'],
'CTPROFILE_ID' => $row['ct_profile'],
'ALLA_ID' => $row['allakhazam'],
'CURSE_ID' => $row['curse_profiler'],
'TALENT_URL' => $row['talentplaner'],
'SHOW_BLASC' => ( $row['blasc_id'] ) ? true : false,
'SHOW_CTPROFILE' => ( $row['ct_profile'] ) ? true : false,
'SHOW_ALLA' => ( $row['allakhazam'] ) ? true : false,
'SHOW_CURSE' => ( $row['curse_profiler'] ) ? true : false,
'SHOW_TALENT' => ( $row['talentplaner'] ) ? true : false,
'ARMORY_LINK1' => $menulink[1],
'ARMORY_LINK2' => $menulink[2],
'ARMORY_LINK3' => $menulink[3],
'LASTRAID' => ( !empty($row['member_lastraid']) ) ? date($user->style['date_notime_short'], $row['member_lastraid']) : ' ',
'LASTLOOT' => ( isset($row['last_loot']) ) ? date($user->style['date_notime_short'], $row['last_loot']) : ' ',
'C_ADJUSTMENT' => color_item($row['member_adjustment']),
'C_CURRENT' => color_item($row['member_current']),
'C_LASTRAID' => 'neutral',
'C_RAIDS_30_DAYS' => color_item($row['percent_of_raids_30'], true),
'C_RAIDS_60_DAYS' => color_item($row['percent_of_raids_60'], true),
'C_RAIDS_90_DAYS' => color_item($row['percent_of_raids_90'], true),
'C_RAIDS_ALL' => color_item($row['percent_of_raids_all'], true),
'U_VIEW_MEMBER' => 'viewmember.php'.$SID . '&' . URI_NAME . '='.$row['member_name'] . '" class="' . $mclass
);
$tpl->assign_block_vars('members_row', $line_array );
// MultiDKP dynamic DKP Data
// ############################
//
if(!empty($members_rows_multidkp[$row['member_count']]))
{
foreach ($members_rows_multidkp[$row['member_count']] as $key)
{
// Build Data Array
//
$multidkp_array = array(
'EARNED' => $key['earned'] ,
'SPENT' => $key['spend'] ,
'ADJUST' => $key['adjust'] ,
'CURRENT' => $html->ToolTip($key['dkp_tooltip'],$key['current']) ,
'C_EARNED' => color_item($key['earned']) ,
'C_SPENT' => color_item($key['spend']) ,
'C_ADJUST' => color_item($key['adjust']) ,
'C_CURRENT' => color_item($key['current'])
);
$tpl->assign_block_vars('members_row.multidkp',$multidkp_array );
} # end for each
}# end if
} # end foreach member row
} # end if isset($members)
$uri_addon = ''; // Added to the end of the sort links
$uri_addon .= '&filter=' . urlencode($filter);
$uri_addon .= '&multifilter=' . urlencode($multifilter);
$uri_addon .= ( isset($_GET['show']) ) ? '&show=' . htmlspecialchars(strip_tags($_GET['show']), ENT_QUOTES) : '';
if ( ($eqdkp->config['hide_inactive'] == 1) && (!$show_all) )
{
$footcount_text = sprintf($user->lang['listmembers_active_footcount'], $member_count,
'<a href="listmembers.php' . $SID . '&'
. URI_ORDER . '=' . $current_order['uri']['current'] . '&show=all" class="rowfoot">');
}
else
{
$footcount_text = sprintf($user->lang['listmembers_footcount'], $member_count);
}
$db->free_result($members_result);
//leaderboard
if ($conf_plus['pk_leaderboard'] == 1)
{
// Load Default Leaderboard Pool from Plus Config
if(($conf_plus['pk_default_multi'] <> 'none') and isset($conf_plus['pk_default_multi']) and ($multifilter =='none')){
$dkpplus->showDKPLeaderboard($conf_plus['pk_default_multi']);
}
else{
$dkpplus->showDKPLeaderboard($multifilter);
$dkpplus->showDKPLeaderboard($multifilter);
$dkpplus->showDKPLeaderboard($multifilter);
$dkpplus->showDKPLeaderboard($multifilter);
}
}
}
$collspan = 20;
// Write Headerdata to template
// build dynamic collums
// set the Headertitle and Overlib !!
if(!empty($multi_name))
{
foreach ($multi_name as $key)
{
$collspan++;
$sql = 'SELECT multidkp2event_eventname
FROM ' . MULTIDKP2EVENTS_TABLE
.' WHERE multidkp2event_multi_id ='.$key['id'] ;
if ( !($multi2event_results = $db->query($sql)) )
{
message_die('Could not obta in MultiDKP -> Event information', '', __FILE__, __LINE__, $sql_events);
}
$multi2event = $user->lang['Multi_menuentry'].' '.$user->lang['Multi_event'].' <br/> <br/> ' ;
while ( $a_multi = $db->fetch_record($multi2event_results) )
{ // gehe alle Events durch, die einem Konto zugewiesen wurden
$multi2event .= $a_multi['multidkp2event_eventname'].' <br/> ' ;
}
if(isset($multifilter))
{
$multiuri = '&multifilter='.$multifilter ;
}
if(isset($_GET['filter']))
{
$sortlink_header = 'listmembers.php'.$SID.'&sortby='.urlencode($key['name']).'&sortorder='.$_GET['sortorder'].'&filter='.$_GET['filter'].$multiuri;
}
else
{
$sortlink_header = 'listmembers.php'.$SID.'&sortby='.urlencode($key['name']).'&sortorder='.$_GET['sortorder'].$multiuri;
}
$tpl->assign_block_vars('custom_header', array('HEADER_DISC' =>
"<a href='".$sortlink_header."' onMouseOver=\"overlib('<b>".$user->lang['Multi_events']."</b>".$multi2event."');\" onMouseOut='nd();'>".$key['name']."</a> " ));
}
}
$tpl->assign_vars(array(
'F_MEMBERS' => 'listmembers.php'.$SID,
'V_SID' => str_replace('?' . URI_SESSION . '=', '', $SID),
'SHOW_LEADERB' => ( $conf_plus['pk_leaderboard'] == 1 )? true : false,
'SHOW_RANK' => ( $conf_plus['pk_rank'] == 1 )? true : false,
'SHOW_LEVEL' => ( $conf_plus['pk_level'] == 1 )? true : false,
'SHOW_ATTEND_ALL' => ( $conf_plus['pk_attendanceAll'] == 1 )? true : false,
'SHOW_ATTEND_90' => ( $conf_plus['pk_attendance90'] == 1 )? true : false,
'SHOW_ATTEND_60' => ( $conf_plus['pk_attendance60'] == 1 )? true : false,
'SHOW_ATTEND_30' => ( $conf_plus['pk_attendance30'] == 1 )? true : false,
'SHOW_LASTLOOT' => ( $conf_plus['pk_lastloot'] == 1 )? true : false,
'SHOW_LASTRAID' => ( $conf_plus['pk_lastraid'] == 1 )? true : false,
'SHOW_CLASS' => ( $conf_plus['pk_showclasscolumn'] == 1 )? true : false,
'SHOW_CMC_SKILL' => ( $conf_plus['pk_show_skill'] == 1 )? true : false,
'SHOW_CMC_ARKAN' => ( $conf_plus['pk_show_arkan_resi'] == 1 )? true : false,
'SHOW_CMC_FIRE' => ( $conf_plus['pk_show_fire_resi'] == 1 )? true : false,
'SHOW_CMC_NATURE' => ( $conf_plus['pk_show_nature_resi'] == 1 )? true : false,
'SHOW_CMC_ICE' => ( $conf_plus['pk_show_ice_resi'] == 1 )? true : false,
'SHOW_CMC_SHADOW' => ( $conf_plus['pk_show_shadow_resi'] == 1 )? true : false,
'SHOW_CMC_PROFILES' => ( $conf_plus['pk_show_profiles'] == 1 )? true : false,
'L_FILTER' => $user->lang['filter'],
'L_NAME' => $user->lang['name'],
'L_RANK' => $user->lang['rank'],
'L_LEVEL' => $user->lang['level'],
'L_CLASS' => $user->lang['class'],
'L_ARMOR' => $user->lang['armor'],
'L_EARNED' => $user->lang['earned'],
'L_SPENT' => $user->lang['spent'],
'L_ADJUSTMENT' => $user->lang['adjustment'],
'L_CURRENT' => $user->lang['current'],
'L_LASTRAID' => $user->lang['lastraid'],
'L_LASTLOOT' => $user->lang['lastloot'],
'L_RAIDS_30_DAYS' => sprintf($user->lang['raids_x_days'], 30),
'L_RAIDS_60_DAYS' => sprintf($user->lang['raids_x_days'], 60),
'L_RAIDS_90_DAYS' => sprintf($user->lang['raids_x_days'], 90),
'L_RAIDS_ALL' => 'Lifetime',
'L_SKILL' => $user->lang['uc_tab_skills'],
'L_ARCANE' => $user->lang['uc_res_arcane'],
'L_FIRE' => $user->lang['uc_res_fire'],
'L_NATURE' => $user->lang['uc_res_nature'],
'L_FROST' => $user->lang['uc_res_frost'],
'L_SHADOW' => $user->lang['uc_res_shadow'],
'L_PROFILE' => $user->lang['uc_ext_profile'],
'L_BUFFED' => $user->lang['uc_buffed'],
'L_ALLAKHAZAM' => $user->lang['uc_allakhazam'],
'L_CTPROFILES' => $user->lang['uc_ctprofiles'],
'L_CURSEPROFILES' => $user->lang['uc_curse_profiler'],
'L_TALENTPLANER' => $user->lang['uc_talentplaner'],
'L_ARMORY_LINK1' => $user->lang['lm_armorylink1'],
'L_ARMORY_LINK2' => $user->lang['lm_armorylink2'],
'L_ARMORY_LINK3' => $user->lang['lm_armorylink3'],
'BUTTON_NAME' => 'submit',
'BUTTON_VALUE' => $user->lang['compare_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],
'O_LASTLOOT' => $current_order['uri'][10],
'O_FROST' => $current_order['uri'][11],
'O_ARCANE' => $current_order['uri'][12],
'O_SHADOW' => $current_order['uri'][13],
'O_NATURE' => $current_order['uri'][14],
'O_FIRE' => $current_order['uri'][15],
'URI_ADDON' => $uri_addon,
'PAGE_HASH' => $cur_hash,
'GIVEN_MULTIFILTER' => $multifilter ,
'GIVEN_FILTER' => $filter ,
'U_LIST_MEMBERS' => 'listmembers.php' . $SID . '&',
'S_COMPARE' => $s_compare,
'S_NOTMM' => true,
'COLSPAN' => $collspan ,
'LEADERBOARD_2ROW' => ( $conf_plus['pk_leaderboard_2row'] == 1 )? true : false,
'LISTMEMBERS_FOOTCOUNT' => ( isset($_GET['compare']) ) ? sprintf($footcount_text, sizeof(explode(',', $compare_ids))) : $footcount_text)
);
if(!$pm->check(PLUGIN_INSTALLED, 'charmanager'))
{
$tpl->assign_vars(array(
'SHOW_CMC_PROFILES' => false,
'SHOW_CMC_SKILL' => false,
'SHOW_CMC_ARKAN' => false,
'SHOW_CMC_FIRE' => false,
'SHOW_CMC_NATURE' => false,
'SHOW_CMC_ICE' => false,
'SHOW_CMC_SHADOW' => false
));
}
$tpl->assign_vars(array(
'U_COMPARE_MEMBERS' => 'listmembers.php' . $SID . '&')
);
$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)
);
function member_display(&$row)
{
global $eqdkp;
global $query_by_armor, $query_by_class, $filter, $filters, $show_all, $id, $query_by_pool;
// Replace space with underscore (for array indices)
// Damn you Shadow Knights!
$d_filter = ucwords(str_replace('_', ' ', $filter));
$d_filter = str_replace(' ', '_', $d_filter);
$member_display = null;
// We're filtering based on class
if ( $filter != 'none' )
{
if ( $query_by_class == 1 )
{
// Check for valid level ranges
$member_display = ( ($row['member_class'] == $id && $row['member_status'] != '0') ) ? true : false;
}
elseif ( $query_by_armor == 1 )
{
$rows = strtolower($row['armor_type']);
// Check for valid level ranges
if ( $row['member_level'] > $row['min_level'] && $row['member_level'] <= $row['max_level'] && $row['member_status'] != '0' )
{
$member_display = ( $rows == $id ) ? true : false;
}
}
elseif ($query_by_pool == 1)
{
$member_display = true ;
}
}
else
{
// Are we showing all?
if ( $show_all )
{
$member_display = true;
}
else
{
// Are we hiding inactive members?
if ( $eqdkp->config['hide_inactive'] == '0' )
{
//Are we hiding their rank?
$member_display = ( $row['rank_hide'] == '0' ) ? true : false;
}
else
{
// Are they active?
if ( $row['member_status'] == '0' )
{
$member_display = false;
}
else
{
$member_display = ( $row['rank_hide'] == '0' ) ? true : false;
} // Member inactive
} // Not showing inactive members
} // Not showing all
} // Not filtering by class
return $member_display;
}
function validateCompareInput($input)
{
// Remove codes from the list, like "%20"
$retval = urldecode($input);
// Remove anything that's not a comma or alpha-numeric
$retval = preg_replace('#[^A-Za-z0-9\,]#', '', $retval);
// Remove any extra commas as a result of removing bogus entries above
$retval = str_replace(',,', ',', $retval);
// Remove a trailing blank entry
$retval = preg_replace('#,$#', '', $retval);
return $retval;
}
// Assure $_GET['rank'] is one of our ranks
function validateRank($rank)
{
global $db;
$retval = false;
$sql = "SELECT rank_id, rank_name
FROM " . MEMBER_RANKS_TABLE;
$result = $db->query($sql);
while ( $row = $db->fetch_record($result) )
{
if ( $row['rank_id'] == $rank || $row['rank_name'] == $rank )
{
$retval = true;
}
}
$db->free_result($result);
return $retval;
}
function assing_filter_rows($a_filterIds, $to_assingVar='', $filter='',$value='', $name)
{
global $db,$tpl;
$sql = 'SELECT class_name, class_id, class_min_level, class_max_level FROM ' . CLASS_TABLE .'';
$implodestring = implode(' ',$a_filterIds);
$sql .= ' WHERE '. $implodestring ;
$result = $db->query($sql);
if($result)
{
$poo1 = array();
while ( $row = $db->fetch_record($result) )
{
$poo1[] = $row['class_name'];}
$poo1_classes = $name.' ';
foreach(array_unique($poo1) as $key)
{
$poo1_classes .= $key.", ";
}
$tpl->assign_block_vars($to_assingVar, array(
'VALUE' => $value,
'SELECTED' => ( strtolower($filter) == strtolower($value) ) ? ' selected="selected"' : '',
'OPTION' => ( !empty($poo1_classes) ) ? stripslashes($poo1_classes) : '(None)' )
);
}
return $implodestring ;
}
?>
ASKER
Hi, I have been commenting out lines via logical trial and error for hours before entering this question. But now, armed with the $Multifilti info I'll give it another few shots and let you know, thanks.
emsee_w:
The easiest way to find out what you need is to work backwards from that one line you are interested in that uses $Multifilti. Look at each variable that is needed to create $Multifilti, and then what functions or variables used to create those variables.
The easiest way to find out what you need is to work backwards from that one line you are interested in that uses $Multifilti. Look at each variable that is needed to create $Multifilti, and then what functions or variables used to create those variables.
ASKER
Thats the plan, thanks for that, I'll try this tonight (been flat out) and see how I go, then I'll award the points to you right after. Thanks again for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your welcome. Best of luck.
That one line of code uses the variable $multifilter from lines 252 & 253. If it's not set then nothing will work. The variable $multifilter depends on other things, so it's a chain of things that have to happen for the single line of code to work. My suggestion would be to copy the entire .php file to a new one, rather than copy the single line. You can then comment out sections (rather than delete) to see what the effect is. Commenting out allows you to uncomment code you need rather than retyping it if it needs to be included for the statement to work. Work backwards from the line you pasted and look at all the variables that were used so that $multifilter could be created.
Good luck in your project. Let me know if you need more help.
JRA