Changeset 307 for minimanager/ahstats.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

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

minimanager/ahstats.php

@@ -38 +38 @@
 
  if( !$user_lvl && !$server[$realm_id]['both_factions']){
-        $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+        $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = '$user_id') LIMIT 1");
         if ($sql->num_rows($result)){
                 $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
-                " AND `character`.`race` IN (2,5,6,8,10) " : " AND `character`.`race` IN (1,3,4,7,11) ";
+                " AND `characters`.`race` IN (2,5,6,8,10) " : " AND `characters`.`race` IN (1,3,4,7,11) ";
         } else $order_side = "";
  } else $order_side = "";
 
- $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 `".$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`
+ $result = $sql->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` , `".$mangos_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`
  $order_side ORDER BY `auctionhouse`.`$order_by` $order_dir LIMIT $start, $itemperpage");
  $this_page = $sql->num_rows($result);
@@ -180 +180 @@
 
  if( !$user_lvl && !$server[$realm_id]['both_factions']){
-        $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+        $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = '$user_id') LIMIT 1");
         if ($sql->num_rows($result)){
                 $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
-                " AND `character`.`race` IN (2,5,6,8,10) " : " AND `character`.`race` IN (1,3,4,7,11) ";
+                " AND `characters`.`race` IN (2,5,6,8,10) " : " AND `characters`.`race` IN (1,3,4,7,11) ";
         } else $order_side = "";
  } else $order_side = "";
@@ -200 +200 @@
                 if ($search_quality >= 0) $item_prefix .= "AND Quality = '$search_quality' ";
 
-                $result = $sql->query("SELECT entry FROM `mangos`.`item_template` WHERE name LIKE '%$search_value%' $item_prefix");
+                $result = $sql->query("SELECT entry FROM `".$mangos_db[$realm_id]['name']."`.`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]";
@@ -212 +212 @@
 
         case "seller_name":
-                $result = $sql->query("SELECT guid FROM `character` WHERE name LIKE '%$search_value%'");
+                $result = $sql->query("SELECT guid FROM `characters` WHERE name LIKE '%$search_value%'");
                 $search_filter = "AND auctionhouse.itemowner IN(0";
                 while ($char = $sql->fetch_row($result)) $search_filter .= ", $char[0]";
@@ -218 +218 @@
         break;
         case "buyer_name":
-                $result = $sql->query("SELECT guid FROM `character` WHERE name LIKE '%$search_value%'");
+                $result = $sql->query("SELECT guid FROM `characters` WHERE name LIKE '%$search_value%'");
                 $search_filter = "AND auctionhouse.buyguid IN(-1";
                 while ($char = $sql->fetch_row($result)) $search_filter .= ", $char[0]";
@@ -227 +227 @@
  }
 
-$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 `".$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
+$result = $sql->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` , `".$mangos_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 $sql_search_limit");
  $tot_found = $sql->num_rows($result);