lib/guild.php

Go to the documentation of this file.

<?php
/***************************************************************************
 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 as published by the Free Software Foundation; either version 2
 of the License, or (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU 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.
 ***************************************************************************/

class Guild
{
    var $oDB;   
    var $oLog;  
    var $oUser;

    function Guild ( &$oDB, &$oLog, &$oUser )
    {
        $this->oUser =& $oUser;
        $this->oDB =& $oDB;
        $this->oLog =& $oLog;
    }

    function get ( $intId = 0 )
    {
        $this->oDB->query("SELECT `guild_id`, `name`, `tag`, `fgcolor`, `bgcolor`, `diplomacy` FROM `".$this->oDB->tblGuild."` WHERE `guild_id`='$intId';");
        $aRow = $this->oDB->fetch_assoc();

        if ( $aRow['guild_id'] != $intId )
        {
            // guild does not exist
            return false;
        }

        return $aRow;
    }

    function set ( $intId, $strName, $strTag, $strFgColor, $strBgColor, $intDiplomacy )
    {
        $this->oDB->query("UPDATE `".$this->oDB->tblGuild."`
                           SET `name`='$strName',`tag`='$strTag', `bgcolor`='$strBgColor', `fgcolor`='$strFgColor', `diplomacy`='$intDiplomacy', `last_update`='".time()."', `last_update_by`='".$this->oUser->intUserID."'
                           WHERE `guild_id`='$intId';");
        $this->oLog->write( 'Gildenupdate: [' . $strTag . '] (id=' . $intId . ')', 4 );
    }

    function add ( $strName, $strTag, $strFgColor='', $strBgColor='', $intDiplomacy=0 )
    {
        $this->oDB->query("SELECT `guild_id` FROM `".$this->oDB->tblGuild."` WHERE `name`='$strName' OR `tag`='$strTag';");
        $aRow = $this->oDB->fetch_assoc();
        if ( $aRow['guild_id'] > 0 )
        {
            // guild with this name or tag already exists
            return false;
        }

        $strMore = '';
        if ( strlen($strFgColor) > 0 )
        {
            $strMore .= ", `fgcolor`='$strFgColor'";
        }
        if ( strlen($strBgColor) > 0 )
        {
            $strMore .= ", `bgcolor`='$strBgColor'";
        }
        if ( $intDiplomacy != 0 )
        {
            $strMore .= ", `diplomacy`='$intDiplomacy'";
        }

        $this->oDB->query("INSERT INTO `".$this->oDB->tblGuild."` ".
                          "SET `name`='$strName', `tag`='$strTag', `last_update`='".time()."', `last_update_by`='".$this->oUser->intUserID."', ".
                          "`created`='".time()."', `created_by`='".$this->oUser->intUserID."'$strMore;");
        $this->oLog->write( "Gilde angelegt: [" . $strTag . "]", 4 );
        return true;
    }

    function delete ( $intGuild )
    {
        if ( $intGuild < 2 )
        {
            return false;
        }
        $this->oDB->query("UPDATE ".$this->oDB->tblPlayer." SET guild_id='1' WHERE guild_id='".$intGuild."';");
        $this->oDB->query("DELETE FROM ".$this->oDB->tblGuild." WHERE guild_id='".$intGuild."';");
        return true;
    }


    function getAll()
    {
        $aReturn = array();
        $aMembers = array();
        $aTowns = array();
        // first get the member count of each guild
        $sqlResult = $this->oDB->query("SELECT COUNT(player_id) as count, guild_id FROM ".$this->oDB->tblPlayer." GROUP BY guild_id;");
        while ( $aRow = $this->oDB->fetch_assoc ( $sqlResult ) )
        {
            $aMembers[$aRow['guild_id']] = $aRow['count'];
        }

        // now get count of towns
        $sqlResult = $this->oDB->query("SELECT COUNT(t.town_id) as count, p.guild_id FROM ".$this->oDB->tblTown." t LEFT JOIN ".$this->oDB->tblPlayer." p USING (player_id) LEFT JOIN `".$this->oDB->tblMapData."` m ON (t.x=m.x AND t.y=m.y) WHERE m.`building` > '-10' GROUP BY p.guild_id;");
        while ( $aRow = $this->oDB->fetch_assoc ( $sqlResult ) )
        {
            $aTowns[$aRow['guild_id']] = $aRow['count'];
        }

        // now get the guilds
        $sqlResult = $this->oDB->query("SELECT `guild_id`, `name`, `tag`, `bgcolor`, `fgcolor`, `diplomacy` FROM `".$this->oDB->tblGuild."` ORDER BY `tag`;");
        while ( $aRow = $this->oDB->fetch_assoc ( $sqlResult ) )
        {
            $aRow['members'] = isset ( $aMembers[$aRow['guild_id']] ) ? $aMembers[$aRow['guild_id']] : 0;
            $aRow['towns']   = isset ( $aTowns[$aRow['guild_id']] )   ? $aTowns[$aRow['guild_id']]   : 0;
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }
}

---