summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
AgeCommit message (Expand)AuthorFilesLines
2010-12-13Added advanced tag link browserYorhel1-4/+34
2010-12-10Keep track of last modification date for tag<->vn linksYorhel1-4/+27
2010-12-10Added vote listings for VNs and users (/[uv]+/votes)Yorhel1-3/+12
2010-11-28Release filter selector: Added original language filterYorhel1-2/+4
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-26Added voiced field release filterYorhel1-1/+2
2010-11-26Added animation field release filterYorhel1-2/+4
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