L2J Server

Hi,
how to insert item into db while server is running? Is it possible?

go into items table and add an item with a unique itemID

I tried. Early everything was allright, but now after some update it doesn't works. Item don't appears visible until server restart.

NEVER manually add items to the table while server is running ! This will ends in duplicated ids and problems.

If you want give item to player try telnet. Or maybe some php script working with telnet?

With telnet is problem too. You cannot give an item when player are offline.
Early I inserted items to db with id lower than minimal server id. That works but items appears visible only after server restart.

I dont recommend adding items using the database when the server is running.. if you wanna give someone an item.. wouldnt spawning it on a gm character and then trading it to them alittle more umm.. what u call it.. "Not a bugged meathod".. As far as I know when you add to the database while the server is running, that doesn't work out to well..

Try spawning item with admin then trade?

i used to add items when server running and chars offline until today with dropcalc and i didnt have a problem, now the item dissapear.

I had used the method below occasionally to give item to offline characters and I had never had a problem......YET.

1. Create/spawn the item on a GM character.
2. While both GM and receiving character are offline (server is running), I change the "owner_id" of the object(s) to the recipient's "owner_id".
3. When the recipient next logs in (whenever he/she does log in), the item are now in the recipient's inventory.

Shouldn't there be an easy way to give a player a quest-object?

And what about GM deleting items from a players inventory, shouldn't there be such an option?

How do one see what is inside a clans warehouse?

lishawj wrote:I had used the method below occasionally to give item to offline characters and I had never had a problem......YET.

1. Create/spawn the item on a GM character.
2. While both GM and receiving character are offline (server is running), I change the "owner_id" of the object(s) to the recipient's "owner_id".
3. When the recipient next logs in (whenever he/she does log in), the item are now in the recipient's inventory.

Thanks, I think I will use that way.