How to I can put aden to the char into the game?

[Systemer]

So, Gentelmens, could you help me?

I need a SQL (SQL+php as well) script, which can insert Adens money to the MSSQL database for each interested account(char) for me.
Yes, of course, this is speech about convertation wmz to adens. :)

Dont speak about l2admin pls. It doesnt worked. I dont know why.

Pls, anybody helm me with script?

Thanks,

wbr,

Systemer.

[MentaL]

[Sundh]

your english is terrible cant understand a shit.

[Dreamgun]

if u want adena... on builder level 1 //summon adena amount
"//summon adena 1000000000"

[localhost]

Yea but he wants to add it to another account. So in doing that you need to modify the users scripts. Start by finding the correct script then find the user and add the item # for adena and the # of adena under the players account id. This is the only way I know, but there may be a simpler solution to this.

[vaskes]

Dont speak about l2admin pls. It doesnt worked. I dont know why.

do not use russian windows hehe :)

[hr-msk]

use CacheD :)

[ProfessorF]

use CacheD :)

you're talking about insert menu?

[hr-msk]

I'm talking about L2ATL/CacheD

[philips]

l2atl cached doesnt support adding of items, neither deletion of items,
it should, but it doesnt

[SantinoB]

This is command to add items via cachd:

public const string ADD_ITEM = "12\t{0**\t{1**\t{2**\t{3**\t{4**\t{5**\t{6**\t{7**\t{8**\t{9**\t{10**\n"; 
格式:12, charName, warehouse, itemType, itemAmount, enchant, eroded, bless, ident, wished 

i use it, and it work....

[rodier]

omg.. simply use SQL query insert into ...
(but server read that new amounts from table after restart...)

declare @a int
set @a = (SELECT char_id FROM lin2world.dbo.user_data where char_name = 'insert_CHARACTER_name_here')
insert into lin2world.dbo.user_item (char_id, item_type, amount, enchant, eroded, bless, ident, wished, warehouse ) values (@a,57, AMOUNT_OF_$$$, 0, 0, 0, 0, 0, 0 )

dont be lame and try it. When I start admiin L2 I never look on sql.. never know it.. and now? simply use google ;]
You can insert this way ANY item.
Simply change 57 to anything you want (57 is adena)
if you set warehouse to 1 and enchant to XY player get item +XY in warehouse.
btw > you can't insert via this pet flute.. because simply creating new item is not all. You need insert that pet to pet_data too