2 horas atrás, flaviofelipezik disse:

 eu vou pesquisar sobre essas informações e vou ver se consigo arrumar o erro 

 

 

Também tenho este problema amigo, mas é apenas ao usar sqlite, se usar mysql ele some. E não precisa necessariamente de um site, você só vai trocar o .s3db por .sql e o Sqlitestudio pelo Mysql, algum destes que o cara citou lá em cima... (xamp, wamp, appserv...)

eu consegui instala o xammp deu tudo certo ate um site criei, porem na hora que eu vou ligar o executavel do server, aparece este erro aqui

33 minutos atrás, flaviofelipezik disse:

eu consegui instala o xammp deu tudo certo ate um site criei, porem na hora que eu vou ligar o executavel do server, aparece este erro aqui

configura o seu config.lua, creio eu q o xamp não coloca senha no phpmyadmin.. 

vai no seu arquivo config.lua (fica na raiz do server), procura por sqlite

 

vai tah mais ou menos assim:     DELETA AS DESCRIÇÕES EM VERMELHO

Spoiler

sqlType = "mysql"  <<aqui vai tah sqlite
sqlHost = "localhost" << vc tbm pode usar localhost ou 127.0.0.1
sqlPort = 3306 <<n mecher
sqlUser = "root" <<no xamp o usuario eh root
sqlPass = "" <<o xamp n coloca senha, maqui eh a senha do mysql (phpmyadmin)
sqlDatabase = "nomedobancodedados" <<aqui eh o nome do banco de dados.. ve nos tutoriais se tiver duvida sobre o nome do seu banco de dados
sqlFile = "theforgottenserver.s3db" << n mecher
sqlKeepAlive = 0
mysqlReadTimeout = 10 <<n mecher
mysqlWriteTimeout = 10 <<n mecher
encryptionType = "sha1" <<n mecher

 

ou assim

 

Spoiler

mysqlHost = "127.0.0.1" <<IP do mysql ( se estiver na sua maquina deixe 127.0.0.1 )
mysqlUser = "root" <<login do MySQL
mysqlPass = "" <<senha do mysql (acho q xamp n coloca senha deixa como esta)
mysqlDatabase = "tibia" <<nome do banco de dados
mysqlPort = 3306 << nao mecher
mysqlSock = "" << nao mecher
passwordType = "sha1" << nao mecher

 

se tiver duvida aqui no forum pode te ajudar bastante... e depois de começar a usar mysql vc nunca ira querer usar sqlite...

os 2 jeito deu erra vou postar aqui pra vc ver os print

meu arquivo lua

 

 

accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 39
newPlayerSpawnPosY = 172
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 15
newPlayerMagicLevel = 1
generateAccountNumber = "no"

redSkullLength = 24 * 60 * 60
blackSkullLength = 48 * 60 * 60
dailyFragsToRedSkull = 70
weeklyFragsToRedSkull = 300
monthlyFragsToRedSkull = 700
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false

notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 1 * 24 * 60 * 60
killsBanLength = 1 * 24 * 60 * 60
finalBanLength = 1 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "open"
protectionLevel = 15
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 2 * 60 * 1000
huntingDuration = 1 * 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = true
removeRuneCharges = false
whiteSkullTime = 3 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 100
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true

enableCast = false

healthHealingColor = COLOR_BLUE

worldId = 0
ip = "192.168.25.3"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 109
motd = "Bem vindo ao Baiak Rox Editado por Flavinho,servidor Dedicado e Sem Lag 24Horas!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Baiak Rox"
loginMessage = "Bem vindo ao Baiak Rox Editado por Flavinho!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "mudar123"
sqlDatabase = "baiak"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

ingameGuildManagement = true
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 2

buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 50
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500

mapName = "Baiak Yurots.otbm"
mapAuthor = "Flavinho"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"

defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false

maxMessageBuffer = 4
bufferMutedOnSpellFailure = false

dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = false
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false

ghostModeInvisibleEffect = false
ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

freePremium = true
premiumForPromotion = true

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

experienceStages = "yes"
rateExperience = 800
rateExperienceFromPlayers = 5
rateSkill = 100
rateMagic = 100
rateLoot = 25
rateSpawn = 1

rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1

rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false
globalSaveHour = 1
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false

ownerName = "Baiak Rox o Melhor"
ownerEmail = ""
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
 

Editado Julho 5, 2017 7 anos por flaviofelipezik (veja o histórico de edições)

1 hora atrás, flaviofelipezik disse:

os 2 jeito deu erra vou postar aqui pra vc ver os print

meu arquivo lua

 

 

accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 39
newPlayerSpawnPosY = 172
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 15
newPlayerMagicLevel = 1
generateAccountNumber = "no"

redSkullLength = 24 * 60 * 60
blackSkullLength = 48 * 60 * 60
dailyFragsToRedSkull = 70
weeklyFragsToRedSkull = 300
monthlyFragsToRedSkull = 700
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false

notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 1 * 24 * 60 * 60
killsBanLength = 1 * 24 * 60 * 60
finalBanLength = 1 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "open"
protectionLevel = 15
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 2 * 60 * 1000
huntingDuration = 1 * 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = true
removeRuneCharges = false
whiteSkullTime = 3 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 100
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true

enableCast = false

healthHealingColor = COLOR_BLUE

worldId = 0
ip = "192.168.25.3"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 109
motd = "Bem vindo ao Baiak Rox Editado por Flavinho,servidor Dedicado e Sem Lag 24Horas!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Baiak Rox"
loginMessage = "Bem vindo ao Baiak Rox Editado por Flavinho!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "mudar123"
sqlDatabase = "baiak"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

ingameGuildManagement = true
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 2

buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 50
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500

mapName = "Baiak Yurots.otbm"
mapAuthor = "Flavinho"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"

defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false

maxMessageBuffer = 4
bufferMutedOnSpellFailure = false

dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = false
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false

ghostModeInvisibleEffect = false
ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

freePremium = true
premiumForPromotion = true

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

experienceStages = "yes"
rateExperience = 800
rateExperienceFromPlayers = 5
rateSkill = 100
rateMagic = 100
rateLoot = 25
rateSpawn = 1

rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1

rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false
globalSaveHour = 1
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false

ownerName = "Baiak Rox o Melhor"
ownerEmail = ""
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
 

 

Só você tentar várias vezes que vai, e tenta fechar tudo no computador, isso é a memória. Mysql consome muito.

Editado Julho 5, 2017 7 anos por Skipper (veja o histórico de edições)