Windows Connect Database?

[sumpen93]

Hello guys!

Few years ago I was hosting my own Open Tibia server! I have alot of players and it working just fine.
Today I tought why not create a Tibia server like the old days? I started to search for servers for hours to find the perfect one.. Well haven't done that yet but that's not my problem!
I have downloaded many servers to see how it works!
Finally I found a server that seems kind of fun. It's the server the many of us use! cryingdamson 0.3.6 (8.60) V7
I started the server in the map and everything works fine.

Back in the days when I was hosting Tibia servers you diden't need a database! Probably you don't have to use it but I read everywhere that database is good!
hum..<_< I never used a database on my whole life!

Tutorials, websites, otlands and many places I search for database help!
I downloaded a program uniform server. [http://www.uniformserver.com/]
I started apache and mySQL and went and it mad be enter PHPmyadmin website! ahh, this is the database!
I went users and created a new one and made a name and password and that stuff! Then I went to import!

On this server I downloaded was a mapp named Schemas! [In that map: mysql.sql, pgsql.sql and sqlite.sql]

When I went to import I put the file from the server mapp [mysql.sql] and it started to load and it worked just fine!

On the left side I saw accounts, bans, players, all of it!

After all this trouble I went to my config on my server mapp. I wrote in my name, password and all that stuff:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "****" <----- MY PASSWORD ON DATABASE
sqlDatabase = "****" <---- MY USERNAME ON DATABASE USER
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"



I can still login into the game! But here comes to real problem! After I have created a character and reset the server and everything! even the computer I CAN'T SEE ANY ACCOUNT OR PLAYERS IN THE DATABASE! I CAN'T CHANGE ANYTHING!!

Can anyone help me with this? Please!

 

[sn3ejk]

You have to change sqlType for mysql.

 

[sumpen93]

You have to change sqlType for mysql.

When I change that I get error when starting the server!

 

[blazzinn]

i do the same thing everytime i start a server i forget alot of stuff but this forum has always helped me maybe it will help u if u do it step for step

http://otland.net/f479/your-first-open-tibia-server-140934/


also u might have to forward ports to get people to join so u might find this one helpful also

http://otland.net/f138/open-ports-tibia-144797/

this is also something else that might help to

http://otland.net/f16/basics-basic-list-ways-solve-your-problems-quickly-176026/

 

[sumpen93]

You have to change sqlType for mysql.

i cant start the server if i change that..

 

[sn3ejk]

i cant start the server if i change that..

Can you show this error?
Probably nobody here is clairvoyant.

 

[Sirion_Mido]

how did they 2 guys who replied didn't find the problem ?
change this 2 points..

sqlType = "mysql"
sqlDatabase = "YOUR DATABASE NAME"

then you need to delete all this lines , i will give a example

  -- Account Manager

all that green lines you need to delete

 

[Mesmeroo]

You made a new user in phpadmin? Then change

sqluser: root

In

sqluser: the username you entered in your DB

 

[blazzinn]

that should do it

 

[blazzinn]

i see what u done

When I went to import I put the file from the server mapp [mysql.sql] and it started to load and it worked just fine!

instead of putting that file in ur databass put the forgottenserver.sql in there u put the wrong file in the database. so delete ur whole database on ur php admin and click creat new database type in forgottenserver and click creat click import and import the file forgottenserver.sql in the server folder should be there try that and see what happens