Ir para conteúdo
Close

REFORMULAMOS A SEÇÃO DE CLASSIFICADOS! - Crie grátis os seus anúncios de procura e oferta de serviços e produtos relacionados ao OTServ! - Acesse através do nosso menu ou clique aqui e confira já!

MarcosAlcantara

Membro
  • Total de itens

    15
  • Registro em

  • Última visita

Sobre MarcosAlcantara

  • Rank
    Padeiro

Últimos Visitantes

O bloco dos últimos visitantes está desativado e não está sendo visualizado por outros usuários.

  1. Bom dia , sou WebMaster e Designer , posso ajuda , dependedo nao cobro entro para equipe , tenho site pronto so eu edita ,vamos invistir em um dedicado ... meu trabalho ai meu whatsaapp : 011982953498
  2. so eu adicionar isso na linha 138 if getPlayerLanguage(cid) == 2 then  correto ? como que e a tablela pode me manda para eu jogar no sql
  3. local EFFECTS = { --[OutfitID] = {Effect} ["Magmar"] = 35, ["Jynx"] = 17, --alterado v1.5 ["Shiny Jynx"] = 17, ["Piloswine"] = 205, --alterado v1.8 ["Swinub"] = 205, } function onUse(cid, item, frompos, item2, topos) if exhaustion.get(cid, 6666) and exhaustion.get(cid, 6666) > 0 then return true end if getPlayerStorageValue(cid, 17000) >= 1 or getPlayerStorageValue(cid, 17001) >= 1 or getPlayerStorageValue(cid, 63215) >= 1 or getPlayerStorageValue(cid, 75846) >= 1 or getPlayerStorageValue(cid, 5700) >= 1 then --alterado v1.9 << return true end local ballName = getItemAttribute(item.uid, "poke") local btype = getPokeballType(item.itemid) local usando = pokeballs[btype].use local effect = pokeballs[btype].effect if not effect then effect = 21 end unLock(item.uid) --alterado v1.8 if item.itemid == usando then if getPlayerStorageValue(cid, 990) == 1 then -- GYM doPlayerSendCancel(cid, "You can't return your pokemon during gym battles.") return true end if #getCreatureSummons(cid) > 1 and getPlayerStorageValue(cid, 212124) <= 0 then --alterado v1.6 if getPlayerStorageValue(cid, 637501) == -2 or getPlayerStorageValue(cid, 637501) >= 1 then BackTeam(cid) end end if #getCreatureSummons(cid) == 2 and getPlayerStorageValue(cid, 212124) >= 1 then doPlayerSendCancel(cid, "You can't do that while is controling a mind") return true --alterado v1.5 end if #getCreatureSummons(cid) <= 0 then if isInArray(pokeballs[btype].all, item.itemid) then doTransformItem(item.uid, pokeballs[btype].off) doItemSetAttribute(item.uid, "hp", 0) doPlayerSendCancel(cid, "This pokemon is fainted.") return true end end local cd = getCD(item.uid, "blink", 30) if cd > 0 then setCD(item.uid, "blink", 0) end local z = getCreatureSummons(cid)[1] if getCreatureCondition(z, CONDITION_INVISIBLE) and not isGhostPokemon(z) then return true end doReturnPokemon(cid, z, item, effect) elseif item.itemid == pokeballs[btype].on then if item.uid ~= getPlayerSlotItem(cid, CONST_SLOT_FEET).uid then doPlayerSendCancel(cid, "You must put your pokeball in the correct place!") return TRUE end local thishp = getItemAttribute(item.uid, "hp") if getItemAttribute(item.uid, "hp") == 0 then if isInArray(pokeballs[btype].all, item.itemid) then doTransformItem(item.uid, pokeballs[btype].off) doItemSetAttribute(item.uid, "hp", 0) doPlayerSendCancel(cid, "This pokemon is fainted.") return true end end local pokemon = getItemAttribute(item.uid, "poke") if not pokes[pokemon] then return true end local x = pokes[pokemon] local boost = getItemAttribute(item.uid, "boost") or 0 if getPlayerLevel(cid) < (x.level) then doPlayerSendCancel(cid, "You need level "..(x.level).." to use this pokemon.") return true end if getItemAttribute(item.uid, "unique") then doItemEraseAttribute(item.uid, "unique") end local pk = getCreatureSummons(cid)[1] doSummonMonster(cid, pokemon) doItemSetAttribute(item.uid, "pokeballusada", 0) local pk = getCreatureSummons(cid)[1] if not isCreature(pk) then return true end if getCreatureName(pk) == "Ditto" or getCreatureName(pk) == "Shiny Ditto" then --edited local left = getItemAttribute(item.uid, "transLeft") local name = getItemAttribute(item.uid, "transName") if left and left > 0 then setPlayerStorageValue(pk, 1010, name) doSetCreatureOutfit(pk, {lookType = getItemAttribute(item.uid, "transOutfit")}, -1) addEvent(deTransform, left * 1000, pk, getItemAttribute(item.uid, "transTurn")) doItemSetAttribute(item.uid, "transBegin", os.clock()) else setPlayerStorageValue(pk, 1010, getCreatureName(pk) == "Ditto" and "Ditto" or "Shiny Ditto") --edited end end if isGhostPokemon(pk) then doTeleportThing(pk, getPosByDir(getThingPos(cid), math.random(0, 7)), false) end doCreatureSetLookDir(pk, 2) doCreatureSetNick(pk, nick) adjustStatus(pk, item.uid, true, true, true) doAddPokemonInOwnList(cid, pokemon) doTransformItem(item.uid, item.itemid+1) local pokename = getPokeName(pk) --alterado v1.7 local mgo = gobackmsgs[math.random(1, #gobackmsgs)].go:gsub("doka", pokename) local mgoen = gobackmsgsen[math.random(1, #gobackmsgsen)].go:gsub("doka", pokename) local mgoes = gobackmsgses[math.random(1, #gobackmsgses)].go:gsub("doka", pokename) if getPlayerLanguage(cid) == 2 then doCreatureSay(cid, mgoen, 19) end if getPlayerLanguage(cid) == 0 then doCreatureSay(cid, mgo, 19) end if getPlayerLanguage(cid) == 1 then doCreatureSay(cid, mgoes, 19) end -- doItemSetAttribute(item.uid, "gender", math.random(3, 4)) doSendMagicEffect(getCreaturePosition(pk), effect) if useOTClient then doPlayerSendCancel(cid, '12//,show') --alterado v1.7 end local pk = getCreatureSummons(cid)[1] local pb = getPlayerSlotItem(cid, 8).uid local look = getItemAttribute(pb,"addon") if not getItemAttribute(pb,"addon") then doSetItemAttribute(pb,"addon",0) end if getItemAttribute(pb,"addon") > 0 then doSetCreatureOutfit(pk, {lookType = look}, -1) end else doPlayerSendCancel(cid, "This pokemon is fainted.") end if useKpdoDlls then doUpdateMoves(cid) end return true end
  4. toda vez que chamo o pokemon para dentro da ball ele multiplica distro mostra isso ai [11/01/2019 19:33:58] mysql_real_query(): SELECT `language` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'language' in 'field list' (1054) [11/01/2019 19:33:58] [Error - Action Interface] [11/01/2019 19:33:58] datapack/actions/scripts/goback.lua:onUse [11/01/2019 19:33:58] Description: [11/01/2019 19:33:58] datapack/lib/004-database.lua:60: [Result:getDataInt] Result not set! [11/01/2019 19:33:58] stack traceback: [11/01/2019 19:33:58] [C]: in function 'error' [11/01/2019 19:33:58] datapack/lib/004-database.lua:60: in function 'getDataInt' [11/01/2019 19:33:58] datapack/lib/some functions.lua:1686: in function 'getPlayerLanguage' [11/01/2019 19:33:58] datapack/actions/scripts/goback.lua:138: in function <datapack/actions/scripts/goback.lua:10> [11/01/2019 19:34:03] mysql_real_query(): SELECT `language` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'language' in 'field list' (1054) [11/01/2019 19:34:03] [Error - Action Interface] [11/01/2019 19:34:03] datapack/actions/scripts/goback.lua:onUse [11/01/2019 19:34:03] Description: [11/01/2019 19:34:03] datapack/lib/004-database.lua:60: [Result:getDataInt] Result not set! [11/01/2019 19:34:03] stack traceback: [11/01/2019 19:34:03] [C]: in function 'error' [11/01/2019 19:34:03] datapack/lib/004-database.lua:60: in function 'getDataInt' [11/01/2019 19:34:03] datapack/lib/some functions.lua:1686: in function 'getPlayerLanguage' [11/01/2019 19:34:03] datapack/lib/some functions.lua:873: in function 'doReturnPokemon' [11/01/2019 19:34:03] datapack/actions/scripts/goback.lua:64: in function <datapack/actions/scripts/goback.lua:10>
  5. boa noite , queria ajuda de vcs no goback esta dando esse erro na distro [C]: in function 'error' [10/01/2019 00:07:43] datapack/lib/004-database.lua:60: in function 'getDataInt' [10/01/2019 00:07:43] datapack/lib/some functions.lua:1686: in function 'getPlayerLanguage' [10/01/2019 00:07:43] datapack/actions/scripts/goback.lua:138: in function <datapack/actions/scripts/goback.lua:10> toda vez que puxo o poke para volta ele multiplica
  6. string(754) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Pandemon', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '2130706433', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');" (query - SQL error) Type: voidQuery (voidQuery is used for update, insert or delete from database) Field 'comment' doesn't have a default value
  7. entao criar conta deu ai veio isso no criar personagem string(754) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Pandemon', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '2130706433', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');" (query - SQL error) Type: voidQuery (voidQuery is used for update, insert or delete from database) Unknown column 'skill_fist' in 'field list'
  8. Marcos Davila 14 min · Adicionar tópicos - Alguem me ajuda ? obs a accounts ja ta criada na database ao criar a conta da isso INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) a um tempo eu vi um topico aqui so disso de erros na db e de insert e tals ce postarem o topico agradeço...
  9. nao ta conectando com as contas no phpmyadmin , no site eu crio a conta normal quando vou entra no client nao vai na distro ta mostrando isso /01/2019 16:06:43] >> Initializing game state modules and registering services... [05/01/2019 16:06:45] > ERROR: Failed to load motd! [05/01/2019 16:06:45] > ERROR: Failed to load players record! [05/01/2019 16:06:45] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054) [05/01/2019 16:06:45] mysql_real_query(): SELECT `id`, `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'key' in 'field list' (1054) [05/01/2019 16:06:45] mysql_real_query(): UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1546711605 WHERE `id` = 0 LIMIT 1; - MYSQL ERROR: Unknown column 'warnings' in 'field list' (1054) [05/01/2019 16:06:45] > ERROR: Failed to save account: ! [05/01/2019 16:06:45] mysql_real_query(): SELECT `id`, `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'key' in 'field list' (1054) [05/01/2019 16:06:45] mysql_real_query(): UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1546711605 WHERE `id` = 0 LIMIT 1; - MYSQL ERROR: Unknown column 'warnings' in 'field list' (1054) [05/01/2019 16:06:45] > ERROR: Failed to save account: ! [05/01/2019 16:06:45] mysql_real_query(): SELECT `id`, `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 3 LIMIT 1 - MYSQL ERROR: Unknown column 'key' in 'field list' (1054) [05/01/2019 16:06:45] mysql_real_query(): UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1546711605 WHERE `id` = 0 LIMIT 1; - MYSQL ERROR: Unknown column 'warnings' in 'field list' (1054) [05/01/2019 16:06:45] > ERROR: Failed to save account: ! [05/01/2019 16:06:45] > Global address: 127.0.0.1 [05/01/2019 16:06:45] > Local ports: 7171 7178 9091 [05/01/2019 16:06:45] >> All modules were loaded, server is starting up... [05/01/2019 16:06:45] >> Blue server Online! [05/01/2019 16:06:46] Um Shiny Alakazam foi spawnado em X=1729 Y=1270 Z=8 [05/01/2019 16:06:46] Um Shiny Alakazam foi spawnado em X=1603 Y=1409 Z=8 [05/01/2019 16:09:31] > Broadcasted message: "Está gostando do servidor? Que tal chamar seus amigos para jogar junto com você?". [05/01/2019 16:09:31] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'pokemonfa.shop_history' doesn't exist (1146)
  10. servidor tava dando isso que tava faltando a tabela tiles fui istala ela no phpmyadmin seguinte tabela DROP TABLE IF EXISTS `tiles`; CREATE TABLE `tiles` ( `id` INT UNSIGNED NOT NULL, `world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0, `house_id` INT UNSIGNED NOT NULL, `x` INT(5) UNSIGNED NOT NULL, `y` INT(5) UNSIGNED NOT NULL, `z` TINYINT(2) UNSIGNED NOT NULL, UNIQUE (`id`, `world_id`), KEY (`x`, `y`, `z`), FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE ) ENGINE = InnoDB; comecou da isso alguem me ajuda
  11. tabela DROP TABLE IF EXISTS `tiles`; CREATE TABLE `tiles` ( `id` INT UNSIGNED NOT NULL, `world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0, `house_id` INT UNSIGNED NOT NULL, `x` INT(5) UNSIGNED NOT NULL, `y` INT(5) UNSIGNED NOT NULL, `z` TINYINT(2) UNSIGNED NOT NULL, UNIQUE (`id`, `world_id`), KEY (`x`, `y`, `z`), FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE ) ENGINE = InnoDB; ta dando esse erro quando tento instala a tabala

Open Tibia Server

Quer aprender a criar seu próprio servidor de Tibia? Então está no lugar certo, aqui você encontrará milhares de tutorias, scripts, códigos, mapas e utilitários para que você possa fazer o seu próprio servidor de Tibia partindo do zero.

Redes Sociais

Anuncie no Tibia King

Precisa de mais visibilidade em seus projetos? Quer publicidade para o seu servidor? Anuncie no Tibia King e faça sua divulgação, possuímos centenas de acessos simultâneos e milhares diários, com certeza será a sua solução! A publicação do seu anuncio é instantânea!

×