summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
AgeCommit message (Expand)AuthorFilesLines
2011-01-02Bugfix: Don't show NSFW screenshots on homepage with filtersYorhel1-1/+1
2011-01-01Also apply permanent VN filters to the random screenshots on /Yorhel1-3/+22
2010-12-21Pass VN tag filters by ID rather than nameYorhel1-9/+15
2010-11-28VN Filter Selector: Added "original language" filterYorhel1-1/+3
2010-11-27VN Filter Selector: Added "has anime" filterYorhel1-1/+3
2010-11-27VN Filter Selector: Added length field filterYorhel1-1/+3
2010-11-27Replaced old VN advanced options with the new filter selection systemYorhel1-5/+5
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-5/+6
2010-11-07Optimized random VN fetching queryYorhel1-1/+7
2010-11-07Optimized random screenshot fetching queryYorhel1-8/+12
2010-11-02Multi::Image: Abstracted image dimension calculation into VNDBUtilYorhel1-1/+2
2010-03-13Improved VN searchYorhel1-28/+5
2010-02-05Merge branch 'master' into betaYorhel1-2/+2
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-3/+3
2010-01-24Versioned the deleting and locking of database entriesYorhel1-1/+1
2010-01-23DB::VN: Fixed ranking bug on VN pages with a NULL popularity or ratingYorhel1-2/+2
2010-01-01SQL: Made a start on revision insertion abstractionYorhel1-27/+28
2009-12-05SQL: Removed changes.causedbyYorhel1-1/+1
2009-12-05SQL: Call update_vncache() in a triggerYorhel1-8/+1
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel1-23/+3
2009-11-29SQL: Replace index on tags_vn_inherit (tag) with an index on (tag,vid)Yorhel1-0/+1
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-4/+14
2009-11-27Changed VN score on tags pages to display plain averagesYorhel1-3/+3
2009-11-14SQL: Cached bayesian VN rating and vote countsYorhel1-6/+4
2009-11-14Added bayesian rating info to VN pagesYorhel1-2/+5
2009-11-14Added bayesian rating and vote count to the VN listYorhel1-1/+4
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-1/+1
2009-10-12SQL: Converted changes.type to an ENUMYorhel1-2/+2
2009-09-26Properly handle UTF-8 in relation graph SVGsYorhel1-0/+5
2009-09-25Use inline SVG for relation graphsYorhel1-2/+2
2009-08-09Converted changes.added to timestamptzYorhel1-1/+1
2009-08-08Improved handling of the timestamp columns in anime and session tablesYorhel1-1/+1
2009-08-08Removed last traces of the category systemYorhel1-20/+3
2009-07-19Converted and renamed screenshots.status (int) to processed (bool)Yorhel1-1/+1
2009-07-18Automatically insert rows into anime table for new vn_anime.aid itemsYorhel1-18/+5
2009-07-05Tag exclude filters on VN searchYorhel1-1/+3
2009-07-05Added spoiler options for tag filters on VN searchYorhel1-3/+5
2009-07-05Made a start on the multiple-tag-VN-searchYorhel1-1/+6
2009-06-07Merge branch 'beta'2.4Yorhel1-19/+4
2009-05-24Removed category filters from /v/allYorhel1-14/+1
2009-05-24Don't perform search subquery when there are no keywords to search onYorhel1-4/+3
2009-05-24Allow search queries with only one characterYorhel1-1/+0
2009-05-10Fixed off-by-one error in popularity ranking on v+Yorhel1-1/+1
2009-05-03Don't show screenshots of hidden VNs on homepageYorhel1-1/+1
2009-05-03Don't count hidden VNs in ranking + first rank considered with shared placeYorhel1-1/+1
2009-01-16Let VN search match on vn->original, and regard . and _ as spacesYorhel1-3/+3
2009-01-15Fixed a very old bug with the VN search matching on release titles of older r...Yorhel1-1/+3
2009-01-10Popularity indicator on VN pagesYorhel1-1/+2
2009-01-10Added VN popularity rankingYorhel1-1/+1
2008-12-15Decreased number of screenshots on the homepage to 4Yorhel1-1/+1