summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/Producers.pm
AgeCommit message (Collapse)AuthorFilesLines
2018-01-06Add bb2text() and use it for release notes & open graph tagsYorhel1-1/+1
2017-01-19Add Open Graph tags for the main page and vrspcflan1-1/+6
2016-11-03Add duplicate check to producer entryYorhel1-6/+70
2016-07-03Generalize substring search relevance + apply to most dropdown searchesYorhel1-1/+1
This is a generalization of the search improvements made in 7da2edeaa0f6cf7794f4f8f68960497dc1be893c and 92235222dba4e5d0c7713d53ef12e0f10e371b83 And has been applied to the dropdown searches for producers, staff, tags and traits. For all those searches, exact matches are listed first, followed by prefix matches, and then substring matches. Relevance is currently only based on the primary name/title and ignores aliases (except for staff). This is fixable, but not trivial, and I'm not sure it's all that useful.
2016-01-23L10N: Intern all VNDB::Handler::* stuffYorhel1-37/+37
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-9/+9
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-2/+2
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-8/+9
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 VN/producer relations + update relation graphsYorhel1-7/+3
Now that graphviz knows the actual strings, it has a better opportunity to create better graphs. (Most of them still look messy tho)
2016-01-16L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlengthYorhel1-13/+14
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel1-4/+4
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-6/+7
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-2/+1
2015-09-20Update usage kv_validate() to upcoming TUWF 1.0Yorhel1-2/+2
And added new 'page' and 'id' templates for more strict validation.
2015-05-12Fix display of 'external' iconYorhel1-1/+1
Broken in commit 887607bb3744c727ec617508c17b2b7df46c2287
2015-01-28Apply bbSubstLinks to database description fieldsYorhel1-0/+1
2011-08-30Changed "remove"- and "add"-like words to a single lang.txt entryQCyph1-1/+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-01-27TUWF: Added tag name to several end() callsYorhel1-8/+8
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-25TUWF: Initial convert from YAWF to TUWFYorhel1-26/+27
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.
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-1/+1
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-11-27Re-added producer role to collapsed view on producer pagesYorhel1-0/+4
And rewrote the expand/collapse JS/CSS code so that the difference between expanded and collapsed view is merely the class of the containing table. This way the JS code doesn't have to pass through the table rows and is thus noticeably faster for larger tables (i.e. /p65).
2010-11-26Use word-level (instead of character-level) diff for large fieldsYorhel1-2/+2
Primary reason for this change is because Algorithm::Diff::Fast isn't all that fast for character-level diffs. :-/
2010-11-11Producer release listing: added dev/pub info and expand/collapse linkYorhel1-5/+9
It's an awesome feature now. :-)
2010-11-11Display releases grouped by VNs on producer pagesYorhel1-18/+62
A nice expanded view. It also happens to be faster than the old view in terms of SQL queries. (In most cases at least) Can be improved a little more by: - Adding an 'expand/collapse' feature to list only the VNs - Adding a column indicating the role of the producer (dev/pub)
2010-11-06Fixed cross-site request forgery vulnerabilitiesYorhel1-0/+1
2010-11-01Properly order the relations listed on producer pagesYorhel1-1/+1
And changed the order a bit, as suggested by ImmLff.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-1/+6
This is implemented by adding ihid (item hidden) and ilock (item locked) columns to the changes table, The (vn|release|producer).(hidden|locked) columns now work as a cache, refering to the changes.(ihid|ilock) columns with changes.id = (vn|release|producer).latest. The cached columns are updated automatically each time a new revision is inserted. This is a pretty large change, bugs are quite likely.
2010-01-09L10N: Extracted/fixed some more strings on revision pagesYorhel1-2/+2
2010-01-01SQL: Revision insertion abstraction for producer entriesYorhel1-13/+6
2009-12-28Highlight opened VN/producer in relation graphsYorhel1-0/+1
The warnbg and warnborder colors from the skins are used for highlighting.
2009-12-05SQL: Removed changes.causedbyYorhel1-6/+4
This column was used to differentiate between automated edits and user edits, but that later changed to checking for changes.requester = 1. The column has since never really been used, and due to a bug introduced in VNDB 2.0, it has never been updated, either. Meaning it's not even accurate for any database changes made after december 2008...
2009-12-05Added maxlength check on the website field for releases and producersYorhel1-1/+1
A form validation error is somewhat more user friendly than a 500.
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel1-3/+3
And also changed the way the item_table.latest column was updated: it is now only updated after the revision insert has completed, making it easier to write trigger functions in SQL.
2009-11-14Added wikipedia links for producersYorhel1-3/+16
2009-10-25Handler::Producers: Fixed perl warning on adding new producerYorhel1-7/+5
2009-10-21Added relation graphs for producersYorhel1-0/+23
TODO: - document the relations - emit a relgraph notify when needed
2009-10-21Wrote producer relation editor interfaceYorhel1-2/+28
Again, mostly copied from the VN relation editor...
2009-10-21Display producer relations on producer pagesYorhel1-0/+17
2009-10-21Display producer relations in revision browserYorhel1-3/+9
And again copied something from the VN relation code... meh.
2009-10-21Started on the producer relationsYorhel1-13/+67
The current list of relations isn't final yet, may be changed later on. Quite a bit of this code has been copied from the VN relations... need to find a way to use prober code reuse here. TODO: - Nice relation editor interface - Display relations in revision browser - Display relations on producer pages - Generate relation graphs - Sync update_2.8.sql into dump.sql
2009-10-10Updated Producer and VN pages with developer/publisher informationYorhel1-0/+2
2009-09-24L10N: Translated the 'ALL' char and fixed footer TL bugYorhel1-1/+1
2009-09-15Handler::Producers: Fixed typo in maketext identifyerYorhel1-1/+1
2009-09-12Added reminders to write English to several form fieldsYorhel1-1/+1
2009-09-06Util::htmlRevision: Removed obsolete name argumentYorhel1-7/+7
2009-08-18htmlForm(): Don't generate subform id from the titleYorhel1-1/+1
The subform id is now passed to htmlForm() as first formpart item. This way the id won't change even if the title does, which will be the case with the interface translation.
2009-08-17L10N: Converted Handler::ProducersYorhel1-19/+19
Hmmm, I think I'll need to update some of the utility functions to take more functionality from the Handler pages in regard to getting text strings. Using mt() on everything that is essentially already passed to other functions with a unique string for identification is a bit double. So far I've updated htmlRevision to do this. (The name argument is still present but currently ignored, to preserve backwards compatility, the rest of the code will be updated soon.) Other utility functions like htmlForm should probably do something like that as well.
2009-08-17L10N: Converted htmlEditMessage, htmlItemMessage and htmlSearchBoxYorhel1-2/+3
This finishes Util::CommonHTML, with the exception of htmlVoteStats