aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2014-09-14Core/Entities: Use ObjectGuid class in game projectShauren
2014-09-12DB/Gameobject: Allow to target 2 gameobjectsAokromes
Closes #13093, closes #13094
2014-09-12Merge pull request #12927 from MitchesD/misc_3MitchesD
Scripts/CoS: implemented Infinite Corruptor, improvements in instance sc...
2014-09-12Scripts/CoS: implemented Infinite Corruptor, improvements in instance script ↵MitchesD
and Meathook converted to BossAI Guardian of Time should have some text, but I have not found anything in sniff. Also the whole event needs to be rewritten and improved.
2014-09-12DB/Misc: Couple more fixesDr-J
closes #13112 closes #13115
2014-09-12DB/Misc: Random fixes/error fixesDr-J
2014-09-11SQL: Fix typo.WishToDie
Fix typo in 587d87d2ccc888b0a881be4bfaab150422edaec8.
2014-09-11DB/Misc: Some additions to ↵Dr-J
https://github.com/TrinityCore/TrinityCore/commit/137c8a7de9beaa90441c5aa38e14ad0b09bebffe Some additions to https://github.com/TrinityCore/TrinityCore/commit/137c8a7de9beaa90441c5aa38e14ad0b09bebffe * Add a missing npc_text where gossip menu had already existed in db with this text and core script sent this text as gossip but text was not in db * Correct option id for a option.
2014-09-11Convert Mount Vendor script to DB Dr-J
Move CPP script npc_mount_vendor to db * Sniffed gossip menu for Veron Amberstill as we did not have this * There is more than one text per gossip for these, readded all gossip menus we have to include the ones that where not in db already * Conditions for vendor option and texts to only sell to elegible to players and show correct texts We do not have text for Dreanei or dwarf have not checked gnome one since that one had already been moved to db since npc had sai closes #13088
2014-09-11SQL: Fix up my failure at 2014_09_11_00_world_conditions.sqlNyeriah
2014-09-11Scripts/Gundrak: Eck the Ferocious updated to EventMap/BossAINyeriah
- Moved his spawn handling to instance script
2014-09-11Remove BOM from 2014_09_11_00_world_conditions.sqlVincent-Michael
2014-09-11DB/Conditions: Fix up conditions for Yogg-Saron's portal spells after latest ↵Nyeriah
changes to the instance data
2014-09-10SQL: Fix wrong sql count orderVincent-Michael
2014-09-10DB/Misc: Cenarion ThicketDr-J
* Add strange aura to spell_area for Cenarion Thicket (someone had tried getting the druids to cast this on themselves in sai whoever did obviously did not read this AttributesEx3: 0x00000100 (SPELL_ATTR3_ONLY_TARGET_PLAYERS) * However even when aura is active it still would not hit druids only the Broken Corpses, found that the druids should not even have this aura (proper auras are permament feign death + blue radiation), also in sniff unit_flags2 is 2049 (we had 2048) and dynamic flags 0 (we had 40) * Also removing stun from unit flags, this makes no difference in game as npc gets those flags from feign death
2014-09-10DB/Locales: Correct multiple quest names for the 3.3.5 patchDDuarte
Ref #13075
2014-09-10DB/Locales: Correct multiple npc names for the 3.3.5 patchDDuarte
Closes #13075
2014-09-09DB/Misc; Perry GatnerDr-J
add some additional lines,
2014-09-09DB/SAI: Jenny (Load'er UP)Dr-J
Ok so found I needed to rescript this to as had not noticed there was already a script on Fezzix Geartwist for this quest, this sai has got same flaws as cpp version had, when npc gets attacked and evades looses crates aura (another example of the thing with auras getting removed at evade causing problems),
2014-09-09DB/Misc: Borean Tundra ScriptsDr-J
* Quest turn in scripts for Souls of the Decursed, The Power of the Elements and Patching Up * Proper script for Gearmaster Mechazod * Rescripted Bury those Cockroaches to SAI, now includes the texts from the mines, also credit npc will no longer be knocked out of sink hole by first person to do quest after a restart rendering the quest non working to all other players who try after due to the npc present not been where its meant to be * A couple of other one line fixes
2014-09-08Scripts/Commands: Allow to set a custom duration to the Freeze command ↵Odyssey
applied Aura - Allow to set a default duration for the Freeze Aura in worldserver.conf - Handle the .freeze and .unfreeze command custom effects through the Freeze AuraScript - Make players able to eventually unfreeze by themselves since the aura will expire without someone having to use .unfreeze - Make .freeze command usable with the following syntax: * .freeze (with a targeted player) * .freeze duration_in_seconds (with a targeted player) * .freeze playername duration (if duration is an invalid value it will be defaulted to the config one) * .freeze playername (in this case, duration will be defaulted to the config value) - Make .listfreeze command able to show the remaining freeze duration on all affected players Closes #12972
2014-09-08DB/Conditions: Argent Tournament Champions Daily questDr-J
Proper conditions for champions quests Battle Before The Citadel, Taking Battle to the Enemy, Among the Champions and Threat from Above require that player is a champion ie has done quest a champion rises Quests Eadric the Pure / The Scourgebane require that player is a champion Threat from above has two requirements - That player is a champion and player has completed the black knights orders The black knights Fall requires that player is a champion, quest chain breaks at the black knights orders if you are not champion
2014-09-08SQL: Renamed file to follow standardsShauren
2014-09-07Core/Misc: Meh some white lines, an addition to last sql's comment and a ↵Nyeriah
spotted typo
2014-09-07Scripts/AV: Balinda StonehearthNyeriah
- Updated to EventMaps - Removed manual spawning of Water Elemental by using proper spell * The Water Elemental has a duration, it'll despawn once it's over. She'll resummon it during the encounter if it dies or disappears. * Fixes it's level scalling with owner. - Moved Water Elemental AI to database. - Script update ** Patch 3.1.0 (14-Apr-2009): Now casts Ice Block.
2014-09-07DB/Misc: Kirin'Var VillageDr-J
Rescripts http://www.wowhead.com/quest=10305 Abjurist Belmara http://www.wowhead.com/quest=10182 Battle-Mage Dathric http://www.wowhead.com/quest=10307 Cohlien Frostweaver http://www.wowhead.com/quest=10306 Conjurer Luminrath Rescripts all of these quests to work fully blizzlike including waypoints, all texts, and equipping items, previous scripts where using wrong npc for two of these quests or the entry they should change to after retrieving item Also a few other visual fixes for this area, and fixing some run-time errors Aokromes asked to look at earlier.
2014-09-07DB/NPCs: Fix unit_class of some difficulty entries (DBErrors)DDuarte
2014-09-07DB/NPCs: Updates to unit_class, speed_run, speed_walk, BaseAttackTime and ↵DDuarte
HoverHeight
2014-09-07DB/NPCs: Correct faction of multiple npcs, 3.3.x dataDDuarte
2014-09-07Scripts/Stratholme: Move Freed Soul AI to database and a small additionNyeriah
- They should follow players until they despawn
2014-09-07Ethereal Teleport Pad & Ethereum Transponder ZetaDr-J
* Replacement for CPP script which was scripted not using the gossip menu / option which this go should have had but on activate instead, now will display proper gossip menu and option which spawns Image of Wind Trader Marid * Fix Ethereum Transponder Zeta so it actually works and delete the permament spawn of Image of Commander Ameer
2014-09-06Scripts/Scholomance: KormokNyeriah
- Updated to EventMaps - Replaced some hacks to summon adds with proper spells, but there might be still missing stuff
2014-09-06DB/Quests: The Summoning Chamber/A Curse Upon Both Your ClansDr-J
Ok first thing I have to say is even though a Curse Upon Both your clans now works with this script, the spawns are not done in correct way due to missing spells which are not in spell_dbc either but are in sniff, Nayd had no luck searching for them either. Anyway script for http://www.wowhead.com/quest=10602 The Summoning Chamber http://www.wowhead.com/quest=10585 The Summoning Chamber http://www.wowhead.com/quest=10544 A Curse Upon Both Your Clans Also spawn missing deathforge summoners from the summoning area, Closes #4837 Closes #6776
2014-09-06DB/NPCs: Remove equipment from HuldarDDuarte
Closes #13032
2014-09-06DB/NPCs: Add equipment to a couple of creaturesDDuarte
2014-09-06DB/Locales: Correct a few gameobject namesSarjuuk
Closes #13049
2014-09-06DB/NPCs: Set BaseAttackTime and RangeAttack to 2000 where these values were 0DDuarte
2014-09-06DB/NPCs: Remove duplicated lines from previous file (creature_model_info). Oops.DDuarte
2014-09-06DB/NPCs: Multiple updates to creature_model_infoDDuarte
2014-09-06DB/GOs: Multiple updates to gameobject_templateDDuarte
2014-09-06SQL: Rename SQL after recent PR mergeVincent-Michael
2014-09-05Scripts/Commands: Move instance command strings to databaseNyeriah
2014-09-06DB/Creature: Fix hover for "Maiden of Drak'Mar" in ↵Vincent-Michael
7a04d5ee8276a81156af9fb7ac13521441cb3f36
2014-09-06DB/NPCs: Remove dynamicflags that should not be in the DBDDuarte
Tapped and lootable flags
2014-09-05DB/Misc: Fel Crystal PrismDr-J
* Spawn missing spawns of Fel Crystal Prism http://www.wowhead.com/object=185927 * Script these to be usable to summon demons (needed in order to properly complete a Felwhip for Gahk!) at a cost of 35 Apexis shards * Scripts for the 4 demons * Adjustments to the egg scripts I made earlier have had to add the spell to take reagents to script (even though is meant to be triggered from other spell) but was failing ie not taking reagents.
2014-09-05SQLs: Rename SQLs after recent PR mergesDDuarte
2014-09-05Merge pull request #13008 from mik1893/onyxiaDuarte Duarte
Scripts/Onyxia Lair: small rework
2014-09-05Merge pull request #13016 from Odyssey/pinfoDuarte Duarte
Scripts/Commands: Move cs_misc.cpp command output hardcoded strings to DB
2014-09-05Merge pull request #13039 from Nyeriah/pr-cmdDuarte Duarte
Core/Tickets: Send global GM system messages on ticket complete
2014-09-05DB/SAI: Also fix the other of the four dragonsDr-J
Already fixed Obsidia from sniff I dont have sniffs of the other 3 but can still make these so the summon and payment occurs in properway. As with Obsidia all dragons are spawned by event script which is triggered from spell, egg despawns to prevent multiple spawns (even though this would be rather stupid as costs 35 shards to call each dragon.