help Translate to eAthena version !

[Yoga]

prontera,120,100,4    script    ranking    100,{

.@nb = query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 10", .@name$, .@kills, .@deaths, .@class );

if ( !.@nb ) {

mes "ladder is empty";

close;

}

mes "[ Top PvP Ranking ]";

mes "Name - Job - Killed - Death";

for ( .@i = 0; .@i < .@nb; .@i++ )

     mes "^0000FF"+ (.@i+1) +": ^228B22"+ .@name$[.@i] +" ^606060"+ jobname(.@class[.@i]) +" ^006699"+ .@kills[.@i] +" / ^C80000"+ .@deaths[.@i] +"^000000";

close;

OnPCKillEvent:

query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1, 0, "+ class +" ) on duplicate key update kills = kills +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;

attachrid killedrid;

query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 0, 1, "+ class +" ) on duplicate key update deaths = deaths +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;

}

 

 

Edited October 25, 2013 by Rainseven

[Yoga]

still got error on line 9.

 

prontera,120,100,4    script    ranking    100,{

set .@nb, query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 10", .@name$, .@kills, .@deaths, .@class );

if ( !.@nb ) {

mes "ladder is empty";

close;

}

mes "[ Top PvP Ranking ]";

mes "Name - Job - Killed - Death";

for ( .@i = 0; .@i < .@nb; .@i++ ) // ERROR LINE 9*

     mes "^0000FF"+ (.@i+1) +": ^228B22"+ .@name$[.@i] +" ^606060"+ jobname(.@class[.@i]) +" ^006699"+ .@kills[.@i] +" / ^C80000"+ .@deaths[.@i] +"^000000";

close;

OnPCKillEvent:

query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1, 0, "+ class +" ) on duplicate key update kills = kills +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;

attachrid killedrid;

query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 0, 1, "+ class +" ) on duplicate key update deaths = deaths +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;

}

for ( .@i = 0; .@i < .@nb; .@i++ ) // ERROR LINE 9*

Solved. ty  Patskie

prontera,120,100,4	script ranking	100,{
    set .@nb, query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 10", .@name$, .@kills, .@deaths, .@class );
    if ( !.@nb ) {
        mes "ladder is empty";
        close;
    }
       mes "[ Top PvP Ranking ]";
mes "Name - Job - Killed - Death";
  	for(set .@i, 0; .@i < getarraysize (.@nb); set .@i, .@i + 1){
	 mes "^0000FF"+ (.@i+1) +": ^228B22"+ .@name$[.@i] +" ^606060"+ jobname(.@class[.@i]) +" ^006699"+ .@kills[.@i] +" / ^C80000"+ .@deaths[.@i] +"^000000";
    close;
OnPCKillEvent:
    query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 1, 0, "+ class +" ) on duplicate key update kills = kills +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;
    attachrid killedrid;
    query_sql "insert into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', 0, 1, "+ class +" ) on duplicate key update deaths = deaths +1, name = '"+ escape_sql( strcharinfo(0) ) +"', class = "+ class;    
}
}

Edited October 25, 2013 by Rainseven

[Patskie]

Change :

.@nb = query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 10", .@name$, .@kills, .@deaths, .@class );

to :

set .@nb, query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 10", .@name$, .@kills, .@deaths, .@class );