This mod will set any new characters skill to the determined amount in each IF statement. The idea here is for skills that are not "gainable" or should be set higher because of the early alpha nature of the game.
Since this uses a trigger BEFORE INSERT on the skills table, any additional skill changes BEFORE INSERT at character creation should be put in this trigger and not a separate one as SQL will not allow it.
- Code: Select all
delimiter $$
CREATE TRIGGER `t_set_new_skills`
BEFORE INSERT ON `skills`
FOR EACH ROW BEGIN
/* Set Piety to 30 so character can pray without needing to pray for homecoming several times */
IF (New.SkillTypeID = 54 and New.SkillAmount < 300000000) then
set New.SkillAmount = 300000000;
end if;
/* Set Warhorse handling to 60 since it is not implemented yet */
IF (New.SkillTypeID = 26 and New.SkillAmount < 600000000) then
set New.SkillAmount = 600000000;
end if;
END;
$$
Pretty straight forward. And if anyone complains that they need the skill points spent in these, they have the option to remove the skill via the down arrow on their sheet.