Project

General

Profile

Actions

Fehler #36896

closed

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

Added by mastermind almost 3 years ago. Updated almost 3 years ago.

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

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;
Actions #1

Updated by b2b-julil almost 3 years ago

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

8149, 8150, 8151 und 8152 stimmen zum beispiel nicht

Actions #2

Updated by b2b-julil almost 3 years ago

  • Status changed from Neu to Bestätigt
Actions #3

Updated by mastermind almost 3 years 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;
Actions #4

Updated by b2b-julil almost 3 years ago

  • Status changed from Bestätigt to Testbereit
Actions #5

Updated by B2B-firespell almost 3 years ago

  • Status changed from Testbereit to Pending
Actions #6

Updated by B2B-Marv312 almost 3 years ago

  • Assignee set to b2b-julil
Actions #7

Updated by b2b-julil almost 3 years ago

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

Also available in: Atom PDF