summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
AgeCommit message (Expand)AuthorFilesLines
2010-01-26Made a start on the notification systemYorhel2-27/+67
2010-01-24Automatically generate the skin credits on d7Yorhel1-1/+3
2010-01-24Versioned the deleting and locking of database entriesYorhel4-18/+12
2010-01-23DB::VN: Fixed ranking bug on VN pages with a NULL popularity or ratingYorhel1-2/+2
2010-01-11Fixed sorting bug on /u+/postsYorhel1-3/+8
2010-01-11Tags: Another bugfix in the parent tags SQL query and displayYorhel1-1/+1
2010-01-01SQL: Revision insertion abstraction for producer entriesYorhel2-14/+13
2010-01-01SQL: Revision insertion abstraction for release entriesYorhel2-45/+44
2010-01-01SQL: Made a start on revision insertion abstractionYorhel2-85/+43
2009-12-05SQL: Removed changes.causedbyYorhel2-2/+2
2009-12-05SQL: Call update_vncache() in a triggerYorhel1-8/+1
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel4-87/+36
2009-11-29SQL: Replace index on tags_vn_inherit (tag) with an index on (tag,vid)Yorhel1-0/+1
2009-11-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-5/+30
2009-11-28dbWishListGet: Don't order by vr.* columns by defaultYorhel1-1/+1
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel6-33/+85
2009-11-27Display VN ratings on tag pages as wellYorhel1-27/+1
2009-11-27Changed VN score on tags pages to display plain averagesYorhel2-8/+8
2009-11-15Auth: Combined dbSessionCheck into dbUserGetYorhel1-14/+11
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-11-14Added wikipedia links for producersYorhel1-3/+3
2009-11-14SQL/L10N: Allow NULL for releases_rev.minage and make the values translatableYorhel2-2/+2
2009-10-25dbRevisionGet: Fixed 500 when using the 'Include edits of releases' optionYorhel1-1/+1
2009-10-21Added relation graphs for producersYorhel1-2/+4
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-1/+1
2009-10-21Started on the producer relationsYorhel1-3/+25
2009-10-12SQL: Converted changes.type to an ENUMYorhel4-18/+18
2009-10-10List all known languages on /r and /v/all instead of only those in useYorhel1-15/+1
2009-10-10Greatly reduced default number of columns returned by dbUserGetYorhel1-3/+7
2009-10-10Get unread posts count in htmlHeader() instead of Util::AuthYorhel1-10/+16
2009-10-10Display number of unread posts in user menuYorhel2-2/+18
2009-10-10Updated Producer and VN pages with developer/publisher informationYorhel1-1/+2
2009-10-09Added producer role (developer/publisher) to DB and release editorYorhel1-4/+4
2009-10-09SQL: Converted releases_media.medium to an ENUM typeYorhel1-1/+1
2009-09-26Properly handle UTF-8 in relation graph SVGsYorhel1-0/+5
2009-09-25Use inline SVG for relation graphsYorhel1-2/+2
2009-08-16Fixed typo in DB::UlistsYorhel1-1/+1
2009-08-12Added global user votes ignore listYorhel2-4/+8
2009-08-09Converted changes.added to timestamptzYorhel4-4/+6
2009-08-08Don't show hidden VN items on g+ pagesYorhel1-0/+1
2009-08-08Converted tags.added to timestamptzYorhel1-2/+3
2009-08-08Converted users.registered to timestamptzYorhel1-5/+5
2009-08-08Converted votes.date to timestamptz and use NOW() as defaultYorhel1-3/+3
2009-08-08Converted threads_posts.date and edited to timestamptzYorhel1-5/+5
2009-08-08Converted wlists.added and rlists.added to timestamptzYorhel1-1/+1
2009-08-08Improved handling of the timestamp columns in anime and session tablesYorhel2-8/+3
2009-08-08Removed last traces of the category systemYorhel1-20/+3
2009-08-08Merge branch '3dev' of git://3decibels.net/vndb into betaYorhel1-1/+3