Maintenance

[Yay]

This is just meant as an aggregate thread, where changes/fixes to Storm are noted that are too small to make a separate announcement.

• Remove L45 SuperiorCalls (Animal, Insect, Reptile) spells and remove them from Beastcraft spell line
• Remove 5 redundant non-existent reptile charm spells from Beastcraft spell line
• Change serverproperty LOOTGENERATOR_DRAGONSCALES_NAMED_COUNT to 2 (integer) to avoid conversion error
• Remove all entries from LineXSpell which had no actual spell in database (11 entries deleted)
• Remove all PortalKeepNPCtemplates since they don't seem to be used and caused errors
• Added missing "Disperse Bones" DoT spell for "deep lake adder" NPCTemplate
• Removed (probably) celerity spell in "spectral paladin" NPCTemplate that had no entry in spell DB and is unlikely appropriate anyway given the level of the other spells
• Corrected spell for grave goblin shaman and deep goblin blighter to the appropriate disease
• Remove Netherworldly_Scale_Hauberk_2 and Netherworldly_Scale_Hauberk2 from Cuuldurach LootTemplate
• Remove region 230 and 247 (it has no zones attached)
• Remove Alliances that have no leader anymore (namely: Iron Vanguard, ChaoS, Guardiani del Vahalla, Polaris Zorn, Alliance Test, Alliance Testerr, Gorillaz in the Mist)
• Remove 6 duplicate styles in Battlemaster for classID 44
• Remove 904 redundant NPCEquipmentTemplates

  Code: Select all

  SELECT necomp.* FROM npcequipment ne JOIN npcequipment necomp ON necomp.Slot = ne.Slot AND necomp.TemplateID = ne.TemplateID AND ne.PackageID = 'public_DB' AND (necomp.PackageID IS NULL OR necomp.PackageID != 'public_DB')

• Remove 318 redundant keepguard NPCEquipmentTemplates

  Code: Select all

  DELETE FROM npcequipment WHERE NPCEquipment_ID not LIKE 'dol\_server\_%' AND (TemplateID LIKE '%\_pk' OR TemplateID LIKE 'albion\_%' OR TemplateID LIKE 'midgard\_%' OR TemplateID LIKE 'hibernia\_%')

• Remove 38 invalid and unused NPCEquipmentTemplates

  Code: Select all

  DELETE ne FROM npcequipment ne LEFT JOIN mob m ON m.EquipmentTemplateID = ne.TemplateID WHERE ne.Slot NOT IN (7,8,9,10,11,12,13,14,15,16,17,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37) AND m.Mob_ID IS null

• Remove 16 redundant liveBB NPCEquipmentTemplate entries
• 185 NPCEquipments with inexistent slots removed and removed from mobs accordingly and also changed ClassType to reflect their job (most of them are guards)
• set 11 mob.EquipmentTemplateID to null where no actual NPCEquipmentTemplate existed + 3 with a single space as EquipmentTemplateID to string.Empty
• delete 5 mobs with ClassType TrophyClaimer
• set 7 mobs with ClassType UniqueObjectGambler to GameNPC

PS.: I have backups for all deleted/changed entries for at least a month.