My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Kayser

By: a guest | Feb 9th, 2010 | Syntax: SQL | Size: 7.36 KB | Hits: 31 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. -- Instance teleport fixes for Trial of the Crusader/Champion
  2. -- Adding areatrigger_teleports for Trial of the Crusader/Champion
  3. DELETE FROM `areatrigger_teleport` WHERE `id` IN(5508,5503,5505,5510);
  4. INSERT INTO `areatrigger_teleport` (`id`,`name`,`access_id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES
  5. (5508, 'Trial of the Crusader (Exit)',0,571,8515.46,728.92,558.3,4.7420),
  6. (5503, 'Trial of the Crusader (Entrance)',80,649,563.61,80.6815,395.20,1.59),
  7. (5505, 'Trial of the Champion (Entrance)',75,650,805.227,618.038,412.393,3.1456),
  8. (5510, 'Trial of the Champion (Exit)',0,571,8577.4,791.732,558.235,0);
  9. -- Add requirements for Trial of the Crusader/Champion
  10. DELETE FROM `access_requirement` WHERE `id` IN(5505,5503);
  11. INSERT INTO `access_requirement` (`id`,`level_min`,`heroic_level_min`,`level_max`,`item`,`item2`,`heroic_key`,`heroic_key2`,`quest_done`,`quest_failed_text`,`heroic_quest_done`,`heroic_quest_failed_text`,`comment`) VALUES
  12. (5505,75,80,0,0,0,0,0,0,NULL,0,NULL, 'Trial of the Champion'),
  13. (5503,80,80,0,0,0,0,0,0,NULL,0,NULL, 'Trial of the Crusader');
  14. -- Add graveyards outside Trial of the Crusader/Champion
  15. DELETE FROM `game_graveyard_zone` WHERE `ghost_zone` IN(4722,4742,4723);
  16. INSERT INTO `game_graveyard_zone` (`id`,`ghost_zone`,`faction`) VALUES
  17. (1478,4722,0),
  18. (1478,4742,0),
  19. (1478,4723,0);
  20. -- Add instance templates for Trial of the Crusader/Champion
  21. DELETE FROM `instance_template` WHERE `map` IN(650,649);
  22. INSERT INTO `instance_template` (`map`,`parent`,`access_id`,`startLocX`,`startLocY`,`startLocZ`,`startLocO`,`script`) VALUES
  23. (650,0,5505,0,NULL,NULL,NULL,'instance_trial_of_the_champion'),
  24. (649,0,5503,0,NULL,NULL,NULL,NULL);
  25. -- Correcting VehicleId
  26. UPDATE `creature_template` SET `VehicleId`=486 WHERE `entry` IN (36558,35644); -- for 35644 vehicleid 529 dosen't work, with 486 works but the sniffed data say 529
  27. UPDATE `creature_template` SET `VehicleId`=109 WHERE `entry`=31689; -- sniffed data say 107 but dosen't work!
  28. -- Inserting new spawns in map 650
  29. DELETE FROM `creature` WHERE `id`=35016 AND `map`=650;
  30. INSERT INTO `creature` (`guid`,`id`,`phaseMask`,`spawnMask`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
  31. (200039,35016,1,3,650,702.274292,638.760437,412.470276,0.000000),
  32. (200040,35016,1,3,650,697.284729,618.253479,412.475830,0.000000),
  33. (200041,35016,1,3,650,714.486145,581.722229,412.476044,0.000000),
  34. (200042,35016,1,3,650,703.883667,596.600708,412.474152,0.000000),
  35. (200043,35016,1,3,650,712.413208,653.930542,412.474182,0.000000);
  36. -- go spawns
  37. DELETE FROM `gameobject` WHERE `id`IN(196398,195477,195486,195481,195479,195480,195478,195648,195649,195485,195650,195647,180723,195650,195647,180708,180703,180730,180736,180720,180738) AND `map`=650;;
  38. INSERT INTO `gameobject` (`guid`,`id`,`phaseMask`,`spawnMask`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
  39. (72078,196398,1,3,650,801.663208,624.805542,412.344391,-1.343901),
  40. (47163,196398,1,3,650,784.533020,660.237854,412.389069,-0.715585),
  41. (72571,196398,1,3,650,710.324646,660.708313,412.386780,0.698132),
  42. (72567,196398,1,3,650,692.126770,610.574646,412.346588,1.850049),
  43. (72083,195477,1,3,650,813.129578,617.632385,413.038574,0.000000),
  44. (72082,195486,1,3,650,813.119751,617.589905,413.030518,0.000000),
  45. (72080,195481,1,3,650,746.155640,549.464294,412.880890,1.570796),
  46. (72081,195480,1,3,650,746.155640,549.464294,412.880890,1.570796),
  47. (72076,195479,1,3,650,746.155640,549.464294,412.880890,1.570796),
  48. (72077,195478,1,3,650,746.155640,549.464294,412.880890,1.570796),
  49. (28105,195648,1,3,650,746.645752,556.925171,412.412476,1.570796),
  50. (28052,195649,1,3,650,685.509827,618.055420,412.412476,3.141593),
  51. (150075,195485,1,3,650,844.684509,623.407959,159.108765,0.000000),
  52. (28044,195650,1,3,650,807.839050,618.055420,412.412476,3.141593),
  53. (72068,195647,1,3,650,746.697632,677.468750,412.339142,1.570796),
  54. (150078,180723,1,3,650,779.951416,655.656250,421.818390,-2.356190),
  55. (150079,180723,1,3,650,782.309021,582.892395,421.545563,2.251473),
  56. (150080,195650,1,3,650,807.839050,618.055420,412.412476,3.141593),
  57. (150081,195647,1,3,650,746.697632,677.468750,412.339142,1.570796),
  58. (150082,180708,1,3,650,712.520813,655.647583,424.593201,-0.767944),
  59. (150083,180708,1,3,650,704.793396,600.736145,429.519257,0.436332),
  60. (150084,180708,1,3,650,704.302063,636.326416,425.136292,-0.418879),
  61. (150085,180703,1,3,650,712.520813,655.647583,424.593201,-0.767944),
  62. (150086,180703,1,3,650,714.158020,585.533020,425.578766,0.715585),
  63. (150087,180703,1,3,650,704.793396,600.736145,429.519257,0.436332),
  64. (150088,180730,1,3,650,714.158020,585.533020,425.578766,0.715585),
  65. (150089,180730,1,3,650,704.793396,600.736145,429.519257,0.436332),
  66. (150090,180736,1,3,650,792.309021,598.456604,424.636078,2.705255),
  67. (150091,180736,1,3,650,794.440979,638.305542,425.700226,-2.775069),
  68. (150092,180736,1,3,650,779.951416,655.656250,421.818390,-2.356190),
  69. (150093,180736,1,3,650,782.309021,582.892395,421.545563,2.251473),
  70. (150094,180720,1,3,650,779.951416,655.656250,421.818390,-2.356190),
  71. (150095,180720,1,3,650,782.309021,582.892395,421.545563,2.251473),
  72. (150096,180738,1,3,650,794.440979,638.305542,425.700226,-2.775069),
  73. (150097,180738,1,3,650,782.309021,582.892395,421.545563,2.251473),
  74. (150098,180728,1,3,650,704.302063,636.326416,425.136292,-0.418879),
  75. (150099,180728,1,3,650,714.158020,585.533020,425.578766,0.715585),
  76. (150100,180728,1,3,650,712.520813,655.647583,424.593201,-0.767944);
  77. -- End spawns insert for map 650
  78. -- Add faction for Grand Champions of the Alliance based on Grand Champion's city
  79. UPDATE `creature_template` SET `faction_A`=1078,`faction_H`=1078 WHERE `entry`=34705; -- Grand Champion of Stormwind
  80. UPDATE `creature_template` SET `faction_A`=64,`faction_H`=64 WHERE `entry`=34702;  -- Grand Champion of Gnomeregan
  81. UPDATE `creature_template` SET `faction_A`=1694,`faction_H`=1694 WHERE `entry`=34701; -- Grand Champion of the Exodar
  82. UPDATE `creature_template` SET `faction_A`=1076,`faction_H`=1076 WHERE `entry`=34657; -- Grand Champion of Darnassus
  83. UPDATE `creature_template` SET `faction_A`=2155,`faction_H`=2155 WHERE `entry`=34703; -- Grand Champion of Ironforge
  84. -- Add faction for Grand Champions of the Horde based on Grand Champion's city
  85. UPDATE `creature_template` SET `faction_A`=29,`faction_H`=29 WHERE `entry`=35572; -- Grand Champion of Orgrimmar
  86. UPDATE `creature_template` SET `faction_A`=1604,`faction_H`=1604 WHERE `entry`=35569;  -- Grand Champion of Silvermoon
  87. UPDATE `creature_template` SET `faction_A`=104,`faction_H`=104 WHERE `entry`=35571; -- Grand Champion of the Thunder Bluff
  88. UPDATE `creature_template` SET `faction_A`=126,`faction_H`=126 WHERE `entry`=35570; -- Grand Champion of Sen'jin
  89. UPDATE `creature_template` SET `faction_A`=68,`faction_H`=68 WHERE `entry`=35617; -- Grand Champion of Undercity
  90. -- Add faction undead to The Black Knight
  91. UPDATE `creature_template` SET `faction_A`=21,`faction_H`=21 WHERE `entry`=35451;
  92. -- Set vehicleid, it is not sniffed.
  93. UPDATE `creature_template` SET `VehicleId`=486 WHERE `entry` IN (35637,35633,35768,34658,35636,35638,35635,35640,35641,35634,33298,33416,33297,33414,33301,33408,33300,33409,33418);
  94. -- Add necessary spells for vehicles.
  95. UPDATE `creature_template` SET `spell1`=68505,`spell2`=62575,`spell3`=68282,`spell4`=66482 WHERE `entry` IN (36558,35644);
  96. -- Arreglo monturas prueba del campeon YTDB
  97. DELETE FROM `creature_template_addon` WHERE `entry` IN (35325,35327,35314,35326);
create new paste | create new version of this paste RAW Paste Data