Gelsior Buga

[shadizinho 0]

eu estava seguindo este tutorial

http://www.xtibia.com/forum/topic/134590-totalmente-reformulado-colocando-seu-server-sql-online-site/

 

quando chega na parte Check DataBase connection occore o seguinte erro

 

Check database connection

If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.

Warning: syntax error, unexpected '(' in C:/Pasta de Usuarios/Usuario/Desktop/ot original/Real Server 1.2/config.lua on line 17 in C:\xampp\htdocs\install.php on line 183

Database error. Unknown database type in C:/Pasta de Usuarios/Usuario/Desktop/ot original/Real Server 1.2/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

 

meu config.lua

 

-- The Forgotten Server Config

 

-- Account manager

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 160

newPlayerSpawnPosY = 51

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 1

generateAccountNumber = false

 

-- Unjustified kills

-- NOTE: *Banishment and *BlackSkull variables are >summed up<

-- (dailyFragsToRedSkull + dailyFragsToBanishment) with their

-- *RedSkull equivalents.

-- Auto banishing works only if useBlackSkull set to negative.

-- advancedFragList is not advised if you use huge frags

-- requirements.

redSkullLength = 1 * 24 * 60 * 60

blackSkullLength = 2 * 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

useFragHandler = true

advancedFragList = false

 

-- Banishments

-- violationNameReportActionType 1 = just a report, 2 = name lock, 3 = player banishment

-- killsBanLength works only if useBlackSkull option is disabled.

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 1 * 24 * 60 * 60

killsBanLength = 1 * 24 * 60 * 60

finalBanLength = 1 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

-- Battle

-- NOTE: showHealingDamageForMonsters inheritates from showHealingDamage.

-- loginProtectionPeriod is the famous Tibia anti-magebomb system.

-- deathLostPercent set to nil enables manual mode.

worldType = "pvp"

protectionLevel = 20

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = true

removeWeaponAmmunition = false

removeWeaponCharges = true

removeRuneCharges = true

whiteSkullTime = 5 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = false

showHealingDamageForMonsters = false

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

 

-- Connection config

worldId = 0

ip = "189.32.225.194"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 212

motd = "Welcome to the Styller 8.54-8.57!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Styller"

loginMessage = "Welcome to the Styller World!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

-- Database

-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.

-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.

sqlType = "sql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "321"

sqlDatabase = "esker"

sqlFile = "Database.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

-- Deathlist

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 50

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

-- Highscores

highscoreDisplayPlayers = 10

updateHighscoresAfterMinutes = 3

 

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 60

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 5000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

-- Map

-- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.

-- useHouseDataStorage usage may be found at README.

mapName = "map"

mapAuthor = "Esker"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

-- Startup

-- NOTE: defaultPriority works only on Windows and niceLevel on *nix

-- coresUsed are seperated by comma cores ids used by server process,

-- default is -1, so it stays untouched (automaticaly assigned by OS).

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

-- Muted buffer

maxMessageBuffer = 4

bufferMutedOnSpellFailure = false

 

-- Miscellaneous

-- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature,

-- called "exception tracer" (__EXCEPTION_TRACER__ flag).

-- monsterLootMessage 0 to disable, 1 - only party, 2 - only player, 3 - party or player (like Tibia's)

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

 

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

-- Limits

idleWarningTime = 59 * 60 * 1000

idleKickTime = 60 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

-- Premium-related

freePremium = false

premiumForPromotion = true

 

-- Blessings

-- NOTE: blessingReduction* regards items/containers loss.

-- eachBlessReduction is how much each bless reduces the experience/magic/skills loss.

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

-- Rates

-- NOTE: experienceStages configuration is located in data/XML/stages.xml.

-- rateExperienceFromPlayers 0 to disable.

experienceStages = false

rateExperience = 65.0

rateExperienceFromPlayers = 0

rateSkill = 100.0

rateMagic = 65.0

rateLoot = 3.0

rateSpawn = 1

 

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

 

-- Experience from players

-- NOTE: min~Threshold* set to 0 will disable the minimum threshold:

-- player will gain experience from every lower leveled player.

-- max~Threshold* set to 0 will disable the maximum threshold:

-- player will gain experience from every higher leveled player.

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

-- Stamina

-- NOTE: Stamina is stored in miliseconds, so seconds are multiplied by 1000.

-- rateStaminaHits multiplies every hit done a creature, which are later

-- multiplied by player attack speed.

-- rateStaminaGain is divider of every logged out second, eg:

-- 60000 / 3 = 20000 milliseconds, what gives 20 stamina seconds for 1 minute being logged off.

-- rateStaminaThresholdGain is divider for the premium stamina.

-- staminaRatingLimit* is in minutes.

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

 

-- Party

-- NOTE: experienceShareLevelDifference is float number.

-- experienceShareLevelDifference is highestLevel * value

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

 

-- Global save

-- NOTE: globalSaveHour means like 03:00, not that it will save every 3 hours,

-- if you want such a system please check out data/globalevents/globalevents.xml.

globalSaveEnabled = false

globalSaveHour = 3

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

 

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

 

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

-- Status

ownerName = "Styller x Soft"

ownerEmail = ""

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

-- Logs

-- NOTE: This kind of logging does not work in GUI version.

-- For such, please compile the software with __GUI_LOGS__ flag.

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

eu uso o Real server 1.2 8.57

[gabrielcep 0]

Você na opção de por sqlite ou mysql vc colocou assim "sql"

 

 

 

Se você for usar SQL vc tem que por sqlite

Se você por usar MYSQL vc tem que por mysql

 

e vc tb precisa remover as frases da config lua.,para seu server obter um site é preciso ter um ot em MYSQL! ai vc temq ue pesquisar no goolgle e achar como passar pra mysql,baixar xampp etc

 

 

ficando assim:

 

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 51
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 1
generateAccountNumber = false


redSkullLength = 1 * 24 * 60 * 60
blackSkullLength = 2 * 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
useFragHandler = true
advancedFragList = false

notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 1 * 24 * 60 * 60
killsBanLength = 1 * 24 * 60 * 60
finalBanLength = 1 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "pvp"
protectionLevel = 20
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 5 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
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 = "189.32.225.194"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 212
motd = "Welcome to the Styller 8.54-8.57!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Styller"
loginMessage = "Welcome to the Styller World!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false


sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "321"
sqlDatabase = "esker"
sqlFile = "Database.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

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


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


highscoreDisplayPlayers = 10
updateHighscoresAfterMinutes = 3


buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 60
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 5000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500


mapName = "map"
mapAuthor = "Esker"
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 = false
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false


ghostModeInvisibleEffect = false
ghostModeSpellEffects = true

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


freePremium = false
premiumForPromotion = true

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


experienceStages = false
rateExperience = 65.0
rateExperienceFromPlayers = 0
rateSkill = 100.0
rateMagic = 65.0
rateLoot = 3.0
rateSpawn = 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 = 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 = 3
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50


maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false


ownerName = "Styller x Soft"
ownerEmail = ""
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false


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

 

 

 

Repp++

Editado Junho 24, 2010 por gabrielcep