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