Add Item to NPC

[Hean]

Well, here is the query, just fill out the Data you need.
You can add the same by my small n00b program :)
There is an example inside so you will know how it works.

Program(client side):


Download



MSSQL Query:

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') 

[MentaL]

[Caipi]

You cud add a retrieval for every Table if the item exists there already - otherwise it'll cause error - furthermore you can shorten those 8 variables to 3 in total actually :)

And please change the 'SRO_VT_SHARD_INIT' into 'SRO_VT_SHARD' that's the common name for the DB.

Anyway nice work ^^

[SL1MSH4DY]

Wow great job. Do you think this will work with adding white wolf to npc?
Posted via Mobile Device

[Hean]

You cud add a retrieval for every Table if the item exists there already - otherwise it'll cause error - furthermore you can shorten those 8 variables to 3 in total actually :)

And please change the 'SRO_VT_SHARD_INIT' into 'SRO_VT_SHARD' that's the common name for the DB.

Anyway nice work ^^

I'm still a n00b with mssql and don't messed that much with the syntax now. but feel free to edit it :P

[saxz]

good job hean

[Caipi]

http://forum.ragezone.com/f722/relea...21/index2.html Look at my second last post :) just to emphasize what I mean, it's nice anyway ^^

[Larkon]

Truly nice job Hean

[RevoLand]

Thanks for idea :)

[Hean]

Wow great job. Do you think this will work with adding white wolf to npc?
Posted via Mobile Device

Yeah but at this point you only need to add Refprice and Refshop txt and table :) Because refscrap/package are already definied.

[arabianfox]

thank you

[Pklawz]

Hean;
Y'know the table editing skill moobs and drop?

[epvp2]

Super lIke

[3d2000]

thxx :)

[MrLo0only]

very nice i was working on something like that but with web application you have to make some validations first (check the item exists and enabled .. calculate the slot automatically ..) but really nice effort thank you

[saufitz77]

Nice :D