summaryrefslogtreecommitdiff
path: root/util
AgeCommit message (Collapse)AuthorFilesLines
2009-07-08Keep track of users who requested tagsYorhel2-1/+9
2009-07-04Implemented support for multilingual releasesYorhel2-4/+73
The 'language' column in releases_rev has been replaced with a releases_lang table. As this is quite a big change, there may still be bugs floating around somewhere.
2009-06-07Merge branch 'beta'2.4Yorhel2-3/+108
+ Set 2.4 date in ChangeLog
2009-05-31Batch edit releases which are likely to have a doujin or freeware flagYorhel1-0/+53
I really need to write an abstraction layer within PgSQL to make inserting new revisions using plain SQL easier.
2009-05-27Fixed typo on 404 pageYorhel1-1/+1
2009-05-23Animation fields for releasesYorhel2-1/+6
2009-05-23Added freeware and doujin information to releasesYorhel2-1/+6
TODO: - update d3 - filters on /r
2009-05-22Voiced field for releasesYorhel2-3/+5
TODO: filter on /r
2009-05-22Added resolution field to release entriesYorhel2-1/+8
TODO: - Update d3 - Add filter to /r
2009-05-09Don't consider VNs with AVG(vote) < 0 on tag pagesYorhel2-2/+35
The bayesian ranking algorithm isn't exactly meant to be used to differentiate between absolute values, so do a pre-check on AVG(vote) before considering a VN in the rating. I've also played around with using plain old averages as score, but I'd say the ordering is a lot better with the bayesian ranking, the displayed score is just slightly more confusing.
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 calculationYorhel2-68/+64
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 bugYorhel2-2/+2
2009-03-22Merge branch 'tagging' into betaYorhel3-6/+365
Conflicts: lib/VNDB/DB/Discussions.pm util/updates/update_2.3.sql
2009-03-22Incorporated update_2.3.sql into dump.sql and updated the dbgrapher scriptYorhel2-6/+176
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 entriesYorhel2-1/+7
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 entriesYorhel2-1/+6
2009-01-25Random quote featureYorhel3-1/+18
2009-01-15Moving style.css to data/Yorhel2-2/+2
2009-01-10Limit account creation to one account a day per IPYorhel2-1/+8
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-10Popularity indicator on VN pagesYorhel1-0/+3
2009-01-10Added VN popularity rankingYorhel2-1/+32
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 releasesYorhel2-2/+7
TODO: update d3 and automatically convert all 'patch' media releases in the DB to use this flag.
2009-01-02Also remove \r from skin names in vndb.plYorhel1-0/+1
2009-01-02Added possibility to hide the main title in skinsYorhel1-0/+2
Simply set the 'maintitle' to '0'
2009-01-02Another bugfix with the skin auto-update, when neither style.css nor ↵Yorhel1-3/+3
boxbg.png are generated
2009-01-02Fixed skin generator bug with \r characters in the conf fileYorhel1-0/+1
2009-01-02Improved the skin reader and updater in vndb.plYorhel1-6/+9
Less error prone, and only updates the skins that need updating and are actually writable.
2009-01-02Added custom CSS field to user profileYorhel1-0/+4
2008-12-23Fixed syntax error in dump.sqlYorhel1-2/+2
2008-12-23Added skin selector to profile pageYorhel2-0/+5
2008-12-23Read the available skins in memory at vndb.pl startupYorhel1-0/+30
Skins are automatically regenerated if necessary. This, however, requires the vndb.pl process to have write access to the skins, which is most often not the case. To do this, simply do a: chmod 777 static/s/*; chmod 666 static/s/*/{boxbg.png,style.css} (and make sure to repeat that each time a new skin is added)
2008-12-23Added simple CSS compressionYorhel1-1/+10
...by removing all newlines, whitespace and comments from the generated CSS file. None of the CSS sent to the browser is maintained by hand now, so adding some compression is easy. :-) This compression is disabled if the debug config flag is enabled, considering debugging an unreadable CSS file isn't fun.
2008-12-23Removed skin directory name from the config files, and renamed fullname to nameYorhel1-4/+5
2008-12-23A DRY appreach to skins: there's only one main CSS file nowYorhel1-197/+11
So, instead of using separate smaller CSS files to overwrite directives in the main (/static/f/style.css) file, I decided to generate one CSS file for each skin, which includes everything needed to render the page. The template for this skin is now /data/skingen/style.css. I just don't feel like maintaining two separate files when changing something to the CSS. Also converted the old layout into a skin directory (angel), since the default skin isn't in the CSS template anymore.
2008-12-23Added grey layout for testing purposes and fixed a few bugs with the skin ↵Yorhel1-2/+2
generator
2008-12-21Made the category colors on VN edit changable in CSSYorhel1-0/+5
...but not yet in the skin generator, as I haven't really decided yet whether to generate those colors based on the other colors, or to make them configurable from the skin config (= more work for the people who create the skins)
2008-12-21Basic skin generator + example skin for testingYorhel1-0/+264
How it works: Create new directory in static/s/ Create a 'conf' file (see the test skin for a template) Run skingen.pl, which will generate a style.css and boxbg.png This process will probably be automated using a simple web interface or something... There's no skin selector yet, so Util/LayoutHTML.pm has to be modified to view the generated skin.