1. 02 Feb, 2020 1 commit
  2. 20 Jan, 2020 1 commit
    • Stefano Borzì's avatar
      Adapt AoWoW to AzerothCore (#3) · 88669c04
      Stefano Borzì authored
      * Pages/Achievements
       * display additional crosslinkable conditions from achievement_criteria_data
      
      * comments/formating
       * added missing whitespace betweeen date and patch version
       * reordered dmy to fit selected locale.
      
      * Page/Header
       * send 404 if an incorrect page or typeId was requested
      
      * Home/Featuredbox
       * allow defining a time span during which the box should be displayed
       * added fields optional fields to point to diffenret header and home logos for the duration
      
      * Libs/jQuery
       * updated to 1.12.4 (plus compatibility changes in affected javascripts)
       * fixed double escapes on featuredbox text
       * fixed rogue whitespace
      
      * Setup/Items
       * fixed an sql error by forgotten var
      
      * Types/Items
       * prevent a possible recursion occuring when preparing ItemSources
      
      * Setuo/enchants
       * reduced overhead by directly querying for spells instead of wrapping them in a SpellList (that functions i didn't neeed)
       * skip enchantments from items without source
      
      * Spell/Procs
       * updated to get data from new table
       * fixed proc data being displayed for unprocable effects
      
      * Setup/Misc
       * wrap LEFT JOINed fields in IFNULL() to prevent errors on setup
       * also adapt to changed TC table structure
       * add ORDER to prevent skipping entries, if not already ordered in source table
      
      * Setup/Titles
       * fixed title sources, where one title has multiple sources
      
      * Setup/Misc
       * fixed complexImage always selecting images for LOCALE_EN if able
       * fixed serverside events being displayed in the calendar
       * set initial memory limit to 4GB
       * set initial db_version to current version (forgotten to do that for a long time :x )
       * updated README.md and .gitignore; revision incremented
      
      * User/Weightscales
       * saving now always updates the name
       * name is now urldecoded
      
      * Setup/Zones
       * fixed flagging valid zones as hidden if no displayable map was present
      
      * Misc
       * ignore one more generated file
       * also its 2017 already
      
      * Setup/Creature
       * fixed sync for creature_template_locale
      
      * Item/Tooltip
       * fixed quote in faction link
      
      * Items/Currency
       * do not display unique-limited amount on item if currency token
       * display as cap on currency page instead
      
      * Spells/Description
       * support parsing another form of formula
       * mod regen auras (mostly food) have an implicit periode of 5sec.
      
      * Spell/Trainer
       * do not use trainer templates when getting trainer by spell
      
      * Item/Shared CD
       * items should not share a cooldown with themself
      
      * Forms/Placeholder
       * removed placeholder text images for input fields
       * readded text as placeholder attribute
      
      * Articles
       * escape article content again
       * restore home logo on maintenance page
      
      * Nav/RedButtons
       * pass parameters as ready to use - objects
      
      * Config/Locales
       * if your current language becomes invalid select the first viable one instead of defaulting to LOCALE_EN
      
      * Screenshots
       * aproving a screenshot now flags the corresponding db entry as having a screenshot
       * deleting & moving screenshots works equivalent
       * instancing a new TypeClass without parameters no longer grabs everything from the corresponding tables ( pass a "[true]" to retain this behaviour)
       * retroactively flag db entries for having screenshots
       * fixed a typo
      
      * Whoops
       * partially revert 99760d7c7266668318a2f578c0d31bd6c2270ed9
       * fixed another type on quests list page
       * added default cases for empty data to pets and races list pages
       * improved typelist iterator to be recursively callable
      
      * Fixup
       * access class property in screenshot/comment-admin by function. Aowow is compatible with PHP 5.5 again
       * changed line-endings across the board from \r\n to \n
      
      * Fixup
       * added missing brackets from copypasta-disaster
      
      * Setup/Creatures
       * hide creatures for internal use from listviews
       * correct Nightelf Player faction
       * trying to enforce strict line endings
      
      * Spells/Tooltips
       * fixed range display when friend- and foe-distances differ
       * fixed interpretation of $l-switch
      
      Item/DetailPage
       * do note prepare unnessecary data for the currency-for tab (eases load)
      
      * implementation of Sound DB
      
      Client sounds are cross-referenced with as many other DB-Types as possible. Including, but not limited to:
       * Character VOs (Errors, Emotes)
       * Creature VOs (Boss Dialogue)
       * Zone Music and Ambience
       * Sounds triggerd by spells
       * Sounds from general item/spell usage, creature behavior
      
      Restrictions:
       * only one locale is supported. Choose wisely!
      
      * revision push
      
      * Setup/ItemEnchantment
       * updated setup to for https://github.com/TrinityCore/TrinityCore/commit/f609e7a08b3b4d2d9642e5ec252e1eedad836f0f
      
      * Misc
       * edited example in README.md to be more clear
       * fixed a typo in RedButton template.
       * fixed a typo in comment ajax. Can now use sticky again.
       * fixed a logic error in comment reply js. do not line break image sources.
      
      * Misc
       * fixed note in quest tab on zone detail page
       * fixed a notice when creating item tooltips while passing an empty randomEnchantment value
       * fixed currencies having no icons on zone detail page
      
      * Pages/Quest
       * added map to quest detail page
       * some minor issues rooted in weired loot templates remain
      
      * Localization/frFR
       * some touch-ups
       * thx @Endalaust
      
      * Admin/Screenshots
       * restrict ability to irrevocably delete files to U_GROUP_ADMIN
      Pages/Quests
       * be a tad more lenient when filtering excessive sources
      
      * Spell/Effects
       * do not rely displayInfo for spell effects, that can occur multiple times per spell
      Items/CurrencyFor
       * always send all currency-info to javascript (an item may require more then one to be bought)
      
      * Spells/Tooltips
       * fixed parser for lastValue/gender-switch (previous pattern matched against that too)
       * also its a stupid idea to replace a var with itself
      
      * Quest/Map
       * assign objective text to map pips if possible
      
      * Items/Menu
       * fixed preselection of menu items on Items List Page
       * fixed display and preselection of 'Type' option list
      
      * Articles/Races
       * added french translation (thx @Endalaust and his translators)
      
      * Quests/Map
       * correctly apply styles to map selector
       * correcly prepare map selector string
      
      * Spell/Detail Page
       * parse effect 103 (Reputation)
       * calc actual value from custom_reward_rate
      
      * Reputation
       * apply reputation_reward_rate to rewards on Quest Detail Page
       * apply reputation_reward_rate to NPC Detail Page
      
      * Template
       * merge text-page-generic into list-page-generic
      
      * Markup
       * add some more options to tags (mostly directly setting class and style)
      
      * Articles
       * distinguish between articles for dbpage and other articles
       * can be served by url instead of arbitrary picked type/typeId-pair
       * save access to article in db (not used yet)
       * serve correct g_pageInfo if on article-page
      
      SiteReputation/Privileges
       * implemented info pages
      
      * SiteConfig
       * always place newly added php-configurations in the misc-category
      
      * User/Contribs
       * added reputation threshold for replys to config
       * check canComment and canReply separately
       * disable contrib-tabs if the user is banned
      
      * Misc
       * Github link to home-footer
       * formating errors in README.md
      
       * oh, i hate this markdown syntax sooo much :x
      
      * Disables
       * display db-entries as disabled or unavailable if appropriate
       * affects now achievements and quests in addition to spells
       * flag items without source as unavailable
       * flag quests without starter als unavailable
      
      Privileges
       * i guess i forgott to add the template...
       ...among other things
      
      * Config/Sanity
       * Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn
      
      * Privileges
       * add individual pages and corresponding articles
       * yes the sql-update was forgotten
      
      * Privilege
       * add forgotten template file
      
      * Errors
       * try to die a bit more gracefull if errors occur
      
      * Setup/Sounds
       * resolved duplicate naming of setup function
      
      * topUsres
       * implemented top users overview
       * w/o achievements, uploads, forum posts, yadda yadda
      
      * Updates/SQL
       * noticed having comments inside querys in these files breaks them
       * also there appear to be files with \r line endings left
      
      * Setup/Firstrun
       * forgot to add sounds generator to firstrun script
      
      * Setup/Sounds
       * updated sql update for changed generator
      Setup/Updates
       * do not throw an invalid scripts supplied - error if no actual scripts where suppied
         (in case of update it is skipped, in every other case it generates everything anyway)
      
      * Fixups
       * undefined variables in Markup.js
       * logic error preventing screenshot uploads
       * bitshift by negative value in spell
       * and i'm pretty sure i already added an exception handler at one point
      
      * Screenshots/filesize
       * UHD screens are pretty large
       * also nginx is a thing and not affected by htaccess (just to keep in mind)
      
      * Admin/Screenshots
       * do not display deleted screenshots on initial listing
      
      * Admin/Screenshots
       * do not limit screenshot sources
      
      Search
       * display floored maps
      
      * Errors / Logging
       * try to log fatal errors if able
      
      * Setup/Icons
       * fixed offsets for class / race icons (should no longer capture icon border from tile)
      
      not important, but you may want to run: aowow --build=simpleImg --icons -f
      
      * Contribute
       * added option to hide contribute tabs depending on subject (screenshots for sounds .. yeah, right)
      
      * Articles/Classes
       * added localization for frFR (thx @Endalaust and his translators)
      
      * Layout
       * make main-contents slightly wider to prevent overlaps
       * make classes listview name column slightly wider to prevent overlap
      
      * PHP/Compatibility
       * should now work with php5 again
      
      * DB/SQL-Modes
       * force disable special modes that will prevent our funny queries
      
      * IconDB
       * initial implementation
       * this includes a complete reindexing of everything touching icons
       * this also means, no linking to red-rocket-site though, they index them differently
      
      * IconDB/Fixups (obligatory)
       * table had wrong engine
       * two hunter pets have unique icons only referenced in creaturefamily.dbc
       * fixed links to rel-tabs
      
      * README
      
      fixed line breaks in Q/A-secion
      
      * Spells/Effects
       * only use MiscValue as spellid for SpellEffect:155
       * interpret and display SpellEffect 293
       * SpellEffects 131 & 132 can both play audio
      
      * Item/Tooltips
       * restore icon to tooltips after iconDB-changes tripped over a long forgotten change
      
      * README
      
      * updated audio generation as suggested in #93
      * fixed indentation
      
      * Fixups
       * fixed two typos
      
      * Fixups
       * fixed two typos
      
      * Misc/Fixups
       * fixed file generators involving ?_icons table
       * known spells onspell detail page should have a localized tooltip
       * fixed numer formating in spell tooltips for locales with a ',' as decimal
       * fixed php-tag in contribute template, causing parse error
      
      * Currencies
       * fixed sold-by tab on detail pag
       * fixed display if rewarded for quest
      
      * Misc/Errors
       * Item/XML
          - fixed setting typeId when lookup was item name
          - fixed lookup by name with utf8-chars
       * Items
          - do not display page for invalid categories
       * NPC
          - fixed reputation display
       * Quest
          - broke infinite loop occuring when quest is in chain with itself
       * Filters
          - handle different sizes of cr, crs and crv passed
      
      * Setup/DBCs
       * vastly improved memory usage when handling DBCs
       * DBCs are no longer read entirely into memory, instead appropriate file handles are used.
       * read data is written to DB in reasonable intervals instead of all at once
       * DBC-class can no longer read from DB, but that wasn't used anyway
      
      CLISetup
       * can now interpret the HOME-shorthand (~) in paths
      
      * Setup/DB
       * table prefix for aowow is now fixed to 'aowow_'
       * no more input required
      
      * WIN/Misc
       * windows compatibility changes
         - prevent crash on very large querys by reducing query size
         - set memory limit to something less than 2GB. Old value caused memory_limit to be set to something miniscule. (with the changes to DBC extraction this should now be feasable)
         - be a tad more lenient with time when generating enchant-datasets
      
      * Creatures
       * flag creatures using creaturedisplayinfoextra.dbc as humanoid
      
      * Setup/DBC
       * index column Id => id
       * why was this exception even there.
       * also DBCs copied directly into aowow_tables should work again
      
      * Lang/Items
       * apply templates from GlobalStrings.lua
       * fix some translation errors in the process .. also, if s.o. knows, what constructs like |3-1(%s) do to the passed string, please tell me.
      
      * Lang/Items
       * try to account for non-latin formating
       * use correct words provided by GlobalStrings.lua
      
      * Fixup/Typo
       * bracket order fail
      
      * DB/PageText
       * update structure for TrinityCore/TrinityCore@fbbe247114d092be1d20768419608bfa9cc57608
      
      * Util/Lang
       * cleanup Util 1/2
       * move spell effect/aura strings to Lang
      
      * Util/Game
       * cleanup Util 2/2
       * move game related functions and variables to new class: Game
      
      * Zones/Misc
       * fix allowed categories on ListPage
       * fix instances for zone 3523
      
      * ListPages/Filter
       * vastly improved input validation
       * content and type validation occurs when filter is created
       * contextual filters like itemTypes are now only applied in context
      
      * Misc
       * added option to 'verbose' concatenate a list of items to class Lang
       * added option to strip tags from a string to class Markdown
       * fixed several instances of wrong categories on pages
       * actually display world state conditions for zone music
       * some typos all over the place
      
      * Zones/DetailPage
       * directly display AudioControls for all ZoneMusic & Ambience
      
      * Pages/Spell
       * display category cooldown in table
      
      * Misc/Debug
       * remove leftover output
      
      * Filters/Items
       * fixed forgotten rename, breaking page with certain tabs
       * fixed typo, breaking stat weights
      
      * Misc/Fixup
       * stray backet braking enchantments list page
      
      * Tooltips
       * place tooltip for daily quests
       * place tooltip for real time duration
      
      * Misc/Errors
       * fixes some notices from log
       * fixed error when handling cookies
      
      * Spells/Tooltips
       * added base stats to be parsed (where skipped before)
       * dummy effects do not singal a healing spell
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/9a3b28894da14a4d839ddad77fa85be61ff03287 (broadcastText localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/460e2c5dc5eae49f62a9193fb58f1bab42028bd2 (item localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/3739d8444b1d5683bdac29f4a91df567dc19fd79 (quest localization)
      
      * Readme
       * updated TDB requirement
      
      * Accounts
       * added config option for external recovery & creation
       * fixed typos in contribute brick for locale 2
      
      * Misc/Fixup
       * added missing leading whitespace to update queries
      
      * DB/Structure
       * implemented changed from https://github.com/TrinityCore/TrinityCore/commit/309a7f7e2ab1f27a8c21d60791bcc6e5f7d6bec3 (achievement reward mail localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/d17a45ee7e348d6fc9146dd81e0457316eef1a62
      
       (creature text localization)
      
      * Readme
       * bump for new TDB dependancy
      
      * Adomin/Config
       * urlencode values or loose data on submit
      
      * Misc/Notices
       * fixed display of GemConditions on enchantment detail page
       * correctly initialize class and race masks for items
      
      * Admin/config
       * added onUpdate handler to rebuild affected files
      
      * README
      
       * removed SoX for WIN in favor of FFmpeg
       * added example scripts for batch audio conversion.
       * added a curious error case to the Q/A-section
      
      * NPCs/DetailPage
       * fixed extraCols for 'teaches' tab
      
      * Admin/siteconfig
       * also rebuild js-locales when updating available locales
       * somewhat unhappy with the access to generated files. need to find a better solution.
      
      * Quests/DetailPage
       * link to quest-ending spell if possible
      
      * Spell/ShapeshiftForms
       * move all localized strings to class Lang
       * added missing negation in flag check, causing stances not to be displayed
      
      * README
       * added another gotcha with auto-minifiers
      
      * Quests/DetailPage
       * correctly interpret exclusiveGroup values (maybe.. (who knows..))
      
      * Setup/Images
       * fixed error, causing everything to be displayed as not dound if anything was missing
       * added readable output to source finding stage
       * should now be obvious if something is missing
      
      * [PH] spell_group error suppressor
      
      * User/Auth
       * import user access from external auth source if available
      
      * Page/Maintenance
       * send appropriate status code: 503 (temporarily unavailable)
      
      thx @Magnifikator for the heads up
      
      * Setup/Firstrun:
       * try to resolve bad inputs for *_host and force_ssl, when they result in redirects (301, 302)
      
      * Factions/Articles
       * added french localization
      
      thx @Endalaust
      
      * Setup/Sounds
       * change extension of the temporary audio files for easier use with the supplied converter scripts.
      
      * Page/Home
      
      Fixes 2 html errors
      
      * Misc/Git
      
      added extracted sounds and setup files to .gitignore
      
      * Misc/Git
      
      added *.orig files to .gitignore
      
      * Misc/Typos
       * fixed typo/php-warning introduced in d83f370fb4f7740eaece8ef19aed1cacffadc989
      
      * Misc/Versions
       * AOWOW_REVISION is no longer expected to be numeric
         this allows for user-defined versions (e.g.4.1c) when changes
         within css/js files need to be forced into the web browser or
         existing cache files need to be invalidated
      
      * Items/Armor
       * fixed calculation of extra armor
      
      * Auth/Fixup
       * fix external login after 49a10e22
      
      * Profiler/Prep:
       * misc changes from profiler branch. No real changes on its own
      
      * Profiler/Filter
       * implemented flag options when searching for strings
      
      * Profiler/Gearscore
       * implement gearscore calculation
      
      im sad and i hate myself
      
      * Profiler/CLI
       * move command line related functions to its own class
      
      * Profiler/Backend
       * added core functions nessecary for profiler
      
      * Profiler/Frontend
       * add pages and templates to display arena teams, guilds and chars
      
      * Misc/Mergefix
       * added clean db dump
       * cleanup fails from profiler merge
       * maybe fixed setup being unable to find images for processing
       * version push
      
      * Setup/Sounds
       * make log more clear, that every available locale is checked
      
      * Profiler/Guilds
       * fixed forcing guildnames to string for js
       * made static string localized
      
      * Profiler/Profile
       * shorten raid activity string for locale deDE to prevent icons from showing up where they shouldn't (also needed for locale ruRU)
       * define offhand frill as unfit for enchantments
       * resort raid activity tracker and add placeholder for ulduar
      
      * Config/Profiler
       * update config to enable/disable profiler in general, instead of just the queue
       * regenerate affected files on config change
      
      * Profiler/RaidTracker
       * ALL the Raids .. track em
      
      * DB/Structure
       * update collate to use utf8mb4
       * fixed creature paths being capped at 255 waypoints
      
      * Profiler
       * further optimize search
         - use achievement 4496 as shortcut for everything based around total achievement points
         - get talent distribution separately
         - get total profiler-items found separately
         - opt to not sort found results
       * fixed Profiles with zero Achievement Points
       * added cache key genrator i forgot :<
       * fixed typos
      
      * Pages/Home
       * implement random home titles
      
      * Misc
       * don't cache playlists
       * don't cache new custom profiles
       * forgot to sanitize and use param from js
      
      * Misc/Typos
      
      * Modelviewer
       * removed quality options (java .. holy crap!)
       * added animations menu
      
      * Misc/Typo
      
      * DB/Favorites
       * implement favorites for DB entries
       * click on the star besides the name of the entry to add it to a new quick menu
      
      * Profiler
       * translate anouncements for loc 3
       * fix queue locking up on error
       * fix queue status display
       * fix flagging real characters as private
      
      * Profiler
       * fixed directly accessing existing, but not yet fetched, profile
      
      * Profiler/Raid-Tracker
       * sort raids by difficulty to fix progress bars
       * rename raids to include raid sizes
      
      * Profiler/Tooltips
       * fixed display of titles
       * supply iconstring in the tooltip data as this does not rely on variables within global.js
         fixes externally embeded profile tooltips
      
      * Misc/Typos
       * fixed display of charges on GameObject Infobox
       * removed display of achievement points as cost from vendors
      
      * Profiler/Reputation
       * add missing base values for each race/class
      
      * JS/Locales
       * grep-fix multiple issues with replacement patterns and hrefs
      
      * pages/Search
       * fix searching by stat weights (used in Profiler, Item Comparison)
      
      * Setup/Spells
       * hide a lot of internal spells from searches
       * apply a faction to mount listing, so the Profiler can hide mounts from the opposite faction
       * apply GS to profession enchantments
      
      * BaseType
       * revert change to get number total results
         this partially reverts bf42973c
      
      * Profiler/Mounts
       * display class-specific mounts on their respective classes
      
      * Profiler
       * reworked default exclusions (hid some things entirely, flagged others for appropriate cases)
       * char names consisting of two letters are now valid
       * fixed matching enchantments onto ranged weapons
      
      * Profiler
       * fixed possible bug where a custom profile would load instead of the original character it was created from
      
      * Items/Armor
       * fixed handling of additional Armor
      
      * Spell/Detail Page
       * display effective MiscValue for effect PowerBurn
      
      * Profiler/Profiles
       * allow strings with less then 3 chars in name search
       * store name as binary to allow accent-sensitive search
         (note: guilds and arenateams have the same issue but utf8mb4_bin can't be applied blindly as the search also becomes case-sensitive (wich is already handled for profiles))
      
      * Profiler/Profiles
       * do not display deleted custom profiles in their parent profiles quick info
      
      * NPCs/Detail Page
       * fixed vendors displaying the same sell price for every item
      
      * Quest/Detail Page
       * display mail attachments besides the actual mail instead of extra tab
      
      * Quests/Categories
       * shuffled quests into a structure that seems sensible (menus should no longer point to dead pages or display 'undefined' links)
      
      * Quests/Misc
       * remove Uldaman from Eastern Kingdoms
       * add Crystalsong forest to Northrend
      
      * Misc/Fixups
       * fixed typo inlocalization
       * have the profiler queue run at least one cycle so it can get registered as successfully started
       * a map popup will no longer scroll the page to bottom
       * replaced an input placeholder image with proper placeholder property
      
      * Localization/Chinese
      * added support for locale 4
      * some strings are missing and will need to be translated at a later date
      * thx @qyh214 for a lot of content
      Co-authored-by: default avatarqyh214 <sandy0214qin@msn.com>
      
      * Item/ExtendedCost
       * display a "sells" entry for every combination of currencies the vendor accepts per item
       * display every cost combination in the quick infos on the item detail page
      
      * Spells/Mounts
       * group mounts into ground, flying & misc.
       * display mount speed bonus in listview
      
      * Spells/Tooltips
       * remove level scaling from tooltips (for now)
      
      * Profiler/Profiles
       * fixed regular characters being hidden by default
      
      * Profiler/Raids
       * fixed displaying individual encounters in raid activity tracker
      
      * Admin/WeightPresets
       * removed redundant code
       * fixed empty scales not being written to dataset as expected
      
      * Localization/deDE
       * kitsch is inappropriate???
      
      * Misc/Fixups
       * squash multiple notices from error log
       * fixed copy&paste error preventing view on custom profiles
       * fixed display of spell requirements if mount was required after changs to mount sorting
       * properly get/send error code in profile synchronisation
       * use clear:left after floating mail block in template
      
      * Profiler/Chars
       * prefix characters flagged for rename to prevent collision with real char names (multiple chars flagged for rename will still collide, but what the hoo haa)
       * alter table index to prevent creation and subsequent conflict with duplicate entries of the same char (realm/guid pair)
      
      * Reports
       * added timestamp column to db table
       * consolidated write operation
       * fixed storing reports when get_browser() would return empty
      
      * Ajax/Debug
       * be a lot more verbose when errors are occuring (to staff anyway)
       * made hardcoded error messages for comments localizable
       * add error messages from posting comments to session to be displayed on next page update
      
      * Spells/Filters
       * add various filters (mostly attribute flags)
       * resolve additional dbc-data on detail page
       * fixed DK rune indexing
      
      * Sounds/DetailPage
       * fixed generating links to play via the WoW API
       * fixed usage of not yet available PlaySoundKitID() when selecting file from list
       * while internally it is pretty laissez-faire about cases in file paths, suddenly WoW DOES care, when it comes to its LUA API.
         so .. don't cast to lowercase when storing sounds in DB
      
      * implemented type areatrigger
       * staff only
      
      * Spells/DetailPage
       * display spells affectged by category cooldowns
      
      Items/DetailPage
       * display items affected by category cooldowns defined in spell template
      
      * Objects/Filters
       * added filter for common spell foci
      
      * Search
       * made racial traits searchable under abilities
      
      * Lang/Races
        Hey Lang, what races does this thing have assigned?
        Yes!
      
         .. this will no longer happen
      
      * Pages/Achivement
       * resorted criteria to match ingame order
      
      * Pages/Quest
       * escape placeholder tags in quest name for display
      
      * Spell/TaxiPath
       * resolve taxi path routes on spells
       * fixed display of taxi paths on maps
      
      * Setup/Quests
       * update structure for TrinityCore/TrinityCore@2f5403d4af3a90a6e51a377e05a55a0d197afb4d (Thx @TheWinchesters for noticing)
       * updated README accordingly
      
      * SmartAI
       * parse and verbosely display smartAI for creatures, gameobjects and areatrigger
      
      * Page/Achievement
       * catch fatal error for achievements without criteria
      
      * PHP-Version
       * return type declarations require php v7.0 or newer
       * updated README and and version check accordingly
      
      * Spells/Models
       * fixed assigning same display to multiple spells from the same SpellList
       * fixes missing mounts in Profiler
      
      * Account/Cookies
       * fixed saving cookie-data to account
       * e.g. announcements shouldn't pop up again if you close them once
      
      * PHP/Core
       * enforced v7.1 compliance, preparations for v7.2
       * removed deprecated usage of each()
       * prefer array deconstruction via [] instead of calling list()
       * try to catch failed session_start()
       * prefer ... - Token instead of calling func_get_args() func_num_args()
       * enforce return types in AjaxHandler
       * revision push
      
      * Page/Search
       * always display tab to denote what type was found
      
      * Setup/DBconfig
       * remove nonfunctional placeholder file
       * its too confusing
      
      * Misc/Fixes
       * resolve two additional spell effects (11, 44)
       * fixed overzealous find/replace in Loot::iterate()
       * fixed wrong placeholder for type 32 in Conditions System
      
      * Misc/Fixes
       * cast GET-params to lower case
       * fixed typo in constant name
       * fixed scope issue when aggregating sql stats
      
      * Profiler/Names
       * handle duplicate names due to rename flags more gracefully
       * should fix infinite reload bug on newly renamed profies
      
      * Page/Search
       * dropped support of wildcard characters
       * search for literal usage of underscore
      
      * Page/Currency
       * display price column in "currency for" tab
      
      * Icons
       * add icon to infobox for db types with icon (*duh!*)
       * fixed a couple issues with markup icondb in the process
       * fixed wrong data display due to shared name fields on joined table
      
      * Creatures/Rank
       * set unused ranks to 0 during setup to fix display issues
      
      * Quest/Mails
       * apply table quest_mail_sender to display correct mail source
      
      * Adaptations to AzerothCore database
      
      * Updated README.md, added spell_learn_spell table
      
      * Update README.MD
      Co-authored-by: default avatarSarjuuk <Sarjuuk@users.noreply.github.com>
      Co-authored-by: default avatarMagnifikator <1770433+Magnifikator@users.noreply.github.com>
      Co-authored-by: default avatarSHIHUANG214 <sandy0214qin@msn.com>
      88669c04
  3. 17 Oct, 2019 1 commit
  4. 16 Oct, 2019 1 commit
    • Stefano Borzì's avatar
      Update fork at the last version (#2) · 9ba5ed37
      Stefano Borzì authored
      * Pages/Achievements
       * display additional crosslinkable conditions from achievement_criteria_data
      
      * comments/formating
       * added missing whitespace betweeen date and patch version
       * reordered dmy to fit selected locale.
      
      * Page/Header
       * send 404 if an incorrect page or typeId was requested
      
      * Home/Featuredbox
       * allow defining a time span during which the box should be displayed
       * added fields optional fields to point to diffenret header and home logos for the duration
      
      * Libs/jQuery
       * updated to 1.12.4 (plus compatibility changes in affected javascripts)
       * fixed double escapes on featuredbox text
       * fixed rogue whitespace
      
      * Setup/Items
       * fixed an sql error by forgotten var
      
      * Types/Items
       * prevent a possible recursion occuring when preparing ItemSources
      
      * Setuo/enchants
       * reduced overhead by directly querying for spells instead of wrapping them in a SpellList (that functions i didn't neeed)
       * skip enchantments from items without source
      
      * Spell/Procs
       * updated to get data from new table
       * fixed proc data being displayed for unprocable effects
      
      * Setup/Misc
       * wrap LEFT JOINed fields in IFNULL() to prevent errors on setup
       * also adapt to changed TC table structure
       * add ORDER to prevent skipping entries, if not already ordered in source table
      
      * Setup/Titles
       * fixed title sources, where one title has multiple sources
      
      * Setup/Misc
       * fixed complexImage always selecting images for LOCALE_EN if able
       * fixed serverside events being displayed in the calendar
       * set initial memory limit to 4GB
       * set initial db_version to current version (forgotten to do that for a long time :x )
       * updated README.md and .gitignore; revision incremented
      
      * User/Weightscales
       * saving now always updates the name
       * name is now urldecoded
      
      * Setup/Zones
       * fixed flagging valid zones as hidden if no displayable map was present
      
      * Misc
       * ignore one more generated file
       * also its 2017 already
      
      * Setup/Creature
       * fixed sync for creature_template_locale
      
      * Item/Tooltip
       * fixed quote in faction link
      
      * Items/Currency
       * do not display unique-limited amount on item if currency token
       * display as cap on currency page instead
      
      * Spells/Description
       * support parsing another form of formula
       * mod regen auras (mostly food) have an implicit periode of 5sec.
      
      * Spell/Trainer
       * do not use trainer templates when getting trainer by spell
      
      * Item/Shared CD
       * items should not share a cooldown with themself
      
      * Forms/Placeholder
       * removed placeholder text images for input fields
       * readded text as placeholder attribute
      
      * Articles
       * escape article content again
       * restore home logo on maintenance page
      
      * Nav/RedButtons
       * pass parameters as ready to use - objects
      
      * Config/Locales
       * if your current language becomes invalid select the first viable one instead of defaulting to LOCALE_EN
      
      * Screenshots
       * aproving a screenshot now flags the corresponding db entry as having a screenshot
       * deleting & moving screenshots works equivalent
       * instancing a new TypeClass without parameters no longer grabs everything from the corresponding tables ( pass a "[true]" to retain this behaviour)
       * retroactively flag db entries for having screenshots
       * fixed a typo
      
      * Whoops
       * partially revert 99760d7c7266668318a2f578c0d31bd6c2270ed9
       * fixed another type on quests list page
       * added default cases for empty data to pets and races list pages
       * improved typelist iterator to be recursively callable
      
      * Fixup
       * access class property in screenshot/comment-admin by function. Aowow is compatible with PHP 5.5 again
       * changed line-endings across the board from \r\n to \n
      
      * Fixup
       * added missing brackets from copypasta-disaster
      
      * Setup/Creatures
       * hide creatures for internal use from listviews
       * correct Nightelf Player faction
       * trying to enforce strict line endings
      
      * Spells/Tooltips
       * fixed range display when friend- and foe-distances differ
       * fixed interpretation of $l-switch
      
      Item/DetailPage
       * do note prepare unnessecary data for the currency-for tab (eases load)
      
      * implementation of Sound DB
      
      Client sounds are cross-referenced with as many other DB-Types as possible. Including, but not limited to:
       * Character VOs (Errors, Emotes)
       * Creature VOs (Boss Dialogue)
       * Zone Music and Ambience
       * Sounds triggerd by spells
       * Sounds from general item/spell usage, creature behavior
      
      Restrictions:
       * only one locale is supported. Choose wisely!
      
      * revision push
      
      * Setup/ItemEnchantment
       * updated setup to for https://github.com/TrinityCore/TrinityCore/commit/f609e7a08b3b4d2d9642e5ec252e1eedad836f0f
      
      * Misc
       * edited example in README.md to be more clear
       * fixed a typo in RedButton template.
       * fixed a typo in comment ajax. Can now use sticky again.
       * fixed a logic error in comment reply js. do not line break image sources.
      
      * Misc
       * fixed note in quest tab on zone detail page
       * fixed a notice when creating item tooltips while passing an empty randomEnchantment value
       * fixed currencies having no icons on zone detail page
      
      * Pages/Quest
       * added map to quest detail page
       * some minor issues rooted in weired loot templates remain
      
      * Localization/frFR
       * some touch-ups
       * thx @Endalaust
      
      * Admin/Screenshots
       * restrict ability to irrevocably delete files to U_GROUP_ADMIN
      Pages/Quests
       * be a tad more lenient when filtering excessive sources
      
      * Spell/Effects
       * do not rely displayInfo for spell effects, that can occur multiple times per spell
      Items/CurrencyFor
       * always send all currency-info to javascript (an item may require more then one to be bought)
      
      * Spells/Tooltips
       * fixed parser for lastValue/gender-switch (previous pattern matched against that too)
       * also its a stupid idea to replace a var with itself
      
      * Quest/Map
       * assign objective text to map pips if possible
      
      * Items/Menu
       * fixed preselection of menu items on Items List Page
       * fixed display and preselection of 'Type' option list
      
      * Articles/Races
       * added french translation (thx @Endalaust and his translators)
      
      * Quests/Map
       * correctly apply styles to map selector
       * correcly prepare map selector string
      
      * Spell/Detail Page
       * parse effect 103 (Reputation)
       * calc actual value from custom_reward_rate
      
      * Reputation
       * apply reputation_reward_rate to rewards on Quest Detail Page
       * apply reputation_reward_rate to NPC Detail Page
      
      * Template
       * merge text-page-generic into list-page-generic
      
      * Markup
       * add some more options to tags (mostly directly setting class and style)
      
      * Articles
       * distinguish between articles for dbpage and other articles
       * can be served by url instead of arbitrary picked type/typeId-pair
       * save access to article in db (not used yet)
       * serve correct g_pageInfo if on article-page
      
      SiteReputation/Privileges
       * implemented info pages
      
      * SiteConfig
       * always place newly added php-configurations in the misc-category
      
      * User/Contribs
       * added reputation threshold for replys to config
       * check canComment and canReply separately
       * disable contrib-tabs if the user is banned
      
      * Misc
       * Github link to home-footer
       * formating errors in README.md
      
       * oh, i hate this markdown syntax sooo much :x
      
      * Disables
       * display db-entries as disabled or unavailable if appropriate
       * affects now achievements and quests in addition to spells
       * flag items without source as unavailable
       * flag quests without starter als unavailable
      
      Privileges
       * i guess i forgott to add the template...
       ...among other things
      
      * Config/Sanity
       * Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn
      
      * Privileges
       * add individual pages and corresponding articles
       * yes the sql-update was forgotten
      
      * Privilege
       * add forgotten template file
      
      * Errors
       * try to die a bit more gracefull if errors occur
      
      * Setup/Sounds
       * resolved duplicate naming of setup function
      
      * topUsres
       * implemented top users overview
       * w/o achievements, uploads, forum posts, yadda yadda
      
      * Updates/SQL
       * noticed having comments inside querys in these files breaks them
       * also there appear to be files with \r line endings left
      
      * Setup/Firstrun
       * forgot to add sounds generator to firstrun script
      
      * Setup/Sounds
       * updated sql update for changed generator
      Setup/Updates
       * do not throw an invalid scripts supplied - error if no actual scripts where suppied
         (in case of update it is skipped, in every other case it generates everything anyway)
      
      * Fixups
       * undefined variables in Markup.js
       * logic error preventing screenshot uploads
       * bitshift by negative value in spell
       * and i'm pretty sure i already added an exception handler at one point
      
      * Screenshots/filesize
       * UHD screens are pretty large
       * also nginx is a thing and not affected by htaccess (just to keep in mind)
      
      * Admin/Screenshots
       * do not display deleted screenshots on initial listing
      
      * Admin/Screenshots
       * do not limit screenshot sources
      
      Search
       * display floored maps
      
      * Errors / Logging
       * try to log fatal errors if able
      
      * Setup/Icons
       * fixed offsets for class / race icons (should no longer capture icon border from tile)
      
      not important, but you may want to run: aowow --build=simpleImg --icons -f
      
      * Contribute
       * added option to hide contribute tabs depending on subject (screenshots for sounds .. yeah, right)
      
      * Articles/Classes
       * added localization for frFR (thx @Endalaust and his translators)
      
      * Layout
       * make main-contents slightly wider to prevent overlaps
       * make classes listview name column slightly wider to prevent overlap
      
      * PHP/Compatibility
       * should now work with php5 again
      
      * DB/SQL-Modes
       * force disable special modes that will prevent our funny queries
      
      * IconDB
       * initial implementation
       * this includes a complete reindexing of everything touching icons
       * this also means, no linking to red-rocket-site though, they index them differently
      
      * IconDB/Fixups (obligatory)
       * table had wrong engine
       * two hunter pets have unique icons only referenced in creaturefamily.dbc
       * fixed links to rel-tabs
      
      * README
      
      fixed line breaks in Q/A-secion
      
      * Spells/Effects
       * only use MiscValue as spellid for SpellEffect:155
       * interpret and display SpellEffect 293
       * SpellEffects 131 & 132 can both play audio
      
      * Item/Tooltips
       * restore icon to tooltips after iconDB-changes tripped over a long forgotten change
      
      * README
      
      * updated audio generation as suggested in #93
      * fixed indentation
      
      * Fixups
       * fixed two typos
      
      * Fixups
       * fixed two typos
      
      * Misc/Fixups
       * fixed file generators involving ?_icons table
       * known spells onspell detail page should have a localized tooltip
       * fixed numer formating in spell tooltips for locales with a ',' as decimal
       * fixed php-tag in contribute template, causing parse error
      
      * Currencies
       * fixed sold-by tab on detail pag
       * fixed display if rewarded for quest
      
      * Misc/Errors
       * Item/XML
          - fixed setting typeId when lookup was item name
          - fixed lookup by name with utf8-chars
       * Items
          - do not display page for invalid categories
       * NPC
          - fixed reputation display
       * Quest
          - broke infinite loop occuring when quest is in chain with itself
       * Filters
          - handle different sizes of cr, crs and crv passed
      
      * Setup/DBCs
       * vastly improved memory usage when handling DBCs
       * DBCs are no longer read entirely into memory, instead appropriate file handles are used.
       * read data is written to DB in reasonable intervals instead of all at once
       * DBC-class can no longer read from DB, but that wasn't used anyway
      
      CLISetup
       * can now interpret the HOME-shorthand (~) in paths
      
      * Setup/DB
       * table prefix for aowow is now fixed to 'aowow_'
       * no more input required
      
      * WIN/Misc
       * windows compatibility changes
         - prevent crash on very large querys by reducing query size
         - set memory limit to something less than 2GB. Old value caused memory_limit to be set to something miniscule. (with the changes to DBC extraction this should now be feasable)
         - be a tad more lenient with time when generating enchant-datasets
      
      * Creatures
       * flag creatures using creaturedisplayinfoextra.dbc as humanoid
      
      * Setup/DBC
       * index column Id => id
       * why was this exception even there.
       * also DBCs copied directly into aowow_tables should work again
      
      * Lang/Items
       * apply templates from GlobalStrings.lua
       * fix some translation errors in the process .. also, if s.o. knows, what constructs like |3-1(%s) do to the passed string, please tell me.
      
      * Lang/Items
       * try to account for non-latin formating
       * use correct words provided by GlobalStrings.lua
      
      * Fixup/Typo
       * bracket order fail
      
      * DB/PageText
       * update structure for TrinityCore/TrinityCore@fbbe247114d092be1d20768419608bfa9cc57608
      
      * Util/Lang
       * cleanup Util 1/2
       * move spell effect/aura strings to Lang
      
      * Util/Game
       * cleanup Util 2/2
       * move game related functions and variables to new class: Game
      
      * Zones/Misc
       * fix allowed categories on ListPage
       * fix instances for zone 3523
      
      * ListPages/Filter
       * vastly improved input validation
       * content and type validation occurs when filter is created
       * contextual filters like itemTypes are now only applied in context
      
      * Misc
       * added option to 'verbose' concatenate a list of items to class Lang
       * added option to strip tags from a string to class Markdown
       * fixed several instances of wrong categories on pages
       * actually display world state conditions for zone music
       * some typos all over the place
      
      * Zones/DetailPage
       * directly display AudioControls for all ZoneMusic & Ambience
      
      * Pages/Spell
       * display category cooldown in table
      
      * Misc/Debug
       * remove leftover output
      
      * Filters/Items
       * fixed forgotten rename, breaking page with certain tabs
       * fixed typo, breaking stat weights
      
      * Misc/Fixup
       * stray backet braking enchantments list page
      
      * Tooltips
       * place tooltip for daily quests
       * place tooltip for real time duration
      
      * Misc/Errors
       * fixes some notices from log
       * fixed error when handling cookies
      
      * Spells/Tooltips
       * added base stats to be parsed (where skipped before)
       * dummy effects do not singal a healing spell
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/9a3b28894da14a4d839ddad77fa85be61ff03287 (broadcastText localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/460e2c5dc5eae49f62a9193fb58f1bab42028bd2 (item localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/3739d8444b1d5683bdac29f4a91df567dc19fd79 (quest localization)
      
      * Readme
       * updated TDB requirement
      
      * Accounts
       * added config option for external recovery & creation
       * fixed typos in contribute brick for locale 2
      
      * Misc/Fixup
       * added missing leading whitespace to update queries
      
      * DB/Structure
       * implemented changed from https://github.com/TrinityCore/TrinityCore/commit/309a7f7e2ab1f27a8c21d60791bcc6e5f7d6bec3 (achievement reward mail localization)
      
      * DB/Structure
       * implemented changes from https://github.com/TrinityCore/TrinityCore/commit/d17a45ee7e348d6fc9146dd81e0457316eef1a62
      
       (creature text localization)
      
      * Readme
       * bump for new TDB dependancy
      
      * Adomin/Config
       * urlencode values or loose data on submit
      
      * Misc/Notices
       * fixed display of GemConditions on enchantment detail page
       * correctly initialize class and race masks for items
      
      * Admin/config
       * added onUpdate handler to rebuild affected files
      
      * README
      
       * removed SoX for WIN in favor of FFmpeg
       * added example scripts for batch audio conversion.
       * added a curious error case to the Q/A-section
      
      * NPCs/DetailPage
       * fixed extraCols for 'teaches' tab
      
      * Admin/siteconfig
       * also rebuild js-locales when updating available locales
       * somewhat unhappy with the access to generated files. need to find a better solution.
      
      * Quests/DetailPage
       * link to quest-ending spell if possible
      
      * Spell/ShapeshiftForms
       * move all localized strings to class Lang
       * added missing negation in flag check, causing stances not to be displayed
      
      * README
       * added another gotcha with auto-minifiers
      
      * Quests/DetailPage
       * correctly interpret exclusiveGroup values (maybe.. (who knows..))
      
      * Setup/Images
       * fixed error, causing everything to be displayed as not dound if anything was missing
       * added readable output to source finding stage
       * should now be obvious if something is missing
      
      * [PH] spell_group error suppressor
      
      * User/Auth
       * import user access from external auth source if available
      
      * Page/Maintenance
       * send appropriate status code: 503 (temporarily unavailable)
      
      thx @Magnifikator for the heads up
      
      * Setup/Firstrun:
       * try to resolve bad inputs for *_host and force_ssl, when they result in redirects (301, 302)
      
      * Factions/Articles
       * added french localization
      
      thx @Endalaust
      
      * Setup/Sounds
       * change extension of the temporary audio files for easier use with the supplied converter scripts.
      
      * Page/Home
      
      Fixes 2 html errors
      
      * Misc/Git
      
      added extracted sounds and setup files to .gitignore
      
      * Misc/Git
      
      added *.orig files to .gitignore
      
      * Misc/Typos
       * fixed typo/php-warning introduced in d83f370fb4f7740eaece8ef19aed1cacffadc989
      
      * Misc/Versions
       * AOWOW_REVISION is no longer expected to be numeric
         this allows for user-defined versions (e.g.4.1c) when changes
         within css/js files need to be forced into the web browser or
         existing cache files need to be invalidated
      
      * Items/Armor
       * fixed calculation of extra armor
      
      * Auth/Fixup
       * fix external login after 49a10e22
      
      * Profiler/Prep:
       * misc changes from profiler branch. No real changes on its own
      
      * Profiler/Filter
       * implemented flag options when searching for strings
      
      * Profiler/Gearscore
       * implement gearscore calculation
      
      im sad and i hate myself
      
      * Profiler/CLI
       * move command line related functions to its own class
      
      * Profiler/Backend
       * added core functions nessecary for profiler
      
      * Profiler/Frontend
       * add pages and templates to display arena teams, guilds and chars
      
      * Misc/Mergefix
       * added clean db dump
       * cleanup fails from profiler merge
       * maybe fixed setup being unable to find images for processing
       * version push
      
      * Setup/Sounds
       * make log more clear, that every available locale is checked
      
      * Profiler/Guilds
       * fixed forcing guildnames to string for js
       * made static string localized
      
      * Profiler/Profile
       * shorten raid activity string for locale deDE to prevent icons from showing up where they shouldn't (also needed for locale ruRU)
       * define offhand frill as unfit for enchantments
       * resort raid activity tracker and add placeholder for ulduar
      
      * Config/Profiler
       * update config to enable/disable profiler in general, instead of just the queue
       * regenerate affected files on config change
      
      * Profiler/RaidTracker
       * ALL the Raids .. track em
      
      * DB/Structure
       * update collate to use utf8mb4
       * fixed creature paths being capped at 255 waypoints
      
      * Profiler
       * further optimize search
         - use achievement 4496 as shortcut for everything based around total achievement points
         - get talent distribution separately
         - get total profiler-items found separately
         - opt to not sort found results
       * fixed Profiles with zero Achievement Points
       * added cache key genrator i forgot :<
       * fixed typos
      
      * Pages/Home
       * implement random home titles
      
      * Misc
       * don't cache playlists
       * don't cache new custom profiles
       * forgot to sanitize and use param from js
      
      * Misc/Typos
      
      * Modelviewer
       * removed quality options (java .. holy crap!)
       * added animations menu
      
      * Misc/Typo
      
      * DB/Favorites
       * implement favorites for DB entries
       * click on the star besides the name of the entry to add it to a new quick menu
      
      * Profiler
       * translate anouncements for loc 3
       * fix queue locking up on error
       * fix queue status display
       * fix flagging real characters as private
      
      * Profiler
       * fixed directly accessing existing, but not yet fetched, profile
      
      * Profiler/Raid-Tracker
       * sort raids by difficulty to fix progress bars
       * rename raids to include raid sizes
      
      * Profiler/Tooltips
       * fixed display of titles
       * supply iconstring in the tooltip data as this does not rely on variables within global.js
         fixes externally embeded profile tooltips
      
      * Misc/Typos
       * fixed display of charges on GameObject Infobox
       * removed display of achievement points as cost from vendors
      
      * Profiler/Reputation
       * add missing base values for each race/class
      
      * JS/Locales
       * grep-fix multiple issues with replacement patterns and hrefs
      
      * pages/Search
       * fix searching by stat weights (used in Profiler, Item Comparison)
      
      * Setup/Spells
       * hide a lot of internal spells from searches
       * apply a faction to mount listing, so the Profiler can hide mounts from the opposite faction
       * apply GS to profession enchantments
      
      * BaseType
       * revert change to get number total results
         this partially reverts bf42973c
      
      * Profiler/Mounts
       * display class-specific mounts on their respective classes
      
      * Profiler
       * reworked default exclusions (hid some things entirely, flagged others for appropriate cases)
       * char names consisting of two letters are now valid
       * fixed matching enchantments onto ranged weapons
      
      * Profiler
       * fixed possible bug where a custom profile would load instead of the original character it was created from
      
      * Items/Armor
       * fixed handling of additional Armor
      
      * Spell/Detail Page
       * display effective MiscValue for effect PowerBurn
      
      * Profiler/Profiles
       * allow strings with less then 3 chars in name search
       * store name as binary to allow accent-sensitive search
         (note: guilds and arenateams have the same issue but utf8mb4_bin can't be applied blindly as the search also becomes case-sensitive (wich is already handled for profiles))
      
      * Profiler/Profiles
       * do not display deleted custom profiles in their parent profiles quick info
      
      * NPCs/Detail Page
       * fixed vendors displaying the same sell price for every item
      
      * Quest/Detail Page
       * display mail attachments besides the actual mail instead of extra tab
      
      * Quests/Categories
       * shuffled quests into a structure that seems sensible (menus should no longer point to dead pages or display 'undefined' links)
      
      * Quests/Misc
       * remove Uldaman from Eastern Kingdoms
       * add Crystalsong forest to Northrend
      
      * Misc/Fixups
       * fixed typo inlocalization
       * have the profiler queue run at least one cycle so it can get registered as successfully started
       * a map popup will no longer scroll the page to bottom
       * replaced an input placeholder image with proper placeholder property
      
      * Localization/Chinese
      * added support for locale 4
      * some strings are missing and will need to be translated at a later date
      * thx @qyh214 for a lot of content
      Co-authored-by: default avatarqyh214 <sandy0214qin@msn.com>
      
      * Item/ExtendedCost
       * display a "sells" entry for every combination of currencies the vendor accepts per item
       * display every cost combination in the quick infos on the item detail page
      
      * Spells/Mounts
       * group mounts into ground, flying & misc.
       * display mount speed bonus in listview
      
      * Spells/Tooltips
       * remove level scaling from tooltips (for now)
      
      * Profiler/Profiles
       * fixed regular characters being hidden by default
      
      * Profiler/Raids
       * fixed displaying individual encounters in raid activity tracker
      
      * Admin/WeightPresets
       * removed redundant code
       * fixed empty scales not being written to dataset as expected
      
      * Localization/deDE
       * kitsch is inappropriate???
      
      * Misc/Fixups
       * squash multiple notices from error log
       * fixed copy&paste error preventing view on custom profiles
       * fixed display of spell requirements if mount was required after changs to mount sorting
       * properly get/send error code in profile synchronisation
       * use clear:left after floating mail block in template
      
      * Profiler/Chars
       * prefix characters flagged for rename to prevent collision with real char names (multiple chars flagged for rename will still collide, but what the hoo haa)
       * alter table index to prevent creation and subsequent conflict with duplicate entries of the same char (realm/guid pair)
      
      * Reports
       * added timestamp column to db table
       * consolidated write operation
       * fixed storing reports when get_browser() would return empty
      
      * Ajax/Debug
       * be a lot more verbose when errors are occuring (to staff anyway)
       * made hardcoded error messages for comments localizable
       * add error messages from posting comments to session to be displayed on next page update
      
      * Spells/Filters
       * add various filters (mostly attribute flags)
       * resolve additional dbc-data on detail page
       * fixed DK rune indexing
      
      * Sounds/DetailPage
       * fixed generating links to play via the WoW API
       * fixed usage of not yet available PlaySoundKitID() when selecting file from list
       * while internally it is pretty laissez-faire about cases in file paths, suddenly WoW DOES care, when it comes to its LUA API.
         so .. don't cast to lowercase when storing sounds in DB
      
      * implemented type areatrigger
       * staff only
      
      * Spells/DetailPage
       * display spells affectged by category cooldowns
      
      Items/DetailPage
       * display items affected by category cooldowns defined in spell template
      
      * Objects/Filters
       * added filter for common spell foci
      
      * Search
       * made racial traits searchable under abilities
      
      * Lang/Races
        Hey Lang, what races does this thing have assigned?
        Yes!
      
         .. this will no longer happen
      
      * Pages/Achivement
       * resorted criteria to match ingame order
      
      * Pages/Quest
       * escape placeholder tags in quest name for display
      
      * Spell/TaxiPath
       * resolve taxi path routes on spells
       * fixed display of taxi paths on maps
      
      * Setup/Quests
       * update structure for TrinityCore/TrinityCore@2f5403d4af3a90a6e51a377e05a55a0d197afb4d (Thx @TheWinchesters for noticing)
       * updated README accordingly
      
      * SmartAI
       * parse and verbosely display smartAI for creatures, gameobjects and areatrigger
      
      * Page/Achievement
       * catch fatal error for achievements without criteria
      
      * PHP-Version
       * return type declarations require php v7.0 or newer
       * updated README and and version check accordingly
      
      * Spells/Models
       * fixed assigning same display to multiple spells from the same SpellList
       * fixes missing mounts in Profiler
      
      * Account/Cookies
       * fixed saving cookie-data to account
       * e.g. announcements shouldn't pop up again if you close them once
      
      * PHP/Core
       * enforced v7.1 compliance, preparations for v7.2
       * removed deprecated usage of each()
       * prefer array deconstruction via [] instead of calling list()
       * try to catch failed session_start()
       * prefer ... - Token instead of calling func_get_args() func_num_args()
       * enforce return types in AjaxHandler
       * revision push
      
      * Page/Search
       * always display tab to denote what type was found
      
      * Setup/DBconfig
       * remove nonfunctional placeholder file
       * its too confusing
      
      * Misc/Fixes
       * resolve two additional spell effects (11, 44)
       * fixed overzealous find/replace in Loot::iterate()
       * fixed wrong placeholder for type 32 in Conditions System
      
      * Misc/Fixes
       * cast GET-params to lower case
       * fixed typo in constant name
       * fixed scope issue when aggregating sql stats
      
      * Profiler/Names
       * handle duplicate names due to rename flags more gracefully
       * should fix infinite reload bug on newly renamed profies
      
      * Page/Search
       * dropped support of wildcard characters
       * search for literal usage of underscore
      
      * Page/Currency
       * display price column in "currency for" tab
      
      * Icons
       * add icon to infobox for db types with icon (*duh!*)
       * fixed a couple issues with markup icondb in the process
       * fixed wrong data display due to shared name fields on joined table
      
      * Creatures/Rank
       * set unused ranks to 0 during setup to fix display issues
      
      * Quest/Mails
       * apply table quest_mail_sender to display correct mail source
      9ba5ed37
  5. 25 Oct, 2016 1 commit
    • Sarjuuk's avatar
      setup/quests · e896daa1
      Sarjuuk authored
      * fixed fatal typo (thx @Fra298)
      e896daa1
  6. 16 Oct, 2016 1 commit
    • Sarjuuk's avatar
      Items/XML · 1a46e584
      Sarjuuk authored
       * added source and cooldown to xml
      1a46e584
  7. 04 Oct, 2016 9 commits
    • Sarjuuk's avatar
      Spells/PageTexts · e2ab00b4
      Sarjuuk authored
       * fixed numeric & gender switch for russian locale
       * treat $| like a $l-switch (only one case iirc)
       * remived output for unhandled text variables
       * fixed display of pageText for items
      e2ab00b4
    • Sarjuuk's avatar
      Locales/esES · 568677ff
      Sarjuuk authored
      * some more square bracket shuffling (should be fine now)
      568677ff
    • Sarjuuk's avatar
      Setup/Sqlgen · 321c9ba7
      Sarjuuk authored
      * fixed setup skipping custom data if it was >stepSize away from the last entry
      321c9ba7
    • Sarjuuk's avatar
      Markdown · 674a2a78
      Sarjuuk authored
       * added [money ..] and [currency=] to tag parser
       * added missing styles to properly display [quote ..] and diffs
       * added missing js to display [n5 ..] and progress bars
      674a2a78
    • Sarjuuk's avatar
      Misc/Fixes: fixed erronous sql-update · 2bc40e94
      Sarjuuk authored
      2bc40e94
    • Sarjuuk's avatar
      Screenshots/Upload · 770f1132
      Sarjuuk authored
       * use fileInfo to determine the filetype (getimagesize fails if the file is not an actual image)
      770f1132
    • Sarjuuk's avatar
      Merge/Fixup: · bb877624
      Sarjuuk authored
      restore array structure after merge
      bb877624
    • AFROM's avatar
      Update spanish localization (#64) · 317e12ed
      AFROM authored
      Update spanish localization
      317e12ed
    • AFROM's avatar
      Update spanish localization in static/js/locale_eses.js (#65) · 1cbe1aea
      AFROM authored
      Update spanish localization
      1cbe1aea
  8. 29 Mar, 2016 3 commits
    • Sarjuuk's avatar
      Misc/Fixup · 8f777745
      Sarjuuk authored
       * really fix broken sql structure after c75777e5 (fix the fix!)
      8f777745
    • Sarjuuk's avatar
      User/Auth · a5219359
      Sarjuuk authored
       * use char limit appropriate to current auth method, when checking usernames
      a5219359
    • Sarjuuk's avatar
      Misc/Fixes · b84854d4
      Sarjuuk authored
       * fixed db_structure.sql broken after
       * readded %-column to GO-Loot listviews
      b84854d4
  9. 23 Mar, 2016 1 commit
    • Sarjuuk's avatar
      Misc/Fixups · c75777e5
      Sarjuuk authored
       * added forgotten mapper strings for esES, ruRU, frFR
       * readded default name for screenshots and videos tab
       * fixed referencing not set $id in opensearch (wich now displays icons once again)
       * fixed referencing a long removed variable in admin=screenshots, preventing delete operations
      c75777e5
  10. 20 Mar, 2016 1 commit
    • Sarjuuk's avatar
      Pages/Quest · 44c90b71
      Sarjuuk authored
       * fixed display of spell rewards, if rewardSpellCast was negative
      44c90b71
  11. 18 Mar, 2016 1 commit
    • Sarjuuk's avatar
      Fixup · a8d68610
      Sarjuuk authored
      override foreign key checks while applying update
      a8d68610
  12. 12 Mar, 2016 1 commit
    • Sarjuuk's avatar
      Weight Scales/Presets: · e80015a7
      Sarjuuk authored
       * moved wt_presets to DB
       * scales are now saved sensibly instead of just being dumped as is (also, tables have now constrains)
       * added admin=weight-presets to edit presets
       * added an internal user on id:0 who 'owns' the wt-presets and the +1 rates on new comments
       * consequently added constraints to comment-related tables
      
      Misc:
       * Util::toJSON() priorizes its flags over CFG_DEBUG, wich fixes the modelviewer-redButton
       * moved terrible javascript-dump from admin-page to template
      e80015a7
  13. 27 Feb, 2016 1 commit
    • Sarjuuk's avatar
      Misc/Misc · 71e44e57
      Sarjuuk authored
       * fixed auth against TCs auth table
       * check for real paths when creating emote aliasses
       * races page no longer identifies as classes
       * fixed item comparison tool
       * fixed js error when trying to display spawn maps
      71e44e57
  14. 16 Feb, 2016 1 commit
    • Sarjuuk's avatar
      Users/Markup · 741ebf38
      Sarjuuk authored
       * implemented pending-status for newly created accounts
       * Markup should now properly recognize external links
       * Markup will remove links by pending accounts
      741ebf38
  15. 11 Feb, 2016 1 commit
    • Sarjuuk's avatar
      Templates/Listviews · 08717c36
      Sarjuuk authored
       * removed most templates by sensibly restructuring lvTab-data. Util::toJSON() does the rest.
       * taught Util::toJSON() to recognize values prefixed with $ as js-code
       * use Util::toJSON whenever possible
       * misc
         - mail attachments are displyed again
         - always show all currency rewards on Quest-LVs
         - suppress an error, when encountering unused ItemMods
      08717c36
  16. 06 Feb, 2016 2 commits
    • Sarjuuk's avatar
      Comments/rating · fe7f05c8
      Sarjuuk authored
       * do not include the +1 every comment starts with in the distribution and preview
      fe7f05c8
    • Sarjuuk's avatar
      Pages/Zone · 447f7f02
      Sarjuuk authored
       * fixed displaying nonexisting multiples of spawns on the map
      447f7f02
  17. 31 Jan, 2016 6 commits
    • Sarjuuk's avatar
      PHP7/compatibility · c1b92df9
      Sarjuuk authored
       * changes to search.php somehow slipped through
      c1b92df9
    • Sarjuuk's avatar
      Admin/Config · 7c1e61d8
      Sarjuuk authored
       * fixed calling $this in static context (broke web-config)
      7c1e61d8
    • Sarjuuk's avatar
      Setup/Update · 63cd83c1
      Sarjuuk authored
       * fixed errors introduced in c3fe4b02
      63cd83c1
    • Sarjuuk's avatar
      Template/Home · 02205876
      Sarjuuk authored
       * update footer to current year
       * display current revision
      02205876
    • Sarjuuk's avatar
      AoWoW is now compatible with php7 · f076a301
      Sarjuuk authored
      (php7 is recommended but not required)
      f076a301
    • Sarjuuk's avatar
      Misc/Fixes · 5abdbe20
      Sarjuuk authored
       * fixed stats when comparing items with scaling random enchantments
       * fixed BOM on compare.php
       * fixed multiple typos and notices
      5abdbe20
  18. 26 Jan, 2016 1 commit
    • Sarjuuk's avatar
      Acc/Passwords · 2bc85dd1
      Sarjuuk authored
       * do not enforce minimum password length for imported accounts
      2bc85dd1
  19. 23 Jan, 2016 3 commits
    • Sarjuuk's avatar
      Template/JS · bd2a5acf
      Sarjuuk authored
       * removed some readability formating, that caused an arbitrary text-node to appear in between DIVs, screwing with javascript
      bd2a5acf
    • Sarjuuk's avatar
      Setup/DBCs · 278176a4
      Sarjuuk authored
       * directly extract integers as signed (may or may not help with a reported case of extracted nonsensical values)
      278176a4
    • Sarjuuk's avatar
      User/Passwords · eddb034a
      Sarjuuk authored
       * allow for passwords longer than 15 characters
      eddb034a
  20. 16 Jan, 2016 1 commit
    • Sarjuuk's avatar
      Setup/Update · c3fe4b02
      Sarjuuk authored
       * get files/tables, which need to be regenerated after! applying sql updates
       * small wording change, to make exiting dbConfig feel less like an error occured
      c3fe4b02
  21. 13 Jan, 2016 2 commits
    • Sarjuuk's avatar
      Items/Block · 43222326
      Sarjuuk authored
       * fixed formating of xml-export
       * fixed handling of block value (can have multiple sources per item (itemMods, spell, set individually) and is then displayed separately in tooltip, but summed for calculations)
      43222326
    • Sarjuuk's avatar
      Misc/Fixes · 99eb8f42
      Sarjuuk authored
       * fixed typo preventing management of custom weight scales
       * added forgotten GET-Parameter to sanitization, preventing rating of comments
       * avoid hardcoding locales
       * do not show tooltip on BUTTON_WOWHEAD
      99eb8f42