Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL - TC2 Fix
-- Lab Work Quest Replace Gobjects with Items
UPDATE `quest_template` SET `RequiredNpcOrGo1`=0, `RequiredNpcOrGo2`=0, `RequiredNpcOrGo3`=0, `RequiredNpcOrGo4`=0, `RequiredNpcOrGoCount1`=0, `RequiredNpcOrGoCount2`=0, `RequiredNpcOrGoCount3`=0, `RequiredNpcOrGoCount4`=0, `RequiredItemId1`=38386, `RequiredItemId2`=38339, `RequiredItemId3`=38340, `RequiredItemId4`=38346, `RequiredItemCount1`=1, `RequiredItemCount2`=1, `RequiredItemCount3`=1, `RequiredItemCount4`=1 WHERE `Id`=12557 LIMIT 1;
-- Missing gameobject
UPDATE `gameobject` SET `id`=190459 WHERE `guid`=55202 LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment