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

MySQL From nothing to a fully working, secured OT server. [Uniform Server] + [TFS 0.3.6]

Status
Not open for further replies.
Make sure to logout from the game.

Enter phpmyadmin, login to database.

Enter database name of OT in the list to the left of the screen.
(<----)

Then enter "accounts"

Click "Browse"

Look for a line with your account number.

Check the box to mark the line, and click "Edit".

Look for Group ID, you usually see this as 0 or "1" as default, change it to "6"

Scroll down, save.

Enter Players

Browse

Find your player that you want to give "GoD" account, mark line, click edit

look for "Group ID", default is 0 or "1", give it "6".

And save, your done.

Login to your "GoD" account with your "GoD" character.

:)
 
My account is not in the list its only account manager in that list why ?

I have created a accoutn whit a character named admin in game,

What is the problem?
 
Last edited:
Enter your OT server config.lua file

Change sqltype from sqlite to mysql

make sure to have correct connection details for the database in username and password and database name.
Code: 
	[B][COLOR="green"]sqlType = "mysql"[/COLOR][/B]
	[B][COLOR="green"]sqlHost = "localhost"[/COLOR][/B]
	[COLOR="Red"][B]sqlPort = 3306[/B][/COLOR]
	[COLOR="DarkOrange"][B]sqlUser = "otland"[/B][/COLOR]
	[COLOR="DarkOrange"][B]sqlPass = "F9quqSU65DctHJV3"[/B][/COLOR]
	[COLOR="DarkOrange"][B]sqlDatabase = "otland"[/B][/COLOR]
	[COLOR="red"]sqlFile = "forgottenserver.s3db"[/COLOR]
	[COLOR="red"]sqlKeepAlive = 0[/COLOR]
	[COLOR="red"]mysqlReadTimeout = 10[/COLOR]
	[COLOR="Red"]mysqlWriteTimeout = 10[/COLOR]
	[COLOR="green"][B]encryptionType = "sha1"[/B][/COLOR]

GREEN = Write exactly as appear on my config.
ORANGE = Write your phpMyAdmin database username and password. In sqlPass write the automatic generated password!
RED = Don't do anything. :p
Also make sure encryption is sha1! Do not use plain, or md5.

This is very important, if you use Plain, your server may easily get hacked!
 
Thanks, now i have done that but my account dont come up. u know why?
 
Now i se my account but i dont se my character xD
But i did change grup id to 6 like u said, i was offline,

but when i login agen i am not god :O

And yes i have restart the server.
 
has anyone been able to succesfully install Modern AAC on windows 7 64 bit with uniform server?

I have been trying for like 2 days without success. I can easily install with xampp however xampp sux.. Dont wanna get a 32 bit os just to get extra security.

:p
 
Hello agen thanks for this turial its workt for me after a big question time ^_^

Now i have one more problem, server is up and running everything is fine to i changed the server to armonia server as normal is tempel posison wrong for account manager and yes u cna change that in database in phpmyadmin, the problem now is when i try to go in on the webb site its only blank the whole site is just blank,

Do some one know where the problem is?

config and all is right and i am online whit my firt char from the other server but accoun manager can login bequs of this,

I Rep++ for help. ;)
 
1. Make sure the mysql.sql (the mysql schema) fits the schema.

2. If you have added mysql as database type, make sure that you create a new account, a new "god" account, then createe a username on that account, and then enter database and do what I said earlier.

~love~
 
Last edited:
Sticky this please xD. Anyways I'm trying it out now on my Windows 7 computer :)
 
Keep in mind it is not supported by Windows 7 64bit. But if you do get it to work, tell me.

Also if you are using Windows 7 32bit, I am curious if you get it to work. :eek:

I haven't tested that yet.
 
I am using mystic spirit, 2.7 and everything has been going good until i import the database, as there is no schema folder i assume it is forgottenserver.sql what i have to import but when i do so i get
Code: 
Error

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL said: Documentation
#1046 - No database selected

Is there anything i am doing wrong? Is this not compatible with TFS 2.7?

I also find it different in the lua. Should i just use crying damson instead?
 
I could already import it but i still find it alot different in the lua part.
What should i do?
Thanks in advance~
EDIT~ Nevermind, solved thanks alot ZNOTE rep added
 
Last edited:
Hello, it me now i am gonna try me on doing a webb page ^_^

But i cant work it aut cant find a good turial that i understand so if some one here can link or explain how to do it it wold be nice :thumbup:

I rep+ ofc, :)
 
Thanks :D
It's working perferk! BUT...
Do u know how to change which browser to open for the links in uniform?
I kind of hate IE :/ and it's quite annoying to copy and paste the links all the time :p

EDIT:
Btw :D when are you going to create the setup guide for Modern AAC? :D or are you waiting for a new patch?
 
Last edited:
Mini Guide:

To busy today, so can't. :(

But here is a quick guide to do it until I finish the detailed version:

After you have configured Uniform Server properly as I described in this thread.

Download latest rev of Modern AAC

Remove everything in the folder named "www" and put in the Modern AAC files there.

Enter:
UniServer\usr\local\php

Open the file "php" or "php.ini" in a text document and search for:

;extension=php_pdo_mysql.dll

Then remove the (;) so the result is:

extension=php_pdo_mysql.dll

Then click "Stop Uniserver".

Wait 5 - 10 sec, and then click "Start Uniserver".

Then enter website 127.0.0.1 and you will get to modern aac installation website.

After installation, remove everything in www/install.

And it should be working fine. :)
 
Znote said:
Mini Guide:

To busy today, so can't. :(

But here is a quick guide to do it until I finish the detailed version:

After you have configured Uniform Server properly as I described in this thread.

Download latest rev of Modern AAC

Remove everything in the folder named "www" and put in the Modern AAC files there.

Enter:
UniServer\usr\local\php

Open the file "php" or "php.ini" in a text document and search for:

;extension=php_pdo_mysql.dll

Then remove the (;) so the result is:

extension=php_pdo_mysql.dll

Then click "Stop Uniserver".

Wait 5 - 10 sec, and then click "Start Uniserver".

Then enter website 127.0.0.1 and you will get to modern aac installation website.

After installation, remove everything in www/install.

And it should be working fine. :)
Click to expand...

Oh my god! Thanks! :D It's working perfekt now! :D
Rep ++ :D

Btw, a guide simple as this... dunno if ppls can do that now days :D
 
Question

One question. Can I use this tutorial in Ubuntu?? Please answer. THX!!! :thumbup:
 
This is an windows alternative. Check for another guide for ubuntu/debian.
 
Status
Not open for further replies.

Similar threads

mar173
[13.21.13839][RLMAP] Fastest way to run Local Server
Replies
8
Views
3K
Freazy
F
zezin009
Compiling TSF 0.3.6 with Dev C++ for Windows in 2023
Replies
3
Views
1K
pelek2002
P
Epsilons
  • Question
OTClient Stuck on "Please wait : Connecting to login server" (ERROR: got a network message with invalid checksum)
Replies
10
Views
565
Epsilons
Epsilons
Back
Top