SET @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;