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

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

    function addUser ( $strName, $strPass, $intHomeX, $intHomeY, $intGroup )
    {
        if ( $strName == '' || $strPass == '' )
        {
            return false;
        }
        // check, if this user already exists
        $aRow = $this->oDB->query_first("SELECT COUNT(user_id) FROM `".$this->oDB->tblUser."` WHERE `name`='$strName';");
        if ( $aRow[0] > 0 )
        {
            return false;
        }
        $this->oDB->query("INSERT INTO `".$this->oDB->tblUser."` SET `name`='$strName', `pass`='".md5($strPass)."', `home_x`='$intHomeX', `home_y`='$intHomeY', `last_x`='$intHomeX', `last_y`='$intHomeY', usergroup_id='$intGroup';");
        return intval ( $this->oDB->insert_id() );
    }

    function editUser( $intUser, $strPlayer, $intHomeX, $intHomeY, $intGroup )
    {
        $strUpdatePlayer = '';
        $aPlayer = $this->oDB->query_first( "SELECT player_id FROM ".$this->oDB->tblPlayer." WHERE name LIKE '".$strPlayer."' LIMIT 1;" );
        if( $aPlayer['player_id'] )
        {
            $strUpdatePlayer = ", player_id='".$aPlayer['player_id']."'";
        }
        elseif( $strPlayer == '' )
        {
            $strUpdatePlayer = ", player_id='0'";
        }

        $this->oDB->query("UPDATE `".$this->oDB->tblUser."` SET `home_x`='$intHomeX', `home_y`='$intHomeY', usergroup_id='$intGroup'".$strUpdatePlayer." WHERE user_id='".$intUser."';");
        return true;
    }

    function getUser( $intUser )
    {
        $aReturn = array();
        $sqlResult = $this->oDB->query( "SELECT u.*, p.name AS pname ".
                                        "FROM `".$this->oDB->tblUser."` u ".
                                        "LEFT JOIN ".$this->oDB->tblPlayer." p ON (u.player_id=p.player_id) ".
                                        "WHERE user_id='".$intUser."';");
        if( $this->oDB->num_rows( $sqlResult ) != 1 )
        {
            return false;
        }
        return $this->oDB->fetch_assoc( $sqlResult );
    }

    function delUser ( $intUser )
    {
        $this->oDB->query("DELETE FROM `".$this->oDB->tblUser."` WHERE user_id='$intUser' AND usergroup_id!=1 LIMIT 1;");
        if ( $this->oDB->affected_rows() == 1 )
        {
            return true;
        }
        return false;
    }

    function getUsers( $strOrder )
    {
        $aReturn = array();
        $sqlResult = $this->oDB->query("SELECT * FROM `".$this->oDB->tblUser."` ORDER BY ".$strOrder);
        while ( $aRow = $this->oDB->fetch_assoc( $sqlResult ) )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }

    function getGroups( $strOrder = 'name' )
    {
        $aReturn = array();
        $sqlResult = $this->oDB->query("SELECT * FROM `".$this->oDB->tblUsergroup."` ORDER BY ".$strOrder);
        while ( $aRow = $this->oDB->fetch_assoc( $sqlResult ) )
        {
            if( $strOrder == 'usergroup_id' )
            {
                $aReturn[$aRow['usergroup_id']] = $aRow;
            }
            else
            {
                $aReturn[] = $aRow;
            }
        }
        return $aReturn;
    }

    function getLogStat ( $strOrder, $intStart = 0, $intEnd = 50 )
    {
        $aReturn = array();
//        $this->oDB->query("SELECT COUNT(actionlog_id) FROM ".$this->oDB->tblActionlog.";");
//        $aRow = $this->oDB->fetch_row();
//        $aReturn['max'] = $aRow[0];
//
//        $strLimit = ($intStart != -1) ? " LIMIT $intStart, $intEnd" : '';
//        $this->oDB->query("SELECT a.*, u.name FROM ".$this->oDB->tblActionlog." a LEFT JOIN user u USING (user_id) ORDER BY $strOrder$strLimit;");

        $this->oDB->query('SELECT u.lastlogin AS lastseen, COUNT(a.actionlog_id) AS aktionen, u.name '.
                          'FROM '.$this->oDB->tblUser.' u '.
                          'LEFT JOIN '.$this->oDB->tblActionlog.' a ON u.user_id = a.user_id  AND a.message != "Kartenquelltext (,)" AND a.flag !=3 AND a.flag < 10 '.
                          'GROUP BY u.name '.
                          'ORDER BY '.$strOrder);
        $aReturn['max'] = $this->oDB->affected_rows();
        while ( $aRow = $this->oDB->fetch_assoc() )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }

    function getLogList ( $strOrder, $intStart = 0, $intEnd = 50 )
    {
        $aReturn = array();
        $this->oDB->query("SELECT COUNT(actionlog_id) FROM ".$this->oDB->tblActionlog.";");
        $aRow = $this->oDB->fetch_row();
        $aReturn['max'] = $aRow[0];

        $strLimit = ($intStart != -1) ? " LIMIT $intStart, $intEnd" : '';
        $this->oDB->query("SELECT a.*, u.name FROM ".$this->oDB->tblActionlog." a LEFT JOIN ".$this->oDB->tblUser." u USING (user_id) ORDER BY $strOrder$strLimit;");
        while ( $aRow = $this->oDB->fetch_assoc() )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }

    function deleteLogs ( $aLogIds, $intTime = 0 )
    {
        $strIds = '(0';
        if ( is_array ( $aLogIds ) && count ( $aLogIds ) > 0 )
        {
            $strIds .= ','.implode ( ',', $aLogIds );
        }
        $strIds .= ')';
        $this->oDB->query("DELETE FROM ".$this->oDB->tblActionlog." WHERE actionlog_id IN $strIds OR `time`<'$intTime';");
        return intval ( $this->oDB->affected_rows() );
    }

    function getDeadList()
    {
        $aReturn = array ( 'players' => array(), 'guilds' => array() );

        // search for players without towns
        $this->oDB->query("SELECT p.player_id, p.name FROM `".$this->oDB->tblPlayer."` p LEFT JOIN `".$this->oDB->tblTown."` t USING (player_id) WHERE p.player_id>1 AND t.town_id IS NULL;");

        while ( $aRow = $this->oDB->fetch_assoc() )
        {
            $aReturn['players'][] = $aRow;
        }

        // search for empty guilds
        $this->oDB->query("SELECT DISTINCT g.guild_id, g.name, g.tag FROM `".$this->oDB->tblGuild."` g LEFT JOIN `".$this->oDB->tblPlayer."` p USING (guild_id) WHERE p.player_id IS NULL AND g.guild_id>1;");

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

    function deletePlayers ( $aPlayers )
    {
        $strIds = '(0';
        if ( is_array ( $aPlayers ) && count ( $aPlayers ) > 0 )
        {
            $strIds .= ','.implode ( ',', $aPlayers );
        }
        $strIds .= ')';
        $this->oDB->query("DELETE FROM ".$this->oDB->tblPlayer." WHERE player_id IN $strIds AND player_id > 1;");
        $this->oDB->query("UPDATE ".$this->oDB->tblUser." SET player_id=0 WHERE player_id IN $strIds;");
        return intval ( $this->oDB->affected_rows() );
    }

    function optimizeDb()
    {
        $aReturn = array();
        $this->oDB->query('ANALYZE TABLE `'.$this->oDB->tblActionlog.'`, `'.$this->oDB->tblGuild.'`, `'.$this->oDB->tblMap.'`, `'.$this->oDB->tblMapData.'`, `'.$this->oDB->tblPlayer.'`, `'.$this->oDB->tblTown.'`, `'.$this->oDB->tblUser.'`;');
        while ( $aRow = $this->oDB->fetch_assoc() )
        {
            $aReturn[] = $aRow;
        }
        return $aReturn;
    }

    function countMapMerge()
    {
        $aCnt = $this->oDB->query_first( 'SELECT COUNT(x) AS cnt FROM `'.$this->oDB->tblMapData.'` GROUP BY x, y HAVING cnt>1' );

        return intval( $aCnt['cnt'] );
    }

    function mergeMap()
    {
        $intCount = 0;

        // first find Records to be merge
        $intQueryID = $this->oDB->query( 'SELECT COUNT(x) AS cnt, m.* FROM `'.$this->oDB->tblMapData.'` m GROUP BY x, y HAVING cnt>1' );
        while ( $aRow = $this->oDB->fetch_assoc( $intQueryID ) )
        {
            if( $aRow['x'] > 0 && $aRow['y'] > 0 && $aRow['last_update'] > 0 )
            {
                // find most recent Record
                $aDest = $this->oDB->query_first( "SELECT last_update,street,building,unit,fow FROM `".$this->oDB->tblMapData."` WHERE x='".$aRow['x']."' AND y='".$aRow['y']."' ORDER BY last_update DESC LIMIT 1"  );

                if( isset( $aDest['last_update'] ) )
                {
                    $fieldcount = 0;
                    $strQuery = 'UPDATE `'.$this->oDB->tblMapData.'` SET';

                    // create fieldlist
                    if( $aRow['street'] != 0 && intval($aDest['street']) == 0 )
                    {
                        $fieldcount++;
                        $strQuery .= ' street=\''.$aRow['street'].'\',';
                    }
                    if( $aRow['building'] != 0 && intval($aDest['building']) == 0 )
                    {
                        $fieldcount++;
                        $strQuery .= ' building=\''.$aRow['building'].'\',';
                    }
                    if( $aRow['unit'] != 0 && intval($aDest['unit']) == 0 )
                    {
                        $fieldcount++;
                        $strQuery .= ' unit=\''.$aRow['unit'].'\',';
                    }
                    if( $aRow['fow'] ==0 && intval($aDest['fow']) == 1 )
                    {
                        $fieldcount++;
                        $strQuery .= ' fow=\'1\',';
                    }

                    // merge record
                    if( $fieldcount > 0 )
                    {
                        $this->oDB->query( substr($strQuery, 0, -1) . ' WHERE x=\''.$aRow['x'].'\' AND y=\''.$aRow['y'].'\' AND last_update=\''.$aDest['last_update'].'\'' );
                        $intCount+=2;
                    }

                    // delete duplicate
                    $this->oDB->query( 'DELETE FROM `'.$this->oDB->tblMapData.'` WHERE x=\''.$aRow['x'].'\' AND y=\''.$aRow['y'].'\' AND last_update=\''.$aRow['last_update'].'\'' );
                }
            }
        }


        // delete duplicates - need to be done in loop - f**ck

        return $intCount;
    }
}

---