accounts dont appear in database

[gold6nboy]

basicly i just made the ot today im a total newbie and when i make accounts in-game they do not appear on my database i want to make a god but i need an aoccount to edit or accounts i mak eon the database i cant log into the game with any idea whats wrong ?

 

[muffmo]

you can login on an account you make in-game? If so, check config.lua if your really looking at the right database

 

[shakasword]

are you using phpmyadmin? if that's the case you need to open the table "accounts" of your database and then hit the button "examine" or "examinate" (I use spanish version and don't know what says in english), which is the first tab you get in the right side. (sorry for my english :S)

 

[gold6nboy]

i dont see an examine button oneh right and i have slected th etable "ot" in the configuration which is the name i have to the table on phpmyadmin. i can make accounts in game log in and walk around but they jus dont appear on the table i make sure the server saves and i refrsh the site >.<

 

[Cykotitan]

Config.lua

sqlType = "mysql"

Make sure you setup the rest of the settings correctly

 

[gold6nboy]

-- The Forgotten Server Config

-- Account Manager
accountManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = -1232
newPlayerSpawnPosY = 697
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 100
newPlayerMagicLevel = 0
generateAccountNumber = "no"

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

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

-- Commands
displayGamemastersWithOnlineCommand = "no"

-- Connection Config
ip = "82.37.133.123"
port = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = "1000"
motd = "Welcome to the Forgotten Server!"
onePlayerOnlinePerAccount = "yes"
allowClones = 0
serverName = "Forgotten"
loginMessage = "Welcome to the Forgotten Server!"
adminLogsEnabled = "no"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"

-- Deathlist
deathListEnabled = "yes"
maxDeathRecords = 5

-- Guilds
ingameGuildSystem = "yes"

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

-- Messaging
enableRuleViolationReports = "yes"
maxMessageBuffer = 4

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "baconbits"
mysqlDatabase = "OT"
mysqlPort = 7171

-- Premium Account
freePremium = "yes"

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

-- Rates
rateExp = 5
rateSkill = 3
rateLoot = 10
rateMagic = 10
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 = 3
saveGlobalStorage = "no"

-- Spawns
deSpawnRange = 2
deSpawnRadius = 50

-- SqLite
sqliteDatabase = "forgottenserver.s3db"

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 7171
sqlUser = "root"
sqlPass = ""
sqlDatabase = "ot"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 60
passwordType = "plain"

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

-- Startup
defaultPriority = "high"

-- Status
ownerName = ""
ownerEmail = "@otland.net"
url = "http://otland.net/"
location = "Europe" that the config but i took out pas son purpose

 

[ExibeR]

Remove your password gold6nboy