Experienced Elementalist
- Joined
- Jul 1, 2012
- Messages
- 215
- Reaction score
- 83
PHP:
USE [SRO_VT_SHARD]
UPDATE _RefObjCommon SET
[TypeID1]= 3,
[TypeID2]= 2,
[TypeID3]= 1,
[TypeID4]= 1,
ReqLevelType1 = 1,
ReqLevel1 = 0,
AssocFile1_128 = 'xxx'
WHERE ID Between 9280 and 9285
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER1_120' WHERE ID = 5753
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER2_120' WHERE ID = 5754
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER3_120' WHERE ID = 5755
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER4_120' WHERE ID = 5756
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER5_120' WHERE ID = 5757
UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER6_120' WHERE ID = 5758
EXEC _GetMediaLines,2,'%ITEM_GUILD%SOLDIER%'