100 Commits
Author SHA1 Message Date
zxbiohazardzx 6e9584696c DB/Loot: correct petdrops from the fishingbags and cleanup the misused reference
Closes #10975
2013-09-30 11:27:13 +02:00
ZxBiohazardZx 99c94f34e4 DB/Misc: Fix startup errors & typo 2013-09-01 22:00:52 +02:00
ZxBiohazardZx 7facda2002 DB/Loot: make sure to update & delete the right templates, updated file! 2013-09-01 21:41:12 +02:00
ZxBiohazardZx ed38441271 DB/Loot: Rework skinning_loot_template definitions, removing the horrible definitions ripped from wowhead and replacing them with a proper defined set of loot
Closes #10610
2013-09-01 21:29:34 +02:00
ZxBiohazardZx 22d07db886 DB/commit: the mining is also useable for 434, thus removed the _335 tag 2013-08-15 01:04:29 +02:00
ZxBiohazardZx fa10737861 DB/Loot: while at it also did the mining veins 2013-08-14 17:11:17 +02:00
ZxBiohazardZx 5890f95f7c DB/Loot: Fix some horrible loot definitions for Herbalism, reworked ALL Herbs 2013-08-14 16:11:22 +02:00
ZxBiohazardZx d6cb32e45c Commit: add newline to endoffile 2013-07-05 13:08:53 +02:00
ZxBiohazardZx 0e4cebf9c6 DB/creature: another c_t_a to c_a convert 2013-06-29 18:51:48 +02:00
ZxBiohazardZx cc899ddc2d DB/Misc:
- Convert c_t_a entry into c_a to prevent errors
 - Allow mounting in Black Temple <outdoor parts>
 - fix by exodius to add sound for Corrupted Ashbringer
