Yestureday i found out a huge bug in my "server account manager" which led me to try and make a ACC maker with geisor instead
Fixed the config file but when i try to get into 3. Add tables and columns to DB
it tells me Can't connect to MySQL database.
My server is running fine so i dont really understand why it can't connect.
Thankful for all help
this is my config:
Running Uniserver btw
- - - Updated - - -
Rly do i have to bump this?
- - - Updated - - -
bump! ...
- - - Updated - - -
bump!
Fixed the config file but when i try to get into 3. Add tables and columns to DB
it tells me Can't connect to MySQL database.
My server is running fine so i dont really understand why it can't connect.
Thankful for all help
this is my config:
Code:
packetsBandwidthSensitivityForPlayer = 30
packetsBandwidthSensitivityForSpectacor = 55
packetsBandwidthSensitivityForAccountManager = 55
packetsBandwidthActionOnDetect = 1
pingAtackEnabled = false
pingAtackSensitivity = 40
pingAtackTimeToStartAcion = 10
pingAtackAciontOnTime = 3
ddosAtackEnabled = false
ddosAtackSensitivity = 40
ddosAtackTimeToStartAcion = 10
ddosAtackAciontOnTime = 3
openShopWindowOnTarget = true
deSpawnRange = 2
deSpawnRadius = 50
monsterSpawnWalkback = true
noDisableBlockRespawn = true
monstersGoBackToSpawn = false
healPlayersOnLevelAdvance = true
useCapSystem = true
noShareExpSummonMonster = false
unifiedSpells = true
accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 1003
newPlayerSpawnPosY = 1000
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = false
generateAccountSalt = false
useFragHandler = true
redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 3
weeklyFragsToRedSkull = 5
monthlyFragsToRedSkull = 10
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
allowedMaxSizedPackets = 20
worldType = "open"
protectionLevel = 1
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = true
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
recoverManaAfterDeathInPvPZone = false
squareColor = 0
allowFightback = true
fistBaseAttack = 7
worldId = 0
ip = "127.0.0.1"
bindOnlyGlobalAddress = false
loginPort = 7171
gamePort = 7172
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "Welcome to the PerfectOts Server!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = 0
serverName = "blah blah blah"
loginMessage = "Welcome to the PerfectOts Server!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"
rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
rsaPublic = "65537"
rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "This is right"
sqlPass = "this too"
sqlDatabase = "perfectot"
sqlFile = "perfectots.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
mysqlReconnectionAttempts = 3
encryptionType = "sha1"
ingameGuildManagement = true
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
mapName = "emperia.otbm"
mapAuthor = "?"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = ""
mailMaxAttempts = 20
mailBlockPeriod = 60 * 60 * 1000
mailAttemptsFadeTime = 10 * 60 * 1000
defaultDepotSizePremium = 2000
defaultDepotSize = 1000
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 1
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 10000
houseSkipInitialRent = true
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false
houseProtection = true
timeBetweenActions = 200
timeBetweenExActions = 1000
hotkeyAimbotEnabled = true
tibiaClassicSlots = true
canOnlyRopePlayers = true
formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
addonsOnlyPremium = true
checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 29
separateVipListPerCharacter = false
vipListDefaultLimit = 20
vipListDefaultPremiumLimit = 100
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false
ghostModeInvisibleEffect = false
ghostModeSpellEffects = true
freePremium = false
premiumForPromotion = true
blessings = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecrement = 5
eachBlessReduction = 8
pvpBlessingThreshold = 40
fairFightTimeRange = 60
experienceStages = false
rateExperience = 5.0
rateExperienceFromPlayers = 0
rateSkill = 3.0
rateMagic = 3.0
rateLoot = 2.0
rateSpawnMin = 1
rateSpawnMax = 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 = 40 * 60
staminaRatingLimitBottom = 14 * 60
staminaLootLimit = 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
daemonize = false
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
houseDataStorage = "binary"
saveGlobalStorage = true
storePlayerDirection = false
savePlayerData = true
startupDatabaseOptimization = true
updatePremiumStateAtStartup = true
confirmOutdatedVersion = false
skipItemsVersionCheck = true
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60
idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
reportsExpirationAfterReads = 1
playerQueryDeepness = -1
tileLimit = 0
protectionTileLimit = 0
houseTileLimit = 0
globalSaveEnabled = false
globalSaveHour = 8
globalSaveMinute = 0
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false
statusPort = 7171
ownerName = ""
ownerEmail = "@perfectots.net"
url = "http://perfectots.net/"
location = "Europe"
displayGamemastersWithOnlineCommand = false
disableLuaErrors = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outputLog = ""
truncateLogOnStartup = false
dataDirectory = "data/"
logsDirectory = "data/logs/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
maximumDoorLevel = 500
maxMessageBuffer = 4
tradeLimit = 100
useCapacity = true
managerPort = 7171
managerLogs = true
managerPassword = ""
managerLocalhostOnly = true
managerConnectionsLimit = 1
adminPort = 7171
adminLogs = true
adminPassword = ""
adminLocalhostOnly = true
adminConnectionsLimit = 1
adminRequireLogin = true
adminEncryption = ""
adminEncryptionData = ""Running Uniserver btw
- - - Updated - - -
Rly do i have to bump this?
- - - Updated - - -
bump! ...
- - - Updated - - -
bump!
