Had to do some form of these classes were only for ranking first time? I tried doing the following, the sql command would check in ranking_race_level `table` table `class` class now had there in the rankings simply ignore it. But it gave error, someone could correct my sql command?
NPC:
L_RANK_CLASS:
if(BaseLevel == $BaseMax && JobLevel == $JobMax){
if( Class == Job_Super_Novice && .end_ev_sn == 0){
set $win_sn$,strcharinfo(0);
set Zeny,Zeny + $premio_Z;
getitem 18779,1;
query_sql"INSERT INTO `ranking_race_level` (`name`,`class`,`date`,`parents`) VALUES ('"+strcharinfo(0)+"','Super Novice','"+@time$+"','0')";
announce "O Jogador "+ $win_sn$ +" foi o primeiro Super Aprendiz a atingir o Nível MÁXIMO !!",8;
query_sql("select `class` from `ranking_race_level` ORDER BY fame DESC LIMIT 1", `class`);
sleep 2000;
announce "Ele foi recompensado com um Panda Ears[1] e uma quantia considerável de Zenys !!",8;
sleep 2000;
announce "Ele é um exemplo para os Aprendizes de toda Rune-Midgard !!",8;
set .end_ev_sn,1;
end;
}
if( Class == Job_Super_Novice && .end_ev_sn < 10){
query_sql"INSERT INTO `ranking_race_level` (`name`,`class`,`date`,`parents`) VALUES ('"+strcharinfo(0)+"','Super Novice','"+@time$+"','2')";
set .end_ev_sn,.end_ev_sn+1;
end;
}
Command SQL:
query_sql("select `class` from `ranking_race_level` ORDER BY fame DESC LIMIT 1", `class`);
Error:
I hope you can help me, thanks