wip

import-custom-sql.sh

@@ -22,9 +22,9 @@ usage() {
 Usage: $(basename "$0")
 
 Imports required custom SQL that lives outside the normal AzerothCore module paths.
-Currently this bootstraps the MythicPlus and Store Lua packages, plus module strings
-and playerbot localization data not covered by the normal module SQL import path
-in this deployment.
+Currently this bootstraps custom creatures, the MythicPlus and Store Lua packages,
+plus module strings and playerbot localization data not covered by the normal
+module SQL import path in this deployment.
 EOF
 }
 
@@ -88,6 +88,14 @@ import_sql_file() {
         "mysql -uroot -p\"\$MYSQL_ROOT_PASSWORD\" \"$database\"" < "$file_path"
 }
 
+import_custom_creatures_sql() {
+    local custom_creatures_sql_file="$ROOT_DIR/sql/custom-creatures.sql"
+
+    # This file uses INSERT ... ON DUPLICATE KEY UPDATE, so it is safe and
+    # intentional to reapply it on every server startup.
+    import_sql_file "acore_world" "$custom_creatures_sql_file"
+}
+
 require_integer_flag() {
     local name="$1"
     local value="$2"
@@ -357,6 +365,7 @@ if ! docker compose ps --status running --services | grep -qx 'ac-database'; the
     exit 1
 fi
 
+import_custom_creatures_sql
 import_mythicplus_sql
 import_aoe_loot_sql
 import_playerbots_ru_sql

sql/custom-creatures.sql

@@ -0,0 +1,87 @@
+-- Generated by MoonWell custom creature builder.
+-- Apply to acore_world, then restart ac-worldserver.
+SET NAMES utf8mb4;
+START TRANSACTION;
+
+-- catslime
+INSERT INTO creature_template
+(entry,name,minlevel,maxlevel,faction,speed_walk,speed_run,unit_class,unit_flags,unit_flags2,type,MovementType,RegenHealth,VerifiedBuild)
+VALUES (5000000,'Cat Slime',1,1,188,1,1.14286,1,0,2048,12,0,1,12340)
+ON DUPLICATE KEY UPDATE name=VALUES(name),faction=VALUES(faction),type=VALUES(type),unit_flags2=VALUES(unit_flags2);
+INSERT INTO creature_template_locale
+(entry,locale,Name,Title,VerifiedBuild)
+VALUES (5000000,'ruRU','Котослизень','',12340)
+ON DUPLICATE KEY UPDATE Name=VALUES(Name),Title=VALUES(Title),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_model_info
+(DisplayID,BoundingRadius,CombatReach,Gender,DisplayID_Other_Gender,VerifiedBuild)
+VALUES (50000,0.25,0.5,2,0,12340)
+ON DUPLICATE KEY UPDATE BoundingRadius=VALUES(BoundingRadius),CombatReach=VALUES(CombatReach),Gender=VALUES(Gender),DisplayID_Other_Gender=VALUES(DisplayID_Other_Gender),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_template_model
+(CreatureID,Idx,CreatureDisplayID,DisplayScale,Probability,VerifiedBuild)
+VALUES (5000000,0,50000,1,1,12340)
+ON DUPLICATE KEY UPDATE CreatureDisplayID=VALUES(CreatureDisplayID),DisplayScale=VALUES(DisplayScale),Probability=VALUES(Probability);
+
+INSERT INTO spell_dbc
+(ID,Attributes,AttributesEx3,CastingTimeIndex,InterruptFlags,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect_1,EffectDieSides_1,EffectBasePoints_1,ImplicitTargetA_1,EffectMultipleValue_1,EffectMiscValue_1,EffectMiscValueB_1,SpellVisualID_1,SpellIconID,Name_Lang_enUS,Name_Lang_ruRU,Description_Lang_enUS,Description_Lang_ruRU,StartRecoveryCategory,StartRecoveryTime,EffectChainAmplitude_1,EffectChainAmplitude_2,EffectChainAmplitude_3,SchoolMask)
+VALUES (110000,262416,536870912,1,31,101,21,1,-1,28,1,1,32,1000,5000000,41,353,2686,'Cat Slime','Котослизень','Summons or dismisses your companion: Cat Slime.','Призывает или отпускает спутника: Котослизень.',133,1500,1,1,1,1)
+ON DUPLICATE KEY UPDATE EffectMiscValue_1=VALUES(EffectMiscValue_1),SpellIconID=VALUES(SpellIconID),Name_Lang_enUS=VALUES(Name_Lang_enUS),Name_Lang_ruRU=VALUES(Name_Lang_ruRU),Description_Lang_enUS=VALUES(Description_Lang_enUS),Description_Lang_ruRU=VALUES(Description_Lang_ruRU);
+INSERT INTO skilllineability_dbc
+(ID,SkillLine,Spell,RaceMask,ClassMask,ExcludeRace,ExcludeClass,MinSkillLineRank,SupercededBySpell,AcquireMethod,TrivialSkillLineRankHigh,TrivialSkillLineRankLow,CharacterPoints_1,CharacterPoints_2)
+VALUES (30000,778,110000,0,0,0,0,1,0,0,0,0,0,0)
+ON DUPLICATE KEY UPDATE SkillLine=VALUES(SkillLine),Spell=VALUES(Spell),RaceMask=VALUES(RaceMask),MinSkillLineRank=VALUES(MinSkillLineRank);
+
+-- moonkin_hatchling_alliance
+INSERT INTO creature_template
+(entry,name,minlevel,maxlevel,faction,speed_walk,speed_run,unit_class,unit_flags,unit_flags2,type,MovementType,RegenHealth,VerifiedBuild)
+VALUES (5000001,'Moonkin Hatchling',1,1,188,1,1.14286,1,0,2048,12,0,1,12340)
+ON DUPLICATE KEY UPDATE name=VALUES(name),faction=VALUES(faction),type=VALUES(type),unit_flags2=VALUES(unit_flags2);
+INSERT INTO creature_template_locale
+(entry,locale,Name,Title,VerifiedBuild)
+VALUES (5000001,'ruRU','Лунный совушек','',12340)
+ON DUPLICATE KEY UPDATE Name=VALUES(Name),Title=VALUES(Title),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_model_info
+(DisplayID,BoundingRadius,CombatReach,Gender,DisplayID_Other_Gender,VerifiedBuild)
+VALUES (50001,0.25,0.5,2,0,12340)
+ON DUPLICATE KEY UPDATE BoundingRadius=VALUES(BoundingRadius),CombatReach=VALUES(CombatReach),Gender=VALUES(Gender),DisplayID_Other_Gender=VALUES(DisplayID_Other_Gender),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_template_model
+(CreatureID,Idx,CreatureDisplayID,DisplayScale,Probability,VerifiedBuild)
+VALUES (5000001,0,50001,1,1,12340)
+ON DUPLICATE KEY UPDATE CreatureDisplayID=VALUES(CreatureDisplayID),DisplayScale=VALUES(DisplayScale),Probability=VALUES(Probability);
+
+INSERT INTO spell_dbc
+(ID,Attributes,AttributesEx3,CastingTimeIndex,InterruptFlags,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect_1,EffectDieSides_1,EffectBasePoints_1,ImplicitTargetA_1,EffectMultipleValue_1,EffectMiscValue_1,EffectMiscValueB_1,SpellVisualID_1,SpellIconID,Name_Lang_enUS,Name_Lang_ruRU,Description_Lang_enUS,Description_Lang_ruRU,StartRecoveryCategory,StartRecoveryTime,EffectChainAmplitude_1,EffectChainAmplitude_2,EffectChainAmplitude_3,SchoolMask)
+VALUES (110001,262416,536870912,1,31,101,21,1,-1,28,1,1,32,1000,5000001,41,353,50000,'Moonkin Hatchling','Лунный совушек','Summons or dismisses your companion: Moonkin Hatchling.','Призывает или отпускает спутника: Лунный совушек.',133,1500,1,1,1,1)
+ON DUPLICATE KEY UPDATE EffectMiscValue_1=VALUES(EffectMiscValue_1),SpellIconID=VALUES(SpellIconID),Name_Lang_enUS=VALUES(Name_Lang_enUS),Name_Lang_ruRU=VALUES(Name_Lang_ruRU),Description_Lang_enUS=VALUES(Description_Lang_enUS),Description_Lang_ruRU=VALUES(Description_Lang_ruRU);
+INSERT INTO skilllineability_dbc
+(ID,SkillLine,Spell,RaceMask,ClassMask,ExcludeRace,ExcludeClass,MinSkillLineRank,SupercededBySpell,AcquireMethod,TrivialSkillLineRankHigh,TrivialSkillLineRankLow,CharacterPoints_1,CharacterPoints_2)
+VALUES (30001,778,110001,1101,0,0,0,1,0,0,0,0,0,0)
+ON DUPLICATE KEY UPDATE SkillLine=VALUES(SkillLine),Spell=VALUES(Spell),RaceMask=VALUES(RaceMask),MinSkillLineRank=VALUES(MinSkillLineRank);
+
+-- moonkin_hatchling_horde
+INSERT INTO creature_template
+(entry,name,minlevel,maxlevel,faction,speed_walk,speed_run,unit_class,unit_flags,unit_flags2,type,MovementType,RegenHealth,VerifiedBuild)
+VALUES (5000002,'Moonkin Hatchling',1,1,188,1,1.14286,1,0,2048,12,0,1,12340)
+ON DUPLICATE KEY UPDATE name=VALUES(name),faction=VALUES(faction),type=VALUES(type),unit_flags2=VALUES(unit_flags2);
+INSERT INTO creature_template_locale
+(entry,locale,Name,Title,VerifiedBuild)
+VALUES (5000002,'ruRU','Лунный совушек','',12340)
+ON DUPLICATE KEY UPDATE Name=VALUES(Name),Title=VALUES(Title),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_model_info
+(DisplayID,BoundingRadius,CombatReach,Gender,DisplayID_Other_Gender,VerifiedBuild)
+VALUES (50002,0.25,0.5,2,0,12340)
+ON DUPLICATE KEY UPDATE BoundingRadius=VALUES(BoundingRadius),CombatReach=VALUES(CombatReach),Gender=VALUES(Gender),DisplayID_Other_Gender=VALUES(DisplayID_Other_Gender),VerifiedBuild=VALUES(VerifiedBuild);
+INSERT INTO creature_template_model
+(CreatureID,Idx,CreatureDisplayID,DisplayScale,Probability,VerifiedBuild)
+VALUES (5000002,0,50002,1,1,12340)
+ON DUPLICATE KEY UPDATE CreatureDisplayID=VALUES(CreatureDisplayID),DisplayScale=VALUES(DisplayScale),Probability=VALUES(Probability);
+
+INSERT INTO spell_dbc
+(ID,Attributes,AttributesEx3,CastingTimeIndex,InterruptFlags,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect_1,EffectDieSides_1,EffectBasePoints_1,ImplicitTargetA_1,EffectMultipleValue_1,EffectMiscValue_1,EffectMiscValueB_1,SpellVisualID_1,SpellIconID,Name_Lang_enUS,Name_Lang_ruRU,Description_Lang_enUS,Description_Lang_ruRU,StartRecoveryCategory,StartRecoveryTime,EffectChainAmplitude_1,EffectChainAmplitude_2,EffectChainAmplitude_3,SchoolMask)
+VALUES (110002,262416,536870912,1,31,101,21,1,-1,28,1,1,32,1000,5000002,41,353,50001,'Moonkin Hatchling','Лунный совушек','Summons or dismisses your companion: Moonkin Hatchling.','Призывает или отпускает спутника: Лунный совушек.',133,1500,1,1,1,1)
+ON DUPLICATE KEY UPDATE EffectMiscValue_1=VALUES(EffectMiscValue_1),SpellIconID=VALUES(SpellIconID),Name_Lang_enUS=VALUES(Name_Lang_enUS),Name_Lang_ruRU=VALUES(Name_Lang_ruRU),Description_Lang_enUS=VALUES(Description_Lang_enUS),Description_Lang_ruRU=VALUES(Description_Lang_ruRU);
+INSERT INTO skilllineability_dbc
+(ID,SkillLine,Spell,RaceMask,ClassMask,ExcludeRace,ExcludeClass,MinSkillLineRank,SupercededBySpell,AcquireMethod,TrivialSkillLineRankHigh,TrivialSkillLineRankLow,CharacterPoints_1,CharacterPoints_2)
+VALUES (30002,778,110002,690,0,0,0,1,0,0,0,0,0,0)
+ON DUPLICATE KEY UPDATE SkillLine=VALUES(SkillLine),Spell=VALUES(Spell),RaceMask=VALUES(RaceMask),MinSkillLineRank=VALUES(MinSkillLineRank);
+
+COMMIT;