// create table pvpladder (
// cid int(11) primary key,
// name varchar(23),
// kills int(11),
// deaths int(11),
// class int(11),
// key (kills)
// ) engine = myisam;


Welgaia,164,188,3	script	MVP Warper	768,{
    .@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;
    }
    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;
    delwaitingroom; // continue read
OnInit:
    if ( query_sql( "select name, kills, deaths, class from pvpladder order by kills desc limit 1", .@name$, .@kills, .@deaths, .@class ) )
        waitingroom .@name$ +" ("+ jobname(.@class) +") : "+ .@kills +" / "+ .@deaths, 0;
    else
        waitingroom "PVP Ladder !", 0;
    end;
}