Knights Problem

[Ferchox]

When knights die or logout ..or paladin, they loose all skills i mean they get back to 10 please help.

 

[demondark]

Problem this in its database.

Probably the id of the player not being created in this skill.

 

[averatec]

Triggers! NO in PhpMyAdmin

 

[Ferchox]

yes Averatec, i check out and the triggers aren't in my phpmyadmin. But when i try to import all data from the Sql sample that comes with tfs appears this:

consult SQL:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;

MySQL says: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1

 

[Zikerus]

phpmyadmin don't let you to add triggers... use console to import database or other program ;]

 

[BarJuice]

I imported my triggers via phpmyadmin, just gotta tell it what the delimiter is