export.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.
 ***************************************************************************/

@ob_start();
require_once( './general.php' );
@ob_end_clean();

// get variables
if(isset($_POST['time']))     $intTime = intval( $_POST['time'] );
elseif(isset($_SERVER['HTTP_WDSMAP_TIMESTAMP']))  $intTime = $_SERVER['HTTP_WDSMAP_TIMESTAMP']; // WDSMap
else $intTime = 1;

if(isset($_POST['type']))     $strType = $_POST['type'];
elseif(isset($_GET['type']))  $strType = $_GET['type']; // static
elseif(isset($_SERVER['HTTP_WDSMAP_TYPE']))  $strType = $_SERVER['HTTP_WDSMAP_TYPE']; // WDSMap
else $strType = '';

$booFile = isset($_POST['file']) || isset($_GET['file']);
$strOut = '';

// try to disable the timelimit
@set_time_limit(0);

if( $strType == 'update' )
{
    if( !$oUser->isAdmin( 'export_update' ) )
    {
        // if the client is WDSMap, add some useful header information
        if( preg_match( '/^WDSMAP\//ui', $_SERVER['HTTP_USER_AGENT'] ) )
        {
            header("phpmap-ReturnCode: 3");
            header("phpmap-ErrorMessage: No Access");
        }
        die("ReturnCode: 3\nErrorMessage: No Access\n");
    }

    $strFilename = 'update'.$intServerId.'.dat';
    $strGuild    = '';
    $strPlayer   = '';
    $strTown     = '';
    $aGuild  = array();
    $aPlayer = array();
    $aPlayerGuild = array();
    $aTown   = array();
    $aSight  = array();
    $aTownOwner   = array();
    $intStartTime = time();
    $oMysql->query( "SELECT * FROM ".$oMysql->tblGuild." WHERE last_update>".$intTime.";");
    if( $oMysql->num_rows() > 0 )
    {
        // there are changed guilds
        $strGuild = ' OR guild_id IN (0';
        while( $aRow = $oMysql->fetch_assoc() )
        {
            $strGuild .= ','.$aRow['guild_id'];
            $aGuild[$aRow['guild_id']] = $aRow['tag'];
        }
        $strGuild .= ')';
    }
    $oMysql->query( "SELECT * FROM ".$oMysql->tblPlayer." WHERE last_update>'".$intTime."'".$strGuild.";");
    if( $oMysql->num_rows() > 0 )
    {
        // there are changed players
        $strPlayer = ' OR player_id IN (0';
        $strGuild  = '';
        while( $aRow = $oMysql->fetch_assoc() )
        {
            $strPlayer .= ','.$aRow['player_id'];
            if( !isset( $aGuild[$aRow['guild_id']] ) )
            {
                $strGuild .= ','.$aRow['guild_id'];
            }
            $aPlayer[$aRow['player_id']] = $aRow['name'];
            $aPlayerGuild[$aRow['player_id']] = $aRow['guild_id'];
        }
        $strPlayer .= ')';

        if( $strGuild != '' )
        {
            // there were some players with a guild, not yet in the guild array
            $oMysql->query( "SELECT guild_id, tag FROM ".$oMysql->tblGuild." WHERE guild_id IN (0".$strGuild.");");
            while( $aRow = $oMysql->fetch_assoc() )
            {
                $aGuild[$aRow['guild_id']] = $aRow['tag'];
            }
        }
    }
    $oMysql->query( "SELECT * FROM ".$oMysql->tblTown." WHERE last_update>'".$intTime."'".$strPlayer.";");
    if( $oMysql->num_rows() > 0 )
    {
        $strTownPlayer = '';
        // there are changed towns
        while( $aRow = $oMysql->fetch_assoc() )
        {
            $aSight[$aRow['x'].'-'.$aRow['y']] = $aRow['sight'];
            $aTown[$aRow['x'].'-'.$aRow['y']] = $aRow['name'];
            $aTownOwner[$aRow['x'].'-'.$aRow['y']] = $aRow['player_id'];
            if( !isset( $aPlayer[$aRow['player_id']] ) )
            {
                $strTownPlayer .= ','.$aRow['player_id'];
            }
        }

        if( $strPlayer != '' || $strTownPlayer != '' )
        {
            // there were some players with a guild, not yet in the guild array
            $oMysql->query( "SELECT player_id, name, guild_id FROM ".$oMysql->tblPlayer." WHERE player_id IN (0".$strPlayer.$strTownPlayer.");");
            while( $aRow = $oMysql->fetch_assoc() )
            {
                $aPlayer[$aRow['player_id']] = $aRow['name'];
                $aPlayerGuild[$aRow['player_id']] = $aRow['guild_id'];
            }
        }
    }

    $oMysql->query( "SELECT * FROM ".$oMysql->tblMapData." WHERE (building>-10 OR building IS NULL) AND last_update>'".$intTime."';");

    while( $aRow = $oMysql->fetch_assoc() )
    {
// X Y [BUILDING] [BORDERS] [STREETS] [UNITS] [FOW] [SIGHT] [TOWN_NAME] [PLAYER_NAME] [GUILD]
// details in wdsmap: doc/phpmap_server.dox

        $intUnit = (((time() - $aRow['last_update']) < $oUser->intUnit*60*60))
                    ? intval( $aRow['unit'] )
                    : 0;

        // first needed values
        $strOut .= intval( $aRow['x'] ).' '.intval( $aRow['y'] );
        // now optional values
        $strOut .= ' '.intval( $aRow['building'] ).' '.intval( $aRow['border'] ).' '.intval( $aRow['street'] ).' '.$intUnit.' '.intval( $aRow['fow'] );
        if( isset( $aSight[$aRow['x'].'-'.$aRow['y']] ) )
        {
            $strOut .= ' '.intval( $aSight[$aRow['x'].'-'.$aRow['y']] ).' "'.$aTown[$aRow['x'].'-'.$aRow['y']].'"';
            if( isset( $aTownOwner[$aRow['x'].'-'.$aRow['y']] ) && $aTownOwner[$aRow['x'].'-'.$aRow['y']]>0 
                && isset( $aPlayer[$aTownOwner[$aRow['x'].'-'.$aRow['y']]] ) )
            {
                // the town belongs to a user
                $strOut .= ' "'.$aPlayer[$aTownOwner[$aRow['x'].'-'.$aRow['y']]].'"';
                if( isset( $aPlayerGuild[$aTownOwner[$aRow['x'].'-'.$aRow['y']]] ) && $aPlayerGuild[$aTownOwner[$aRow['x'].'-'.$aRow['y']]]>0 )
                {
                    // the user has a guild
                    $strOut .= ' "'.$aGuild[$aPlayerGuild[$aTownOwner[$aRow['x'].'-'.$aRow['y']]]].'"';
                }
            }
        }

        $strOut .= "\n";
    }

    // add header for WDSMap
    header( "phpmap-ReturnCode: 0" );
    header( "phpmap-Version: 1" );
    header( "phpmap-Timestamp: ".$intStartTime );
    header( "phpmap-DataSize: ".strlen($strOut) );
}
elseif( $strType == 'static' )
{
    if( !$oUser->isAdmin( 'export_static' ) )
    {
        // if the client is WDSMap, add some useful header information
        if( preg_match( '/^WDSMAP\//ui', $_SERVER['HTTP_USER_AGENT'] ) )
        {
            header("phpmap-ReturnCode: 3");
            header("phpmap-ErrorMessage: No Access");
        }
        die("ReturnCode: 3\nErrorMessage: No Access\n");
    }

    $strFilename = 'server'.$intServerId.'.dat';
    $sqlResult = $oMysql->query( "SELECT x,y,building,unit,border,street FROM ".$oMysql->tblMapData.";");

    $strBuilding = "[buildings]\n";
    $strUnit     = "\n[units]\n";
    $strBorder   = "\n[border]\n";
    $strStreet   = "\n[streets]\n";
    $strTown     = "\n[towns]\n";

    while( $aRow = $oMysql->fetch_assoc($sqlResult) )
    {
        if( !is_null($aRow['building']) && ( $aRow['building'] > -10) )
        {
            if( $aRow['building'] < 0 )
            {
                // town dummy
                $aRow['building'] = 97;
            }
            $strBuilding .= $aRow['x'].' '.$aRow['y'].' '.$aRow['building']."\n";
        }
        if( !is_null($aRow['unit']) )
        {
            $strUnit .= $aRow['x'].' '.$aRow['y'].' '.$aRow['unit']."\n";
        }
        if( !is_null($aRow['border']) )
        {
            $strBorder .= $aRow['x'].' '.$aRow['y'].' '.$aRow['border']."\n";
        }
        if( !is_null($aRow['street']) )
        {
            $strStreet .= $aRow['x'].' '.$aRow['y'].' '.$aRow['street']."\n";
        }
    }

    // get towns
    $sqlResult = $oMysql->query( "SELECT t.x, t.y, t.name AS tname, p.name AS pname, g.tag ".
                                 "FROM ".$oMysql->tblTown." t ".
                                 "LEFT JOIN ".$oMysql->tblPlayer." p USING (player_id) ".
                                 "LEFT JOIN ".$oMysql->tblGuild." g USING (guild_id)" .
                                 "LEFT JOIN `".$oMysql->tblMapData."` m ON (t.x=m.x AND t.y=m.y) ".
                                 "WHERE m.`building` > '-10';" );

    while( $aRow = $oMysql->fetch_assoc( $sqlResult ) )
    {
        $strTown .= $aRow['x'].' '.$aRow['y'].' "'.$aRow['tname'].'" "'.$aRow['pname'].'" "'.$aRow['tag'].'"'."\n";
    }

    $strOut = $strBuilding.$strUnit.$strBorder.$strStreet.$strTown;
}
else
{
    // if the client is WDSMap, add some useful header information
    if( preg_match( '/^WDSMAP\//ui', $_SERVER['HTTP_USER_AGENT'] ) )
    {
        header("phpmap-ReturnCode: 2");
        header("phpmap-ErrorMessage: Invalid export type");
    }
    die("ReturnCode: 2\nErrorMessage: Invalid export type\n");
}

if( $booFile )
{
    header("Content-Description: File Transfer");
    header("Content-Type: application/force-download");
    header("Content-Disposition: attachment; filename=".$strFilename);
}
echo $strOut;

---