|
You last visited: Today at 23:32
Advertisement
How can change the rawared ti FGw at talsiamn like Power.
Discussion on How can change the rawared ti FGw at talsiamn like Power. within the SRO Private Server forum part of the Silkroad Online category.
05/04/2016, 19:39
|
#1
|
elite*gold: 1 
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
How can change the rawared ti FGw at talsiamn like Power.
How title say , how i can change the rawared ? Thanks You ! 
|
|
|
|
05/06/2016, 05:02
|
#2
|
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 342
|
You can change FGW Reward FROM "RefQuestRewardItems"
, you can use this query, replace with items you want to, after you finish with executing the query, copy and paste the table to media side ".txt"
PHP Code:
/************* Script Creat By BryanSA for ******** | Please, Not Remove This *************/
USE [SRO_VT_SHARD]
GO
DECLARE [MENTION=2474014]newit[/MENTION]em1 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em2 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em3 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em4 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em5 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em6 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em7 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em8 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em9 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em10 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em11 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em12 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em13 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em14 varchar(128)
/* Script New Itens */
SET [MENTION=2474014]newit[/MENTION]em1='ITEM_CH_SWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em2='ITEM_CH_BLADE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em3='ITEM_CH_SPEAR_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em4='ITEM_CH_TBLADE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em5='ITEM_CH_BOW_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em6='ITEM_EU_SWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em7='ITEM_EU_TSWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em8='ITEM_EU_AXE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em9='ITEM_EU_DAGGER_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em10='ITEM_EU_CROSSBOW_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em11='ITEM_EU_TSTAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em12='ITEM_EU_DARKSTAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em13='ITEM_EU_STAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em14='ITEM_EU_HARP_13_C_RARE' -- New Items
/* End Script New Itens */
/* Script Update New Itens */
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em1
WHERE ItemCodeName='ITEM_CH_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em2
WHERE ItemCodeName='ITEM_CH_BLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em3
WHERE ItemCodeName='ITEM_CH_SPEAR_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em4
WHERE ItemCodeName='ITEM_CH_TBLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em5
WHERE ItemCodeName='ITEM_CH_BOW_11_SET_A_RARE'
/*HeroSilkroad Revolution*/
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em6
WHERE ItemCodeName='ITEM_EU_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em7
WHERE ItemCodeName='ITEM_EU_TSWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em8
WHERE ItemCodeName='ITEM_EU_AXE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em9
WHERE ItemCodeName='ITEM_EU_DAGGER_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em10
WHERE ItemCodeName='ITEM_EU_CROSSBOW_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em11
WHERE ItemCodeName='ITEM_EU_TSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em12
WHERE ItemCodeName='ITEM_EU_DARKSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em13
WHERE ItemCodeName='ITEM_EU_STAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em14
WHERE ItemCodeName='ITEM_EU_HARP_11_SET_A_RARE'
/* End Script Update New Itens */
/* 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, 'ITEM_CH_SHIELD_13_C_RARE', '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, 'ITEM_EU_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
|
|
|
|
|
05/01/2018, 21:27
|
#3
|
elite*gold: 0
Join Date: Feb 2018
Posts: 17
Received Thanks: 0
|
Good Work
|
|
|
|
|
05/03/2018, 14:16
|
#4
|
elite*gold: 0
Join Date: Jan 2017
Posts: 50
Received Thanks: 7
|
Quote:
Originally Posted by EdwardTeach+-
You can change FGW Reward FROM "RefQuestRewardItems"
, you can use this query, replace with items you want to, after you finish with executing the query, copy and paste the table to media side ".txt"
PHP Code:
/************* Script Creat By BryanSA for ******** | Please, Not Remove This *************/
USE [SRO_VT_SHARD]
GO
DECLARE [MENTION=2474014]newit[/MENTION]em1 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em2 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em3 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em4 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em5 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em6 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em7 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em8 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em9 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em10 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em11 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em12 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em13 varchar(128)
DECLARE [MENTION=2474014]newit[/MENTION]em14 varchar(128)
/* Script New Itens */
SET [MENTION=2474014]newit[/MENTION]em1='ITEM_CH_SWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em2='ITEM_CH_BLADE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em3='ITEM_CH_SPEAR_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em4='ITEM_CH_TBLADE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em5='ITEM_CH_BOW_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em6='ITEM_EU_SWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em7='ITEM_EU_TSWORD_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em8='ITEM_EU_AXE_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em9='ITEM_EU_DAGGER_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em10='ITEM_EU_CROSSBOW_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em11='ITEM_EU_TSTAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em12='ITEM_EU_DARKSTAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em13='ITEM_EU_STAFF_13_C_RARE' -- New Items
SET [MENTION=2474014]newit[/MENTION]em14='ITEM_EU_HARP_13_C_RARE' -- New Items
/* End Script New Itens */
/* Script Update New Itens */
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em1
WHERE ItemCodeName='ITEM_CH_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em2
WHERE ItemCodeName='ITEM_CH_BLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em3
WHERE ItemCodeName='ITEM_CH_SPEAR_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em4
WHERE ItemCodeName='ITEM_CH_TBLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em5
WHERE ItemCodeName='ITEM_CH_BOW_11_SET_A_RARE'
/*HeroSilkroad Revolution*/
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em6
WHERE ItemCodeName='ITEM_EU_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em7
WHERE ItemCodeName='ITEM_EU_TSWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em8
WHERE ItemCodeName='ITEM_EU_AXE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em9
WHERE ItemCodeName='ITEM_EU_DAGGER_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em10
WHERE ItemCodeName='ITEM_EU_CROSSBOW_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em11
WHERE ItemCodeName='ITEM_EU_TSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em12
WHERE ItemCodeName='ITEM_EU_DARKSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em13
WHERE ItemCodeName='ITEM_EU_STAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName [MENTION=2474014]newit[/MENTION]em14
WHERE ItemCodeName='ITEM_EU_HARP_11_SET_A_RARE'
/* End Script Update New Itens */
/* 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, 'ITEM_CH_SHIELD_13_C_RARE', '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, 'ITEM_EU_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
|
did u try it before !! is it working fine ?
|
|
|
|
|
05/10/2018, 00:14
|
#5
|
elite*gold: 6
Join Date: Nov 2013
Posts: 279
Received Thanks: 223
|
Change it Manual From _RefQuestRewardItems Search For Egy Items The Change It
Also Same Edit In Media Side RefQuestRewardItems.txt
|
|
|
|
 |
Similar Threads
|
i want to change battle power nobility
09/09/2015 - CO2 Private Server - 1 Replies
hello all now i want to change battle power king from 12 to 14
i have make it and the king icon in the client have been hide
what i can do ????
|
[Selling] Power Saw 140 Argos + Class change card
04/14/2014 - Atlantica Online Trading - 7 Replies
SOLD OUT !!
IMAGE : SOLD OUT !!
Skype : Vanilahero
Server : Argos
Job : Power Saw + Class Cuppon Change
Power : 2.376.000 and 2.528.000 (battle)
|
Archlord Webzen, Power Farm/ Power Level Services.
05/21/2013 - Archlord Trading - 5 Replies
Hello Guys my name is adrian and today id like to introduce you to my archlord services.(READ MY SIGNATURE)
--
--
--
Dear Adrian How does it work ?
Basicly. You must have your Account and email.
I dont want or need your email account but its just to make sure that "IF i hacked" You can always go and change it, Security reasons.
|
[B]IETE EINZIGARTIGEN POWER LEVELING SERVICE (WARROCK via WarBot POWER lvl`n)
11/11/2012 - WarRock - 1 Replies
Hallo,
ich biete einen einzigartigen 24H Power Leveling Service für nur 10 e*GOLD für einen Tag an.
Viele weitere wichtige Info´s findet ihr in meinem richtigen Thread :
- http://www.elitepvpers.com/forum/elite-gold-tradin g/2227970-b-iete-24h-warrock-acc-power-leveling-nu r-10-e-gold-warbot-24h-lvl-n.html
|
All times are GMT +1. The time now is 23:33.
|
|
