3.3.5a - [MySQL] Creature Dummy Creator [Very Simple] | Emudevs.gg

A very simple creature dummy creator.
This will create (INSERT INTO creature_template) one creature dummy (a creature with the dummy extraflag (128)).
It will then SELECT the newly created creature_template.entry and creature_template.name for futher use.

PLEASE EDIT: dev_world to YOUR [WORLD DATABASE NAME]

You can edit faction to '14' for hostile and '35' for friendly.

MySQL Query:

SQL:

-- ########################
-- ### Creature Creator ###
-- ########################

-- This is a simple dummy creature_template

set
        @creatureEntry = (select max(dev_world.creature_template.entry) from dev_world.creature_template);

set
        @creatureName = '',
        @creatureScale = '1',
        @creatureFaction = 35;

set
    @npcFlags = 0;



INSERT INTO dev_world.`creature_template`
        (`entry`, `modelid1`, `name`, `subname`, `minlevel`,
        `maxlevel`, `exp`, `faction`, `scale`, `BaseAttackTime`,
        `unit_class`, `type`, `AIName`, `flags_extra`, npcflag)
    VALUES
        (@creatureEntry+1, '40721', @creatureName, 'Dummy',
            '100', '100', '2', @creatureFaction, @creatureScale, '2000',
            '1', '10', 'SmartAI', '128', @npcFlags);


select creature_template.entry, creature_template.name FROM dev_world.creature_template where entry = (select MAX(dev_world.creature_template.entry) FROM dev_world.creature_template);

Liked By 1 member :

splicho

3.3.5a [MySQL] Creature Dummy Creator [Very Simple] 1_0

3.3.5a [MySQL] Simple Gameobject_template Create

3.3.5a Double Icon Creator (SpellIcon AND ItemDisplayInfo Icon)

3.3.5a [TrinityCore] Custom Season 9 - Malicious Gladiator

3.3.5a [Spell Copier] Simple INSERT SELECT (Copy spell)

3.3.5a Item_template -> Item_dbc (MYSQL)

3,383

1,252

9,530

410