module/auction/auctionhouse.php

   1 <?php
   2 include_once("conf.php");
   3 include_once("include/functions.php");
   4 $page = intval(@$_REQUEST['page']);
   5 $type = @$_REQUEST['auction'];
   6
   7 switch ($type)
   8 {
   9         case "Alliance":
  10         $houseid="(houseid=1 or houseid=2 or houseid=3)";
  11         break;
  12         case "Horde":
  13         $houseid="(houseid=4 or houseid=5 or houseid=6)";
  14         break;
  15         case "Blackwater":
  16         $houseid="(houseid=7)";
  17         default:
  18         $type="Blackwater";
  19         $houseid="(houseid=7)";
  20         break;
  21 }
  22
  23 $rows = $cDB->selectPage($number,
  24 "SELECT
  25 `auction`.`id`,
  26 `auction`.`itemguid`,
  27 `auction`.`item_template`,
  28 `auction`.`itemowner`,
  29 `auction`.`buyoutprice`,
  30 `auction`.`time`,
  31 `auction`.`buyguid`,
  32 `auction`.`lastbid`,
  33 `auction`.`startbid`,
  34 `auction`.`deposit`,
  35 `auction`.`houseid`,
  36
  37 (SUBSTRING_INDEX( SUBSTRING_INDEX(`item_instance`.`data` , ' ' , ?d) , ' ' , -1 )+0) AS `itementry`,
  38 `item_instance`.`data`,
  39 `item_instance`.`owner_guid`
  40 FROM
  41  `auction`
  42    left join
  43  `item_instance`
  44   ON `auction`.`itemguid` = `item_instance`.`guid`
  45 WHERE
  46  $houseid
  47 LIMIT ?d, ?d",
  48 ITEM_FIELD_ENTRY+1,
  49 getPageOffset($page), $config['fade_limit']);
  50 echo "<table class=report width=500>";
  51 echo "<tbody>";
  52 echo "<tr><td colspan=4 class=head>";
  53 echo "<img src=\"images/gold.gif\">";
  54 echo "<a href=\"?auction=Alliance\" style=\"Text-decoration: none; color:gold;\">$lang[Alliance]</a>";
  55 echo "<img src=\"images/gold.gif\">";
  56 echo "<a href=\"?auction=Horde\" style=\"Text-decoration: none; color:gold;\">$lang[Horde]</a>";
  57 echo "<img src=\"images/gold.gif\">";
  58 echo "<a href=\"?auction=Blackwater\" style=\"Text-decoration: none; color:gold;\">$lang[Blackwater]</a>";
  59 echo "<img src=\"images/gold.gif\">";
  60 echo "</td></tr>";
  61
  62 if ($rows)
  63 {
  64  echo "<tr><td colspan=4 class=head><font color=gold>$lang[auction] $type: </font> $number $lang[items]</td></tr>";
  65  echo "<tr>";
  66  echo "<th width=1px></th>";
  67  echo "<th width=50%>".$lang['auction_seller']."</th>";
  68  echo "<th width=25%>".$lang['auction_cost']."</th>";
  69  echo "<th width=25%>".$lang['auction_bye']."</th>";
  70  echo "</tr>\n";
  71  foreach ($rows as $auc_data)
  72  {
  73    $item_data = explode(' ', $auc_data['data']);
  74    echo "<tr>";
  75    echo "<td>"; show_item_by_data($item_data, 'auction'); echo "</td>";
  76    echo "<td><a href=?player=$auc_data[itemowner]>".getCharacterName($auc_data['itemowner'])."</a></td>";
  77    echo "<td align=center>".money($auc_data['startbid'])."</td>";
  78    echo "<td align=center>".money($auc_data['buyoutprice'])."</td>";
  79    echo "</tr>\n";
  80  }
  81  generatePage($number, $page, "<a href=\"?auction=$type&page=%d\">%d </a>", 4);
  82 }
  83 else
  84  echo "<tr><td colspan=4 align=center>$lang[empty]</td></tr>";
  85  echo "</tbody></table>";
  86 ?>