[AJUDA]Mudar Servidor Mysql para Sqlite

[Squash01 2]

Bom como Topico ja Disse

Querria mudar Meu Servidor que Abaxei

Baiak Dream Editado By:Renan Domiciano

E gostei do Server.

Só que ele esta em Mysql e querria mudar para Sqlite

ALGUEM PODERIA ME AJUDAR ?

Se tiver postado lugar errado favor mover porq sou novo

VALENDO +REP

 

[Junior001 362]

poste o config.lua do servidor para que podemos ajudar

[Squash01 2]

accountManager = "yes"

namelockManager = "no"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 66

newPlayerSpawnPosY = 189

newPlayerSpawnPosZ = 0

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = "no"

redSkullLength = 180 * 60 * 1000

blackSkullLength = 240 * 60 * 1000

dailyFragsToRedSkull = 10

weeklyFragsToRedSkull = 100

monthlyFragsToRedSkull = 300

dailyFragsToBlackSkull = 20

weeklyFragsToBlackSkull = 120

monthlyFragsToBlackSkull = 480

dailyFragsToBanishment = 0

weeklyFragsToBanishment = 0

monthlyFragsToBanishment = 0

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = false

notationsToBan = 3

warningsToFinalBan = 1

warningsToDeletion = 5

banLength = 3 * 24 * 60 * 60

killsBanLength = 1 * 24 * 60 * 60

finalBanLength = 5 * 24 * 60 * 60

ipBanishmentLength = 9999 * 24 * 60 * 60

broadcastBanishments = false

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

worldType = "open"

protectionLevel = 100

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 30 * 1000

huntingDuration = 45 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = "false"

whiteSkullTime = 2 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 0 * 1000

deathLostPercent = 10

stairhopDelay = 0 * 1000

pushCreatureDelay = 0 * 500

deathContainerId = 1987

gainExperienceColor = 18

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

worldId = 0

ip = "Seu ip"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 2 * 1000

loginTimeout = 5 * 1000

maxPlayers = 1000

motd = "*Bem Vindo ao Dream Baiak OT.*"

displayOnOrOffAtCharlist = true

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "Dream OT"

loginMessage = "Bem-Vindo ao Dream OT Server!"

statusTimeout = 10 * 100

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "senha"

sqlDatabase = "lol"

sqlFile = "lol.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 5000

mysqlWriteTimeout = 5000

encryptionType = "sha1"

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

ingameGuildManagement = true

levelToFormGuild = 100

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

highscoreDisplayPlayers = 100

updateHighscoresAfterMinutes = 2

buyableAndSellableHouses = true

houseNeedPremium = false

bedsRequirePremium = false

levelToBuyHouse = 100

housesPerAccount = 1

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 10000

houseRentPeriod = "weekly"

houseCleanOld = 0

guildHalls = false

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = false

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

mapName = "Baiak Yurots.otbm"

mapAuthor = "Hollister World OT Server"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

maxMessageBuffer = 10

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

ghostModeSpellEffects = true

idleWarningTime = 13 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

freePremium = true

premiumForPromotion = false

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

experienceStages = false

rateExperience = 900

rateExperienceFromPlayers = 0

rateSkill = 300

rateMagic = 150

rateLoot = 9

rateSpawn = 3

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

rateStaminaLoss = 0

rateStaminaGain = 10

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.0

rateStaminaUnderNormal = 1.0

staminaThresholdOnlyPremium = false

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false

globalSaveHour = 24

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

deSpawnRange = 2

deSpawnRadius = 50

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = true

ownerName = "Hollister World OT Server"

ownerEmail = "HollisterOT@hotmail.com.br"

url = "http://HollisterOT.servegame.com/"

location = "Brazil"

displayGamemastersWithOnlineCommand = false

adminLogsEnabled = true

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

[Junior001 362]

toma tenta este

 

  Mostrar conteúdo oculto

 

accountManager = "yes"
namelockManager = "no"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 66
newPlayerSpawnPosY = 189
newPlayerSpawnPosZ = 0
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = "no"
 
redSkullLength = 180 * 60 * 1000
blackSkullLength = 240 * 60 * 1000
dailyFragsToRedSkull = 10
weeklyFragsToRedSkull = 100
monthlyFragsToRedSkull = 300
dailyFragsToBlackSkull = 20
weeklyFragsToBlackSkull = 120
monthlyFragsToBlackSkull = 480
dailyFragsToBanishment = 0
weeklyFragsToBanishment = 0
monthlyFragsToBanishment = 0
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false
 
notationsToBan = 3
warningsToFinalBan = 1
warningsToDeletion = 5
banLength = 3 * 24 * 60 * 60
killsBanLength = 1 * 24 * 60 * 60
finalBanLength = 5 * 24 * 60 * 60
ipBanishmentLength = 9999 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
 
worldType = "open"
protectionLevel = 100
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 30 * 1000
huntingDuration = 45 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "false"
whiteSkullTime = 2 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 0 * 1000
deathLostPercent = 10
stairhopDelay = 0 * 1000
pushCreatureDelay = 0 * 500
deathContainerId = 1987
gainExperienceColor = 18
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
 
