PSMList 0.4.1 PSM-041-062
Général
| Ordre affichage : | 56 | Création : | 05/07/2023 14h35 |
| Index BL : | 62 | Modification : | 30/08/2023 11h14 |
| BL : | PSM-041-062 | ||
| Source : | Aucune | Soeurs : | - |
Dev
| Fin dev : | D (Done) | Ticket : | - |
| Contrôle dev effectué : | Fiche : | - | |
| C.Qualif. : | #FF0005 | ||
| Activé : | Icône FA : | Par défaut | |
| Contact : | ARS - Arshellan | Qualification : | Nouveauté |
| Répartition : | - | Module : | Custom |
| Dev : | ARS - Arshellan | Sous module : | Ship |
| Provenance : | 0.4.1 New | Constat : | - |
| Début : | S.35 | Charge j. : | - |
| Fin : | S.35 | Délai j. : | - |
| Priorité : | - | Pokercard : | - |
| Estimatif j. : | - | ||
| Description : | Being able to move a ship to another spot in a custom expansion. Includes modes, push all, push minimal and swap places | ||
| Texte Commit : | - | ||
| Description client : | You can now move around items in your expansions. See the complete documentation about it ARTICLE_LINK | ||
Client
| Fascicule : | Ne pas communiquer : | ||
| Alerte Mailing : |
PreP
| Statut PreP : | OK - Validé | Testeur : | ARS - Arshellan |
Discussion
run this after the DB update<br/><br/>UPDATE ship s SET s.numidint = s.numid;<br/>UPDATE crew c SET c.numidint = c.numid;<br/>UPDATE treasure t SET t.numidint = t.numid;<br/>UPDATE equipment eq SET eq.numidint = eq.numid;<br/><br/>it will raise warnings, they can be ignored
ou bien alternativement<br/><br/>UPDATE ship s SET s.numidint = s.numid WHERE LENGTH(s.numid) = 3 AND s.numid REGEXP '^[0-9]+$';<br/>UPDATE crew c SET c.numidint = c.numid WHERE LENGTH(c.numid) = 3 AND c.numid REGEXP '^[0-9]+$';<br/>UPDATE treasure t SET t.numidint = t.numid WHERE LENGTH(t.numid) = 3 AND t.numid REGEXP '^[0-9]+$';<br/>UPDATE equipment eq SET eq.numidint = eq.numid WHERE LENGTH(eq.numid) = 3 AND eq.numid REGEXP '^[0-9]+$';
for the rarity<br/><br/><br/>UPDATE rarity SET usedonequipment = '0' WHERE rarity.id = 1;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 2;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 3;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 4;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 5;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 6;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 7;<br/>UPDATE rarity SET usedonequipment = '1' WHERE rarity.id = 8;