Files
mod-azerothshard/data/sql/db-world/09_lfg_rewards_update.sql
Walter Pagani 9c25df7d39 chore. Compatibility with the latest version (#24)
* chore. Compatibility with the latest version

* ci: add apps/ directory for ci scripts

* Update SQL files

* Update workflow and upload template

* rewrite getf method

* Revert "Update workflow and upload template"

This reverts commit 7951beaca606f8667d107e4436dfe65d43cd947b.

* Pointer to local variable

* update workflow

* Revert "Pointer to local variable"

This reverts commit 22a66673e94b00dabb88f4bde297b0d44898a27c.

* Change const char for std::string

* AzthLanguage in modules

* fix build error

* fix build

* fix. sql

* fix sql

---------

Co-authored-by: Helias <stefanoborzi32@gmail.com>
2024-03-20 02:57:11 -03:00

4 lines
309 B
SQL

UPDATE quest_template SET RewardFactionID1 = 948, RewardFactionValue1 = 3, RewardItem2 = 37711, RewardAmount2 = 3 WHERE id IN (SELECT firstQuestId FROM lfg_dungeon_rewards);
UPDATE quest_template SET RewardFactionID1 = 948, RewardFactionValue1 = 1 WHERE id IN (SELECT otherQuestId FROM lfg_dungeon_rewards);