worldId = 0
ip = "Seu ip"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 2 * 1000
loginTimeout = 5 * 1000
maxPlayers = 1000
motd = "*Bem Vindo ao Dream Baiak OT.*"
displayOnOrOffAtCharlist = true
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "Dream OT"
loginMessage = "Bem-Vindo ao Dream OT Server!"
statusTimeout = 10 * 100
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
 
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "lol"
sqlFile = "lol.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 5000
mysqlWriteTimeout = 5000
encryptionType = "plain"
 
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
 
ingameGuildManagement = true
levelToFormGuild = 100
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
 
highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2
 
buyableAndSellableHouses = true
houseNeedPremium = false
bedsRequirePremium = false
levelToBuyHouse = 100
housesPerAccount = 1
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 10000
houseRentPeriod = "weekly"
houseCleanOld = 0
guildHalls = false
 
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = false
hotkeyAimbotEnabled = true
maximumDoorLevel = 500
 
mapName = "Baiak Yurots.otbm"
mapAuthor = "Hollister World OT Server"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
 
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false
 
maxMessageBuffer = 10
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 = true
ghostModeSpellEffects = true
 
idleWarningTime = 13 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
 
freePremium = true
premiumForPromotion = false
 
blessingOnlyPremium = false
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
 
experienceStages = false
rateExperience = 900
rateExperienceFromPlayers = 0
rateSkill = 300
rateMagic = 150
rateLoot = 9
rateSpawn = 3
 
rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0
 
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1
 
rateStaminaLoss = 0
rateStaminaGain = 10
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 40 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.0
rateStaminaUnderNormal = 1.0
staminaThresholdOnlyPremium = false
 
experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000
 
globalSaveEnabled = false
globalSaveHour = 24
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false
 
deSpawnRange = 2
deSpawnRadius = 50
 
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = true
 
ownerName = "Hollister World OT Server"
ownerEmail = "HollisterOT@hotmail.com.br"
url = "http://HollisterOT.servegame.com/"
location = "Brazil"
displayGamemastersWithOnlineCommand = false
 
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

 

 

[Squash01 2]

Agora Da erro no DATABASE COMO EU MUDO PARA SQLITE ?

[pessoa93 217]

@Junior

Uma coisa que aprendi aqui no XTIBIA: "Ao invés de dar o peixe, ensine a pescar".

Você entregou uma configuração pronta para ele sem ao menos, dizer as alterações, muito menos o que significa as alterações.

--

 

As alterações foram:

1. sqlType = "mysql" PARA -> sqlType = "sqlite"
2. encryptionType = "sha1" PARA -> encryptionType = "plain"

 

1. Mudou do banco de dados mysql(web) para banco de dados sqlite(local/na sua maquina)

2. Mudou o tipo de armazenamento das senhas das contas. sha1 é mais seguro do que plain.

 

OBS:

Tente mudar isso aqui

ip = "Seu ip"

para

ip = "localhost"

 

Abraços

Editado Abril 26, 2014 por Pess0a

[Squash01 2]

Hm entao...

 

Está dando Erro no Database ...

Quando ABRIR O TFS

Como posso mudar o SQL DATABASE

ou se tiver algum TUTORIAL como passar o server completo para Sqlite Porfavor me ajudem

Editado Abril 26, 2014 por Squash01

[Junior001 362]

  Em 26/04/2014 em 02:30, Pess0a disse:

@Junior

Uma coisa que aprendi aqui no XTIBIA: "Ao invés de dar o peixe, ensine a pescar".

Você entregou uma configuração pronta para ele sem ao menos, dizer as alterações, muito menos o que significa as alterações.

--

 

As alterações foram:

1. sqlType = "mysql" PARA -> sqlType = "sqlite"

2. encryptionType = "sha1" PARA -> encryptionType = "plain"

 

1. Mudou do banco de dados mysql(web) para banco de dados sqlite(local/na sua maquina)

2. Mudou o tipo de armazenamento das senhas das contas. sha1 é mais seguro do que plain.

 

OBS:

Tente mudar isso aqui

ip = "Seu ip"

para

ip = "localhost"

 

Abraços

 

Entendi vacilei nisso

 

no ip bote o ip do no-ip

e se tiver dando erro no database mude o sqlFile = "lol.s3db"

para sqlFile = "forgottenserver.s3db"

[Squash01 2]

Continuou dando este erro.

no TFS !

Error: Could't estabilish connection to SQL database

[pessoa93 217]

  Em 26/04/2014 em 02:52, Squash01 disse:

Continuou dando este erro.

no TFS !

Error: Could't estabilish connection to SQL database

Dentro da pasta do seu servior, tem um arquivo com o final .s3db

troque o sqlFile = "lol.s3db" para o nome dele.

Isso é seu banco de dados.

Editado Abril 26, 2014 por Pess0a