{

if (e_QUERY) {

$tmp = explode(".", e_QUERY);

$action = $tmp[0];

}

if (!isset($action) || ($action == ""))

{

$action = "config";

}

$var['config']['text'] = EB_ADMIN_L24;

$var['config']['link'] = "admin_config.php";

$var['eb_games']['text'] = EB_ADMIN_L39;

$var['eb_games']['link'] ="admin_config.php?eb_games";

$var['eb_links']['text'] = EB_ADMIN_L25;

$var['eb_links']['link'] ="admin_config.php?eb_links";

$var['eb_activity']['text'] = EB_ADMIN_L26;

$var['eb_activity']['link'] ="admin_config.php?eb_activity";

$var['eb_vupdate']['text'] = EB_ADMIN_L32;

$var['eb_vupdate']['link'] ="admin_vupdate.php";

show_admin_menu(EB_L1, $action, $var);

global $pref;

global $sql;

global $text;

global $session;

$pages = new Paginator;

$array = array(

'id' => array(EB_GAMES_L3, TBL_GAMES.'.GameID'),

'icon' => array(EB_GAMES_L4, TBL_GAMES.'.Icon'),

'game' => array(EB_GAMES_L5, TBL_GAMES.'.Name')

);

if (!isset($_GET['orderby'])) $_GET['orderby'] = 'game';

$orderby= eb_sanitize($_GET['orderby']);

$sort = "ASC";

if(isset($_GET["sort"]) && !empty($_GET["sort"]))

{

$sort = ($_GET["sort"]=="ASC") ? "DESC" : "ASC";

}

$q = "SELECT count(*) "

." FROM ".TBL_GAMES;

$result = $sql->db_Query($q);

$numGames = mysql_result($result, 0);

$totalItems = $numGames;

$pages->items_total = $totalItems;

$pages->mid_range = eb_PAGINATION_MIDRANGE;

$pages->paginate();

$text .= '<div class="spacer">';

$text .= '<p>';

$text .= $numGames.' '.EB_GAMES_L6.'<br />';

$text .= '</p>';

$text .= '</div>';

$orderby_array = $array["$orderby"];

$q = "SELECT ".TBL_GAMES.".*"

." FROM ".TBL_GAMES

." ORDER BY $orderby_array[1] $sort"

." $pages->limit";

$result = $sql->db_Query($q);

$num_rows = mysql_numrows($result);

if(!$result || ($num_rows < 0)){

$text .= EB_GAMES_L7;

return;

}

if($num_rows == 0){

$text .= EB_GAMES_L8;

}

else

{

// Paginate

$text .= '<br />';

$text .= '<span class="paginate" style="float:left;">'.$pages->display_pages().'</span>';

$text .= '<span style="float:right">';

// Go To Page

$text .= $pages->display_jump_menu();

$text .= '&nbsp;&nbsp;&nbsp;';

// Items per page

$text .= $pages->display_items_per_page();

$text .= '</span><br /><br />';

/* Display table contents */

$text .= '<form id="gamesform" action="'.e_PLUGIN.'ebattles/gameprocess.php" method="post">';

$text .= '<table class="fborder" style="width:95%"><tbody>';

$text .= '<tr>';

$text .= '<td class="eb_td2"><input class="tbox" type="checkbox" name="sAll" onclick="selectAll(this)" /> ('.EB_GAMES_L9.')</td>';

foreach($array as $opt=>$opt_array)

$text .= '<td class="eb_td2"><a href="'.e_PLUGIN.'ebattles/admin_config.php?eb_games&orderby='.$opt.'&amp;sort='.$sort.'">'.$opt_array[0].'</a></td>';

$text .= '<td class="eb_td2">'.EB_GAMES_L10;

$text .= '<input type="hidden" id="delete_game" name="delete_game" value=""/></td></tr>';

for($i=0; $i<$num_rows; $i++){

$gid = mysql_result($result,$i, TBL_GAMES.".GameID");

$gname = mysql_result($result,$i, TBL_GAMES.".Name");

$gicon = mysql_result($result,$i, TBL_GAMES.".Icon");

$text .= '<tr>';

$text .= '<td class="forumheader3"><input class="tbox" type="checkbox" name="game_sel[]" value="'.$gid.'" /></td>';

$text .= '<td class="forumheader3">'.$gid.'</td>';

$text .= '<td class="forumheader3"><img '.getGameIconResize($gicon).' title="'.$gicon.'"/></td>';

$text .= '<td class="forumheader3"><a href="'.e_PLUGIN.'ebattles/admin_config.php?eb_games&gameid='.$gid.'">'.$gname.'</a></td>';

$text .= '<td class="forumheader3"><a href="'.e_PLUGIN.'ebattles/admin_config.php?eb_games&gameid='.$gid.'"><img src="'.e_PLUGIN.'ebattles/images/page_white_edit.png" alt="'.EB_GAMES_L11.'" title="'.EB_GAMES_L11.'"/></a>';

$text .= '<a href="javascript:buttonval(\''.$gid.'\');" title="'.EB_GAMES_L12.'" onclick="return confirm(\''.EB_GAMES_L13.'\')"><img src="'.e_PLUGIN.'ebattles/images/cross.png" alt="'.EB_GAMES_L12.'"/></a>';

$text .= '</td>';

$text .= '</tr>';

}

$text .= '</tbody></table>';

$text .= '<table><tr>

<td>

<input class="eb_button" type="submit" name="delete_selected_games" value="'.EB_GAMES_L14.'" onclick="return confirm(\''.EB_GAMES_L15.'\')"/>

</td>