<?php
echo "<TABLE BORDER=2 style='border-color: #f8c300; border: collapse;' CELLPADDING=2 CELLSPACING=2 WIDTH=100%>
<TR BGCOLOR=#FFF><TD><B>Command</B></TD><TD><B>Action</B></TD></TR>
<TR BGCOLOR=#FFF><TD>/war invite,guild name,fraglimit </TD><TD>Send an invitation to start a war.
Example: war invite,Black Ninjas,150</TD></TR>
<TR BGCOLOR=#FFF><TD>/war invite,guild name,fraglimit,money,time </TD><TD>Send an invitation to start a war.
Example: war invite,Black Ninjas,150,10000,3 day's</TD></TR>
<TR BGCOLOR=#FFF><TD>/war accept,guild name </TD><TD>Accept the invitation to start a war.</TD></TR>
<TR BGCOLOR=#FFF><TD>/war reject,guild name </TD><TD>Reject the invitation to start a war.</TD></TR>
<TR BGCOLOR=#FFF><TD>/war cancel,guild name</TD><TD>This will cancel the invitation to the guild Black Ninjas</TD></TR>
<TR BGCOLOR=#FFF><TD>/balance donate 1234</TD><TD>Command for founder of guilds for pay money</TD></TR>
<TR BGCOLOR=#FFF><TD>/balance pick 1234</TD><TD>Command for founder of guilds for payout money</TD></TR>
</TABLE>";
echo '<center><h1>Guild Wars</h1></center>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td bgcolor="" class="white" width="150"><b>Aggressor</b></td>
<td bgcolor="" class="white"><b>Information</b></td>
<td bgcolor="" class="white" width="150"><b>Enemy</b></td>
</tr>';
echo "
<script type=\"text/javascript\"><!--
function show_hide(flip)
{
var tmp = document.getElementById(flip);
if(tmp)
tmp.style.display = tmp.style.display == 'none' ? '' : 'none';
}
--></script>";
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();
$config['site']['vdarkborder']='';
$config['site']['darkborder']='';
$config['site']['lightborder']='';
$count = 0;
foreach($SQL->query('SELECT * FROM `guild_wars` WHERE `status` IN (1,4) OR ((`end` >= (UNIX_TIMESTAMP() - 604800) OR `end` = 0) AND `status` IN (0,5));') as $war)
{
$a = $ots->createObject('Guild');
$a->load($war['guild_id']);
if(!$a->isLoaded())
continue;
$e = $ots->createObject('Guild');
$e->load($war['enemy_id']);
if(!$e->isLoaded())
continue;
//$alogo = $a->getCustomField('logo_gfx_name');
//if(empty($alogo) || !file_exists('guilds/' . $alogo))
$alogo = 'default.gif';
//$elogo = $e->getCustomField('logo_gfx_name');
//if(empty($elogo) || !file_exists('guilds/' . $elogo))
$elogo = 'default.gif';
$count++;
echo "<tr style=\"background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">
<td align=\"center\"><a href=\"/index.php/guilds/view/".$a->getId()."\"><img src=\"/public/guild_logos/".$alogo."\" width=\"64\" height=\"64\" border=\"0\"/><br />".$a->getName()."</a></td>;
<td class=\"white\" align=\"center\">";
switch($war['status'])
{
case 0:
{
echo "<b>Pending acceptation</b><br />Invited on " . date("M d Y, H:i:s", $war['begin']) . " for " . ($war['end'] > 0 ? (($war['end'] - $war['begin']) / 86400) : "unspecified") . " days. The frag limit is set to " . $war['frags'] . " frags, " . ($war['payment'] > 0 ? "with payment of " . $war['payment'] . " bronze coins." : "without any payment.")."<br />Will expire in three days.";
break;
}
case 3:
{
echo "<s>Canceled invitation</s><br />Sent invite on " . date("M d Y, H:i:s", $war['begin']) . ", canceled on " . date("M d Y, H:i:s", $war['end']) . ".";
break;
}
case 2:
{
echo "Rejected invitation<br />Invited on " . date("M d Y, H:i:s", $war['begin']) . ", rejected on " . date("M d Y, H:i:s", $war['end']) . ".";
break;
}
case 1:
{
echo "<font size=\"12\"><span style=\"color: red;\">" . $war['guild_kills'] . "</span> : <span style=\"color: lime;\">" . $war['enemy_kills'] . " </span></font><br /><br /><span style=\"color: darkred; font-weight: bold;\">On a brutal war</span><br />Began on " . date("M d Y, H:i:s", $war['begin']) . ($war['end'] > 0 ? ", will end up at " . date("M d Y, H:i:s", $war['end']) : "") . ".<br />The frag limit is set to " . $war['frags'] . " frags, " . ($war['payment'] > 0 ? "with payment of " . $war['payment'] . " bronze coins." : "without any payment.");
break;
}
case 4:
case 5:
{
echo "<i>Ended</i><br />Began on " . date("M d Y, H:i:s", $war['begin']) . ", ended on " . date("M d Y, H:i:s", $war['end']) . ". Frag statistics: <span style=\"color: red;\">" . $war['guild_kills'] . "</span> to <span style=\"color: lime;\">" . $war['enemy_kills'] . "</span>.";
break;
}
default:
{
echo "Unknown, please contact with gamemaster.";
break;
}
}
echo "<br /><br /><a onclick=\"show_hide('war-details:" . $war['id'] . "'); return false;\" style=\"cursor: pointer;\">» Details «</a></td>
<td align=\"center\"><a href=\"/index.php/guilds/view/".$e->getId()."\"><img src=\"/public/guild_logos/".$elogo."\" width=\"64\" height=\"64\" border=\"0\"/><br />".$e->getName()."</a></td>
</tr>
<tr id=\"war-details:" . $war['id'] . "\" style=\"display: none; background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">
<td colspan=\"3\">";
if(in_array($war['status'], array(1,4,5)))
{
$deaths = $SQL->query('SELECT `pd`.`id`, `pd`.`date`, `gk`.`guild_id` AS `enemy`, `p`.`name`, `pd`.`level`
FROM `guild_kills` gk
LEFT JOIN `player_deaths` pd ON `gk`.`death_id` = `pd`.`id`
LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id`
WHERE `gk`.`war_id` = ' . $war['id'] . ' AND `p`.`deleted` = 0
ORDER BY `pd`.`date` DESC')->fetchAll();
if(!empty($deaths))
{
foreach($deaths as $death)
{
$killers = $SQL->query('SELECT `p`.`name` AS `player_name`, `p`.`deleted` AS `player_exists`, `k`.`war` AS `is_war`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `p`.`id` = `pk`.`player_id`
WHERE `k`.`death_id` = ' . $death['id'] . '
ORDER BY `k`.`final_hit` DESC, `k`.`id` ASC')->fetchAll();
$count = count($killers); $i = 0;
$others = false;
echo date("j M Y, H:i", $death['date']) . " <span style=\"font-weight: bold; color: " . ($death['enemy'] == $war['guild_id'] ? "red" : "lime") . ";\">+</span>
<a href=\"degustatornia.zapto.org//index.php/character/view/" . urlencode($death['name']) . "\"><b>".$death['name']."</b></a> ";
foreach($killers as $killer)
{
$i++;
if($killer['is_war'] != 0)
{
if($i == 1)
echo "killed at level <b>".$death['level']."</b> by ";
else if($i == $count && $others == false)
echo " and by ";
else
echo ", ";
if($killer['player_exists'] == 0)
echo "<a href=\"degustatornia.zapto.org//index.php/character/view/".urlencode($killer['player_name'])."\">";
echo $killer['player_name'];
if($killer['player_exists'] == 0)
echo "</a>";
}
else
$others = true;
if($i == $count)
{
if($others == true)
echo " and few others";
echo ".<br />";
}
}
}
}
else
echo "<center>There were no frags on this war so far.</center>";
}
else
echo "<center>This war did not began yet.</center>";
echo "</td>
</tr>";
}
if($count == 0)
echo "<tr style=\"background: ".$config['site']['darkborder'].";\">
<td colspan=\"3\">Currently there are no active wars.</td>
</tr>";
echo "</table>";
?>
