search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

World Gameobjects #1714

Open Xadras opened 8 years ago

Xadras commented 8 years ago

Spawn / Respawn etc. of World Gameobjects

ToDo:

Xadras commented 8 years ago

Recheck Rogue Lockpicking Skillup Chests:

123330

Recheck Outland: http://db.hellfire-tbc.com/?object=142143 http://db.hellfire-tbc.com/?object=176583 http://db.hellfire-tbc.com/?object=176584

Xadras commented 8 years ago

181280: https://www.wowhead.com/object=181280/nightmare-vine

https://db.rising-gods.de/?maps=3483:573201641170673201581197577177595185598217624168635175630179646172657204670203665185670181

Xadras commented 8 years ago 
#!sql

-- General 

-- 142144 also tbc and pooled
UPDATE `gameobject` SET `spawntimesecs` = 720, `animprogress` = 100 WHERE `id` = 142144 AND `map` IN (0,1);
-- old world krautz
UPDATE `gameobject` SET `spawntimesecs` = 720, `animprogress` = 100 WHERE `id` IN (1617,1618,3724,3725,181166,1619,3726,1620,3727,1621,3729,2045,1622,3730,1623,1628,1624,2041,2042,2046,2043,2044,2866,142140,180165,142141,176642,142142,180164,176636,142143,142145,176637,176583,180167,176638,176584,180168,176639,176586,180166,176640,176587,176641,176588) AND `map` IN (0,1,530); -- 900

-- old world ores
UPDATE `gameobject` SET `animprogress` = 255, `state` = 1 WHERE `id` IN (103711,3764,1732,2054,176643,150082,324,1733,105569,175404,123848,73940,177388,73941,1667,1610,181109,150080,1734,103713,3763,2055,1731,123309,123310,73939,176645,150079,2040,2653,1735,165658)-- Vanilla Mother Pools /3

-- tbc
-- Ragveil 183043, 181275
-- Felweed 183044, 181270
-- Dreaming Glory 183045, 181271, 181272
-- Blindweed 183046 (tbc version)
-- Flame Cap 181276
-- Terocone 181277
-- Ancient Lichen 181278 (only dungeons)
-- Netherbloom 181279(netherstorm)181282(dungeons)
-- Nightmare Vine 181280, 181285
-- Mana Thistle 181281, 181284(flightmount)
-- Nethercite Deposit 185877
-- Netherdust Bush 185881
-- Netherwing Egg 185915 + Netherwing Egg Trap 185600
-- SELECT * FROM `gameobject` WHERE `id` IN (183043,183044,183045,183046,181270,181271,181272,181275,181276,181277,181278,181279,181280,181281,181282,181284,181285,185877,185881) AND `map`=530;
UPDATE `gameobject` SET `spawntimesecs`= 60,`animprogress`= 255 WHERE `id` IN (183043,183044,183045,183046,181270,181271,181272,181275,181276,181277,181279,181280,181281,181284,181285,185877,185881) AND `map`= 530; -- 2700

UPDATE `gameobject` SET `animprogress` = 255 WHERE `id` = 181555;
UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` = 181555 AND `map` IN (0, 1, 530);

UPDATE `gameobject` SET `animprogress` = 255 WHERE `id` = 181569;
UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` = 181569 AND `map` IN (0, 1, 530);

UPDATE `gameobject` SET `animprogress` = 255 WHERE `id` = 181570;
UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` = 181570 AND `map` IN (0, 1, 530);

UPDATE `gameobject` SET `animprogress` = 255 WHERE `id` = 181556;
UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` = 181556 AND `map` IN (0, 1, 530);

