Tfs Players

[fokuleh]

well, i have made my char with account manager but there is a problem, where can i edit my char information?, like acces, etc...

 

[Saphira]

in your sql database...

//Saphira

 

[fokuleh]

how to acces to the sql database?, when i acces with phpmyadmin i only see account manager account, but the others don't appear =(

 

[Mokerhamer]

how to acces to the sql database?, when i acces with phpmyadmin i only see account manager account, but the others don't appear =(

Dit u put the correct infno from your phpmyadmin in config.lua? so it can get in?

 

[fokuleh]

what should i put? or change:

---------------------------------------------------------------------
--------  T h e F o r g o t t e n S e r v e r   C o n f i g  --------
---------------------------------------------------------------------

	-- Account Manager
	accountManager = "yes"
	newPlayerChooseVoc = "no"
	newPlayerSpawnPosX = 95
	newPlayerSpawnPosY = 117
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 0

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 20
	killsToRedSkull = 3
	killsToBan = 10
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 10
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"

	-- Commands
	displayGamemastersWithOnlineCommand = "no"

	-- Connection Config
	ip = "127.0.0.1"
	port = 7171
	loginTries = 500
	retryTimeout = 30 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "150"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = 0
	serverName = "Tibia Mochis 8.0"
	loginMessage = "Bievenido A Tibia Mochis 8.0 Server, entra al foro en caso de alguna duda o sugerencia =)!"
	adminLogsEnabled = "no"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- House
	housePriceEachSQM = 1000
	houseRentPeriod = "monthly"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "yes"

	-- Messaging
	maxMessageBuffer = 5

	-- MySQL
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = ""
	mysqlDatabase = "theforgottenserver"
	mysqlPort = 3306

	-- Premium Account
	freePremium = "no"

	-- PVP Server
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Rates
	rateExp = 4
	rateSkill = 4
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	-- Server Save
	serverSaveHour = 1
	shutdownAtServerSave = "no"
	cleanMapAtServerSave = "yes"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "sqlite"
	useMD5Passwords = "no"

	-- Startup
	defaultPriority = "high"

	-- Status
	ownerName = "God Fokuleh"
	ownerEmail = "[email protected]"
	url = "http://Tibia-Mochis.net/"
	location = "Mexico"

---------------------------------------------------------------------
---------------------------------------------------------------------
---------------------------------------------------------------------

and in web when i am trying to make an account the web give me this error:
SQL query failed, and in highscores i only can see the Account manager, but not my other accounts, plz help me ='(

 

[fokuleh]

somebody help!!!!!!!!!!

 

[whiteDevil]

you have to go to http://localhost/phpmyadmin then go to your database and click on the players table

 

[JayBeee]

You must change:

	-- SQL
	sqlType = "sqlite"
	useMD5Passwords = "no"

To:

	-- SQL
	sqlType = "mysql"
	useMD5Passwords = "no"

For the server to save in the mysql-database instead of the sqlite one. The mysql is the one that you're accessing with the phpmyadmin, sqlite is a file in the same directory as your config-file named "forgottenserver.s3db" (default) There it has stored the current information, with the accounts etc.

 

[fokuleh]

no se pudo cargar la extensión mcrypt,<br />por favor revise su configuración de PHP.
----------------------------------
Cannot load mcrypt extension. Please check your PHP configuration.

and the problem continue, i can not see my other accounts, only account manager, and i can not create new accounts: sql query failed! ='( help!!!! plz



Problem fixed, plz close this thread! =)