$blue,2 => $red,3 => $blue,4 => $blue,5 => $red,6 => $red,7 => $blue,8 => $red,10 => $red); $hiddencols = array(1,8,9,10); //$sqlc = new SQL; //$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); //==========================$_GET and SECURE================================= $start = (isset($_GET['start'])) ? $sqlc->quote_smart($_GET['start']) : 0; if (is_numeric($start)); else $start=0; $order_by = (isset($_GET['order_by'])) ? $sqlc->quote_smart($_GET['order_by']) : "time"; if (!preg_match("/^[_[:lower:]]{1,15}$/", $order_by)) $order_by="time"; $dir = (isset($_GET['dir'])) ? $sqlc->quote_smart($_GET['dir']) : 1; if (!preg_match("/^[01]{1}$/", $dir)) $dir=1; $order_dir = ($dir) ? "ASC" : "DESC"; $dir = ($dir) ? 0 : 1; //==========================$_GET and SECURE end============================= if( !$user_lvl && !$server[$realm_id]['both_factions']) { $result = $sqlc->query("SELECT race FROM `characters` WHERE account = $user_id AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = $user_id) LIMIT 1"); if ($sqlc->num_rows($result)) { $order_side = (in_array($sqlc->result($result, 0, 'race'),array(2,5,6,8,10))) ? " AND `characters`.`race` IN (2,5,6,8,10) " : " AND `characters`.`race` IN (1,3,4,7,11) "; } else $order_side = ""; } else $order_side = ""; //==========================Browse/Search CHECK============================== $search_by = ''; $search_value = ''; $search_filter = ''; $search_class = -1; $search_quality = -1; if((isset($_GET['search_value']) && isset($_GET['search_by'])) || (isset($_GET['search_class'])) || (isset($_GET['search_quality'])) ) { $search_value = $sqlc->quote_smart($_GET['search_value']); $search_by = $sqlc->quote_smart($_GET['search_by']); $search_class = $sqlc->quote_smart($_GET['search_class']); $search_quality = $sqlc->quote_smart($_GET['search_quality']); switch ($search_by) { case "item_name": if(( ($search_class >= 0) || ($search_quality >= 0)) && (!isset($search_value) )) { if ($search_class >= 0) $search_filter = "AND item_template.class = '$search_class'"; if ($search_quality >= 0) $search_filter = "AND item_template.Quality = '$search_quality'"; } else { $item_prefix = ""; if ($search_class >= 0) $item_prefix .= "AND item_template.class = '$search_class' "; if ($search_quality >= 0) $item_prefix .= "AND item_template.Quality = '$search_quality' "; $result = $sqlc->query("SELECT entry FROM `".$world_db[$realm_id]['name']."`.`item_template` WHERE name LIKE '%$search_value%' $item_prefix"); $search_filter = "AND auctionhouse.item_template IN(0"; while ($item = $sqlc->fetch_row($result)) $search_filter .= ", $item[0]"; $search_filter .= ")"; } break; case "item_id": $search_filter = "AND auctionhouse.item_template = '$search_value'"; break; case "seller_name": if(( ($search_class >= 0) || ($search_quality >= 0)) && (!isset($search_value) )) { if ($search_class >= 0) $search_filter = "AND item_template.class = '$search_class'"; if ($search_quality >= 0) $search_filter = "AND item_template.Quality = '$search_quality'"; } else { $item_prefix = ""; if ($search_class >= 0) $item_prefix .= "AND item_template.class = '$search_class' "; if ($search_quality >= 0) $item_prefix .= "AND item_template.Quality = '$search_quality' "; $result = $sqlc->query("SELECT guid FROM `characters` WHERE name LIKE '%$search_value%'"); $search_filter = $item_prefix; $search_filter .= "AND auctionhouse.itemowner IN(0"; while ($char = $sqlc->fetch_row($result)) $search_filter .= ", $char[0]"; $search_filter .= ")"; $search_filter .= $item_prefix; } break; case "buyer_name": if(( ($search_class >= 0) || ($search_quality >= 0)) && (!isset($search_value) )) { if ($search_class >= 0) $search_filter = "AND item_template.class = '$search_class'"; if ($search_quality >= 0) $search_filter = "AND item_template.Quality = '$search_quality'"; } else { $item_prefix = ""; if ($search_class >= 0) $item_prefix .= "AND item_template.class = '$search_class' "; if ($search_quality >= 0) $item_prefix .= "AND item_template.Quality = '$search_quality' "; $result = $sqlc->query("SELECT guid FROM `characters` WHERE name LIKE '%$search_value%'"); $search_filter = $item_prefix; $search_filter .= "AND auctionhouse.buyguid IN(-1"; while ($char = $sqlc->fetch_row($result)) $search_filter .= ", $char[0]"; $search_filter .= ")"; } break; default: redirect("ahstats.php?error=1"); } $query_1 = $sqlc->query("SELECT count(*) FROM `".$characters_db[$realm_id]['name']."`.`characters` , `".$characters_db[$realm_id]['name']."`.`item_instance` , `".$world_db[$realm_id]['name']."`.`item_template` , `".$characters_db[$realm_id]['name']."`.`auctionhouse` LEFT JOIN `".$characters_db[$realm_id]['name']."`.`characters` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid` WHERE `auctionhouse`.`itemowner`=`characters`.`guid` AND `auctionhouse`.`item_template`=`item_template`.`entry` AND `auctionhouse`.`itemguid`=`item_instance`.`guid` $search_filter $order_side"); } else { $query_1 = $sqlc->query("SELECT count(*) FROM auctionhouse"); } $result = $sqlc->query("SELECT `characters`.`name` AS `seller`, `auctionhouse`.`item_template` AS `itemid`, `item_template`.`name` AS `itemname`, `auctionhouse`.`buyoutprice` AS `buyout`, `auctionhouse`.`time`-unix_timestamp(), `c2`.`name` AS `encherisseur`, `auctionhouse`.`lastbid`, `auctionhouse`.`startbid`, SUBSTRING_INDEX(SUBSTRING_INDEX(`item_instance`.`data`, ' ',15), ' ',-1) AS qty, `characters`.`race` AS seller_race, `c2`.`race` AS buyer_race FROM `".$characters_db[$realm_id]['name']."`.`characters` , `".$characters_db[$realm_id]['name']."`.`item_instance` , `".$world_db[$realm_id]['name']."`.`item_template` , `".$characters_db[$realm_id]['name']."`.`auctionhouse` LEFT JOIN `".$characters_db[$realm_id]['name']."`.`characters` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid` WHERE `auctionhouse`.`itemowner`=`characters`.`guid` AND `auctionhouse`.`item_template`=`item_template`.`entry` AND `auctionhouse`.`itemguid`=`item_instance`.`guid` $search_filter $order_side ORDER BY `auctionhouse`.`$order_by` $order_dir LIMIT $start, $itemperpage"); $all_record = $sqlc->result($query_1,0); //=====================top tage navigaion starts here======================== $output .="
"; makebutton($lang_global['search'], "javascript:do_submit()",80); $output .= " "; (($search_by && $search_value) || ($search_class != -1) || ($search_quality != -1)) ? makebutton($lang_global['back'], "javascript:window.history.back()",80) : $output .= ""; $output .= "
"; $output .= generate_pagination("ahstats.php?order_by=$order_by".( (($search_by && $search_value) || ($search_class != -1) || ($search_quality != -1)) ? "&search_by=$search_by&search_value=$search_value&search_quality=$search_quality&search_class=$search_class&error=2" : "" )."&dir=".(($dir) ? 0 : 1), $all_record, $itemperpage, $start); $output .= "
"; global $mmfpm_db, $world_db; $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); $sqlw = new SQL; $sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']); while ($rows = $sqlc->fetch_row($result)) { $output .= " "; foreach($rows as $row => $value) { switch ($row) { case 4: $value = ($value >= 0)? (floor($value / 86400).$lang_auctionhouse['dayshortcut']." ". floor(($value % 86400)/3600).$lang_auctionhouse['hourshortcut']." ".floor((($value % 86400)%3600)/60).$lang_auctionhouse['mnshortcut']) : $lang_auctionhouse['auction_over']; break; case 5: $value = "".((!empty($rows[10])) ? "".htmlentities($value)."" : "N/A").""; break; case 7: case 6: case 3: $g = floor($value/10000); $value -= $g*10000; $s = floor($value/100); $value -= $s*100; $c = $value; $value = $g."\"\" ".$s."\"\" ".$c."\"\" "; break; case 2: $value = "\"$value\"
$value".(($rows[8]>1) ? " (x$rows[8])" : "").""; break; case 0: $value = "".((!empty($rows[9])) ? "".htmlentities($value)."" : "N/A").""; break; } if (!in_array($row,$hiddencols)) $output .= " "; } $output .= " "; } $output .= "
".($order_by=='itemowner' ? "\"\" " : "")."{$lang_auctionhouse['seller']} ".($order_by=='item_template' ? "\"\" " : "")."{$lang_auctionhouse['item']} ".($order_by=='buyoutprice' ? "\"\" " : "")."{$lang_auctionhouse['buyoutprice']} ".($order_by=='time' ? "\"\" " : "")."{$lang_auctionhouse['timeleft']} ".($order_by=='buyguid' ? "\"\" " : "")."{$lang_auctionhouse['buyer']} ".($order_by=='lastbid' ? "\"\" " : "")."{$lang_auctionhouse['lastbid']} ".($order_by=='startbid' ? "\"\" " : "")."{$lang_auctionhouse['firstbid']}
".$value."
"; $output .= generate_pagination("ahstats.php?order_by=$order_by".( (($search_by && $search_value) || ($search_class != -1) || ($search_quality != -1)) ? "&search_by=$search_by&search_value=$search_value&search_quality=$search_quality&search_class=$search_class&error=2" : "" )."&dir=".(($dir) ? 0 : 1), $all_record, $itemperpage, $start); $output .= "
{$lang_auctionhouse['total_auctions']} : $all_record
"; } //############################################################################# // MAIN //############################################################################# $err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $output .= "
"; $lang_auctionhouse = lang_auctionhouse(); switch ($err) { case 1: $output .= "

{$lang_global['empty_fields']}

"; break; case 2: $output .= "

{$lang_auctionhouse['search_results']}

"; break; default: $output .= "

{$lang_auctionhouse['auctionhouse']}

"; } unset($err); $output .= "
"; $action = (isset($_GET['action'])) ? $_GET['action'] : NULL; switch ($action) { case "unknown": break; default: browse_auctions($sqlr, $sqlc); } unset($action); unset($action_permission); unset($lang_auctionhouse); require_once("footer.php"); ?>