Gesior :3

Absolute  Qd vc? ;=;

qual versão tfs você usa primeiramente?

qual versão tfs você usa primeiramente?

tfs 1.0 (10.41) :3

Desculpa, estava atarefado, segue:

 

página guilds.php com o suport:  http://paste.ots.me/560176/text

 

Wars.php:

<?php
if(!defined('INITIALIZED'))
    exit;

$main_content = "<h1 align=\"center\">Guild Wars</h1>
To invite guild to war use your guild page.
<br>
<script type=\"text/javascript\"><!--
function show_hide(flip)
{
        var tmp = document.getElementById(flip);
        if(tmp)
                tmp.style.display = tmp.style.display == 'none' ? '' : 'none';
}
--></script>
<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"4\">
<tr>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Aggressor</b></td>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\"><b>Information</b></td>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Enemy</b></td>
</tr>";

$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 .= "<tr style=\"background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">
<td align=\"center\"><a href=\"?subtopic=guilds&action=show&guild=".$war['guild1']."\"><img src=\"guild_image.php?id= . $war['guild1] . "\" width=\"64\" height=\"64\" border=\"0\"/><br />".htmlspecialchars($war['name1'])."</a></td>
<td class=\"white\" align=\"center\">";
    switch($war['status'])
    {
        case 0:
        {
            $main_content .= "<font color=black><b>Pending acceptation</b><br />Invited on " . date("M d Y, H:i:s", $war['started']) . " for " . (($war['ended'] - $war['started']) / 86400) . " days.<br /><br /><br /></font>";
            break;
        }
        case 1:
        {
            $main_content .= "<font size=\"12\"><span style=\"color: red;\">" . $war['guild1_kills'] . "</span><font color=black> : </font><span style=\"color: lime;\">" . $war['guild2_kills'] . "</span></font><br /><br /><span style=\"color: darkred; font-weight: bold;\">On a brutal war</span><br /><font color=black>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)) . ".<br /></font>";
            $main_content .= "<br /><br />";
            if(in_array($war['status'], array(1,4)))
            {
                $main_content .= "<a onclick=\"show_hide('war-details:" . $war['id'] . "'); return false;\" style=\"cursor: pointer;\">&raquo; Details &laquo;</a>";
            }
            break;
        }
        case 2:
        {
            $main_content .= "<font color=black><b>Rejected invitation</b><br />Invited on " . date("M d Y, H:i:s", $war['started']) . ", rejected on " . date("M d Y, H:i:s", $war['ended']) . ".<br /><br /><br /></font>";
            break;
        }
        case 3:
        {
            $main_content .= "<font color=black><b>Canceled invitation</b><br />Sent invite on " . date("M d Y, H:i:s", $war['started']) . ", canceled on " . date("M d Y, H:i:s", $war['ended']) . ".<br /><br /><br /></font>";
            break;
        }
        case 4:
        {
            $main_content .= "<b><i>Ended</i></b><br />Began on " . date("M d Y, H:i:s", $war['started']) . ", ended on " . date("M d Y, H:i:s", $war['ended']) . ". Frag statistics: <span style=\"color: red;\">" . $war['guild1_kills'] . "</span> to <span style=\"color: lime;\">" . $war['guild2_kills'] . "</span>.";
            $main_content .= "<br /><br />";
            if(in_array($war['status'], array(1,4)))
            {
                $main_content .= "<a onclick=\"show_hide('war-details:" . $war['id'] . "'); return false;\" style=\"cursor: pointer;\">&raquo; Details &laquo;</a>";
            }
            break;
        }
        default:
        {
            $main_content .= "Unknown, please contact with gamemaster.";
            break;
        }
    }
    $main_content .= "</td>
        <td align=\"center\"><a href=\"?subtopic=guilds&action=show&guild=".$war['guild2']."\"><img src=\"guild_image.php?id= . $war['guild2] . "\" width=\"64\" height=\"64\" border=\"0\"/><br />".htmlspecialchars($war['name2'])."</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)))
    {
        if(isset($warFrags[$war['id']]))
        {
            foreach($warFrags[$war['id']] as $frag)
            {
                $main_content .= date("j M Y, H:i", $frag['time']) . " <span style=\"font-weight: bold; color: " . ($frag['killerguild'] == $war['guild1'] ? "red" :"lime") . ";\">+</span><a href=\"?subtopic=characters&name= . urlencode($frag['killer]) . "\"><b>".htmlspecialchars($frag['killer'])."</b></a> killed <a href=\"?subtopic=characters&name=.urlencode($frag['target])."\"> " . htmlspecialchars($frag['target']) . "</a>";
            }
        }
        else
            $main_content .= "<center>There were no frags on this war so far.</center>";
    }
    else
        $main_content .= "</td></tr>";
}

