Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Questions & Answers
You last visited: Today at 07:05

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



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.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2021
Posts: 8
Received Thanks: 2
Need Query to find gold in Guild storage and chars

Hi, i need some query to find gold in All guild storage, and in All chars Storage,, thanks
LatinFlowShy is offline  
Old 08/14/2021, 08:42   #2
 
JellyBitz's Avatar
 
elite*gold: 0
Join Date: Sep 2018
Posts: 419
Received Thanks: 941
Quote:
Originally Posted by LatinFlowShy View Post
... 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 
JellyBitz is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[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



All times are GMT +1. The time now is 07:06.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.