30-11-2013, 09:48 AM
|
#2
|
|
• الانـتـسـاب » Feb 2013
|
• رقـم العـضـويـة » 109807
|
• المشـــاركـات » 2,903
|
• الـدولـة » اسكندريه
|
• الـهـوايـة » برمجه
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 100
|
|
|
كود:
Adding Job Rates
Well, that will increase the price also
(At my opinion more enjoymend for Traders because they get scared of they expensive loot )
, but it works for Thiefs and Hunters, here is the query.
Hope you like it ;)
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 the *20 to your value =)
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjCommon
SET Price = 3830
WHERE Price = 383
UPDATE dbo._RefObjCommon
SET SellPrice = 1910
WHERE SellPrice = 191
UPDATE dbo._RefPricePolicyOfItem
SET Cost = 114900
WHERE Cost = 16024
|
|
|