Solved Problems from 0

[Ahead]

Hello everyone, it has been a long time since i managed an otserv. Now i come back and i'm not able to remember anything ^^''.

I'm using this: https://otland.net/threads/10-77-tfs-1-2-orts-a-real-map-project.204514/

I've read that it's not possible to have account manager from tfs 1.0, that the only way of creating accounts is from the website. But... if i have no website?. How do i do?. My accounts tab in the db is empty .

Could someone give me the sql query to create an account?. Just to convert it into god and test things X_X.

Thanks in advance!.

 

[WibbenZ]

Use the insert? I think it's called in your phpmyadmin page.
Then fill in the details you feel you need to fill kinda.
If you forgot something that is required by the schema it will throw an error about it.

 

[Ahead]

Oh, hadn't seen that i already had the fields to fill.

Anyway i have created a new column:

Spoiler

*Note: i've added manually "group_id" by comparing with a 0.3.7 TFS db i had. I don't even know if it's needed.*

Despite this, it's shown that username or password is not correct. Server is running 100%, no errors. Client applied with 127.0.0.1.

X_X

Thanks.

 

[Leo32]

In your config.LUA what is your passwordType set to?

Plain?
SHA1?
There is no passwordType?

 

[Ahead]

Yeah, i was looking if it was set on sha1 or something so i had to change it. Anyway there's no passwordtype option in my config.lua:

*Note: I've deleted db info but there's actually filled correctly*

Spoiler

-- Combat settings
-- NOTE: valid values for worldType are: "pvp", "no-pvp" and "pvp-enforced"
worldType = "pvp"
hotkeyAimbotEnabled = true
protectionLevel = 1
killsToRedSkull = 3
killsToBlackSkull = 6
pzLocked = 60000
removeChargesFromRunes = true
timeToDecreaseFrags = 24 * 60 * 60 * 1000
whiteSkullTime = 15 * 60 * 1000
stairJumpExhaustion = 2000
experienceByKillingPlayers = false
expFromPlayersLevelRange = 75

-- Connection Config
-- NOTE: maxPlayers set to 0 means no limit
ip = "127.0.0.1"
bindOnlyGlobalAddress = false
loginProtocolPort = 7171
gameProtocolPort = 7172
statusProtocolPort = 7171
maxPlayers = 0
motd = "Welcome to The Forgotten Server!"
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Forgotten"
statusTimeout = 5000
replaceKickOnLogin = true
maxPacketsPerSecond = 25

-- Deaths
-- NOTE: Leave deathLosePercent as -1 if you want to use the default
-- death penalty formula. For the old formula, set it to 10. For
-- no skill/experience loss, set it to 0.
deathLosePercent = -1

-- Houses
-- NOTE: set housePriceEachSQM to -1 to disable the ingame buy house functionality
housePriceEachSQM = 1000
houseRentPeriod = "never"

-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000

-- Map
-- NOTE: set mapName WITHOUT .otbm at the end
mapName = "forgotten"
mapAuthor = "Komic"

-- Market
marketOfferDuration = 30 * 24 * 60 * 60
premiumToCreateMarketOffer = true
checkExpiredMarketOffersEachMinutes = 60
maxMarketOffersAtATimePerPlayer = 100

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = ""
mysqlPort = 3306
mysqlSock = ""

-- Misc.
allowChangeOutfit = true
freePremium = false
kickIdlePlayerAfterMinutes = 15
maxMessageBuffer = 4
emoteSpells = false
classicEquipmentSlots = false

-- Rates
-- NOTE: rateExp is not used if you have enabled stages in data/XML/stages.xml
rateExp = 5
rateSkill = 3
rateLoot = 2
rateMagic = 3
rateSpawn = 1

-- Monsters
deSpawnRange = 2
deSpawnRadius = 50

-- Stamina
staminaSystem = true

-- Scripts
warnUnsafeScripts = true
convertUnsafeScripts = true

-- Startup
-- NOTE: defaultPriority only works on Windows and sets process
-- priority, valid values are: "normal", "above-normal", "high"
defaultPriority = "high"
startupDatabaseOptimization = false

-- Status server information
ownerName = ""
ownerEmail = ""
url = "https://otland.net/"
location = "Sweden"

Tyty.

 

[Leo32]

TFS uses SHA1 by default from what I can see
When setting your password use a manual SQL QUERY to change the password:

update `accounts` set `password` = SHA1('111') where `id` = 1

 

[Ahead]

Ok, now i can access to my account, thank you so much!.

But now i try to create several characters on the database (manually) and i always have this error:

"Warning: #1364 Field 'conditions' doesn't have a default value".

It doesn't matter what i fill or what i leave blank.

For that reason it's shown (when i pick the character in my character list) that character couldn't be loaded.

SOLVED: Was writing wrong coordinates, wrong id and wrong group_id. Zzzzzz.