rendered paste bodySET @NEWENTRY = NEWENTRY;
SET @OLDENTRY = OLDENTRY;
UPDATE gameobject_loot_template SET item = @NEWENTRY WHERE item = @OLDENTRY ;
UPDATE pickpocketing_loot_template SET item = @NEWENTRY WHERE item = @OLDENTRY;
UPDATE item_loot_template SET item = @NEWENTRY WHERE item = @OLDENTRY;
UPDATE creature_loot_template SET item = @NEWENTRY WHERE item = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId1 = @NEWENTRY
WHERE
RewChoiceItemId1 = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId2 = @NEWENTRY
WHERE
RewChoiceItemId2 = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId3 = @NEWENTRY
WHERE
RewChoiceItemId3 = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId4 = @NEWENTRY
WHERE
RewChoiceItemId4 = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId5 = @NEWENTRY
WHERE
RewChoiceItemId5 = @OLDENTRY;
UPDATE quest_template
SET
RewChoiceItemId6 = @NEWENTRY
WHERE
RewChoiceItemId6 = @OLDENTRY;
UPDATE quest_template
SET
RewItemId1 = @NEWENTRY
WHERE
RewItemId1 = @OLDENTRY;
UPDATE quest_template
SET
RewItemId2 = @NEWENTRY
WHERE
RewItemId2 = @OLDENTRY ;
UPDATE quest_template
SET
RewItemId3 = @NEWENTRY
WHERE
RewItemId3 = @OLDENTRY ;
UPDATE quest_template
SET
RewItemId4 = @NEWENTRY
WHERE
RewItemId4 = @OLDENTRY;