20130315update.sql 1.8 KB

123456789101112131415161718192021
  1. UPDATE character_quests SET name='Q00324_SweetestVenom' WHERE name='324_SweetestVenom';
  2. UPDATE character_quests SET name='Q00328_SenseForBusiness' WHERE name='328_SenseForBusiness';
  3. UPDATE character_quests SET name='Q00331_ArrowOfVengeance' WHERE name='331_ArrowForVengeance';
  4. UPDATE character_quests SET name='Q00341_HuntingForWildBeasts' WHERE name='341_HuntingForWildBeasts';
  5. UPDATE character_quests SET name='Q00605_AllianceWithKetraOrcs' WHERE name='605_AllianceWithKetraOrcs';
  6. UPDATE character_quests SET name='Q00606_BattleAgainstVarkaSilenos' WHERE name='606_WarWithVarkaSilenos';
  7. UPDATE character_quests SET name='Q00607_ProveYourCourageKetra' WHERE name='607_ProveYourCourage_Ketra';
  8. UPDATE character_quests SET name='Q00608_SlayTheEnemyCommanderKetra' WHERE name='608_SlayTheEnemyCommander_Ketra';
  9. UPDATE character_quests SET name='Q00609_MagicalPowerOfWaterPart1' WHERE name='609_MagicalPowerOfWaterPart1';
  10. UPDATE character_quests SET name='Q00610_MagicalPowerOfWaterPart2' WHERE name='610_MagicalPowerOfWaterPart2';
  11. UPDATE character_quests SET name='Q00611_AllianceWithVarkaSilenos' WHERE name='611_AllianceWithVarkaSilenos';
  12. UPDATE character_quests SET name='Q00612_BattleAgainstKetraOrcs' WHERE name='612_WarWithKetraOrcs';
  13. UPDATE character_quests SET name='Q00613_ProveYourCourageVarka' WHERE name='613_ProveYourCourage_Varka';
  14. UPDATE character_quests SET name='Q00614_SlayTheEnemyCommanderVarka' WHERE name='614_SlayTheEnemyCommander_Varka';
  15. UPDATE character_quests SET name='Q00615_MagicalPowerOfFirePart1' WHERE name='615_MagicalPowerOfFirePart1';
  16. UPDATE character_quests SET name='Q00616_MagicalPowerOfFirePart2' WHERE name='616_MagicalPowerOfFirePart2';
  17. UPDATE quest_global_data SET var='Q00610_respawn' WHERE var='610_respawn';
  18. UPDATE quest_global_data SET var='Q00616_respawn' WHERE var='616_respawn';
  19. ALTER TABLE `characters` DROP `varka_ketra_ally`;