Squash01 2 Postado Abril 26, 2014 Share Postado Abril 26, 2014 Bom como Topico ja Disse Querria mudar Meu Servidor que Abaxei Baiak Dream Editado By:Renan DomicianoE 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 Link para o comentário Compartilhar em outros sites More sharing options...
Junior001 362 Postado Abril 26, 2014 Share Postado Abril 26, 2014 poste o config.lua do servidor para que podemos ajudar Link para o comentário Compartilhar em outros sites More sharing options...
Squash01 2 Postado Abril 26, 2014 Autor Share Postado Abril 26, 2014 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 Link para o comentário Compartilhar em outros sites More sharing options...
Junior001 362 Postado Abril 26, 2014 Share Postado Abril 26, 2014 toma tenta este 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 Link para o comentário Compartilhar em outros sites More sharing options...
Squash01 2 Postado Abril 26, 2014 Autor Share Postado Abril 26, 2014 Agora Da erro no DATABASE COMO EU MUDO PARA SQLITE ? Link para o comentário Compartilhar em outros sites More sharing options...
pessoa93 217 Postado Abril 26, 2014 Share Postado Abril 26, 2014 (editado) @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 Link para o comentário Compartilhar em outros sites More sharing options...
Squash01 2 Postado Abril 26, 2014 Autor Share Postado Abril 26, 2014 (editado) 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 Link para o comentário Compartilhar em outros sites More sharing options...
Junior001 362 Postado Abril 26, 2014 Share Postado Abril 26, 2014 @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" Link para o comentário Compartilhar em outros sites More sharing options...
Squash01 2 Postado Abril 26, 2014 Autor Share Postado Abril 26, 2014 Continuou dando este erro. no TFS ! Error: Could't estabilish connection to SQL database Link para o comentário Compartilhar em outros sites More sharing options...
pessoa93 217 Postado Abril 26, 2014 Share Postado Abril 26, 2014 (editado) 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 Link para o comentário Compartilhar em outros sites More sharing options...
Posts Recomendados