aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2010-03-19Fix SQL yet again, thanks Trazom. (My apologies)Machiavelli
--HG-- branch : trunk
2010-03-19Fix SQL's, thanks Aokromes.Machiavelli
--HG-- branch : trunk
2010-03-19Implement instance script for Zul'Farrak and prevent Gahz'Rilla from being ↵Machiavelli
summoned multiple times. --HG-- branch : trunk
2010-03-19Little sql improvement.teacher
--HG-- branch : trunk
2010-03-18Store alternate currency spent on an item by Item ExtendedCost entry instead ↵Machiavelli
of honorPts/arenaPts/items seperately. Thanks to Opterman for the idea. --HG-- branch : trunk
2010-03-18*fix quest Bury Those Cockroaches!(11608)Rat
--HG-- branch : trunk
2010-03-18*fix Merciless Totem of the Third Wind procRat
*fix in world.sql --HG-- branch : trunk
2010-03-18Implement vendor item refund system.Machiavelli
For info about this system, see: hxxp://us.blizzard.com/support/article.xml?locale=en_US&articleId=27351 Thanks to: - Opterman, Malcrom, Xanadu + anonymous colleagues for aiding research on packet structure - Aokromes and Svannon for testing --HG-- branch : trunk
2010-03-17Add script for Amberpine Woodsmen Grizzly Hillsmalcromtdb@gmail.com
--HG-- branch : trunk
2010-03-17Added 7597_world_scriptname.sql to world_scripts_full.sqlTroy
--HG-- branch : trunk
2010-03-17Argent Tournament Post script by MalcromXanadu
--HG-- branch : trunk
2010-03-17Fixed Drain Soul increased damage for targets below 25% HP. Closes issue ↵Xanadu
#394. Closes issue #748. Closes issue #938. Rejoice, new era of server-side spells has begun! --HG-- branch : trunk
2010-03-16Update Halls of Stones script text entries to correct range.Trazom62
Fixes issue #607. --HG-- branch : trunk
2010-03-15Moved sql update files to 3.3.2_old directory.teacher
Fixed my typo in world.sql. --HG-- branch : trunk
2010-03-15Remove Hack detecting spell 61988 in HasAura()thenecromancer
Correctly cast 61988/61987 after casting Avenging Wrath/Divine Shield respectively (This will correctly show both spells disabled state) Don't allow casting Lay on Hands on self when aura 61988 is present (ie. after using Avenging Wrath) --HG-- branch : trunk
2010-03-15Change field `crc` in characters.addons to int(32) to support proper values.Machiavelli
--HG-- branch : trunk
2010-03-14* Fix potential import error for vehicle_accessory tableBrian
* Thanks Riccardo --HG-- branch : trunk
2010-03-13Random sql cleanup.teacher
--HG-- branch : trunk
2010-03-13Fix SQL errors in world_script_texts.Trazom62
--HG-- branch : trunk
2010-03-13Add missing file in previous commit.Spp
--HG-- branch : trunk
2010-03-13Allow Battlegrounds and arenas to be disabled by DB.Spp
wtlk arenas disabled by default. - Player will continue to see all bgs using UI, but won't be able to join disabled bg's - Gossip menu not shown for disabled Bgs/arenas - Id 6 disabled = all arenas disabled. - Only id 6 arena enabled = Gossip shown but unable to join any arena --HG-- branch : trunk
2010-03-12Fix compile after 7548.Spp
Also reorder the columns of account onlinelist command --HG-- branch : trunk
2010-03-12Fix a typo in a SQL.Anubisss
--HG-- branch : trunk
2010-03-12Some Ticket text formating changes to help addons to parse dataSpp
Linked issue 466 --HG-- branch : trunk
2010-03-12Add map and zone to account onlinelist command.Spp
Closes issue 466 --HG-- branch : trunk
2010-03-12Move vehicle accesories to DB.Spp
Credit to Malcrom and Manuel for the idea and original patch --HG-- branch : trunk
2010-03-09Small update to the group/party system.Machiavelli
- Fixes raid assistant privileges, Fixes issue #248 - Proper designation for Main tank and Main assistant roles - Remove 2 redundant columns in DB, namely groups.mainTank and groups.mainAssist. These are now defined by the value of group_member.memberFlags --HG-- branch : trunk
2010-03-09Typo in server shutdown command.Spp
Original author VladimirMangos Closes issue #57 --HG-- branch : trunk
2010-03-09Add level restrictions to some commands:Spp
say, yell, emote, whisper, channel use, trade, auction, mail, tickets By azazel. Closes issue #598 --HG-- branch : trunk
2010-03-08Support for quest Doing your Duty by Malcrom. Thanks to Supabad._manuel_
--HG-- branch : trunk
2010-03-02* Add change to characters.sql from last commitBrian
--HG-- branch : trunk
2010-03-02* Fix blob conversion SQL to allow for proper value for watchedFactionBrian
--HG-- branch : trunk
2010-03-02* Move some values out of the data blob in the characters tableBrian
* (honor, kills, title, currencies, watched faction, drunken-status, health and power) * Original Author Hunuza - thank you * Ported to Trinity by RammboNr5 - thank you * Tested by Aokromes - thank you * Closes Issue #911 --HG-- branch : trunk
2010-03-02* Add support for sending quest completion textBrian
* Original patch by NoFantasy - thank you * Ported to Trinity by seirgy - thank you * Closes issue #873 --HG-- branch : trunk
2010-03-02Fixed import errors on recent sql update files...teacher
Added forgotten updates to world.sql... Added missing lines at the end of some sql files... Better format by adding DELETE FROM before any INSERT INTO update... --HG-- branch : trunk
2010-03-01Add command similar to pinfo but for gameobjects.p0wer
Displays Entry, Type, DisplayId, and Name. Created in response to issue #768. --HG-- branch : trunk
2010-03-01Implemented script for npcs 32369,32371,32372. By Malcrom._manuel_
For a full fix apply http://trinitydatabase.org/index.php?/topic/14699-fix-transitus-shield-invisible-bunny-positions-violet-stand/ --HG-- branch : trunk
2010-02-27Fix Script Naxxramas/Kel Thusad. Thanks Ille.Trazom62
Fixes issue 650. Fixes issue 659. Fixes issue 809. Thanks PrinceCreed. script changes - added spawnpoints and spawn creatures in corners * they react defensive, otherwise they assist the minions kelthuzad spawns - added functionality to area trigger * fight begins when player enters green circle - added functionality to kelthuzad trigger * trigger is activated when player enters green circle * trigger disappears after 5s - added functionality to window portals * at 45% portals open to let guardians in - chained can be 3 at once - added spells to chained * for every class two spells - changed timers on enter combat - set combat reach to 2 for guardians - Fix emote when enter combat and when enter phase 2. NOTE: some db updates may still be necessary to have better locations of portals and EventAI updates. For more info, see sql in attachment of #659 and http://trinitydatabase.org/index.php?/topic/14304-boss-naxxramas-kelthuzad on tdb forum. --HG-- branch : trunk
2010-02-26Added sql files for previous commits._manuel_
--HG-- branch : trunk
2010-02-25Support for quest Troll Patrol Intestinal Fortitude, by Malcrom. Thanks to ↵_manuel_
raczman and biglad. For a full fix see TDB Forum - Core related DB content. --HG-- branch : trunk
2010-02-25Implemented support for npc 34885. Code from ScriptDev2._manuel_
--HG-- branch : trunk
2010-02-25Add new flagged column to access_requirement to set instances opened/closed.Tartalo
This way is possible to open a raid on 10man mode while the rest of modes are closed (for example). Ingame commands to open/close instances coming soon ;) --HG-- branch : trunk
2010-02-24Add command for administrators to change channel publicity ingame rather ↵p0wer
than having to manually manipulate the database. --HG-- branch : trunk
2010-02-24Remove naxxramas areatrigger check to get to frostwyrm wing (no longer ↵Trazom62
needed in 3.3.2). Fixes issue #874. Thanks Gyullo for original patch. Still need db support for the teleport back from frostwyrm wing. --HG-- branch : trunk
2010-02-24Icecrown, Argent Tournament: Support for quests 14096 & 14142Tartalo
You've Really Done It This Time Kul Needs db support to work properly (missing spawn + faction changes) --HG-- branch : trunk
2010-02-24Borean Tundra: Support for quest 11653Tartalo
Hah... You're Not So Big Now! --HG-- branch : trunk
2010-02-23Missed changes from last commit. Sorry bout that.p0wer
--HG-- branch : trunk
2010-02-23Through DB you can now disable password changing by non-gm's simply by ↵p0wer
changing m_public to 0. Make channels public by default. --HG-- branch : trunk
2010-02-23Durotar: Support for quest 5441, by SupabadTartalo
Lazy Peons --HG-- branch : trunk
2010-02-23Add forgotten SQL from last week commits to world_scripts_full.sqlTartalo
--HG-- branch : trunk