source: trunk/pages/aukce.php

<?php
function ShowValue ($cook)
{
  if (isset($_COOKIE[$cook]) AND $_COOKIE[$cook] != 0 AND $_COOKIE[$cook] != "")
  {
  echo $_COOKIE[$cook];
  }
}
function SelectValue ($frakce)
{
  if (isset($_COOKIE["hof-frakce"]) AND $_COOKIE["hof-frakce"] != 0 AND $_COOKIE["hof-frakce"] != "" AND $_COOKIE["hof-frakce"] == $frakce)
  {
  echo "SELECTED";
  }
}
$work = "";
if (isset($_POST["set"]))
{
  $year = 365 * 24 * 60 * 60;
  setcookie("hof-maxlvl",$_POST["maxlvl"],time()+$year);
  setcookie("hof-minlvl",$_POST["minlvl"],time()+$year);
  setcookie("hof-maxgold",$_POST["maxgold"],time()+$year);
  setcookie("hof-frakce",$_POST["frakce"],time()+$year);
  echo "<meta http-equiv=\"refresh\" content=\"2;url=?page=aukce\">";
  $work = "Ukládám nastavení , chvíli strpení";
}
if (isset($_POST["reset"]))
{
  $year = 365 * 24 * 60 * 60;
  setcookie("hof-maxlvl","",time()+$year);
  setcookie("hof-minlvl","",time()+$year);
  setcookie("hof-maxgold","",time()+$year);
  setcookie("hof-frakce","",time()+$year);
  echo "<meta http-equiv=\"refresh\" content=\"2;url=?page=aukce\">";
  $work = "Ukládám nastavení , chvíli strpení";
}
if (isset($_COOKIE["hof-widget"]) AND $_COOKIE["hof-widget"] == "thottbot")
{
  echo "<script src=\"http://i.thottbot.com/power.js\"></script>";
  $link = "http://thottbot.com/i";
}
else
{
  echo "<script src=\"http://www.wowhead.com/widgets/power.js\"></script>";
  $link = "http://www.wowhead.com/?item=";
}
?>
<form method="post">
<table border="0">
  <tr>
    <td>Minimální / Maximální úroveň</td>
    <td><input type="text" size="10" name="minlvl" value="<?php ShowValue("hof-minlvl");?>"> / <input type="text" size="10" name="maxlvl" value="<?php ShowValue("hof-maxlvl");?>"></td>
  </tr>
  <tr>
    <td>Frakce</td>
    <td>
      <select name="frakce">
        <option value="">Frakce</option>
        <option value="2" <?php SelectValue("2");?> >Aliance</option>
        <option value="6" <?php SelectValue("6");?> >Horda</option>
        <option value="7" <?php SelectValue("7");?> >Neutralní</option>
      </select>
    </td>
  </tr>
  <tr>
    <td>Maximálně goldů</td>
    <td><input type="text" size="10" name="maxgold" value="<?php ShowValue("hof-maxgold");?>"></td>
  </tr>
  <tr>
    <td colspan="2"><input type="submit" value="Potvrdit" name="set"></form><?php echo $work;?></td>
  </tr>
</table>
<form method="post">
<input type="submit" value="Resetovat filtry" name="reset">
</form>



<center>
<table border="1" width="540">
  <tr>
    <td width="300">Předmět</td>
    <td align="center">Aktuální cena<br />Kup teď za cenu</td>
    <td align="center">Konec aukce</td>
    <td align="center">F</td>
  </tr>
<?php
$db -> select_db($Config['Mangos']['DatabaseCharacters']);

