.HuRRiKaNe

Tenta esse: function onSay(cid, words, param, channel) local tid = cid if(param ~= '') then tid = getPlayerByNameWildcard(param) if(not tid or (isPlayerGhost(tid) and getPlayerGhostAccess(tid) > getPlayerGhostAccess(cid))) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. param .. " not found.") return true end end local pos = getPlayerTown(tid) local tmp = getTownName(pos) if(not tmp) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Home town does not exists.") return true end pos = getTownTemplePosition(pos) if(not pos or isInArray({pos.x, pos.y}, 0)) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Wrong temple position for town " .. tmp .. ".") return true end pos = getClosestFreeTile(tid, pos) if(not pos or isInArray({pos.x, pos.y}, 0)) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Destination not reachable.") return true end tmp = getCreaturePosition(tid) if(doTeleportThing(tid, pos, true) and not isPlayerGhost(tid)) then doSendMagicEffect(tmp, CONST_ME_POFF) doSendMagicEffect(pos, CONST_ME_TELEPORT) end return true end

Por enquanto só macro recorder e candybot!

Espero que ajude: http://www.tibiaking.com/forum/topic/12858-como-fazer-area-pvp/ http://www.tibiaking.com/forum/topic/52235-como-criar-uma-quest-pelo-rmes-video-tutorial/ http://www.tibiaking.com/forum/topic/13388-como-criar-quest/ http://www.tibiaking.com/forum/topic/19857-tutorial-iniciantes-em-rme-map-editor/ http://www.tibiaking.com/forum/topic/14684-criando-uma-zona-pvp/

Informações: Mapa próprio 100% Items vip Teleports Pet System Trainers Houses E mais! Vídeo: https://youtu.be/QLUMbnPpAno Download: http://www.mediafire.com/download/42r3zbijvi521d3/Inovation+BYSEIDLER.rar Scan: https://www.virustotal.com/pt/file/d5059e497377b9e2213368348d8b8e108115f1489fd4f3dd56335634c26c4580/analysis/1439394825/ Créditos: Seidler Kaiser Cipsoft

Informações: Baiak editado by Daesung Teleports Vip System Quests Castle Zombie Event Trainers E mais! Imagens: Download: http://www.4shared.com/postDownload/n_7SnfFcce/Baiak_Edited_By_Daesung.html Scan: https://www.virustotal.com/pt/file/49c523df512d41ccbb5159b64415dd8aa53ff85ba8871bf5e70500fbc4025cfe/analysis/1439395345/ Créditos: Daesung Kamek

Os únicos disponíveis para download aqui no fórum são esses: http://www.tibiaking.com/forum/topic/60995-860-dbo-omniverse-site-server-client/ http://www.tibiaking.com/forum/topic/60737-860-dbrelated-12-site-data-sources/

Obrigado por aprovar, espero que ajude os membros da comunidade.

Mesma coisa zipter, se o player relogar ele consegue falar novamente.

Já aconteceu com meu servidor 3x, não achei nada pra parar com isso, resolvi deixar por account manager, depois nunca tive mais problemas. Mais acho que se voce hospedar o site em uma hospedagem fora da máquina, não vão conseguir mais fazer isso.

Zipter coloquei e registrei no login.lua mais não funcionou não, também adicionei a linha do storage na talkaction

Já tentei colocar um mute check por storage e não funcionou

Algum erro no console?

tfs 0.4 funciona normalmente.

DROP TABLE IF EXISTS guild_wars; CREATE TABLE guild_wars ( id INTEGER NOT NULL, guild_id INT NOT NULL, enemy_id INT NOT NULL, begin BIGINT NOT NULL DEFAULT '0', end BIGINT NOT NULL DEFAULT '0', frags INT NOT NULL DEFAULT '0', payment BIGINT NOT NULL DEFAULT '0', guild_kills INT NOT NULL DEFAULT '0', enemy_kills INT NOT NULL DEFAULT '0', status TINYINT( 1 ) NOT NULL DEFAULT '0', PRIMARY KEY ( id ), FOREIGN KEY ( guild_id ) REFERENCES guilds ( id ), FOREIGN KEY ( enemy_id ) REFERENCES guilds ( id ) );

