summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/Misc.pm
AgeCommit message (Collapse)AuthorFilesLines
2010-01-24Show deleted entries in the edit histories by defaultYorhel1-2/+2
They used to be hidden from all edit histories, but there's not really a point in hiding them. In fact, it'll only confuse people who just got their DB entry deleted and can't find any evidence that it even existed at all.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-16/+0
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.
2009-12-05SQL: Call update_vncache() in a triggerYorhel1-6/+1
This removes the need for the dbVNCache() function in perl.
2009-11-28homepage: Show language flags Just released and Upcoming releasesYorhel1-0/+2
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-5/+5
The ORDER BY was previously specified using an 'order' argument, which would then be directly inserted into the query. The new method is the same as what I used for the public API: two 'sort' and 'reverse' arguments. This should be less error-prone and more readable. This changes quite a lot of code, so I hope I haven't forgotten to update something along the way.
2009-11-27Split browse functions from CommonHTML.pm into BrowseHTML.pmYorhel1-1/+1
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.
2009-11-13docs: Updated d11 and added :SUBSUB: macroYorhel1-1/+6
2009-10-24Merge branch 'beta'2.8Yorhel1-4/+9
+ ChangeLog update
2009-10-22d+: Wrote more extensive credits page and moved link icons to the FAQYorhel1-0/+6
2009-10-18Handler::Misc: Fixed bug with unhiding a producer entryYorhel1-1/+1
I could swear I'd found and fixed a similar bug in the past...
2009-10-12SQL: Converted changes.type to an ENUMYorhel1-3/+2
This is a very important column in a very important table, I hope I didn't forget to update a piece of code somewhere...
2009-09-26homepage: Minor typo fix + link to /v/randYorhel1-1/+3
2009-09-12Typo fix in the IE6-must-die messageYorhel1-1/+1
2009-09-07Handler::Misc: Made box titles on the homepage click-ableYorhel1-6/+16
2009-09-04L10N: Implemented framework for translation of the doc pagesYorhel1-2/+6
When a [docname].[langauge tag] file is available for the user language, that is used instead of the main [docname] file.
2009-08-17L10N: Converted Handler::Discussions and the discussion_boards listYorhel1-1/+1
2009-08-17L10N: Converted Handler::Misc::nospamYorhel1-4/+4
This finishes Handler::Misc.
2009-08-17L10N: Converted two homepage items and use key for site titleYorhel1-13/+11
2009-08-17L10N: Moved some functions from Func.pm to L10N.pm and added Russian quant() ↵Yorhel1-3/+3
and age()
2009-08-17L10N: Converted platform namesYorhel1-2/+2
2009-08-17L10N: Converted homepage and history pagesYorhel1-33/+24
There are a few things left hardcoded, though: The 'expand' link is also in Javascript, that will probably need some mechanism for TL as well. The format of the items on the homepage might need to change depending on the language, I can imagine that not every language uses the 'title by name' construct. Especially the age() function needs a localized version.
2009-08-17L10N: Russian TL for site title and main menuYorhel1-2/+2
Things are looking good so far.
2009-08-11Improved styling of the threeboxes layoutYorhel1-90/+98
It's still not perfect, though: - New version is table-based - meh. - Uses negative margins more than once - meh! - Only works if any of the columns has enough content to wrap. If all content fits in the columns without wrapping, the total table width falls back to the "min-width: 100%" statement - which, with the negative margins, isn't really 100%. MEH! Still... it looks better than the previous solution. So far tested on FF3.5, Opera 9.something, and some semi-recent version of webkit. Reported to work fine on IE7 as well.
2009-08-06Added OpenSearch plugin + autodetectionYorhel1-1/+21
2009-07-23Implemented relgraph notify from PgSQL triggerYorhel1-1/+1
This finishes the new relation graph generator, as it'll now regenerate graphs as soon as is needed. This obsletes the VNDB::Util::Misc::vnCacheUpdate() function, this functionality is provided by triggers within PostgreSQL. The update_vncache(0) procedure is now significantly slower due to the trigger on the vn table. It'd be a good idea to rewrite this procedure by using triggers and conditional updates, to drastically lower the number of rows that need to be updated.
2009-07-07Hide threads targeted at users from the main pageYorhel1-1/+1
2009-07-04Removed old /v/cat URL rewriting functionYorhel1-15/+0
That URL is so extremely old that I doubt anyone still links to it.
2009-06-15Display related boards in tooltip on recent posts on homepageYorhel1-2/+3
And another 5ms to the page loading time of the homepage. Byebye, server resources, byebye! :-(
2009-06-07Merge branch 'beta'2.4Yorhel1-1/+1
+ Set 2.4 date in ChangeLog
2009-06-01Display edit history for hidden itemsYorhel1-1/+1
2009-05-11Make sure to get current hidden status when (un)hiding a releaseYorhel1-1/+1
2009-03-15Consistent filter naming on /v+/histYorhel1-1/+1
<SilverDragon> btw, a small thing <SilverDragon> in vn's edit history, there are two selectors: "Show automated edits / Hide automated edits" and "Exclude / Include edits of releases". Shouldn't "Exclude" be "Exclude edits of releases" as well? <Yorhel> looks obvious enough to me without the full "..edits [..]" <SilverDragon> true, that's obvious, but imho looks too strange together with the first one, where 'automated edits' is repeated
2009-03-01Removed useless extra query on /histYorhel1-1/+1
2009-02-06Added platform icons to Just released / Upcoming releases on homepageYorhel1-2/+6
2009-01-15Don't forget to update the vn.c_* columns when hiding/unhiding a releaseYorhel1-1/+5
2008-12-18Added redirect: /u+/votes -> /u+/list?v=1Yorhel1-0/+2
/u+/votes was used somewhere in the past. While I don't think anyone still uses it, nothing's wrong with providing a redirect.
2008-12-17Moved age() to VNDB::FuncYorhel1-12/+0
2008-12-17Homepage: Use relative ageapplehq1-1/+13
2008-12-17Added warning for IE6 usersYorhel1-0/+43
2008-12-17Hide edits of hidden items from homepageYorhel1-1/+1
(12:46:39) applehq: bug: recent changes on the homepage show hidden v+.+ Fixed!
2008-12-15Redirect old /v/cat URLs to the new search functionYorhel1-1/+16
2008-12-15Redirect /v/search to /v/all (including the query)Yorhel1-0/+1
I kind of forgot there was a firefox search plugin for VNDB which points to /v/search, let's not break that one.
2008-12-14Don't hide automated edits by default on /[vrp]+/histYorhel1-1/+1
2008-12-13Exclude automated edits from the homepageYorhel1-1/+1
2008-12-13Include edits of releases filter to /v+/histYorhel1-0/+9
2008-12-13FF2 style fixesYorhel1-2/+1
Three-box-layout didn't work very well together with the screenshots on the homepage and the CSS icon hack needed a &nbsp; 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-12HomepageYorhel1-0/+117
No idea why, but it looks like a mess :-(
2008-12-12Redirect /v to /v/allYorhel1-1/+1
2008-12-11Recent changes on userpagesYorhel1-43/+1
2008-12-09Code cleanup: removed leading spaces and combined ↵Yorhel1-5/+5
DB/{Votes,VNList,WishList}.pm into ULists.pm
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-19 15:29:42 +0000