summaryrefslogtreecommitdiff
path: root/lib
AgeCommit message (Collapse)AuthorFilesLines
2010-10-31VNDBUtil::normalize: Added search alias for 'fandisk'Yorhel1-0/+2
2010-03-14Made name of the auth cookie configurableYorhel1-4/+4
Now it's finally possible to run multiple VNDB's with different databases on the same domain without constantly getting logged out.
2010-03-14Handler::Users: Added noindex to user pagesYorhel1-1/+1
I could swear the user pages have always been noindex'ed... hmm.
2010-03-13Multi::IRC: Changed !vn command to use the new search functionYorhel1-16/+15
2010-03-13Multi::API: Fixed a Perl warning on 'get vn' with the platforms array filterYorhel1-2/+2
2010-03-13Multi::API: Make use of the new search function for 'get vn'Yorhel1-4/+13
This required a new 'split' option to consider a string as an array.
2010-03-13Improved VN searchYorhel4-177/+262
This adds a new column to the vn table: c_search, which holds the normalized titles for speedy search results using LIKE. Also split some functions from VNDB::Func that didn't require YAWF into a VNDBUtil module, so Multi can also make use of them. The normalization functions are the same for Multi and VNDB, after all. The API and Multi::IRC still use the old search, these should be updated as well.
2010-03-13Handler::Tags: Re-added /g/debugYorhel1-0/+31
2010-03-09DB::ULists: Greatly improved query performance for VN list with 'hide voted'Yorhel1-2/+2
Crawlers would often find such pages, and the query would often take more than a second to finish, in some extreme cases even 10 seconds. This fix converts an intermediate result into an array, forcing the query planner to evaluate the subquery first, resulting in a far more optimal query plan.
2010-03-09Multi::API: Properly format returned error message on incorrect UTF8Yorhel1-1/+5
2010-03-09Multi::API: Got rid of perl warning on incorrect JSON::XS::decode_prefix()Yorhel1-1/+1
substr outside of string at /www/vndb/lib/POE/Filter/VNDBAPI.pm line 124. I have no idea what input caused JSON::XS to return an invalid character offset... but oh well.
2010-03-08Multi::API: Fixed 'Unkown' -> 'Unknown'applehq1-5/+5
2010-03-05API: Added image field to 'get vn'Yorhel1-1/+2
2010-02-19Two more GTIN-related fixesYorhel2-2/+2
1. Don't try to normalize the GTIN code in the releases form when it's 0 2. Don't try to gtintype() *every* number in the search
2010-02-19VNDB::Func: Another gtintype() related bugfixYorhel2-2/+4
We have to assume that the input doesn't always have enough zeros, to fill the 12 characters, otherwise UPC codes fail when they are fetched from the database (which is stored as a bigint, no zero padding in the output). Instead, we'll just add the zeros ourselves up to 12 for normalization purposes.
2010-02-19VNDB::Func::gtintype: Another silly bug fixYorhel1-1/+0
You can't quite check the length of the GTIN code if you strip away zeros in the beginning, right?
2010-02-19VNDB::Func::gtintype: Fixed stupid mistake in regexYorhel1-1/+1
2010-02-17Multi::IRC: Added !scr command for reverse screenshot lookupYorhel1-1/+27
2010-02-13Multi::Anime: Some minor fixes when the UDP API is down or returns an errorYorhel1-3/+3
2010-02-10Handler::Tags: Increased maxlength of the tag descriptionsYorhel1-1/+1
2010-02-06Handler::ULists: Fixed L10N bug with the char browser on /u+/listYorhel1-1/+1
2010-02-06Handler::VNEdit: Removed useless line breakYorhel1-1/+1
The layout looks better without that.
2010-02-06Handler::VNPage: Don't show delete option when not on wishlistYorhel1-1/+1
...rather useless option to have.
2010-02-06Handler::Users: Re-fetch notifycount after batch-editing notificationsYorhel1-0/+1
So that the count displayed in the main menu is updated immediately, rather than on a subsequent pageview.
2010-02-06L10N-NL: Added Dutch interface translationYorhel1-1/+9
I may do the docs later as well, when I'm terribly bored again.
2010-02-05Merge branch 'master' into betaYorhel2-5/+5
Conflicts: data/lang.txt
2010-02-05Notifications: Added 'announce' notificationYorhel2-9/+14
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' notificationYorhel2-3/+30
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-02SQL: Converted language columns to an ENUM typeYorhel5-15/+14
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-02Handler::Users: Got rid of useless sprintf statementYorhel1-1/+0
2010-02-02Notifications: Renamed description column to actionYorhel1-1/+1
2010-02-01Added notification for database deletions to users who contributedYorhel1-1/+2
Complex queries...
2010-02-01Cache the title and userid of the notificationsYorhel2-10/+3
These aren't likely to change anyway, and things will become less easy to display when other types of notifications are added.
2010-02-01Notifications: Added onclick event to the description columnYorhel1-1/+1
More intuitive to allow clicking on that as well to open the notification.
2010-02-01Made the "My notifications" link less easier to ignore when n>0Yorhel1-2/+1
2010-02-01Properly copy over search string on switching with the searchtabsYorhel1-13/+6
2010-01-31Removed #vndb link from the main menuYorhel1-3/+3
Too many "HEY CAN YOU RECOMMEND ME .." people going around. The channel is crowded enough now.
2010-01-26Automatically remove sessions that haven't been used for a monthYorhel1-2/+9
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel2-8/+4
An expiration date doesn't make much sense if it's both not used and if it can't be configured by the user, so just make this a timestamp to indicate when the session has been added, which, while still not really used, is more valuable.
2010-01-26Keep track of when a session has last been usedYorhel2-1/+11
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/+15
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 systemYorhel6-38/+177
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-1/+1
The current error message isn't really intuitive, though...
2010-01-24Automatically generate the skin credits on d7Yorhel4-6/+18
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-24SkinFile: Abstracted access to the skin configuration filesYorhel1-0/+73
And updated skingen.pl and vndb.pl to make use of this abstraction.
2010-01-24Multi::IRC: Announcements are colored in blue rather than redYorhel1-14/+16
This way you can easily see the difference between an announcement and a regular user-requested reply.
2010-01-24Show deleted entries in the edit histories by defaultYorhel2-3/+3
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 entriesYorhel10-55/+55
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/+2
2010-01-23DB::VN: Fixed ranking bug on VN pages with a NULL popularity or ratingYorhel1-2/+2