mirror of
https://github.com/araxiaonline/mod-azerothshard.git
synced 2026-06-13 01:32:21 -04:00
9c25df7d39
* chore. Compatibility with the latest version * ci: add apps/ directory for ci scripts * Update SQL files * Update workflow and upload template * rewrite getf method * Revert "Update workflow and upload template" This reverts commit 7951beaca606f8667d107e4436dfe65d43cd947b. * Pointer to local variable * update workflow * Revert "Pointer to local variable" This reverts commit 22a66673e94b00dabb88f4bde297b0d44898a27c. * Change const char for std::string * AzthLanguage in modules * fix build error * fix build * fix. sql * fix sql --------- Co-authored-by: Helias <stefanoborzi32@gmail.com>
15 lines
3.7 KiB
SQL
15 lines
3.7 KiB
SQL
DELETE FROM creature_template WHERE entry >= 760000 AND entry <= 760009;
|
|
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
|
|
(760000, 0, 0, 0, 0, 0, 24029, 0, 0, 0, 'Druid PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 2, 768, 2048, 0, 0, 0, 0, 11, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760001, 0, 0, 0, 0, 0, 24030, 0, 0, 0, 'Hunter PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 2, 768, 2048, 0, 0, 0, 0, 3, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760002, 0, 0, 0, 0, 0, 24031, 0, 0, 0, 'Mage PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 8, 768, 2048, 0, 0, 0, 0, 8, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760003, 0, 0, 0, 0, 0, 24032, 0, 0, 0, 'Paladin PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 2, 768, 2048, 0, 0, 0, 0, 2, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760004, 0, 0, 0, 0, 0, 24033, 0, 0, 0, 'Priest PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 8, 768, 2048, 0, 0, 0, 0, 5, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760005, 0, 0, 0, 0, 0, 23777, 0, 0, 0, 'Rogue PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 1, 768, 2048, 0, 0, 0, 0, 4, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760006, 0, 0, 0, 0, 0, 24034, 0, 0, 0, 'Shaman PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 2, 768, 2048, 0, 0, 0, 0, 7, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760007, 0, 0, 0, 0, 0, 24035, 0, 0, 0, 'Warlock PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 8, 768, 2048, 0, 0, 0, 0, 9, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760008, 0, 0, 0, 0, 0, 24036, 0, 0, 0, 'Warrior PVP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 1, 768, 2048, 0, 0, 0, 0, 1, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340),
|
|
(760009, 0, 0, 0, 0, 0, 24036, 0, 0, 0, 'Death Knight PvP Trainer', '', '', 0, 70, 70, 2, 35, 49, 1.1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 1, 1, 1, 1, 1, 768, 2048, 0, 0, 0, 0, 1, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'npc_azth_vendor', 12340);
|
|
|
|
UPDATE creature_template SET minlevel = 82, maxlevel = 82 WHERE entry >= 760000 AND entry <= 760009;
|