Off traders from database?

[alejandromoran]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 6291:
L2JDP Revision 9641:

Hi all, I would like to know if it's possible to get information about offline traders and what they are selling outside of game from database? (I've not found nothing)

Thank you very much =)

[BiggBoss]

it'll sound obvious, but just create any app (web,program,app,...) that connects to your game database

[alejandromoran]

And... where is this data stored? what table?

[BiggBoss]

http://svn.l2jdp.com/trunk/L2J_DataPack ... _trade.sql
http://svn.l2jdp.com/trunk/L2J_DataPack ... _items.sql

[alejandromoran]

I supposed that I should use that tables, what I don't understand it's why I haven't any data in that tables?? (I've offline traders right now), thank you very much.

[BiggBoss]

First, to store them, the option to restore offline traders on server start up must be enabled. Second, offline traders are stored in database on server's shutdown. If you didnt shutted down the server since the offline traders was setted, they wont appear.

If you still wanna access offline traders information from an outside app, you have 2 options, update database with each new store setted (not a good option), or create a custom server which send you that data to your app.