Temat: [Podstawy] Tworzenie bazy danych MySQL oraz obsługa silnika TFS*

-- The Forgotten Server Config

	-- Account manager
	accountManager = "yes" ---------- Czy ma być włączony AccManager?
	namelockManager = "yes"
	newPlayerChooseVoc = "no"
	newPlayerSpawnPosX = 752 <---------------   Pozycja X AccManagera
	newPlayerSpawnPosY = 742 <----------------  Pozycja Y AccManagera
	newPlayerSpawnPosZ = 6    <------------------Pozycja Z AccManagera
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = "no"

	-- Banishments
	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = "yes"
	killsToBan = 5 <-------------- Ilość fragów do bana.
	maxViolationCommentSize = 200
	autoBanishUnknownBytes = "no"

	-- Battle
	-- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
	-- deathLostPercent set to nil enables manual mode.
	worldType = "non-pvp" <--------------- Typ serwera , możliwe są pvp,non-pvp,pvp-enforced
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1 <-------- Od którego lvla jest Pvp.
	pvpTileIgnoreLevelAndVocationProtection = "yes"
	killsToRedSkull = 3 <------- Ilość fragów do Rs'a
	pzLocked = 60 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = "no"
	removeWeaponAmmunition = "yes"    <------ Czy amucicja się kończy?
	removeWeaponCharges = "yes"
	removeRuneCharges = "yes"    <------- Czy runki się kończą?
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"   <----- Czy mamy dostawać Exp za zabitego gracza
	showHealingDamage = "no"
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = "no"
	oldConditionAccuracy = "no"
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000

	-- Connection config
	worldId = 0
	ip = "127.0.0.1" <--------- Ip serwera.
	loginPort = 7171 <--------- Port 
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"  <------------ Maxymalna ilość graczy
	motd = "Welcome to the Theforgotten Server "  <-------- Co ma się pojawić podczas wchodzenia na Account.
	displayOnOrOffAtCharlist = "no"
	onePlayerOnlinePerAccount = "yes"
	allowClones = 0
	serverName = "Forgotten"
	loginMessage = "Welcome to the Theforgotten Server" <--------- Co ma się pojawić po zalogowaniu.
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"
	forceSlowConnectionsToDisconnect = "no"
	loginOnlyWithLoginServer = "no"

	-- 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'  <------- TUTAJ PROSZĘ ZMIENIĆ NA mysql!
                sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "hasło"   <------- Tutaj podajemy hasło,prosze je zapamiętać!
	sqlDatabase = "theforgottenserver"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	passwordType = "plain"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildManagement = "yes"
	levelToFormGuild = 8
	guildNameMinLength = 4
	guildNameMaxLength = 20

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	buyableAndSellableHouses = "yes"
	houseNeedPremium = "yes"
	bedsRequirePremium = "yes"
	levelToBuyHouse = 1
	housesPerAccount = 0
	houseRentAsPrice = "no"
	housePriceAsRent = "no"
	housePriceEachSquare = 1000
	houseRentPeriod = "never"

	-- Item usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	-- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.
	-- useHouseDataStorage usage may be found at README.
	mapName = "nazwa mapki" <------- Nazwa Mapy
	mapAuthor = "autor"       <------- Autor Mapki
	randomizeTiles = "yes"
	useHouseDataStorage = "no"
	storeTrash = "yes"
	cleanProtectedZones = "yes"

	-- Startup
	-- NOTE: defaultPriority works only on Windows
	defaultPriority = "high"
	optimizeDatabaseAtStartup = "yes"
	removePremiumOnInit = "yes"
	abortOnSocketFailure = "yes"

	-- Miscellaneous
	-- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature,
	-- called "exception tracer" (__EXCEPTION_TRACER__ flag).
	maxMessageBuffer = 4
	kickIdlePlayerAfterMinutes = 15
	allowChangeOutfit = "yes"
	allowChangeColors = "yes"
	allowChangeAddons = "yes"
	disableOutfitsForPrivilegedPlayers = "no"
	bankSystem = "yes"
	saveGlobalStorage = "yes"
	displaySkillLevelOnAdvance = "no"
	spellNameInsteadOfWords = "no"
	emoteSpells = "no"
	expireReportsAfterReads = 1
	promptExceptionTracerErrorBox = "yes"
	storePlayerDirection = "no"
	playerQueryDeepness = 2

	-- Premium-related
	freePremium = "no"
	premiumForPromotion = "yes"

	-- Blessings
	blessingsOnlyPremium = "yes"
	blessingReductionBase = 30
	blessingReductionDecreament = 5

	-- Rates
	-- NOTE: experienceStages configuration is located in data/XML/stages.xml.
	experienceStages = "no"
	rateExperience = 5.0     <-------- Współczynnik EXP
	rateSkill = 3.0      <-------- Współczynnik SKILL
	rateMagic = 3.0 <-------- Współczynnik MAGIC
	rateLoot = 8 <-------- Współczynnik LOOT
	rateSpawn = 1 <-------- Współczynnik SPAWN

	-- 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 = 1000 / 3
	rateStaminaThresholdGain = 4
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = "yes"

	-- Party
	-- NOTE: experienceShareLevelDifference is float number.
	-- experienceShareLevelDifference is highestLevel * value
	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5

	-- 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 = "no"
	globalSaveHour = 8  <------- Co ile godzin ma być global save
	shutdownAtGlobalSave = "yes"
	cleanMapAtGlobalSave = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- Summons
	maxPlayerSummons = 2
	teleportAllSummons = "no"
	teleportPlayerSummons = "no"

	-- Status
	ownerName = ""   <------- Owner serwera
	ownerEmail = "#otland.net"  <------ E-mail właściciela
	url = "http://otland.net/"  <------ Strona właściciela
	location = "Europe"    <----- Lokacja właściciela.
	displayGamemastersWithOnlineCommand = "no"

	-- Logs
	-- NOTE: This kind of logging does not work in GUI version.
	-- For such, please compile the software with __GUI_LOGS__ flag.
	displayPlayersLogging = "yes"
	runeFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = "no"

	sqlType = "sqlite'  <------- TUTAJ PROSZĘ ZMIENIĆ NA mysql!
                sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "hasło"   <------- Tutaj podajemy hasło!

To fix the problems for mysql, phpmyadmin and the xampp directory simply use
=> http://localhost/security/xamppsecurity.php <=   [allowed only for localhost]

UPDATE players SET posx = 793, posy = 1014, posz = 7;

sqlPass = "pass"

mapName = "by Midas"