summaryrefslogtreecommitdiff
path: root/lib/VNDB/Util/BrowseHTML.pm
AgeCommit message (Collapse)AuthorFilesLines
2016-01-20L10N: Intern all VNDB::Util::* stuffYorhel1-13/+13
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-17L10N: Intern tag_cats/voiced/animated/*_statusYorhel1-1/+1
2016-01-16L10N: Intern languages/platforms/resolutions/media/ptype/rtype/vnlengthYorhel1-2/+2
2015-11-10Show full date/time at edit history and thread listingsYorhel1-1/+1
Having the time display is quite useful. It does make the listings look more cluttered, but meh.
2015-10-17SQL: Fix all browsing queries to use the new schemaYorhel1-2/+2
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-07-22Util::BrowseHTML: Fix XSS in "order by" link URLsYorhel1-2/+2
Reported by dim0k at https://www.xssposed.org/incidents/74523/
2015-05-13Changed layour of staff pagesYorhel1-2/+2
Not entirely sure if this is an improvement, but it's slightly more consistent with other layouts (combination of user page, release page and character page), and leaves more room for the credit/cast listings.
2014-10-13SQL: Use enum to represent platformsYorhel1-1/+1
I believe I didn't do this conversion earlier (back when I converted the language types) because PostgreSQL didn't support dynamically adding new values to an existing enum back then, and modifying an enum was a huge pain. Recent versions do support this, so there's no reason to keep it as a string. ...I just felt like adding some churn to the code base.
2012-07-24Add wishlist / VN list status options to VN list browserSpaceRanger1-0/+8
2012-01-25Do most of the table striping in CSSYorhel1-3/+3
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.
2012-01-10Allow one fractional digit for VN votesYorhel1-1/+1
The interface to set a non-integer vote isn't very nice, but at least it works. Or so I hope.
2011-01-27TUWF: Added tag name to several end() callsYorhel1-6/+6
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-1/+1
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-20Added advanced page-browsing tabs to threadsYorhel1-13/+30
2010-12-09Removed expand/collapse from /u+/posts and switched to a combined viewYorhel1-1/+1
And removed some shared code that is now unused
2010-12-09Removed expand/collapse from history browser switched to a combined viewYorhel1-10/+4
Much less screen space wasted this way.
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-1/+1
And changed vn.c_languages to an array type while I was at it. This required some changes in the Perl code, and I found a bug in DBD::Pg while I was at it: https://rt.cpan.org/Ticket/Display.html?id=54224 Luckily, there's an easy workaround for that.
2009-11-27Split browse functions from CommonHTML.pm into BrowseHTML.pmYorhel1-0/+204
CommonHTML.pm was starting to get a bit large. Also renamed htmlHistory to htmlBrowseHist while I was at it, to keep consistency with the htmlBrowse functions.