Код:
Index: cswowd/include/report_generator.php
===================================================================
--- cswowd/include/report_generator.php (revision 343)
+++ cswowd/include/report_generator.php (working copy)
@@ -1140,7 +1140,7 @@
case 'go_take': $this->table = '(`quest_template` join `gameobject_involvedrelation` ON `quest_template`.`entry` = `gameobject_involvedrelation`.`quest`)';break;
case 'npc_giver': $this->table = '(`quest_template` join `creature_questrelation` ON `quest_template`.`entry` = `creature_questrelation`.`quest`)';break;
case 'npc_take': $this->table = '(`quest_template` join `creature_involvedrelation` ON `quest_template`.`entry` = `creature_involvedrelation`.`quest`)';break;
- case 'mail_loot': $this->table = '(`quest_template` join `quest_mail_loot_template` ON `quest_template`.`entry` = `quest_mail_loot_template`.`entry`)';break;
+ case 'mail_loot': $this->table = '(`quest_template` join `mail_loot_template` ON `quest_template`.`RewMailTemplateId` = `mail_loot_template`.`entry`)';break;
default: $this->table = '`quest_template`';break;
}
$this->db_fields = '`quest_template`.`entry`';
@@ -1177,7 +1177,7 @@
// Create quest list require item for comlete
function requireItem($entry, $giveQuest)
{
- $this->doRequirest('(`ReqItemId1`= ?d OR `ReqItemId2`= ?d OR `ReqItemId3`= ?d OR `ReqItemId4`= ?d OR `ReqSourceId1`= ?d OR `ReqSourceId2`= ?d OR `ReqSourceId3`= ?d OR `ReqSourceId4`= ?d) AND `quest_template`.`entry` <> ?d', $entry, $entry, $entry, $entry, $entry, $entry, $entry, $entry, $giveQuest);
+ $this->doRequirest('(`ReqItemId1`= ?d OR `ReqItemId2`= ?d OR `ReqItemId3`= ?d OR `ReqItemId4`= ?d OR `ReqItemId5`= ?d OR `ReqItemId6`= ?d OR `ReqSourceId1`= ?d OR `ReqSourceId2`= ?d OR `ReqSourceId3`= ?d OR `ReqSourceId4`= ?d) AND `quest_template`.`entry` <> ?d', $entry, $entry, $entry, $entry, $entry, $entry, $entry, $entry, $entry, $entry, $giveQuest);
}
// Create quest list prowide item at take
function provideItem($entry, $giveQuest)
Про wowd_creature_spells ответ был...