PSMList 0.4.0 PSM-040-057

UPDATE ship s SET idauthor = null WHERE s.idauthor is not null;

DELETE FROM reset_password_request WHERE expires_at < NOW();

in the crew entity, make one update with the images commented, then decomment the images and update again, yes this is stupid but I don't have a better solution<br/><br/><br/>INSERT INTO `cache_values_generic` (`id`, `discordservername`, `discordservericon`, `discordmembercount`, `discordcacheexpiration`) VALUES (NULL, 'default', 'icon', '0', '2023-07-01 00:00:00')

empty the tables keyword_target and keyword_category<br/><br/><br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(1, 'Firepower', '2022-06-21 23:58:00', NULL, 'gun', 'Improvement to attack efficiency.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(2, 'Cargo', NULL, NULL, 'boxes-stacked', 'Affect or uses cargo spaces.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(3, 'Crew Buff', NULL, NULL, 'user-plus', 'Improves crew effectiveness or ease of use.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(4, 'Self Debuff', NULL, NULL, 'user-slash', 'Negative abilities inflicted to self.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(7, 'Boarding', NULL, NULL, 'person-walking-arrow-right', 'Directly tied to boarding actions.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(8, 'Treasure', NULL, NULL, 'crown', 'Linked to unique treasures and coins.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(9, 'Other', NULL, NULL, 'list', 'Not fitting other categories.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(10, 'Mobility', NULL, NULL, 'feather-pointed', 'Affects the capability of a ship to get around.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(11, 'Special', NULL, NULL, 'star', 'More complex, intricate or conditionned passive unique abilities.');<br/>INSERT INTO kw_category (id, name, datecrea, datemodif, iconfa, description) VALUES(12, 'Defense', NULL, NULL, 'shield-halved', 'Increase in overall survavibility.');

INSERT INTO kw_target (id, name, datecrea, datemodif, description) VALUES<br/>(1, 'Self', '2022-06-01 10:36:12', NULL, 'Affects the game piece the effect originates from.'),<br/>(2, 'Ally', '2022-06-01 10:36:12', NULL, 'Affects game pieces from the same team.'),<br/>(3, 'Enemy', '2022-06-01 10:36:12', NULL, 'Affect any game piece not in the team of the caster.');

Run the tool to update all the counts in expansion<br/><br/>don't forget to retrieve the avatar images

set to null all the forts that have a speed value (basemove)