Hellogood evening,someonecouldpleasehelp mewith thisscript?I can notupgradeit to usethe newrathena...I am gettingthe followingalerts inmap_server:
[SQL]: DB error - You have an error in your SQL syntax; check the manual that co
rresponds to your MySQL server version for the right syntax to use near '' at li
ne 1
[Debug]: at ..\src\map\script.c:16961 - SELECT name FROM `char` WHERE char_id =
0 OR char_id = 0 OR char_id = 0 OR char_id = 0 OR char_id = 0 OR
[Debug]: Source (NPC): BG Ranker at new_1-1 (51,109)
script:
new_1-1,51,109,5 script BG Ranker 55,{
mes .name$;
mes "I can give you the Battlegrounds Raking Information.";
mes "Choose what do you want to know.";
next;
set .@selection, select( implode( .menu$, ":" ) ) - 1;
query_sql "SELECT char_id, "+ .tables$[.@selection] +" FROM char_bg ORDER BY "+ .tables$[.@selection] +" DESC LIMIT "+ .maxsize , @char_id, @bgtop;
for ( .@a = 0; .@a < .maxsize; .@a++ )
set .@fetch_name$, .@fetch_name$ + "char_id = "+ @char_id[.@a]+ " OR ";
query_sql "SELECT name FROM `char` WHERE "+ .@fetch_name$, @char_name;
mes .name$;
mes .menu$[.@selection];
for ( .@a = 0; .@a < .maxsize; .@a++ )
mes "["+ (.@a+1) +"] "+ ( (@char_name) ? @char_name : "^FF0000None^000000" );
close;
OnInit:
set .name$, "[^0000FFBattlegrounds Ranker^000000]";
setarray .menu$[0], "Top Game Win",
"Top Game Tie",
"Top Game Lost",
"Top Leader Game Win",
"Top Leader Game Tie",
"Top Leader Game Lost";
setarray .tables$[0], "win",
"tie",
"lost",
"leader_win",
"leader_tie",
"leader_lost";
set .maxsize, 5; //Amount of player that will appear
end;
}
Question
Kakaroto
Hello good evening, someone could please help me with this script? I can not upgrade it to use the new rathena ... I am getting the following alerts in map_server:
script:
Thank you in advance anyone who can help me.
Link to comment
Share on other sites
9 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.