Changeset 374 for minimanager/ahstats.php
- Timestamp:
- Sep 11, 2008, 9:10:27 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
minimanager/ahstats.php
r307 r374 10 10 11 11 require_once("header.php"); 12 valid_login( 0);12 valid_login($action_permission['read']); 13 13 require_once("scripts/get_lib.php"); 14 14 … … 38 38 39 39 if( !$user_lvl && !$server[$realm_id]['both_factions']){ 40 $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = '$user_id') LIMIT 1");40 $result = $sql->query("SELECT race FROM `characters` WHERE account = $user_id AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = $user_id) LIMIT 1"); 41 41 if ($sql->num_rows($result)){ 42 42 $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ? … … 44 44 } else $order_side = ""; 45 45 } else $order_side = ""; 46 46 47 47 $result = $sql->query("SELECT `characters`.`name` AS `seller`, `auctionhouse`.`item_template` AS `itemid`, `item_template`.`name` AS `itemname`, `auctionhouse`.`buyoutprice` AS `buyout`, 48 48 `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
Note:
See TracChangeset
for help on using the changeset viewer.