summaryrefslogtreecommitdiff
path: root/ChangeLog
AgeCommit message (Collapse)AuthorFilesLines
2010-02-06Version bump2.11Yorhel1-1/+1
2010-02-06L10N-NL: Added Dutch interface translationYorhel1-0/+1
I may do the docs later as well, when I'm terribly bored again.
2010-02-05Notifications: Added 'announce' notificationYorhel1-0/+1
This one is also configurable, but mainly because I want to avoid generating several thousands of notifications for a single action...
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-0/+1
And added a settings window where you can disable this notification, which is something you really want to do if you're an active contributor...
2010-02-04Notifications: Added notify for deletion of entries in (wish)listYorhel1-0/+1
2010-02-02Differentiate between pt-PT and pt-BR in the languagesYorhel1-0/+1
As requested, http://vndb.org/t423
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-0/+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.
2010-02-01Added notification for database deletions to users who contributedYorhel1-1/+3
Complex queries...
2010-02-01Properly copy over search string on switching with the searchtabsYorhel1-0/+1
2010-01-26Automatically remove sessions that haven't been used for a monthYorhel1-1/+1
2010-01-26Keep track of when a session has last been usedYorhel1-0/+1
If we're going to automatically remove older sessions, it would make more sense to remove unused sessions, rather than old sessions that are still in use. But we first need to keep track of when a session has last been used to do so...
2010-01-26Removed the ?l10n= parameterYorhel1-0/+1
Setting the l10n cookie is now done from a separate url: /setlang This makes the language determination code less complex, and makes sure nobody links to pages that change the UI language without intending to. (I've seen some links floating around with the l10n parameter included, which is... bad)
2010-01-26Made a start on the notification systemYorhel1-0/+1
The current setup should be able to handle all kinds of notifications, though only PMs are implemented at this point. More to come.
2010-01-24Handler::Tags: Only allow tagmods to create top-level tagsYorhel1-0/+1
The current error message isn't really intuitive, though...
2010-01-24Automatically generate the skin credits on d7Yorhel1-0/+2
Added a userid field in the skin config files, from which the credits are loaded. Now I don't have to constantly update d7 for every language when something changes in the skin files.
2010-01-24Multi::IRC: Announcements are colored in blue rather than redYorhel1-0/+1
This way you can easily see the difference between an announcement and a regular user-requested reply.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-0/+1
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-23Handler::Releases: Made the release date a required fieldYorhel1-0/+1
2010-01-23JS: Improved date selectorYorhel1-0/+1
Replaced the selection boxes with some javascript dropdown magic. This saves a click and a scroll per date part in most cases.
2010-01-23Handler::VNPage: Centered the thumbnails in the screenshot viewerYorhel1-0/+1
And greatly simplified the HTML of the screenshot viewer and fixed a HTML bug (colspan when it wasn't needed) in the process.
2010-01-11Added Slovak to the list of languagesYorhel1-0/+3
2010-01-10Merge branch 'beta'2.10Yorhel1-0/+21
+ Changelog update for 2.10
2010-01-10L10N: Determine language from Accept-Language headerYorhel1-0/+1
So that people with correctly configured browsers don't have to manually choose their language of choice with the language switcher, and so that most people will have one cookie less. (The 'l10n' cookie is removed if it matches the Accept-Header language -- or the fallback) More info @ http://www.w3.org/International/questions/qa-lang-priorities
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-0/+1
The functions can now be edited without having to repeat them in the update scripts. Just importing the func.sql file with \i will do the trick.
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-28Rewrote POE::Filter::VNDBAPI to be more genericYorhel1-0/+1
A POE::Filter shouldn't do anything more than parsing incoming data into perl structures and vice versa. The previous implementation had too much logic in the filter itself, which has now been moved into Multi::Anime.
2009-12-16Fixed bug with zero strings ("0") in the diff viewerYorhel1-0/+1
2009-12-16JS: Made screenshot release linking less painfulYorhel1-0/+1
1. If there's only one release, select that by default 2. Allow release selection before uploading the file 3. Use the release of the last uploaded screenshot (within the same session) as default for subsequent uploads.
2009-12-16JS: Fixed minor issue with the dropdownYorhel1-0/+1
When a trigger object for a dropdown box is within 10px of an opened dropdown box, doing a mouse-over on it didn't trigger the new dropdown to be opened.
2009-12-05SQL: Removed changes.causedbyYorhel1-0/+1
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-0/+1
A form validation error is somewhat more user friendly than a 500.
2009-12-05SQL: Removed the use of CONSTRAINT TRIGGERsYorhel1-0/+1
This makes use of the change that the [vn|producers].latest columns are now only updated after the entire revision has been inserted.
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel1-0/+1
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-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-0/+2
The return value of dbTagTree() is also somewhat easier to work with.
2009-11-28v+: Allow hiding of NSFW cover even if NSFW warning is disabledYorhel1-0/+1
2009-11-28homepage: Show language flags Just released and Upcoming releasesYorhel1-0/+1
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-0/+1
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-0/+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-27Display VN ratings on tag pages as wellYorhel1-0/+1
With this method I managed to reuse the VN list table code for the lists on both the VN browser and the tag pages. And optimized away the dbTagVNs() function while I was at it (dbVNGet() is powerful enough)
2009-11-27Changed VN score on tags pages to display plain averagesYorhel1-0/+3
For three reasons: - Speed tag_vn_calc() is now more than 10 times faster (granted, it could have been a lot faster even with the bayesian rating, but whatever) - Consistency with the tag scores displayed on the VN pages (which are raw averages as well) - It didn't always make sense
2009-11-16Merge branch 'beta'2.9Yorhel1-0/+14
+ Changelog update
2009-11-14SQL: Allow NULL for vn.c_popularityYorhel1-0/+1
Sorting from least to most popular VN make sense now, you won't have to wade through those entries without any vote at all.
2009-11-14Added bayesian rating and vote count to the VN listYorhel1-0/+1
It's even realtime! To my surprise this calculation isn't very heavy, or PostgreSQL is just extremely fast. The GetVN query on /v/all takes 100ms in the worst case (instead of the usual 30-60ms). Can always cache this later on.
2009-11-14Made external links on VN pages translatableYorhel1-1/+1
2009-11-14Added wikipedia links for producersYorhel1-0/+1
2009-11-14SQL/L10N: Allow NULL for releases_rev.minage and make the values translatableYorhel1-0/+2
2009-11-13docs: Updated d11 and added :SUBSUB: macroYorhel1-0/+1
2009-11-13Multi::IRC: Tweaked the idlequote timingsYorhel1-0/+1
She shouldn't spam a quote more than once every 48 hours per channel now. Also decreased the actual idle timeout, so that the channel doesn't have to be idle for that long.
2009-11-09bb2html: Added [code] tag and fixed a minor bugYorhel1-0/+1
The previous version also had a problem with closing tags when a $maxlength was defined. With $maxlength, not all tags actually open a tag in HTML, after all.
2009-11-09Plugin::TransAdmin: CSS/doc fixes related to the APIYorhel1-0/+3
+ Changelog updates, considering the API and other changes are now in the beta branch.