Jump to content
  • Hellfire: the stair of destiny portals

    • Status: Completed
      Main Category: Database
      Sub-Category: Code Enhancement
      Version: 21.11 Milestone: 21 Priority: Normal
      Implemented Version: Unset
    -- Remove the current "creature" portal for both horde and alliance respectively --
    DELETE FROM creature WHERE guid = '68120';
    DELETE FROM creature WHERE guid = '68119';
    -- Create new portal object for both horde and alliance respectively --
    insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`) values ('500000','22','4395','Portal to Orgrimmar','','','','1735','0','2','0','0','0','0','0','0','17609','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
    insert into `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`) values('500001','22','4396','Portal to Stormwind','','','','1732','0','2','0','0','0','0','0','0','17334','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
    -- Place new portals for both horde and alliance respectively --
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('300000','500000','530','1','1','-161.318','965.41','54.3738','1.5708','0','0','0.00872639','0.999962','181','100','1');
    insert into `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('300001','500001','530','1','1','-337.492','962.619','54.3719','1.22173','0','0','-0.156434','0.987688','181','100','1');

    Credit to @necrovoice for providing this.


    User Feedback

    Recommended 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