Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 12:21

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

Advertisement



[Release] How to Edit Forgotten World Quest Reward last Weapon.

Discussion on [Release] How to Edit Forgotten World Quest Reward last Weapon. within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2016
Posts: 113
Received Thanks: 13
Talking [Release] How to Edit Forgotten World Quest Reward last Weapon.

Hello Dear Epvp People.

Let's Start.

You Need at Db - _RefQuestRewardItems
And Media.Pk2 you need - refquestrewarditems.txt

First Go Db at _RefQuestRewardItems Change What item you want :
PHP Code:
1    799    QNO_FW_RS1_001    0    What item you want ***    0    1    ***    0    ***    0    *** 
Put What item you want to get as rawared want Example ITEM_CH_SWORD_12_B_RARE

Pres Execute and Db Done !

Now Media.Pk2 Go To refquestrewarditems.txt and search all line like this :
PHP Code:
799    QNO_FW_RS1_001    0    What item you want here    ***    ***    0    1    0    ***    0    *** 
Put what item want at Reward at What item you want here .

Press Save and All done.

If Hellp Give Thanks , If need me pm Me in Private Good Luck.
EQuiNoXsro is offline  
Thanks
4 Users
Old 05/11/2016, 20:03   #2
 
nemo08's Avatar
 
elite*gold: 393
Join Date: Feb 2009
Posts: 681
Received Thanks: 396
Here is a simple Query to do this and the credits always saved By BryanSA ..

Quote:
/************* Script Created By BryanSA | Please, Not Remove This *************/
USE [SRO_VT_SHARD]
GO
DECLARE @NewItem1 varchar(128)
DECLARE @NewItem2 varchar(128)
DECLARE @NewItem3 varchar(128)
DECLARE @NewItem4 varchar(128)
DECLARE @NewItem5 varchar(128)
DECLARE @NewItem6 varchar(128)
DECLARE @NewItem7 varchar(128)
DECLARE @NewItem8 varchar(128)
DECLARE @NewItem9 varchar(128)
DECLARE @NewItem10 varchar(128)
DECLARE @NewItem11 varchar(128)
DECLARE @NewItem12 varchar(128)
DECLARE @NewItem13 varchar(128)
DECLARE @NewItem14 varchar(128)
/* Script New Itens */
SET @NewItem1='NEW_ITEM_YOU_WANT' -- New Items
SET @NewItem2='NEW_ITEM_YOU_WANT' -- New Items
SET @NewItem3='NEW_ITEM_YOU_WANT' -- New Items
SET @NewItem4='NEW_ITEM_YOU_WANT' -- New Items
SET @NewItem5='NEW_ITEM_YOU_WANT' -- New Items
SET @NewItem6='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem7='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem8='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem9='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem10='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem11='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem12='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem13='NEW_EU_ITEM_YOU_WANT' -- New Items
SET @NewItem14='NEW_EU_ITEM_YOU_WANT' -- New Items
/* End Script New Itens */

/* Script Update New Items */
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem1
WHERE ItemCodeName='ITEM_CH_SWORD_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem2
WHERE ItemCodeName='ITEM_CH_BLADE_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem3
WHERE ItemCodeName='ITEM_CH_SPEAR_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem4
WHERE ItemCodeName='ITEM_CH_TBLADE_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem5
WHERE ItemCodeName='ITEM_CH_BOW_11_SET_A_RARE'
/*HeroSilkroad Revolution*/
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem6
WHERE ItemCodeName='ITEM_EU_SWORD_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem7
WHERE ItemCodeName='ITEM_EU_TSWORD_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem8
WHERE ItemCodeName='ITEM_EU_AXE_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem9
WHERE ItemCodeName='ITEM_EU_DAGGER_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem10
WHERE ItemCodeName='ITEM_EU_CROSSBOW_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem11
WHERE ItemCodeName='ITEM_EU_TSTAFF_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem12
WHERE ItemCodeName='ITEM_EU_DARKSTAFF_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem13
WHERE ItemCodeName='ITEM_EU_STAFF_11_SET_A_RARE'

UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem14
WHERE ItemCodeName='ITEM_EU_HARP_11_SET_A_RARE'
/* End Script Update New Items */

/* Insert Shield Degree13 Europe and Chinese in quest Forgotten */
INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'NEW_CH_SHIELD_YOU_WANT', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'NEW_EU_SHIELD_YOU_WANT', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
nemo08 is offline  
Old 05/12/2016, 10:43   #3
 
elite*gold: 0
Join Date: May 2016
Posts: 113
Received Thanks: 13
I no trust 100% in query this is reason why i use manually But Thanks anyway
EQuiNoXsro is offline  
Thanks
1 User
Old 05/12/2016, 22:54   #4
 
nemo08's Avatar
 
elite*gold: 393
Join Date: Feb 2009
Posts: 681
Received Thanks: 396
Quote:
Originally Posted by EQuiNoXsro View Post
I no trust 100% in query this is reason why i use manually But Thanks anyway
np mate welcome anytime
nemo08 is offline  
Reply


Similar Threads Similar Threads
[Release]Couple ring quest with a little edit Eng*
12/28/2011 - Metin2 PServer Guides & Strategies - 2 Replies
Hi guys I translated the couple rings quest and made a little modification to it i made it so that you must kill only 2 Jin-Hee and once you complete it you will recive 2x couple ring, 1x tuxedo and 1x wedding dress. (I don't think anyone else has ever done this before so i decided to release it.) quest couple_ring begin state start begin when 9006.chat."Revenge for the ring Dealer." with pc.get_level()>=25 begin say("Hi") say("Your looking for the ring dealer?") ...
[RELEASE]Level reward quest!
11/02/2011 - Metin2 Guides & Templates - 6 Replies
New Level up reward Quest DOnt forget to fix in download rar this
How to edit Quest Reward for Report Job Change to Gildas?
07/22/2011 - Rappelz - 4 Replies
As in the Topic title seen i need help in editing the quest reward anyone knows how to?



All times are GMT +1. The time now is 12:21.


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.