Need Query to find gold in Guild storage and chars
Discussion on Need Query to find gold in Guild storage and chars within the SRO PServer Questions & Answers forum part of the SRO Private Server category.
... query to find gold in All guild storage, and in All chars Storage ...
Quick and easy.
PHP Code:
USE SRO_VT_SHARD SELECT c.CharName16 AS 'Charname', c.RemainGold as 'Inventory Gold', aJID.Gold as 'Storage Gold', g.Gold as 'Guild Storage Gold' FROM dbo._Char AS c INNER JOIN dbo._Guild AS g ON g.ID = c.GuildID INNER JOIN dbo._User AS u ON u.CharID = c.CharID INNER JOIN dbo._AccountJID AS aJID ON aJID.JID = u.UserJID ORDER BY c.RemainGold + aJID.Gold DESC -- Sort by inventory + storage
[Solved]Add items to storage query 04/14/2021 - SRO PServer Questions & Answers - 8 Replies Hello everyone, i am trying to build a query to add items to storage.
This is what i have achieved so far
exec _ADD_ITEM_EXTERN_CHEST 1417, 3683, 15, 1
1417 -- The Account JID
3683 -- The Item ID
15 -- The Item Quantity
1 -- default
Vsro Storage query is failed help 12/29/2016 - SRO Private Server - 2 Replies http://image.prntscr.com/image/def1b30f74d14414a4e d4ff5803183c5.png
Sometimes this is over
Exchange,stall items buy dc items no.
help
