Use the cursor for all avatars and adjust the price of hat attach and dress on its typeIDs. You can also order the avatars and implement them to different shopGrouos by defining the gender
[Release][Query] Query _InvCOS Items WITH _Char Connection 12/29/2015 - SRO PServer Guides & Releases - 1 Replies Ok, so i needed to write this query for a procedure im working on and not many people know how to connect the pet inventory table to the character table.... so this query will explain how its done...
im not going to explain every single detail, like how there is no charcos when pet is despawned / dead... but yea you can probably figure that all out from this query...
The code...
USE
SELECT pet_invo.
,pet_invo. PetSlot