{

global $lang_arenateam, $lang_global, $output, $realm_db, $characters_db, $realm_id, $itemperpage, $action_permission, $user_lvl, $user_id;

$sqlc = new SQL;

$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);

//==========================$_GET and SECURE=================================

$start = (isset($_GET['start'])) ? $sqlc->quote_smart($_GET['start']) : 0;

if (is_numeric($start));

else $start=0;

$order_by = (isset($_GET['order_by'])) ? $sqlc->quote_smart($_GET['order_by']) : "atid";

if (!preg_match("/^[_[:lower:]]{1,17}$/", $order_by))

$order_by="atid";

$dir = (isset($_GET['dir'])) ? $sqlc->quote_smart($_GET['dir']) : 1;

if (!preg_match("/^[01]{1}$/", $dir))

$dir=1;

$order_dir = ($dir) ? "ASC" : "DESC";

$dir = ($dir) ? 0 : 1;

//==========================$_GET and SECURE end=============================

//==========================Browse/Search CHECK==============================

$search_by ='';

$search_value = '';

if(isset($_GET['search_value']) && isset($_GET['search_by']))

{

$search_value = $sqlc->quote_smart($_GET['search_value']);

$search_by = $sqlc->quote_smart($_GET['search_by']);

$search_menu = array('atname', 'leadername', 'atid');

if (!in_array($search_by, $search_menu))

$search_by = 'atid';

switch($search_by)

{

case "atname":

$query = $sqlc->query("SELECT art.`arenateamid` as atid, art.`name` as atname, art.`captainguid` as lguid, art.`type` as attype, cCaptain.`name` as lname, COUNT(atm.`arenateamid`) as tot_chars, art.`rating` as atrating, art.`seasonGames` as atgames, art.`seasonWins` as atwins FROM `arena_team` art

LEFT JOIN `characters` cCaptain on art.`captainguid` = cCaptain.`guid`

RIGHT JOIN `arena_team_member` atm on atm.`arenateamid` = art.`arenateamid`

WHERE art.`name` LIKE '%$search_value%' GROUP BY atid ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");

$query_1 = $sqlc->query("SELECT count(*) FROM arena_team WHERE arena_team.name LIKE '%$search_value%'");

break;

case "leadername":

$query = $sqlc->query("SELECT art.`arenateamid` as atid, art.`name` as atname, art.`captainguid` as lguid, art.`type` as attype, cCaptain.`name` as lname, COUNT(atm.`arenateamid`) as tot_chars, art.`rating` as atrating, art.`seasonGames` as atgames, art.`seasonWins` as atwins FROM `arena_team` art

LEFT JOIN `characters` cCaptain on art.`captainguid` = cCaptain.`guid`

RIGHT JOIN `arena_team_member` atm on atm.`arenateamid` = art.`arenateamid`

WHERE cCaptain.`name` LIKE '%$search_value%' GROUP BY atid ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");

$query_1 = $sqlc->query("SELECT count(*) FROM arena_team WHERE arena_team.captainguid in (SELECT guid from characters where name like '%$search_value%')");

break;

case "atid":

$query = $sqlc->query("SELECT art.`arenateamid` as atid, art.`name` as atname, art.`captainguid` as lguid, art.`type` as attype, cCaptain.`name` as lname, COUNT(atm.`arenateamid`) as tot_chars, art.`rating` as atrating, art.`seasonGames` as atgames, art.`seasonWins` as atwins, COUNT(cOnlineCount.`guid`) as arenateam_online

FROM `arena_team` art

LEFT JOIN `characters` cCaptain on art.`captainguid` = cCaptain.`guid`

RIGHT JOIN `arena_team_member` atm on atm.`arenateamid` = art.`arenateamid`

LEFT JOIN (SELECT `guid` FROM `characters` WHERE `online` = 1) cOnlineCount on cOnlineCount.`guid` = atm.`guid`

GROUP BY atid ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");

$query_1 = $sqlc->query("SELECT count(*) FROM arena_team arena_team.arenateamid ='$search_value'");

break;

}

}

else

{

$query = $sqlc->query("SELECT arena_team.arenateamid AS atid, arena_team.name AS atname, arena_team.captainguid AS lguid, arena_team.type AS attype, (SELECT NAME FROM `characters` WHERE guid = lguid) AS lname,(SELECT COUNT(*) FROM arena_team_member WHERE arenateamid = atid) AS tot_chars, rating AS atrating, seasonGames AS atgames, seasonWins AS atwins, (SELECT COUNT(*) AS GCNT FROM `arena_team_member`, `characters`, `arena_team` WHERE arena_team.arenateamid = atid AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = characters.guid AND characters.online = 1) AS arenateam_online FROM arena_team ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");

$query_1 = $sqlc->query("SELECT count(*) FROM arena_team");

}

$all_record = $sqlc->result($query_1,0);

unset($query_1);

$this_page = $sqlc->num_rows($query);

//==========================top page navigation starts here====================

$output .="

<center>

<table class=\"top_hidden\">

<tr>

<td>";

makebutton($lang_global['back'], "javascript:window.history.back()", 130);

($search_by && $search_value) ? makebutton($lang_arenateam['arenateams'], "arenateam.php", 130) : $output .= "";

$output .= "

</td>

</tr>

<tr>

<td>

<table class=\"hidden\">

<tr>

<td>

<form action=\"arenateam.php\" method=\"get\" name=\"form\">

<input type=\"hidden\" name=\"error\" value=\"4\" />

<input type=\"text\" size=\"24\" name=\"search_value\" value=\"{$search_value}\"/>

<select name=\"search_by\">

<option value=\"atname\"".($search_by == 'atname' ? " selected=\"selected\"" : "").">{$lang_arenateam['by_name']}</option>

<option value=\"leadername\"".($search_by == 'leadername' ? " selected=\"selected\"" : "").">{$lang_arenateam['by_team_leader']}</option>

<option value=\"atid\"".($search_by == 'atid' ? " selected=\"selected\"" : "").">{$lang_arenateam['by_id']}</option>

</select>

</form>

</td>

<td>";

makebutton($lang_global['search'], "javascript:do_submit()",80);

$output .= "

</td>

</tr>

</table>

</td>

<td align=\"right\">";

$output .= generate_pagination("arenateam.php?order_by=$order_by".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=".!$dir, $all_record, $itemperpage, $start);

$output .= "

</td>

</tr>

</table>";

//==========================top page navigation ENDS here =====================

$output .= "

<table class=\"lined\">

<tr>

<th width=\"1%\"><a href=\"arenateam.php?order_by=atid&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='atid' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['id']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=atname&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='atname' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['arenateam_name']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=lname&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='lname' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['captain']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=attype&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='attype' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['type']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=tot_chars&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='tot_chars' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['members']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=arenateam_online&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='arenateam_online' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['arenateam_online']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=rating&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='rating' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['rating']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=atgames&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='atgames' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['games']}</a></th>

<th width=\"1%\"><a href=\"arenateam.php?order_by=atwins&amp;start=$start".( $search_value && $search_by ? "&amp;search_by=$search_by&amp;search_value=$search_value" : "" )."&amp;dir=$dir\">".($order_by=='atwins' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_arenateam['wins']}</a></th>

</tr>";

while ($data = $sqlc->fetch_row($query))

{

$gonline = $sqlc->query("SELECT count(*) AS GCNT FROM `arena_team_member`, `characters`, `arena_team` WHERE arena_team.arenateamid = ".$data[0]." AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = characters.guid AND characters.online = 1;");

$arenateam_online = $sqlc->result($gonline,"GCNT");

$output .= "

<tr>

<td>$data[0]</td>

<td><a href=\"arenateam.php?action=view_team&amp;error=3&amp;id=$data[0]\">".htmlentities($data[1])."</a></td>

<td><a href=\"char.php?id=$data[2]\">".htmlentities($data[4])."</a></td>

<td>{$lang_arenateam[$data[3]]}</td>

<td>$data[5]</td>

<td>$arenateam_online</td>

<td>$data[6]</td>

<td>$data[7]</td>

<td>$data[8]</td>

</tr>";

}

$output .= "

<tr>

<td colspan=\"9\" class=\"hidden\" align=\"right\">{$lang_arenateam['tot_teams']} : $all_record</td>

</tr>

</table>

</center>";

$gd_a = getdate( $a );

$gd_b = getdate( $b );

$a_new = mktime( 12, 0, 0, $gd_a['mon'], $gd_a['mday'], $gd_a['year'] );

$b_new = mktime( 12, 0, 0, $gd_b['mon'], $gd_b['mday'], $gd_b['year'] );

return round( abs( $a_new - $b_new ) / 86400 );

{

global $lang_arenateam, $lang_global, $output, $characters_db, $realm_id, $realm_db, $mmfpm_db, $action_permission, $user_lvl, $user_id, $showcountryflag;

if(!isset($_GET['id']))

redirect("arenateam.php?error=1");

$sqlc = new SQL;

$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);

$arenateam_id = $sqlc->quote_smart($_GET['id']);

$query = $sqlc->query("SELECT arenateamid, name, type FROM arena_team WHERE arenateamid = '$arenateam_id'");

$arenateam_data = $sqlc->fetch_row($query);

$query = $sqlc->query("SELECT arenateamid, rating, weekGames, weekWins, seasonGames, seasonWins, rank FROM arena_team WHERE arenateamid = '$arenateam_id'");

$arenateamstats_data = $sqlc->fetch_row($query);

$rating_offset = 1550;

if ($arenateam_data[2] == 3)

$rating_offset += 6;

else if ($arenateam_data[2] == 5)

$rating_offset += 12;

$members = $sqlc->query("SELECT arena_team_member.guid,characters.name, arena_team_member.personalRating, level, arena_team_member.weekGames, arena_team_member.weekWins, arena_team_member.seasonGames, arena_team_member.seasonWins, characters.race, characters.class, characters.online, characters.account, characters.logout_time, gender, account FROM arena_team_member,characters LEFT JOIN arena_team_member k1 ON k1.guid=characters.guid AND k1.arenateamid='$arenateam_id' WHERE arena_team_member.arenateamid = '$arenateam_id' AND arena_team_member.guid=characters.guid ORDER BY characters.name");

$total_members = $sqlc->num_rows($members);

$losses_week = $arenateamstats_data[2]-$arenateamstats_data[3];

if($arenateamstats_data[2])

$winperc_week = round((10000 * $arenateamstats_data[3]) / $arenateamstats_data[2]) / 100;

else

$winperc_week = $arenateamstats_data[2];

$losses_season = $arenateamstats_data[4]-$arenateamstats_data[5];

if($arenateamstats_data[4])

$winperc_season = round((10000 * $arenateamstats_data[5]) / $arenateamstats_data[4]) / 100;

else

$winperc_season = $arenateamstats_data[4];

$output .= "

<script type=\"text/javascript\">

answerbox.btn_ok='{$lang_global['yes_low']}';

answerbox.btn_cancel='{$lang_global['no']}';

</script>

<center>

<fieldset>

<legend>{$lang_arenateam['arenateam']} ({$arenateam_data[2]}v{$arenateam_data[2]})</legend>

<table class=\"lined\" style=\"width: 100%;\">

<tr class=\"bold\">

<td colspan=\"".($showcountryflag ? 14 : 13 )."\">".htmlentities($arenateam_data[1])."</td>

</tr>

<tr>

<td colspan=\"".($showcountryflag ? 14 : 13 )."\">{$lang_arenateam['tot_members']}: $total_members</td>

</tr>

<tr>

<td colspan=\"4\">{$lang_arenateam['this_week']}</td>

<td colspan=\"2\">{$lang_arenateam['games_played']} : $arenateamstats_data[2]</td>

<td colspan=\"2\">{$lang_arenateam['games_won']} : $arenateamstats_data[3]</td>

<td colspan=\"2\">{$lang_arenateam['games_lost']} : $losses_week</td>

<td colspan=\"".($showcountryflag ? 4 : 3 )."\">{$lang_arenateam['ratio']} : $winperc_week %</td>

</tr>

<tr>

<td colspan=\"4\">{$lang_arenateam['this_season']}</td>

<td colspan=\"2\">{$lang_arenateam['games_played']} : $arenateamstats_data[4]</td>

<td colspan=\"2\">{$lang_arenateam['games_won']} : $arenateamstats_data[5]</td>

<td colspan=\"2\">{$lang_arenateam['games_lost']} : $losses_season</td>

<td colspan=\"".($showcountryflag ? 4 : 3 )."\">{$lang_arenateam['ratio']} : $winperc_season %</td>

</tr>

<tr>

<td colspan=\"".($showcountryflag ? 14 : 13 )."\">{$lang_arenateam['standings']} {$arenateamstats_data[6]} ({$arenateamstats_data[1]})</td>

</tr>

<tr>

<th width=\"1%\">{$lang_arenateam['remove']}</th>

<th width=\"1%\">{$lang_arenateam['name']}</th>

<th width=\"1%\">Race</th>

<th width=\"1%\">Class</th>

<th width=\"1%\">Personal Rating</th>

<th width=\"1%\">Last Login (Days)</th>

<th width=\"1%\">Online</th>

<th width=\"1%\">{$lang_arenateam['played_week']}</th>

<th width=\"1%\">{$lang_arenateam['wons_week']}</th>

<th width=\"1%\">Win %</th>

<th width=\"1%\">{$lang_arenateam['played_season']}</th>

<th width=\"1%\">{$lang_arenateam['wons_season']}</th>

<th width=\"1%\">Win %</th>";

if ($showcountryflag)

{

require_once 'libs/misc_lib.php';

$sqlr = new SQL;

$sqlr->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);

$sqlm = new SQL;

$sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);

$output .="

<th width=\"1%\">{$lang_global['country']}</th>";

}

$output .="

</tr>";

while ($member = $sqlc->fetch_row($members))

{

$accid = $member[11];

$output .= "

<tr>";

if($user_lvl >= $action_permission['delete'] || $accid == $user_id)

$output .= "

<td><img src=\"img/aff_cross.png\" alt=\"\" onclick=\"answerBox('{$lang_global['delete']}: <font color=white>{$member[1]}</font><br />{$lang_global['are_you_sure']}', 'arenateam.php?action=rem_char_from_team&amp;id=$member[0]&amp;arenateam_id=$arenateam_id');\" style=\"cursor:pointer;\" /></td>";

else

$output .= "

<td>&nbsp;</td>";

if($member[4])

$ww_pct = round((10000 * $member[5]) / $member[4]) / 100;

else

$ww_pct = $member[4];

if($member[6])

$ws_pct = round((10000 * $member[7]) / $member[6]) / 100;

else

$ws_pct = $member[6];

$output .= "

<td><a href=\"char.php?id=$member[0]\">".htmlentities($member[1])."</a></td>

<td><img src='img/c_icons/{$member[8]}-{$member[13]}.gif' onmousemove='toolTip(\"".char_get_race_name($member[8])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>

<td><img src='img/c_icons/{$member[9]}.gif' onmousemove='toolTip(\"".char_get_class_name($member[9])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>

<td>$member[2]</td>

<td>".get_days_with_color($member[12])."</td>

<td>".(($member[10]) ? "<img src=\"img/up.gif\" alt=\"\" />" : "-")."</td>

<td>$member[4]</td>

<td>$member[5]</td>

<td>$ww_pct %</td>

<td>$member[6]</td>

<td>$member[7]</td>

<td>$ws_pct %</td>";

if ($showcountryflag)

{

$country = misc_get_country_by_account($member[14], $sqlr, $sqlm);

$output .="

<td>".(($country['code']) ? "<img src='img/flags/".$country['code'].".png' onmousemove='toolTip(\"".($country['country'])."\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" />" : "-")."</td>";

}

$output .="

</tr>";

}

$output .= "

</table>

<br />

<table class=\"hidden\">

<tr>

<td>";

if($user_lvl >= $action_permission['delete'])

{

makebutton($lang_arenateam['del_team'], "arenateam.php?action=del_team&amp;id=$arenateam_id\" type=\"wrn", 180);

$output .= "

</td>

<td>";

makebutton($lang_arenateam['arenateams'], "arenateam.php\" type=\"def", 130);

$output .= "

</td>

</tr>

<tr>

</tr>";

}

else

{

makebutton($lang_arenateam['arenateams'], "arenateam.php", 130);

$output .= "

</td>

</tr>";

}

$output .= "

</table>

</fieldset>

</center>";

{

global $lang_arenateam, $lang_global, $output;

if(isset($_GET['id']))

$id = $_GET['id'];

else

redirect("arenateam.php?error=1");

$output .= "

<center>

<h1>

<font class=\"error\">{$lang_global['are_you_sure']}</font>

</h1>

<br />

<font class=\"bold\">{$lang_arenateam['arenateam_id']}: $id {$lang_global['will_be_erased']}</font>

<br /><br />

<form action=\"cleanup.php?action=docleanup\" method=\"post\" name=\"form\">

<input type=\"hidden\" name=\"type\" value=\"arenateam\" />

<input type=\"hidden\" name=\"check\" value=\"-$id\" />

<table class=\"hidden\">

<tr>

<td>";

makebutton($lang_global['yes'], "javascript:do_submit()",130);

makebutton($lang_global['no'], "arenateam.php?action=view_team&amp;id=$id",130);

$output .= "

</td>

</tr>

</table>

</form>

<br />

</center>";

{

global $characters_db, $realm_id, $user_lvl;

if(isset($_GET['id']))

$guid = $_GET['id'];

else

redirect("arenateam.php?error=1");

if(isset($_GET['arenateam_id']))

$arenateam_id = $_GET['arenateam_id'];

else

redirect("arenateam.php?error=1");

$sqlc = new SQL;

$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);

// must be checked that this user can delete it

//$sql->query("DELETE FROM arena_team_member WHERE guid = '$guid'");

redirect("arenateam.php?action=view_team&id=$arenateam_id");