Problem z sql

[ganar24]

siema ostatnio się nudzę i chciałem odpalić ots 8.6

pobrałem xampp-a 1.7.4 

acc maker 0.3.6

i jakiś silnik tfs

 

i tu mam problem po wrzuceniu plików acc makera do xampp\htdocs i zmienieniu w config.ini install = "no"

server_path  na install = "yes" server_path 

 

wejściu na http://localhost/install.php w przeglądarce mam taki błąd - 

 

http://imgur.com/9yl2SuE

 

nie jestem informatykiem, ktoś coś pomoże 

[Firiux]

Nie robiłem dużo na xampie ale może wystarczy obadać te linie ze zdjęcia (notepad++). Upewnij się że podałeś dobrą ścieżkę plików i czy twój acc maker jest kompatybilny z silnikiem.

A najlepiej zrobisz jak postawisz na uniserver, polecam.

Edytowane 4 Stycznia 2017 przez Firiux

[rafaeru]

https://github.com/gesior/Gesior2012/tree/TFS-0.3.6_and_0.4_to_rev_3703

tu masz oficjalnego gesiora pod 0.3.6 - 0.4.0 (8.6 teoretycznie )

[DJkamilo]

mam taki problem ze robi kona ale niema ich w bazie  jak mam to naprawic 

[rafaeru]

w config.lua zmien sqlType z 'sqlite' na 'mysql'

[DJkamilo]

Mam 

-- The Forgotten Server Config

 

-- Account manager

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerChooseTown = false

newPlayerDefaultTownId = 1

newPlayerLevel = 1

newPlayerMagicLevel = 0

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.

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

 

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

 

-- Battle

-- NOTE: showHealingDamageForMonsters inheritates from showHealingDamage.

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

-- deathLostPercent set to nil enables manual mode.

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

healthHealingColor = COLOR_GREEN

manaHealingColor = COLOR_DARKPURPLE

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

fistBaseAttack = 7

optionalWarAttackableAlly = false

 

-- Connection config

worldId = 0

ip = "Ip Moge podac na pw"

loginPort = 7171

gamePort = 7172

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Welcome to the Forgotten Server!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Forgotten"

loginMessage = "Welcome to the Forgotten Server!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

enableCast = true

 

-- Database

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

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

-- encryptionType can be plain, md5, sha1, sha256, sha512 or vahash.

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = ""

sqlFile = "theforgottenserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

-- Deathlist

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = true

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

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

 

-- Exhaust

onBuy = 500

onSell = 500

changeOutfit = 500

 

-- Map

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

mapName = "forgotten.otbm"

mapAuthor = "Komic"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

 

-- Process

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

-- niceLevel works only on *nix systems

-- 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"

 

-- Startup

startupDatabaseOptimization = true

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

skipItemsVersionCheck = true

 

-- Spells

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

 

-- Outfits

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

 

-- Miscellaneous

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

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

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

-- useHouseDataStorage usage may be found at README.

saveGlobalStorage = true

useHouseDataStorage = true

storePlayerDirection = false

 

-- Loot

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

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

 

-- Ghost mode

ghostModeInvisibleEffect = true

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

 

-- Blessings

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

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

blessings = true

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

 

-- Rates

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

-- rateExperienceFromPlayers 0 to disable.

experienceStages = false

rateExperience = 5.0

rateExperienceFromPlayers = 0

rateSkill = 3.0

rateMagic = 3.0

rateLoot = 2.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 multiplying every second of logged out time, eg:

-- 60 * 1000 / 3 = 20 seconds, what gives 1 stamina minute for 3 being logged off.

-- rateStaminaThresholdGain is dividing in case the normal gain (that is

-- multiplied by rateStaminaGain, btw.) passed above threshold, eg:

-- 60 * 1000 / 3 = 20 / 4 = 5 seconds (3 * 4 = 12 minutes for 1 stamina minute).

-- staminaRatingLimit* is in minutes.

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

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

-- NOTE: managerPassword left blank disables manager.

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

 

-- Admin

-- NOTE: adminPassword left blank disables manager.

-- Set to anything if you set adminRequireLogin to false.

-- adminEncryption available options: rsa1024xtea;

-- remember to set correct data!

adminPort = 7171

adminLogs = true

adminPassword = ""

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

[rafaeru]

opisz to dokładniej

[DJkamilo]

 jak zaloze konto  to nimy dodaje do baze ale ani na acc anie na otsa nie moge wbic  teraz mam Otsa Off 

podam ip  Otsa  195.64.158.42 zobacz ta sie zalozyc do bazy dodaje ale zalogowac sie nieda 2 lata juz otsa nie robie  mam to na maszynie

[rafaeru]

to moze masz encryption na stronie np. sha1 a w silniku plain

[DJkamilo]

jezeli o hasla to sa kodowana 

[rafaeru]

ja zrobiłem normalnie konto, chara i sprawdziłem jest dodany. 

[DJkamilo]

lol

 a nie dzialalo 

[DJkamilo]

a zaloguj sie na otsa 

[DJkamilo]

na otsa  Nie można sie wbić  kurde niewiem czemu pomusz

[DJkamilo]

Ok naprawilem

[Marchwj]

Ok naprawilem

Napisz jak, może ktoś w przyszłości będzie miał podobny problem. 

[sebucha]

mial ktos podobny problem przy robieniu konta? 

wyskakuje mi taki blad jak wchodze w account przez stronke

Edytowane 13 Grudnia 2021 przez sebucha

[Myrors93]

Dnia 13.12.2021 o 01:34, sebucha napisał:

mial ktos podobny problem przy robieniu konta? 

wyskakuje mi taki blad jak wchodze w account przez stronke

Trochę odkopałem, ale może komuś się przyda.

Błąd informuje o błędnych danych logowania do bazy danych. Sprawdź w pliku config co masz wpisane.I czy XAMPP jest prawidłowo uruchomiony.