All pastes #2107686 Raw Edit

sql statemnet

public sql v1 · immutable
#2107686 ·published 2012-01-30 08:43 UTC
rendered paste body
DELETE FROM `gameobject_loot_template` WHERE `entry`=190459 AND `item`=38340;DELETE FROM `gameobject_loot_template` WHERE `entry`=190462 AND `item`=38346;DELETE FROM `gameobject_loot_template` WHERE `entry`=190473 AND `item`=38339;DELETE FROM `gameobject_loot_template` WHERE `entry`=190478 AND `item`=38386;-- Insert --INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`)VALUES(190459, 38340, -100, 1, 0, 1, 1),(190462, 38346, -100, 1, 0, 1, 1),(190473, 38339, -100, 1, 0, 1, 1),(190478, 38386, -100, 1, 0, 1, 1);-- Update --# Link items to quest so they dropUPDATE `quest_template` SET `ReqSourceId1` =  '38386', `ReqSourceId2` =  '38339', `ReqSourceId3` =  '38340', `ReqSourceId4` =  '38346', `ReqSourceCount1` =  '0', `ReqSourceCount2` =  '0', `ReqSourceCount3` =  '0', `ReqSourceCount4` =  '0' WHERE `entry` =12557; # Update script name so GO triggers scriptUPDATE `gameobject_template` SET `ScriptName`='go_finklesteins_cauldron' WHERE `entry`=190498;