Changeset 209 for trunk/src/game/Level3.cpp
- Timestamp:
- 11/19/08 13:46:36 (17 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/game/Level3.cpp
r184 r209 2098 2098 2099 2099 result=CharacterDatabase.PQuery( 2100 2100 // 0 1 2 3 4 5 2101 2101 "SELECT ci.item, cibag.slot AS bag, ci.slot, ci.guid, characters.account,characters.name " 2102 2102 "FROM character_inventory AS ci LEFT JOIN character_inventory AS cibag ON (cibag.item=ci.bag),characters " … … 2152 2152 { 2153 2153 result=CharacterDatabase.PQuery( 2154 2154 // 0 1 2 3 4 5 6 2155 2155 "SELECT mail_items.item_guid, mail.sender, mail.receiver, char_s.account, char_s.name, char_r.account, char_r.name " 2156 2156 "FROM mail,mail_items,characters as char_s,characters as char_r " … … 2202 2202 { 2203 2203 result=CharacterDatabase.PQuery( 2204 2204 // 0 1 2 3 2205 2205 "SELECT auctionhouse.itemguid, auctionhouse.itemowner, characters.account, characters.name " 2206 2206 "FROM auctionhouse,characters WHERE auctionhouse.item_template='%u' AND characters.guid = auctionhouse.itemowner LIMIT %u", … … 2329 2329 else 2330 2330 result = WorldDatabase.PQuery("SELECT guid, position_x, position_y, position_z, map FROM gameobject WHERE id = '%u' LIMIT %u", 2331 go_id,uint32(count));2331 go_id,uint32(count)); 2332 2332 2333 2333 if (result) … … 2484 2484 else 2485 2485 result = WorldDatabase.PQuery("SELECT guid, position_x, position_y, position_z, map FROM creature WHERE id = '%u' LIMIT %u", 2486 cr_id,uint32(count));2486 cr_id,uint32(count)); 2487 2487 2488 2488 if (result)