[QUEST]Metin2 Mysql_Query Duplicate

[Keselth 0]

Hi guys! So I'm trying to create a pvp system with quests, but everytime a player kills another if gives 2 points instead of 1! Anyone can help me with this?

quest kryzek_pvp begin 
    state start begin 
        when kill begin  
            if npc.is_pc() then 
pc.give_exp2(21000000) 
mysql_query("UPDATE player.player SET prestige=prestige+1 WHERE name='"..pc.get_name().."' LIMIT 1") 
            end 
        end 
    end 
end

[ekoo 8]

 

Hi guys! So I'm trying to create a pvp system with quests, but everytime a player kills another if gives 2 points instead of 1! Anyone can help me with this?

quest kryzek_pvp begin 
    state start begin 
        when kill begin  
            if npc.is_pc() then 
pc.give_exp2(21000000) 
mysql_query("UPDATE player.player SET prestige=prestige+1 WHERE name='"..pc.get_name().."' LIMIT 1") 
            end 
        end 
    end 
end

 

 

quest kryzek_pvp begin 
    state start begin 
    	when kill with npc.is_pc() begin
			pc.give_exp2(21000000) 
			mysql_query("UPDATE player.player SET `prestige`=prestige+1 WHERE `name`='"..pc.get_name().."' LIMIT 1") 
		end 
	end 
end

[Keselth 0]

Did work! Now it dont update!

[ekoo 8]

follow this

 

http://metin2dev.org/board/topic/344-kills-are-counted-twice/#entry2665

 

#4

 

and

quest kryzek_pvp begin
    state start begin
        when kill with npc.is_pc() begin
            pc.give_exp2(21000000)
            mysql_query("UPDATE player.player SET prestige=prestige+1 WHERE name='"..pc.get_name().."' LIMIT 1")
        end
    end
end

[Keselth 0]

I don't have acess to the game source.. I'm using 34083 Game