aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2022-01-04DB/Loot: Remove excess items from some creaturesoffl
Closes #24589 (cherry picked from commit fc80c41079e7271f230c0942253a04ce40c518e9)
2022-01-03DB/Hotfixes: Update hotfixes to build 41488funjoker
2022-01-02TDB 915.22011 - 2022/01/02TDB915.22011TDB Release
2022-01-02CI/CircleCI: Switch to Ubuntu 20.04 and MySQL 8jackpoz
(cherry picked from commit e3dfab52a639275ea130d279f4a6fe4312d34b06)
2022-01-02Rename sqlShauren
2022-01-02DB: Add drop script compatible with MySQL 8Giacomo Pozzoni
(cherry picked from commit 7e5c1cf453972e142613ab828b75c8635edf697d)
2022-01-02Scripts/Pet: Lil' K.T (#24528)Sorikoff
* Lil' K.T. * Rename 9999_99_99_99_world_335.sql to 2020_05_10_00_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 34fecde022e6e2a228111ee79a0e9f5f8a7bed12)
2022-01-02DB/Loot: Add references for Level 70 Darkmoon Cards (5-8) & Books and use ↵offl
them in TK & SSC Closes #24584 (cherry picked from commit 0b60b482730f03399104b64a69a14598cf137edc)
2022-01-02DB/Loot: Add some references for Black Templeoffl
Closes #24585 (cherry picked from commit 2ada2cfaea96c535d2996aad50ea14af50db25a7)
2022-01-02DB/Loot: Remove remaining herbs and ore with low chance to dropoffl
Closes #24586 Closes #24587 (cherry picked from commit 85e5735c0c464ab7d614e8e390c6f53b075b0cfc)
2022-01-02DB/loot: Fix some Azjol Nerub loots and skinningoffl
Closes #24582 (cherry picked from commit ae9646641f6cdb7624398073ccc086ac3ee5ba72)
2022-01-02DB/Loot: Remove some wrong lootsoffl
Ref #18182 (cherry picked from commit 7395eadd3afaa98e7c04e6c573015f015594e309)
2022-01-02DB/Loot: Add more items for Crimson Hand Battle Mageoffl
Closes #24576 (cherry picked from commit 63b1c740941e3b6af537b27024b12982064eddfa)
2022-01-02DB/Loot: Add reference for TK & SSC recipesoffl
Closes #24575 (cherry picked from commit bda7c385ee09b55068f2930cb1720ac160b862ed)
2022-01-02DB/Loot: Adjust LootMode & QuestRequired for some gameobjects lootoffl
Closes #24574 (cherry picked from commit bcafbcf68d7b825b82da142a1cf6e61dabce45f4)
2022-01-02DB/Loot: Remove more incorrect items from creaturesoffl
Closes #24573 (cherry picked from commit e64ed729d7bb17074b9f4fc1de80c726a2ae4903)
2022-01-02DB/Spawn: Fix some under-map creature and gobsKillyana
(cherry picked from commit 4e4a999e49fc7a9d0b55e19bd77fffd59683621a)
2022-01-02DB/Loot: Remove Motes of Shadow from nearly all demons and fix db errorsoffl
Closes #24563 (cherry picked from commit 2384d1d8e4fb667ac6d7103c4cf465a97b21a084)
2022-01-02DB/Loot: Restore some incorrectly removed referencesoffl
Closes #24559 (cherry picked from commit 6df0b7acdbfb83df2ba45355f59c648eae8a4213)
2022-01-02DB/Loot: Petrified Bandoffl
Closes #24558 (cherry picked from commit d46cc74f0051c0a776d19293ea758c5512eeaac0)
2022-01-02DB/Loot: Remove excess references from some creaturesoffl
Closes #24557 (cherry picked from commit ec17750fe9ea9f198315bb0803d9b8e022c67769)
2022-01-02DB/Loot: Add references for Tempest Keep & Serpenshrine Cavern epic itemsoffl
Closes #24556 (cherry picked from commit 7c1cf76e280005b4aaa774aeb20129c6c55edb7a)
2022-01-02DB/Loot: Delete reference for Green Hills of Stranglethorn PagesShauren
2022-01-02DB/Loot: Add reference for Depleted items (Ogri'la)offl
Closes #24546 (cherry picked from commit 2284790d31fd50dedc84fba97725bd7477c5165d)
2022-01-02DB/Loot: Remove more incorrect/weird items from lootoffl
Closes #24544 (cherry picked from commit 67b0adca02b9b103bccc168d318b2b0d5f7b248f)
2022-01-02DB/Loot: Remove incorrect items from some quest chestsoffl
Closes #24543 (cherry picked from commit 9b5375f858b7a9bac409cc0b17c56391f2787f5b)
2022-01-02DB/Loot: Remove incorrect skinning loot from some creaturesoffl
Closes #24538 (cherry picked from commit f7d385abf022b154c74120f83b5e3a11f2d19262)
2022-01-02DB/Loot: Remove more incorrect/weird items from lootoffl
Closes #24537 (cherry picked from commit fa2f42b596f9903139782205543588ec6cb2f1b1)
2022-01-02DB/Loot: Remove wrong items from Weapon Crates and Armor Cratesoffl
Closes #24536 (cherry picked from commit 9f5bafa7c662d39d891126f9c09de6cd654a0342)
2022-01-01DB/Loot: Remove incorrect/weird items from loot and adjust chanceoffl
Closes #24532 (cherry picked from commit e3b8b05aa7d811f2ca595e2aed5e8237947a0b81)
2022-01-01DB/Loot: Add missing bandages to Arathi Basin care packagesoffl
Closes #24533 (cherry picked from commit 4a8382d9059186b7e5c4132f86b2fb75dcc2cc35)
2022-01-01DB/Loot: Remove incorrect/weird loot from some gameobjectsoffl
Closes #24529 (cherry picked from commit 7701243f6ae419a302e624fefd5153fc7f9e09e0)
2022-01-01DB/Misc: Remove wrong loots and fix some creature leveloffl
Closes #24524 (cherry picked from commit a1bd3c1b2e2e532989d16dc8b39018af5721a610)
2022-01-01DB/Fishing: Update fishing skills level and loots in Molten Core, Blackrock ↵Killyana
Spire, Blackrock Depths, Blackrock Mountain and Burning Steppes (cherry picked from commit c3981f09d399ce44234417f3851bf323368a36a2)
2022-01-01DB/Quest: Becoming a Spellfire Tailoroffl
Closes #24522 (cherry picked from commit 9638f0ad0b70084f06bf3b6a9d9e49f00830772e)
2022-01-01DB/Conditions: Eruption - Lava FissureKillyana
Ref #11877 (cherry picked from commit 46a017d454b516de53ec23fd09c6b2be31f473fa)
2022-01-01DB/Pet: Lil' K.TKillyana
Ref #1364 (cherry picked from commit ee5eace3c6d1fa489572c052daef4834e9c7f12c)
2022-01-01DB/Pet: Toxic WastelingKillyana
Closes #12773 (cherry picked from commit 3f5e0927c3e7e3c0fc471f9d8dd4944b270dc40e)
2022-01-01DB/Conditions: Remove unneeded conditions for Onyxya Lair Eruption spellKillyana
Closes #11877 (cherry picked from commit 477f1baf9e9d57e3ae29e1631d76d92702083867)
2022-01-01DB/SAI: Update some SAI to use the correct action type to despawn ↵Killyana
gameobjects instead the old unexpected result of action 70 (cherry picked from commit 22af72b149a57d922933ccf24a28f8c28d09cc03)
2022-01-01DB/SAI: Update target for Closest unspawned game objectKillyana
Ref #24439 (cherry picked from commit 84c91cdef9185527ef3f856e185d5c7acf8be8b8)
2022-01-01Scripts/Black Temple: Fixed Reliquary of Souls after combat rewrite changes.Keader
Closes #23879 * Fixed combat start/evade issue * Fixed visual issue in Soul Release spell * Fixed some timers issue * Fixed some codestyle issues PS: Please, stop break my black temple babys. (cherry picked from commit d8e726de586070d24bec3c43a9ae795cf5482be0)
2022-01-01DB/GameObject: Zul Farrak Shallow Graves PoolingJinnaix
(cherry picked from commit 948b5905f7ec55376a648300c88bd02a8644c775)
2022-01-01DB/Creature: Servant of HodirKillyana
Closes #24406 (cherry picked from commit 1b897d33c76984f3600f51eeb6650599c859e780)
2022-01-01DB/Creature: Add waypoint to creatures near Omorok the Tree ShaperRushor
Closes #24359 (cherry picked from commit 82bc2c01e92066eea03ac9f31ea790b18e1d939c)
2022-01-01DB/GameObject: Spawn a missing Everfrost Shard and fix the rotation for ↵Killyana
other spawns (cherry picked from commit 19f67356d7cbf7e2777c543bf177e0ee0c49a4e6)
2022-01-01DB/GameObject: Arakkoa EggKillyana
(cherry picked from commit cc41323d6f04603c03d847e57a6ac79ff0fce3df)
2022-01-01Spell: Fix "Dark Conclave Ritualist Channel" range and castKillyana
(cherry picked from commit 64878e19fbbb95ee1741aed6013a27f7c6323f41)
2022-01-01Add realm ID for actions based ip logging (#24453)zartech22
* Update SQL queries to insert realm id * Insert the realm id when logging actions based on IP * Adding the SQL update file * Update 9999_99_99_99_auth.sql * Update auth structure Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e)
2022-01-01DB/Creature: Add some missing spawnsKillyana
(cherry picked from commit b69c5560dc3d8e8f2b957773d9d91bf5b6d21e89)