Closes #9997
2013-06-29 18:46:22 +02:00
ZxBiohazardZx f5e073ddec DB/Item: set the correct PageText value for item 37540
Closes #10077
2013-06-25 19:48:29 +02:00
ZxBiohazardZx b23a6d2d00 Merge pull request #10095 from Kirkhammett/patch-1
Update README
2013-06-25 06:20:12 -07:00
ZxBiohazardZx 4b0ca6831a DB/Commit: add DRAKE define to fix query 2013-06-25 01:14:09 +02:00
ZxBiohazardZx e7aa5679ee Merge pull request #9938 from LeGuybrush/organize-old
Organize sql/old directory
2013-06-04 01:08:23 -07:00
ZxBiohazardZx 364f08fcbc Merge pull request #9848 from Foldor/master
Remove a duplicate semicolon
Closes #9848
2013-05-23 15:08:51 -07:00
ZxBiohazardZx 88c41a44ef commit: added newline at eof 2013-05-23 00:03:25 +02:00
ZxBiohazardZx 62ecc11cfb DB/Loot:
Update loot for Scarab Coffers in AQ (related to issue #9638)
Update loot for Axtroz (related to issue #9610)
2013-04-21 12:27:52 +02:00
ZxBiohazardZx 6431dc8b12 DB/Trainers: Add Enchant Boots - Lesser Accuracy to appropriate trainers
Closes #9571
2013-04-06 12:25:50 +02:00
ZxBiohazardZx e277f0401b added = sign to prevent issues for people etc 2013-04-03 21:39:13 +02:00
ZxBiohazardZx e3924a58f6 fix wrong pointid in previous commit 2013-03-23 11:06:36 +01:00
ZxBiohazardZx da5829b7da DB/SAI Update SAI param for Ruined lifeboat & add SAI for Negolas
Closes #8846
2013-03-23 10:45:32 +01:00
ZxBiohazardZx e7d333f708 Commit: fuck mondays, i cba to fix it, its out 2013-03-04 13:22:32 +01:00
ZxBiohazardZx 56efb2df44 Commit: its monday....... 2013-03-04 13:05:03 +01:00
ZxBiohazardZx 534bdae0c9 DB/Quest: fix some questrequirements in BE start zone by Praxious, Closes #9156
Commit: fix naming on previous file, fix typo in 2013_03_04_00
2013-03-04 13:00:03 +01:00
ZxBiohazardZx e826e37815 DB/Waypoints: add waypoints for Doomsayer Jurim, thx Kelsarhu
Closes #8958
2013-03-04 12:55:56 +01:00
ZxBiohazardZx 6984fbe16b DB/Gameobject: Add missing Gameobject
Closes #8948
2013-03-04 12:52:52 +01:00
ZxBiohazardZx 13568b1853 DB/Misc:
Add Missing Sunreaver Guardian Mage (thx aokromes) Closes #9311
Add SAI for Mission: The Abyssal Shelf (thx Kirkhammett)
2013-03-03 12:48:19 +01:00
ZxBiohazardZx bd01370dff DB/Conditions: add conditions to Lokhtos Darkbargainer Thx badmoon for initial fix
Closes #9028
2013-02-19 21:50:55 +01:00
ZxBiohazardZx e8b7f8f61b DB/Creature: Add texts for Lurgglbr
Closes #1608
2013-02-16 10:36:54 +01:00
ZxBiohazardZx 2aa554db34 Typo: i will now go hang myself..... _ typo 2013-01-27 17:42:44 +01:00
ZxBiohazardZx b9cb92cc88 Fix/Commit: push final file, not the workingcopy 2013-01-27 17:41:26 +01:00
ZxBiohazardZx e591f886ff DB/Misc:
Add Rare Bosses to Dire Maul Closes #5882
Add SAI for Quest: No Mercy for the Captured Closes #568
Add Spawn for Sand Shark Closes #5925 (thx Mogale)
Fix underground Centaurs Closes #8498 (thx baric)
2013-01-26 22:12:04 +01:00
ZxBiohazardZx 1c95762849 DB/Loot: some modifications to Mithrill Bound Trunk
Closes #3801
2013-01-26 19:46:14 +01:00
ZxBiohazardZx 1682a72d1a DB/Loot: add loot for Protectorate Treasure Cache and make sure you always get sometime out of it...
Closes #8589
2013-01-26 19:20:15 +01:00
ZxBiohazardZx 51611c7c22 DB/Creature remove obsolete creature_addon records (default values in all fields) 2013-01-19 11:22:29 +01:00
ZxBiohazardZx 6ec1652b60 DB/Creatures: more cleanups to creature_addon table: roughly 200 unrequired auras removed, SAI is already applying these.... 2013-01-19 11:09:49 +01:00
ZxBiohazardZx dd19bec433 DB/Creature: more cleanups in creature_template_addon: remove all pointless entries (0 in all fields, bytes2=1) 2013-01-18 23:49:12 +01:00
ZxBiohazardZx 29deb56877 DB/Creatures: cleaning up creature_template_addon, removed auras that where also/already added by SAI, should reduce some runtime errors 2013-01-18 23:31:35 +01:00
ZxBiohazardZx d9339cea60 DB/SAI: Fix startup DB errors 2013-01-09 15:59:15 +00:00
ZxBiohazardZx c3134bc6cd DB/Creature: Remove ALOT of auras and creature_addon definitions, all these entries should be handled by SAI already, if not then SAI should be fixed 2013-01-08 00:45:44 +01:00
ZxBiohazardZx 4d14c58dd4 DB/Creature: Remove creature_addon aura for Frost Armor for the NPCs that have SAI defined: if the creature requires Frost Armor then SAI should cast it. this should reduce some runtime errors for duplicate auras 2013-01-07 17:37:39 +01:00
ZxBiohazardZx 5fe399195f DB/Cleanup: Remove duplicate aura definitions in creature_addon and creature_template addon 2013-01-06 23:36:53 +01:00
ZxBiohazardZx facea9f158 db/commit: fix sql error 2013-01-04 20:27:05 +01:00
ZxBiohazardZx 51b5e04a88 Various issuetracker fixes
Immunities for Shambling Horror by Valcorb Closes #7541
Flying and  a path for Higherch by Malcrom Closes #7436
SAI for Talonshrike by Nevadas Closes #8639
2013-01-03 23:06:31 +01:00
ZxBiohazardZx fd052dedc6 typofix IN not = 2013-01-03 20:45:58 +01:00
ZxBiohazardZx fb273bf0af DB/Misc: fix some startup errors 2013-01-03 20:39:56 +01:00
ZxBiohazardZx 0419abf223 DB/Item: add proper flags to real-life-duration items Closes #3601 2013-01-03 15:54:15 +01:00
ZxBiohazardZx 9e6344b220 DB/Gameobject: Add Invincible Grave Plaque Closes #8693 2013-01-03 15:47:24 +01:00
ZxBiohazardZx afc21ccf29 DB/Misc: remove the scripts! 2013-01-03 11:57:43 +01:00
ZxBiohazardZx abcc6c5fd8 DB/SAI: converted the last gameobject_script to SAI, jeej! 2013-01-03 11:52:27 +01:00
ZxBiohazardZx c56a83e85c DB/Scripts and more gameobject_script removals, only 1 left?! --> please not that not all doors may function yet. this is a known issue 2013-01-03 11:46:51 +01:00
ZxBiohazardZx 5ae81724f3 DB/Script: more conversions THIS UNSUPPORTS THE BLACKROCK DUNGEON untill a fix is found for SAI issues
also fixed naming of file
2013-01-03 11:25:34 +01:00
ZxBiohazardZx 8403081240 DB/Script: More removal of gameobject scripts. some of the doors do not work yet, this is a known issue 2013-01-03 11:14:10 +01:00
ZxBiohazardZx ec1d17f207 DB/Scripts: More removals of gameobject_scripts
UNSUPPORTS old treasure chest in Scholomance
2013-01-03 02:00:10 +01:00
ZxBiohazardZx c6ed15f826 DB/Script: more gameobject_script removals: Stasis Chamber Alpha conversion 2013-01-03 01:31:06 +01:00
ZxBiohazardZx a7a23cca34 DB/Script: More horribad script removals:
Zul gurub: Brazier summons 4 creatures, removed 3 bad spawns, and unsupported the encounters starting with Gri'lek
Fix the MovementType issue Closes #8834
2013-01-03 01:12:04 +01:00
ZxBiohazardZx 8d1e542231 DB/Script : kill more gameobject_scripts. THIS UNSUPPORTS THE FOLLOWING DUNGEON BOSSES:
Scholomance: Kirtenos the Herald
Scarlet Monestry - Cathedral: Fairbanks, Mograine, Whitemane
2013-01-03 00:52:14 +01:00
ZxBiohazardZx dbf99992e1 DB/Script: Add the Undead Postman script to the proper mailboxes and use SAI instead of gameobject_script
TODO: add Parcel Packet when i have more information about it
2013-01-02 21:41:09 +01:00
ZxBiohazardZx 922459783c DB/Scriptremoval: Remove not working scripts from gameobject_scripts: the objecttype is not correct for this useage 2013-01-02 20:23:06 +01:00
ZxBiohazardZx f7b89357c6 DB/SAI: convert the gameobject_script for stonewraught pass lever, and fix the non-working one while at it. also remove the uldaman gameobject_script. it has a CPP, if any scripts are required put it there! 2013-01-02 15:59:11 +01:00
ZxBiohazardZx 718313f1b8 DB/Startups: apparently we had some creatures with wrong movementtype... 2012-12-28 16:11:04 +01:00
ZxBiohazardZx a5e4fc8fd4 DB/Cleanup: actually remove the quest_end_scripts and correct a questid in previous push 2012-12-16 00:08:51 +01:00
ZxBiohazardZx 18da48881b DB/SAI: Convert some more quest_end_scripts 2012-12-16 00:01:12 +01:00
ZxBiohazardZx cb501a2aa4 DB/Scripts: Remove deprecated Quest_end_scripts and replace them with SAI 2012-12-09 12:26:07 +01:00
ZxBiohazardZx 59f8457bd4 DB/Cleanup: remove unused db_script_strings 2012-12-08 23:41:30 +01:00
ZxBiohazardZx e2020f284b DB/Misc: actually remove the scripts instead of keeping pointers alive that arent needed 2012-12-08 23:37:51 +01:00
ZxBiohazardZx ce2312f28c DB/Scripts: Remove deprecated Quest_end_scripts and replace them with SAI 2012-12-08 22:55:50 +01:00
ZxBiohazardZx 0abeb1b5c3 DB/Scripts: Remove deprecated Quest_end_scripts and replace them with SAI 2012-12-07 21:56:05 +01:00
ZxBiohazardZx fef854e8f2 DB/Misc: Various issuetracker fixes and quest_end_scripts conversions
Fix Wintergrasp Tower Cannon Closes #8054
Fix Stacking for Kings and Sanctuary Closes #8276
Fix Quest: Prepping the Speech Closes #8364
Update spawnposition for Sludge Beast Closes #8495
Update SAI fixing Quest Cycle of Rebirth Closes $8504, Closes #7523
Update SAI for quest No Rest for the Wicked Closes #8506
Add conditions for Quest: DrTerribles Building a better flesh giant Closes #8547
Convert some quest_end_scripts to SAI
2012-12-07 15:32:56 +01:00
ZxBiohazardZx c44c6248ec DB/Misc: Various fixes from issuetracker:
correct SAI parameters, should fix quest "Not On My Watch" Closes #4149
Add SAI for quest "Eliminate the Competition" Closes #4206
add SAI for quest "Bringing Down the Iron Thane" Closes #4252
add SAI for event after quest "The Dragonforged Hilt" Closes #4888
2012-11-25 12:49:31 +01:00
ZxBiohazardZx f9b2fac9eb DB/Misc: Various fixes from the issuetracker, Various Authors, see issues for details
Fix issue for warlock quest "The Binding" Closes #373
add SAI and gossip for quest "Glyph Chasing" Closes #1682
add spells for quest "On Ruby Wings" Closes #3068
add spawns for quest "Vengeful Souls" Closes #3232
add conditions and spells for quest "Seal of Ascension" Closes #3608
add SAI for quest "Hungry Nether Rays" Closes #3656
add SAI for quest "The Restless Dead" Closes #3853
2012-11-25 12:27:50 +01:00
ZxBiohazardZx cabfcb1a3d Readd support for quest 11198 (SAI)
Closes #1421 : Morridune is hostile for Alliance.
Closes #1426 : Attack on Camp Narache
Closes #1518 : Eramas Brightblaze's attack type
Closes #1520 : Banish the Demons
Closes #1843 : Old Crystalbark
Closes #1881 : The Honored Dead
Closes #2075 : Bring Down Those Shields
Closes #2077 : Eyes of the Eagle
Closes #2324 : Battered Hilt
Closes #4363 : Crashin' Thrashin' Racer
Closes #5320 : Fields of Grief
Closes #8408 : ICC Trash Mobs Damage
Closes #8401 : Anatoly will talk
Closes #8405 : A Sister's Pledge and Hour Of The Worg
Closes #8404 : An Experienced Guide
Closes #8382 : Agmar's Hammer missing gossips
Closes #8032 : Destroying the Altars
Closes #7996 : Set Required races for some Argent Tournament quests
Closes #7969 : Pyroblast Cinnamon Ball (37582), G.N.E.R.D.S. (37583), Soothing Spearmint Candy (37584) & Chewy Fel Taffy (37585) duration fix
Closes #7964 : Hyperspeed Acceleration
Closes #7824 : Missing Brewfest Vendors
Closes #7823 : This One Time, When I Was Drunk... Alliance quest giver fix
Closes #7416 : Twilight of the Dawn Runner
Closes #7301 : Ashenvale's spirit healer
Closes #7219 : The Ashenvale Hunt
Closes #7079 : Corporal Thund Splithoof
Closes #7155 : Aleric Hawkins
Closes #7011 : Inactive Fel Reaver
Closes #6959 : There Is No Hope
Closes #6212 : Merciful Freedom
2012-11-25 01:06:55 +01:00
ZxBiohazardZx e29be15432 DB/Quests: Convert/remove quest_start_script entries
THIS (TEMP) REMOVES SUPPORT FOR QUESTS 434,10985,11108,11198!
2012-11-24 14:42:35 +01:00
ZxBiohazardZx 8bd462b6d1 Core/scritps: change enum to fix compile 2012-11-20 23:20:14 +01:00
ZxBiohazardZx 78c873c1d3 Commit/Naming: update filename from automerge 2012-11-20 22:56:07 +01:00
ZxBiohazardZx 074b2e3936 Merge pull request #8371 from Gacko/creaturetext
Core/DB: Some script to creature text conversions...
2012-11-20 13:53:55 -08:00
ZxBiohazardZx 7c6c24fce8 DB/commit: darn incremental number fail 2nd time today 2012-11-19 22:11:39 +01:00
ZxBiohazardZx e5c047c90d DB/Misc: some cleanups 2012-11-19 21:40:45 +01:00
ZxBiohazardZx 731d30664f Commit: change SQL name to match indexing 2012-11-19 21:20:56 +01:00
ZxBiohazardZx dc5fac23dd db/commit: NULL is a bad param, fixed 2012-11-19 21:06:50 +01:00
ZxBiohazardZx 7a30ffe68e commitfix: add newline to prevent possible issues with next file 2012-11-19 20:46:51 +01:00
ZxBiohazardZx cdec49fc85 DB/misc:
NPC Jezelle Pruitt Closes #856
Standards and Practices Closes #1539
An Improper Burial Closes #1977
Postponing the Inevitable Closes #2350
Rune of Dawn Closes #2782
No Rest For The Wicked Closes #4013
Gregory Tabor Closes #4350
Anatoly Will Talk Closes #4551
Pilgrim's Bounty Closes #5025
The Fallen Sisters Bugged again Closes #5419
The Lost Spirits Closes #5647
Feedin' Da Goolz Closes #5679
The One That Got Away Closes #5764
Find the Ancient Hero Closes #5785
Shattrath Daily Quests missing ExclusiveGroup Closes #5821
Nether Drake Egg Closes #6284
Quest - 28056 Closes #6627
Before the Gate of Horror Closes #5760
Quest Audio - 12593 Closes #6632
Souls of the Decursed Closes #6724
Norgannon's Shell (12872,12928) Closes #7837
Windcaller Yessendra (15498),Warden Haro (15499),Keyl Swiftclaw (15500),Mokvar (16012) & Deliana (16013) quests  Closes #7907
Attunement to the Core (7487,7848) Closes #7908
spawn location in OG near Rogg (37072) Closes #8021
Missing Fires for Hallow End Q  Closes #8086
Wickerman Festival NPC & GO's Closes #8133
Hallow's End Pumpkin Treat & Tricky Treat time fix Closes #8244
Exhausted Vrykul - not responding after using discipline stick on him Closes #8288
2012-11-19 20:35:20 +01:00
ZxBiohazardZx 2a00b20da9 DB/Misc:
Add Support for Day of the Dead Closes #3761
Add Ray'ma for Brewfest Closes #3132
Add Spellfocus for Mistcaller Ynfvar see issue #3563
Add SAI for Somnus,Orokk Omosh, Raschal the Courrier,Plainstalker
Closes #3635
Closes #3678
Closes #3679
Closes #3680
Add Spawns & support for Quest Frankly, it makes no sense Closes #3749
Add SAI support for Quests: You Robot, Deaths Door
Closes #3809
Closes #3822
Fix Teribus the Cursed Closes #3930
Add SAI support for quests: To Catch a Sparrowhawk, Stop the Ascension, Melding of Influences
Closes #4803
Closes #4843
Closes #4996
2012-11-17 11:04:51 +01:00
ZxBiohazardZx 5951947753 DB/Misc: Various fixes from the Issue Tracker
Closes #1959
Closes #2297
Closes #2399
Closes #3038
Closes #3131
Closes #3225
Closes #3351
Closes #3432
Closes #3548
2012-11-14 10:32:44 +01:00
ZxBiohazardZx b2efb060a3 Db/Misc: oneline fixes merged, thx Nelgano & Gecko32 for parts of it
Closes #8021
Closes #8019
Closes #7361
Closes #7184
2012-11-12 22:06:50 +01:00
ZxBiohazardZx ebd2c12f99 DB/Quest: add questrequirements for Doomguard Minion Questline
Closes #7124
2012-11-12 21:30:38 +01:00
ZxBiohazardZx 7bdd596e6d DB/Gossip: Add gossip menus for Midsummer
Closes #6886
2012-11-11 12:50:03 +01:00
ZxBiohazardZx a5a9503bbe DB/Loot: readd loot to stinky from clean 49 (removed by accident)
Closes #8222
2012-11-03 10:09:41 +01:00
ZxBiohazardZx cd8e9dfb52 DB/Conditions: update ItemEquipped Condition2/3 values to 0 2012-10-29 23:41:10 +01:00
ZxBiohazardZx 57f84c920b DB/Conditions: slightly modify the conditions for Sealed Chest: it only drops IF: you dont have it already AND you are wielding Shadowmourne AND you are on The Lich Kings Last Stand AND if you did not do Personal Property quest yet
Closes #8167
2012-10-27 10:44:49 +02:00
zxbiohazardzx 608ed2cf1d DB/Loot: increase dropchance for Plump Buzzard Wing
Closes #7989
2012-10-07 17:43:13 +02:00
ZxBiohazardZx 3aa586986f Core/Codestyle: some small improvements for Doxygen Purposes 2012-10-02 23:20:03 +02:00
ZxBiohazardZx e4cdd0956a DB/Loot : correct some lootids, remove pointless sharedid, Thx Kandera for the assist 2012-10-02 21:17:14 +02:00
zxbiohazardzx 09b47ecad1 DB/Loot: Fix loot for VoA (thx to Gecko32 for the work)
closes #6833
2012-09-19 11:23:03 +02:00
ZxBiohazardZx 0b2fb4a5a8 DB/Loot: fix startuperrors caused by previous lootidfix, porting the wrong way :) 2012-09-15 16:37:45 +02:00
zxbiohazardzx 6e134d4761 DB/Loot: Fixlooting for HC dungeons trash
Closes #7515
2012-09-14 12:42:49 +02:00
ZxBiohazardZx c8b3812940 Db/Loot: assign lootid to npc 2012-08-11 12:12:51 +02:00
ZxBiohazardZx f87655b916 DB/Misc: add npcflag for 0b98656b28 (thx Vincent-Michael)
DB/Loot: add missing recipe to loot
2012-08-09 09:32:33 +02:00
ZxBiohazardZx 0deaa521bc DB/Disables another 39 deprecated quests 2012-08-04 17:43:45 +02:00
ZxBiohazardZx 61c93deecf DB/Disables: add priest T3 as well, stupid "of Faith" suffix got unnoted 2012-08-04 17:23:57 +02:00