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

[SQL] Problem with skills save.

H3xed

New Member
Joined
Sep 28, 2007
Messages
93
Reaction score
2
Location
Poland
Hello !

I make DB on old PMA version and now have a problem with skills save.
When i sew problem with skills save i update my PMA and want add triggers (code on down)

PHP:
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 ;

But while adding is this error:

PHP:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpmyadmin/libraries/import/sql.php on line 99

While make a new DB triggers be adding without errors, on this time i have 700 players and can't make new DB ;/

Maybe someone know how i can make this ?
 
Back
Top