summaryrefslogtreecommitdiff
path: root/util
AgeCommit message (Collapse)AuthorFilesLines
2013-01-05Don't use Multi for processing screenshotsYorhel3-9/+3
TODO: Get rid of the 'processing' flag and all the async loading of screenshot data in the screenshot uploader.
2013-01-05Don't use Multi for processing character imagesYorhel3-9/+3
2013-01-05Don't use Multi for processing VN cover imagesYorhel3-8/+6
I used to do this to avoid loading Image::Magick in each TUWF process, decreasing memory usage, and lowering the blocking time by avoiding too much processing. Memory isn't much of a problem nowadays, and processing images is fast enough, too, so this complexity isn't necessary anymore. (Character images and screenshots pending)
2012-07-24Add wishlist / VN list status options to VN list browserSpaceRanger2-1/+7
2012-06-05schema.sql: Fix order of some columns + remove useless DEFAULT NULLYorhel1-4/+4
The ordering unfortunately matters for some tables, due to the edit_* stored procedures relying on it. :-(
2012-06-04all.sql: Fix creation of the deleted and multi accountsYorhel1-2/+2
2012-06-04schema.sql: Fix creation of anime tableYorhel1-2/+2
2012-03-27Added Indonesian languageYorhel2-3/+3
2012-01-10Allow one fractional digit for VN votesYorhel1-0/+15
The interface to set a non-integer vote isn't very nice, but at least it works. Or so I hope.
2012-01-09Added language for UkrainianYorhel2-1/+34
And added an update_2.23.sql file which now also includes the previously added indices. Currently, this update file can be run as often as you want, it doesn't make any noticable changes when you run it on a database that has already been updated. (i.e. I can update the main site without a new release)
2012-01-07SQL: Added two indicesYorhel1-0/+2
This brings the average page generation time for VN pages down from ~170ms to ~90ms (when measured over a period of a few hours). I haven't put this in an update script, if you want to take advantage of these indices make sure to manually add them yourself.
2011-12-31Merge branch 'beta'2.22Yorhel4-11/+20
Conflicts: data/lang.txt
2011-12-29Maintain VN search cache for hidden entries as wellYorhel3-11/+17
Required in order to search for hidden entries (obviously :P)
2011-10-24Added 'role' filter to character browserYorhel1-0/+1
2011-09-21doc: Added German translator to credits + fixed minor bug in lang.plYorhel1-0/+1
2011-08-30Changed size/weight character filters to javascript slidersQCyph1-5/+0
2011-08-27Added filters to character browse page and trait pageQCyph1-0/+7
2011-08-23Added email confirmation to registration processYorhel2-1/+11
2011-08-22Removed support for pre-2.6 passwordsYorhel1-0/+4
Users who haven't logged in since 2009-08-09 will find that their passwords have been reset. They need to use the password recovery feature before logging in again.
2011-08-21Added 1280x960 screen resolutionYorhel1-0/+4
2011-05-01Bugfix in update_stats_cache() resulting in a 500Yorhel1-1/+1
2011-04-30Replaced user ranks with a permission systemYorhel2-1/+14
This is far more flexible.
2011-04-30Bugfix: Don't allow unicode numbers as 'int' in formValidateYorhel1-1/+1
Stuff like "168" went through earlier, but couldn't be interpreted by either perl or postgresql.
2011-04-29affiliates: +data column, hide hidden links, better browser, Multi fixesYorhel2-6/+4
2011-04-09affiliates: Added simple admin interface + default_prioYorhel1-0/+1
The lastfetch/price columns can't be modified at the moment.
2011-04-09affiliates: Added very basic support for sponsored "buy now" linksYorhel2-0/+34
2011-04-08Added char/tag/trait stats to database statistics boxYorhel3-3/+35
2011-04-08Generate dbedit/dbdel notifications on character editsYorhel3-17/+36
2011-03-20chardb: Fixed no-change-edit-bug + test data insertion errorYorhel1-4/+4
2011-03-19chardb: Synchronized DB changes with util/sql/* and dbgraph.plYorhel4-5/+105
2011-03-15chardb: Added list of instances to char pagesYorhel1-1/+12
2011-03-15chardb: Added main char field + editingYorhel2-3/+3
The field isn't used yet.
2011-03-14chardb: Added Char<->VN linking edit interfaceYorhel1-0/+1
Still somewhat quircky, but it works.
2011-02-27chardb: Allow specifying the order of trait groups +'sexual' trait flagYorhel1-0/+2
The sexual flag isn't used yet.
2011-02-22chardb: +char<->vn linking, +vn display on char pagesYorhel2-5/+10
2011-02-22chardb: +image quality, -other blood type, typo fix, +gender iconsYorhel2-6/+6
2011-02-21chardb: gender field + blood type/gender field compacting on char pageYorhel2-7/+41
2011-02-21chardb: char-by-trait lookup + trait usage count + tag-code sharingYorhel2-2/+48
I'll have to optimize the updating of traits_chars as soon as I have some data to test with. Also renamed tags.c_vns to c_items, to have it share the same name as traits.c_items. This makes it a lot easier to re-use code for both tags and traits, such as what I did with dbTagTree/dbTraitTree -> dbTTTree and the childtags() and parenttags() functions.
2011-02-20chardb: Added "group" property to traitsYorhel2-16/+24
It's more like a cache, and has some unintuitive problems when a trait is applied to multiple top-level traits. But this'll do the trick anyway.
2011-02-19chardb: Removed unique constraints from traits and traits_aliasesYorhel1-11/+48
This makes things somewhat simpler.
2011-02-19chardb: Added blood type + misc. fixes and improvementsYorhel2-5/+8
2011-02-18chardb: Implemented BWH/height/weight fieldsYorhel1-4/+2
2011-02-16chardb: Added image to character entriesYorhel2-0/+10
2011-02-16chardb: Added character add/edit form + misc. fixesYorhel2-5/+7
2011-02-15chardb: Added char entry tables and updated the basic revision frameworkYorhel2-1/+113
The Perl code and SQL-revisioning code only handles the name, original, alias and desc fields at the moment. There is a basic /i+ and /i+.+ page for testing, which should have all the functionality required for the revisioning framework.
2011-02-14chardb: Made Multi aware of traitsYorhel2-1/+8
Added new trait notify and i+ id-matching
2011-02-13chardb: Added notes file and started implementing the traitsYorhel2-1/+27
2011-02-07Bugfix: don't generate listdel notify for the user who deletedYorhel2-1/+5
2011-02-04Added category field to tags (content/ero/technical)Yorhel3-1/+8
Not very useful at the moment, but will be used to improve several other things.
2011-02-04jsgen.pl: Fixed bug with referencing to the wrong cookie_defaultsYorhel1-2/+2