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

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

    function doSearch ( $strName = '', $strGuild = '', $intGuild = 0, $intX = 0, $intY = 0, $intRadius = 0, $strOrder = '' )
    {
        // check order
        switch ( $strOrder )
        {
            case 'position':
                $strOrderBy = '`x`, `y`';
                break;
            case 'guild':
                $strOrderBy = 'g.`tag`, p.name';
                break;
            case 'town':
                $strOrderBy = 't.name';
                break;
            default:
                $strOrderBy = 'p.`name`';
        }

        // Set SQL Filter
        $strFilter = '';
        if ( $strName != '' )
        {
            $strFilter .= " AND UPPER(`p`.`name`) LIKE UPPER('%$strName%')";
        }

        if ( $strGuild != '' )
        {
            $strFilter .= " AND UPPER(`g`.`tag`) LIKE UPPER('%$strGuild%')";
        }

        if ( $intX > 0 )
        {
            $strFilter .= " AND t.`x` BETWEEN ".($intX-$intRadius)." AND ".($intX+$intRadius);
        }

        if ( $intY > 0 )
        {
            $strFilter .= " AND t.`y` BETWEEN ".($intY-$intRadius)." AND ".($intY+$intRadius);
        }

        if ( $intGuild > 0 && $strFilter == '' )
        {
            $strFilter = ' AND `p`.`guild_id`='.$intGuild;
        }

        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);
        }

        $sqlResult = $this->oDB->query("SELECT p.`name`, t.`name` AS `townname`, g.`tag` AS `guild_tag`, t.`x`, t.`y`, p.`guild_id`, 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 (p.`guild_id`=g.`guild_id`) ".
                             "WHERE t.`town_id`>0  AND m.`building` > '-10' ".$strFilter." ".
                             "ORDER BY $strOrderBy;");

        $aResult = array();
        while ( $aRow = $this->oDB->fetch_assoc ($sqlResult) )
        {
            if ( !isset ( $aRow['guild_tag'] ) ) $aRow['guild_tag'] = '';
            if ( !isset ( $aRow['guild_id'] ) )  $aRow['guild_id']  = 0;
            $aRow['prefix'] = ( $aRow['building'] == -2 ) ? '~' : '';
            $aResult[] = $aRow;
        }
        return $aResult;
    }
}

---