Register for your free account! | Forgot your password?

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

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

Advertisement



i need query to change job rate

Discussion on i need query to change job rate within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2015
Posts: 48
Received Thanks: 2
i need query to change job rate

i need query job rate 70x
By 1 Trade Item = 1m
Sell 1 Trade item = 2m ?
leader* is offline  
Old 03/24/2015, 11:16   #2
 
Crayon*'s Avatar
 
elite*gold: 1700
Join Date: Oct 2014
Posts: 432
Received Thanks: 396
PHP Code:
USE [SRO_VT_SHARD]
GO

UPDATE dbo
._RefObjCommon
SET Price 
383*20
WHERE Price 
383

UPDATE dbo
._RefObjCommon
SET SellPrice 
191*20
WHERE SellPrice 
191

UPDATE dbo
._RefPricePolicyOfItem
SET Cost 
383*20
WHERE Cost 
383 
Change 20 to your value, this query will change the price&rate, also you have to edit it in client side.
Crayon* is offline  
Reply


Similar Threads Similar Threads
[RELEASE] CHANGING YOUR EUDEMON COMPOSE RATE USING QUERY
07/13/2017 - EO PServer Guides & Releases - 19 Replies
i though many of people here having a problem when trying to changing their eudemon compose rate one by one in cq_eudemon_rbn_rqr..so i made a simple query to changing it easily by using a query..so here we go..firsty..u must have a standard compose sql..so i have upload the standard compose rate query for download if u like(my standard compose rate). Then use this query to changing your composing rate.. UPDATE `cq_eudemon_rbn_rqr` SET max = max + 20; UPDATE `cq_eudemon_rbn_rqr` SET...
i need iSRO alchmey rate query
06/11/2013 - SRO Private Server - 0 Replies
Hi, i need iSRO alchemy rate query. Please help me
Query to change inventorysize by chr name
06/17/2012 - SRO PServer Guides & Releases - 1 Replies
Hello,Epvpers. Simple query to change inventorysize by character name. Enjoy USE GO --by Atossuper Declare @CharName Varchar (64) Set @CharName = 'Put Chr name here' UPDATE dbo._Char
[Question]How to change Exp rate and Drop rate?
01/30/2012 - Dragonica Private Server - 0 Replies
Sorry i has a problem to use GM-Tool, CMTOOL, GMAdminTool. and How to Setup GM-Tool, CMTOOL, GMAdminTool ? help please.
Change Query class?
01/14/2010 - EO PServer Hosting - 1 Replies
Hello friends. by gentele someone could help me with any query exchange class as to testing my serves and has no class switching could someone help me please?? Thank you friends and friends :o



All times are GMT +2. The time now is 04:29.


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