Welcome to AC Web.
Results 1 to 7 of 7
  1. #1

    [SQL] Transfer creature_template entries from azerothcore to trinitycore


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    As the title says, this query will let you transfer specific creature_template entries from azerothcore to trinitycore.

    Code:
    INSERT INTO creature_template (SELECT 
        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,
        scale,
        rank,
        dmgschool,
        BaseAttackTime,
        RangeAttackTime,
        BaseVariance,
        RangeVariance,
        unit_class,
        unit_flags,
        unit_flags2,
        dynamicflags,
        family,
        type,
        type_flags,
        lootid,
        pickpocketloot,
        skinloot,
        PetSpellDataId,
        VehicleId,
        mingold,
        maxgold,
        AIName,
        MovementType,
        HoverHeight,
        HealthModifier,
        ManaModifier,
        ArmorModifier,
        DamageModifier,
        ExperienceModifier,
        RacialLeader,
        movementId,
        RegenHealth,
        mechanic_immune_mask,
        spell_school_immune_mask,
        flags_extra,
        ScriptName,
        VerifiedBuild
    FROM acore_world.creature_template WHERE entry >= 9000000);

  2. #2
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,264
    Quote Originally Posted by Blake Barraclough View Post
    As the title says, this query will let you transfer specific creature_template entries from azerothcore to trinitycore.

    Code:
    INSERT INTO creature_template (SELECT 
        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,
        scale,
        rank,
        dmgschool,
        BaseAttackTime,
        RangeAttackTime,
        BaseVariance,
        RangeVariance,
        unit_class,
        unit_flags,
        unit_flags2,
        dynamicflags,
        family,
        type,
        type_flags,
        lootid,
        pickpocketloot,
        skinloot,
        PetSpellDataId,
        VehicleId,
        mingold,
        maxgold,
        AIName,
        MovementType,
        HoverHeight,
        HealthModifier,
        ManaModifier,
        ArmorModifier,
        DamageModifier,
        ExperienceModifier,
        RacialLeader,
        movementId,
        RegenHealth,
        mechanic_immune_mask,
        spell_school_immune_mask,
        flags_extra,
        ScriptName,
        VerifiedBuild
    FROM acore_world.creature_template WHERE entry >= 9000000);
    Why not just do
    Code:
    INSERT INTO creature_template
    SELECT * FROM acore_world.creature_template WHERE entry >= 9000000;
    instead of including every column name?

    Or another option is
    Code:
    DROP TABLE creature_template;
    CREATE TABLE creature_template SELECT * FROM acore_world.creature_template;
    so you first delete the creature_template from TrinityCore's world database then you duplicate creature_template from acore_world in to TrinityCore's world database with data

  3. #3
    Quote Originally Posted by Tok124 View Post
    Why not just do
    Code:
    INSERT INTO creature_template
    SELECT * FROM acore_world.creature_template WHERE entry >= 9000000;
    instead of including every column name?

    Or another option is
    Code:
    DROP TABLE creature_template;
    CREATE TABLE creature_template SELECT * FROM acore_world.creature_template;
    so you first delete the creature_template from TrinityCore's world database then you duplicate creature_template from acore_world in to TrinityCore's world database with data
    Because not all fields are present in the acore db tok

  4. #4
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,264
    Quote Originally Posted by titkata_bg View Post
    Because not all fields are present in the acore db tok
    So acore's creature_template have more columns than TrinityCore's creature_template? If so then yeah, You need to include all column names Or you could just duplicate the table as shown above and either keep the new columns from acore or just delete them. Doesnt really matter. But this you should only do if you have a fresh creature_template from TrinityCore. If you have added a bunch of NPCs that you want to keep then the best solution is to do as Blake showed

    But thanks for letting me know. i've never tried acore before so i had to ask
    Last edited by Tok124; 10-16-2021 at 11:35 AM.

  5. #5
    Quote Originally Posted by Tok124 View Post
    So acore's creature_template have more columns than TrinityCore's creature_template? If so then yeah, You need to include all column names Or you could just duplicate the table as shown above and either keep the new columns from acore or just delete them. Doesnt really matter. But this you should only do if you have a fresh creature_template from TrinityCore. If you have added a bunch of NPCs that you want to keep then the best solution is to do as Blake showed

    But thanks for letting me know. i've never tried acore before so i had to ask
    Azerothcore has more columns and some of them I think are named differently to trinitycore.

  6. #6

  7. #7

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Thanks for this share mate

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •