Well, here is the query, just fill out the Data you need.
You can add the same by my small n00b program [Only registered and activated users can see links. Click Here To Register...]
There is an example inside so you will know how it works.
Program(client side):
[Only registered and activated users can see links. Click Here To Register...]
Download
[Only registered and activated users can see links. Click Here To Register...]
MSSQL Query:
Thanks,Have a nice day
Regards
You can add the same by my small n00b program [Only registered and activated users can see links. Click Here To Register...]
There is an example inside so you will know how it works.
Program(client side):
[Only registered and activated users can see links. Click Here To Register...]
Download
[Only registered and activated users can see links. Click Here To Register...]
MSSQL Query:
Code:
USE SRO_VT_SHARD_INIT GO DECLARE @ID int DECLARE @CodeName varchar(129) DECLARE @DescSTRID varchar(129) DECLARE @File varchar(129) DECLARE @Price int DECLARE @Slot tinyint DECLARE @TAB varchar(129) DECLARE @Data int --- Set Variables SET @ID = 84037 SET @CodeName = 'ITEM_ETC_ARCHEMY_MAGICSTONE_STR_08' SET @DescSTRID = 'SN_ITEM_ETC_ARCHEMY_MAGICSTONE_STR_TT_DESC' SET @File = 'item\etc\archemy_magicstone_str.ddj' SET @Price = 9000000 SET @Slot = 11 SET @TAB = 'STORE_KT_ACCESSORY_TAB3' SET @Data = 0 SET IDENTITY_INSERT _RefPackageItem ON INSERT _RefPackageItem ( [Service], Country, ID, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128) VALUES ( 1, 15, @ID,'PACKAGE_' + @CodeName, 0, 'EXPAND_TERM_ALL', 'SN_' + @CodeName, @DescSTRID, @File, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx') SET IDENTITY_INSERT _RefPackageItem OFF INSERT _RefScrapOfPackageItem ( Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128 ) VALUES (1, 15, 'PACKAGE_' + @CodeName, @CodeName, 0, 0, @Data, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx' ) INSERT _RefPricePolicyOfItem ( Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128 ) VALUES (1, 15, 'PACKAGE_' + @CodeName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx') INSERT _RefShopGoods ( Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128 ) VALUES (1, 15, @TAB,'PACKAGE_' + @CodeName, @Slot, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
Regards