localhost/phpmyadmin Problem

[simkal]

hi i have a problem, my localhost/phpmyadmin doesnt show my account or player:


the server is [8.7] The Forgotten Server v0.2.10 (Mystic Spirit)
i wrote correct in config.lua i odnt know what to do
anyone please help..

 

[ReDe]

I do not understand, specify better problem.

 

[simkal]

look, when i import my database from my server to phpmyadmin, and then i go ingame create acc and then i cant find my acc in phpmyadmin

 

[Anoxi]

then its not correct configured.

 

[simkal]

i did what i did on my 8.54 ot and that worked

 

[Kippetjee]

Or is in mysql Sha1 or in the account wrong temple..

 

[simkal]

read?

 

[ReDe]

you import file of schemas/mysql.sql ?

 

[Mooosie]

write your whole config.lua here. and whats your database named?

 

[simkal]

My database is called: good
here's configlua

-- The Forgotten Server Config

	-- Account Manager
	accountManager = "yes"
	newPlayerChooseVoc = "yes"
	newPlayerSpawnPosX = 137
	newPlayerSpawnPosY = 400
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 2
	newPlayerLevel = 20
	newPlayerMagicLevel = 4
	generateAccountNumber = "no"

	-- Banishments
	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 5

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "no"
	removeChargesFromRunes = "yes"
	removeChargesFromWeapons = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	stairJumpExhaustion = 2000
	animationTextOnHeal = "yes"

	-- Commands
	displayGamemastersWithOnlineCommand = "no"

	-- Connection Config
	ip = "83.251.203.42"
	bindOnlyGlobalAddress = "no"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Forgotten"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"
	levelToCreateGuild = 8

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	housePriceEachSQM = 1000
	houseRentPeriod = "never"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

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

	-- Messaging
	maxMessageBuffer = 4

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

	-- Premium Account
	freePremium = "yes"

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

	-- Rates
	rateExp = 40
	rateSkill = 20
	rateLoot = 5
	rateMagic = 15
	rateSpawn = 2

	-- Real Server Save
	-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. this serversave method
	-- may be unstable, we recommend using otadmin if you want real serversaves.
	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Server saving
	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "sqlite"
	passwordType = "plain"

	-- Startup
	defaultPriority = "high"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

	-- Status
	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"

 

[simkal]

bump

 

[WeZzi]

You need to change:

mysqlPass = "to your phpmyadmin password"
mysqlDatabase = "to your database name"

And

-- SQL
sqlType = "sqlite"

TO:
sqlType = "mysql"

//Regards WeZzi^

 

[simkal]

Thank you soooooooooooooooooooo MUCH WeZzi rep u ;d

 

[WeZzi]

Youre welcome!