MvP Ranking GM Disable

[Sasuke Uchiha]

Hello I need realy help for this Script

 

How can I disable the Gm MvP kills

 

P.s Sorry for my Bad English

prontera,155,188,0	script	MVP Rank	910,{
	// get database names, for join
	query_sql    "SELECT DATABASE()", .@rag_db$;
	query_logsql "SELECT DATABASE()", .@log_db$;
	
	query_sql "SELECT `name`,COUNT(mvp_id) FROM "+.@log_db$+".mvplog " + 
	          "LEFT JOIN "+.@rag_db$+".`char` ON mvplog.kill_char_id=`char`.char_id " + 
	          "GROUP BY kill_char_id ORDER BY COUNT(mvp_id) DESC LIMIT 10", .@name$, .@kills;
	
	mes "[MVP Rank Top 10]";
	for( set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i + 1 ){
		mes "Top ^FF0000"+(.@i+1)+"^000000 "+.@name$[.@i]+" with ^FF0000"+.@kills[.@i]+"^000000 MVPs killed.";
	}
	close;
}

[Sasuke Uchiha]

anyone can help me?

 

edit: Solved

https://rathena.org/board/topic/102243-mvp-rank-menu/

Edited November 12, 2015 by Sasuke Uchiha

[Elsa Mist]

prontera,155,188,0	script	MVP Rank	910,{
	// get database names, for join
	query_sql    "SELECT DATABASE()", .@rag_db$;
	query_logsql "SELECT DATABASE()", .@log_db$;
	
	query_sql "SELECT `name`,COUNT(mvp_id) FROM "+.@log_db$+".mvplog " + 
	          "LEFT JOIN "+.@rag_db$+".`char` ON mvplog.kill_char_id=`char`.char_id " + 
	          "GROUP BY kill_char_id ORDER BY COUNT(mvp_id) DESC LIMIT 10", .@name$, .@kills;
	
	mes "[MVP Rank Top 10]";
	for( set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i + 1 ){
		mes "Top ^FF0000"+(.@i+1)+"^000000 "+.@name$[.@i]+" with ^FF0000"+.@kills[.@i]+"^000000 MVPs killed.";
	}
	close;
   }

Not tested yet, perhaps you can test it and report here if there is any error.

[Sasuke Uchiha]

The NPC freezing

[Elsa Mist]

Im sorry. Just notice this script using sql query...