';
for($i = 0; $i < count($mode_types_text); $i++)
{
$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
$select_sort_mode .= '';
}
$select_sort_mode .= '';
$select_sort_order = '';
//
// Generate page
//
$page_title = "Character Roster";
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'characters_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx);
$button = ($userdata['username'] != "Anonymous") ? "" : "";
$template->assign_vars(array(
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_UNAME' => "Forum Username",
'L_CNAME' => "Character Name",
'L_RANK' => "PvP Rank",
'L_LEVEL' => "Level",
'L_CLASS' => "Class",
'L_RACE' => "Race",
'L_PROF' => "Professions",
'L_MCDKP' => "MC Dkp",
'L_ZGDKP' => "ZG Dkp",
'L_MCR' => "MC Runs",
'L_ZGR' => "ZG Runs",
'BUTTON' => $button,
'S_MODE_SELECT' => $select_sort_mode,
'S_ORDER_SELECT' => $select_sort_order,
'S_MODE_ACTION' => append_sid("characters.$phpEx"))
);
switch( $mode )
{
case 'name':
$order_by = "name $sort_order";
break;
case 'rank':
$order_by = "rank $sort_order";
break;
case 'level':
$order_by = "lvl $sort_order";
break;
case 'class':
$order_by = "class $sort_order";
break;
case 'prof1lvl':
$order_by = "prof1lvl $sort_order";
break;
case 'prof2lvl':
$order_by = "prof2lvl $sort_order";
break;
case 'mcdkp':
$order_by = "class, mcdkp $sort_order";
break;
case 'zgdkp':
$order_by = "class, zgdkp $sort_order";
break;
default:
$order_by = "class, mcdkp $sort_order";
break;
}
$sql = "SELECT ID, user_ID, name, rank, lvl, class, race, prof1, prof1lvl, prof2, prof2lvl, mcdkp, zgdkp, mcr, zgr
FROM phpbb_characters
ORDER BY $order_by";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
// Start retreiving information
$user_ID_ = $row['user_ID'];
$roflcopter = $db->sql_fetchrow($db->sql_query("SELECT username FROM " . USERS_TABLE . " WHERE user_id = $user_ID_ LIMIT 1"));
$username = $roflcopter['username'];
$charname = $row['name'];
$rank = $row['rank'];
$level = $row['lvl'];
$class = $row['class'];
$race = $row['race'];
$prof1 = $row['prof1'];
$prof1lvl = $row['prof1lvl'];
$prof2 = $row['prof2'];
$prof2lvl = $row['prof2lvl'];
$mcdkp = $row['mcdkp'];
$zgdkp = $row['zgdkp'];
$mcr = $row['mcr'];
$zgr = $row['zgr'];
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('memberrow', array(
'ROW_NUMBER' => $i + ( $start + 1 ),
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'USERNAME' => $username,
'USERNAME_LINK' => "profile.php?mode=viewprofile&u=" . $user_ID_,
'CHARACTER' => $charname,
'RANK' => $rank,
'LVL' => $level,
'CLASS' => $class,
'RACE' => $race,
'ZGDKP' => $zgdkp,
'MCDKP' => $mcdkp,
'MCR' => $mcr,
'ZGR' => $zgr,
'PROFS' => $prof1 . ' ' . $prof1lvl . ', ' . $prof2 . ' ' . $prof2lvl)
);
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
}
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>