NPC - Insert dont work

[Cyrix]

I'm using this script to save  woe ranking. But it does not save in the database. 

 

I used this line for testing, and the NPC reads correctly.

INSERT INTO `woeplayerrank` (`char_id`,`name`,`breaks`) VALUES ('123456','test',1);

 

Please help me to find the error.

 

thanks.

 

 

Script:

 

prontera,164,165,3 script Top Emperium 413,{

setarray $woemap$[0],"prtg_cas01","arug_cas03"; //ponha aqui os castelos que estão habilitados na sua WoE

P_Ini:
// == Configurações ==
set @name$,"^FF4500[Top Emperium]^000000";
set @PG2$,"^FF4500[Top Emperium]^000000"; 
set @PG3$,"^40E0D0ServerName^000000";
set @PG4$,"RagBrasil"; 
set @PlRank,10; 
set @GdRank,10;
set @V$,strcharinfo(0);
set @CID,getcharid(0);
set @GID,getcharid(2);
mes @name$;
mes "Olá ^00BFFF"+strcharinfo(0)+"^000000.";
mes "Selecione a ^FF0000opção^000000 desejada:";
next;
menu "Woe Ranking",-,"Meu Status",charst,"Sair",EXIT;

woerank:
set @breakswoe,0;
set @charnamewoe$,"";
set @guildnamewoe$,"";
set @kills,0;
set @deaths,0;
next;
mes @PG2$;
mes "Selecione a ^FF0000opção^000000 desejada:";
next;
menu "Top "+@PlRank+" EmpBreak",B10,"Top "+@GdRank+" Guild",BT100,"Sair",EXIT;

B10:
query_sql "SELECT `breaks`,`name`,`kills`,`deaths` FROM `woeplayerrank` ORDER BY `breaks` DESC, `kills` DESC LIMIT "+@PlRank+"",@breakswoe,@charnamewoe$,@kills,@deaths;
next;
mes "[^FF4500Top "+@PlRank+" EmpBreak^000000]";
for(set @i,0; @i<=@PlRank; set @i,@i+1){ if(@charnamewoe$[@i]==""){ mes @i+1 +": ---"; }else{ mes "^0000FF"+ (@i+1) +"^000000º: "+@charnamewoe$[@i]+" quebrou ^FF0000"+@breakswoe[@i]+"^000000 ^0000FFx^000000, ^FF0000"+@kills[@i]+"^000000 ^0000FFMatou^000000 e ^FF0000"+@deaths[@i]+"^000000 ^0000FFMortes^000000."; }}
mes "^525252_____________^000000";
mes "^525252TOP "+@PlRank+" Breakers^000000 "+@PG3$+".";
next;
goto P_Ini;

BT100:
query_sql "SELECT `breaks`,`gname`,`kills`,`deaths` FROM `woerank` ORDER BY `breaks` DESC, `kills` DESC LIMIT "+@GdRank+"",@breakswoe,@guildnamewoe$,@kills,@deaths;
next;
mes "[^FF0000TOP "+@GdRank+" Clãs^000000]";
for(set @i,0; @i<=@GdRank; set @i,@i+1){ if(@guildnamewoe$[@i]==""){ mes @i+1 +": ---"; }else{ mes "Posição: ^0000FF"+ (@i+1) +"^000000º: "+@guildnamewoe$[@i]+" com ^FF0000"+@breakswoe[@i]+"^000000 ^0000FFvezes^000000, ^FF0000"+@kills[@i]+"^000000 ^0000FFMatou^000000 e ^FF0000"+@deaths[@i]+"^000000 ^0000FFMortes^000000."; }}
mes "^525252_____________^000000";
mes "^525252TOP "+@GdRank+" Clãs^000000 "+@PG3$+".";
next;
goto P_Ini;

EXIT:
mes @name$;
mes "Bom jogo.";
close;
//===============================
charst:
query_sql "SELECT `breaks`,`kills`,`deaths` FROM `woeplayerrank` WHERE `char_id`="+@CID+"",@woepoints,@killswoe,@deathswoe;
query_sql "SELECT `breaks`,`kills`,`deaths` FROM `woerank` WHERE `guild_id`="+@GID+"",@woeguild,@gkillswoe,@gdeathswoe;
next;
mes @name$;
mes "^0000FF[ O jogador "+strcharinfo(0)+"]^000000";
mes "^525252Clã:^000000 ^FF0000"+strcharinfo(2)+"^000000.";
mes "^525252Quebrou a emperium^000000 ^FF0000"+@woepoints+"^000000 x";
mes "^525252O clã quebrou a emperium^000000 ^FF0000"+@woeguild+"^000000 x";
mes "^525252Você matou^000000 ^FF0000"+@killswoe+"^000000 Players.";
mes "^525252Você morreu^000000 ^FF0000"+@deathswoe+"^000000 x";
mes "^525252O clã matou^000000 ^FF0000"+@gkillswoe+"^000000 Players.";
mes "^525252O clã morreu^000000 ^FF0000"+@gdeathswoe+"^000000 x";
next;
goto P_Ini;

//===============================
}

function script WoE_Rank {

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

- script WoePlayerLadder -1,{
OnPCKillEvent:
getmapxy @map$,@x,@y,0;
for(set @i,0; @i<=getarraysize($woemap$); set @i,@i+1){ if(@map$==$woemap$[@i] && agitcheck()){ //comparando se o mapa encontrado é um castelo da WoE, mas só se a WoE estiver ativada

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

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

[HD Scripts]

try this

 

INSERT INTO `woeplayerrank` (`char_id`,`name`,`breaks`) VALUES ('123456','test','1');

[Cyrix]

try this

 

 

INSERT INTO `woeplayerrank` (`char_id`,`name`,`breaks`) VALUES ('123456','test','1');

 

@Hurican Essa linha que eu mostrei acima, importei usando phpmyadm só para ver se o NPC iria ler. A função de leitura tá certinho o problema é que não salva... quando alguém quebra ou quando é morto dentro do castelo.

-----------------------------------------------------------------------------------------------------------

 

this line is only for test, and works fine... i import using phpmyadm.

INSERT INTO `woeplayerrank` (`char_id`,`name`,`breaks`) VALUES ('123456','test',1);

 

i need help w/ script

 

thx   

Edited February 20, 2013 by Cyrix