Skills being reset?

[Coeco]

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?

 

[R3ignlasting]

are you using eldinworld server?Cuz this is happening to me on eldinworld except mine resets every skill to 10....

 

[rla23]

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

 

[Gangsta-jr]

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.

 

[Coeco]

Thanks for the help but a bit late, updated my Mysqladmin and it works as it should now. +Repped