Erro script WOE RANKING

[stiflerxx]

Hello am using a rank woe however she is not working could someone get me a ranking or woe corrigirir this low? 

 

note: The rank is not the rank and GVG as each players killed and died.

 

//////////////////////////////////////////
// \/== \| |/ //==\\ \\==// \===/ //
// // || || || || |/ \| // \\ //
// || ||--|| ||--|| || || \\___ //
// || ||--|| ||--|| || || \\ //
// \\ || || || || || || // //
// /\== /| |\ /| |\ \\==// ====// //
//////////////////////////////////////////
//Npc: Chaos Rankings - WoE///////////////
//////////////////////////////////////////
//Description: Mostra os Rankings WoE //
//////////////////////////////////////////
//Changelog: //////////
// V1.1 - Script Original por algoz ONE //
// v2.0 - Script Reformulado para //
// diversos rankings //
// v3.0 - Script Otimizado //
//////////////////////////////////////////
prontera,151,166,4 script Rankings 450,{

// == Configurações ==
setarray @Names$[0],"^FF4500[Rank Guerra do Emperium]^000000","^40E0D0PortalRaG^000000"; //= Nome do NPC seguido do nome do Servidor.
set @PlRank,10; //= Quantos Players aparecerão nos rankings?
set @GdRank,10; //= Quantos Clãs aparecerão nos rankings
// ===================
set @CID,getcharid(0);
set @GID,getcharid(2);
while(true)
{
mes @Names$[0];
mes "Olá ^00BFFF"+strcharinfo(0)+"^000000.";
mes "Selecione a ^FF0000opção^000000 desejada:";
deletearray @breaks[0],getarraysize(@breaks);
deletearray @name$[0],getarraysize(@name$);
deletearray @kills[0],getarraysize(@kills);
deletearray @deaths[0],getarraysize(@deaths);
next;
set @Rank,select("- TOP "+@PlRank+" Breakers","- TOP "+@GdRank+" Clãs","- Meu Status","- Sair") - 1;
if(@Rank == 4)
{
mes @Names$[0];
mes "Bom jogo.";
close;
}
else if(@Rank == 3)
{
query_sql "SELECT `breaks`,`kills`,`deaths` FROM `woeplayerrank` WHERE `char_id`="+@CID,@points,@kills,@deaths;
query_sql "SELECT `breaks`,`kills`,`deaths` FROM `woerank` WHERE `guild_id`="+@GID,@guild,@gkills,@gdeaths;
mes @name$;
mes "^0000FF[Jogador "+strcharinfo(0)+"]^000000";
mes "^525252Clã atual:^000000 ^FF0000"+strcharinfo(2)+"^000000.";
mes "^525252Quebrou o Emperium..^000000 ^FF0000"+@points+"^000000 vezes.";
mes "^525252Clã quebrou o Emperium..^000000 ^FF0000"+@guild+"^000000 vezes.";
mes "^525252Matou no Total..^000000 ^FF0000"+@kills+"^000000 Players.";
mes "^525252Morreu no Total..^000000 ^FF0000"+@deaths+"^000000 Vezes.";
mes "^525252Amigos do Clã Mataram no Total..^000000 ^FF0000"+@gkills+"^000000 Players.";
mes "^525252Amigos do Clã Morreram no Total..^000000 ^FF0000"+@gdeaths+"^000000 Vezes.";
next;
}
else
{
query_sql "SELECT `breaks`,`"+(@from? "g" : "")+"name`,`kills`,`deaths` FROM `woe"+(!@from? "player" : "")+"rank` ORDER BY `breaks` DESC, `kills` DESC LIMIT "+(@from? @GdRank : @PlRank),@breaks,@name$,@kills,@deaths;
mes "[^FF4500TOP "+(@from? @GdRank+" Clãs" : @PlRank+" Breakers")+" - WoE^000000]";
for(set @i,0; @i<=(@from? @GdRank : @PlRank); set @i,@i+1)
if(@name$[@i]=="")
mes (@i+1)+": ---";
else
mes "Posição: ^0000FF"+ (@i+1) +"^000000º: "+@name$[@i]+" com ^FF0000"+@breaks[@i]+"^000000 ^0000FFbreaks^000000, ^FF0000"+@kills[@i]+"^000000 ^0000FFKills^000000 e ^FF0000"+@deaths[@i]+"^000000 ^0000FFDeaths^000000.";
mes "^525252_____________^000000";
mes "^525252TOP "+(@from? @GdRank+" Clãs" : @PlRank+" Breakers")+" - WoE^000000 "+@Names$[1]+".";
next;
}
}
}

