Sasuke Uchiha Posted November 11, 2015 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 114 Reputation: 8 Joined: 09/16/14 Last Seen: November 1, 2016 Share Posted November 11, 2015 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; } Quote Link to comment Share on other sites More sharing options...
0 Sasuke Uchiha Posted November 12, 2015 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 114 Reputation: 8 Joined: 09/16/14 Last Seen: November 1, 2016 Author Share Posted November 12, 2015 (edited) anyone can help me? edit: Solved https://rathena.org/board/topic/102243-mvp-rank-menu/ Edited November 12, 2015 by Sasuke Uchiha Quote Link to comment Share on other sites More sharing options...
0 Elsa Mist Posted November 11, 2015 Group: Members Topic Count: 23 Topics Per Day: 0.01 Content Count: 387 Reputation: 60 Joined: 10/08/13 Last Seen: July 14, 2022 Share Posted November 11, 2015 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. Quote Link to comment Share on other sites More sharing options...
0 Sasuke Uchiha Posted November 11, 2015 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 114 Reputation: 8 Joined: 09/16/14 Last Seen: November 1, 2016 Author Share Posted November 11, 2015 The NPC freezing Quote Link to comment Share on other sites More sharing options...
0 Elsa Mist Posted November 11, 2015 Group: Members Topic Count: 23 Topics Per Day: 0.01 Content Count: 387 Reputation: 60 Joined: 10/08/13 Last Seen: July 14, 2022 Share Posted November 11, 2015 Im sorry. Just notice this script using sql query... Quote Link to comment Share on other sites More sharing options...
Question
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; }Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.