Entao, eu baixei o gesior "mudrockwebgesior", parece ser muito bom, mas eu nao sei como configurar, instalei o xampp entrei na adm, criei a database e tal, mas dai nao sei qual database devo usar, se e a do gesior, ou a do meu server... nem como fazer as duas trabalharem juntas, ou se vai ser so uma que vai trabalhar..

tentei importar minha db na adm do xampp (phpmyadmin) e deu isso:

Comando SQL:

 

Mensagens do MySQL :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

 

Vou lhe explicar como funciona o sistema de conexão Gesior/Servidor, quando você usa seu OtServer sem conexão com website, as contas geradas no account manager são mandadas direta pra sua database que esta no seu servidor, quando você usa um gesior ele usa a database que você ta usando no seu PhpMyAdmin, que é a que você baixa junto com o Gesior, peço que me mande a parte do seu config.lua que esta referente a sua Database

no caso minha db e essa forgotten ne, mas no "phpmyadmin" ela nao importa, ela importou uma tal de "database.sql", mas isso e meio obvio que o php nao ia executar arquivo s3db ne?

so que importou essa db mas ela esta vazia, nao tem as accounts que tem na db "forgottenserver"

Primeiro você tem que tirar todos os espaços do seu config.lua

Exemplo

de:

-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

Para

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

Você vai enviar para o seu phpmyadmin o arquivo .sql que esta no seu servidor e que possue as contas e colunas, caso seu servidor não tenha o arquivo .sql abaixe um de qualquer outro gesior, não o s3db.

Depois que você tirou os espaços mude para

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "SENHA QUE VC COLOCOU NO PHPMYADMIN"
sqlDatabase = "Nome da database do seu Servidor que upo no phpmyadmin"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

obrigado cara, consegui... mas agora reiniciei o xampp com todas as coisas la dentro e abri ne o 127.0.0.1 como no tutorial mas apareceu o seguinte erro agora ):

Warning: parse_ini_file(C:/Users/******/Desktop/Baiak Speed 8.6/config.lua): failed to open stream: No such file or directory in C:\xampp\htdocs\config-and-functions.php on line 13
Database error. Unknown database type in C:/Users/*******/Desktop/Baiak Speed 8.6/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

C:/Users/*******/Desktop/Baiak Speed 8.6/config.lua

******* Substitua pelo nome meu seu pc

então consegui fazer tudo isso, demorei até porque tive que reiniciar pra deixar o mesmo nome do computador, botei até o nome da pasta do server igual...

mas mudei tudo no config.lua e agora não ta ficando on

ta assim a config.lua:

accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 54
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = "no"


redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 20
weeklyFragsToRedSkull = 50
monthlyFragsToRedSkull = 70
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 = 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 = 50
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 700
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 5 * 10 * 100
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 = "177.156.166.88"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 841
motd = "Bem vindos ao Baiak Ganja \|/"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Baiak Ganja"
loginMessage = "Bom Divertimento e chapaceira"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false


sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "66531644"
sqlDatabase = "database"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"


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


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


highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2


buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 1
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"
mapAuthor = "We Bass Drun Kill"
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 = true
spellNameInsteadOfWords = true
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false


ghostModeInvisibleEffect = false
ghostModeSpellEffects = true


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


freePremium = true
premiumForPromotion = true


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


experienceStages = "yes"
rateExperience = 500
rateExperienceFromPlayers = 0
rateSkill = 80
rateMagic = 40
rateLoot = 2
rateSpawn = 2


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


deSpawnRange = 2
deSpawnRadius = 50


maxPlayerSummons = 0
teleportAllSummons = false
teleportPlayerSummons = false


ownerName = "We Bass Drun Raell's Kill's"
ownerEmail = "[email protected]<script cf-hash='f9e31' type="text/javascript">
/*  */</script>"
url = "frozen-hell.net"
location = "usa"
displayGamemastersWithOnlineCommand = false


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

tentei mexer no gesior mesmo assim sem deixar online e apareceu isso

Notice: Undefined index: sqliteDatabase in C:\xampp\htdocs\config-and-functions.php on line 37

config-and-functions.php on line 37 

manda oq tem na linha

ta aparecendo isso na hora de deixar online agora

line 37

$sqlitefile = $config['server']['sqliteDatabase'];

ta me ajudando bastante, valeu e foi mal a incomodação kkkk

Você não vai conseguir colocar seu servidor no gesior, porque seu servidor é SQLITE não MYSQL.

recomendo trocar de Servidor

poisé, acabei de perceber isso... troquei pra sqlite e foi.. obg mano, vou procurar outro server ^^

amigo o erro e que no servidor ele ainda se encontra account manage , la no config.lua tem accontmanage algo assim esta yes tem que fica no e o abaixo dela tb no e no seu esta yes

então consegui fazer tudo isso, demorei até porque tive que reiniciar pra deixar o mesmo nome do computador, botei até o nome da pasta do server igual...

 

mas mudei tudo no config.lua e agora não ta ficando on

 

ta assim a config.lua:

accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 54
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = "no"


redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 20
weeklyFragsToRedSkull = 50
monthlyFragsToRedSkull = 70
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 = 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 = 50
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 700
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 5 * 10 * 100
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 = "177.156.166.88"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 841
motd = "Bem vindos ao Baiak Ganja \|/"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Baiak Ganja"
loginMessage = "Bom Divertimento e chapaceira"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false


sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "66531644"
sqlDatabase = "database"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"


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


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


highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2


buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 1
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"
mapAuthor = "We Bass Drun Kill"
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 = true
spellNameInsteadOfWords = true
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false


ghostModeInvisibleEffect = false
ghostModeSpellEffects = true


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


freePremium = true
premiumForPromotion = true


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


experienceStages = "yes"
rateExperience = 500
rateExperienceFromPlayers = 0
rateSkill = 80
rateMagic = 40
rateLoot = 2
rateSpawn = 2


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


deSpawnRange = 2
deSpawnRadius = 50


maxPlayerSummons = 0
teleportAllSummons = false
teleportPlayerSummons = false


ownerName = "We Bass Drun Raell's Kill's"
ownerEmail = "[email protected]<script cf-hash='f9e31' type="text/javascript">
/*  */</script>"
url = "frozen-hell.net"
location = "usa"
displayGamemastersWithOnlineCommand = false


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

tentei mexer no gesior mesmo assim sem deixar online e apareceu isso

 

Notice: Undefined index: sqliteDatabase in C:\xampp\htdocs\config-and-functions.php on line 37

ainda tem erro no config.lua do gesior e do server vendo aqui seu config.lua encontrei 3 erros.

Erros porque o servidor dele é SQLite. normal

O tópico foi fechado e movido para lixeira por estar inativo a mais de 10 dias. Caso seja preciso reabrir o mesmo, favor entrar em contato com a equipe.