Insert item

[MKas]

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

[momo61]

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

[MKas]

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

[_DS_]

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

[qwerty13]

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

[MKas]

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.

[itskidd]

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?

[blacksea]

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.

[lishawj]

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.

[Notorious]

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?

[MKas]

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.