if($count == 0)
    $main_content .= "<tr style=\"background:".$config['site']['darkborder'].";\">
<td colspan=\"3\">Currently there are no active wars.</td>
</tr>";

$main_content .= "</table>";

 

Guildwar.php:

<?php
if(!defined('INITIALIZED'))
    exit;

class GuildWar extends ObjectData
{
    const STATE_INVITED = 0;
    const STATE_ON_WAR = 1;
    const STATE_REJECTED = 2;
    const STATE_CANCELED = 3;
    const STATE_WAR_ENDED = 4;

    public static $table = 'guild_wars';
    public $data = array('guild_id' => null, 'name' => null, 'level' => null,);
    public static $fields = array('id', 'guild1', 'guild2', 'name1', 'name2', 'status', 'started', 'ended');

public function __construct($warID = null)
{
        if($warID != null)
            $this->load($warID);
}

    public function load($id)
    {
        $fieldsArray = array();
        foreach(self::$fields as $fieldName)
            $fieldsArray[] = $this->getDatabaseHandler()->fieldName($fieldName);

        $this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($id))->fetch();
    }

    public function save($forceInsert = false)
    {
        if(!isset($this->data['id']) || $forceInsert)
        {
            $keys = array();
            $values = array();
            foreach(self::$fields as $key)
                if($key != 'id')
                {
                    $keys[] = $this->getDatabaseHandler()->fieldName($key);
                    $values[] = $this->getDatabaseHandler()->quote($this->data[$key]);
                }
            $this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName(self::$table) . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')');
            $this->setID($this->getDatabaseHandler()->lastInsertId());
        }
        else
        {
            $updates = array();
            foreach(self::$fields as $key)
                $updates[] = $this->getDatabaseHandler()->fieldName($key) . ' = ' . $this->getDatabaseHandler()->quote($this->data[$key]);
            $this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . implode(', ', $updates) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
        }
    }

    public function delete()
    {
        if($this->isLoaded())
        {
            $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
            $_tmp = new self();
            $this->data = $_tmp->data;
            unset($_tmp);
        }
        else
            new Error_Critic('', __METHOD__ . '() - cannot delete, guild war not loaded');
    }

    public function getID(){return $this->data['id'];}
    public function setID($value){$this->data['id'] = $value;}
    public function getGuild1ID(){return $this->data['guild1'];}
    public function setGuild1ID($value){$this->data['guild1'] = $value;}
    public function getGuild2ID(){return $this->data['guild2'];}
    public function setGuild2ID($value){$this->data['guild2'] = $value;}
    public function getGuild1Name(){return $this->data['name1'];}
    public function setGuild1Name($value){$this->data['name1'] = $value;}
    public function getGuild2Name(){return $this->data['name2'];}
    public function setGuild2Name($value){$this->data['name2'] = $value;}
    public function getStatus(){return $this->data['status'];}
    public function setStatus($value){$this->data['status'] = $value;}
    public function getStarted(){return $this->data['started'];}
    public function setStarted($value){$this->data['started'] = $value;}
    public function getEnded(){return $this->data['ended'];}
    public function setEnded($value){$this->data['ended'] = $value;}
}

 

Basta usar as querys que mandei a cima e a talkaction de invitewar.