Sim cole o primeiro codigo e de f9, depois o segundo e de f9! Feche abra o servidor e veja se funcionou.

Summer o que voce fez pra quando o player relogar não sair o mute?

Cara, tentei mandar pm pra vc, mas vc nn pode mais receber... preciso de ajuda.. http://www.tibiaking.com/forum/topic/61107-pedido-tfs-04-sem-salt/ POR FAVOR ME AJUDAAA Cara se ninguém compilar pra você até hora que eu chegar em casa eu compilo sem salt.

Abre o sqlite editor e faça como na imagem, coloque os códigos e aperte F9 pra executar na sua database: Códigos: DROP TABLE IF EXISTS players; CREATE TABLE players ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR( 255 ) NOT NULL, world_id INTEGER NOT NULL DEFAULT '0', group_id INTEGER NOT NULL DEFAULT '1', account_id INTEGER NOT NULL, level INTEGER NOT NULL DEFAULT '1', vocation INTEGER NOT NULL DEFAULT '0', health INTEGER NOT NULL DEFAULT '100', healthmax INTEGER NOT NULL DEFAULT '100', experience INTEGER NOT NULL DEFAULT '0', lookbody INTEGER NOT NULL DEFAULT '10', lookfeet INTEGER NOT NULL DEFAULT '10', lookhead INTEGER NOT NULL DEFAULT '10', looklegs INTEGER NOT NULL DEFAULT '10', looktype INTEGER NOT NULL DEFAULT '136', lookaddons INTEGER NOT NULL DEFAULT '0', lookmount INTEGER NOT NULL DEFAULT '0', maglevel INTEGER NOT NULL DEFAULT '0', mana INTEGER NOT NULL DEFAULT '100', manamax INTEGER NOT NULL DEFAULT '100', manaspent INTEGER NOT NULL DEFAULT '0', soul INTEGER NOT NULL DEFAULT '0', town_id INTEGER NOT NULL, posx INTEGER NOT NULL DEFAULT '32369', posy INTEGER NOT NULL DEFAULT '32241', posz INTEGER NOT NULL DEFAULT '7', conditions BLOB NOT NULL, cap INTEGER NOT NULL DEFAULT '0', sex INTEGER NOT NULL DEFAULT '0', lastlogin INTEGER NOT NULL DEFAULT '0', lastip INTEGER NOT NULL DEFAULT '0', save BOOLEAN NOT NULL DEFAULT 'TRUE', skull INTEGER NOT NULL DEFAULT '0', skulltime INTEGER NOT NULL DEFAULT '0', rank_id INTEGER NOT NULL, guildnick VARCHAR( 255 ) NOT NULL DEFAULT '''', lastlogout INTEGER NOT NULL DEFAULT '0', blessings INTEGER NOT NULL DEFAULT '0', pvp_blessing BOOLEAN NOT NULL DEFAULT 'FALSE', balance INTEGER NOT NULL DEFAULT '0', stamina INTEGER NOT NULL DEFAULT '151200000', direction INTEGER NOT NULL DEFAULT '2', loss_experience INTEGER NOT NULL DEFAULT '100', loss_mana INTEGER NOT NULL DEFAULT '100', loss_skills INTEGER NOT NULL DEFAULT '100', loss_containers INTEGER NOT NULL DEFAULT '100', loss_items INTEGER NOT NULL DEFAULT '100', premend INTEGER NOT NULL DEFAULT '0', online INTEGER NOT NULL DEFAULT '0', marriage INTEGER NOT NULL DEFAULT '0', promotion INTEGER NOT NULL DEFAULT '0', deleted INTEGER NOT NULL DEFAULT '0', description VARCHAR( 255 ) NOT NULL DEFAULT '''', comment TEXT NOT NULL, create_ip INT( 11 ) NOT NULL DEFAULT '0', create_date INT( 11 ) NOT NULL DEFAULT '0', hide_char INT( 11 ) NOT NULL DEFAULT '0', signature TEXT NOT NULL, offlinetraining_time SMALLINT UNSIGNED NOT NULL DEFAULT '43200', offlinetraining_skill INT NOT NULL DEFAULT '-1', cast TINYINT( 4 ) NOT NULL DEFAULT '0', castViewers INT( 11 ) NOT NULL DEFAULT '0', castDescription VARCHAR( 255 ) NOT NULL, created INT( 11 ) NOT NULL DEFAULT '0', nick_verify INT( 11 ) NOT NULL DEFAULT '0', old_name VARCHAR( 255 ) NOT NULL DEFAULT '', worldtransfer INT( 11 ) NOT NULL DEFAULT '0', show_outfit TINYINT( 4 ) NOT NULL DEFAULT '1', show_eq TINYINT( 4 ) NOT NULL DEFAULT '1', show_bars TINYINT( 4 ) NOT NULL DEFAULT '1', show_skills TINYINT( 4 ) NOT NULL DEFAULT '1', show_quests TINYINT( 4 ) NOT NULL DEFAULT '1', stars INT( 10 ) NOT NULL DEFAULT '0', ip VARCHAR( 17 ) NOT NULL DEFAULT '0', UNIQUE ( name, deleted ), FOREIGN KEY ( account_id ) REFERENCES accounts ( id ) ); INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0); DROP TABLE IF EXISTS z_ots_comunication; CREATE TABLE z_ots_comunication ( id INT( 11 ) NOT NULL, name VARCHAR( 255 ) NOT NULL, type VARCHAR( 255 ) NOT NULL, [action] VARCHAR( 255 ) NOT NULL, param1 VARCHAR( 255 ) NOT NULL, param2 VARCHAR( 255 ) NOT NULL, param3 VARCHAR( 255 ) NOT NULL, param4 VARCHAR( 255 ) NOT NULL, param5 VARCHAR( 255 ) NOT NULL, param6 VARCHAR( 255 ) NOT NULL, param7 VARCHAR( 255 ) NOT NULL, delete_it INT( 2 ) NOT NULL DEFAULT '1', PRIMARY KEY ( id ) );

