Request count item in server

[SweetyBerriiz]

i want to count item in my server like countitem npc script

Edited August 19, 2013 by SweetyBerriiz

[Patskie]

Only inventory? or also includes items in storage, mail, auction and so on.

[SweetyBerriiz]

Only inventory? or also includes items in storage, mail, auction and so on.

 

yes includes all

[x13th]

You need SQL statement.

 

prontera,157,95,4    script    ahue    602,{
query_sql ("SELECT SUM(nameid) FROM `auction` WHERE `nameid` = '569'", @auction); 
query_sql ("SELECT SUM(amount) FROM `inventory` WHERE `nameid` = '569'", @inventory); 
query_sql ("SELECT SUM(amount) FROM `storage` WHERE `nameid` = '569'", @storage); 
query_sql ("SELECT SUM(amount) FROM `cart_inventory` WHERE `nameid` = '569'", @cartinventory); 
query_sql ("SELECT SUM(amount) FROM `mail` WHERE `nameid` = '569'", @mail); 
 
set sum, @inventory + @storage + @cartinventory + @mail + @auction;
mes sum;
 
close;
}

Edited August 20, 2013 by x13th

[SweetyBerriiz]

i write like this already but it's not realtime

 

you can try

1. @item 4001 5ea

2. relogin

3. click your npc, npc will return 5 to you

4. @item 4001 5ea again

5. click your npc , npc will return 5 same before

 

it's not realtime, npc must return 10 not 5 when i @item again and not relogin

[x13th]

because your account is not yet save in your db unless you log out or wait for a minute.

[Emistry]

it should be like this...http://upaste.me/raw/54d5fb

 

and..you are unable to do a realtime count since saving data into database required some time or event to trigger it.

[SweetyBerriiz]

ahh , i already know why not recommend to make server function like this because it's must query item every table if item have a lot server will work heavily