count log for change item

[minx123]

i need some help.. can some make a script to give a log?

example

player will change how much they have item 607 to same quantity item 607 to item 608.

when they change item. it will be has log so i will know how much player change for that item.

 

[AnnieRuru]

the best log is query_sql, hands down

erm, isn't the `picklog` table already handle that ?

under type (N), that is

https://github.com/HerculesWS/Hercules/blob/master/conf/logs.conf#L17

 

[minx123]

the best log is query_sql, hands down

erm, isn't the `picklog` table already handle that ?

under type (N), that is

https://github.com/HerculesWS/Hercules/blob/master/conf/logs.conf#L17

this one right?

 

[AnnieRuru]

more like

select * from picklog where ( nameid = 607 or nameid = 608 ) and type = 'N';