Changeset 142 for minimanager/ahstats.php

Timestamp:

Nov 23, 2007, 11:29:33 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.5b

File:

• minimanager/ahstats.php (modified) (7 diffs)

minimanager/ahstats.php

@@ -17 +17 @@
 //########################################################################################################################
 function browse_auctions() {
- global $lang_auctionhouse, $lang_global, $lang_item, $output, $mangos_db, $realm_id, 
+ global $lang_auctionhouse, $lang_global, $lang_item, $output, $characters_db, $realm_id, $mangos_db,
                 $itemperpage, $item_datasite, $server, $user_lvl, $user_id;
 
@@ -26 +26 @@
 
  $sql = new SQL;
- $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+ $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
  $start = (isset($_GET['start'])) ? $sql->quote_smart($_GET['start']) : 0;
@@ -47 +47 @@
  $result = $sql->query("SELECT `character`.`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, `character`.`race` AS seller_race, `c2`.`race` AS buyer_race
- FROM `character`, `item_instance`,`item_template`, `auctionhouse` LEFT JOIN `character` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid`
+ FROM `".$characters_db[$realm_id]['name']."`.`character` , `".$characters_db[$realm_id]['name']."`.`item_instance` , `".$mangos_db[$realm_id]['name']."`.`item_template` , `".$characters_db[$realm_id]['name']."`.`auctionhouse`
+LEFT JOIN `".$characters_db[$realm_id]['name']."`.`character` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid`
  WHERE `auctionhouse`.`itemowner`=`character`.`guid` AND `auctionhouse`.`item_template`=`item_template`.`entry` AND `auctionhouse`.`itemguid`=`item_instance`.`guid`
  $order_side ORDER BY `auctionhouse`.`$order_by` $order_dir LIMIT $start, $itemperpage");
@@ -152 +153 @@
 //########################################################################################################################
 function search_auctions() {
- global $lang_auctionhouse, $lang_global, $lang_item, $output, $mangos_db, $realm_id, 
+ global $lang_auctionhouse, $lang_global, $lang_item, $output, $characters_db, $realm_id, $mangos_db, 
+
                 $itemperpage, $item_datasite, $server, $user_lvl, $user_id, $sql_search_limit;
 
@@ -161 +163 @@
 
  $sql = new SQL;
- $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+ $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
  $order_by = (isset($_GET['order_by'])) ? $sql->quote_smart($_GET['order_by']) : "time";
@@ -198 +200 @@
                 if ($search_quality >= 0) $item_prefix .= "AND Quality = '$search_quality' ";
                 
-                $result = $sql->query("SELECT entry FROM item_template WHERE name LIKE '%$search_value%' $item_prefix");
+                $result = $sql->query("SELECT entry FROM `mangos`.`item_template` WHERE name LIKE '%$search_value%' $item_prefix");
                 $search_filter = "AND auctionhouse.item_template IN(0";
                 while ($item = $sql->fetch_row($result)) $search_filter .= ", $item[0]";
@@ -224 +226 @@
                 redirect("ahstats.php?error=1");
  }
-                
- $result = $sql->query("SELECT `character`.`name` AS `seller`, `auctionhouse`.`item_template` AS `itemid`, `item_template`.`name` AS `itemname`, `auctionhouse`.`buyoutprice` AS `buyout`,
+
+$result = $sql->query("SELECT `character`.`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, `character`.`race` AS seller_race, `c2`.`race` AS buyer_race
- FROM `character`, `item_instance`,`item_template`, `auctionhouse` LEFT JOIN `character` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid`
+ FROM `".$characters_db[$realm_id]['name']."`.`character` , `".$characters_db[$realm_id]['name']."`.`item_instance` , `".$mangos_db[$realm_id]['name']."`.`item_template` , `".$characters_db[$realm_id]['name']."`.`auctionhouse` LEFT JOIN `".$characters_db[$realm_id]['name']."`.`character` c2 ON `c2`.`guid`=`auctionhouse`.`buyguid`
  WHERE `auctionhouse`.`itemowner`=`character`.`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 $sql_search_limit");