#insert_item Guide

[RoflcopterGoesSoiSoiSoi]

Step #1

#sv("lv", "149", "CharacterName")

Step #2

#learn_all_skill("CharacterName")

Step #3 - choose one!

Skill Cards

 Spoiler

#insert_item([itemcode], 1, [enchant], 2, "CharacterName")

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

 Spoiler

#insert_item([itemcode], [quantity], 2, "CharacterName")

Tamed creature cards

 Spoiler

#insert_item([itemcode], 1, 1, 1, -2147483648, "CharacterName")

Misc. Resources
Creature Card IDs

 Spoiler

Tier 1:
540014 - Poultry ([URL="http://rappelz.wikia.com/wiki/Poultry"]Poultry - Wiki[/URL])
540015 - Tortus ([URL="http://rappelz.wikia.com/wiki/Tortus"]Tortus - Wiki[/URL])
540016 - Pantera ([URL="http://rappelz.wikia.com/wiki/Pantera"]Pantera - Wiki[/URL])

Tier 2:
540038 - Orc ([URL="http://rappelz.wikia.com/wiki/Orc"]Orc - Wiki[/URL])
540039 - Yeti ([URL="http://en.wikipedia.org/wiki/Yeti"]Yeti - Wiki[/URL])
540041 - Red Pixie ([URL="http://rappelz.wikia.com/wiki/Red_Pixie"]Red Pixie - Wiki[/URL])
540042 - Blue Pixie ([URL="http://rappelz.wikia.com/wiki/Blue_Pixie"]Blue Pixie - Wiki[/URL])
540043 - Siren ([URL="http://rappelz.wikia.com/wiki/Siren"]Siren - Wiki[/URL])
540057 - Octopus ([URL="http://rappelz.wikia.com/wiki/Octopus"]Octopus - Wiki[/URL])
540109 - Skeleton ([URL="http://rappelz.wikia.com/wiki/Skeleton"]Skeleton - Wiki[/URL])
540053 - Wolf ([URL="http://rappelz.wikia.com/wiki/Wolf"]Wolf - Wiki[/URL])

Tier 3:
540044 - Salamander ([URL="http://rappelz.wikia.com/wiki/Salamander"]Salamander - Wiki[/URL])
540045 - Hawkman ([URL="http://rappelz.wikia.com/wiki/Hawkman"]Hawkman - Wiki[/URL])
540052 - Harpy ([URL="http://rappelz.wikia.com/wiki/Harpy"]Harpy - Wiki[/URL])
540065 - Unicorn ([URL="http://rappelz.wikia.com/wiki/Unicorn"]Unicorn - Wiki[/URL])
540067 - Nightmare ([URL="http://rappelz.wikia.com/wiki/Nightmare_(pet)"]Nightmare - Wiki[/URL])

Tier 4:
540010 - Kentauros ([URL="http://rappelz.wikia.com/wiki/Kentauros"]Kentauros - Wiki[/URL])
540013 - Angel ([URL="http://rappelz.wikia.com/wiki/Angel"]Angel - Wiki[/URL])
540059 - Naga ([URL="http://rappelz.wikia.com/wiki/Naga"]Naga - Wiki[/URL])
540055 - Gnoll ([URL="http://rappelz.wikia.com/wiki/Gnoll"]Gnoll - Wiki[/URL])
540073 - Abomination ([URL="http://rappelz.wikia.com/wiki/Abomination"]Abomination - Wiki[/URL])
540070 - Joker ([URL="http://rappelz.wikia.com/wiki/Joker"]Joker - Wiki[/URL])
540071 - Ice Maiden ([URL="http://rappelz.wikia.com/wiki/Ice_Maiden"]Ice Maiden - Wiki[/URL])

Tier 5:
540036 - Cerberus ([URL="http://rappelz.wikia.com/wiki/Cerberus"]Cerberus - Wiki[/URL])
540061 - Genie ([URL="http://rappelz.wikia.com/wiki/Genie"]Genie - Wiki[/URL])
540063 - Ifrit ([URL="http://rappelz.wikia.com/wiki/Ifrit"]Ifrit - Wiki[/URL])

Tier 6:
540037 - White Dragon ([URL="http://rappelz.wikia.com/wiki/White_Dragon"]White Dragon - Wiki[/URL])
540049 - Mystic Koala ([URL="http://rappelz.wikia.com/wiki/Mystic_Koala"]Mystic Koala - Wiki[/URL])
540069 - Death Tyrant ([URL="http://rappelz.wikia.com/wiki/Death_Tyrant"]Death Tyrant - Wiki[/URL])
540001 - Ent (N/A)

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

[Strean]

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

[RoflcopterGoesSoiSoiSoi]

This post was created to show people how to insert items quickly and correctly via the gameserver console, not through LUA files.

[Strean]

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

[RoflcopterGoesSoiSoiSoi]

Does using the target player in #sv() set a focus and affect LUA files too?

[nightguy13]

2 is items 3 is skill card(I think) and 1 is for pets

[s0ul37]

Originally Posted by Strean

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

[RoflcopterGoesSoiSoiSoi]

Original post updated. Creature card IDs with respective Rappelz Wiki pages included.

[s0ul37]

Originally Posted by RoflcopterGoesSoiSoiSoi

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

[RoflcopterGoesSoiSoiSoi]

Post updated. Thanks!

[gavsta]

yep rofl made this topic i could tell from the title

[gulden19]

Only the GM's can use this codes on P.server's? or can use this a p.server "user"?

[DrakuLL777]

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:

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.

[RoflcopterGoesSoiSoiSoi]

You posted your thing in another thread. You've had your 5 minutes of fame, don't hijack.

[egurgle]

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?