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

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

Znote, Mysql is deprecated in php, i suggest to improve to PDO or to Mysqli, specialy if you are updating it.

Thanks a lot too for always give support and update your AAC and, in general, for help this comunity.


¡Cheers up!
 
Obsdark said:
Znote, Mysql is deprecated in php, i suggest to improve to PDO or to Mysqli, specialy if you are updating it.

Thanks a lot too for always give support and update your AAC and, in general, for help this comunity.


¡Cheers up!
Click to expand...
Latest version of Znote AAC is here:
https://github.com/Znote/ZnoteAAC

mysql libs was upgraded to mysqli a long time ago.
 
when i enter local host it says Failed to connect to MySQL: (1045) Access denied for user 'tfs10'@'localhost' (using password: YES)
  1. Import the below schema to a TFS database in phpmyadmin:
  2. Edit config.php with correct mysql connection details.
 
Heroman said:
when i enter local host it says Failed to connect to MySQL: (1045) Access denied for user 'tfs10'@'localhost' (using password: YES)
  1. Import the below schema to a TFS database in phpmyadmin:
  2. Edit config.php with correct mysql connection details.
Click to expand...

Use 127.0.0.1

Maziajka said:
Does all this works also with new versions like 10.77 or whatever?
Click to expand...
Yes.
 
im sorry what do you means with use 127.0.0.1?

where should i write it?
 
Heroman said:
im sorry what do you means with use 127.0.0.1?

where should i write it?
Click to expand...

Instead of localhost.
In config.php, config.lua and on users/priviledges in phpmyadmin for the database. And in your browser to visit the site.
 
Znote said:
Instead of localhost.
In config.php, config.lua and on users/priviledges in phpmyadmin for the database. And in your browser to visit the site.
Click to expand...
aha thankyou mate <333

Znote said:
Instead of localhost.
In config.php, config.lua and on users/priviledges in phpmyadmin for the database. And in your browser to visit the site.
Click to expand...
i made it 127.0.0.1 and still getting that erorr
 
Last edited by a moderator:
Hello, so I have been following this guide, noticing a few differences here and there, and now im stuck. First difference: in the config.lua file he change a sqlite to mysql, in my config.lua there isnt even a text saying sqlite. He also changes the password type to sha1 or w.e, that was also something I could not do. I was able to get the server launched anyways. Now I am stuck trying to log in, it is just saying account name or password incorrect. and when I look at my localhost it doesnt look anywhere near the same as his, and I can't seem to find a way to set the acc name/password to what I want it as. another thing I noticed is that in my config.lua he has an account manager setup in his. mine does not have this. I downloaded TFS 1.1 for this. Rather then his version, BTW.
 
Oneeyedlarry said:
Hello, so I have been following this guide, noticing a few differences here and there, and now im stuck. First difference: in the config.lua file he change a sqlite to mysql, in my config.lua there isnt even a text saying sqlite. He also changes the password type to sha1 or w.e, that was also something I could not do. I was able to get the server launched anyways. Now I am stuck trying to log in, it is just saying account name or password incorrect. and when I look at my localhost it doesnt look anywhere near the same as his, and I can't seem to find a way to set the acc name/password to what I want it as. another thing I noticed is that in my config.lua he has an account manager setup in his. mine does not have this. I downloaded TFS 1.1 for this. Rather then his version, BTW.
Click to expand...
He is using 0.2.1.x After the release of TFS 1.0 they removed SQlite and Account manager. Hit me up if you need setuping Znoteacc and TFS 1.x
 
Is this up to date for 1.1 TFS? Or will a bunch of the tutorial not make sense/look different for TFS 1.1

Edit:
No worries about this anymore @Colors was nice enough to spend a bunch of time last night helping me with all the setup :)
 
Last edited by a moderator:
Okay so I've been following this tutorial and I successfuly made a website however, I got lil questions.
First,
When I was importing the sql thing to create tables this is what I got after hitting GO:
Code: 
Error
SQL query:


CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
MySQL said: Documentation

