Wery Oliveira 170 Posted September 7, 2015 bom gostaria de ajuda de vocês com uma quest para sistema de pontos que achei na epvp e já está instalada mas não sei oq fazer para ela funcionar bem, deixo ela aqui em baixo para analise --[[ -- Naturalion Point System -- Quest Writer By : HaveBeen™]]--quest naturalion begin state start begin function kill() -- Get Vid local vid = npc.get_vid() local a = pc.select(vid) local name,point = pc.get_name(),game.get_event_flag(pc.get_name().."_point") pc.select(a) if(point > 5) then game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+math.floor(point/2)) mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ") local b = pc.select(vid) game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-math.floor(game.get_event_flag(pc.get_name().."_point")/2)) mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ") pc.select(b) chat(name.." Got Half The Score ") chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point")) elseif(point >= 1 and point <= 3 or point < 0) then game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+1) mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ") local c = pc.select(vid) game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-1) mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ") pc.select(c) chat(name.." Get Points ") chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point")) end end function Rank() say_title("Naturalion Point System Rank: ") say("") --- local query = mysql_query("SELECT * FROM player.naturalion ORDER BY naturalionpoint desc limit 10") maxs = table.getn(query) i = 0 repeat i = i + 1 say(i..". "..query.name[i].." "..query.naturalionpoint[i]) until i == maxs end when login with game.get_event_flag(pc.get_name().."_point") == 0 and pc.getqf("naturalion") != 1 begin pc.setqf("naturalion",1) game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+2) mysql_query("INSERT INTO player.naturalion VALUES ('"..pc.get_player_id().."','"..pc.get_name().."','"..game.get_event_flag(pc.get_name().."_point").."' ) ") end when kill with npc.is_pc() begin naturalion.kill() end endend Bom a parte de criar uma tabela no navicat creio eu que ficou certa mas deixo aqui o codigo q estava lá. aki na tabela aparece o nome do player o id da conta mas os pontos nao saem de 0. creio que nao está definido quais boss matar ou algo do tipo. quem puder ajudar fico muito agradeçido /* Navicat MySQL Data TransferSource Server : HaveBeen™Source Server Version : 50095Source Host : ---Source Database : playerTarget Server Type : MYSQLTarget Server Version : 50095File Encoding : 65001Date: 2013-03-10 11:02:58*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `naturalion`-- ----------------------------DROP TABLE IF EXISTS `naturalion`;CREATE TABLE `naturalion` ( `id` int(50) NOT NULL, `name` varchar(24) NOT NULL, `naturalionpoint` int(40) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Records of naturalion-- ---------------------------- Share this post Link to post Share on other sites