Boa tarde, eu tenho esse script de mute no meu servidor, ele muta o jogador normalmente pelo tempo que eu escolher, mas se o player relogar o mute sai, alguém saberia arrumar: local GMGroup = 3 -- grupo mínimo do GM local maxTimeMute = 60 --Tempo máximo de mute, em minutos. Sim, isso é necessário. local conditions = {} for i = 1, maxTimeMute do conditions[i] = createConditionObject(CONDITION_MUTED) setConditionParam(conditions[i], CONDITION_PARAM_TICKS, i * 60 * 1000) end function onSay(cid,words,param) local testeGroup = getPlayerGroupId(cid) if testeGroup >= GMGroup then if param ~= "" then local sep = param:explode(",") local playerMuted, timeMuted = getPlayerByName(sep[1]), tonumber(sep[2]) if not timeMuted or not conditions[timeMuted] then doPlayerSendCancel(cid, "Escolha um tempo de mute (em minutos) válido.") elseif isPlayer(playerMuted) then local GMName = getPlayerName(cid) local playerName = getPlayerName(playerMuted) if playerName == GMName then doPlayerSendTextMessage(cid,MESSAGE_STATUS_DEFAULT ,"Por que ao invés aplicar um muted em si mesmo você mesmo não cale a boca?") return 0 end local playerGroup = getPlayerGroupId(playerMuted) if playerGroup >= testeGroup then doPlayerSendTextMessage(cid,MESSAGE_STATUS_DEFAULT ,"Você não pode calar um jogador que tenha um cargo maior ou igual ao seu.") return 0 end doAddCondition(playerMuted, conditions[timeMuted]) doPlayerSendTextMessage(cid,MESSAGE_STATUS_DEFAULT ,"Você aplicou um muted de "..timeMuted.." minuto(s) no jogador "..playerName..".") doPlayerSendTextMessage(playerMuted,MESSAGE_STATUS_DEFAULT,"Você foi mutado por "..timeMuted.." minuto(s) pelo "..GMName..".") else doPlayerSendTextMessage(cid,MESSAGE_STATUS_DEFAULT ,"O nome "..param.." está escrito errado ou este está offline.") end end end return true end

Não, cast system não funciona no 0.3.6 apenas no 0.4!

Tfs 0.3.6 e 0.4!

