About 2,994 results: "【┃总代4641⒍⒏5[Q]】】杏彩进不去"
Page 1 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On




  1. SET @OGUID := 68000;
  2. 
                        
  3. DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1246;
  4. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  5. -- (@OGUID+0, 175080, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 120, 255, 1), -- 0 (Area: -Unknown-) - !!! transport !!!
  6. (@OGUID+0, 205220, 0, 1, 1, -4794.4, -999.585, 510.811, 3.263772, 0, 0, 0, 1, 120, 255, 1), -- -Unknown- (Area: -Unknown-)
  7. (@OGUID+1, 205220, 0, 1, 1, -4794.67, -1006.65, 510.811, 3.106652, 0, 0, 0, 1, 120, 255, 1), -- -Unknown- (Area: -Unknown-)
  8. -- (@OGUID+2, 176310, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 120, 255, 1), -- 0 (Area: -Unknown-) - !!! transport !!!
  9. -- (@OGUID+2, 176231, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 120, 255, 1), -- 0 (Area: 0) - !!! transport !!!
  10. (@OGUID+2, 208262, 0, 1, 1, -4902.022, -185.6528, 449.107, 5.270896, 0, 0, 0, 1, 120, 255, 1), -- -Unknown- (Area: 0)
  11. (@OGUID+3, 276, 0, 1, 1, -5029.113, -197.1111, 445.7784, 0, 0, 0, 0, 1, 120, 255, 1), -- Shimmerweed Basket (Area: Chill Breeze Valley)
  12. (@OGUID+4, 276, 0, 1, 1, -5018.09, -203.3866, 446.7282, 5.846854, 0, 0, 0, 1, 120, 255, 1), -- Shimmerweed Basket (Area: Chill Breeze Valley)
  13. (@OGUID+5, 276, 0, 1, 1, -5012.76, -241.5632, 442.9372, 4.537859, 0, 0, 0, 1, 120, 255, 1), -- Shimmerweed Basket (Area: Chill Breeze Valley)
  14. (@OGUID+6, 276, 0, 1, 1, -5024.286, -195.4973, 446.7291, 2.478367, 0, 0, 0, 1, 120, 255, 1), -- Shimmerweed Basket (Area: Chill Breeze Valley)
  15. (@OGUID+7, 276, 0, 1, 1, -5048.26, -235.3733, 445.1161, 0, 0, 0, 0, 1, 120, 255, 1), -- Shimmerweed Basket (Area: Chill Breeze Valley)





  1. DELETE FROM `gameobject_template` WHERE `entry` IN (194133, 194131, 194130, 194124, 194714, 194145, 194179, 194112, 194113, 194211, 195057, 194139, 194150, 194140, 195043, 195054, 195058, 194141, 194142, 194143, 194144);
  2. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES
  3. (194133, 10, 676, 'Secure Duskrat Cage', '', '', '', 1821, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62141, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.6, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  4. (194131, 5, 6651, 'Secure Duskrat Cage Bottom', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.6, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  5. (194130, 5, 6651, 'Secure Bear Cage Bottom', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  6. (194124, 10, 676, 'Secure Bear Cage', '', '', '', 1821, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62141, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  7. (194714, 2, 4391, 'Disgusting Workbench', '', '', '', 0, 9610, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.75, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  8. (194145, 10, 8552, 'Aetherion Ritual Orb', '', '', '', 1634, 13558, 20898, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  9. (194179, 10, 5151, 'The Final Flame of Bashal''Aran', '', '', '', 1634, 13562, 20957, 20, 0, 0, 0, 0, 0, 0, 62497, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  10. (194112, 5, 7069, 'Shadowmoon Rune 2', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  11. (194113, 5, 7069, 'Shadowmoon Rune 2 (scale x2.00)', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  12. (194211, 5, 181, 'Ball and Chain', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  13. (195057, 5, 7292, 'Devouring Artifact', '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  14. (194139, 8, 192, 'Campfire', '', '', '', 4, 10, 2061, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.08, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  15. (194150, 10, 8553, 'Jadefire Brazier', 'Attack', 'Destroying', '', 99, 13572, 0, 196608, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 24585, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.55, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-

  1. DELETE FROM `gameobject_template` WHERE `entry` IN (205008, 207179, 207301, 207293, 207300, 177149, 177147, 177148, 177146, 176806, 177144, 177140, 177142, 177143, 177145, 177141, 177139, 179864, 179863, 175927, 176807, 176808, 177151, 177153, 177150, 177152, 207291, 207306, 175587, 207424, 207421, 207420, 207419, 207423, 175324, 207422);
  2. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES
  3. (205008, 8, 192, 'Campfire', '', '', '', 4, 10, 2061, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  4. (207179, 2, 216, 'Winterfall Cauldron', '', '', '', 0, 4391, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  5. (207301, 3, 10250, 'Ancient Urn', '', 'Collecting', '', 43, 36096, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.5, 64675, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  6. (207293, 3, 321, 'Chillwind Eggs', '', 'Collecting', '', 93, 36131, 0, 1, 0, 0, 0, 207418, 0, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 65890, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  7. (207300, 8, 192, 'Campfire', '', '', '', 4, 10, 2061, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- -Unknown-
  8. (177149, 5, 388, 'Starfall Village', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Starfall Village
  9. (177147, 5, 388, 'Kel''Theril', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Kel'Theril
  10. (177148, 5, 388, 'Frostsaber Rock', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Frostsaber Rock
  11. (177146, 5, 388, 'Everlook', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Everlook
  12. (176806, 8, 192, 'Campfire', '', '', '', 4, 10, 2061, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Campfire
  13. (177144, 5, 388, 'Everlook', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Everlook
  14. (177140, 5, 388, 'Frostsaber Rock', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Frostsaber Rock
  15. (177142, 5, 388, 'Moonglade', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 15595), -- Moonglade


  1. SET @CGUID := 86984;
  2. 
                        
  3. DELETE FROM `creature` WHERE `id`=24110 AND `guid` BETWEEN @CGUID+0 AND @CGUID+31;
  4. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
  5. (@CGUID+0, 24110, 571, 1, 169, 2480.52, -405.0309, 31.25292, 1.954769, 120, 0, 0), -- 24110 (Area: 4181)
  6. (@CGUID+1, 24110, 571, 1, 169, 2485.832, -406.4011, 38.64569, 1.937315, 120, 0, 0), -- 24110 (Area: 4181)
  7. (@CGUID+2, 24110, 571, 1, 169, 2483.247, -405.9387, 35.05476, 4.991642, 120, 0, 0), -- 24110 (Area: 4181)
  8. (@CGUID+3, 24110, 571, 1, 169, 2477.307, -404.4191, 27.71297, 2.530727, 120, 0, 0), -- 24110 (Area: 4181)
  9. (@CGUID+4, 24110, 571, 1, 169, 2490.05, -404.6198, 27.34736, 0, 120, 0, 0), -- 24110 (Area: 4181)
  10. (@CGUID+5, 24110, 571, 1, 169, 2486.804, -396.4983, 37.61678, 6.248279, 120, 0, 0), -- 24110 (Area: 4181)
  11. (@CGUID+6, 24110, 571, 1, 169, 2473.764, -403.68, 23.80915, 3.246312, 120, 0, 0), -- 24110 (Area: 4181)
  12. (@CGUID+7, 24110, 571, 1, 169, 2489.167, -395.6806, 28.83605, 0.01745329, 120, 0, 0), -- 24110 (Area: 4181)
  13. (@CGUID+8, 24110, 571, 1, 169, 2488.105, -403.3663, 35.30573, 2.80998, 120, 0, 0), -- 24110 (Area: 4181)
  14. (@CGUID+9, 24110, 571, 1, 169, 2457.642, -389.6918, 23.55255, 6.143559, 120, 0, 0), -- 24110 (Area: 4181)
  15. (@CGUID+10, 24110, 571, 1, 169, 2469.61, -402.5246, 21.45798, 4.08407, 120, 0, 0), -- 24110 (Area: 4181)








Back to Top