Add Item to NPC

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):
http://i40.tinypic.com/igam84.png

Download



MSSQL Query:

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


---

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 ^^

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

Quote:

---

Originally Posted by 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 ^^

---

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

good job hean

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 ^^

Truly nice job Hean

Thanks for idea :)

Quote:

---

Originally Posted by SL1MSH4DY

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.

thank you

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

Super lIke

thxx :)

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

Nice :D