aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2012-03-28SQL: Auth db data type cleanup `account_access`, `account_banned`, ↵leak
`ip_banned` / Storage engine switched to InnoDB
2012-03-28SQL: Auth db data type cleanup `account` / Storage engine switched to InnoDBleak
2012-03-28Core/DB: Adjust AP-bonuses for Hunter Volley (thanks to Jildor)click
2012-03-28Core/DBLayer: Fix remaining errors in loading world tables and a couple of ↵Nay
them in characters database Also removed World::LoadIp2nation(), it was not doing anything. Closes #5897
2012-03-27Core/DBLayer: Correct few more wrong read types (No. 4)Nay
DB/World: Some consistency in the ints "length" field (not really a length) All world dbs checked
2012-03-27Core/DBLayer: Correct few more wrong read types (No. 3)Nay
DB/World: Some consistency in the ints "length" field (not really a length) From A to G world tables verified; missing all the others
2012-03-27Core/DBLayer: Correct few more wrong read types (No. 2)Nay
DB/World: Some consistency in the ints "length" field (not really a length) From A to G world tables verified; missing all the others
2012-03-27Core/DBLayer: Correct few more wrong read types (No. 1)Nay
DB/World: Some consistency in the ints "length" field (not really a length) From A to D world tables verified; missing all the others int(11) -> int32 unsigned int(10) -> uint32 mediumint(8) -> int32 unsigned mediumint(8) -> uint32 smallint(6) -> int16 unsigned smallint(5) -> uint16 tinyint(4) -> int8 unsigned tinyint(3) -> uint8
2012-03-26DB/Auth: Update auth_database.sql with recent changesNay
2012-03-26Core/Spells: Added sql for misdirection fix (thx dasio)Kandera
2012-03-26DB/Creature Template: Some updates, mostly HoverHeight and InhabitType. ↵Machiavelli
Thanks to KingPin for re-parsing ~5GB of sniffs.
2012-03-26Auth/Realmlist: Make use of RealmFlags and rename color to flag (core- and ↵kaelima
dbwise) Also fix connecting with realmflag & 4
2012-03-25DB/Auth: Update auth_database.sql with recent changesNay
DB/GameEvent: Resync Darkmoon, again - by Aokromes
2012-03-25Core/DBLayer: Restore pinfo ban info outputleak
2012-03-24DB/Loot: Add some Missing loot, thx Helias for spotting and initial workZxBiohazardZx
Closes #5842
2012-03-24DB/Loot: Update Loot for first 4 bosses in UlduarZxBiohazardZx
2012-03-24Merge pull request #5858 from w1sht0l1v3/AKMachiavelli
Scripts/Ahn'kahet/Prince Taldaram: Fix movement after shield drops.(no more LoS issues) Update boss texts and move them to creature_text. Add proper sounds to text. Add condition for a visual spell. Add usage of different Embrace of the Vampyr spell based on difficulty.
2012-03-24Scripts/Ahn'kahet/Prince Taldaram:w1sht0l1v3
Fix movement after shield drops.(no more LoS issues) Update boss texts and move them to creature_text. Add proper sounds to text. Add condition for a visual spell. Add usage of different Embrace of the Vampyr spell based on difficulty.
2012-03-23Core/Commands: Add support for ip2nation database lookups when using .pinfo ↵Spp
command. This will (when a full database exists) allow for seeing (approximately) which country a player might be from when doing .pinfo <player> Note: External data required for this patch to work correctly can be found at http://www.ip2nation.com/ip2nation/Download Signed-off-by: click <click@gonnamakeyou.com>
2012-03-22DB/Conditions: 39152 should only be lootable if you have at least 390 skills ↵ShinDarth
in First Aid; Also add proper file ending to recent SQLs Closes #5840
2012-03-22Scripts/Ahn'kahet/Prince Taldaram: Fix Conjure Flame Sphere visual casting.w1sht0l1v3
Flame Sphere should not be visible to players(only their visual).
2012-03-21Merge pull request #5825 from w1sht0l1v3/ToCrMachiavelli
Scripts/ToCr/Val'kyr Twins: Fix orb targeting.
2012-03-21Scripts/ToCr/Val'kyr Twins: Fix orb targeting.w1sht0l1v3
Add missing triggers.
2012-03-20DB/Gossip: Quel'Danas gossips Closes #5803Malcrom
2012-03-19DB/SAI: SAI & Gossip for Unrestrained DragonhawkMalcrom
2012-03-15Scripts/Icecrown Citadel: Corrected flying animations for frostwyrms in ↵Shauren
Sindragosa's Lair and prevent reentering combat with Deathbringer Saurfang after encounter is won
2012-03-12Scripts/Icecrown Citadel: Lock Deathbringer Saurfang and Valithria ↵Shauren
Dreamwalker chests to players who fought them
2012-03-12Core/Units:Machiavelli
- Implement UNIT_FIELD_HOVERHEIGHT (requires DB data). This field, sent in update object packet, will determine the height at which a creature hovers if it has movementflag_hover applied. Note that hovering will now update the server-sided z-coordinate by the value of this field, and that all subsequent positional updates to the client will need to send z coordinate MINUS the hover height offset, or the hoverheight will be visually doubled client side. - Correct our usage of movementflag_flying, movementflag_can_fly, movementflag_hover and movementflag_disable_gravity (previously levitate), and how they relate to InhabitType in the database. This fixes "flying creatures on steroids" bug (wings flapping too fast), and potentially a lot of visual issues in AI scripts. Note that a lot of scripts still set wrong movementflags, these need to be fixed on a case by case basis. - Send correct packets for SPELL_AURA_FEATHER_FALL, SPELL_AURA_WATER_WALK and SPELL_AURA_HOVER apply/unapply. - Send correct packet contents for movement update in Unit::SetSpeed. - Misc. cleanup in affected scripts.
2012-03-11SQL: Fix some failures in previous commit (2b2d054)Nay
Please, re-apply the SQL files.
2012-03-11R.I.P SimpleAINay
- Convert SimpleAI to (DB) SmartAI - Spell ids corrected (and completed some of the scripts) - Random cleanup (code style) in some scripts
2012-03-10SQL: Fix one of the filenames from commit 0ad6238a96click
2012-03-10DB/SAI,Waypoints,creature: Some updates for Silvermoon CityMalcrom
2012-03-07Core/MapsShauren
* Corrected liquid type extraction in maps - MCLQ chunk must be parsed together with MH2O (they stack) * Fixed liquid detection in WMO objects * Implemented LiquidType.dbc use, players will now get proper auras in special liquids * Turned off slime damage by default (Naxxramas uses periodic damage aura for this purpose) * Implemented liquid type overrides basing on area/zone * Renamed final temp_gameobject_models to GameObjectModels.dtree (the temporary one produced by vmap extractor remains unaffected) Note: Map and Vmap re-extraction is required
2012-03-06DB/text: Fixed text from last commit :)Malcrom
2012-03-06DB/SAI: SAI for Elrodan & Aurosalia textMalcrom
2012-03-06DB/World: Remove character_queststatus_seasonal from the world database (if ↵Nay
it exists)
2012-03-06DB/Schema: Convert all world db tables to use MYISAM storage engineleak
2012-03-05Core/Commands: add command to reload locales_creature_textjoschiwald
2012-03-04Add handling for areatriggers at Area 52 entances.Malcrom
2012-03-04DB/Misc: Fix SQL of c48a1ad17db9b623795d24bbe83d77247b6ef756Discover-
2012-03-04Scripts/Misc: Script entrance areatriggers for Area 52.Discover-
2012-03-03Merge pull request #5426 from Souler/fix_ds_pipe_knockbackSubv
Dalaran Sewers Arena: Knockback from starting pipe
2012-03-03Core/Commands: Implement .debug moveflags command. With params you can set ↵Machiavelli
MoveFlags and MoveFlagsExtra for targeted unit. Without params it will display the current MoveFlags and MoveFlagsExtra. Useful for debugging upcoming changes.
2012-03-02Core/Arenas/Dalaran Sewers: Players who stay on the pipe after the battle ↵Souler
has begun should be knocked into the arena. Also corrected the orientation of horde starting position
2012-03-01Core/CreatureTextMgr: Added support for creature_text localizationShauren
2012-03-01DB/Creature_Text: Convert script_texts to creature_text for boss General ↵Malcrom
Bjarngrim
2012-03-01DB/Conditions: Really fix the Scarlet Harvest. Quest automatically had ↵Machiavelli
STATUS_COMPLETE, so condition needed to be adjusted
2012-03-01Core/Player: Quests with status QUEST_STATUS_NONE(0) shouldn't be loaded ↵Machiavelli
into player's queststatus storage. These should be removed since they are remnants from the old queststatus storage system.
2012-02-29DB/Creature_Text: Convert script_texts to creature_text for boss Volkhan, ↵Malcrom
Halls of Lightning.
2012-02-29DB/Creature_Text: Convert script_texts to creature_text for boss Ionar, ↵Malcrom
Halls of Lightning.