Sure, you can:
query_sql() in /doc/scripts_commands.txt
SELECT, LIMIT, ORDER, from mysql docs
Command in NPC to select total zeny from all characters on the server to .@total_zeny array.
query_sql(" SELECT SUM(`zeny`) FROM `char`", .@total_zeny);
It will select from `char` table 10 richest players to the two arrays: .@player$[], and .@zeny[]
query_sql("SELECT name, zeny FROM `char` ORDER BY DESC LIMIT 10", .@player$, .@zeny);
Thx sir for this knowledge ^ ^
Thx also sir about this.. ^ ^
Sql query... @.@
And about this Miss Annieruru... alot...
It works well
but i encounter some error when trying to check the@cashpoints or @kafrapoints.
That npc did not showing it unlike the zeny. It just sow the close button
then
Errmmmm... How to make this fixed?..?
And the other thing,just incase how can we add a command which can make NPC read how much item example gold_coin of the player in whole server?..?
Cuz above topic was refer to zeny and cash point which is can be log into server and how about if the item?..?
Wodering about that??..??