Jump to content

Erro Sql Database


xllgokullx

Recommended Posts

Eai galera baxei um ot de War desse link http://otland.net/f4...oobwar-128056/.

Achei muito legal o ot mais não consigo dexar ele on ja li todo o topico e ainda n consigo arrumar

por favor me ajudem , desde já agradesço ao Xtibia happy.png

 

Esse erro

Hr4Rr.png

 

Aqui os arquivos do meu Ot serv

 

ylgLU.png

Minha Config.lua

 

accountManager = false

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 0

newPlayerSpawnPosY = 0

newPlayerSpawnPosZ = 0

newPlayerTownId = 1

newPlayerLevel = 20

newPlayerMagicLevel = 1

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

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

worldType = "hardcore"

protectionLevel = 1

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 3 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = true

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 0 * 1000

deathLostPercent = 7

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

fistBaseAttack = 7

-- Connection config

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 Noobwaria Server!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Noobwaria"

loginMessage = "Welcome to the Noobwaria Server!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "your password"

sqlDatabase = "your database"

sqlFile = "theforgottenserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

-- Deathlist

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

-- Guilds

ingameGuildManagement = false

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

-- Highscores

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 60

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

mapName = "Noob-war.otbm"

mapAuthor = "Zoom Iker"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

-- Startup

startupDatabaseOptimization = false

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

-- Spells

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

-- Outfits

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

 

dataDirectory = "data/"

logsDirectory = "data/logs/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

-- VIP list

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

-- Saving-related

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = false

-- Loot

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

-- Limits

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

reportsExpirationAfterReads = 1

playerQueryDeepness = 2

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

-- Premium-related

freePremium = true

premiumForPromotion = false

-- Blessings

blessings = true

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 10

 

experienceStages = false

rateExperience = 0.25

rateExperienceFromPlayers = 8

rateSkill = 22.0

rateMagic = 10.0

rateLoot = 0.1

rateSpawn = 1

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

-- Experience from players

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

staminaLootLimit = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

-- Global save

globalSaveEnabled = false

globalSaveHour = 8

globalSaveMinute = 0

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

-- Status

statusPort = 7171

ownerName = ""

ownerEmail = "@otland.net"

url = "http://otland.net/"

location = "Europe"

displayGamemastersWithOnlineCommand = false

-- Logs

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outputLog = ""

truncateLogsOnStartup = false

-- Manager

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

-- Admin

adminPort = 7171

adminLogs = true

adminPassword = "otlandbest"

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

 

Já descobri como Obrigado =p

 

ja descobri o problema =p

Edited by xllgokullx
Link to comment
Share on other sites

Peça pra fecharem o tópico(esqueça oq eu falei aqui aqui em baixo)

 

 

sqlType = "mysql"

troque essa linha por essa

sqlType = "sqlite"

 

REP ++?

Edited by Epyrus
Link to comment
Share on other sites

Caso vc vá usar o servidor sem usar site, somente com account manager, apenas mude como mencionado pelo membro acima.

 

Caso vc vá usar com site, precisa de uma database Mysql.

 

Então mantenha seu config.lua assim

 

sqltype = "mysql"

 

E siga esse tutorial que vai te ensinar à colocar o ot on, com database mysql e site.

 

http://www.xtibia.com/forum/topic/157897-tutorialcriando-website-com-xampp/

Link to comment
Share on other sites

×
×
  • Create New...