Help Cached - Consult Amount Of Item

[AiroN]

Hello guys!

It can query the amount of a particular item in real time through the cacheD using PHP?

In SQL would look like:

SELECT * FROM [lin2world].[dbo].[user_item] WHERE item_type='57' AND char_id='1'

Is there any class or function ready for this?

I've tried using the packet "PrintAllItemData" (ID 42), but it seems not functioning.

Thanks in advance.

[xeL]

You can only trough sql directly not cached.

[AiroN]

Thanks, xeL!

 

The update of items table doesn't happen in real time, right?
Is there any way to force the update in PHP-cacheD?

[xeL]

there is a cached OP code for update real time update on a char. here is a php panel for l2off that uses cached options

http://sourceforge.net/projects/lin2panel/

Edited December 10, 2015 by xeL

[AiroN]

Thank you, xeL!

I will study this panel.
Soon put progress here.

Best regards!

[xeL]

no problem ;)