Insert Item Query
Page 1 of 1
Insert Item Query
Admin Thu May 19, 2011 3:32 pm
Run this query to add items that you want to. Make sure you are logged out.
- Spoiler:
- USE [Telecaster]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 1, --Change this Per Item
@IN_OWNER_ID = 1, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 1, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0
SELECT 'Return Value' = @return_value
GO
Admin- Admin
- Posts : 17
Join date : 2011-05-19 -
Similar topics» loot pet item code??
» How I Can Add a New NPC Marchant item shop Rappelz
» Error on CapitainHerlock on Loading Max Item list
» How I Can Add a New NPC Marchant item shop Rappelz
» Error on CapitainHerlock on Loading Max Item list
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|