GM Staff online status

[Jesky]

Hi everyone, this is my 2nd thread on rathena.

I already search and found many of this script (GM Online Status), the one i like is sir Emistry script.

But can someone modifiy a little to keep the list of GM and show the status if he/she online, offline, or afk?

 

For example, when the npc clicked, it will show the dialogue like this:

 

============================================

Example-RO GM List: 2 (amount of GM in the server)

- Admin [Admin character name]

Status: Online/Offline/AFK

Last Login: (Example: 10.00am 22/12/2013)

- Game Master [GM character name]

Status: Online/Offline/AFK

Last Login: (Example: 10.00am 22/12/2013)

 

(Show the clock & date here)

ex: 11:08am 22 December, 2013

============================================

 

Hope someone can help me. Credit to sir Emistry

Edited December 22, 2013 by Jesky

[AnnieRuru]

emistry is having his holiday

so I do

 

prontera,155,171,5	script	GM Online Lists	436,{
	mes "Example RO GM list : "+( .admincount + .gmcount );
	mes "-----------------------------";
	for ( .@i = 0; .@i < .admincount; .@i++ ) {
		mes "Admin : "+ .admin$[.@i];
		mes "Status : "+( ( isloggedin( getcharid( 3, .admin$[.@i] ) ) )? ( ( checkidle( .admin$[.@i] ) > .idletime )? "Idle" : "Online" ) : "Offline" );
		query_sql "select date_format( lastlogin , '%l.%i%p %e/%c/%Y' ) from login right join `char` on `char`.account_id = login.account_id where `char`.name = '"+ escape_sql( .admin$[.@i] ) +"'", .@time$;
		mes "Last Login: "+ .@time$;
		mes "-----------------------------";
	}
	for ( .@i = 0; .@i < .gmcount; .@i++ ) {
		mes "GM : "+ .gm$[.@i];
		mes "Status : "+( ( isloggedin( getcharid( 3, .gm$[.@i] ) ) )? ( ( checkidle( .gm$[.@i] ) > .idletime )? "Idle" : "Online" ) : "Offline" );
		query_sql "select date_format( lastlogin , '%l.%i%p %e/%c/%Y' ) from login right join `char` on `char`.account_id = login.account_id where `char`.name = '"+ escape_sql( .gm$[.@i] ) +"'", .@time$;
		mes "Last Login: "+ .@time$;
		mes "-----------------------------";
	}
	mes gettimestr("%I:%M%p ",10) + gettime(5) + gettimestr(" %B ",15) + gettime(7);
	close;

OnInit:
	.idletime = 60; // idle for 60 seconds = idle status
	setarray .admin$, "AnnieRuru";
	setarray .gm$, "EnnyRuru", "KinoRuru";

	.admincount = getarraysize( .admin$ );
	.gmcount = getarraysize( .gm$ );
	end;
}

the script itself isn't hard, but for some reason, I took lots of time to figure which %? to use in date_format <.<

[Checkmate]

Miss  AnnieRuru

 

Im actually i dont know how to resolve this...

 

 

 

Did i need to restart a server?..?

I just reloading a script and it show like that..?

How was that?..?

 

**Btw thx for the nice script **

 

[AnnieRuru]

you have to make sure your GM name match the one having in your SQL table

try run this query

select login.account_id, `char`.name, `char`.char_num from login right join `char` on `char`.account_id = login.account_id where login.group_id > 0;

also your map-server.exe should've display an error message

try show that error too

[Jesky]

I'm so happy, this script works very well and it's like what i want! Thank you so much miss Annie, you're the best! 

*again, sorry for my bad english