function AuctionEnd($end_time)
{
  $now = time();
  $end = $end_time;
  $dif_minutes = round(($end_time - time()) / 60);
  $dif_hours = round($dif_minutes / 60);
  $dif_days = round($dif_hours / 24);
  // dny
  if ($dif_days <= 2)
  {$end = "< 2 Dny";}
  if ($dif_days < 1)
  {$end = "< 1 Den";}
  // hodiny
  if ($dif_hours < 24)
  {$end = "< 24 Hodin";}
  if ($dif_hours < 12)
  {$end = "< 12 Hodin";}
  if ($dif_hours < 5)
  {$end = "< 5 Hodin";}
  // minuty
  if ($dif_minutes < 60)
  {$end = "< 1 Hodina";}
  if ($dif_minutes < 10)
  {$end = "< 10 Minut";}
  if ($dif_minutes < 5)
  {$end = "< 5 Minut";}
  if ($dif_minutes < 2)
  {$end = "< 2 Minuty";}
  if ($dif_minutes <= 1)
  {$end = "<font color =\"#990000\">Konec</font>";}
  return $end;
}
function LoadCookie ($name,$def)
{
  if (isset($_COOKIE[$name]) AND $_COOKIE[$name] != 0 AND $_COOKIE[$name] != "")
  {
    if ($name == "hof-maxgold")
    {$value = $_COOKIE[$name]*10000;}
    else
    {$value = $_COOKIE[$name];}
    return $value;
  }
  else
  {
    return $def;
  }
}


$data = $db -> query("SELECT `item_template`,`itemowner`,`buyoutprice`,`time`,`buyguid`,`lastbid`,`startbid`,`location` FROM `auctionhouse` ORDER BY `time` ASC LIMIT 0,30");


while($row = $data -> fetch_array())
{

  $moneys = array_unique(array($row["buyoutprice"],$row["lastbid"],$row["startbid"]));
  sort($moneys);
  reset($moneys);
  while ($moneys[0] == 0)
  {
  array_shift($moneys);
  }


  
  $db -> select_db($Config['Mangos']['DatabaseMangos']);
  $item = $db -> query("SELECT `name` , `RequiredLevel` FROM `item_template` WHERE `entry`='".$row["item_template"]."' LIMIT 1;") -> fetch_array();
  if (LoadCookie("hof-frakce",$row["location"]) == $row["location"] AND LoadCookie("hof-maxgold",10000000000) >= $moneys[0] AND LoadCookie("hof-minlvl",0) <= $item["RequiredLevel"] AND LoadCookie("hof-maxlvl",70) >= $item["RequiredLevel"])
  {
    // switch
    switch ($row["location"])
    {
        case 2:
            $loc = "<img src=\"imgs/inc/a.gif\">";
            break;
        case 6:
            $loc = "<img src=\"imgs/inc/h.gif\">";
            break;
        case 7:
            $loc = "-";
            break;
        return $loc;
    }
    // imgs
    if (is_readable("./imgs/INV/".$row["item_template"].".jpg"))
    {$img = "<img src=\"imgs/INV/".$row["item_template"].".jpg\"><img src=\"imgs/INV/icon_border.png\" style=\"position: relative; left: -40px; top: 3px;\">";}
    else
    {$img = "<img src=\"imgs/INV/13250.jpg\"><img src=\"imgs/INV/icon_border.png\" style=\"position: relative; left: -40px; top: 3px;\">";}
    // moneys
    if ($row["buyoutprice"] != 0)
    {$buyout = $server -> ParseCopper($row["buyoutprice"]);}
    else
    {$buyout = "-";}
    if ($row["buyoutprice"] != 0)
    {$buyout = $server -> ParseCopper($row["buyoutprice"]);}
    else
    {$buyout = "-";}
    if ($row["lastbid"] != 0)
    {$now = $server -> ParseCopper($row["lastbid"])."<br />(".$player -> GuidToCharName($row["buyguid"]).")";}
    else
    {$now = $server -> ParseCopper($row["startbid"]);}
    // timer
    echo "
      <tr>
        <td width=\"300\">".$img."<a href=\"".$link.$row["item_template"]."\" target=\"_blank\"><span style=\"position: relative; top: -13px; left: -38px\"><font size=\"2\">".$item["name"]."</font></span></a><br />Minimální level : ".$item["RequiredLevel"]."<br />Aukci vložil : ".$player -> GuidToCharName($row["itemowner"])."</td>
        <td align=\"center\">".$now."<br />".$buyout."</td>
        <td align=\"center\"><font size=\"2\">".AuctionEnd($row["time"])."</font></td>
        <td align=\"center\">".$loc."</td>
      </tr>
    ";
  }
}
?>
</table></center>
<font size="2">Pro správnou filtraci je potřeba mít zaplé cookies.</font>