Project

General

Profile

Fehler #36896

[Quest][Zul'Gurub][A/H] Halskette durch Zandalari Ruf

Added by mastermind 6 months ago. Updated 6 months ago.

Status:
Live
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
10.10.2019
DB-Link:

Description

Wie bei allen großen Raidinstanzen gibt es auch bei Zul'Gurub für jede Klasse eine Questreihe, die mit steigender Rufstufe ein neues Item bringt. Hier ist es eine Halskette. Ab Freundlich bekommt man die erste von einem Questgeber auf der Insel Yojamba. Die Questgeber sind unterschiedlich, stimmen aber auf dem Server.
Ohne was zu erledigen, kann man mit steigender Stufe seine alte Kette gegen eine bessere eintauschen bis zu einem Epic auf ehrfürchtig.

Eine Beispielreihe (Magier):

Der Stein des Kajaro
Der Stein des Kajaro
Der Stein des Kajaro
Das Juwel von Kajaro

Fehler ist hier, dass jeder, alle Ketten für jede Klasse holen kann. Bringen tut einem das nicht, da die Items klassengebunden sind, allerdings kann man sie gegen Gold verkaufen.

Fix:

UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8041;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8042;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8043;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8044;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8045;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8046;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8047;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8048;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8145;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8146;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8147;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8148;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8141;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8142;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8143;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8144;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8149;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8150;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8151;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8152;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8116;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8117;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8118;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8119;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8101;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8102;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8103;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8104;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8106;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8107;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8108;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8109;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8110;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8111;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8112;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8113;

History

#1 Updated by b2b-julil 6 months ago

da haben sich ein paar falsche quest ids eingeschlichen, bitte mal überprüfen.

8149, 8150, 8151 und 8152 stimmen zum beispiel nicht

#2 Updated by b2b-julil 6 months ago

  • Status changed from Neu to Bestätigt

#3 Updated by mastermind 6 months ago

Hier aktualisiert, hat nur die mit der Klasse 16 betroffen:

UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8041;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8042;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8043;
UPDATE `quest_template` SET `RequiredClasses` = '1' WHERE `entry` = 8044;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8045;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8046;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8047;
UPDATE `quest_template` SET `RequiredClasses` = '2' WHERE `entry` = 8048;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8145;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8146;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8147;
UPDATE `quest_template` SET `RequiredClasses` = '4' WHERE `entry` = 8148;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8141;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8142;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8143;
UPDATE `quest_template` SET `RequiredClasses` = '8' WHERE `entry` = 8144;

UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8049;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8050;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8051;
UPDATE `quest_template` SET `RequiredClasses` = '16' WHERE `entry` = 8052;

UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8116;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8117;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8118;
UPDATE `quest_template` SET `RequiredClasses` = '64' WHERE `entry` = 8119;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8101;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8102;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8103;
UPDATE `quest_template` SET `RequiredClasses` = '128' WHERE `entry` = 8104;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8106;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8107;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8108;
UPDATE `quest_template` SET `RequiredClasses` = '256' WHERE `entry` = 8109;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8110;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8111;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8112;
UPDATE `quest_template` SET `RequiredClasses` = '1024' WHERE `entry` = 8113;

#4 Updated by b2b-julil 6 months ago

  • Status changed from Bestätigt to Testbereit

#5 Updated by B2B-firespell 6 months ago

  • Status changed from Testbereit to Pending

#6 Updated by B2B-Marv312 6 months ago

  • Assignee set to b2b-julil

#7 Updated by b2b-julil 6 months ago

  • Status changed from Pending to Live
  • Assignee deleted (b2b-julil)

Also available in: Atom PDF