#1005 - Can't create table 'serv.znote_guild_wars' (errno: 150) (Details…)

EDIT:
The /t command stopped working, I haven't change anything about the command, this is the error:
Code: 
...teleporttown.lua:38: attempt to concatenate field '?' (a nil value)
...
 
Last edited:
70011983 said:
Okay so I've been following this tutorial and I successfuly made a website however, I got lil questions.
First,
When I was importing the sql thing to create tables this is what I got after hitting GO:
Code: 
#1005 - Can't create table 'serv.znote_guild_wars' (errno: 150) (Details…)
Click to expand...

What message do you get when you click on "Details..." ?
My guess is that it fails to create znote_guild_wars table because it depends on your regular guild_wars table. (FOREIGN KEY (`id`) REFERENCES `guild_wars`), which need to exist before you import this.
 
Great video tutorial, not easy doing this in English while you're from Norway, this helped me alot!
++
 
My OT is slowly getting closer to being playable. Running [8.60] The Forgotten Server 0.3.6 (Crying Damson) V8 and the map I'm using is: [8.60] Tracked Tibia Map (RME 2.1)
Current status is that most NPC's are dysfunctional and special objects such as levers etc won't work but apart from that, most things are working nicely. I've recieved lots of help form a person from otland (I think it's @Nottinghster but I'm not completely sure since I never asked in Skype).

Anyway, on to my current problem: (I thought it'd fit in this thread since I used the guide in here to set up the page, sorry if it's in a bad place ^^;)
I've set up my home page just like in this video but now I'd like to edit a few areas in it and I have no clue where to do this.
I'd like to set the characters which are created on the home page to level 1 and their starting location to Rookgaard. (They're currently being created at level 8 in Ab'dendriel)
Other areas of the page, such as the download section suggests downloading client version 10.41, while I'm running 8.60 so I'd also like to change this.

More about my current status (unnescessary for this thread)
I really, really need to get the oracle to work. Any help with this is very very appreciated! (The same goes for the promotion from Druid, Sorc, Knight or Pala to ED, MS, EK or RP)
Another critical thing to get done is setting up more NPC's at Rookgaard so they start working (Al Dee is highest on the priority list but I think I could do this by myself...)
The Fibula key can be obtained from Simon the Beggar but I don't know how I can link it to the door inside the dungeon. The door is currently unlocked.
 
When I import the SQL at 21:32 it gives me this error:

fad3922008409c590d918d8688429a91.png


Can someone help me?

Well I see that the tables exist. but don't know what the problem then is.
 
LordVissie said:
When I import the SQL at 21:32 it gives me this error:

fad3922008409c590d918d8688429a91.png


Can someone help me?
Click to expand...
Remove the part with znote_guild_wars

And add this

Code: 
CREATE TABLE `guild_wars` (
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`enemy_id` INT NOT NULL,
`begin` BIGINT NOT NULL DEFAULT 0,
`end` BIGINT NOT NULL DEFAULT 0,
`frags` INT UNSIGNED NOT NULL DEFAULT 0,
`payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`), KEY `status` (`status`),
KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
 
Tarek1337 said:
Remove the part with znote_guild_wars

And add this

Code: 
CREATE TABLE `guild_wars` (
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`enemy_id` INT NOT NULL,
`begin` BIGINT NOT NULL DEFAULT 0,
`end` BIGINT NOT NULL DEFAULT 0,
`frags` INT UNSIGNED NOT NULL DEFAULT 0,
`payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`), KEY `status` (`status`),
KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
Click to expand...
Thank you :p

Euhm.. Also a thingy maybe you can help me with it. It says
75714b454f9212a394b60f24e623c6bc.png
but I'm online with my char and my brother and 2 friends of me also have a account it only sees the account manager.

I also cannot login on the server with the account I already had before I maked the site.
When I create a account on the website I cannot login with it on my server.
 
Last edited by a moderator:

Similar threads

TheSeviest
The state of Dragon Ball OT servers (as for 2024)
Replies
6
Views
1K
Tofame
Tofame
Back
Top