rendered paste body<?phpdefine('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);?>