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

define( 'PHPMAP_FROM_VERSION', '2.0' );
define( 'PHPMAP_TO_VERSION', '2.0.1' );

if(isset($_POST['step']))     $intStep = $_POST['step'];
elseif(isset($_GET['step']))  $intStep = $_GET['step'];
else $intStep = 0;

/* Steps
 * 0 - check if template system, config and mysql are available and correct version is used
 * 1 - perform the update
 * 2 - (for security reasons) try delete update.html and update.php
 */
if( $intStep == 0 )
{
    // try to create a Template object
    if( !file_exists('./lib/template.php') || !file_exists('./templates/default/update.html') )
    {
        echo 'Template Klasse wurde nicht gefunden<br />'.
            'Vergewissere dich, dass alle Dateien korrekt hochgeladen wurden und alle Ordner richtig erstellt wurden.<br />'.
            'Falls du Hilfe ben&ouml;tigst, komm in #wdstools im Andaloria Irc :)';
        die();
    }
    require_once( './lib/template.php' );
    $oStyle = new Template( './templates/default/' );
    $oStyle->addReplacements( array( 'TEMPLATES' => $oStyle->getPath() ) );
    $oStyle->setTemplate ( 'update.html' );

    // look for the config.php
    if( !file_exists( './conf/config.php' )  )
    {
        $strMessage = $oStyle->get_area( 'ErrorConfig' );
        $oStyle->addReplacements( array( 'ERROR' => $strMessage ) );
        echo $oStyle->get_area( 'Error' );
        die();
    }

    // get the config settings
    error_reporting(0);
    include( './conf/config.php' );
    error_reporting(E_ALL);

    if( $strPhpMapVersion != PHPMAP_FROM_VERSION )
    {
        $oStyle->addReplacements( array( 'FOUND_VERSION' => $strPhpMapVersion, 'NEW_VERSION' => PHPMAP_FROM_VERSION ) );
        $strMessage = $oStyle->get_area( 'ErrorVersion' );
        $oStyle->addReplacements( array( 'ERROR' => $strMessage ) );
        echo $oStyle->get_area( 'Error' );
        die();
    }

    // try to connect to DB
    $sqlLink = @mysql_connect( $strMysqlHost, $strMysqlUser, $strMysqlPwd );

    if( $sqlLink === false || !@mysql_select_db( $strMysqlDb, $sqlLink ) )
    {
        $strMessage = $oStyle->get_area( 'ErrorMysql' );
        $oStyle->addReplacements( array( 'ERROR' => $strMessage ) );
        echo $oStyle->get_area( 'Error' );
        die();
    }

    unset( $strMysqlHost, $strMysqlUser, $strMysqlPwd, $strMysqlDb ); // aren't used anymore

    // check for double entries in map_data

    $sqlResult = mysql_query( 'SELECT COUNT(x) AS cnt FROM `'.$strMysqlPrefix.'map_data` GROUP BY x, y HAVING cnt>1' );
    $intCount = intval( @mysql_result( $sqlResult , 0, 0 ) );
    if( $intCount > 0 )
    {
        $oStyle->addReplacements( array( 'DOUBLES' => $intCount ) );
        $strContinue = $oStyle->get_area( 'Step0Warning' );
    }
    else
    {
        $strContinue = $oStyle->get_area( 'Step0Continue' );
    }
    $oStyle->addReplacements( array( 'CONTINUE' => $strContinue ) );

    // templatesystem, config and mysql are available
    // show infos and start update in next step
    echo $oStyle->get_area( 'Step0' );
    die();
}
// 1 - perform the update
elseif( $intStep == 1 )
{
    // template class was validated in step 0, if the user tricks us in faking the _GET Parameter, it's his own fault :)
    require_once( './lib/template.php' );
    $oStyle = new Template( './templates/default/' );
    $oStyle->addReplacements( array( 'TEMPLATES' => $oStyle->getPath() ) );
    $oStyle->setTemplate ( 'update.html' );

    include( './conf/config.php' );

    $sqlLink = @mysql_connect( $strMysqlHost, $strMysqlUser, $strMysqlPwd );
    @mysql_select_db( $strMysqlDb, $sqlLink );

    //-------------------------------------------------------------------------
    // fix map_data table
    $sqlResult = mysql_query( 'SELECT COUNT(x) AS cnt FROM `'.$strMysqlPrefix.'map_data` GROUP BY x, y HAVING cnt>1' );
    $intCount = intval( @mysql_result( $sqlResult , 0, 0 ) );

    if( $intCount > 0 && !empty( $_REQUEST['clear_doubles'] ) )
    {
        $sqlResult = mysql_query( 'SELECT COUNT(x) AS cnt, m.* FROM `'.$strMysqlPrefix.'map_data` m GROUP BY x, y HAVING cnt>1' );
        while( $aRow = mysql_fetch_assoc( $sqlResult ) )
        {
            if( $aRow['x'] == 0 || $aRow['y'] == 0 || $aRow['last_update'] == 0 ) continue;

            // find most recent Record
            $sqlResult2 = mysql_query( "SELECT * FROM `".$strMysqlPrefix."map_data` WHERE x='".$aRow['x']."' AND y='".$aRow['y']."' ORDER BY last_update DESC LIMIT 1" );

            $aRow = mysql_fetch_assoc( $sqlResult2 );

            if( $aRow['building'] == 0 ) $aRow['building'] = 'NULL';
            if( $aRow['border'] == 0 ) $aRow['border'] = 'NULL';
            if( $aRow['street'] == 0 ) $aRow['street'] = 'NULL';
            if( $aRow['unit'] == 0 ) $aRow['unit'] = 'NULL';

            mysql_query( 'DELETE FROM '.$strMysqlPrefix."map_data WHERE x='".$aRow['x']."' AND y='".$aRow['y']."'" );
            mysql_query( 'INSERT INTO '.$strMysqlPrefix."map_data SET x='".$aRow['x']."', y='".$aRow['y']."', fow='".$aRow['fow']."', building=".$aRow['building'].", border=".$aRow['border'].", unit=".$aRow['unit'].", street=".$aRow['street'].", last_update='".$aRow['last_update']."', last_update_by='".$aRow['last_update_by']."'" );
        }
    }

    // select all towns and check if a building exists in map_data
    $sqlResult = mysql_query( 'SELECT x, y FROM `'.$strMysqlPrefix.'town` t'  );
    while( $aRow = mysql_fetch_assoc( $sqlResult ) )
    {
        // get the terrain info for that field
        $sqlResult2 = mysql_query( 'SELECT x FROM `'.$strMysqlPrefix."map` WHERE x='".$aRow['x']."' AND y='".$aRow['y']."'" );
        if( mysql_num_rows( $sqlResult2 ) == 0 )
        {
            // insert terrain field
            mysql_query( 'INSERT INTO `'.$strMysqlPrefix."map` SET x='".$aRow['x']."', y='".$aRow['y']."', terrain='0'" );
        }
        $sqlResult2 = mysql_query( 'SELECT x, building FROM `'.$strMysqlPrefix."map_data` WHERE x='".$aRow['x']."' AND y='".$aRow['y']."'" );
        if( mysql_num_rows( $sqlResult2 ) == 0 )
        {
            // insert details
            mysql_query( 'INSERT INTO `'.$strMysqlPrefix."map_data` SET x='".$aRow['x']."', y='".$aRow['y']."', building='-', last_update='".time()."', last_update_by='1';" );
        }
        else
        {
            $aRow2 = mysql_fetch_assoc( $sqlResult2 );
            if( !in_array( $aRow2['building'], array( -11, -2, -1, 97, 98, 99, 100 ) ) )
            {
                mysql_query( 'UPDATE `'.$strMysqlPrefix."map_data` SET building='-1', last_update='".time()."', last_update_by='1' WHERE x='".$aRow['x']."' AND y='".$aRow['y']."';" );
            }
        }
    }


    //-------------------------------------------------------------------------
    // update queries
    $oStyle->addReplacements( array( 'PREFIX' => $strMysqlPrefix ) );
    $strError = '';
    $aSqlQueries = explode ( ";\n", str_replace( "\r\n", "\n", $oStyle->get_area( 'Sql' ) ) );
    foreach( $aSqlQueries AS $strQuery )
    {
        $strQuery = trim( $strQuery );
        if( $strQuery == '' ) continue;
        @mysql_query( $strQuery ) OR $strError .= mysql_error().'<br />';
    }

    //-------------------------------------------------------------------------
    // update config
    $oStyle->addReplacements( array(
        'CFG_SERVER' => $intServerId,
        'CFG_SQL_HOST' => $strMysqlHost,
        'CFG_SQL_DB' => $strMysqlDb,
        'CFG_SQL_USER' => $strMysqlUser,
        'CFG_SQL_PW' => $strMysqlPwd,
        'CFG_SQL_PREFIX' => $strMysqlPrefix,
        'CFG_COOKIE_PREFIX' => $strCookiePrefix,
        'CFG_REFRESH' => $intTmplRefresh,
        'CFG_TMPL_PATH' => $strTmplPath,
        'CFG_SERVER_STATS' => $strServerStats,
        'CFG_SERVER_NAME' => $strServerName,
        'CFG_MAP_SIZE' => $intMapSize,
        'ERROR_MESSAGE' => $strError
    ) );

    for( $i=0; $i<9; $i++ )
    {
        $aReplace['DIPLO_BG'.$i] = $aDiploBgColor[$i];
        $aReplace['DIPLO_FG'.$i] = $aDiploFgColor[$i];
    }
    $oStyle->addReplacements( $aReplace );

    $strConfig = trim( $oStyle->get_area( 'Config' ) );

    if( ( $fp = @fopen('./conf/config.php', 'w' ) ) === false )
    {
        // should not happen, we checked if config.php is writeable in step 1
        die ( 'Konnte <i>./conf/config.php</i> nicht zum schreiben &ouml;ffnen.' );
    }
    if( @fwrite ( $fp, $strConfig ) === false )
    {
        // should not happen, we checked if config.php is writeable in step 1
        die ( 'Konnte in <i>./conf/config.php</i> nicht schreiben.' );
    }
    fclose ( $fp );

    echo $oStyle->get_area( 'Step1' );
    die();
}
// 2 - (for security reasons) try delete update.html and update.php
elseif( $intStep == 2 )
{
    // template class was validated in step 0, if the user tricks us in faking the _GET Parameter, it's his own fault :)
    require_once( './lib/template.php' );
    $oStyle = new Template( './templates/default/' );
    $oStyle->addReplacements( array( 'TEMPLATES' => $oStyle->getPath() ) );
    $oStyle->setTemplate ( 'update.html' );

    $aFiles = array( './templates/default/update.html', './update.php', './endpage.php', './templates/default/template.php' );

    $strMessage = '';
    foreach( $aFiles AS $strFile )
    {
        if( !is_writable( $strFile ) )
        {
            // try to chmod the file
            @chmod ( $strFile, 0666 );
        }

        if( !@unlink( $strFile ) )
        {
            $booError = true;
            $strMessage .= $strFile.' konnte <b>nicht</b> gelöscht werden.<br />';
        }
        else
        {
            $strMessage .= $strFile.' gelöscht.<br />';
        }
    }

    $oStyle->addReplacements( array( 'MESSAGE' => $strMessage ) );

    // show finish
    if( empty( $booError ) )
    {
        echo trim( $oStyle->get_area( 'Step2' ) );
    }
    else
    {
        echo trim( $oStyle->get_area( 'Step2Error' ) );
    }
    die();
}

---