| '.$user->lang['event'].' |
'.$user->lang['earned'].' |
'.$user->lang['spent'].' |
'.$user->lang['adjustment'].' |
'.$user->lang['current'].' |
';
}
$multi2event_results = get_events_for_poolid($sortID);
reset($multi2event_results);
while ( list($unused_key, $a_multi) = each($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)
{
if ($conf_plus['pk_multiSmarttip'] == 1) // SmartTooltip
{
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
"
| ".$a_multi['multidkp2event_eventname']." |
"
.runden($event_data[$a_multi['multidkp2event_eventname']]['earned'])." |
"
.runden($event_data[$a_multi['multidkp2event_eventname']]['spend'])." |
"
.runden($event_data[$a_multi['multidkp2event_eventname']]['adjust'])." |
"
.runden($current)." |
";
}
else if ($conf_plus['pk_multiSmarttip'] == 0)
{
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
''.$user->lang['event'].': '.$a_multi['multidkp2event_eventname']."
" ;
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
" ".$user->lang['earned'].": "
.runden($event_data[$a_multi['multidkp2event_eventname']]['earned'])."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
" ".$user->lang['spent'].": "
.runden($event_data[$a_multi['multidkp2event_eventname']]['spend'])."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
" ".$user->lang['adjustment'].": "
.runden($event_data[$a_multi['multidkp2event_eventname']]['adjust'])."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
" ".$user->lang['current'].": "
.runden($current)."
";
} // end normal tooltip
} // end tooltip
//Array for the template
//multicount = Account (konto)
//Die Werte werden einfach aufaddiert
$members_rows_multidkp[$row['member_name']]['earned'] += runden($event_data[$a_multi['multidkp2event_eventname']]['earned']);
$members_rows_multidkp[$row['member_name']]['spend'] += runden($event_data[$a_multi['multidkp2event_eventname']]['spend']);
$members_rows_multidkp[$row['member_name']]['adjust'] += runden($event_data[$a_multi['multidkp2event_eventname']]['adjust']);
$members_rows_multidkp[$row['member_name']]['current'] += runden($current);
}
$members_rows_multidkp[$row['member_name']]['name']=$row['member_name'];
$members_rows_multidkp[$row['member_name']]['rank_hide']=$row['rank_hide'];
$members_rows_multidkp[$row['member_name']]['class_id']=$row['member_class_id'];
#create sepperate array to sort the shit
#$sort_current[$row['member_name']] = $members_rows_multidkp[$row['member_name']]['current'];
// Generate DKP Tooltip
// ###############################################################
if ($conf_plus['pk_multiTooltip'] == 1) // Tooltip on/off
{
if ($conf_plus['pk_multiSmarttip'] == 1) // SmartTooltip
{
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
"
| ".$user->lang['Multi_total_cost'].": |
"
.$members_rows_multidkp[$row['member_name']]['earned']." |
"
.$members_rows_multidkp[$row['member_name']]['spend']." |
"
.$members_rows_multidkp[$row['member_name']]['adjust']." |
"
.$members_rows_multidkp[$row['member_name']]['current']." |
";
}
else if ($conf_plus['pk_multiSmarttip'] == 0 ) // normal Tooltip)
{
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .=
"".$user->lang['Multi_total_cost'].":
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .= " ".$user->lang['earned'].": "
.$members_rows_multidkp[$row['member_name']]['earned']."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .= " ".$user->lang['spent'].": "
.$members_rows_multidkp[$row['member_name']]['spend']."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .= " ".$user->lang['adjustment'].": "
.$members_rows_multidkp[$row['member_name']]['adjust']."
";
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .= " ".$user->lang['current'].": "
.$members_rows_multidkp[$row['member_name']]['current']."
";
}
}
if ($conf_plus['pk_multiSmarttip'] == 1 and $conf_plus['pk_multiTooltip'] == 1)
{
$members_rows_multidkp[$row['member_name']]['dkp_tooltip'] .= '
';
}
} #end while row
$dkp_sort = array();
#Temp Array |Member | DKP
if(isset($members_rows_multidkp))
{
foreach($members_rows_multidkp as $key => $row)
{
$dkp_sort[$key] = $row['current'];
}
}
#Sort by DKP
if(isset($members_rows_multidkp) and isset($dkp_sort))
{
array_multisort($dkp_sort, SORT_DESC, SORT_NUMERIC, $members_rows_multidkp);
}
return $members_rows_multidkp ;
} // end function
##########################################
/**
* Erzeugt
*
* @param unknown_type $multifilter
*/
function showDKPLeaderboard($multifilter)
{
// get needed global vars
global $query_by_rank, $id, $eqdkp, $db, $tpl, $SID, $conf_plus, $htmlPlus, $filter, $dkpplus, $html, $pdc;
// Max players listed per class (0 = all)
define('MAXLIST', $conf_plus['pk_leaderboard_limit']);
$tpl->assign_vars(array('NORMAL_LEADERBOARD' => !$conf_plus['pk_leaderboard_normal']));
if ($conf_plus['pk_multidkp'] == 1)
{
$sql = 'SELECT multidkp_name, multidkp_disc, multidkp_id
FROM ' . MULTIDKP_TABLE . '
WHERE multidkp_name IS NOT NULL'
;
if ( !($multi_result = $db->query($sql)) )
{
message_die('Could not obtain Leaderboard MultiDKP information', '', __FILE__, __LINE__, $sql);
}
$tpl->assign_block_vars('multi_row', array(
'VALUE' => "0",
'SELECTED' => ( $filter == strtolower("None") ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', "None"))
);
// Add in the cute ---- line, filter on None if some idiot selects it
$tpl->assign_block_vars('multi_row', array(
'VALUE' => "0",
'SELECTED' => ( $filter == strtolower("NULL") ) ? ' selected="selected"' : '',
'OPTION' => str_replace('_', ' ', "--------")));
$showmultifilter = '';
while ( $row = $db->fetch_record($multi_result) )
{
$tpl->assign_block_vars('multi_row', array(
'VALUE' => $row['multidkp_id'],
'SELECTED' => ( strtolower($multifilter) == strtolower($row['multidkp_id']) ) ? ' selected="selected"' : '',
'OPTION' => ( !empty($row['multidkp_name']) ) ? stripslashes($row['multidkp_name']) : '(None)' )
);
if(strtolower($multifilter) == strtolower($row['multidkp_id']))
{
$showmultifilter = " - ". stripslashes($row['multidkp_name']) ;
}
}
$tpl->assign_vars(array('SHOW_MULTI' => true,
'SHOW_MULTI_FILTER' => $showmultifilter,));
#Multifilter = Kontoname z.b. Tier4
if(isset($multifilter) and ( strtoupper($multifilter ) <> 'NONE') and ($multifilter <> '--------') and $multifilter > 0)
{
// create the multiDKP Array
//now with pdc cache
$member_multidkp = $pdc->get('dkp.listmember.leaderboard.'.$multifilter,false,true);
if (!$member_multidkp)
{
$member_multidkp = $this-> multiDkpAllMemberArray($multifilter) ;
$pdc->put('dkp.listmember.leaderboard.'.$multifilter,$member_multidkp,86400,false,true);
}
if(!empty($member_multidkp))
{
# create temp array mit den klassen dann den membern
# damit wir später ein array haben -> array[klassen][member]
$a_member_class = array();
$a_classes_temp = array();
foreach($member_multidkp as $key => $value)
{
$a_member_class[$value['class']][] = $value;
$a_classes_temp[$value['class']] = $value['class_id'];
}
$a_classes = array();
#gehe durch die klassen und setze die header
foreach ($a_member_class as $key => $value)
{
if (!array_search(strtolower($key),$a_classes) and (strtolower($key) <> 'unknown'))
{
$a_classes[] = strtolower($key);
$tpl->assign_block_vars('classheader_row', array(
'ICON' => get_ClassIcon($key,$a_classes_temp[$key]),
'ROW_CLASS' => $eqdkp->switch_row_class(),
'NAME_ENG' => get_classColorChecked($key),
'ROW' => $eqdkp->switch_row_class(),
'PERCENT' => 0,
'NAME' => $key));
}
#gehe durch die member in den klassen
$membercount = 0 ;
foreach ($value as $data)
{
$skip = false;
$classcounte[$data['class']]++;
if(($conf_plus['pk_leaderboard_limit'] == '') or ($conf_plus['pk_leaderboard_limit'] == 0)) {
$max = 999;
}
else
{
$max = intval($conf_plus['pk_leaderboard_limit']);
}
if($classcounte[$data['class']] > $max )
{$skip=true;}
if(strtolower($data['class']) == 'unknown' )
{$skip=true;}
if($data['rank_hide']==1) {
$skip=true;}
if($conf_plus['pk_leaderboard_hide_zero']==1)
{
if($data['current'] == 0)
{$skip = true ;}
}
if(!$skip)
{
$class = 'classheader_row.classlist_row' ;
$tpl->assign_block_vars($class, array(
'NAME' => $html->ToolTip($data['dkp_tooltip'],get_coloredLinkedName($data['name'])) ,
'CURRENT' => $html->ToolTip($data['dkp_tooltip'],$data['current']) ,
'C_CURRENT' => color_item(round($data['current'])),
'U_VIEW_MEMBER' => 'viewmember.php' . $SID . '&' . URI_NAME . '='.$data['name'])
);
$membercount++;
}
}# end for each member
$a_member_count[] = $membercount;
}; # end for each classes
$maxhigh = round((max($a_member_count)*2.2));
//Define the maximum height of the dynamicleaderboard
$tpl->assign_vars(array('MAX_HIGH' => $maxhigh
));
}; # end if empty
}; # end if set filter
}
else # kein multidkp -> normale ansicht
{
// select the classes (distinct: for only once)
$sql= 'SELECT DISTINCT class_name, class_id FROM '. CLASS_TABLE;
$classes = $db->query($sql);
while ( $class_row = $db->fetch_record($classes) )
{
if(strtolower($class_row['class_name']) <> 'unknown')
{
// build sql string
$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)
AND c.class_name = '".$class_row['class_name']."'
AND rank_hide = '0'";
if ( isset($query_by_rank) && $query_by_rank == '1' )
{
$sql .= " AND r.rank_name = '$id'";
}
// Are we hiding inactive members?
if ( $eqdkp->config['hide_inactive'] == '1' )
$sql .= " AND member_status <> '0'";
$sql .= ' GROUP BY m.member_id'; #workaround for double members
$sql .= " ORDER BY member_current desc";
// add limit if set
if(MAXLIST > 0)
{$sql .= " LIMIT 0,".MAXLIST;}
if ($class_result = $db->query($sql))
{
#show only if membercount in a class is > 0
$clas_count = $db->num_rows($class_result) ;
$j = 1;
if ($clas_count > 0)
{
// create the header row
$tpl->assign_block_vars('classheader_row', array(
'ICON' => get_ClassIcon($class_row['class_id']),
'ROW_CLASS' => $eqdkp->switch_row_class(),
'NAME_ENG' => get_classColorChecked($class_row['class_name']),
'NAME' => $class_row['class_name'],
'PERCENT' => 100/$clas_count,
'ROW' =>$eqdkp->switch_row_class(),
));
$j++;
// produce output
$membercount = 0 ;
while ( $row = $db->fetch_record($class_result) )
{
if((intval(round($row['member_current'])) == 0 ) and ($conf_plus['pk_leaderboard_hide_zero']==1))
{
//hide member with zero DKP
}else
{
$tpl->assign_block_vars('classheader_row.classlist_row', array(
'NAME' => $row['rank_prefix'] . (( $row['member_status'] == '0' ) ? '