* do not use stopwords in fulltext search
apparentyl there is a bug in innodb where including stopwords in a search causes the lookup to fail entirely.
e.g. innodb_ft_enable_stopword must be disabled when the index is edited (rows are added/removed)
* don't create a MATCH AGAINST search from empty search strings after sanitization
* drop fulltext indizes for locale zhCN
logographic languages need special treatment, which handling may differ by db provider
* use LIKE search by default for locale zhCN. Added config option to use fulltext if supported by db.
* split Screenshot upload & management into separate endpoints
* move shared functions to manager classes
* cleanup javascript
* move test for config screenshot min size to cfg class
* whelp, didn't see the onKeydown handler for the input field
* fix the fix in bf06c418d4
* allow "ArrowUp", "ArrowDown" and "-" as inputs
* also fix search by pressing <Return>
* do not urlencode mysqli uris .. can't wait for this to cause issues again.
* input[type=number] does not allow inputing dashes to signify negative numbers. Use input[type=text] instead and cast to int afterwards.
* move related functions to separate class
* implement out of date comment handling shorthand
* implement admin interface to work with reports
- listing based on user group
- assign to self / unassign from self
- close with reason
- comment functionality
- reward reputation to creator based on resolution
* 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
* 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
* 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
* editing after upload
* reputation gain for approved uploads
* moderator interface (albeit a bit wonky)
I still do not speak French, Spanish or Russian, so translations are
appreciated
