summaryrefslogtreecommitdiff
path: root/util/updates
AgeCommit message (Collapse)AuthorFilesLines
2009-03-30Tiny bugfix in the tag<->vn calculationYorhel1-1/+1
Use a user's highest vote on a child tag in the calculation of the rating of a parent, rather than the average.
2009-03-28Fixed and re-organized tag<->vn calculationYorhel1-31/+31
Fixed major performance bug caused by referencing the wrong table, moved all intermediate views to tag_vn_calc() as temporary views (similar to update_vnpopularity()) and renamed tags_vn_stored to tags_vn_bayesian.
2009-03-22Fixed tiny SQL bugYorhel1-1/+1
2009-03-22Merge branch 'tagging' into betaYorhel1-0/+189
Conflicts: lib/VNDB/DB/Discussions.pm util/updates/update_2.3.sql
2009-03-21Replacing all occurences of 'discussion tags' with 'discussion boards'Yorhel1-0/+5
Which is a more accurate description, and doesn't confuse with the tagging system. Note than even all internal uses of the word 'tag' have been replaced, as I'm not a huge fan of different terminology in the code and UI. This update might break some things related to the discussion board.
2009-03-14Separated table for tag aliases + proper checking of unique aliases and namesYorhel1-1/+5
2009-03-14Added tag states for pending/deleted/acceptedYorhel1-13/+7
2009-03-08Added caching of tags_vn_bayesian and the VN count for tagsYorhel1-16/+20
Updated hourly by Multi. May want to look for a better way to update this cache, because I'm afraid the current tags_vn_calc() is going to perform very badly on larger databases.
2009-03-08Tag stats on user pages and listYorhel1-0/+32
2009-03-07Hiding spoilers on tag pagesYorhel1-1/+1
2009-03-07Adding list of VNs to tag pagesYorhel1-1/+1
2009-03-01Wrote some SQL magic to fetch a list of VNs related to a tagYorhel1-0/+63
...taking into account the votes on child tags and one user voting on multiple child tags. Doing this realtime is slow... very slow. Tried playing around with storing the ratings in a normal table for caching, but don't have enough data to do proper benchmarks and determine the fastest method yet.
2009-02-22Renaming tags.aliases to tags.aliasYorhel1-1/+1
Consistent with all other aliases field
2009-02-22Very basic, unfinished and non-working interface for VN/tag linkingYorhel1-2/+2
But it already starts to look like something that might work.
2009-02-21Aliases field to producer entriesYorhel1-0/+5
2009-02-14Made a start on the tagging systemYorhel1-0/+89
Mostly playing around with the possibilities, tag page layout & database scheme are far from final
2009-02-12Catalog number field to release entriesYorhel1-0/+4
2009-01-25Random quote featureYorhel1-0/+7
2009-01-10Limit account creation to one account a day per IPYorhel1-0/+6
This would at least annoy the people who'll try to manipulate the rankings, and will make finding duplicate users a bit easier. (Not that it's really a problem at the moment)
2009-01-10Added VN popularity rankingYorhel1-0/+18
The following query should be run periodically to update the rankings: SELECT update_vnpopularity(); I'll fix Multi::Maintenance to do this automatically.
2009-01-10Convert all existing patch media in the DB to the new patch flagYorhel1-0/+5
2009-01-04Added patch flag to releasesYorhel1-0/+3
TODO: update d3 and automatically convert all 'patch' media releases in the DB to use this flag.
2009-01-02Added custom CSS field to user profileYorhel1-0/+4
2008-12-23Added skin selector to profile pageYorhel1-0/+4
2008-12-14Getting rid of all leading and trailing whitespace and newlines in the DBYorhel1-7/+7
YAWF's formValidate() automatically removes them from all input, which could result in a few unexpected changes when editing a v/r/p entry.
2008-12-112 Bugfixes with user registrationYorhel1-0/+1
2008-12-07Added extra user rank for people who can't edit but can post on the ↵Yorhel1-0/+5
discussion board
2008-11-29Caching the global database statisticsYorhel1-0/+58
Because I can't say no to a performance increase of 4 to 7ms for -every- pageview! Makes use of postgresql triggers and stored procedures.
2008-11-22Getting rid of \r altogetherYorhel1-0/+16
2008-11-11Removed users.flags and used two boolean columns insteadYorhel1-0/+14
I wasn't planning on really touching the database in the rewrite, but oh well, I've always wanted to do this, anyway.
2008-11-11Cached each users change and vote counts in the users tableYorhel1-0/+46
And added triggers to keep these up to date, and made it possible to sort on the change and vote count on the userlist
2008-10-18Forgot to upload update_1.23.sqlyorhel1-0/+3
git-svn-id: svn://vndb.org/vndb@114 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-27Added release link to screenshotsyorhel1-0/+5
git-svn-id: svn://vndb.org/vndb@103 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Converted relation graphs to PNGyorhel3-31/+18
git-svn-id: svn://vndb.org/vndb@101 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Fixed error when creating a new thread, changed type of threads_posts.num to ↵yorhel1-0/+6
smallint, and added (yet another) foreign key constraint to the threads table git-svn-id: svn://vndb.org/vndb@100 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Another internal database change: changes.causedby accepts NULL values and ↵yorhel1-0/+10
properly references changes.id git-svn-id: svn://vndb.org/vndb@99 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Stored relgraph image maps in the DB, instead of using plain text files in ↵yorhel2-0/+42
/data/rg/ git-svn-id: svn://vndb.org/vndb@93 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Converted smallints used as boolean to PostgreSQL's relatively new (8.1) ↵1.21yorhel1-0/+97
boolean type. git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots table to store the dimensions of all images, moved to AJAX ↵yorhel1-4/+8
for determining when a thumbnail has been generated after uploading a screenshot, and got rid of the javascript image preloader git-svn-id: svn://vndb.org/vndb@84 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots (not entirely finished, still needs some tweaking and ↵yorhel2-0/+27
polishing) git-svn-id: svn://vndb.org/vndb@83 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-01Added wishlist feature and re-added "my profile" link to user menuyorhel1-0/+19
git-svn-id: svn://vndb.org/vndb@77 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-29- Added release list featureyorhel1-0/+13
- Added noindex tag to iid-ttag browser - Replaced last poster with age of last post on home page - Merged user vote lists into new vnlist - Removed 'hide votes' feature - Fixed users+1 stats bug - Fixed FF3 JS hack - Old VNList code is still present, need to decide what to do with that git-svn-id: svn://vndb.org/vndb@74 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-16Accounts can be deleted, home page now shows age of last post instead of ↵yorhel1-0/+4
user, removed the /u+/pending URL, and small bugfix in dump.sql git-svn-id: svn://vndb.org/vndb@69 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Added primary key to threads_tags, added documentation, and mods can now ↵yorhel1-1/+2
hide DB entries git-svn-id: svn://vndb.org/vndb@60 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Removed the rating system and small cleanup on the homepageyorhel1-0/+6
git-svn-id: svn://vndb.org/vndb@55 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Wrote an integrated messageboard, and fixed a few (very) small things along ↵yorhel1-0/+28
the way git-svn-id: svn://vndb.org/vndb@54 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-30HTML Fix + forgot to upload update_1.18.sql with the previous commit -.-yorhel1-0/+31
git-svn-id: svn://vndb.org/vndb@49 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-21Time and Place categories are now boolean, and small vnpage cleanupyorhel1-0/+7
git-svn-id: svn://vndb.org/vndb@32 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-21Set beta version to "svn" and uploaded a script to move JAN codes from the ↵yorhel1-0/+82
notes field to the new GTIN field git-svn-id: svn://vndb.org/vndb@31 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-15Permenantly removed the CISV link, added links to renai.us and encubed, and ↵yorhel1-0/+5
small bugfix in the VNDBID pattern matching git-svn-id: svn://vndb.org/vndb@28 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b