lib/towninfo.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 TownInfo
{
    var $oDB;   
    var $oLog;  

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

    function add( $x, $y, $strName='', $intPlayer=1, $strInfos='', $intTownhall=0, $intSight=0 )
    {
        $this->oDB->query( "INSERT INTO `".$this->oDB->tblTown."` SET `x`='$x', `y`='$y', `name`='$strName', `player_id`='$intPlayer', `townhall`='$intTownhall', `sight`='$intSight', `infos`='$strInfos'".$GLOBALS['strUpdateString'].$GLOBALS['strCreatedString'].";" );
        return $this->oDB->insert_id();
    }

    function get( $x, $y )
    {
        $sqlResult = $this->oDB->query( "SELECT town_id, name, last_update FROM ".$this->oDB->tblTown." WHERE x='$x' AND y='$y';" );
        if( $this->oDB->num_rows( $sqlResult ) != 1 )
        {
            return false;
        }
        return $this->oDB->fetch_assoc( $sqlResult );
    }

    function getById( $intTownId = 0 )
    {
        $aInfo = $this->oDB->query_first("SELECT `t`.*, `p`.`name` AS `owner`, `p`.`player_id` AS `ownerid`, `u`.`name` AS username, `u2`.`name` AS username2
                              FROM `".$this->oDB->tblTown."` t
                              LEFT JOIN `".$this->oDB->tblPlayer."` p ON (`t`.`player_id`=`p`.`player_id`)
                              LEFT JOIN `".$this->oDB->tblUser."` u ON (`t`.`last_update_by`=`u`.`user_id`)
                              LEFT JOIN `".$this->oDB->tblUser."` u2 ON (`t`.`created_by`=`u2`.`user_id`)
                              WHERE `t`.`town_id`='$intTownId';");
        // Existenzpruefung
        if ( $aInfo['town_id'] != $intTownId )
        {
            return false;
        }
        return $aInfo;
    }

    function getTowns( $intPlayerId, $intNoTown = 0 )
    {
        $aResult = array();
        $this->oDB->query("SELECT `name`, `town_id`, `t`.`x`, `t`.`y` FROM `".$this->oDB->tblTown."` t LEFT JOIN `".$this->oDB->tblMapData."` m USING (x,y) WHERE m.`building` > '-10' AND `player_id`='$intPlayerId' AND `town_id`!='$intNoTown';");
        while ( $aRow = $this->oDB->fetch_assoc() )
        {
            $aResult[] = $aRow;
        }
        return $aResult;
    }

    function set( $intTownId, $strName, $intPlayer=-1, $intSight=-1, $intTownhall=-1, $strInfos=-1, $booPrepend = false )
    {
        $strQuery = "UPDATE `".$this->oDB->tblTown."` SET `name`='$strName'";
        if( $intPlayer !== -1 )
        {
            $strQuery .= ", `player_id`='$intPlayer'";
        }
        if( $intSight !== -1 )
        {
            $strQuery .= ", `sight`='$intSight'";
        }
        if( $intTownhall !== -1 )
        {
            $strQuery .= ", `townhall`='$intTownhall'";
        }
        if( $strInfos !== -1 )
        {
            $strQuery .= ($booPrepend) ? ", infos=CONCAT('$strInfos', `infos`)" : ", infos='$strInfos'";
        }

        $strQuery .= $GLOBALS['strUpdateString']." WHERE `town_id`='$intTownId' LIMIT 1;";
        $this->oDB->query( $strQuery );
        $this->oLog->write( "Stadtinfo gesichert für: " . $strName . " (id=" . $intTownId. ")", 5);
    }

    function delete( $intTown, $x, $y )
    {
        $this->oDB->query( "DELETE FROM `".$this->oDB->tblTown."` WHERE `town_id`='".$intTown."';" );
        $this->oDB->query("UPDATE `".$this->oDB->tblMapData."` SET `building`=NULL".$GLOBALS['strUpdateString']." WHERE `x`='$x' AND `y`='$y';" );
    }
}

---