summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
AgeCommit message (Expand)AuthorFilesLines
2020-06-07DB::VN: Fetch random homepage screenshots using TABLESAMPLEYorhel1-14/+20
2020-04-06Delete old relation graph generating and caching machineryYorhel1-5/+3
2020-04-06DB::VN: Fix 500 by randomly generating a "sf0" vndbidYorhel1-1/+1
2020-04-05SQL: Add C-based "vndbid" type and use it for image IDsYorhel1-11/+10
2020-03-12SQL: Keep track of dimensions for all images in the DBYorhel1-14/+1
2020-03-12SQL: Use global "images" table for metadata of all images in the DBYorhel1-15/+19
2019-12-29ulist: Display labels on VN browserYorhel1-0/+8
2019-12-22ulist: Update "My lists" VN filters to use new ulists featureYorhel1-9/+6
2019-10-14Fix fetching of c_olang for revision pagesYorhel1-1/+1
2019-10-14Add lang HTML attribute to some original language fieldsYorhel1-1/+1
2019-10-10rewards: Apply supporters badge and unicode name (almost) everywhereYorhel1-1/+1
2019-09-13DB::VN: Return hidden staff & seiyuu in dbGetVNYorhel1-2/+2
2019-08-09Replace Wikipedia links with Wikidata IDsYorhel1-5/+4
2019-07-13Support GTIN lookup on VN searchYorhel1-2/+6
2019-07-08Add Producer/Staff/Seiyuu filters to Release/VN/Char filtersYorhel1-0/+2
2019-06-28VNBrowse: Add character filtersYorhel1-1/+7
2018-10-31VNEdit: Remove "import cast" functionalityYorhel1-13/+1
2018-01-12Don't allow unlikely short GTIN codesYorhel1-1/+1
2017-03-03Add date filters to VN searchYorhel1-1/+6
2016-09-18Suppress silly Perl 5.22 warnings about extra sprintf argsYorhel1-0/+1
2016-01-10DB::(VN|Producers): Don't decode_utf8() xml valuesYorhel1-2/+0
2015-12-30Add release filters to VN browserYorhel1-1/+9
2015-11-28VNPage: Generalize seiyuu listing to character summary listingYorhel1-12/+6
2015-11-26Handler::VNPage: Move staff tab into main VN page + some styling changesYorhel1-9/+1
2015-11-14DB::VN: Fix undeterministic ordering on tag score in VN listingsYorhel1-1/+1
2015-11-02DB::VN: Fix dbVNHasStaff() query when VN has only seiyuu and no staffYorhel1-1/+1
2015-11-01DB::(Producers|VN): Convert svg column to perl encoding when fetchingYorhel1-0/+1
2015-10-17SQL: Fix all browsing queries to use the new schemaYorhel1-110/+114
2015-10-03Handle JSON data natively when processing form dataYorhel1-2/+2
2015-10-03Rewrote screenshot uploader to support multiple files + use jsonYorhel1-1/+1
2015-02-04Add spoiler settings to /v+/staffmorkt1-1/+1
2015-02-02dbVNHasChar(): Fix bug with hidden/deleted charactersYorhel1-1/+1
2015-01-28Hide spoilerous characters from the VN staff pages by defaultYorhel1-1/+2
2015-01-28Merge branch 'staff' into masterYorhel1-1/+1
2015-01-02staff: Fix duplicate listing of seiyuu for chars with multiple releasesYorhel1-3/+3
2015-01-02staff: Fix deleting of staff + use JSON to pass data + minor fixesmorkt1-2/+2
2014-12-28staff: Import cast from other VN + some styling + more improvementsmorkt1-1/+16
2014-12-28More progress on the staff + cast DBmorkt1-2/+24
2014-12-24Further progress on the staff databasemorkt1-2/+16
2014-12-22DB: Merge name/title fetching in main fetching functionsYorhel1-12/+2
2014-12-22bbcode: Replace [vcpgi][0-9]+ links with a [url] tagmorkt1-1/+12
2014-12-22Initial implementation of a staff/seiyuu databasemorkt1-1/+17
2014-12-02Completely drop l_vnn column from VN infoYorhel1-2/+2
2014-10-13SQL: Use enum to represent platformsYorhel1-3/+3
2013-01-05Screenshot uploader: Load stuff synchronously + removed processing flagYorhel1-1/+1
2013-01-05Don't use Multi for processing screenshotsYorhel1-2/+2
2012-07-24DB::VN: Use subquery join for obtaining rlist status infoYorhel1-18/+11
2012-07-24Add wishlist / VN list status options to VN list browserSpaceRanger1-2/+23
2011-12-29Added duplicate check when adding VNsYorhel1-2/+2
2011-12-29DB::VN: Add secondary order on title when sorting by release dateYorhel1-1/+1