PvP Frags Count

[gabrielks]

hi guys, i'm lost here because my pvp system is not counting the frags and it doesn't show in rank either. 
Could someone please help me?

Sorry for my bad english

Spoiler

/=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
// Npc criado por marcio93
//=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
// Nome do Npc PvP sem ygg
//=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
// Versão atual 1.2
//=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
// Npc criado em 13/10/2010
//=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
// Compatível com Cronus e Eathena
//=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+

prontera,150,150,3	script	PvP sem Ygg	56,{

Mes "[PvP Sem YGG]";
mes "Olá gostaria de entrar em qual Arena sem YGG?";
menu "PvP",pvp,"GvG",gvg,"Ranking",rank,"Nenhuma obrigado",-;

mes "[PvP sem YGG]";
mes "volte quando quiser";
close;

pvp:
if(countitem(610)>= 1) goto temitem;
if(countitem(607)>= 1) goto temitem;
mes "Boa sorte na Arena!!";
next;
warp "pvp_y_2-2",0,0;
mapannounce "pvp_y_2-2","O jogador "+strcharinfo(0)+" entrou na Arena sem Ygg", bc_yellow;
end;

gvg:
if(getcharid(2) == 0) goto semg;
if(countitem(610)>= 1) goto temitem;
if(countitem(607)>= 1) goto temitem;
mes "Boa sorte na Arena!!";
next;
warp "guild_vs2",0,0;
mapannounce "guild_vs2","O jogador "+strcharinfo(0)+" entrou na Arena sem Ygg", bc_yellow;
end;

			temitem:
				mes "[PvP sem YGG]";
   	  			mes "Você não pode entrar com os seguintes itens:";
			mes "getitemname(607)";
			mes "getitemname(610)";
			mes "Retire-os do seu inventario e tente novamente";
			close;

			semg:
 					 mes "[PvP sem YGG]";
	 			 mes "Você Não possui clã, somente quem tem clã pode entrar nesta sala";
 				 close;

rank:
 				  	mes "[PvP sem YGG]";
			  	mes "Olá "+strcharinfo(0)+" gostaria de ver qual ranking?";
			  	menu  "PvP sem YGG",pv,"GvG sem YGG",gv,"Nenhum, Obrigado",-;

			  	mes "Ok, Quando precisar so vir falar comigo";
			  	close;
		pv:
		   	  	mes @nome$;
		mes "Ok, este o nosso Ranking de PvP [TOP 10]";
		next;
		query_sql "SELECT name, kills, deaths FROM pvp ORDER BY kills DESC LIMIT 10",@name$,@kills,@deaths;
		dispbottom "Ranking PvP [TOP 10]";
		dispbottom " ";
		dispbottom "Posição <~> Nome <~> Matou <~> Morreu";
		dispbottom " ";
		for(set @i,0;@i<=9;set @i,@i+1) {
			dispbottom "["+(@i+1)+"] <~> "+@name$[@i]+" <~> "+@kills[@i]+" <~> "+@deaths[@i]+"";
		}
		close;

		gv:
		  	mes @nome$;
		mes "Ok, este 0 nosso Ranking de GvG [TOP 10]";
		next;
		query_sql "SELECT name, kills, deaths FROM gvg ORDER BY kills DESC LIMIT 10",@guild_name$,@guild_kills,@guild_deaths;
		dispbottom "Ranking GvG [TOP 10]";
		dispbottom " ";
		dispbottom "Posição <~> Nome da Guild <~> Vitórias <~> Derrotas";
		dispbottom " ";
		for(set @i,0;@i<=9;set @i,@i+1) {
		dispbottom "["+(@i+1)+"] <~> "+@guild_name$[@i]+" <~> "+@guild_kills[@i]+" <~> "+@guild_deaths[@i]+"";
		}
		close;



}
//================= parte dos ranking's==============
-	script	rankingygg	-1,{

OnPCKillevent:
	   	GetMapxy(.@mapa$,.@x,.@y,0);
	if(.@mapa$ == "guild_vs2") nowarp;
	if(.@mapa$ == "pvp_y_2-2") nowarp;

pvp:
	set @CID,getcharid(0);set @name$,"";set @points,0;
					query_sql "SELECT `kills` FROM `pvp` WHERE `char_id`="+@CID+"",@points;
					query_sql "SELECT `name` FROM `pvp` WHERE `char_id`="+@CID+"",@name$;
			if ( @name$ == "" ) { query_sql "INSERT INTO `pvp`  (`char_id`,`name`,`kills`) VALUES  ("+@CID+",'"+strcharinfo(0)+"',1)",@esc$; dispbottom "Você Matou seu  primeiro jogador"; end; }
					query_sql "UPDATE `pvp` SET `kills` = `kills` +1 WHERE `char_id`="+@CID+"",@esc$;
		set @points,@points+1;
		dispbottom "[PvP]: Você tem "+@points+" Pontos no PVP sem YGG.";
						end;

gvg:

		set @GID,getcharid(2);set @name$,"";set @points,0;
					query_sql "SELECT `kills` FROM `gvg` WHERE `guild_id`="+@GID+"",@gpoints;
					query_sql "SELECT `name` FROM `gvg` WHERE `guild_id`="+@GID+"",@name$;
			if ( @name$ == "" ) { query_sql "INSERT INTO `gvg`  (`guild_id`,`name`,`kills`) VALUES  ("+@GID+",'"+strcharinfo(2)+"',1)",@esc$; dispbottom "Primeiro Frag da  Guild"; end; }
					query_sql "UPDATE `gvg` SET `kills` = `kills` + 1 WHERE `guild_id`="+@GID+"",@esc$;
		set @gpoints,@gpoints+1;
		mapannounce	@map$,"A Guild [ "+@name$+" ] empilhou "+@gpoints+" caveiras.",bc_self,0x90FFFF;
						end;
//==========
OnPCDieEvent:

	 	getmapxy @map$,@x,@y,0;
			if(.@mapa$ == "guild_vs2") nowarp;
			if(.@mapa$ == "pvp_y_2-2") nowarp;

pvp1:
		set @CID,getcharid(0);set @name$,"";set @points,0;
					query_sql "SELECT `deaths` FROM `pvp` WHERE `char_id`="+@CID+"",@points;
					query_sql "SELECT `name` FROM `pvp` WHERE `char_id`="+@CID+"",@name$;
			if ( @name$ == "" ) { query_sql "INSERT INTO `pvp`  (`char_id`,`name`,`deaths`) VALUES  ("+@CID+",'"+strcharinfo(0)+"',1)",@esc$; end; }
					query_sql "UPDATE `pvp1` SET `deaths` = `deaths` + 1 WHERE `char_id`="+@CID+"",@esc$;
						end;

gvg1:
		set @GID,getcharid(2);set @name$,"";set @gpoints,0;
					query_sql "SELECT `deaths` FROM `gvg` WHERE `guild_id`="+@GID+"",@gpoints;
					query_sql "SELECT `name` FROM `gvg` WHERE `guild_id`="+@GID+"",@name$;
			if ( @name$ == "" ) { query_sql "INSERT INTO`gvg`  (`guild_id`,`name`,`deaths`) VALUES  ("+@GID+",'"+strcharinfo(2)+"',1)",@esc$; end; }
					query_sql "UPDATE `gvg1` SET `deaths` = `deaths` + 1 WHERE `guild_id`="+@GID+"",@esc$;
						end;
} 

Thanks

Edited December 31, 2019 by gabrielks

[Moooooon-Aisha]

Check your console when you make kills. Post any errors here.

[gabrielks]

 

don't have any errors

[Mabuhay]

Check your sql queries. It seems like you have 4 sql tables. pvp and pvp1 then gvg and gvg1. 

[gabrielks]

 

I already have all the querys and does not show error none = /