Alter Table `accounts` add `language` int(11) not null default '0';
7
2.4k
info
Grupo: Conde
Registrado: 21/04/16
Posts: 831
Reputação: +271
Gênero: Masculino
10 de setembro de 2019 às 18:25
info
Grupo: Cavaleiro
Registrado: 25/08/17
Posts: 153
Reputação: +1
Gênero: Masculino
10 de setembro de 2019 às 20:00
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
info
Grupo: Conde
Registrado: 21/04/16
Posts: 831
Reputação: +271
Gênero: Masculino
10 de setembro de 2019 às 20:58
Vai na Sua Db e execute isso
UPDATE `players set `cap`= 7;
Agora quando criar a conta outra vez fica normal
info
Grupo: Cavaleiro
Registrado: 25/08/17
Posts: 153
Reputação: +1
Gênero: Masculino
10 de setembro de 2019 às 21:00
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
o correto seria assim? UPDATE `players` SET `cap`= 7;
info
Grupo: Conde
Registrado: 21/04/16
Posts: 831
Reputação: +271
Gênero: Masculino
10 de setembro de 2019 às 21:01
Melhor resposta
erro meu
UPDATE `players` set `cap`= 7;
info
Grupo: Cavaleiro
Registrado: 25/08/17
Posts: 153
Reputação: +1
Gênero: Masculino
10 de setembro de 2019 às 21:02
Agora, Marshmello disse:erro meu
UPDATE `players` set `cap`= 7;
obrigado bug corrigido
info
Grupo: Cavaleiro
Registrado: 25/08/17
Posts: 153
Reputação: +1
Gênero: Masculino
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