path: root/lib/VNDB/Handler/
AgeCommit message (Collapse)AuthorFilesLines
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 = (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
2009-08-17L10N: Moved some functions from to and added Russian quant() ↵Yorhel1-1/+1
and age()
2009-08-17L10N: Converted producer and release typesYorhel1-4/+4
And replaced the ugly release type cssicon class hack. The class is now 'tr'.$type_numer, instead of the first three characters of their English representation in lowercase. No idea why I haven't done it this way in the first place...
2009-08-17L10N: Converted user ranks and language namesYorhel1-5/+5
User ranks are easy... but the language names are used everywhere!
2009-08-05Removed last traces of the shared memory processing queueYorhel1-2/+0
Everything has now finally been converted to use the PgSQL LISTEN/NOTIFY feature. This commit removes the last Tie::ShareLite dependency.
2009-05-31Tabs on v/r/p/g search fieldsYorhel1-4/+1
This should make a nice connection between the few kinds of database entries we have.
2009-05-10Added search field on release browserYorhel1-2/+2
2009-02-21Small performance improvements: Don't always fetch all columns on ↵Yorhel1-4/+4
dbProducerGet() Added an 'extended' flag to the 'what' argument, which should be used if more columns are desired.
2009-02-21Aliases field to producer entriesYorhel1-1/+6
2008-12-13FF2 style fixesYorhel1-1/+1
Three-box-layout didn't work very well together with the screenshots on the homepage and the CSS icon hack needed a   to get rid of a strange top margin. With this, the following browsers should render all pages correctly: FF2, FF3 and the latest Opera, Safari and Chrome
2008-12-11Basic userpage + recent votes to VN pages + long-object-float bugfixYorhel1-1/+1
These changes are all pretty much related, so couldn't really do that in multiple commits.
2008-12-09Code cleanup: removed leading spaces and combined ↵Yorhel1-1/+1
DB/{Votes,VNList,WishList}.pm into
2008-12-04Added htmlItemMessage() for some generic messages about editing the pageYorhel1-1/+1
2008-12-04Added noindex tag on pages I don't want to see indexedYorhel1-2/+2
Including anything related to editing, item histories, etc. No need to have those pages in google, is there?
2008-12-04...and an interface for adding/removing producersYorhel1-1/+26
Code reuse = good. Release edit form is now finished, functionality-wise.
2008-11-29Add new producer bugfixYorhel1-1/+1
2008-11-22Created htmlEditMessage() and started on /v+/editYorhel1-21/+1
It'll take a while before the VN edit form is finished... it's one of the most complex things of VNDB.
2008-11-22Wrote a generic function to handle all /[vrp]+/(lock|hide) URIsYorhel1-12/+0
They pretty much all work the same anyway
2008-11-21Added htmlHiddenMessage() to hide deleted itemsYorhel1-14/+1