dúvida [Encerrado] Passar de MySql para SQLITE ?

[HeartReason 2]

Mudar server de MySql para SqlLite

 

 

 

Olá pessoal, estou com meu server online por mysql, mas gostaria de passar para sqlite.

Gostaria de uma explicação bem detalhada, pois mudei lá no config.lua, de mysql para sqlite,

funciona, mas o server trava do nada e não abre mais,

poderiam me ajudar ? Vou postar meu config.lua e a base do ot

que eu uso.

 

 

A base do Otserver que uso

 

http://www.xtibia.co...ate-ot-phoenix/

 

 

 

Meu config.lua

 

accountManager = false

namelockManager = false

newPlayerChooseVoc = true

newPlayerSpawnPosX = 2000

newPlayerSpawnPosY = 2000

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 100

newPlayerMagicLevel = 30

generateAccountNumber = false

 

redSkullLength = 5 * 6 * 7 * 9

blackSkullLength = 6 * 7 * 8 * 9

dailyFragsToRedSkull = 20

weeklyFragsToRedSkull = 40

monthlyFragsToRedSkull = 80

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 1000

blackSkulledDeathMana = 200

useBlackSkull = true

useFragHandler = true

advancedFragList = true

 

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 7 * 24 * 60 * 60

killsBanLength = 8 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

worldType = "pvp"

protectionLevel = 1000

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 10 * 50

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 7 * 30 * 100

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

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 = "*.***.**.**"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Bem Vindo ao Otsbe, mais info acesse: otsbr.servegame.com:8090"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "OtsBR"

loginMessage = "Bem Vindo ao Otsbe, mais info acesse: otsbr.servegame.com:8090"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "**********"

sqlDatabase = "otserv"

sqlFile = "otserv.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 = 1

 

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 700000

housesPerAccount = 1

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 10000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

 

mapName = "Pheonixia"

mapAuthor = "Pheonixia"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

 

optimizeDatabaseAtStartup = true

removePremiumOnInit = false

confirmOutdatedVersion = false

 

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = true

 

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

 

dataDirectory = "data/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

separateViplistPerCharacter = false

maximumDoorLevel = 717217

maxMessageBuffer = 4

 

saveGlobalStorage = false

useHouseDataStorage = false

storePlayerDirection = false

 

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

 

ghostModeInvisibleEffect = true

ghostModeSpellEffects = true

 

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

freePremium = true

premiumForPromotion = true

 

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

experienceStages = false

rateExperience = 1000

rateExperienceFromPlayers = 0

rateSkill = 100.0

rateMagic = 100.0

rateLoot = 1.0

rateSpawn = 2

 

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

 

minLevelThresholdForKilledPlayer = 5000

maxLevelThresholdForKilledPlayer = 10000

 

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 = 9000000

experienceShareActivity = 2 * 60 * 1000

 

globalSaveEnabled = true

globalSaveHour = 1

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

 

deSpawnRange = 2

deSpawnRadius = 50

 

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

ownerName = "[ADMIN]"

ownerEmail = "otsbrstaff@gmail.com"

url = "http://otsteste.servegame.com:8090"

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

Editado Janeiro 5, 2013 por PauloMarinaska

[Subwat 405]

é impossivel de se fazer.

abraços

[mkbrabsolute 134]

Prezado, as ferramentos do MYSQL não permitem transformar banco de dados em uma extensão inferior, que seria a s3bd, outro tipo de compilação.

 

Caso necessite muito disto, baixar qualquer banco de dados em sqlite e configure para rodar em seu servidor.

 

AJUDEI? REP+

[HeartReason 2]

Entendi, obrigado !

[Stigal 584]

Tópico movido para a seção de dúvidas e pedidos resolvidos.

[Stigal 584]

A questão neste tópico de suporte foi encerrada por falta de respostas. Este tópico está fechado e foi movido para Suporte - Tópicos Sem Resposta.

+ Caso a dúvida não tenha sido resolvida você poderá criar outro tópico solicitando ajuda.
* Lembre-se que é permitido dar UP no tópico a cada 24 horas para assim o destacar e manter movimentado.