module/livesearch/live_search.php

   1 <?php
   2 //=============================================================================
   3 // Script allow do search in database by name, output result in 2 modes
   4 // ls - Live Search -> for web script (if user input data on web page)
   5 // os - Open Search -> for browser Open Search toolbar
   6 // Search in item, itemset, quest, NPC, GO, spell, faction tables
   7 //=============================================================================
   8
   9 include_once("include/functions.php");
  10
  11 function highliteText($text, $sub)
  12 {
  13    return preg_replace('/'.$sub.'/i', '<b>$0</b>', $text);
  14 }
  15
  16 $type = isset($_REQUEST['ls']) ? $_REQUEST['ls'] : @$_REQUEST['os'];
  17 $name = @$_REQUEST['name'];
  18
  19 // Localisation
  20 if ($config['locales_lang']) $localised = preg_match($config['locales_charset'], $name);
  21 else                         $localised = false;
  22 $locale = $config['locales_lang'];
  23
  24 // Result limit from config
  25 $limit = $config['ls_limit'];
  26
  27 // Fill this array
  28 $result = array();
  29
  30 // Item search
  31 if ($type == 'i' OR $type == 'all')
  32 {
  33  $filter  = '`name` like ?';
  34  $tables  = '`item_template`';
  35  $filelds = '`item_template`.`entry`, `Quality`, `displayid`, `name`';
  36  if ($localised)
  37  {
  38    $tables = '`item_template` LEFT JOIN `locales_item` ON `item_template`.`entry` = `locales_item`.`entry`';
  39    $filter = str_replace('`name`', '`name_loc'.$locale.'`', $filter);
  40    $filelds= str_replace('`name`', '`locales_item`.`name_loc'.$locale.'` AS `name`', $filelds);
  41  }
  42  if ($items = $dDB->select("SELECT $filelds FROM $tables WHERE $filter LIMIT 0, ?d", '%'.$name.'%', $limit))
  43  foreach ($items as $item)
  44     $result['i'][]=array('ico'=>getItemIcon($item['displayid'], 0), 'class'=>$Quality[$item['Quality']], 'link'=>'?item='.$item['entry'], 'txt'=>$item['name'], 'type'=>$ls_type_name['i']);
  45 }
  46
  47 // Item Set search
  48 if ($type == 'set' OR $type == 'all')
  49 {
  50  if ($set = $wDB->select('SELECT `id`, `name` FROM `wowd_itemset` WHERE `name` LIKE ? LIMIT 0, ?d', '%'.$name.'%', $limit))
  51  foreach ($set as $s)
  52     $result['set'][]=array('txt'=>$s['name'], 'link'=>'?itemset='.$s['id'], 'type'=>$ls_type_name['set']);
  53 }
  54
  55 // Quest search
  56 if ($type == 'q' OR $type == 'all')
  57 {
  58  $filter = '`Title` like ?';
  59  $tables = '`quest_template`';
  60  $filelds = '`quest_template`.`entry`, `Title`';
  61  if ($localised)
  62  {
  63    $tables = '`quest_template` LEFT JOIN `locales_quest` ON `quest_template`.`entry` = `locales_quest`.`entry`';
  64    $filter = str_replace('`Title`', '`Title_loc'.$locale.'`', $filter);
  65    $filelds= str_replace('`Title`', '`locales_quest`.`Title_loc'.$locale.'` AS `Title`', $filelds);
  66  }
  67  if ($quests = $dDB->select("SELECT $filelds FROM $tables WHERE $filter LIMIT 0, ?d", '%'.$name.'%', $limit))
  68  foreach($quests as $quest)
  69     $result['q'][]=array('txt'=>$quest['Title'], 'link'=>'?quest='.$quest['entry'], 'type'=>$ls_type_name['q']);
  70 }
  71
  72 // NPC search
  73 if ($type == 'n' OR $type == 'all')
  74 {
  75  $filter  = '`name` like ?';
  76  $tables  = '`creature_template`';
  77  $filelds = '`creature_template`.`entry`, `name`';
  78  if ($localised)
  79  {
  80    $tables = '`creature_template` LEFT JOIN `locales_creature` ON `creature_template`.`entry` = `locales_creature`.`entry`';
  81    $filter = str_replace('`name`', '`name_loc'.$locale.'`', $filter);
  82    $filelds= str_replace('`name`', '`locales_creature`.`name_loc'.$locale.'` AS `name`', $filelds);
  83  }
  84  if ($npcs= $dDB->select("SELECT $filelds FROM $tables WHERE $filter LIMIT 0, ?d", '%'.$name.'%', $limit))
  85  foreach ($npcs as $npc)
  86     $result['n'][]=array('txt'=>$npc['name'], 'link'=>'?npc='.$npc['entry'], 'type'=>$ls_type_name['n']);
  87 }
  88
  89 // Gameobject search
  90 if ($type == 'g' OR $type == 'all')
  91 {
  92  $filter  = '`name` like ?';
  93  $tables  = '`gameobject_template`';
  94  $filelds = '`gameobject_template`.`entry`, `name`';
  95  if ($localised)
  96  {
  97    $tables = '`gameobject_template` LEFT JOIN `locales_gameobject` ON `gameobject_template`.`entry` = `locales_gameobject`.`entry`';
  98    $filter = str_replace('`name`', '`name_loc'.$locale.'`', $filter);
  99    $filelds= str_replace('`name`', '`locales_gameobject`.`name_loc'.$locale.'` AS `name`', $filelds);
 100  }
 101  if ($go = $dDB->select("SELECT $filelds FROM $tables WHERE $filter LIMIT 0, ?d", '%'.$name.'%', $limit))
 102  foreach($go as $g)
 103     $result['g'][]=array('txt'=>$g['name'], 'link'=>'?object='.$g['entry'], 'type'=>$ls_type_name['g']);
 104 }
 105
 106 // Spell search
 107 if ($type == 's' OR $type == 'all')
 108 {
 109  if ($spells = $wDB->select('SELECT `id`, `SpellName`, `Rank`, `SpellIconID` FROM `wowd_spell` WHERE `SpellName` like ? LIMIT 0, ?d', '%'.$name.'%', $limit))
 110  foreach ($spells as $spell)
 111  {
 112     $n = $spell['SpellName'];
 113     if ($spell['Rank'])
 114       $n.=' ('.$spell['Rank'].')';
 115     $result['s'][]=array('ico'=>getSpellIcon($spell['SpellIconID'], 0), 'txt'=>$n, 'link'=>'?spell='.$spell['id'], 'type'=>$ls_type_name['s']);
 116  }
 117 }
 118
 119 // Faction search
 120 if ($type == 'f' OR $type == 'all')
 121 {
 122  $factions = $wDB->select('SELECT `id`, `name` FROM `wowd_faction` WHERE `name` like ? LIMIT 0, ?d', '%'.$name.'%', $limit);
 123  if ($factions)
 124  foreach ($factions as $f)
 125     $result['f'][]=array('txt'=>$f['name'], 'link'=>'?faction='.$f['id'], 'type'=>$ls_type_name['f']);
 126 }
 127
 128 // Area search
 129 if ($type == 'a' OR $type == 'all')
 130 {
 131  $area = $wDB->select('SELECT `id`, `name` FROM `wowd_zones` WHERE `name` like ? LIMIT 0, ?d', '%'.$name.'%', $limit);
 132  if ($area)
 133  foreach ($area as $a)
 134     $result['a'][]=array('txt'=>$a['name'], 'link'=>'?zone='.$a['id'], 'type'=>$ls_type_name['a']);
 135 }
 136
 137 // Results count
 138 $count = 0;
 139 foreach($result as $key=>$r)
 140   $count+=count($result[$key]);
 141
 142 // Limit results count to need amount by remove one result in max group step by step
 143 while ($count > $limit)
 144 {
 145    $max_key = 0;
 146    $cmax = 0;
 147    foreach($result as $key=>$r)
 148    {
 149       $c = count($result[$key]);
 150       if ($cmax < $c)
 151       {
 152          $cmax = $c;
 153          $max_key = $key;
 154       }
 155    }
 156    unset($result[$max_key][$cmax-1]);
 157    $count--;
 158 }
 159
 160 // Output result
 161 if ($count)
 162 {
 163  if (isset($_REQUEST['ls']))      // Live Search mode
 164  {
 165   echo '<table class=livesearch><tbody>';
 166   foreach($result as $key=>$r)
 167   {
 168    foreach($result[$key] as $res)
 169    {
 170        echo '<tr>';
 171        echo '<td>'.(isset($res['ico'])? '<img src='.$res['ico'].'>' : '').'</td>';
 172        echo '<td class=lsname><a'.(isset($res['class'])?' class='.$res['class']:'').' href="'.$res['link'].'">'.highliteText($res['txt'], $name).'</a></td>';
 173        echo '<td class=lstype>'.$res['type'].'</td>';
 174        echo '</tr>';
 175    }
 176   }
 177   echo '</tbody></table>';
 178  }
 179  else if (isset($_REQUEST['os'])) // Open Search mode
 180  {
 181   echo '["'.$name.'", [';
 182   foreach($result as $key=>$r)
 183     foreach($result[$key] as $res)
 184       echo '"'.$res['txt'].' ('.$res['type'].')",';
 185   echo ']]';
 186  }
 187 }
 188 ?>