Calma então se é por mysql os códigos são esses: DROP TABLE IF EXISTS `killers`; CREATE TABLE `killers` ( `id` INT NOT NULL AUTO_INCREMENT, `death_id` INT NOT NULL, `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `war` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `player_killers`; CREATE TABLE `player_killers` ( `kill_id` INT NOT NULL, `player_id` INT NOT NULL, FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DROP TABLE IF EXISTS `players`; CREATE TABLE `players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '10', `vocation` int(11) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '150', `healthmax` int(11) NOT NULL DEFAULT '150', `experience` bigint(20) unsigned NOT NULL DEFAULT '0', `lookbody` int(11) NOT NULL DEFAULT '0', `lookfeet` int(11) NOT NULL DEFAULT '0', `lookhead` int(11) NOT NULL DEFAULT '0', `looklegs` int(11) NOT NULL DEFAULT '0', `looktype` int(11) NOT NULL DEFAULT '136', `lookaddons` int(11) NOT NULL DEFAULT '0', `lookmount` int(11) NOT NULL DEFAULT '0', `maglevel` int(11) NOT NULL DEFAULT '0', `mana` int(11) NOT NULL DEFAULT '0', `manamax` int(11) NOT NULL DEFAULT '0', `manaspent` bigint(20) unsigned NOT NULL DEFAULT '0', `soul` int(10) unsigned NOT NULL DEFAULT '0', `town_id` int(11) NOT NULL DEFAULT '2', `posx` int(11) NOT NULL DEFAULT '32369', `posy` int(11) NOT NULL DEFAULT '32241', `posz` int(11) NOT NULL DEFAULT '7', `conditions` blob NOT NULL, `cap` int(11) NOT NULL DEFAULT '0', `sex` int(11) NOT NULL DEFAULT '0', `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0', `lastip` int(10) unsigned NOT NULL DEFAULT '0', `save` tinyint(1) NOT NULL DEFAULT '1', `skull` tinyint(1) unsigned NOT NULL DEFAULT '0', `skulltime` int(11) NOT NULL DEFAULT '0', `rank_id` int(11) NOT NULL DEFAULT '0', `guildnick` varchar(255) NOT NULL DEFAULT '', `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0', `blessings` tinyint(2) NOT NULL DEFAULT '0', `pvp_blessing` tinyint(1) NOT NULL DEFAULT '0', `balance` bigint(20) unsigned NOT NULL DEFAULT '0', `stamina` bigint(20) unsigned NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds', `direction` int(11) NOT NULL DEFAULT '2', `loss_experience` int(11) NOT NULL DEFAULT '100', `loss_mana` int(11) NOT NULL DEFAULT '100', `loss_skills` int(11) NOT NULL DEFAULT '100', `loss_containers` int(11) NOT NULL DEFAULT '100', `loss_items` int(11) NOT NULL DEFAULT '100', `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER', `online` tinyint(1) NOT NULL DEFAULT '0', `marriage` int(10) unsigned NOT NULL DEFAULT '0', `promotion` int(11) NOT NULL DEFAULT '0', `deleted` int(11) NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `comment` text NOT NULL, `create_ip` int(11) NOT NULL DEFAULT '0', `create_date` int(11) NOT NULL DEFAULT '0', `hide_char` int(11) NOT NULL DEFAULT '0', `signature` text NOT NULL, `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200', `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1', `cast` tinyint(4) NOT NULL DEFAULT '0', `castViewers` int(11) NOT NULL DEFAULT '0', `castDescription` varchar(255) NOT NULL, `created` int(11) NOT NULL DEFAULT '0', `nick_verify` int(11) NOT NULL DEFAULT '0', `old_name` varchar(255) NOT NULL DEFAULT '', `worldtransfer` int(11) NOT NULL DEFAULT '0', `show_outfit` tinyint(4) NOT NULL DEFAULT '1', `show_eq` tinyint(4) NOT NULL DEFAULT '1', `show_bars` tinyint(4) NOT NULL DEFAULT '1', `show_skills` tinyint(4) NOT NULL DEFAULT '1', `show_quests` tinyint(4) NOT NULL DEFAULT '1', `stars` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`deleted`), KEY `account_id` (`account_id`), KEY `group_id` (`group_id`), KEY `online` (`online`), KEY `deleted` (`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0);

Imagens: Download Spr: https://mega.co.nz/#!toVk0SCb!RoavyqtKXQMOmM4c78lm5GSX42WP4MR4bZ82_1bXsnk Scan Spr: https://www.virustotal.com/pt/file/356cc7848d06fe15af7cd6a4ddab46ab5b061ed984493c09254df44b3a87105e/analysis/1438643233/ Download Items.otb: https://mega.co.nz/#!kpklEI4S!JRpUZUxFR1y9tt9KQkFaOY6jRDZkr9hzceg2NmfCs4E Scan Items.otb; https://www.virustotal.com/pt/file/e11a9ef36384215d1a49f14be877edbbe8ebf97dd62e3e872dce087f03844bb0/analysis/1438643009/ Créditos: PAdventures Team

Em talkactions/scripts crie um arquivo changename.lua e dentro coloque: --Player rename by Mock the bear (MTB) function sugested() --GName generator local cons = {'b','c','d','f','g','h','i','j','k','l','m','n',' p','q','r','s','t','v','x','y','z'} local vog = {"a",'e','i','o','u'} local sibalas = {} for i=1,#cons do for e=1,#vog do table.insert(sibalas,1,cons[i]..vog[e]) end end local total = "" for i=1,math.random(1,2) do local nam = "" for i=1,math.random(2,4) do nam = nam..sibalas[math.random(1,#sibalas)] end if math.random(1,2) == 1 then nam = nam..vog[math.random(1,#vog)] elseif math.random(1,2) == 2 then nam = nam..cons[math.random(1,#vog)] end total = total..(i == 2 and ' ' or '')..nam:sub(1,1):upper()..nam:sub(2,-1) end return total end function onSay(cid, words, param, channel) if param == 'gen' then doCreatureSay(cid,'Suggested name: '..sugested(),1) return true end local param1,param2 = param:match('(.-)[;:,.]%s*(.+)') param = param1 or param param2 = param2 or sugested() if not param then doPlayerSendTextMessage(cid,25,'Use like this: /rename Old name, New name') return true end if param2:len() <= 2 or param2:len() > 20 then doPlayerSendTextMessage(cid,25,'Please 3-20 characters.') return true end if param2:match('[%a%d%s%u%l]+') ~= param2 then doPlayerSendTextMessage(cid,25,'Please only A-Z 0-9') return true end param2 = param2:sub(1,1):upper()..param2:sub(2,-1) local p2 = getPlayerByName(param) if p2 and isPlayer(p2) then local id = getPlayerGUID(p2) doPlayerPopupFYI(p2,'Changing your name. Please login again on your character list.') addEvent(doRemoveCreature,2000,p2) addEvent(function(id,param2) db.executeQuery("UPDATE `players` SET `name` = '"..param2.."' WHERE `id` ="..id) end,2100,id,param2) else doPlayerSendTextMessage(cid,25,'Player '..param..' not found.') return true end return TRUE end Em talkactions/talkactions.xml adicione: <talkaction log="yes" words="/name" access="5" event="script" value="changename.lua"/> Créditos: Mock The Bear

Executa esse código na database: DROP TABLE IF EXISTS players; CREATE TABLE players ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR( 255 ) NOT NULL, world_id INTEGER NOT NULL DEFAULT '0', group_id INTEGER NOT NULL DEFAULT '1', account_id INTEGER NOT NULL, level INTEGER NOT NULL DEFAULT '1', vocation INTEGER NOT NULL DEFAULT '0', health INTEGER NOT NULL DEFAULT '100', healthmax INTEGER NOT NULL DEFAULT '100', experience INTEGER NOT NULL DEFAULT '0', lookbody INTEGER NOT NULL DEFAULT '10', lookfeet INTEGER NOT NULL DEFAULT '10', lookhead INTEGER NOT NULL DEFAULT '10', looklegs INTEGER NOT NULL DEFAULT '10', looktype INTEGER NOT NULL DEFAULT '136', lookaddons INTEGER NOT NULL DEFAULT '0', lookmount INTEGER NOT NULL DEFAULT '0', maglevel INTEGER NOT NULL DEFAULT '0', mana INTEGER NOT NULL DEFAULT '100', manamax INTEGER NOT NULL DEFAULT '100', manaspent INTEGER NOT NULL DEFAULT '0', soul INTEGER NOT NULL DEFAULT '0', town_id INTEGER NOT NULL, posx INTEGER NOT NULL DEFAULT '32369', posy INTEGER NOT NULL DEFAULT '32241', posz INTEGER NOT NULL DEFAULT '7', conditions BLOB NOT NULL, cap INTEGER NOT NULL DEFAULT '0', sex INTEGER NOT NULL DEFAULT '0', lastlogin INTEGER NOT NULL DEFAULT '0', lastip INTEGER NOT NULL DEFAULT '0', save BOOLEAN NOT NULL DEFAULT 'TRUE', skull INTEGER NOT NULL DEFAULT '0', skulltime INTEGER NOT NULL DEFAULT '0', rank_id INTEGER NOT NULL, guildnick VARCHAR( 255 ) NOT NULL DEFAULT '''', lastlogout INTEGER NOT NULL DEFAULT '0', blessings INTEGER NOT NULL DEFAULT '0', pvp_blessing BOOLEAN NOT NULL DEFAULT 'FALSE', balance INTEGER NOT NULL DEFAULT '0', stamina INTEGER NOT NULL DEFAULT '151200000', direction INTEGER NOT NULL DEFAULT '2', loss_experience INTEGER NOT NULL DEFAULT '100', loss_mana INTEGER NOT NULL DEFAULT '100', loss_skills INTEGER NOT NULL DEFAULT '100', loss_containers INTEGER NOT NULL DEFAULT '100', loss_items INTEGER NOT NULL DEFAULT '100', premend INTEGER NOT NULL DEFAULT '0', online INTEGER NOT NULL DEFAULT '0', marriage INTEGER NOT NULL DEFAULT '0', promotion INTEGER NOT NULL DEFAULT '0', deleted INTEGER NOT NULL DEFAULT '0', description VARCHAR( 255 ) NOT NULL DEFAULT '''', comment TEXT NOT NULL, create_ip INT( 11 ) NOT NULL DEFAULT '0', create_date INT( 11 ) NOT NULL DEFAULT '0', hide_char INT( 11 ) NOT NULL DEFAULT '0', signature TEXT NOT NULL, offlinetraining_time SMALLINT UNSIGNED NOT NULL DEFAULT '43200', offlinetraining_skill INT NOT NULL DEFAULT '-1', cast TINYINT( 4 ) NOT NULL DEFAULT '0', castViewers INT( 11 ) NOT NULL DEFAULT '0', castDescription VARCHAR( 255 ) NOT NULL, created INT( 11 ) NOT NULL DEFAULT '0', nick_verify INT( 11 ) NOT NULL DEFAULT '0', old_name VARCHAR( 255 ) NOT NULL DEFAULT '', worldtransfer INT( 11 ) NOT NULL DEFAULT '0', show_outfit TINYINT( 4 ) NOT NULL DEFAULT '1', show_eq TINYINT( 4 ) NOT NULL DEFAULT '1', show_bars TINYINT( 4 ) NOT NULL DEFAULT '1', show_skills TINYINT( 4 ) NOT NULL DEFAULT '1', show_quests TINYINT( 4 ) NOT NULL DEFAULT '1', stars INT( 10 ) NOT NULL DEFAULT '0', ip VARCHAR( 17 ) NOT NULL DEFAULT '0', UNIQUE ( name, deleted ), FOREIGN KEY ( account_id ) REFERENCES accounts ( id ) ); INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0); Caso não saiba como faça como manda na imagem: Esse também: DROP TABLE IF EXISTS killers; CREATE TABLE killers ( id INTEGER PRIMARY KEY, death_id INTEGER NOT NULL, final_hit BOOLEAN NOT NULL DEFAULT 'FALSE', unjustified BOOLEAN NOT NULL DEFAULT 'FALSE', war BIGINT NOT NULL DEFAULT '0', FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id ) ); E esse também: DROP TABLE IF EXISTS player_killers; CREATE TABLE player_killers ( kill_id INTEGER NOT NULL, player_id INTEGER NOT NULL, FOREIGN KEY ( kill_id ) REFERENCES killers ( id ), FOREIGN KEY ( player_id ) REFERENCES players ( id ) );