Unnamed

<?php

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_VIEWMEMBERS);
init_userprefs($userdata);
//
// End session management
//

$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;

if ( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? htmlspecialchars($HTTP_POST_VARS['mode']) : htmlspecialchars($HTTP_GET_VARS['mode']);
}
else
{
	$mode = 'default';
}

if(isset($HTTP_POST_VARS['order']))
{
	$sort_order = ($HTTP_POST_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else if(isset($HTTP_GET_VARS['order']))
{
	$sort_order = ($HTTP_GET_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else
{
	$sort_order = 'DESC';
}

//
// Memberlist sorting
//
$mode_types_text = array("Class, MCdkp", "Class, ZGdkp" , "Name", "Rank", "Level", "Class");
$mode_types = array('mcdkp', 'zgdkp', 'name', 'rank', 'level', 'class');

$select_sort_mode = '<select name="mode">';
for($i = 0; $i < count($mode_types_text); $i++)
{
	$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
	$select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
}
$select_sort_mode .= '</select>';

$select_sort_order = '<select name="order">';
if($sort_order == 'ASC')
{
	$select_sort_order .= '<option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option><option value="DESC">' . $lang['Sort_Descending'] . '</option>';
}
else
{
	$select_sort_order .= '<option value="ASC">' . $lang['Sort_Ascending'] . '</option><option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option>';
}
$select_sort_order .= '</select>';

//
// 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") ? "<form method=\"POST\" action=\"char_edit.php\"><input type=\"submit\" value=\"Äéá÷åéñéóôåßôå ôïõò ÷áñáêôÞñåò óáò\" class=\"liteoption\"></form>" : "";


$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);

?>