lib/field.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 Field
{
    var $oDB;       
    var $oUser;     
    var $oLog;      
    var $aField;    
    var $oTown;     

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

    function get( $x, $y )
    {
        $this->aField = array(
            'fow' => 1,
            'border' => NULL,
            'building' => NULL,
            'street' => NULL,
            'unit' => NULL,
            'player_id' => NULL,
            'name' => NULL,
            'guild_id' => NULL,
            'race' => NULL,
            'typ' => NULL,
            'town_name' => NULL,
            'town_id' => NULL,
            'sight' => NULL );


        if( !$this->oUser->check( $x, $y ) )
        {
            return $this->aField;
        }

        // get field data
        $aRow = $this->oDB->fetch_assoc($this->oDB->query("SELECT m.* FROM `".$this->oDB->tblMap."` m WHERE m.`x`='$x' AND m.`y`='$y';" ) );
        $this->aField['terrain'] = $aRow['terrain'];
        $this->aField['x'] = $aRow['x'];
        $this->aField['y'] = $aRow['y'];

        $sqlResult = $this->oDB->query("SELECT m.* FROM `".$this->oDB->tblMapData."` m WHERE m.`x`='$x' AND m.`y`='$y';" );
        if( $this->oDB->num_rows( $sqlResult ) )
        {
            $aRow = $this->oDB->fetch_assoc( $sqlResult );
            $this->aField['fow'] = $aRow['fow'];
            $this->aField['border'] = $aRow['border'];
            $this->aField['building'] = $aRow['building'];
            $this->aField['street'] = $aRow['street'];
            $this->aField['unit'] = $aRow['unit'];
        }

        $sqlResult = $this->oDB->query("SELECT p.*, t.name AS town_name, t.town_id, t.sight ".
                                       "FROM `".$this->oDB->tblTown."` t ".
                                       "LEFT JOIN `".$this->oDB->tblPlayer."` p USING (`player_id`) ".
                                       "WHERE t.`x`='$x' AND t.`y`='$y';");
        if( $this->oDB->num_rows( $sqlResult ) )
        {
            $aRow = $this->oDB->fetch_assoc( $sqlResult );
            $this->aField['player_id'] = $aRow['player_id'];
            $this->aField['name'] = $aRow['name'];
            $this->aField['guild_id'] = $aRow['guild_id'];
            $this->aField['race'] = $aRow['race'];
            $this->aField['typ'] = $aRow['typ'];
            $this->aField['town_name'] = $aRow['town_name'];
            $this->aField['town_id'] = $aRow['town_id'];
            $this->aField['sight'] = $aRow['sight'];
        }
        return $this->aField;
    }

    function set( $x, $y, $strPlayer, $strTown, $intGuild, $intType, $intRace, $intTown, $intSight )
    {
        if( !$this->oUser->check( $x, $y ) )
        {
            // user has no access to this field
            return false;
        }
        $this->get( $x, $y );

        if( $strPlayer == '' )
        {
            // remove the owner of the town
            $this->oTown->set( $this->aField['town_id'], $this->aField['town_name'], 1 );
        }
        else
        {
            $booUpdate = false;
            $strQuery = "UPDATE `".$this->oDB->tblPlayer."` SET ";

            // do not save unknown guild/type/race
            if( $intGuild > 0 )
            {
                $strQuery .= " `guild_id`='$intGuild'";
                $booUpdate = true;
            }
            if( $intType != 0 )
            {
                if( $strQuery ) $strQuery .= ',';
                $strQuery .= " typ='$intType'";
                $booUpdate = true;
            }
            if( $intRace != 0 )
            {
                if( $strQuery ) $strQuery .= ',';
                $strQuery .= " race='$intRace'";
                $booUpdate = true;
            }

            // get new owner
            $aRow = $this->oDB->query_first( "SELECT `player_id`, `name` FROM `".$this->oDB->tblPlayer."` WHERE UPPER(`name`)=UPPER('$strPlayer');");
            if( $aRow['player_id'] != $this->aField['player_id'] || is_null( $aRow['player_id'] ) )
            {
                // link town with new owner
                if( strcasecmp( $aRow['name'], $strPlayer ) != 0 )
                {
                    // there is no player entry in the database
                    $this->oDB->query("INSERT INTO `".$this->oDB->tblPlayer."` SET name='$strPlayer', guild_id='$intGuild', typ='$intType', race='$intRace'".$GLOBALS['strUpdateString'].$GLOBALS['strCreatedString'].";");
                    $aRow['player_id'] = $this->oDB->insert_id();
                }
                $this->oTown->set( $this->aField['town_id'], $strTown, $aRow['player_id'], $intSight );
            }
            else
            {
                // owner has not changed
                if( $strTown != $this->aField['town_name'] || $intSight != $this->aField['sight'] )
                {
                    // update townname
                    $this->oTown->set( $this->aField['town_id'], $strTown, -1, $intSight );
                }
            }

            // update guild/race/type?
            if( $booUpdate && $aRow['player_id'] > 1 )
            {
                $strQuery .= $GLOBALS['strUpdateString']." WHERE player_id='".$aRow['player_id']."';";
                $this->oDB->query( $strQuery );
            }
        }

        // towntype has changed
        if( $intTown != 0 )
        {
          $this->oDB->query( "UPDATE `".$this->oDB->tblMapData."` SET `building` ='$intTown' WHERE `x`='$x' AND `y`='$y'" );
        }
        return true;
    }

    function add( $x, $y, $intTownType = -1 )
    {
        if( !$this->oUser->check( $x, $y ) )
        {
            // user has no access to this field
            return false;
        }

        $this->get( $x, $y );
        if( $this->aField['town_id'] != NULL )
        {
            // town already exists
            return false;
        }

        // create new town
        $intTownId = $this->oTown->add( $x, $y, '', 1 );

        // link town with field
        $this->oDB->query( "SELECT x,y FROM `".$this->oDB->tblMapData."` WHERE `x`='$x' AND `y`='$y';");
        $aRows = $this->oDB->fetch_array();
        if(  $this->oDB->affected_rows() > 0 )
        {
            $this->oDB->query( "UPDATE `".$this->oDB->tblMapData."` SET `building`='".$intTownType."'".$GLOBALS['strUpdateString']." WHERE `x`='$x' AND `y`='$y';");
        }
        else
        {
            $this->oDB->query( "REPLACE INTO `".$this->oDB->tblMapData."` SET `building`='".$intTownType."', `x`='$x', `y`='$y'".$GLOBALS['strUpdateString'].";");
        }
        $this->oDB->query( "SELECT x,y FROM `".$this->oDB->tblMap."` WHERE `x`='$x' AND `y`='$y';");
        $aRows = $this->oDB->fetch_array();
        if(  $this->oDB->affected_rows() < 1 )
        {
            $this->oDB->query("INSERT INTO ".$this->oDB->tblMap." SET `x`='$x', `y`='$y', `terrain`='0';");
        }
        return true;
    }

    function delete( $x, $y )
    {
        if( !$this->oUser->check( $x, $y ) )
        {
            // user has no access to this field
            return false;
        }

        $this->get( $x, $y );
        if( $x == $this->aField['x'] && $y == $this->aField['y'] && $this->aField['town_id'] > 0 )
        {
            $this->oTown->delete( $this->aField['town_id'], $x, $y );
            return true;
        }
        // field/town did not exist
        return false;
    }
}

---