source: aowow/opensearch.php

<?php

// Настройки
error_reporting(2039);
require_once 'configs/config.php';
// Для Ajax отключаем debug
$AoWoWconf['debug'] = false;
// Для Ajax ненужен реалм
$AoWoWconf['realmd'] = false;
// Настройка БД
global $DB;
require_once('includes/db.php');

echo '["'.$_GET['search'].'", [';

function SideByRace($race)
{
        switch ($race)
        {
                case '0':
                        // Для всех?
                        return 3;
                case '690':
                        // Орда?
                        return 2;
                case '1101':
                        // Альянс?
                        return 1;
                default:
                        return 0;
        }
}

// Ищем вещи:
$rows = $DB->select('
        SELECT entry, name, iconname, quality
        FROM item_template i, ?_icons a
        WHERE
                ((i.name LIKE ?)
                AND a.id=i.displayid)
        ORDER BY i.quality DESC, i.name
        LIMIT 3
        ',
        '%'.$_GET['search'].'%');

foreach ($rows as $i => $row)
        $found[$row['name'].' (Item)'] = array(
                'type'          => 3,
                'entry'         => $row['entry'],
                'iconname'      => $row['iconname'],
                'quality'       => $row['quality']
        );

// Ищем объекты:
$rows = $DB->select('
        SELECT entry, name
        FROM gameobject_template
        WHERE
                (name LIKE ?)
        ORDER BY name
        LIMIT 3
        ',
        '%'.$_GET['search'].'%'
);

foreach ($rows as $i => $row)
        $found[$row['name'].' (Object)'] = array(
                'type' => 2,
                'entry'=>$row['entry'],
        );

// Ищем квесты:
$rows = $DB->select('
        SELECT entry, Title, RequiredRaces
        FROM quest_template
        WHERE
                (Title LIKE ?)
        ORDER BY Title
        LIMIT 3
        ',
        '%'.$_GET['search'].'%'
);

foreach ($rows as $i => $row)
        $found[$row['Title'].' (Quest)'] = array(
                'type' => 5,
                'entry'=> $row['entry'],
                'side' => SideByRace($row['RequiredRaces'])
        );

// Ищем creature:
$rows = $DB->select('
        SELECT entry, name
        FROM creature_template
        WHERE
                (name LIKE ?)
        ORDER BY name
        LIMIT 3
        ',
        '%'.$_GET['search'].'%'
);

foreach ($rows as $i => $row)
        $found[$row['name'].' (NPC)'] = array(
                'type' => 1,
                'entry'=> $row['entry']
        );

// Если ничего не найдено...
if (!IsSet($found))
{
        echo ']]';
        die();
}

ksort($found);

$found = array_slice($found, 0, 10);

$i=0;
foreach ($found as $name => $fitem)
{
        echo '"'.str_replace('"','\"',$name).'"';
        if ($i<count($found)-1)
                echo ', ';
        $i++;
}

echo '], [], [], [], [], [], [';

$i=0;
foreach ($found as $name => $fitem)
{
        echo '['.$fitem['type'].', '.$fitem['entry'];
        if (IsSet($fitem['iconname'])) echo ', "'.$fitem['iconname'].'"';
        if (IsSet($fitem['quality'])) echo ", ".$fitem['quality'];
        if (IsSet($fitem['side'])) echo ", ".$fitem['side'];
        echo ']';
        if ($i<count($found)-1)
                echo ',';
        $i++;
}

echo ']]';

?>