<script type="text/javascript">
var flashId="arenarank<?php
echo $arenateam["type"];
?>
";
if ((is_safari && flashId=="flashback") || (is_linux && flashId=="flashback")){//kill the searchbox flash for safari or linux
document.getElementById("searchFlash").innerHTML = '<div class="search-noflash"></div>';
}else
printFlash("arenarank<?php
echo $arenateam["type"];
?>
", "images/rank.swf", "transparent", "", "", "100", "50", "best", "", "rankNum=<?php
echo ordinal_suffix($arenateam["rank"]);
?>
", "<div class=teamstanding-noflash><?php
echo ordinal_suffix($arenateam["rank"]);
?>
</div>")
</script>
</div>
<div class="arenaBadge-icon" id="icon<?php
echo $arenateam["type"], "v", $arenateam["type"];
?>
team" style="background-image:url(images/pixel.gif);">
<img border="0" class="p" id="badgeBorder<?php
echo $arenateam["type"], "v", $arenateam["type"];
?>
team" src="images/pixel.gif"></div>
</div>
<script type="text/javascript">
switchConnection("characters", REALM_NAME);
$pvpquery = execute_query("SELECT at.`arenateamid`, at.`name`, `BackgroundColor`, `EmblemStyle`, `EmblemColor`, `BorderColor`, `rating`, `wins2`, `played` - `wins2` AS `losses`, `rank`, c.`name` AS captain_name, `race`\r\nFROM `arena_team` AS at, `arena_team_stats` AS atm, `characters` AS c\r\nWHERE at.`arenateamid` = atm.`arenateamid` AND `played` <> 0 AND `type` = " . $type . " AND `captainguid` = c.`guid`" . exclude_GMs() . " ORDER BY `" . $orderField . "` DESC LIMIT " . $config["TeamTop"]);
$i = 0;
while ($team = mysql_fetch_assoc($pvpquery)) {
$i++;
$team["faction"] = GetFaction($team["race"]);
$team["captain_name"] = $team["captain_name"] ? $team["captain_name"] : $lang["unknown"];
$teamMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid` = " . $team["arenateamid"]), 0);
?>
<tr>
<td>
<div>
<p></p>
</div>
</td><td><q><i><span class="veryplain"><?php
echo ordinal_suffix($team["rank"]);
?>
</span></i></q></td>
<td><q><span id="emblem_<?php
echo $i;
?>
"></span></q></td>
<td><q><?php
echo guild_arenateam_tooltip_frame("team", $team["arenateamid"], $team["name"], $team["captain_name"], $teamMembers);
?>
</q></td>
<td align="center"><q><img width="20" height="20" src="images/icon-<?php
echo $team["faction"];
?>
.gif" onMouseOver="showTip('<?php
echo $lang[$team["faction"]];
<th width="400">Gender</th>
<td><?php
echo strtolower($seeking['gender']) == 'm' ? 'Male' : 'Female';
?>
</td>
</tr>
<?php
}
?>
<?php
if ($showGrade == true) {
?>
<tr>
<th width="400">Grade Level</th>
<td><?php
echo ordinal_suffix($seeking['grade']);
?>
</td>
</tr>
<?php
}
?>
<?php
foreach ($otherAnswers as $answerIndex => $answer) {
?>
<tr>
<th width="400"><?php
echo h($question['questions'][$answerIndex]);
?>
</th>
<td width="520"><?php
echo $key;
?>
" style="display:none;"></div>
<script type="text/javascript">
var flashId="arenarank<?php
echo $key;
?>
";
if ((is_safari && flashId=="flashback") || (is_linux && flashId=="flashback")){//kill the searchbox flash for safari or linux
document.getElementById("searchFlash").innerHTML = '<div class="search-noflash"></div>';
}else
printFlash("arenarank<?php
echo $key;
?>
", "images/rank.swf", "transparent", "", "", "100", "40", "best", "", "rankNum=<?php
echo ordinal_suffix($teams[$type]["rank"]);
?>
", "")
</script>
</div>
</div>
</div>
</li>
<?php
}
?>
</ul>
<ul class="badges-pvp personalrating">
<?php
foreach ($arenatypes as $type) {
Sort:
<?php
if ($_REQUEST['sort'] == "pwin") {
echo "<a href='endgamesummary.php'>Number of Paths</a> | <em>Probability of Winning</em>";
} else {
echo "<em>Number of Paths</em> | <a href='endgamesummary.php?sort=pwin'>Probability of Winning</a>";
}
?>
</h5>
<table border="0" >
<tr valign="top">
<?php
for ($showRanks = 1; $showRanks <= $maxScoreRanks; $showRanks++) {
echo "<td>";
$rankName = ordinal_suffix($showRanks) . " Place";
createSummaryTable($db, $showRanks, $rankName, $viewAll, $summary_data['num_scenarios'], $_REQUEST['sort']);
echo "</td>";
if ($showRanks % 3 == 0) {
echo "</tr>";
if ($showRanks < $maxScoreRanks) {
echo "<tr>";
}
}
}
if (($showRanks - 1) % 3 != 0) {
echo "</tr>";
}
?>
<tr>
if ($db->connect_error) {
die("Error connecting the database");
}
$db->query('SET NAMES utf8mb4');
include get_include_path() . '/' . '../modules/utils/main.php';
$getstats = $db->query("SELECT value FROM stats WHERE id=7 OR id=9");
$contestid = $getstats->fetch_array()[0];
$custommsg = $getstats->fetch_array()[0];
$db->query("UPDATE stats SET value=value+1 WHERE id=7");
$db->query("UPDATE stats SET value=0 WHERE id=8");
$db->query("UPDATE stats SET value='<!-- Msg -->' WHERE id=9");
$db->query("DELETE FROM hallop_votes");
$ganadores = $db->query("SELECT *, (SELECT user FROM users WHERE manceID=hallofplays.manceID) as name FROM hallofplays WHERE contestid={$contestid} ORDER BY votes DESC LIMIT 3");
$n = 0;
while ($ganador = $ganadores->fetch_array()) {
$n++;
$msg = 'Congratulations on winning the ' . ordinal_suffix($contestid) . ' contest in ' . ordinal_suffix($n) . ' place!';
if ($n == 1) {
// Dar premios especiales que haya aka añadir el texto manual de stats a su mensaje
$msg .= '<br>' . $custommsg;
}
$db->query("INSERT INTO hallop_msg (manceID, message, timestamp) VALUES ({$ganador['manceID']}, '" . $db->real_escape_string($msg) . "', " . time() . ")");
$gold = $db->query("SELECT gold FROM users WHERE manceID={$ganador['manceID']}")->fetch_array()[0];
if ($gold != 1) {
if ($gold > time()) {
$db->query("UPDATE FROM users SET gold=gold+31*60*60*24*{$n} WHERE manceID={$ganador['manceID']}");
} else {
$db->query("UPDATE FROM users SET gold=" . time() . "+31*60*60*24*{$n} WHERE manceID={$ganador['manceID']}");
}
}
}
