• 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!

[7.4, 7.8, 7.92, 8.0] Sabrehaven.com based on Nostalrius 7.7 fork

Hello,

i downloaded the master sabrehaven server and otcv8 client, however when i try to log in it loads my character and when i enter the character it comes up with the following error;

Connection failed. (ERROR 1214)

but no error comes up within the console?

I got all my ports forwarded but still nothing.

Does anyone know what causes this error and hopefully try and assist me to fix it please?

Kind Regards

3llis
Post automatically merged:

View attachment 73005

all works, i see my character list but i can't login - connection failed. error 1214 where is the problem?
Post automatically merged:

View attachment 73005

all works, i see my character list but i can't login - connection failed. error 1214 where is the problem?
Hello,

How did you manage to fix this issue? I have the same issue and I have all my ports open 7171 and 7172 and some others but still unable to connect, I were wondering if you could help me by saying what your fix was.

Thanks in advance.

3llis
 
Last edited:
can someone help me with this error? as soon as I try to login to my character the server returns this message

1675020403916.png
 
Do we have a fully working .sql schema for this server possibly?

The .sql files does not work with the server.
It is missing market history and other things, just error out on repeat.

same problem 8.0 version
 
All you have to do is import the market_history/offer tables to your database.

Lua:
CREATE TABLE IF NOT EXISTS `market_history` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int NOT NULL,
  `sale` tinyint NOT NULL DEFAULT '0',
  `itemtype` smallint unsigned NOT NULL,
  `amount` smallint unsigned NOT NULL,
  `price` bigint unsigned NOT NULL DEFAULT '0',
  `expires_at` bigint unsigned NOT NULL,
  `inserted` bigint unsigned NOT NULL,
  `state` tinyint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `player_id` (`player_id`, `sale`),
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int NOT NULL,
  `sale` tinyint NOT NULL DEFAULT '0',
  `itemtype` smallint unsigned NOT NULL,
  `amount` smallint unsigned NOT NULL,
  `created` bigint unsigned NOT NULL,
  `anonymous` tinyint NOT NULL DEFAULT '0',
  `price` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

cant add it, error :/ "(Error code: 150 "Foreign key constraint is incorrectly formed")"

And i cant make account on znote :/ ver 8.0
 
Last edited:
Am I stupid or something? Havent messed around with ots in over 10 years, Where is the .exe? or do I need to download something extra?
 
Am I stupid or something? Havent messed around with ots in over 10 years, Where is the .exe? or do I need to download something extra?
You're gonna have to compile to get the .exe. Here is a full guide on how to do so and also some more useful information (note that this tutorial is 2 part)
 
Guys which acc maker u use? Znote doesnt work for this database..
 

What is Sabrehaven​

Link to repo: GitHub - ErikasKontenis/SabrehavenServer (https://github.com/ErikasKontenis/SabrehavenServer)

Overall I feel like I have contributed to open tibia too little and worked too much in private as compared with other developers I see and respect so in return I wish to give everything I took. And I wish you the best use of the Sabrehaven server and its features. Server is based on the Nostalrius fork which uses original cipsoft resources which were leaked- however I would say this is super expansion features wise than Nostalrius fork I have started with and there we have had lots of old crash bugs fixed like aleta sio regex crash bug, creatures talk for no spectators crash bug fix and etc. All in all, I will try to make a little documentation for you. To start with, take a look at the Good reads for you about my and Sabrehaven life:

Sabrehaven features or whats new not in the Nostalrius fork​

  • 7.8-8.0 cities and quests including POI, INQ and other.
  • Outfits, Outfit Addons, Mounts, Shaders, Auras, Wings...
  • Market system.
  • Built in client shop system.
  • Offline training implementation.
  • Stamina implementation.
  • Guild wars with bounties implementation.
  • Quest log support.
  • And quite many more for you to discover including many bugfixes.

How to find things in this mess​

The very first and the very important thing is to take a look at the commit history! You can find the whole progress of the development which may be very useful for you. Now lets speak about branches:
Compile the sources just as you would compile any other TFS server. Here is also sabrehaven.sql which you must use to create clean schema and little schema changes for znoteAAC support sabrehaven_znote.sql.

Info regarding Sabrehaven 8.0​

  • You should use 800OTClient folder to login with the very specific OTClient which is based OTCv8
  • There is the most majority of the new cool features: mounts and shaders, in-game shop system, market system (there is a little snipper in www library to generate json for items), colourful loot message based on items.srv cost property, the implementation of inq, svargrond arena and other cool things. However many things are missing like no mount outfits for all outfits except citizen outfit, majority of items missing its description in items.srv.

Info regarding Sabrehaven 7.92​

It is quite precise replica of how 7.92 tibia worked only with original cipsoft client and it does not contain too much custom features.

Info regarding Sabrehaven 7.8​

It is supreme replica of 7.8 server- I was taking care of the every detail how the map and features differ from leaked 7.72 and 7.8 however didin't receive too much interest from players and I though 7.9 with POI has to be the thing I need to make server great success. Only 7.8 original client required to login.

Info regarding Sabrehaven 7.4​

Nothing much to say- wasn't a big success, it is basically a copy of 7.92 sabrehaven but without hotkeys and map has deleted PZs in boats to abuse newbies. And good old uh trap and other traps to abuse the newbies even more. Login with OTCv8.

The little QA session for you because I know what you want to ask​

Sabrehaven Tools​

Credits​

  • Erikas Kontenis for the Sabrehaven Platform
  • CustomTibia OTLand user for the mapping 8.0 custom areas
  • Nostalrius and TheForgottenServer Team
  • Maybe Cipsoft too for its resources and the whole game? Idk :)

Some pictures from in-game​

bank color_loot ingameshop inq market
how to work with otclient edubart redemption???
View attachment 73257
 
Solved!

following this tip:

I recommend you to add these codes to the engine, to compat otcv8 with this distro :)!


how use this classic client in sabrehaven ?
 
Back
Top