You can use both events in one npc...
I have modify it for you, please give a try..
- script pvp1 -1,{
OnPCDieEvent:
getmapxy @mapdie1$,@x,@y;
if (@mapdie1$ != "coca_cola") end;
set @CID,getcharid(0);
set @name$,"";
set @points,0;
query_sql "SELECT `deaths_pvp1` FROM `rankpvp01` WHERE `char_id`="+@CID+"",@points;
query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="+@CID+"",@name$;
if ( @name$ == "" ) {
query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`deaths_pvp1`,`saldo_pvp1`) VALUES ("+@CID+",'"+strcharinfo(0)+"',1,-1)";
end;
}
query_sql "UPDATE `rankpvp01` SET `deaths_pvp1` = `deaths_pvp1` + 1, `saldo_pvp1` = `saldo_pvp1` - 1 WHERE `char_id`="+@CID;
end;
OnPCKillEvent:
getmapxy @map1$,@x,@y;
if ( @map1$ != "coca_cola" ) end;
set @CID, getcharid(0);
set @name$, "";
set @points, 0;
query_sql "SELECT `kills_pvp1` FROM `rankpvp01` WHERE `char_id`="+@CID+"", @points;
query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="+@CID+"", @name$;
if ( @name$ == "" ) {
query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`kills_pvp1`,`saldo_pvp1`) VALUES ("+@CID+",'"+strcharinfo(0)+"',1,1)";
dispbottom "Você Matou seu primeiro jogador";
end;
}
query_sql "UPDATE `rankpvp01` SET `kills_pvp1` = `kills_pvp1` + 1, `saldo_pvp1` = `saldo_pvp1` + 1 WHERE `char_id`="+@CID;
set @points, @points + 1;
announce "Você matou [ "+rid2name(killedrid)+" ] e chegou a "+@points+" jogadores mortos.",bc_self,0x90FFFF;
end;
}
-Chuck-'s post in rank pvp ratio is not counted was marked as the answer