VIDEO TUTORIAL: From nothing to a fully working OT server, website and shop system

I have got the homepage to work and the game server to work. My problem is that I cant change from sqlType = "sqlite" to sqlType = "mysql" in the config.lua. When I do this my server client just crashes and closes itself. I cant even read the error message. Anyone know what could be wrong? its starting to get really frustrating. ( I've changed localhost to 127.0.0.1 on all places its possible)

can I use this on 8.60

You do not have bad English. I thought the sound quality was perfect. Wasn't too quite, loud, or unclear.
(Too many nabs making non-video tutorials not being specific enough in half of them to follow, its appreciated but come on..)
For the sake of Ot Land, more videos soon please. Rep+ Keep It Up!

Thank you so much so sorry for the necro bump but this helped me out so much loving this tutorial so glad you took the time out to teach the beginners how to run the server

i cant connect to my ip address on the website it gives me this
Failed to recognize your IP address. (Not a valid IPv4 address).

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1
Any help? Plz?

Hello, I whould be really gratefull if someone could help me I have the exact same problem as some some that has posted here and that is when I try to boot-up my OT server using instead of sqlite(default) using mysql it crashes, my OT serv bootup fine with sqlite but when I change to connect to mysql database it just collapse it self, the application closes it self after trying to load items, and I can't even see if there is any Error Message in console. Only difference is that when i change sql host to 127.0.0.1 it still doesn't work.

This is is my configuration that dont let me bootup the ot:
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "whitelightning"
sqlPass = "xxxxxxxxx"
sqlDatabase = "whitelightning"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

This is the configuration that works fine, but it is sqlite, so I cant integrate with my AACZnote site and so on:
sqlType = "sqlite"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "whitelightning"
sqlPass = ""
sqlDatabase = "whitelightning"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

tnecniiv said:

i cant connect to my ip address on the website it gives me this
Failed to recognize your IP address. (Not a valid IPv4 address).

Click to expand...

Use 127.0.0.1 instead of localhost in your browser URL

yha i tried that after thx maybe if someone else has the same problem they will see your post @Znote

Nice Tutorial Znote you taught me a lot about running/hosting a server. Hey I have a 10.1 version of tibia running I was just wondering if your web application would work for it? And I was using uniform server but I switched to xammp since I'm more familiar with it. . Which files or folder in xammp would I extract your web application to? I don't see a "www" for xammp. . I may or may not have deleted it? Your friend Steffan has been helping me a lot but..was just wondering?

Hey znote, I have a problem im using 1.0 and I cant use the !shop command to get items bought in website shop

vingo said:

Hey znote, I have a problem im using 1.0 and I cant use the !shop command to get items bought in website shop

Click to expand...

Use the LUA talkaction script for TFS 0.2, it should also work on TFS 1.0.

Bizzyizking said:

Nice Tutorial Znote you taught me a lot about running/hosting a server. Hey I have a 10.1 version of tibia running I was just wondering if your web application would work for it? And I was using uniform server but I switched to xammp since I'm more familiar with it. . Which files or folder in xammp would I extract your web application to? I don't see a "www" for xammp. . I may or may not have deleted it? Your friend Steffan has been helping me a lot but..was just wondering?

Click to expand...

Znote AAC 1.5 supports TFS 1.0. The developement version is available at github: https://github.com/Znote/ZnoteAAC

I recommend using the latest version of Uniform Server. Not xampp as it is designed for developement purposes not for serious hosting.

Oh im sorry I read that from one of your others posts, thanks anyway I see that you like dota aswell heh.. <- Less known professional player


edit: Do you know how I can hide my sample characters from the hidescores with your aac?

I have the exact same problem as
White Lightning and
litium, altho I screened the exact moment of the Error and it says this

weskler said:

I have the exact same problem as
White Lightning and
litium, altho I screened the exact moment of the Error and it says this

Click to expand...

use 127.0.0.1 instead of localhost

vingo said:

Oh im sorry I read that from one of your others posts, thanks anyway I see that you like dota aswell heh.. <- Less known professional player


edit: Do you know how I can hide my sample characters from the hidescores with your aac?

Click to expand...

Znote AAC dont use sample characters, delete them from admin panel.
It is garbage data from Gesior or Modern AAC.

im having problems, when i try to make an account and try to login i get this in console

Nice tutorial!

Question -

I setup the whole pages, it works great thanks you!

One question is...
When I create an account and then a character, it goes into my database, awesome!
But when I go to login it keeps throwing invalid password, and I have my IP changer to 8.60
I changed in the config file from TFS_02 to the 03..

Am I missing something else?
Thanks in advance <3

I can't log into my server with 1/1... Did exactly what you did...

That wierd when i add forgottenserver.sql on my database and its was a success but the Gui console crash and i dont even have time to see the Problem and i did everything like you.

I dont know its about the Internet Statue.