/sql/old/ancient/3.3.5a/TDB48_to_TDB49_updates/world/2012_08_27_03_world_gameobject.sql

https://gitlab.com/trinitycore/TrinityCore_434 · SQL · 6 lines · 4 code · 1 blank · 1 comment · 0 complexity · 996f73499b34018302551baafc6760fb MD5 · raw file 

    

  1. -- Spawn Blackened Urn (194092) GO based on sniff by Aokromes
    2. 

  2. SET @GUID := 334; -- Set by TDB team
    3. 

  3. 

  4. DELETE FROM `gameobject` WHERE `id`=194092;
    5. 

  5. INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
    6. 

  6. (@GUID,194092,532,1,1,-11126.87,-1874.455,91.47264,6.056293,0,0,-0.113203,0.9935719,180,100,1);
    7.