#insert_item Guide

08/01/2011 03:09 RoflcopterGoesSoiSoiSoi#1
Step #1
Code:
#sv("lv", "149", "CharacterName")
Step #2
Code:
#learn_all_skill("CharacterName")
Step #3 - choose one!

Skill Cards

Consumables with no level/enchant - SS, T-Protect, potions, etc.

Tamed creature cards

Misc. Resources
Creature Card IDs
- Original post updated and expanded upon with information from s0ul37 and others. Will be continuously updated as further confirmation and/or additional information is received. -
08/01/2011 03:13 Strean#2
yea but the insert_item function dont need the name as parameter...

you can see it if you debug the sframe the insert_item is a simple lua function that can be used in the console but you need to target a player before.

#insert_item(540037, 1, 1, 1, -2147483648)

and this is useless if you have all 5 lvl ss or any other things in the lua files who add you items..

maybe if you want to revive any player use this

#sv("hp","1","targetname")
08/01/2011 03:14 RoflcopterGoesSoiSoiSoi#3
This post was created to show people how to insert items quickly and correctly via the gameserver console, not through LUA files.
08/01/2011 03:17 Strean#4
no but i mean if your lua files contain any function who add any player items.. it dont work.

learn all skill set the last focus on your player but if any lua files add any player items, the last focus changed to this player...

this is the reason why you dont need to add the name in the console or in the lua files...
08/01/2011 03:20 RoflcopterGoesSoiSoiSoi#5
Does using the target player in #sv() set a focus and affect LUA files too?
08/01/2011 03:27 nightguy13#6
2 is items 3 is skill card(I think) and 1 is for pets
08/01/2011 03:31 s0ul37#7
Quote:
Originally Posted by Strean View Post
no but i mean if your lua files contain any function who add any player items.. it dont work.

learn all skill set the last focus on your player but if any lua files add any player items, the last focus changed to this player...

this is the reason why you dont need to add the name in the console or in the lua files...

Actually, in my level up lua, players get items by nearly every level, but with learn all skill I was able to insert all items, the focus did not change.

BTW:
You can actually use flag 2 for nearly everything.

#insert_item([itemcode], [VALUE], [enchant], [level], [flag], [target])

For skill cards:
#insert_item([itemcode], 1, [enchant], 2, [target])

For items like SS:
#insert_item([itemcode], [VALUE], 2, [target])
08/01/2011 04:09 RoflcopterGoesSoiSoiSoi#8
Original post updated. Creature card IDs with respective Rappelz Wiki pages included.
08/01/2011 05:37 s0ul37#9
Quote:
Originally Posted by RoflcopterGoesSoiSoiSoi View Post
Original post updated. Creature card IDs with respective Rappelz Wiki pages included.
The consumable is not only for cs consumable, just all items that are countable and have no enchant/level like stones, ss, ac, gmfb, scrolls, pots, etc..)

and yea value = quantity

i think flag is needed for consumables too

#insert_item([itemcode], [value/qty], 2, "CharacterName")
08/01/2011 05:43 RoflcopterGoesSoiSoiSoi#10
Post updated. Thanks!
08/01/2011 08:18 gavsta#11
yep rofl made this topic i could tell from the title
08/01/2011 09:39 gulden19#12
Only the GM's can use this codes on P.server's? or can use this a p.server "user"?
08/01/2011 11:37 DrakuLL777#13
1. Create the new character (after creation bowl off to close login the server and the game server it is not necessary).

2. Delete all lines in table Item of database Telecaster (table Item should be empty ATTENTION don't delete a line if you have other characters differently you will lose all items at all characters).

3. Import table ItemResource of database Arcadia to database Telecaster (it is not necessary to rename).

4. Launch this code:

Code:
USE [Telecaster]
 GO

 DECLARE @return_value int
 DECLARE @id int, @i int
 
 SET @i=1 -- or 2 if you have a card of the bear track as this card isn't displayed in table Item
 
 DECLARE ASD CURSOR DYNAMIC SCROLL READ_ONLY FOR 
 SELECT [id] FROM [ItemResource] order by id
 OPEN ASD 
 FETCH FIRST FROM ASD INTO @id
 WHILE (@@FETCH_STATUS=0)
 BEGIN
 EXEC [dbo].[smp_insert_item]
 @IN_SID = @i,
 @IN_OWNER_ID = 1, --Char ID (ID which you have created recently the new character mandatory to LEARN WHAT and to interpose for a place of this digit!!!)
 @IN_ACCOUNT_ID = 0,
 @IN_SUMMON_ID = 0,
 @IN_AUCTION_ID = 0,
 @IN_KEEPING_ID = 0,
 @IN_CODE = @id,
 @IN_IDX = @i,
 @IN_FLAG = 0,
 @IN_CNT = 1, 
 @IN_LEVEL = 1, 
 @IN_ENHANCE = 0, 
 @IN_ENDURANCE = 100,
 @IN_GCODE = 1,
 @IN_REMAIN_TIME = 1312186301,
 @IN_ELEMENTAL_EFFECT_TYPE = 0,
 @IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 06:00:00.000',
 @IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
 @IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0
 set @i+=1 --or if it doesn't work that @i=@i+1 
 FETCH NEXT FROM ASD INTO @id
 END
 CLOSE ASD
 DEALLOCATE ASD

 SELECT 'Return Value' = @return_value

 GO
5. Come into game and enter this character (be not frightened if at you all hangs it normally for an insertion of set of things time from several seconds about one minute is necessary).

6. Described all above is applied exceptional with a view of the test.
08/01/2011 11:40 RoflcopterGoesSoiSoiSoi#14
You posted your thing in another thread. You've had your 5 minutes of fame, don't hijack.
08/01/2011 15:20 egurgle#15
copter,,, if i use #learn_all_skill("char_name")
i can add itens with #insert_item but, all other chars gains itens too.
how to fix this?