summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/Releases.pm
AgeCommit message (Collapse)AuthorFilesLines
2017-01-19Add Open Graph tags for the main page and vrspcflan1-1/+6
2016-11-03List deleted releases when adding a new releaseYorhel1-0/+23
2016-07-02Validate release dates + move validation out of vndb.plYorhel1-1/+1
2016-06-05Fix typo on release page.Albin Bernhardsson1-1/+1
2016-02-12Minor fixes / behaviour reverts related to the removal of L10NYorhel1-1/+1
- Fix mouse-over text of language flag on homepage - Capitalize release types in edit form - Use plural form of character roles on VN page listing
2016-01-23L10N: Intern all VNDB::Handler::* stuffYorhel1-78/+87
Most of these replacements were automated. This ended up being less work than I had anticipated. I also fixed a few minor bugs along the way, but probably introduced more than I fixed.
2016-01-20L10N: Intern all VNDB::Util::* stuffYorhel1-22/+22
With some related edits in other parts of the code, mostly due to interface changes to htmlRevision() and htmlFormError(). Trivial replacements were automated by a super awesome script.
2016-01-19Move some VNDB::L10N stuff to VNDB::Func + intern VNDB::FuncYorhel1-3/+3
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-1/+1
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2016-01-17L10N: Intern tag_cats/voiced/animated/*_statusYorhel1-16/+16
2016-01-16L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlengthYorhel1-31/+26
2015-12-30Add release filters to VN browserYorhel1-2/+4
2015-11-26Handler::Releases: Fix bug when editing release with lots of VNsYorhel1-1/+1
2015-10-28Handler::(Releases|VNEdit): Increase width of title/orig input fieldsYorhel1-2/+2
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel1-2/+2
This changes quite a bit to the way the editing functions work. Because these functions are very repetitive and it's easy to keep things out of sync, I created a script to generate them automatically. I had to rename a few function and table names for consistency to make this work. Since database entries don't have a 'latest' column anymore, and since the order in which tables are updated doesn't have to be fixed, I dropped many of the SQL triggers and replaced them with a edit_committed() function which is called from edit_*_commit() and checks for stuff to be done. Don't forget to run 'make' before importing the update script.
2015-10-17SQL: Fix all browsing queries to use the new schemaYorhel1-5/+6
This basically makes VNDB browsable again, but editing entries is still broken. I split off the get-old-revision functionality from the db*Get() methods into db*GetRev(). This split makes sense even with the old SQL schema: db*Get() had to special-case some joins/filters when fetching an older revision, and none of the other filters would work in that case. This split does cause some code duplication in that all db*GetRev() methods look very much alike, and that the columns they fetch is almost identical to the db*Get() methods. Not sure yet how to avoid the duplication elegantly. I didn't do a whole lot of query optimization yet (most issues require extra indices, I'll investigate later which indices will make a big difference), but I did fix some low hanging fruit whenever I encountered something. I don't think I've worsened anything, performance-wise.
2015-09-20formValidate: Created templates for gtin and editsum fieldsYorhel1-4/+2
2015-09-20Update usage kv_validate() to upcoming TUWF 1.0Yorhel1-6/+6
And added new 'page' and 'id' templates for more strict validation.
2015-08-17js: Add L10N strings to all relevant varsYorhel1-6/+1
This simplifies the JS code in some places and removes a whole number of L10N strings from the "l10n_str" var, thus shrinking the JS size a bit (uncompressed about 1500 bytes, in fact. 500 bytes after gzip).
2014-12-01Don't use inline script tag to pass pref_code to JSYorhel1-1/+1
This also simplifies the code a bit, as the value of the preference data was never used so doesn't need to be included now. Primary reason for this change is to work towards disabling inline JS with a CSP header. There's still more stuff to fix before the CSP header can be applied, though.
2013-10-21Handler::Releases: Fix 500 on /xml/releases.xml when VN has been deletedYorhel1-0/+1
Releases for the requested VN will now not be listed. This fixes the VN selector on character edit pages.
2013-01-21I18N: Merge all translation strings that eval to "Unknown"Yorhel1-11/+11
A generic '_unknown' is more easily usable.
2012-09-05Handler::Releases: Don't sort platform listing on edit pageYorhel1-1/+1
The filters list the platforms in the order they are present in the array, which also makes more sense than the odd ordering you get when sorting on their ID.
2012-01-25Do most of the table striping in CSSYorhel1-22/+21
Using CSS3 selectors. This is a more elegant approach, and since browser support for CSS3 selectors isn't as crap as it used to be I can finally make use of them.
2011-08-30Changed "remove"- and "add"-like words to a single lang.txt entryQCyph1-2/+2
2011-05-17Bugfix: Don't throw error when adding character to VN without releasesYorhel1-0/+1
2011-04-30Cleaned up permissionsYorhel1-1/+1
- Removed 'hist' and 'mod', weren't used at all - Merged 'del' and 'lock' into a single 'dbmod'
2011-03-14chardb: Added Char<->VN linking edit interfaceYorhel1-1/+33
Still somewhat quircky, but it works.
2011-02-04Merge branch 'beta'2.17Yorhel1-54/+54
Conflicts: ChangeLog
2011-02-03Cleaner and more efficient method of checking for the &fil= paramYorhel1-2/+2
With the new TUWF, kv_validate() returns undef when the param isn't present and an empty string if it is, but left empty. This is a more efficient way to differentiate between empty and nonexistent than the previous YAWF-method of grepping all param names.
2011-01-27L10N: Renamed _rbrowse_filters to _js_fil_filtersYorhel1-1/+1
2011-01-27TUWF: Added tag name to several end() callsYorhel1-5/+5
Haven't found any bugs this way, yet. I doubt there'll be any problems, but it's a nice new feature that could help quite a bit. :-D
2011-01-27TUWF: Use the uri_escape() provided by TUWFYorhel1-1/+1
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-47/+47
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2011-01-07Bugfix: Don't allow empty edit on releases with multiple producersYorhel1-1/+1
Caused by an errorneous sort statement when comparing the producer values.
2011-01-01V|R Browse: Don't apply saved filters when an empty filter string is givenYorhel1-1/+2
2011-01-01Bugfix: properly escape search query in links query stringYorhel1-2/+3
2011-01-01More infrastructural changes to accomodate for the permanent filtersYorhel1-2/+2
- Added a 'prefs' option to htmlFooter() to add preference data for use by Javascript. - Added an /xml/prefs.xml URL for setting preferences from JS. - Added 'filter_*' keys to the prefs_key ENUM - Load filters by default on VN and Release browser
2011-01-01Implemented filFetchDB() and converted the VN/Release browser to use itYorhel1-22/+20
This will correctly handle fetching stuff from the database when permanent filters are enabled. This update also removes compatibility with some old VN browse URLs. The old 'ti' and 'te' (tag include/exclude) query parameters are now ignored, and searching for a language in the query string (e.g. "q=English") won't enable the language filter.
2010-12-28Bugfix: translate screen resolutions on release revision pagesYorhel1-1/+1
2010-12-19RFC-01: Code/DB cleanup and renamed some stuff for consistencyYorhel1-3/+3
2010-12-19RFC-01: Fixed release list selection thing on release pagesYorhel1-10/+6
2010-12-17Check for editsum = description and give an easier to understand errorYorhel1-1/+2
The check is quite basic and you can easily get around it. It's just intended to warn about common mistakes.
2010-12-17Don't allow NULL for rr.minage and use -1 for unknownYorhel1-10/+8
This can be seen as a partial revert of 0a4f97f0186d6941a4cab2e3bd05201f1fed1441. I used to think using NULL for special values is more "correct" in database terms. But in the end I guess I should be aiming for whatever solution is easier. Both are "correct" in a sense anyway.
2010-12-14L10N: Extracted screen resolution strings from the codeYorhel1-2/+3
A somewhat ugly approach, but couldn't think of something better.
2010-12-04Handler::Releases: Fixed perl warning in _fil_compat()Yorhel1-1/+1
2010-11-28Release filter selector: Added original language filterYorhel1-1/+1
I'm surprised I haven't been able to find a combination of filters that would generate an SQL query that would run more than 300ms or so. PostgreSQL is amazing!
2010-11-27Filter system: Fixed IE8 compatibility and an HTML bugYorhel1-0/+1
IE7 still doesn't work, however. Not going to fix it either.
2010-11-27Replaced old VN advanced options with the new filter selection systemYorhel1-1/+1
Had to fix some bugs here and there and add some new functionality to the abstractions at some places, but it appears to be working now. There are still a few TODOs left, I'll get to those in a bit.
2010-11-26Added voiced field release filterYorhel1-1/+1
The release filters are now pretty much complete. Save, perhaps, for some improved styling and grouping in the filter selector; but I'm too lazy for that at the moment.