function map_players($mapid)
{
$link = baselink();
global $coddb;
global $separatorline;
global $t;
// table names from config
global $map_minkills;
global $map_minrounds;
global $exclude_ban;
global $currentconfignumber;
global $text;
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"outertable\"><tr><td align=\"center\">" . $text["playermapstats"] . "</td></tr><tr><td>\n <table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\" class=\"innertable\">\n <tr class=\"outertable\">\n <td>" . $text["player"] . "</td>\n <td colspan=\"2\" align=\"center\">" . $text["kills"] . "</td>\n <td colspan=\"2\" align=\"center\">" . $text["suicides"] . "</td>\n <td colspan=\"2\" align=\"center\">" . $text["teamkills"] . "</td>\n <td align=\"center\">" . $text["rounds"] . "</td>\n ";
$query = "SELECT kills, suicides, teamkills, rounds\n FROM {$t['maps']}\n WHERE id = {$mapid}\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
$kills = $row['kills'];
// $deaths = $row['deaths'];
$suicides = $row['suicides'];
$teamkills = $row['teamkills'];
$rounds = $row['rounds'];
// $teamdeaths = $row['teamdeaths'];
$query = "SELECT {$t['b3_clients']}.name, {$t['playermaps']}.player_id, {$t['playermaps']}.kills, \n {$t['playermaps']}.suicides, \n {$t['playermaps']}.teamkills,\n {$t['playermaps']}.rounds,\n {$t['players']}.fixed_name\n FROM {$t['b3_clients']}, {$t['players']}, {$t['playermaps']}\n WHERE {$t['playermaps']}.map_id = {$mapid}\n AND {$t['players']}.id = {$t['playermaps']}.player_id\n AND {$t['players']}.hide = 0\n AND {$t['b3_clients']}.id = {$t['players']}.client_id\n AND ( {$t['playermaps']}.kills > {$map_minkills}\n OR {$t['playermaps']}.rounds > {$map_minrounds} )";
if ($exclude_ban) {
$query .= " AND {$t['b3_clients']}.id NOT IN (\n SELECT distinct(target.id)\n FROM {$t['b3_penalties']} as penalties, {$t['b3_clients']} as target\n WHERE (penalties.type = 'Ban' OR penalties.type = 'TempBan')\n AND inactive = 0\n AND penalties.client_id = target.id\n AND ( penalties.time_expire = -1 OR penalties.time_expire > UNIX_TIMESTAMP(NOW()) )\n )";
}
$query .= " ORDER BY {$t['playermaps']}.kills DESC";
$result = $coddb->sql_query($query);
while ($row = $coddb->sql_fetchrow($result)) {
if ($separatorline == 1) {
echo "<tr><td colspan=\"8\" class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>";
}
// This draws a one pixel line between rows
echo "<tr>";
echo "<td><a href=\"{$link}?func=player&playerid={$row['player_id']}&config={$currentconfignumber}\">", htmlspecialchars(utf2iso($row['fixed_name'] ? $row['fixed_name'] : $row['name'])), "</a></td>";
echo " <td align=\"center\">", $row['kills'] ? $row['kills'] : "", "</td>";
if ($kills > 0 && $row['kills'] > 0) {
$temp = sprintf("%.2f", 100 * $row['kills'] / $kills);
echo " <td align=\"center\" class=\"tiny\">({$temp}%)</td>";
} else {
echo " <td></td>";
}
echo " <td align=\"center\">", $row['suicides'] ? $row['suicides'] : "", "</td>";
if ($suicides > 0 && $row['suicides'] > 0) {
$temp = sprintf("%.2f", 100 * $row['suicides'] / $suicides);
echo " <td align=\"center\" class=\"tiny\">({$temp}%)</td>";
} else {
echo " <td></td> ";
}
echo " <td align=\"center\">", $row['teamkills'] ? $row['teamkills'] : "", "</td>";
if ($teamkills > 0 && $row['teamkills'] > 0) {
$temp = sprintf("%.2f", 100 * $row['teamkills'] / $teamkills);
echo " <td align=\"center\" class=\"tiny\">({$temp}%)</td>";
} else {
echo " <td></td>";
}
echo " <td align=\"center\">", $row['rounds'] ? $row['rounds'] : "", "</td>";
echo "</tr>";
}
echo "</table>";
echo "</td></tr><tr><td class=\"tiny\" align =\"right\">" . $text["youneedmap"] . "";
echo "</td></tr></table>";
// Closing extra border-table
}
function globalclan_awards($clan_name = "")
{
$link = baselink();
global $coddb;
global $t;
//table names
global $a_name;
//award names
global $a_desc;
//award descriptions
global $minkills;
global $minrounds;
global $currentconfignumber;
echo "\n <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"outertable\"><tr><td align=\"center\">Our award winners</span></td></tr><tr><td>\n <table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\" class=\"innertable\">\n <tr class=\"outertable\">\n <td>Award</td>\n <td>Player</td>\n <td>Description</td>\n <td align=\"center\">Amount</td>\n </tr>\n ";
// winning streak award (as the top lists this award is limited to minkills or minrounds)
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, winstreak, kills, rounds, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND (({$t['players']}.kills > {$minkills})\n OR ({$t['players']}.rounds > {$minrounds}))\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY winstreak DESC, rounds ASC\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['winstreak']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['winstreak']}</td> \n <td align=\"center\">{$row['winstreak']}</td>\n </tr>";
// loss streak award
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, losestreak, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY losestreak ASC, rounds ASC \n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['losestreak']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['losestreak']}</td> \n <td align=\"center\">" . -1 * $row['losestreak'] . "</td>\n </tr>";
// rounds played award
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, rounds, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY rounds DESC\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['rounds']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['rounds']}</td> \n <td align=\"center\">{$row['rounds']}</td>\n </tr>";
// teamkills award
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, teamkills, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY teamkills DESC, rounds ASC\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['teamkills']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['teamkills']}</td> \n <td align=\"center\">{$row['teamkills']}</td>\n </tr>";
// teamdeaths award
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, teamdeaths, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY teamdeaths DESC, rounds ASC\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['teamdeaths']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['teamdeaths']}</td> \n <td align=\"center\">{$row['teamdeaths']}</td>\n </tr>";
// suicides award
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, suicides, fixed_name\n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ({$t['players']}.hide = 0)\n\t\t\t\tAND ({$t['b3_clients']}.name like '%%{$clan_name}%%')\n ORDER BY suicides DESC, rounds ASC\n LIMIT 1";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
echo "<tr><td>{$a_name['suicides']}</td>\n <td><a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">", $row['fixed_name'] ? $row['fixed_name'] : $row['name'], "</a></td>\n <td>{$a_desc['suicides']}</td> \n <td align=\"center\">{$row['suicides']}</td>\n </tr>";
echo "</table>";
echo "</td></tr><tr><td class=\"tiny\" align =\"right\">Top these players to win an award!";
echo "</td></tr></table>";
// Closing extra border-table
}
function ShowMedal($MedalName, $ArchieveName, $ArchValue, $PlayerId, $Nick, $MedalPicture, $Description, $PlayerNames, $Scores, $FunctionName, $PlayerListIds, $Country, $ch)
{
$link = baselink();
global $game;
global $currentconfignumber;
global $text;
global $geoip_path;
// do we have game specific medals?
if (file_exists("./images/medals/{$game}/")) {
$MedalSrc = "./images/medals/{$game}/{$MedalPicture}";
} else {
$MedalSrc = "./images/medals/{$MedalPicture}";
}
// Clean the Nick from html code (translate)
$Nick = htmlspecialchars(utf2iso($Nick));
if ($ArchValue == 0 || $ArchValue == "" || $ArchValue == false) {
$PlayerId = "";
$ArchValue = $text["awardavailable"];
$ArchieveName = ":";
$Nick = "";
$Scores[] = "";
$text["owner"] = "";
$text["score"] = ":";
}
flush();
if (!isset($_GET['fname'])) {
echo "<td align=\"center\" width=\"150\">\r\n <table width=\"150\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"center\" class=\"with_border_alternate\">\r\n <tr><td align=\"center\" class=\"cellmenu1\"><a name=\"{$Description}\"><strong><a href='{$link}?func=medal&fname={$FunctionName}' title=\"" . $text["seemedaldetails"] . "\">{$MedalName}</a></strong></a></td></tr>\r\n <tr> \r\n <td width=\"150\" class=\"line1\" nowrap valign=\"top\" align=\"center\">\r\n <B>{$ArchieveName}: {$ArchValue} </B>\r\n <br/><a href=\"{$link}?func=player&playerid={$PlayerId}&config={$currentconfignumber}\" title=\"" . $text["seeplayerdetails"] . "\">{$Nick}<br/></a>\r\n <a href='{$link}?func=medal&fname={$FunctionName}' title=\"" . $text["seemedaldetails"] . "\">\r\n <img src=\"{$MedalSrc}\" border=\"0\" style=\"filter: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='{$MedalSrc}', sizingMethod='scale')\" width=\"128\" height=\"256\" name=\"{$Description}\">\r\n </a>\r\n </td>\r\n </tr>\r\n <tr> \r\n <td class=\"line0\" valign=\"top\" align=\"center\">\r\n {$Description} \r\n <br><br>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n ";
$ch->close();
} else {
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"outertable\">\r\n <tr><td colspan=\"2\" align=\"center\">" . $text["medaldetails"] . "</td></tr>\r\n <tr><td>\r\n <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"innertable\">\r\n <tr class=\"outertable\"><td width=\"50%\"align=\"center\">{$MedalName}</td><td align=\"center\">" . $text["topplayers"] . "</td></tr>\r\n <tr><td>\r\n <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\" class=\"outertable\">\r\n <tr class=\"innertable\"><td width=\"150\" rowspan=\"3\" align=\"center\"><img src=\"{$MedalSrc}\" style=\"filter: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='{$MedalSrc}', sizingMethod='scale')\" width=\"128\" height=\"256\" title=\"{$MedalName}\"></img></td>\r\n <td valign=\"top\">\r\n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"innertable\">\r\n <tr><td height=\"10px\"><b><br>" . $text["owner"] . "<a href=\"{$link}?func=player&playerid={$PlayerId}&config={$currentconfignumber}\" title=\"" . $text["seeplayerdetails"] . "\">{$Nick}</a></b></td></tr>\r\n <tr class=\"innertable\"><td><b>" . $text["score"] . ": {$ArchValue}<br><br></b></td></tr>\r\n <tr><td colspan=\"1\" class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>\r\n <tr class=\"innertable\"><td valign=\"top\"><b><br>" . $text["medaldescription"] . "<br></b>{$Description}</td></tr>\r\n </table></td>\r\n </table></td>\r\n <td valign=\"top\">\r\n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"innertable\">\r\n <tr><td>\r\n <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"innertable\">\r\n <tr class=\"outertable\">\r\n <td align=\"center\">" . $text["place"] . "</td>\r\n " . (file_exists($geoip_path . "GeoIP.dat") ? "<td align=\"center\">" . $text["cntry"] . "</td>" : "") . "\r\n <td align=\"center\">" . $text["player"] . "</td>\r\n <td align=\"center\">" . $text["mdscore"] . "</td></tr>\r\n ";
for ($i = 0; $i < 10; $i++) {
if (@$Scores[$i] > 0) {
echo "<tr class=\"innertable\">\r\n <td width=\"50\" align=\"center\">" . ($i + 1) . "</td>\r\n " . (file_exists($geoip_path . "GeoIP.dat") ? "<td width=\"50\" align=\"center\">" . $Country[$i] . "</td>" : "") . "\r\n <td align=\"left\"><a href=\"{$link}?func=player&playerid=" . $PlayerListIds[$i] . "&config={$currentconfignumber}\" title=\"" . $text["seeplayerdetails"] . "\">" . htmlspecialchars(utf2iso($PlayerNames[$i])) . "</td></a>\r\n <td align=\"center\">" . $Scores[$i] . "</td></tr>\r\n <tr><td colspan=" . (file_exists($geoip_path . "GeoIP.dat") ? '4' : '3') . " class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>\r\n ";
}
}
echo "</table></tr></td>\r\n </table></td></tr>\r\n </table></td></tr>\r\n </table>\r\n ";
}
}
function draw_blocks($array, $title = "League", $number = 10, $blocks = 4, $on = "skill", $name_length = 10)
{
global $main_width;
$link = baselink();
$width = $main_width / $blocks;
echo "<table width='100%' class='outertable'><tr><td><div style='font-size:1.5em;'>" . $title . "</div></td></tr></table>";
$blockcount = 1;
echo "<table width='100%'>\n";
echo " <tr>\n";
foreach ($array as $k1 => $v1) {
echo " <td width='{$width}' valign='top' class='outertable'>\n";
$count = 1;
//$width = 100/$blocks."%";
echo " <table width='{$width}' class='innertable'>\n";
$division = $k1 + 1;
echo " <tr><td colspan='4'><p><strong>Division " . $division . " (top " . $number . ")</strong></p></td></tr>\n";
//print_r($array);
//echo $k1.": <br />";
if (is_array($v1)) {
foreach ($v1 as $k2 => $v2) {
//echo $k2.": ".$v2."<br />";
if (is_array($v2)) {
foreach ($v2 as $k3 => $v3) {
if ($k3 == 'id') {
$id = $v3;
}
if ($k3 == 'name') {
$name = $v3;
}
if ($k3 == $on) {
if ($on == 'skill') {
$value = sprintf("%.1f", $v3);
} else {
$value = $v3;
}
}
if ($k3 == 'ip') {
$flag = $this->get_flag($v3);
echo " <tr><td>{$count}</td>\n";
echo " <td align=\"center\">" . $flag . "</td>\n";
echo " <td><a href='{$link}?func=player&playerid={$id}'>{$name}</a></td>\n";
echo " <td>" . $value . "</td></tr>\n";
$count += 1;
}
if ($count > $number) {
break;
}
}
}
}
}
echo " </table>\n";
echo " </td>\n";
$fill = $blocks - $blockcount;
$blockcount += 1;
if ($blockcount > $blocks) {
$blockcount = 1;
echo " </tr>\n <tr>\n";
}
}
if ($fill > 0) {
for ($i = 0; $i < $fill; $i++) {
echo "<td> </td>\n";
}
}
echo " </tr>\n</table>\n";
}
}
if (isset($_GET['id'])) {
$plid = $_GET['id'];
$query = "SELECT {$t['b3_clients']}.name, ctime.id, ctime.gone, ctime.came\n FROM {$t['b3_clients']}, ctime, {$t['players']} \n WHERE {$t['players']}.id = \"{$plid}\"\n AND {$t['players']}.client_id = {$t['b3_clients']}.id\n AND {$t['b3_clients']}.guid = ctime.guid\n ORDER BY ctime.id DESC";
} else {
if (isset($_GET['dbid'])) {
$plid = $_GET['dbid'];
$query = "SELECT {$t['b3_clients']}.name, ctime.id, ctime.gone, ctime.came\n FROM {$t['b3_clients']}, ctime\n WHERE {$t['b3_clients']}.id = \"{$plid}\"\n AND {$t['b3_clients']}.guid = ctime.guid\n ORDER BY ctime.id DESC";
} else {
return;
}
}
$data = array();
global $t;
$count = 0;
$link = baselink();
$result = $coddb->sql_query($query);
$d = array();
$max = 31;
$idx = 1;
$suma = 0;
while ($row = $coddb->sql_fetchrow($result)) {
$start = $row['came'];
$end = $row['gone'];
$d1 = date("Y-m-d", $start);
$d2 = date("Y-m-d", $end);
if (count($data) and $data[count($data) - 1][1] > $d1) {
$diff = floor(($data[count($data) - 1][4] - $start) / (60 * 60 * 24));
$empty = $data[count($data) - 1][4];
for ($i = 0; $i < $diff; $i++) {
if (count($d) >= $max) {
function addClients($clients, $backgroundColor)
{
global $geoip_path;
global $public_ip;
global $currentconfignumber;
$link = baselink();
$x = 1;
foreach ($clients as $client) {
echo '<tr bgcolor="#cccccf" valign="middle">
<td style="background: ' . $backgroundColor . 'none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2"><strong>' . $x . '</strong></font></td>';
if ($client->levelInt == 0) {
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2">' . htmlspecialchars(utf2iso($client->name)) . '</font></td>';
} else {
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2"><a href=' . $link . '?func=player&playerdbid=' . $client->dbid . '&config=' . $currentconfignumber . '><strong>' . htmlspecialchars(utf2iso($client->name)) . '</strong></a></font></td>';
}
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2">' . $client->score . '</font></td>';
if (file_exists($geoip_path . "GeoIP.dat")) {
if ($client->level == "BOT") {
$tip = explode(":", $public_ip);
$ip = $tip[0];
} else {
$ip = $client->ip;
}
$geocountry = $geoip_path . "GeoIP.dat";
$gi = geoip_open($geocountry, GEOIP_STANDARD);
$countryid = strtolower(geoip_country_code_by_addr($gi, $ip));
$country = geoip_country_name_by_addr($gi, $ip);
if (!is_null($countryid) and $countryid != "") {
$flag = "<img src=\"images/flags/" . $countryid . ".gif\" title=\"" . $country . "\" alt=\"" . $country . "\">";
} else {
$flag = "<img width=\"16\" height=\"11\" src=\"images/spacer.gif\" title=\"" . $country . "\" alt=\"" . $country . "\">";
}
geoip_close($gi);
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2">' . $flag . '</font></td>';
}
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2">' . $client->level . '</font></td>';
echo '<td style="background: ' . $backgroundColor . ' none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; color: black;" align="center"><font class="fontNormal" size="2">' . $client->connections . '</font></td>
</tr>';
$x++;
}
}
function do_search($name, $search_aliases = false)
{
global $currentconfig;
global $currentconfignumber;
global $coddb;
global $t;
global $text;
$count = 0;
$link = baselink();
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, {$t['players']}.fixed_name,\n {$t['players']}.hide \n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ( \n ({$t['b3_clients']}.name LIKE \"%{$name}%\")\n OR\n ({$t['players']}.fixed_name LIKE \"%{$name}%\")\n )\n AND {$t['players']}.hide = 0";
$result = $coddb->sql_query($query);
opentablerow('100');
echo "<td>" . $text["currentplnames"] . "<td></tr><tr>";
while ($row = $coddb->sql_fetchrow($result)) {
opentablecell('100');
if ($row['fixed_name'] == "") {
echo "<a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">" . htmlspecialchars(utf2iso($row['name'])) . "</a><br/>";
$count++;
} else {
if (stristr($row['fixed_name'], $name)) {
echo "<a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">" . htmlspecialchars(utf2iso($row['fixed_name'])) . "</a><br/>";
$count++;
}
}
closetablecell();
echo "</tr><tr>";
}
closetablerow();
if ($search_aliases == "true") {
$query = "SELECT {$t['b3_aliases']}.alias, {$t['b3_clients']}.name, {$t['players']}.id\n FROM {$t['b3_aliases']}, {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_aliases']}.alias LIKE \"%{$name}%\")\n AND {$t['b3_aliases']}.client_id = {$t['b3_clients']}.id\n AND {$t['b3_clients']}.id = {$t['players']}.client_id\n AND {$t['players']}.hide = 0\n AND {$t['players']}.fixed_name = '' ";
$result = $coddb->sql_query($query);
if ($coddb->sql_numrows($result) > 0) {
echo "Alias results:<br/>";
}
opentablerow('100');
echo "<td>Search results (aliase -> current playername)<td></tr><tr>";
while ($row = $coddb->sql_fetchrow($result)) {
opentablecell('100');
echo "{$row['alias']} -> <a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">{$row['name']}</a><br/>";
$count++;
closetablecell();
echo "</tr><tr>";
}
closetablerow();
}
return $count;
}
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Library General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* http://www.gnu.org/copyleft/gpl.html
***************************************************************************/
global $currentconfignumber;
echo "<a href=\"http://{$mysiteurl}\" class = \"breadcrumb-a\">{$mysitelinkname}</a><span class=\"breadcrumb-a\"> : </span>";
if ($_SERVER['PHP_SELF'] == GetFileDir($_SERVER['PHP_SELF']) . "index.php") {
echo "<a href=\"" . $link . "\" class = \"breadcrumb-a\">XLRStats</a><span class=\"breadcrumb-a\"> : </span>";
//echo "<a href=\"http://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] . "\" class = \"breadcrumb-a\">XLRStats</a><span class=\"breadcrumb-a\"> : </span>";
} elseif ($_SERVER['PHP_SELF'] == GetFileDir($_SERVER['PHP_SELF']) . "build.php") {
echo "<a href=\"" . $link . "\" class = \"breadcrumb-a\">XLRStats</a><span class=\"breadcrumb-a\"> : </span><a href=\"" . baselink() . "\" class = \"breadcrumb-a\">Signature Builder</a><span class=\"breadcrumb-a\"> : </span>";
//echo "<a href=\"http://" . $_SERVER['HTTP_HOST'] . GetFileDir($_SERVER['PHP_SELF']) . "\" class = \"breadcrumb-a\">XLRStats</a><span class=\"breadcrumb-a\"> : </span><a href=\"http://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] . "\" class = \"breadcrumb-a\">Signature Builder</a><span class=\"breadcrumb-a\"> : </span>";
}
if (isset($myplayerid)) {
echo "<a href=\"{$link}?func=player&playerid={$myplayerid}&config={$currentconfignumber}\" class = \"breadcrumb-a\">MyStats</a><span class=\"breadcrumb-a\"> : </span>";
}
if (strlen($statstitle) > 30 && $disable_configpicker != 1) {
$statstitle = substr($statstitle, 0, 30) . "...";
}
echo "<a class = \"breadcrumb-b\">{$statstitle}</a>";
//echo $xlrstats_url;
//echo $_SERVER['PHP_SELF'];
//echo $_SERVER['HTTP_HOST'];
//echo GetFileDir($_SERVER['PHP_SELF']);
echo "</font>";
echo "</font>";
function shame_medal_careless()
{
$link = baselink();
global $coddb;
global $separatorline;
global $t;
//table names
global $a_name;
//award names
global $a_desc;
//award descriptions
global $w;
global $minkills;
global $minrounds;
global $maxdays;
global $wp_accidents;
global $text;
global $exclude_ban;
$current_time = gmdate("U");
$query = " SELECT {$t['b3_clients']}.name, {$t['players']}.id, ip, {$t['b3_clients']}.time_edit, {$t['players']}.fixed_name, rounds, (SUM({$t['weaponusage']}.suicides) / {$t['players']}.rounds) AS total_suicides\n FROM {$t['weaponusage']}\n JOIN {$t['players']} ON {$t['weaponusage']}.player_id = {$t['players']}.id\n JOIN {$t['b3_clients']} ON {$t['players']}.client_id = {$t['b3_clients']}.id\n WHERE ({$t['weaponusage']}.weapon_id IN {$wp_accidents})\n AND (({$t['players']}.kills > {$minkills})\n OR ({$t['players']}.rounds > {$minrounds}))\n AND ({$t['players']}.hide = 0)\n AND ({$current_time} - {$t['b3_clients']}.time_edit < {$maxdays}*60*60*24)";
if ($exclude_ban) {
$query .= " AND {$t['b3_clients']}.id NOT IN (\n SELECT distinct(target.id)\n FROM {$t['b3_penalties']} as penalties, {$t['b3_clients']} as target\n WHERE (penalties.type = 'Ban' OR penalties.type = 'TempBan')\n AND inactive = 0\n AND penalties.client_id = target.id\n AND ( penalties.time_expire = -1 OR penalties.time_expire > UNIX_TIMESTAMP(NOW()) )\n )";
}
$query .= " GROUP BY {$t['players']}.id\n ORDER BY total_suicides DESC\n LIMIT 1 ";
$result = $coddb->sql_query($query);
$row = $coddb->sql_fetchrow($result);
$name = $row['fixed_name'] ? $row['fixed_name'] : $row['name'];
$score = sprintf("%.2f", $row['total_suicides']);
$playerid = $row['id'];
$query = str_replace("LIMIT 1", "LIMIT 0, 10", $query);
$result = $coddb->sql_query($query);
while ($row = $coddb->sql_fetchrow($result)) {
$names = $row['fixed_name'] ? $row['fixed_name'] : $row['name'];
$players[] = $names;
$scores[] = sprintf("%.2f", $row['total_suicides']);
$playerids[] = $row['id'];
$flags[] = country_flag($row['ip']);
}
if (!isset($playerids, $flags, $players, $scores)) {
$playerids = "";
$flags = "";
$players = "";
$scores = "";
}
$fname = __FUNCTION__;
ShowMedal($text["accidenthero"], $text["blindasbat"], $score, $playerid, $name, "xlr_shame_blind.png", $text["mostaccdeath"], $players, $scores, $fname, $playerids, $flags);
}
