path: root/util
AgeCommit message (Collapse)AuthorFilesLines
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. Fixed bug with referencing to the wrong cookie_defaultsYorhel1-2/+2
2011-02-02Log user ID in the TUWF logYorhel1-0/+10
2011-01-27TUWF: Cleanup IE check code using pre_request_handler return valueYorhel1-7/+1
No more ugly hacks in my code thanks to TUWF! (a browser check in itself is already ugly enough for my tastes...)
2011-01-27TUWF: Replaced resHeader('Set-Cookie', ..) with resCookie()Yorhel1-2/+1
Way more convenient. This also fixes several bugs with the previous commit, since the cookie_prefix wasn't used for *all* cookies. Since it is now, the 'l10n' cookie now also respects the configured prefix, which means some people will have to set their default language again. Configuration changes: 'cookie_domain' option has been removed, the 'cookie_defaults' option of TUWF should now be used.
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel2-8/+21
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2011-01-03SQL: Added tags_vn.ignore column and updated queries to respect thisYorhel3-0/+10
This is the first step in adding support for overruling tag votes by moderators. Also removed some unused options from dbTagStats(); the tag-vote-stats-by-user pages have been removed in the previous VNDB update, which was the only page using these additional options.
2011-01-02SQL: Synchronised the language ENUM with the actual DBYorhel1-1/+1
I changed the ENUM in 2.11, and apparently forgot to update the local SQL files... I'm sure there are more such issues. >_>
2011-01-02Bugfix: allow a VN to be available for more than 7 platformsYorhel2-1/+4
This constraint was caused by the character length limit on vn.c_platforms. Trying to add or edit a release in such a way that a platform would be added to c_platforms would result in a 500.
2011-01-01More infrastructural changes to accomodate for the permanent filtersYorhel2-2/+2
- Added a 'prefs' option to htmlFooter() to add preference data for use by Javascript. - Added an /xml/prefs.xml URL for setting preferences from JS. - Added 'filter_*' keys to the prefs_key ENUM - Load filters by default on VN and Release browser
2010-12-23Store l10n preference in the database for logged-in usersYorhel1-12/+32
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel4-19/+25
And renamed notify_dbedit to notify_nodbedit, since the default is to provide a notify on a database edit. Also fixed a few bugs along the way.
2010-12-23Converted the show_list pref. to users_prefs and inverted the valueYorhel2-1/+3
In the users_prefs table, the default value should evaluate to 'false' in Perl, so show_list had to be inverted to hide_list.
2010-12-23Converted the show_nsfw preference to use the users_prefs tableYorhel2-1/+3
2010-12-23Added users_prefs table and removed users.(skin|customcss)Yorhel4-3/+31
Will convert the other preferences later.
2010-12-21Added notes field to the user VN listYorhel2-1/+3
The interface to set this could be more dynamic, since it'll be a lot of work to set different notes for each VN. But oh well, let's first see how many people will use this feature.
2010-12-19SQL: Synchronised the current index definitions with schema.sqlYorhel1-0/+5
2010-12-19RFC-01: Code/DB cleanup and renamed some stuff for consistencyYorhel3-4/+6
2010-12-18RFC-01: Implemented (most) of the SQL partYorhel5-7/+106
- Created vnlists table - Converted rlists.vstat into that table - Added triggers to make sure that there is always a corresponding row in vnlists for every row in rlists. - Added a check on vnlists for the 'listdel' notify
2010-12-18JS: Fixed bug in with the generation of age_ratingsYorhel1-1/+1
Should've tested an earlier commit. wouldn't even run. >_>
2010-12-17Don't allow NULL for rr.minage and use -1 for unknownYorhel2-1/+7
This can be seen as a partial revert of 0a4f97f0186d6941a4cab2e3bd05201f1fed1441. I used to think using NULL for special values is more "correct" in database terms. But in the end I guess I should be aiming for whatever solution is easier. Both are "correct" in a sense anyway.
2010-12-14L10N: Extracted screen resolution strings from the codeYorhel1-3/+6
A somewhat ugly approach, but couldn't think of something better.
2010-12-14VNDBUtil: Consider "senpai" and "sempai" the same in the VN searchYorhel1-0/+4
2010-12-13SQL: Added index on tags_vn.dateYorhel1-0/+3
This index speeds up most of the reports generated using /g/links. I've also tested other index possibilities, but they weren't all that satisfactionary: - An index on tags_vn.uid does speed up several queries, but since these queries may not have to be very common, I'd like to have some more real-world testing before adding the index. - Sorting on VN title is slow, regardless of any indexes on vn_rev.title or tags_vn.vid (not tested one on vn.latest, which could possibly help...). I have seen a few queries that were faster with an index on tags_vn.vid, but not many and not significantly. - An index on vn_rev.tag isn't necessary, the index for the primary key on (tag,vid,uid) already takes care of that. PostgreSQL is clever enough to be able to use that multi-column index for the tag column.
2010-12-10Keep track of last modification date for tag<->vn linksYorhel2-0/+5
Currently unused, but this will be useful in the future. dbTagLinkEdit() is now a lot more complex, since the last modification date will be incorrect for unmodified tag links when we simply delete and re-insert all related links like the old function did.
2010-12-04JS: Display TL lang in its own language in TL selector dropdownYorhel1-4/+3
This is how it used to be before the JS files were split. I simply forgot to update this code to behave the same.
2010-11-28BUGFIX: Moved update_vncache() to the bottom of the update script2.14Yorhel1-4/+4
Otherwise it'd send out a lot of "entry has been deleted" notifications. >.>
2010-11-28ChangeLog update for 2.14 + some minor upgrade fixesYorhel1-1/+4