Guild Wars To invite guild to war use your guild page.
"; $warFrags = array(); foreach($SQL->query('SELECT * FROM `guildwar_kills` ORDER BY `time` DESC')->fetchAll() as $frag) { $warFrags[$frag['warid']][] = $frag; } $count = 0; foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` ORDER BY `started` DESC') as $war) { $count++; $main_content .= ""; } if($count == 0) $main_content .= ""; $main_content .= "

Aggressor	Information	Enemy
".htmlspecialchars($war['name1'])."	"; switch($war['status']) { case 0: { $main_content .= "Pending acceptation Invited on " . date("M d Y, H:i:s", $war['started']) . " for " . (($war['ended'] - $war['started']) / 86400) . " days. "; break; } case 1: { $main_content .= "" . $war['guild1_kills'] . " : " . $war['guild2_kills'] . " On a brutal war Began on " . date("M d Y, H:i:s", $war['started']) . ", will end up after server restart after " . date("M d Y, H:i:s", $war['started'] + (7*86400)) . ". "; $main_content .= " "; if(in_array($war['status'], array(1,4))) { $main_content .= "» Details «"; } break; } case 2: { $main_content .= "Rejected invitation Invited on " . date("M d Y, H:i:s", $war['started']) . ", rejected on " . date("M d Y, H:i:s", $war['ended']) . ". "; break; } case 3: { $main_content .= "Canceled invitation Sent invite on " . date("M d Y, H:i:s", $war['started']) . ", canceled on " . date("M d Y, H:i:s", $war['ended']) . ". "; break; } case 4: { $main_content .= "Ended Began on " . date("M d Y, H:i:s", $war['started']) . ", ended on " . date("M d Y, H:i:s", $war['ended']) . ". Frag statistics: " . $war['guild1_kills'] . " to " . $war['guild2_kills'] . "."; $main_content .= " "; if(in_array($war['status'], array(1,4))) { $main_content .= "» Details «"; } break; } default: { $main_content .= "Unknown, please contact with gamemaster."; break; } } $main_content .= "	".htmlspecialchars($war['name2'])."
"; if(in_array($war['status'], array(1,4))) { if(isset($warFrags[$war['id']])) { foreach($warFrags[$war['id']] as $frag) { $main_content .= date("j M Y, H:i", $frag['time']) . " +".htmlspecialchars($frag['killer'])." killed " . htmlspecialchars($frag['target']) . ""; } } else $main_content .= "There were no frags on this war so far."; } else $main_content .= "
Currently there are no active wars.

";