UPDATE `gameobject` SET `animprogress` = 255 WHERE `id` = 181557;
UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` = 181557 AND `map` IN (0, 1, 530);

-- Outland Dungeon Ores
UPDATE `gameobject` SET `spawntimesecs` = 86400 WHERE `guid` IN (3497242, 3497243, 3497128, 3497127, 3489213, 3486610, 3496020, 3486611, 3494261, 3497219, 3497218, 3489285, 3497216, 3497215, 3497208, 3497207, 3497206, 3497211, 3497212, 3496019, 3497213, 3497214, 3497217, 3497209, 3493144, 3493145, 3497210, 3497966, 3497334, 3497333, 3497331, 3497330, 3497332);

UPDATE `gameobject` SET `spawntimesecs`= 300,`animprogress`= 255 WHERE `id` IN (183043,183044,183045,183046,181270,181271,181272,181275,181276,181277,181279,181280,181281,181284,181285,185877,185881) AND `map`= 530; -- 2700
Xadras commented 8 years ago 
#!sql

-- proper respawn for gameobjects
UPDATE `gameobject` SET `spawntimesecs`='1' WHERE `id` IN (32,41,52,54,57,58,167,249,251,337,1166,1571,1727,1759,2086,2087,2716,2717,2718,2842,2867,182804,184859,184860,184727,184728,184115,26111,26110,47565,182122,184310,184466,184726,184727,184728,184744,185128,181963);
UPDATE `gameobject_template` SET `data2`='1',`data3`='1' WHERE `entry` IN (32,41,52,54,57,58,167,249,251,337,1166,1571,1727,1759,2086,2087,2716,2717,2718,2842,2867,182804,184859,184860,184727,184728,184115,185224,185225,185226,182122,184310,184466,184726,184727,184728,184744,185128,181963);

UPDATE `gameobject` SET `spawntimesecs`='90' WHERE `id` IN (331,333,334,2712,2739,2740,2741,2742);
UPDATE `gameobject_template` SET `data2`='90' WHERE `entry` IN (331,333,334,2712,2739,2740,2741,2742);

UPDATE `gameobject` SET `spawntimesecs`='180' WHERE `id` IN (271,375,1560,1562,2068);
UPDATE `gameobject_template` SET `data2`='180' WHERE `entry` IN (271,375,1560,1562,2068);

UPDATE `gameobject` SET `spawntimesecs`='300' WHERE `id` IN (1673,1723,2724,2743);
UPDATE `gameobject_template` SET `data2`='300' WHERE `entry` IN (1673,1723,2724,2743);

UPDATE `gameobject` SET `spawntimesecs`='600' WHERE `id` IN (182116);
UPDATE `gameobject_template` SET `data2`='600' WHERE `entry` IN (182116);

UPDATE `gameobject` SET `spawntimesecs`='900' WHERE `id` IN (271,272,276,2554,2560,2714,2744,2848);
UPDATE `gameobject_template` SET `data2`='900' WHERE `entry` IN (271,272,276,2554,2560,2714,2744,2848);

UPDATE `gameobject` SET `spawntimesecs`='2700' WHERE `id` IN (324,1610,1617,1618,1619,1620,1621,1622,1623,1624,1628,1667,1731,1732,1733,1734,1735,2040,2041,2042,2043,2044,2045,2046,2047,2054,2055,2653,2866);
UPDATE `gameobject_template` SET `data2`='2700' WHERE `entry` IN (324,1610,1617,1618,1619,1620,1621,1622,1623,1624,1628,1667,1731,1732,1733,1734,1735,2040,2041,2042,2043,2044,2045,2046,2047,2054,2055,2653,2866);

UPDATE `gameobject` SET `spawntimesecs`='3600' WHERE `id` IN (164885,164886,164887,164888);
UPDATE `gameobject_template` SET `data2`='3600' WHERE `entry` IN (164885,164886,164887,164888);

UPDATE `gameobject` SET `spawntimesecs`='7200' WHERE `id` IN (2039,2656,2843,2844,2845,2846,2847,2849,2850,2852,2855,2857);
UPDATE `gameobject_template` SET `data2`='7200' WHERE `entry` IN (2039,2656,2843,2844,2845,2846,2847,2849,2850,2852,2855,2857);

UPDATE `gameobject` SET `spawntimesecs`='43200' WHERE `id` IN (183385,183386);
UPDATE `gameobject_template` SET `data2`='43200' WHERE `entry` IN (183385,183386);