summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
AgeCommit message (Expand)AuthorFilesLines
2010-11-21Implemented the server side of the new release filter selectorYorhel1-27/+31
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-15/+1
2010-11-11DB::Releases: Removed extra ON clause from JOIN releasesYorhel1-1/+1
2010-11-11Producer release listing: added dev/pub info and expand/collapse linkYorhel1-0/+1
2010-11-11Display releases grouped by VNs on producer pagesYorhel2-27/+5
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-5/+6
2010-11-07DB::Misc: Optimized dbRevisionGet()Yorhel1-17/+19
2010-11-07Optimized random VN fetching queryYorhel1-1/+7
2010-11-07Optimized random screenshot fetching queryYorhel1-8/+12
2010-11-06Bugfix: delete/update all references when deleting a userYorhel1-0/+5
2010-11-03Merge branch 'master' into betaYorhel1-2/+2
2010-11-02Multi::Image: Abstracted image dimension calculation into VNDBUtilYorhel1-1/+2
2010-10-31Remove duplicate votes when merging tags (fixes a 500)Yorhel1-0/+4
2010-03-13Improved VN searchYorhel1-28/+5
2010-03-09DB::ULists: Greatly improved query performance for VN list with 'hide voted'Yorhel1-2/+2
2010-02-19Two more GTIN-related fixesYorhel1-1/+1
2010-02-05Merge branch 'master' into betaYorhel1-2/+2
2010-02-05Notifications: Added 'announce' notificationYorhel1-2/+2
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-2/+2
2010-02-02SQL: Converted language columns to an ENUM typeYorhel2-4/+4
2010-02-01Cache the title and userid of the notificationsYorhel1-9/+2
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel1-5/+2
2010-01-26Keep track of when a session has last been usedYorhel1-1/+9
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