skills wont save

[Quickshot]

hi when i train my skills up on the server then log of and on the skills will go to 10 and wont save plz help me to fix this

 

[Pitufo™]

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

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.
READ THIS:
Every new player that is created now will have savable stats.s

 

[Quickshot]

ty, it worked

 

[Pitufo™]

No problem and remember to REP++ me