RG Live WotLK 3.3.5a

Danke, habe schon das meiste zusammen, sind noch einige mehr

select * from gameobject where id IN (
32,
52,
54,
57,
58,
119,
167,
249,
251,
263,
264,
271,
272,
276,
290,
321,
331,
333,
334,
337,
375,
759,
1165,
1166,
1560,
1562,
1571,
1594,
1617,
1618,
1620,
1621,
1622,
1623,
1624,
1673,
1723,
1727,
1731,
1732,
1736,
1759,
1760,
2045,
2046,
2054,
2055,
2068,
2084,
2086,
2087,
2689,
2690,
2691,
2707,
2708,
2709,
2710,
2712,
2714,
2716,
2717,
2718,
2724,
2739,
2740,
2741,
2742,
2743,
2867,
2891,
2892,
2893,
2907,
2910,
2912,
3236,
3237,
3240,
3290,
3640,
3646,
3685,
3726,
3743,
3767,
3768,
4406,
4608,
9630,
11713,
11714,
12654,
13360,
13872,
13891,
13949,
17282,
17783,
18036,
19015,
19016,
19021,
19022,
19283,
19284,
19541,
19595,
19596,
19597,
19598,
19602,
19603,
19868,
19869,
19870,
19871,
19872,
19873,
19877,
19903,
19904,
19905,
19906,
20691,
20725,
20726,
20727,
20807,
20920,
20925,
21052,
21277,
21530,
22245,
22246,
22550,
23505,
24798,
28024,
30854,
30855,
30856,
35252,
36738,
37098,
37099,
50935,
50936,
50937,
50982,
58369,
58595,
68865,
74731,
83763,
85562,
85563,
86492,
89634,
89635,
91138,
92013,
92420,
92423,
93192,
102984,
102985,
103574,
103600,
103628,
103662,
103664,
103711,
103713,
103815,
104564,
104569,
104574,
104575,
105169,
105170,
105171,
105172,
105174,
105175,
105176,
113757,
121264,
123214,
124388,
124389,
125477,
126049,
126158,
126260,
128293,
129127,
140911,
140971,
141853,
142076,
142088,
142181,
142191,
142344,
142477,
144053,
144054,
144064,
147557,
148499,
148506,
148513,
148514,
148515,
148516,
149036,
149480,
149481,
149482,
149483,
152094,
152095,
152620,
152621,
152622,
152631,
153123,
153239,
154357,
160845,
161521,
161526,
161527,
161557,
161752,
164662,
164690,
164910,
164958,
165554,
166863,
171938,
173266,
174728,
175165,
175166,
175207,
175264,
175322,
175324,
175329,
175330,
175331,
175334,
175382,
175384,
175385,
175407,
175487,
175488,
175565,
175566,
175588,
175606,
175628,
175629,
175708,
175785,
175802,
175888,
175889,
175891,
175892,
175893,
175928,
175949,
175950,
175964,
175965,
175966,
175970,
176089,
176092,
176116,
176142,
176143,
176145,
176150,
176151,
176189,
176206,
176207,
176208,
176209,
176249,
176344,
176356,
176484,
176485,
176486,
176487,
176630,
176634,
176751,
176752,
176753,
176785,
176793,
177241,
177264,
177287,
177464,
177624,
177747,
177750,
177784,
177785,
177789,
177790,
177792,
177794,
177804,
177805,
177806,
177844,
177926,
177964,
178084,
178085,
178087,
178104,
178105,
178106,
178144,
178184,
178185,
178186,
178195,
178204,
178227,
178553,
178784,
178785,
179004,
179005,
179006,
179007,
179008,
179024,
179025,
179426,
179545,
179553,
179562,
179565,
179644,
179826,
179828,
179832,
179908,
179914,
179915,
179922,
180216,
180435,
180436,
180501,
180510,
180511,
180512,
180600,
180671,
180917,
180921,
181053,
181083,
181098,
181107,
181110,
181133,
181138,
181139,
181140,
181151,
181238,
181239,
181248,
181249,
181276,
181277,
181278,
181279,
181280,
181281,
181283,
181372,
181385,
181574,
181594,
181620,
181626,
181627,
181628,
181629,
181637,
181644,
181645,
181665,
181671,
181674,
181675,
181680,
181681,
181683,
181686,
181687,
181696,
181697,
181746,
181757,
181770,
181771,
181854,
181871,
181872,
181873,
181874,
181875,
181876,
181891,
181892,
181893,
181894,
181897,
181898,
181916,
181963,
181981,
182011,
182031,
182050,
182054,
182063,
182095,
182116,
182119,
182122,
182127,
182128,
182139,
182166,
182184,
182185,
182199,
182256,
182265,
182355,
182505,
182520,
182532,
182541,
182542,
182581,
182584,
182599,
182600,
182601,
182606,
182797,
182798,
182799,
182804,
182936,
182937,
182938,
182940,
183050,
183394,
183395,
183396,
183397,
183441,
183767,
183813,
183814,
183933,
183934,
183935,
183945,
184031,
184075,
184077,
184115,
184121,
184122,
184123,
184310,
184433,
184443,
184466,
184478,
184560,
184589,
184607,
184689,
184691,
184716,
184726,
184727,
184728,
184744,
184793,
184795,
184810,
184811,
184812,
184813,
184814,
184815,
184859,
184860,
184869,
184870,
184947,
184948,
184980,
185015,
185033,
185128,
185130,
185152,
185182,
185200,
185201,
185220,
185224,
185225,
185226,
185233,
185302,
185497,
185541,
185562,
185567,
185569,
185574,
185577,
185939,
185954,
186263,
186266,
186272,
186273,
186301,
186325,
186329,
186390,
186397,
186404,
186423,
186427,
186450,
186463,
186466,
186467,
186468,
186587,
186591,
186595,
186607,
186618,
186619,
186632,
186640,
186662,
186679,
186684,
186729,
186733,
186828,
186830,
186831,
186832,
186885,
186886,
186912,
186938,
186950,
186954,
186955,
187022,
187023,
187026,
187027,
187032,
187033,
187039,
187072,
187238,
187264,
187333,
187381,
187577,
187659,
187660,
187661,
187670,
187671,
187673,
187677,
187683,
187684,
187685,
187686,
187687,
187689,
187697,
187875,
187885,
187886,
187897,
187898,
187899,
187900,
187901,
187902,
187980,
188015,
188016,
188017,
188018,
188113,
188120,
188131,
188140,
188164,
188236,
188237,
188238,
188260,
188262,
188263,
188345,
188351,
188359,
188367,
188432,
188434,
188441,
188442,
188461,
188462,
188489,
188499,
188501,
188502,
188503,
188518,
188525,
188530,
188600,
188601,
188646,
188650,
188658,
188659,
188670,
188671,
188675,
188676,
188677,
188691,
188699,
188702,
188703,
188705,
189288,
189291,
189293,
189295,
189298,
189306,
189983,
189992,
190032,
190127,
190189,
190208,
190223,
190354,
190399,
190447,
190453,
190454,
190455,
190483,
190484,
190500,
190533,
190534,
190537,
190540,
190541,
190542,
190543,
190558,
190560,
190561,
190562,
190563,
190578,
190584,
190612,
190613,
190614,
190623,
190624,
190625,
190633,
190643,
190660,
190691,
190696,
190702,
190717,
190718,
190719,
190720,
190778,
190836,
190937,
190938,
190947,
191084,
191092,
191179,
191209,
191210,
191458,
191519,
191530,
191531,
191532,
191533,
191534,
191535,
191536,
191537,
191543,
191567,
191568,
191576,
191708,
191770,
191773,
191780,
191781,
191782,
191783,
191814,
191815,
191843,
191844,
191845,
192058,
192081,
192082,
192127,
192171,
192172,
192187,
192188,
192189,
192190,
192191,
192192,
192243,
192536,
192556,
192676,
192693,
192773,
192788,
192818,
192823,
192824,
192825,
192826,
192827,
192828,
192908,
192909,
192910,
192911,
192912,
192941,
192942,
192943,
192944,
192945,
193059,
193091,
193092,
193196,
193197,
193199,
193200,
193201,
193403,
193404,
193405,
193406,
193560,
193561,
193597,
193767,
193792,
193793,
193905,
193943,
193944,
193945,
193946,
193967,
194126,
194158,
194159,
194200,
194201,
194213,
194238,
194313,
194315,
194327,
194331,
194340,
194341,
194423,
194424,
194957,
194958,
195022,
195037,
195274,
195344,
201367,
201384,
201592,
201778,
201794,
201874,
201875,
201937,
202179,
202180,
202240,
202241,
202339,
202340,
202947,
202948) and map IN (
33,
34,
36, 43, 47, 48, 70, 90, 109, 129, 189, 209, 229, 230, 249, 289, 269, 289, 309, 329, 349, 389, 409, 429, 469, 509, 531, 532, 533, 534, 540, 
534,
540,
542,
543,
544,
545,
546,
547,
548,
550,
552,
553,
554,
555,
556,
557,
558,
560,
562,
564,
565,
566,
568,
574,
575,
576,
578,
580,
595,
599,
600,
601,
602,
603,
604,
608,
609,
615,
616,
617,
618,
619,
624,
628,
631,
632,
649,
650,
658,
668,
724) and id not IN (13891, 1622, 1624, 1731, 1732, 2045, 1621, 20920, 142344, 182940) order by id;

das gibt dir dann wirklich alle aus, die in einer instanz spawnen + type chest sind + nen questitem besitzen

da muss aber gescheit aussortiert werden, da https://db.rising-gods.de/?object=142344 z.b. nicht direkt respawnen sollte

Bedeutung Live:

Der Bug wurde erfolgreich behoben und der Fix dazu befindet sich auf dem Spielserver. Sollte der Fehler weiterhin bestehen sollte ein neues Ticket ( https://redmine.rising-gods.de/projects/live/issues/new ) erstellt werden. Anmerkungen in dem alten abgewiesenen oder live genommenen Ticket werden ignoriert und gelöscht.