[RESOLVIDO] O nome do jogador na tabela do ranking pvp some quando o personagem não está online

[Tdi123]

Exemplo 1 (Personagem Online):

Exemplo 2 (Personagem Offline):

ERROR no Emulador:

Tabela SQL: 

Quote

DROP TABLE IF EXISTS `pvp_ladder`;
CREATE TABLE IF NOT EXISTS `pvp_ladder` (
  `char_id` int(11) UNSIGNED NOT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`char_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

SCRIPT: 

Quote

set .rankpoint, 1; //Ranking PvP? (0:Disable)

if(.rankpoint < 0){ set .rankpoint, 0; }

if(.rankpoint){ query_sql("INSERT INTO `pvp_ladder` SET `char_id` = '"+getcharid(0)+"', `count` = '1' ON DUPLICATE KEY UPDATE `count` = `count`+1"); }

//Player Ranking
        mes "^FF7F00[ Arena PvP ]^000000";
        if(!([email protected] = query_sql("SELECT `char_id`, `count` FROM `pvp_ladder` ORDER BY `count` DESC LIMIT 10", [email protected], [email protected]))) {
        mes "Nenhuma morte foi contabilizada ainda.";
        close;
        }
        mes "Top 10 PvP:";
        for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ )
        mes ([email protected]+1) +". "+ strcharinfo(0,[email protected][[email protected]]) +": ^008aff"+ [email protected][[email protected]] +"^000000";
        close;

Agradeço a ajuda desde já!

EDIT 1 SOLUÇÃO:

SQL: 

Quote

ALTER TABLE `char` ADD `pvp_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0'  AFTER `fame`;

SCRIPT: 

Quote

//Player Ranking
mes "^FF7F00[ Arena PvP ]^000000";
mes "TOP 10 PvP:";
query_sql( "SELECT `name`,`pvp_kill` FROM `char` WHERE `pvp_kill` > 0 ORDER BY `pvp_kill` DESC LIMIT 10", [email protected]$, [email protected]_kill );
[email protected] = getarraysize( [email protected]$ );
for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) {
mes "^ff0000"+([email protected] + 1 )+"°^000000 "[email protected]$[[email protected]]+" - ^008aff"[email protected]_kill[[email protected]]+" kill(s)^000000";
}
close;

RESET: 

Quote

query_sql("UPDATE `char` SET `pvp_kill` = 0 WHERE `pvp_kill` > 0");

CONTADOR:

Quote

OnPCKillEvent:
if ( getcharid(3) != killedrid ) {
    query_sql( "UPDATE `char` SET `pvp_kill` = `pvp_kill` + 1 WHERE `char_id` = "+getcharid(0)+" LIMIT 1" );
}
end;

BOM PROVEITO!

Edited January 19, 2021 by Tdi123