Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 09:19

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

Advertisement



Need Query Delete Gold From all player

Discussion on Need Query Delete Gold From all player within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
gmroske's Avatar
 
elite*gold: 0
Join Date: Oct 2015
Posts: 204
Received Thanks: 67
Need Query Delete Gold From all player

i Need Query Delete Gold From all player any one know Code?
gmroske is offline  
Old 04/27/2016, 14:12   #2
 
elite*gold: 0
Join Date: May 2012
Posts: 179
Received Thanks: 56
use SRO_VT_SHARD
go
update _Char set RemainGold = 0
mtnman33 is offline  
Thanks
1 User
Old 04/28/2016, 08:03   #3
 
gmroske's Avatar
 
elite*gold: 0
Join Date: Oct 2015
Posts: 204
Received Thanks: 67
Quote:
Originally Posted by mtnman33 View Post
use SRO_VT_SHARD
go
update _Char set RemainGold = 0
But maybe some one have gold at storge or storge guild.
gmroske is offline  
Old 04/28/2016, 14:50   #4
 
blapanda's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
Quote:
Originally Posted by gmroske View Post
But maybe some one have gold at storge or storge guild.
You need to learn how to query those simple stuffs by yourself.
This ain't advanced nor amateur queries, which you are requesting. Those are rated less than beginner.

Code:
USE SRO_VT_SHARD
UPDATE _AccountJID
SET Gold = 0
Edit: Try to figure out how to set gold values of guilds to zero. This may be a lesson for you actually to learn something.
blapanda is offline  
Thanks
1 User
Old 04/29/2016, 01:57   #5
 
gmroske's Avatar
 
elite*gold: 0
Join Date: Oct 2015
Posts: 204
Received Thanks: 67
Quote:
Originally Posted by blapanda View Post
You need to learn how to query those simple stuffs by yourself.
This ain't advanced nor amateur queries, which you are requesting. Those are rated less than beginner.

Code:
USE SRO_VT_SHARD
UPDATE _AccountJID
SET Gold = 0
Edit: Try to figure out how to set gold values of guilds to zero. This may be a lesson for you actually to learn something.
Thanks it`s Working
gmroske is offline  
Reply


Similar Threads Similar Threads
[Release][QUERY] Delete All Inactive Accounts
04/11/2016 - SRO PServer Guides & Releases - 3 Replies
---removed---
Query delete oldest account
03/06/2016 - SRO Private Server - 8 Replies
Help me! hello I want a query that deletes oldest accounts
Need Query for add item to all player
10/31/2014 - SRO Private Server - 2 Replies
Need It Fast please, thanks
Help Query Code Char delete
11/17/2013 - SRO Private Server - 6 Replies
hi guys. my db have char delete bug.7500 account waiting delete. this codes only 1x account deleted. i dont want 7500 account manuel delete.Anyone help me query code?. DELETE FROM _InventoryForAvatar WHERE charid = '81935' DELETE FROM _Inventory WHERE charid = '81935' DELETE FROM _CharSkillMastery WHERE charid = '81935' DELETE FROM _CharSkill WHERE charid = '81935' DELETE FROM _CharTrijob WHERE charid = '81935'



All times are GMT +1. The time now is 09:19.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.