Checkmate

Like above topic.. Can i request an sql queries or command to delete all acc in database which is not even online even once??.??

Im just curious about all these stuff... Thx again miss cuz setting up rAthena for answering my question.. That was very helpfull.. ^ ^

Owh.. In hercules was more complicated... but if got some error can fix easily without need to edit whole error or database or script. That was a long and ermm liltle easy to understand for newbie like me. And all i need to do know is change all the word from 'acc_reg_num_db` into `global_reg_value` right... And add the last query to make NPC read how many gold_coin from player... I try it first.. Very helped.. Thx alot guys... ^ ^ [ Edited ] 1 # Im stuck in here... Im confused where to add the clause, put in 'key' or where?..? 1 : acc_reg_num_db.account_id where `key` 2 # The queries was to detect gold coin only from iventory right?..? How to add more.. I mean to check into storage,gstorage,cart,iventory?

Ermm.... how can i solve that.. Anyting i can do to help to solve this from happen to other members sir?..?

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??..??

Nope.. Im also have th same issue... Latest version right?..? Try to check here From topic here Yup that was the solution. Its more better than relog char. Otherwise try give them @refresh cmd(But i think sometime @refresh can be abuse,so just go @go and @warp) and it was happen to default warper too which is provide by rAthena.

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); Errrr.... If you dont mind can show me how to do it... I mean an live example.. Cuz to create a new script... I still dont get it much...

I wonder if there any npc that can make a list or check of top 7 or maybe 5 richest player with zeny and cash. Only player not Staff or GM Are those npc can be created..??..??

Try to give them @refresh cmd to see it solve the problem or not... Or maybe they stuck after talking to npc?..?

Got it sir... i was remove the npc cuz i thought it can be running automatically without npc. The script itself must have npc to make it trigger

Hi there.. Im having aliltel problem here..Here... I was using the dice event by sir @Sanbox.. Then this error came out.. Here are the script which is setting p that would be autoomatically running every 9 hour. Is this true setting??..?? Need help on this...

Done,,, ^ ^ Maybe can add a sidebox which show a new update for github rAthena?..?

So sorry... Try this Topic at here

'SDloltext' => 'Akkarin is win.', Lol... End of this : Iya... Nasib baik mereka kebanyakan menggunakan bahasa inggeris.. Sekiranya mereka menggunakan bahasa mereka atau slang mereka sendiri..

Look in here Just type /showname

Cuba lihat disini

Thor Patchers Free Patcher (Soon) Beautifull work.. ^ ^ And colourfull... I dont have idea if this is mine..

About above topic.. Im already comment that and recompile back and there was no error while recompiling but how this can be happened again when idle about 1 minutes close box appear again ... ??...?? Something i miss??

What revisiona are you using? @revision I see this error somewhere in this rAthena.. Wait im searching and try to contact other scripter.. I'm using eAthena. When i type @revision unknown command. Sorry I'm newbie >_< No wonder... It is because... This script was function for rAthena... Its ok sir... Im also newbie.. ^ ^ Trying to help as i can.. ^ ^ Wait im trying searching

What revisiona are you using? @revision I see this error somewhere in this rAthena.. Wait im searching and try to contact other scripter..

Errr... Is that a positive feed back or some error?..?

I want to make a Quest Like Hokage Hat Ex: 100 Fabric, 100 Burning Heart 1 TCG Card but It makes some error. Can someone help me please? Why you did not use this script??? It support

WOW.... Is this the solution fo some random chat box change into close... Thx cuz pointing it out dude.. ^ ^ **Edit** It not working... -.-

I think there are some issue with that map or are you tryinf to edit the map?..? I dont know either if about the map.. Try to pm other map creator like Olrox and trying to ask her.

Yap... it just all in one .. But some ppl encounter and error by updating this.. Maybe that was thier client side problem.. ^ ^