aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2012-03-28Partially revert a36a0a77ef75e66933ac5b8802a9ec7906acfd0b.click
Cleaning databases for old/deprecated and expired quests should never be a developers choice specifically. This should be done by admins, not developers, through the use of the already existing paramters found in the worldserver config : CleanCharacterDB / PersistentCharacterCleanFlags An adjustment to the respective questloader prepared statement has been done to accomodate for the earlier change (by not loading such quests into memory at all). Documentation for how this cleanup-procedures work already exists in the core : doc/CharacterDBCleanup.txt.
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.