Ir para conteúdo

Featured Replies

Postado

Fala glr blz? Então to com um mapa bem louco, e pretendo criar meu server com ele, mas o servidor só funciona se tiver site, ou seja ele é mysql só para qm sabe mexer com xampp etc...

Teria como eu mudar isso? Botar pra ser apenas por accmanager? Já mudei no config.lua e botei como modo sqlitle, no accmanager mudei para true. Mesmo assim continua dando esse error no distro\/

 

[19:53:13.778] >> Loading config <config.lua>
[19:53:13.779] >> Opening logs
[19:53:13.808] > Using plaintext encryption
 
[19:53:13.840] > WARNING: This method is completely unsafe!
[19:53:13.840] > Please set encryptiontype = "sha1' <or any other available method> in config.lua
[19:53:44.351] >> Checking software version...failed checking - malformed file.
[19:53:44.352] >> Loading RSA Key
[19:53:44.353] >> Starting SQL connection
[19:53:45.352] Failed connecting to  database - MYSQL ERROR: Can't connect to MySQL server on 'localhost'
 
[19:53:45.353] > ERROR: Couldn't estabilish connection to SQL database!
 
Sinceramente quero resolver isso pq fiquei muito tempo atrs desse mapa e gostaria de ter um servidor com ele. Já fiz outros tópicos sobre esse error, mas sem sucesso então dei como resolvido.
Agradeço desde já.. 

Editado por Kd meu arrozz (veja o histórico de edições)

Resolvido por Cat

Ir para solução
  • Respostas 8
  • Visualizações 673
  • Created
  • Última resposta

Top Posters In This Topic

Most Popular Posts

  • Coloque em seu config.lua:     Eu modifiquei, agora tem account manager, mas você precisará pegar outra database e modificar aqui:   sqlType = "sqlite" sqlHost = "localhost" sqlPort = 3306

Postado
  • Autor
accountManager = false
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 50
newPlayerSpawnPosZ = 8
newPlayerTownId = 1
newPlayerLevel = 10
newPlayerMagicLevel = 1
generateAccountNumber = false
 
redSkullLength = 10 * 24 * 60 * 60
blackSkullLength = 20 * 24 * 60 * 60
dailyFragsToRedSkull = 5
weeklyFragsToRedSkull = 10
monthlyFragsToRedSkull = 20
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = true
 
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 3 * 24 * 60 * 60
killsBanLength = 2 * 24 * 60 * 60
finalBanLength = 7 * 24 * 60 * 60
ipBanishmentLength = 7 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = true
 
worldType = "2"
protectionLevel = 50
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 10 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = false
whiteSkullTime = 5 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
 
worldId = 0
ip = "ipaki"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 300
motd = "Welcome to the VIPOT ROX Server, brevemente novidades!!!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = true
serverName = "VIPOT ROX"
loginMessage = "Welcome to the VIPOT ROX Server, brevemente novidades sobre VIP!!!!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
 
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "maelstrom"
sqlFile = "crazy.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
 
deathListEnabled = true
deathListRequiredTime = 2 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
 
ingameGuildManagement = true
levelToFormGuild = 25
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
 
highscoreDisplayPlayers = 10
updateHighscoresAfterMinutes = 15
 
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 50
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 5000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = true
 
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500
 
mapName = "Hunted.otbm"
mapAuthor = "CrazyBoY"
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 = false
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
 
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
 
idleWarningTime = 14 * 60 * 1000
idleKickTime = 30 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
 
freePremium = false
premiumForPromotion = true
 
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
 
experienceStages = true
rateExperience = 10.0
rateExperienceFromPlayers = 0
rateSkill = 5.0
rateMagic = 5.0
rateLoot = 1.5
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 = 8
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false
 
deSpawnRange = 2
deSpawnRadius = 50
 
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false
 
ownerName = "Crazy Team"
ownerEmail = "crazyot_team@hotmail.com"
location = "Portugal"
displayGamemastersWithOnlineCommand = true
 
adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
Postado

verifique se o nome está correto em SQL, no caso se está de acordo com o arquivo:

sqlDatabase = "maelstrom"
sqlFile = "crazy.s3db"

E substitua no config.lua:

 

Mostrar conteúdo oculto

 

accountManager = false
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 50
newPlayerSpawnPosZ = 8
newPlayerTownId = 1
newPlayerLevel = 10
newPlayerMagicLevel = 1
generateAccountNumber = false
 
redSkullLength = 10 * 24 * 60 * 60
blackSkullLength = 20 * 24 * 60 * 60
dailyFragsToRedSkull = 5
weeklyFragsToRedSkull = 10
monthlyFragsToRedSkull = 20
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = true
 
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 3 * 24 * 60 * 60
killsBanLength = 2 * 24 * 60 * 60
finalBanLength = 7 * 24 * 60 * 60
ipBanishmentLength = 7 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = true
 
worldType = "2"
protectionLevel = 50
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 10 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = false
whiteSkullTime = 5 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
 
worldId = 0
ip = "ipaki"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 300
motd = "Welcome to the VIPOT ROX Server, brevemente novidades!!!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = true
serverName = "VIPOT ROX"
loginMessage = "Welcome to the VIPOT ROX Server, brevemente novidades sobre VIP!!!!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
 
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "maelstrom"
sqlFile = "crazy.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
 
deathListEnabled = true
deathListRequiredTime = 2 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
 
ingameGuildManagement = true
levelToFormGuild = 25
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
 
highscoreDisplayPlayers = 10
updateHighscoresAfterMinutes = 15
 
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 50
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 5000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = true
 
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500
 
mapName = "Hunted.otbm"
mapAuthor = "CrazyBoY"
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 = false
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
 
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
 
idleWarningTime = 14 * 60 * 1000
idleKickTime = 30 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
 
freePremium = false
premiumForPromotion = true
 
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
 
experienceStages = true
rateExperience = 10.0
rateExperienceFromPlayers = 0
rateSkill = 5.0
rateMagic = 5.0
rateLoot = 1.5
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 = 8
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false
 
deSpawnRange = 2
deSpawnRadius = 50
 
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false
 
ownerName = "Crazy Team"
ownerEmail = "crazyot_team@hotmail.com"
location = "Portugal"
displayGamemastersWithOnlineCommand = true
 
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = true
 

Postado
  • Autor

Está correto, no sqltype já mudei de mysql para sqlitle, mas da o msm error, no próprio tk a um tópico de um dos criadores do mapa q eu estou usando, falando exatamente assim, logo abaixo\/

 

Este servidor é 100% baseado no OpenTibia SVN, ou sejá, este server não possui uma versão SQLite, este server não possui Account Manager, ou seja... este server é apenas para quem sabe mexer com xampp e website.

 

É isso que quero mudar, quero que o server seja por acc manager.

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

Quem Está Navegando 0

  • Nenhum usuário registrado visualizando esta página.

Estatísticas dos Fóruns

  • Tópicos 96.9k
  • Posts 519.6k

Informação Importante

Confirmação de Termo