aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2013-02-25Core/RBAC: Create new permissions related to character creationSpp
- 'Skips character creation team mask check' - 'Skips character creation class mask check' - 'Skips character creation race mask check' - 'Skips character creation reserved name check' - 'Skips character creation heroic min level check' - 'Creation of two side faction characters in same account' (Affected by global config option)
2013-02-25Core/RBAC: Create new permissions 'Allow channel chat between factions', ↵Spp
'Join channels without announce' (both need config option enabled and permission set) and 'Change channel settings without being channel moderator'
2013-02-25Core/RBAC: Create new permissions 'Skips needed requirements to use channel ↵Spp
check', 'Filter whispers', 'Allow say chat between factions'. Last one needs config option to be enabled and both sender and receiver to have the permission
2013-02-25Core/RBAC: Add new permissions 'Skip disable map check', 'Skip reset talents ↵Spp
when used more than allowed check', 'Skip spam chat check', 'Restore saved gm setting states', 'Use Config option START_GM_LEVEL to assign new character level'
2013-02-25Core/RBAC: Create new permissions 'Notify if a command was not found' and ↵Spp
'Enables lower security than target check'
2013-02-25Core/RBAC: Create new permission 'Two side mail interaction'. In order to ↵Spp
send/receive mails from other faction, config option should be enabled and both sender and receiver should have the permission
2013-02-25Core/RBAC: Create new permissions 'Allow to use CMSG_WORLD_TELEPORT opcode' ↵Spp
and 'Allow to use CMSG_WHOIS opcode'
2013-02-25Core/RBAC: Create new permission 'Skip over-speed ping check'Spp
2013-02-25Core/RBAC: Create new permission 'Receive global GM messages/texts'Spp
2013-02-25Core/RBAC: Create new permissions 'Use staff badge in chat' and 'Check if ↵Spp
should appear in .gm ingame command'
2013-02-25Corrections to recent sqlsSpp
2013-02-25Core/RBAC: Create new permissions 'Instant .save', 'Allow params with ↵Spp
.unstuck', 'Full HP after resurrect'
2013-02-25Core/RBAC: Create new permission 'Be assigned ticket'Spp
2013-02-25Core/RBAC: Create 'Skip instance required bosses check' permissionSpp
2013-02-25Core/RBAC: Add new Permission "Log gm trade". Config option still active, ↵Spp
but will affect only to users with that permission granted
2013-02-24Script/Quest: The Lonesome Watcher (12877)Gacko
Closes: #9185 See: http://www.youtube.com/watch?v=ylZRMu9CIMw
2013-02-24Core/Summons: Implement summon groups system to be able to summon multiple ↵horn
NPCs at once without need of hardcoding the positions. Almost all hardcoded positions can now be moved to DB. Thx to @Shauren for his help.
2013-02-23DB/Trigger: Fixed instance exit of the Culling of StratholmeKinzcool
2013-02-23SQL: Fix "No newline at end of file" in 194cc54f08d8b42c8c49d756e14273d917e1fcf2Vincent_Michael
2013-02-23DB/Gameobject: Removed transport gameobjectVincent_Michael
2013-02-20Core/NPCs: Fix some equipment issues introduced with 028c72a9f2c606e8af3Nay
Also changed equips defaults to 0 (no equipment) instead of 1. It seems that some parts of the original commit were reverted locally, my bad.
2013-02-19DB/SAI: Add sai for quest Gather the Orbs (10859)Trista
Closes #7636
2013-02-19DB/Conditions: add conditions to Lokhtos Darkbargainer Thx badmoon for ↵ZxBiohazardZx
initial fix Closes #9028
2013-02-19DB/Creature: Set Triggerflags & behaviour to triggerNPCExodius
Closes #8950
2013-02-19DB/Creatures: Update damage done by ICC bosses to more blizzlike valuesLarya
Closes #8580
2013-02-18DB/Spell: Added an auto-kill spell if you go at No Man's Land in Isle of ↵Kinzcool
Conquest
2013-02-18SQL Fix after 933381fAscathor
2013-02-18DB/Misc: Mostly gossip stuff for various creatures.Pitcrawler
Some scripts still need to be implemented. Fixes quest Blood Oath of the Horde.
2013-02-18Core/NPCs: Refactor equipmentsNay
- creature_template.equipment_id deleted - creature_equip_template.entry == creature_template.entry - id field added to creature_equip_template -> PK(entry, id) - id field in creature_equip_template starts at 1 - creature.equipment_id references id of creature_equip_template - creature.equipment_id = 0 means no equipment at all (default 1) - creature.equipment_id = -1 means pick a random equipment from creature_equip_template - add equipment info to .npc info command While table creature_equip_template got bigger in size, this system is easier to mantain and allows creatures to have a random template from a group of equipments
2013-02-17SQLs: Rename some old SQL files to match standardsNay
2013-02-17Remove BOM from 2 SQL filesShocker
Closes #9233
2013-02-17Scripts/Icecrown Citadel: Improvements to Shadowmourne quest lineShauren
2013-02-16DB/Quests:dr-j
Update Quest Requirements for To Bor'gorok Outpost, Quickly! Closes #9113 Fix Quest Grouping Add Quest Conditions for Hellscream's Champion Closes #9092 Fix SAI for Hugh Glass Closes #9097
2013-02-16DB/Loot:Exodius
+ Remove Zulian Mudskunk from Zulian Crocolisk loot template Closes #9169 + Add Vicious Oil to Vicous Oil Closes #9147
2013-02-16DB/SAI: Add script for Quergo's GoldRicko92
Closes #1677
2013-02-16DB/Creature: Add texts for LurgglbrZxBiohazardZx
Closes #1608
2013-02-16Misc/Spells:Vincent_Michael
- Add some ulduar teleport pos for spells - Add target hack for ulduar teleport spells
2013-02-16DB/Creature: The Ocularw1sht0l1v3
Now Eyesore Blaster hits this npc for 12600 damage as it should.
2013-02-15TDB 335.51 - 2013/02/14TDB335.51Nay
Ref #8947 Closes #9077
2013-02-15Scripts/TheStormPeaks: Cold Hearted quest update.w1sht0l1v3
Fix a crash.Thx @DDuarte. Closes #8865 Move waypoint data from script to DB table.
2013-02-11DB/NPCs: Set trigger flags_extra to a bunch of quest credit markersNay
God damn Aokromes, always making me do work and stuff...
2013-02-10DB/Triggers: Added anti-exploration in Hellfire RampartsKinzcool
2013-02-10DB/Factionchange: Add a missing spell (Teleport: Darnassus / Teleport: ↵Vincent_Michael
Thunder Bluff) at player_factionchange_spells
2013-02-09DB/Triggers: Fixed access to Duskwither SpireKinzcool
2013-02-10DB/Creature: Fix Onyxian Lair Guard equipmentVincent_Michael
2013-02-09DB/Quests: Fix quest The Collapse and Deploy the Shake-n-QuakeNay
Ref #1005 Ref #2034 Ref ae307048475ff14863d5a Closes #3595
2013-02-08DB/Triggers: Added areatriggers in Shadowfang - when you'll try to jump out ↵Kinzcool
of the dungeon walls, you will be teleported
2013-02-08Core/Auth: Reverted part of fb43a92cc2aaffab42efebf025b6a12c01af8fde - ↵Shauren
session key is still needed after logging in to be able to switch realms
2013-02-07Core/Accounts: sessionkey field in account table is only a temporary storage ↵Shauren
to pass data from authserver to worldserver and should only be used as such. Clearing sessionkey from database after a successful login to prevent possible exploits.
2013-02-06Fix up previous commit.w1sht0l1v3