Skip to content

Instantly share code, notes, and snippets.

@FALL1N1

FALL1N1/Lab Work - Quest Fix

Created September 10, 2012 02:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save FALL1N1/3688494 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save FALL1N1/3688494 to your computer and use it in GitHub Desktop.
Download ZIP
SQL - TC2 Fix
Raw
Lab Work - Quest 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