• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

TFS 1.X+ How to generate database and how to add account manually for admin

BlackPanther_

BlackPanther_

New Member
Joined
Dec 25, 2019
Messages
7
Reaction score
1
Location
New Zeland
This is possible to auto generate empty database for TFS?
This is my output after compiling tfs on my ubuntu

Lua: 
> position.lua [loaded]
>> Loading monsters
>> Loading lua monsters
> #example.lua [disabled]
>> Loading outfits
>> Checking world type... PVP
>> Loading map
> Map size: 2048x2048.
> Map loading time: 1.076 seconds.
[Error - mysql_real_query] Query: SELECT `id`, `owner`, `paid`, `warnings` FROM `houses`
Message: Table 'hellots.houses' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `owner`, `paid`, `warnings` FROM `houses`
Message: Table 'hellots.houses' doesn't exist
[Error - mysql_real_query] Query: SELECT `data` FROM `tile_store`
Message: Table 'hellots.tile_store' doesn't exist
[Error - mysql_store_result] Query: SELECT `data` FROM `tile_store`
Message: Table 'hellots.tile_store' doesn't exist
>> Initializing gamestate
[Error - mysql_real_query] Query: DELETE FROM `players` WHERE `deletion` != 0 AND `deletion` < 1591261943
Message: Table 'hellots.players' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `ip_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1591261943
Message: Table 'hellots.ip_bans' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `market_history` WHERE `inserted` <= 1588669943
Message: Table 'hellots.market_history' doesn't exist
[Error - mysql_real_query] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1591261943
Message: Table 'hellots.account_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1591261943
Message: Table 'hellots.account_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1591261943
Message: Table 'hellots.houses' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1591261943
Message: Table 'hellots.houses' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id`, `sale` FROM `market_offers` WHERE `created` <= 1588669943
Message: Table 'hellots.market_offers' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id`, `sale` FROM `market_offers` WHERE `created` <= 1588669943
Message: Table 'hellots.market_offers' doesn't exist
[Error - mysql_real_query] Query: SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'hellots.market_history' doesn't exist
[Error - mysql_store_result] Query: SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'hellots.market_history' doesn't exist
>> Loaded all modules, server starting up...
> Warning: The Forgotten Server has been executed as root user, please consider running it as a normal user.
>> Forgotten Server Online!

and please let me know how to add character for me manually? :D
 
Sort by date Sort by votes
TFS version? Every TFS version have a clean schema.sql when you download it and about adding an account/player you'll have to follow this.
otland.net

God account on TFS 1.3 + premium, via sql

If you are testing a server locally and just looking to create a new account without having to setup an AAC, these 2 sql queries will do that for you. This is just to help you speed up your work flow :) The username and password is 1/1. 1st thing you want to do is create the account, go into...
otland.net otland.net
and remove the entries which doesn't exist in your server and its value like
offlinetraining_time/offlinetraining_skill
 
Upvote 0 Downvote
Ok, got this, but still i see this:

Ydbxmp5.jpg



Whats the problem?
I configured posx posy posz and id of a town ;d
 
Upvote 0 Downvote
It is so clear check your data\XML\groups.xml and edit your God group to correct one.
 
Upvote 0 Downvote

Similar threads

J
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
571
johnsamir
J
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
589
lursky
L
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
247
ShadowProwl
ShadowProwl
peteralto
  • Question
TFS 1.X+ Lost connection to server during query
Replies
0
Views
220
peteralto
peteralto
WikiArk21
  • Question
Error MySql
Replies
0
Views
213
WikiArk21
WikiArk21
J
  • Question
Guild War tfs 1.5 problem
Replies
0
Views
169
jareczekjsp
J
OTcreator
  • Question
TFS 0.X MySQL [2013] - guild ranks
Replies
1
Views
344
tobi132
T
D
  • Question
Setting up website for OT server
Replies
1
Views
464
Mateus Robeerto
Mateus Robeerto
E
  • Solved
TFS 1.X+ [Error - mysql_store_result] Query: SELECT 'QuestPoints' FROM 'players' WHERE 'id' =8
Replies
2
Views
262
Erna
E
F
  • Question
TFS 1.X+ IOLoginData::loginserverAuthentication
Replies
10
Views
792
ForgottenNot
F
Back
Top