lib/worldmap.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 WorldMap
{
    var $oDB;   
    var $oUser; 

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

    function getTowns( $intFields = 1, $intZoom = 1, $intX = 0, $intY = 0, $strFilter = '' )
    {
        global $intMapSize;
        if( $strFilter != '' )
        {
            $strFilter = ' AND g.`guild_id` IN ('.str_replace('_', ',', substr($strFilter, 1)).')';
        }

        $intMinX    = $intX * $intFields;
        $intMinY    = $intY * $intFields;
        $intMaxX    = ($intX+1) * $intFields;
        $intMaxY    = ($intY+1) * $intFields;

        if( $this->oUser->intLimitView > 0 )
        {
            // user has not full view
            $strFilter .= ' AND t.x BETWEEN '.( $this->oUser->intHomeX - $this->oUser->intLimitView).' AND '.($this->oUser->intHomeX + $this->oUser->intLimitView);
            $strFilter .= ' AND t.y BETWEEN '.( $this->oUser->intHomeY - $this->oUser->intLimitView).' AND '.($this->oUser->intHomeY + $this->oUser->intLimitView);
        }

        // Stadtdaten
        $result = $this->oDB->query("SELECT p.`name`, p.typ, p.race, g.`tag`, g.`bgcolor`, g.`diplomacy`, t.`x`, t.`y`, m.building ".
                          "FROM `".$this->oDB->tblTown."` t ".
                          "LEFT JOIN `".$this->oDB->tblMapData."` m ON (t.x=m.x AND t.y=m.y) ".
                          "LEFT JOIN `".$this->oDB->tblPlayer."` p ON (t.`player_id`=p.`player_id`) ".
                          "LEFT JOIN `".$this->oDB->tblGuild."` g ON (g.`guild_id`=p.`guild_id`) ".
                          "WHERE `t`.`x` BETWEEN '$intMinX' AND '$intMaxX' AND `t`.`y` BETWEEN '$intMinY' AND '$intMaxY' AND t.`player_id`>'0' AND m.`building` > '-10' $strFilter;");

        $aReturn = array();
        while( $aRow = $this->oDB->fetch_assoc($result) )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }

    function getGuilds()
    {
        $sqlResult = $this->oDB->query( "SELECT `tag`, `guild_id` FROM `".$this->oDB->tblGuild."` ORDER BY `tag`;");
        $aReturn = array();
        while( $aRow = $this->oDB->fetch_assoc() )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }
}

---