Projekt

Allgemein

Profil

Fehler #1283 » loot for quest.sql

karn, 13.06.2012 00:54

 
1
/*
2
Author: Karn
3
Ticket: #1283
4
Descr.: Fix loot, and add script to the trigger-npc
5
*/ 
6

    
7
--Fix loot
8
INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount) VALUES
9
(27232, 37305, -100, 1, 0, 1, 1);
10
--add script to the trigger npc
11
UPDATE creature_template SET scale=3, ScriptName='fire_upon_the_waters_helper' WHERE entry=28013;
12

    
(1-1/3)