• 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 arent saving

Proland

New Member
Joined
Dec 28, 2008
Messages
116
Reaction score
0
as the title says, Im using tfs 0.3 and after a player relog his skills are gone. how to do so that skills save?

Also axe Fighting saves but other skills like sword/shielding not. HELp

and getting this error by creating an character

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\ots\pot\OTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\ots\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\ots\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\ots\pot\OTS_Player.php on line 1832
 
Last edited:
Try making this:

Thanks SeoxTard and TheGig from ot***ns.net

First, go to: http://localhost/phpmyadmin/

Log in as root with whatever password you picked

Click on your servers database on the left side

Click the SQL button above the database selection

phpmyadmintue18nov0708nn8.png


Where it says Run SQL query/queries on database enter this in the text box below:

SQL:

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 ;



Then click go.
Apparantely, sometimes it shows an error anyway but just disregard that. It should still work.
Every new player that is created now will have savable stats.
 
i got a problem, its also only working for new players, if i check someone who just created new character i see skills with ids 1 to 6, but if i check any high level he got only Skill ids 1 , 2 , 3 , 6

They dont got 4,5 and thats Sword fighting and shielding i think thats why its not saving, anyone know how to fix this?
 
Back
Top