MarcosAlcantara

- Olá presiso de ajuda para a copilação das soucers do Cliente da base do psoul , consigo copilar no codes so que o cliente copilado não abre e nem da erro não mostra nada, no visual studio 2013 que pede a versao v10 para a copilação da soucers da erro e presiso de ajuda nessa parte , quem enteder e puder me ajuda eu pago ou até mesmo dou vaga na staff ce gosta do servidor ! Whats para contato : (011) 982953498 Facebook : www.facebook.com/MarcosAlcantaraSP

.Qual servidor ou website você utiliza como base? Znote ACC Qual o motivo deste tópico? Presiso de ajuda Player Online ele não conta quantos players online tem mostra 0 nao tem erro no scripts online list ja teste varios ate outras data base . acho que falta colocar algo nela para ela ler o user_count_online . aqui e a pasta de players online e eu estou usando uma conta de player em um servidor de teste como na imagem abaixo ate quando eu entro em perfil mostra meu ultimo login porem mostra Offline e em records ele mostra 1 players online Codigo do onlinelist.php tabela player online que eu uso CREATE TABLE IF NOT EXISTS players_online ( `player_id` int(11) NOT NULL DEFAULT '0', `id` int(11) NOT NULL DEFAULT '0', `p` int(11) NOT NULL DEFAULT '0', `g` int(11) NOT NULL DEFAULT '0', `guild_id` int(11) NOT NULL DEFAULT '0', `guilds` int(11) NOT NULL DEFAULT '0', `guild_membership` int(11) NOT NULL DEFAULT '0', `name` int(11) NOT NULL DEFAULT '0', `gname` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '0', `vocation` int(11) NOT NULL DEFAULT '0', `players_online` int(11) NOT NULL DEFAULT '0', `gm` int(11) NOT NULL DEFAULT '0', `attributes` blob NOT NULL ); Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

Mysql

tou com esse erro na tilles nao consigo mostra do outro lado ele nao deixa , mais fala algo de Cannot add or update a parent row: a foreign key constraint fails - MYSQL

Procuro membros para equipe Pokemon Mundial Procuro alguem para entra como administrador com vps base OTP bem editada Site 80% ja entrem em contato meu whats : 011982953498 meu facebook: https://www.facebook.com/MarcosAlcantaraSP -

sou webdesigner... meu whats: 011982953498

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

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

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>

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

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

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'

obg , funcionou , vou te da +resp

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...

mandei pv aqui no tibiaking ....

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)

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

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