module/search/quest_zone_sort.php

   1 <?php
   2 function cmpZones($a, $b)
   3 {
   4   if (count($a['areas'])==1)
   5     return count($b['areas'])==1 ? strcmp($a['name'], $b['name']) : 1;
   6   return count($b['areas'])!=1 ? strcmp($a['name'], $b['name']) : -1;
   7 }
   8 function zoneSortSelect()
   9 {
  10   global $lang, $config, $dDB, $wDB;
  11   $cacheFilename = 'quest_zone_sort_'.$config['lang'].'.html';
  12   if (checkUseCacheHtml($cacheFilename, 24*60*60))
  13   {
  14     $zone_sort = $dDB->selectCol("SELECT `ZoneOrSort` FROM `quest_template` GROUP BY `ZoneOrSort`");
  15     $areas = $wDB->select("SELECT `id` AS ARRAY_KEY, `map_id`, `zone_id`, `name` FROM `wowd_zones` WHERE `id` IN (?a)", $zone_sort);
  16     $q_zones= array();
  17     $q_sort = array();
  18     foreach($zone_sort as $z)
  19     {
  20       if ($z > 0)
  21       {
  22         $area = @$areas[$z];
  23         $map = $area['map_id'];
  24         if (!isset($q_zones[$map]))
  25         {
  26           $q_zones[$map]['name'] = getMapName($map);
  27           $q_zones[$map]['areas']= array();
  28         }
  29         $q_zones[$map]['areas'][$z]=$area['name'];
  30       }
  31       else if ($z < 0)
  32         $q_sort[-$z]=getQuestSort(-$z);
  33     }
  34     // Sort it
  35     uasort($q_zones, 'cmpZones');
  36     uasort($q_sort,  'strcmp');
  37
  38     echo '<select name="ZoneID" style="width: 49%">';
  39     echo '<option value=0>'.$lang['anything'].'</option>'."\n";
  40     foreach($q_zones as $map=>$z)
  41     {
  42       if (count($z['areas']) > 1)
  43       {
  44         uasort($z['areas'], 'strcmp');
  45         echo '<optgroup label="'.$z['name'].'">';
  46         foreach($z['areas'] as $id=>$name)
  47           echo '<option value='.$id.'>'.$name.'</option>'."\n";
  48         echo '</optgroup>';
  49       }
  50       else
  51       {
  52         foreach($z['areas'] as $id=>$name)
  53           echo '<option value='.$id.'>'.$name.'</option>'."\n";
  54       }
  55     }
  56     echo "</select>\n";
  57     echo '<select name="SortID" style="width: 49%">';
  58     echo '<option value=0>'.$lang['anything'].'</option>'."\n";
  59     foreach($q_sort as $id=>$name)
  60       echo '<option value='.$id.'>'.$name.'</option>'."\n";
  61     echo "</select>";
  62     flushHtmlCache($cacheFilename);
  63   }
  64 }
  65 ?>