* localize "unnamed" text for gameobjects and areatrigger
* fix empty links in Quest Detail Page for quests with
external completion event but empty AreaDescription
* closes#501
* move fulltext indizes for tables /w ~10k+ rows to separate tables
> sounds have ~12k but names are effectively incompatible with FTI
* normalize searchable strings to catch edgecases
> preparse spell descriptions + buffs
> move effect text cols of items to new table
* also fix extended search of creatures, spells & quests
* filters should test string input during initialization, so errors
can be passed on to the PageTemplate.
* have strings be compared for identity by default and (NOT) LIKE as
optional operator
* note: if a string criterium gets processed via callback function
it will not get prechecked
* implement tooltip scaling calculation for spells with attribute
SPELL_ATTR0_LEVEL_DAMAGE_CALCULATION
* I don't know why i loaded item scales as spell scales a decade ago.
Lets hope removing that didn't break stuff.
* add more indizes to large tables for cols used in lookups
* drop multi-column indizes on spell as they are not utilized by mysql
* add and use fulltext indizes for names of items, spells, quests, creatures & objects
could add more, but is it really necessary?
* limitations
- still need a solution for race/class/spellFamily masks cols that are used as such
- fulltext indizes in boolean mode cant partial match the end of a word.
reverse name cols and search and match back to front like that..? blows up db size even more though
(+trike* : "stormstrike" => +ekirt* : "ekirtsmrots")
* hardcode sql limits within their respective components instead of
having them configurable
* creating a new DBTypeList defaults it to being unlimited
* SQL_LIMIT_NONE (0) > removed as it only existed for consistency
* SQL_LIMIT_DEFAULT (300) > frontend / Listview::DEFAULT_SIZE
* SQL_LIMIT_SEARCH (500) > Search::DEFAULT_MAX_RESULTS
* SQL_LIMIT_QUICKSEARCH (10) > Search::SUGGESTIONS_MAX_RESULTS
* fix crash when race mask was resolved to faction
* fix id buffer bleeding from resolving class mask into
resolving race mask and vice versa
* fixes#472
* fix names (still use original string for title cards, just not internals and files)
* link manually created icons (holidays, classes, races) to icon db
* use newly linked icons instead of hardcoded values for classes/races
* implement used-by-classes filter on icons listing
* fix internal name of race 5 (undead) which fucked up icons
* version bump to invalidate cache
* group options for: currency, factions, itemcurrency & zones
* update faction setup so faction "The Frostorn" are available and it does not rely on factiontemplate.dbc
* fix broken purchasablewith* localization in locale DE
* work against more correctly assigning instance mode to entities and loot
- added manually collected data for difficulty versions of gameobjects, just boss chests for now.
update setup/source to default object source to base difficulty version if able
- update spelldifficulty table to contain the (likely) mapmode it will be used in
* refactored class loot
- implement loot mode indicators on listview for creature and gameobject loot
- show 'drops' listview tab on instance zone page
- fixes against tribute chest systems (toc / ulduar)
- fix icc gunship battle chest ownership
* recreate date functions from javascript in new class DateTime
* move date and time functions from Util to new class
* fixes various cooldown messages for account recovery
* hopefully fix a lot of nonsensical spell scaling infos
* note: an aweful lot of physical spells are hardcoded or have spell scripts and won't display any info
* fix building talent string for hunter pets.
the alternate spells (e.g. Dash & Swoop) must both be included
* align talent order in build scripts talenticons, talentcalc with
Profiler talent string builder
* fix Shamans gaining 5% Parry by talent Spirit Weapons
* cleanup
* move checks to __construct so they can be run on $_POST data
and don't create malformed filter urls
* if we received malformed $_GET params, build new params and reload
* do not store error state in cache
* cleanup
