Jump to content
  • NPC: Achellios the Banished


    bdebaere
    • Status: Completed
      Main Category: Database
      Sub-Category: Creature
      Version: 22.x (Current Master Branch) Milestone: 21 Priority: New
      Implemented Version: 21.14

    NPC: Achellios the Banished

    Achellios the Banished
    [url]http://db.vanillagaming.org/?npc=5933#wh-comments[/url]

    Does not have any waypoint set. But he is clearly meant to be patrolling around. Also old WH comments mention you can CC him and his dogs will keep on running, implying they all patrol.


    User Feedback

    Recommended Comments

    Taking the coordinates from the following commit: [url]https://github.com/TrinityCore/TrinityCore/issues/8524[/url] I have come up with a SQL statement to make him and his hounds patrol and aggro when he is attacked.

    Execute the following SQL statement in your mangos database:
    INSERT INTO
    creature_movement_template( `entry`, `point`, `position_x`, `position_y`, `position_z` )
    VALUES
    (5933, 1, -5065.414551, -1433.431885, -52.054058),
    (5933, 2, -5080.285156, -1409.718994, -52.203053),
    (5933, 3, -5096.495605, -1378.726807, -51.724346),
    (5933, 4, -5104.196289, -1358.002808, -50.824722),
    (5933, 5, -5112.802734, -1324.146851, -50.094719),
    (5933, 6, -5111.580078, -1301.388672, -49.267933),
    (5933, 7, -5107.584473, -1280.802734, -48.943916),
    (5933, 8, -5096.659180, -1257.089233, -48.471100),
    (5933, 9, -5082.086914, -1233.186279, -50.992100),
    (5933, 10, -5065.160156, -1214.561768, -54.094868),
    (5933, 11, -5048.077148, -1208.920410, -54.393391),
    (5933, 12, -5025.265625, -1212.702515, -53.574635),
    (5933, 13, -5007.475098, -1223.781250, -50.797726),
    (5933, 14, -4988.770508, -1237.379517, -47.942184),
    (5933, 15, -4965.532227, -1252.931885, -46.213470),
    (5933, 16, -4945.341309, -1262.725708, -48.321907),
    (5933, 17, -4957.100098, -1257.528564, -47.172382),
    (5933, 18, -4974.348145, -1245.551147, -46.548256),
    (5933, 19, -4997.272949, -1229.474365, -49.777657),
    (5933, 20, -5014.469727, -1217.421753, -52.319622),
    (5933, 21, -5032.637695, -1209.560913, -54.186928),
    (5933, 22, -5056.286133, -1214.395996, -54.073860),
    (5933, 23, -5073.804199, -1225.945801, -52.395935),
    (5933, 24, -5089.777344, -1243.745728, -49.314560),
    (5933, 25, -5098.031250, -1259.230591, -48.500839),
    (5933, 26, -5106.213379, -1282.815308, -48.529831),
    (5933, 27, -5109.097656, -1303.605347, -48.834938),
    (5933, 28, -5108.130859, -1322.882935, -49.570202),
    (5933, 29, -5104.601074, -1343.582642, -50.142941),
    (5933, 30, -5101.294922, -1364.320801, -50.986908),
    (5933, 31, -5092.989258, -1385.642334, -52.071144),
    (5933, 32, -5081.424316, -1403.168579, -52.366920);

    UPDATE
    creature
    SET
    movementtype = 2
    WHERE
    id = 5933;

    INSERT INTO
    creature_linking_template( `entry`, `map`, `master_entry`, `flag`, `search_range` )
    VALUES
    (4250, 1, 5933, 513, 0);

    Link to comment
    Share on other sites



    Guest
    This is now closed for further comments

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use