- 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. -
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..
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.
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..)
Insert all items (the modified code of an insertion items)!!!
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.
#insert_item Right Syntax 07/24/2011 - Rappelz - 9 Replies the right syntax for the insert_item function :
#insert_item(ID,howmuch,+,level,flag,"YourNa me")
example :
#insert_item(540100,1,20,10,2,"Strean")
description :
[Help Me]Insert_item work as a creation of the server 07/23/2011 - Rappelz - 3 Replies Hi,
I have a problem with insert_item.
For example when I do this command:
#insert_item(540037, 1, 1, 1, -2147483648, "Oujdi")
It gives me no item.
But it worked very well before the first server startup.
Help me please.
[Help Me] Insert_item does not 07/12/2011 - Rappelz - 3 Replies Hi,
When I type a command in CapitainHerlockServer I do not receive the item.
The command I type is : #insert_item(540037, 1, 1, 1, -2147483648, "Oujdii")
And I've already changed the FRAG
Help ME please
