StrikersBR12 1 Postado Setembro 10, 2019 Share Postado Setembro 10, 2019 Alguem me ajuda nesse erro quando eu logo na conta no servidor ela n é logada segue o print http://prntscr.com/p4e9lz @Yan Liima @Ayron5 @Marshmello se vocês souberem ai @Ayron5 se souber resolver isso ai pelo que entendi falta o table de language tentei adicionar através desse comando ALTER TABLE `accounts` ADD `language` TEXT NOT NULL AFTER `id`; mas fico tudo bugado Link para o comentário https://xtibia.com/forum/topic/250235-website/ Compartilhar em outros sites More sharing options...
1 Marshmello 271 Postado Setembro 11, 2019 Share Postado Setembro 11, 2019 erro meu UPDATE `players` set `cap`= 7; Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753551 Compartilhar em outros sites More sharing options...
0 Marshmello 271 Postado Setembro 10, 2019 Share Postado Setembro 10, 2019 Alter Table `accounts` add `language` int(11) not null default '0'; Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753544 Compartilhar em outros sites More sharing options...
0 StrikersBR12 1 Postado Setembro 10, 2019 Autor Share Postado Setembro 10, 2019 1 hora atrás, Marshmello disse: Alter Table `accounts` add `language` int(11) not null default '0'; quando crio personagem novo ele fica assim http://prntscr.com/p4hb0k meu login.lua pra qualquer coisa local config = { loginMessage = getConfigValue('loginMessage'), useFragHandler = getBooleanFromString(getConfigValue('useFragHandler')) } function onLogin(cid) if getPlayerLevel(cid) >= 1 and getPlayerLevel(cid) <= 10 then --alterado v1.8 doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, 0) else doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, (getPlayerLevel(cid) >= 200 and 100 or math.floor(getPlayerLevel(cid)/2)) ) end doCreatureSetDropLoot(cid, false) local accountManager = getPlayerAccountManager(cid) if(accountManager == MANAGER_NONE) then local lastLogin, str = getPlayerLastLoginSaved(cid), config.loginMessage if(lastLogin > 0) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str) str = "Sua última visita foi em " .. os.date("%a %b %d %X %Y", lastLogin) .. "." else str = str end sendMsgToPlayer(cid, 20, "Seja bem-vindo(a) ao Pokemon StarWind!") doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str) elseif(accountManager == MANAGER_NAMELOCK) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, it appears that your character has been namelocked, what would you like as your new name?") elseif(accountManager == MANAGER_ACCOUNT) then doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to manage your account and if you want to start over then type 'cancel'.") else doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to create an account or type 'recover' to recover an account.") end if getCreatureName(cid) == "Account Manager" then local outfit = {} if accountManagerRandomPokemonOutfit then outfit = {lookType = getPokemonXMLOutfit(oldpokedex[math.random(151)][1])} else outfit = accountManagerOutfit end doSetCreatureOutfit(cid, outfit, -1) return true end if(not isPlayerGhost(cid)) then doSendMagicEffect(getCreaturePosition(cid), CONST_ME_TELEPORT) end local outfit = {} if getPlayerVocation(cid) == 0 then doPlayerSetMaxCapacity(cid, 7) doPlayerSetVocation(cid, 1) setCreatureMaxMana(cid, 6) doPlayerAddSoul(cid, -getPlayerSoul(cid)) setPlayerStorageValue(cid, 19898, 0) if getCreatureOutfit(cid).lookType == 128 then outfit = {lookType = 510, lookHead = math.random(0, 132), lookBody = math.random(0, 132), lookLegs = math.random(0, 132), lookFeet = math.random(0, 132)} elseif getCreatureOutfit(cid).lookType == 136 then outfit = {lookType = 511, lookHead = math.random(0, 132), lookBody = math.random(0, 132), lookLegs = math.random(0, 132), lookFeet = math.random(0, 132)} end doCreatureChangeOutfit(cid, outfit) end registerCreatureEvent(cid, "dropStone") registerCreatureEvent(cid, "ShowPokedex") registerCreatureEvent(cid, "ClosePokedex") registerCreatureEvent(cid, "WatchTv") registerCreatureEvent(cid, "StopWatchingTv") registerCreatureEvent(cid, "WalkTv") registerCreatureEvent(cid, "RecordTv") registerCreatureEvent(cid, "PlayerLogout") registerCreatureEvent(cid, "WildAttack") registerCreatureEvent(cid, "Idle") registerCreatureEvent(cid, "EffectOnAdvance") registerCreatureEvent(cid, "GeneralConfiguration") registerCreatureEvent(cid, "SaveReportBug") registerCreatureEvent(cid, "LookSystem") registerCreatureEvent(cid, "T1") registerCreatureEvent(cid, "T2") registerCreatureEvent(cid, "atkz") registerCreatureEvent(cid, "atk") registerCreatureEvent(cid, "magica") registerCreatureEvent(cid, "Effect") registerCreatureEvent(cid, "bonuspremium") registerCreatureEvent(cid, "PassiveSystem") registerCreatureEvent(cid, "Teste") registerCreatureEvent(cid, "atacar") registerCreatureEvent(cid, "UpAbsolute") registerCreatureEvent(cid, "Outfit250") registerCreatureEvent(cid, "Outfit150") registerCreatureEvent(cid, "onlinebonus") registerCreatureEvent(cid, "BlockSkills") registerCreatureEvent(cid, "GodLight") registerCreatureEvent(cid, "OpenChannelDialog") registerCreatureEvent(cid, "upspeed") registerCreatureEvent(cid, "Monster Hunterl") registerCreatureEvent(cid, "Monster Hunter") registerCreatureEvent(cid, "MonsterKill") registerCreatureEvent(cid, "bossKill") if getPlayerStorageValue(cid, 99284) == 1 then setPlayerStorageValue(cid, 99284, -1) end if getPlayerStorageValue(cid, 6598754) >= 1 or getPlayerStorageValue(cid, 6598755) >= 1 then setPlayerStorageValue(cid, 6598754, -1) setPlayerStorageValue(cid, 6598755, -1) doRemoveCondition(cid, CONDITION_OUTFIT) --alterado v1.9 \/ doTeleportThing(cid, posBackPVP, false) doCreatureAddHealth(cid, getCreatureMaxHealth(cid)) end doChangeSpeed(cid, -(getCreatureSpeed(cid))) --///////////////////////////////////////////////////////////////////////////-- local storages = {17000, 63215, 17001, 13008, 5700} for s = 1, #storages do if not tonumber(getPlayerStorageValue(cid, storages[s])) then if s == 3 then setPlayerStorageValue(cid, storages[s], 1) elseif s == 4 then setPlayerStorageValue(cid, storages[s], -1) else if isBeingUsed(getPlayerSlotItem(cid, 8).itemid) then setPlayerStorageValue(cid, storages[s], 1) else setPlayerStorageValue(cid, storages[s], -1) end end doPlayerSendTextMessage(cid, 27, "Sorry, but a problem occurred on the server, but now it's alright") end end --/////////////////////////////////////////////////////////////////////////-- if getPlayerStorageValue(cid, 17000) >= 1 then -- fly local item = getPlayerSlotItem(cid, 8) local poke = getItemAttribute(item.uid, "poke") doChangeSpeed(cid, getPlayerStorageValue(cid, 54844)) doRemoveCondition(cid, CONDITION_OUTFIT) local addonfly = getPlayerSlotItem(cid, 8).uid local addofly = getItemAttribute(addonfly,"addonfly") if not addofly then doSetItemAttribute(addonfly,"addonfly",0) doSetCreatureOutfit(cid, {lookType = flys[poke][1] + 351}, -1) end if addofly > 0 then doSetCreatureOutfit(cid, {lookType = addofly}, -1) end local item = getPlayerSlotItem(cid, 8) local poke = getItemAttribute(item.uid, "poke") doChangeSpeed(cid, getPlayerStorageValue(cid, 54844)) doRemoveCondition(cid, CONDITION_OUTFIT) doSetCreatureOutfit(cid, {lookType = flys[poke][1] + 351}, -1) local apos = getFlyingMarkedPos(cid) apos.stackpos = 0 if getTileThingByPos(apos).itemid <= 2 then doCombatAreaHealth(cid, FIREDAMAGE, getFlyingMarkedPos(cid), 0, 0, 0, CONST_ME_NONE) doCreateItem(460, 1, getFlyingMarkedPos(cid)) end doTeleportThing(cid, apos, false) if getItemAttribute(item.uid, "boost") and getItemAttribute(item.uid, "boost") >= 50 and getPlayerStorageValue(cid, 42368) >= 1 then sendAuraEffect(cid, auraSyst[getItemAttribute(item.uid, "aura")]) --alterado v1.8 end local posicao = getTownTemplePosition(getPlayerTown(cid)) markFlyingPos(cid, posicao) elseif getPlayerStorageValue(cid, 63215) >= 1 then -- surf local item = getPlayerSlotItem(cid, 8) local poke = getItemAttribute(item.uid, "poke") local addonsurf = getPlayerSlotItem(cid, 8).uid local addosurf = getItemAttribute(addonsurf,"addonsurf") if not addosurf then doSetItemAttribute(addonsurf,"addonsurf",0) doSetCreatureOutfit(cid, {lookType = surfs[poke].lookType + 351}, -1) end if addosurf > 0 then doSetCreatureOutfit(cid, {lookType = addosurf}, -1) end doChangeSpeed(cid, getPlayerStorageValue(cid, 54844)) if getItemAttribute(item.uid, "boost") and getItemAttribute(item.uid, "boost") >= 50 and getPlayerStorageValue(cid, 42368) >= 1 then sendAuraEffect(cid, auraSyst[getItemAttribute(item.uid, "aura")]) --alterado v1.8 end elseif getPlayerStorageValue(cid, 17001) >= 1 then -- ride local item = getPlayerSlotItem(cid, 8) local poke = getItemAttribute(item.uid, "poke") local item = getPlayerSlotItem(cid, 8) local poke = getItemAttribute(item.uid, "poke") if rides[poke] then doChangeSpeed(cid, getPlayerStorageValue(cid, 54844)) doRemoveCondition(cid, CONDITION_OUTFIT) local addonride = getPlayerSlotItem(cid, 8).uid local addoride = getItemAttribute(addonride,"addonride") if not addofly then doSetItemAttribute(addonride,"addonride",0) doSetCreatureOutfit(cid, {lookType = rides[poke][1] + 351}, -1) end if addoride > 0 then doSetCreatureOutfit(cid, {lookType = addoride}, -1) end if getItemAttribute(item.uid, "boost") and getItemAttribute(item.uid, "boost") >= 50 and getPlayerStorageValue(cid, 42368) >= 1 then sendAuraEffect(cid, auraSyst[getItemAttribute(item.uid, "aura")]) --alterado v1.8 end else setPlayerStorageValue(cid, 17001, -1) doRegainSpeed(cid) end local posicao2 = getTownTemplePosition(getPlayerTown(cid)) markFlyingPos(cid, posicao2) elseif getPlayerStorageValue(cid, 13008) >= 1 then -- dive if not isInArray({5405, 5406, 5407, 5408, 5409, 5410}, getTileInfo(getThingPos(cid)).itemid) then setPlayerStorageValue(cid, 13008, 0) doRegainSpeed(cid) doRemoveCondition(cid, CONDITION_OUTFIT) return true end if getPlayerSex(cid) == 1 then doSetCreatureOutfit(cid, {lookType = 1034, lookHead = getCreatureOutfit(cid).lookHead, lookBody = getCreatureOutfit(cid).lookBody, lookLegs = getCreatureOutfit(cid).lookLegs, lookFeet = getCreatureOutfit(cid).lookFeet}, -1) else doSetCreatureOutfit(cid, {lookType = 1035, lookHead = getCreatureOutfit(cid).lookHead, lookBody = getCreatureOutfit(cid).lookBody, lookLegs = getCreatureOutfit(cid).lookLegs, lookFeet = getCreatureOutfit(cid).lookFeet}, -1) end doChangeSpeed(cid, 800) elseif getPlayerStorageValue(cid, 5700) > 0 then --bike doChangeSpeed(cid, -getCreatureSpeed(cid)) doChangeSpeed(cid, getPlayerStorageValue(cid, 5700)) --alterado v1.8 if getPlayerSex(cid) == 1 then doSetCreatureOutfit(cid, {lookType = 1394}, -1) else doSetCreatureOutfit(cid, {lookType = 1393}, -1) end elseif getPlayerStorageValue(cid, 75846) >= 1 then --alterado v1.9 \/ doTeleportThing(cid, getTownTemplePosition(getPlayerTown(cid)), false) setPlayerStorageValue(cid, 75846, -1) sendMsgToPlayer(cid, 20, "You have been moved to your town!") else doRegainSpeed(cid) end if getPlayerStorageValue(cid, 22545) >= 1 then setPlayerStorageValue(cid, 22545, -1) doTeleportThing(cid, getClosestFreeTile(cid, posBackGolden), false) setPlayerRecordWaves(cid) end setPlayerStorageValue(cid, 243656, 0) if getPlayerLanguage(cid) == 0 then doPlayerSendTextMessage(cid, 25,"Bem-vindo(a) ao StarWind!\nDica de Segurança: Nunca digite sua senha em algum site não oficial!") -- doPlayerSendTextMessage(cid, 25,"Você está fazendo parte do BETA TESTE, então após ser realizado o TESTE as contas iram resetar, os 3 melhores do BETA iram ganhar PONTOS!\n1° = 30\n2° = 25\n3° = 20\ne o 4° e 5° iram ganhar 1 Shiny Stone, 1 Boost Stone, 1 Bike Box.") end if getPlayerLanguage(cid) == 2 then doPlayerSendTextMessage(cid, 25,"Welcome to StarWind\nSafety Tip: Never enter your password on any unofficial site!") end if getPlayerLanguage(cid) == 1 then doPlayerSendTextMessage(cid, 25, "Bienvenido a StarWind\nConsejo de seguridad: Nunca introduzca su contraseña en cualquier sitio no oficial!") end if getPlayerLanguage(cid) == 0 then doPlayerSendTextMessage(cid, 27,"[Language System (Beta)] Do you speak english? If so, try setting your game language to english. Just say: '!lang en'.") doPlayerSendTextMessage(cid, 27,"[Language System (Beta)] Tu hablas español? si, para mudar la lengua del juego a español apenas diga: '!lang es'.") end if getPlayerLanguage(cid) == 2 then doPlayerSendTextMessage(cid, 27, "[Language System (Beta)] Você fala português? Se sim, experimente mudar a língua do jogo para português. Apenas diga: '!lang pt'.") doPlayerSendTextMessage(cid, 27, "[Language System (Beta)] Tu hablas español? si, para mudar la lengua del juego a español apenas diga: '!lang es'.") end if getPlayerLanguage(cid) == 1 then doPlayerSendTextMessage(cid, 27, "[Language System (Beta)] Do you speak english? If so, try setting your game language to english. Just say: '!lang en'.") doPlayerSendTextMessage(cid, 27, "[Language System (Beta)] Você fala português? Se sim, experimente mudar a língua do jogo para português. Apenas diga: '!lang pt'.") end doSetPlayerSpeedLevel(cid) doPlayerSetMaxCapacity(cid, 7) return true end to conseguindo logar agora pq removi esse system de language mas olha o erro que ta dando http://prntscr.com/p4hhmk sabe como resolver? se precisar mando o some functions tbm print de como fica o inventario http://prntscr.com/p4hhwk eu vi uma solução "Simples, va no sua data base / players / e mude seu Cap pra 400 isso deve parar o problema dos itens cairem no chao !" so não entendi essa parte mude seu cap pra 400 Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753547 Compartilhar em outros sites More sharing options...
0 Marshmello 271 Postado Setembro 10, 2019 Share Postado Setembro 10, 2019 Vai na Sua Db e execute isso UPDATE `players set `cap`= 7; Agora quando criar a conta outra vez fica normal Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753549 Compartilhar em outros sites More sharing options...
0 StrikersBR12 1 Postado Setembro 11, 2019 Autor Share Postado Setembro 11, 2019 1 minuto atrás, Marshmello disse: Vai na Sua Db e execute isso UPDATE `players set `cap`= 7; Agora quando criar a conta outra vez fica normal http://prntscr.com/p4hr6c o correto seria assim? UPDATE `players` SET `cap`= 7; Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753550 Compartilhar em outros sites More sharing options...
0 StrikersBR12 1 Postado Setembro 11, 2019 Autor Share Postado Setembro 11, 2019 Agora, Marshmello disse: erro meu UPDATE `players` set `cap`= 7; obrigado bug corrigido Link para o comentário https://xtibia.com/forum/topic/250235-website/#findComment-1753552 Compartilhar em outros sites More sharing options...
Pergunta
StrikersBR12 1
Alguem me ajuda nesse erro quando eu logo na conta no servidor ela n é logada segue o print http://prntscr.com/p4e9lz
@Yan Liima @Ayron5 @Marshmello se vocês souberem
ai @Ayron5 se souber resolver isso ai
pelo que entendi falta o table de language tentei adicionar através desse comando ALTER TABLE `accounts` ADD `language` TEXT NOT NULL AFTER `id`; mas fico tudo bugado
Link para o comentário
https://xtibia.com/forum/topic/250235-website/Compartilhar em outros sites
6 respostass a esta questão
Posts Recomendados