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

Skills being reset?

Coeco

Banned User
Joined
Apr 21, 2008
Messages
31
Reaction score
2
Location
Sweden
Recently started an open tibia server and i had one or two paladins saying that their distance level was getting reset everytime they died, i checked it out and it seems to only be happening with the distance level.. Does anyone know a fix to this?
 
how to fix the skills

I am going to tell you how to fix the skills that is resetting after you log out and log back in.


1)goto phpMyAdmin | MySQL Database Administration Tool | phpMyAdmin | MySQL Database Administration Tool | phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net and download the newest version (3.0.0 At the moment)
2)Open you xampp folder c:xampp and goto the phpmyadmin folder open the rar or zip files and extract the files into the php file let EVERYTHING overwrite eachother.
3)Restart Your Xampp using Xampp_restart.exe
4)login to your phpmyadmin (phpMyAdmin 2.9.1.1-Debian-8) if you do not yet have a password set goto http://localhost/security/xamppsecurity.php .
5)login and create a database. Open the database and import the theforgottenserver.sql file
6) Your skills should begin to save once people create there accounts
 
Or just go to localhost/phpmyadmin click on ur database and go to "SQL" at the top

Paste the following Code

DELIMITER |

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

DELIMITER ;

Now execute and it should work from now on.
 
Back
Top