function script WoE_Rank {

query_sql "SELECT `breaks`,`name` FROM `woeplayerrank` WHERE `char_id`="+getcharid(0),@bpoints,@name$;
query_sql "SELECT `gname`,`breaks` FROM `woerank` WHERE `guild_id`="+getcharid(2),@gname$,@gbpoints;
if( @name$ == "" )
query_sql "INSERT INTO `woeplayerrank` (`char_id`,`name`,`breaks`) VALUES ("+getcharid(0)+",'"+strcharinfo(0)+"',0)";
if ( @gname$ == "" )
query_sql "INSERT INTO `woerank` (`guild_id`,`gname`,`breaks`) VALUES ("+getcharid(2)+",'"+getguildname(getcharid(2))+"',0)";
query_sql "UPDATE `woeplayerrank` set `breaks` = `breaks` +1 WHERE `char_id`="+getcharid(0);
query_sql "UPDATE `woerank` set `breaks` = `breaks` +1 WHERE `guild_id`="+getcharid(2);
return;
}

- script WoePlayerLadder -1,{
OnPCKillEvent:
if(!agitcheck() && !agitcheck2())
end;
getmapxy @map$,@x,@y,0;
set @Found,0;
if($UsingWoEController)
for(set @i,0; @i<3; set @i,@i+1)
for(set @j,0; @j < getarraysize(getd("$DiasWoE_"+@i)); set @j,@j + 1)
for(set @k,0; @k if(@map$==getd("$CastelosWoE_"+@i+"_"+@j+"$["+@k+"]"))
{
set @Found,1;
break;
}
else
for(set @i,0; @i < getarraysize($woemap$); set @i,@i+1)
if(@map$==$woemap$[@i])
{
set @Found,1;
break;
}
if(!@Found)
end;

query_sql "SELECT `kills`,`name` FROM `woeplayerrank` WHERE `char_id`="+getcharid(0),@ppoints,@name$;
query_sql "SELECT `kills`,`gname` FROM `woerank` WHERE `guild_id`="+getcharid(2),@gpoints,@gname$;
if( @name$ == "" )
query_sql "INSERT INTO `woeplayerrank` (`char_id`,`name`,`kills`) VALUES ("+getcharid(0)+",'"+strcharinfo(0)+"',0)";
if( @gname$ == "" )
query_sql "INSERT INTO `woerank` (`guild_id`,`gname`,`kills`) VALUES ("+getcharid(2)+",'"+getguildname(getcharid(2))+"',0)";
query_sql "UPDATE `woeplayerrank` set `kills` = `kills` +1 WHERE `char_id`="+getcharid(0);
query_sql "UPDATE `woerank` set `kills` = `kills` +1 WHERE `guild_id`="+getcharid(2);

attachrid killedrid;
query_sql "SELECT `deaths`,`name` FROM `woeplayerrank` WHERE `char_id`="+getcharid(0),@ppoints,@name$;
query_sql "SELECT `deaths`,`gname` FROM `woerank` WHERE `guild_id`="+getcharid(2),@gpoints,@gname$;
if( @name$ == "" )
query_sql "INSERT INTO `woeplayerrank` (`char_id`,`name`,`deaths`) VALUES ("+getcharid(0)+",'"+strcharinfo(0)+"',0)";
if( @gname$ == "" )
query_sql "INSERT INTO `woerank` (`guild_id`,`gname`,`deaths`) VALUES ("+getcharid(2)+",'"+getguildname(getcharid(2))+"',0)";
query_sql "UPDATE `woeplayerrank` set `deaths` = `deaths` + 1 WHERE `char_id`="+getcharid(0);
query_sql "UPDATE `woerank` set `deaths` = `deaths` + 1 WHERE `guild_id`="+getcharid(2);
end;

OnInit:
set $UsingWoEController,0; // Coloque 1 caso utilize o WoE Controller de minha autoria.
if(!$UsingWoEController) // Ponha aqui os castelos que estão habilitados na sua WoE caso não use o WoE Controller
setarray $woemap$[0],"prtg_cas03","payg_cas03","gefg_cas04","aldeg_cas01","schg_cas01","schg_cas02","schg_cas05","arug_cas01";
end;
}

(getd("$casteloswoe_"+@i+"_"+@j+"$"));>

[Jasc]

Do you have a console debug of the error?

[stiflerxx]

Do you have a console debug of the error?

Nothing he just not of the points I kill several players and my points do not go upa table ....

[Jasc]

To clarify, you have the SQL tables in your database? Tables should be woerank and woeplayerrank

[stiflerxx]

 

To clarify, you have the SQL tables in your database? Tables should be woerank and woeplayerrank

Yes i have

 

Edited July 7, 2014 by stiflerxx