summaryrefslogtreecommitdiff
path: root/lib/VNDB
AgeCommit message (Collapse)AuthorFilesLines
2009-10-29Handler::Users: Fixed password recovery email sending bugYorhel1-1/+1
dbUserGet() doesn't return the email address by default anymore.
2009-10-25Handler::Producers: Fixed perl warning on adding new producerYorhel1-7/+5
2009-10-25dbRevisionGet: Fixed 500 when using the 'Include edits of releases' optionYorhel1-1/+1
2009-10-24Merge branch 'beta'2.8Yorhel22-303/+868
+ ChangeLog update
2009-10-24Discussions: Don't allow bots to index user discussion indexesYorhel1-1/+1
2009-10-22TransAdmin: Added simple doc page translation interfaceYorhel1-24/+117
2009-10-22d+: Wrote more extensive credits page and moved link icons to the FAQYorhel1-0/+6
2009-10-22TransAdmin: Added intro pageYorhel1-0/+15
2009-10-22TransAdmin: Fixed comment about how to use itYorhel1-4/+6
So that it will only be loaded in the scripts where it is used. This is still a rather ugly solution, though.
2009-10-22Wrote a quick and dirty translation editor pluginYorhel1-0/+239
See Plugin::TransAdmin for details. I wrote it as a plugin so that it can make use of the framework and functions of the main VNDB website code, but that it doesn't have to confirm to the rest of the code or have to be loaded into memory when unused.
2009-10-21Added relation graphs for producersYorhel4-35/+66
TODO: - document the relations - emit a relgraph notify when needed
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-1/+1
As the same table can easily be used to store producer relation graphs as well.
2009-10-21Handler::Tags: Increased tag dropdown search results to 15Yorhel1-1/+1
2009-10-21Wrote producer relation editor interfaceYorhel1-2/+28
Again, mostly copied from the VN relation editor...
2009-10-21Display producer relations on producer pagesYorhel1-0/+17
2009-10-21Display producer relations in revision browserYorhel1-3/+9
And again copied something from the VN relation code... meh.
2009-10-21Started on the producer relationsYorhel2-16/+92
The current list of relations isn't final yet, may be changed later on. Quite a bit of this code has been copied from the VN relations... need to find a way to use prober code reuse here. TODO: - Nice relation editor interface - Display relations in revision browser - Display relations on producer pages - Generate relation graphs - Sync update_2.8.sql into dump.sql
2009-10-21L10N-HU: Added code for Hungarian TL and minor code cleanupYorhel1-13/+22
2009-10-19L10N-CS: Added Czech quant()Yorhel1-1/+18
2009-10-19Use 'no spoilers' as default spoiler level for tagsYorhel3-5/+5
2009-10-18Handler::Misc: Fixed bug with unhiding a producer entryYorhel1-1/+1
I could swear I'd found and fixed a similar bug in the past...
2009-10-17SQL: Converted releases_rev.type to an ENUM data typeYorhel1-3/+3
2009-10-17Handler::ULists: Add secundary order by title when ordered by voteYorhel1-1/+1
This fixes a strange issue that the ordering changes when browsing to the next page, resulting in some VNs not showing up at all.
2009-10-12htmlSearchBox: Copy over search query when switching search typeYorhel1-5/+12
<@EchoMateria> for example I searched for 'Maika' in Visual Novels <@EchoMateria> then remembered that it was a producer not a game and clicked Producers instead <@EchoMateria> can you set it so that entry in the search field would stay and it would search for it in the producers instead?
2009-10-12SQL: Converted changes.type to an ENUMYorhel6-24/+22
This is a very important column in a very important table, I hope I didn't forget to update a piece of code somewhere...
2009-10-10List all known languages on /r and /v/all instead of only those in useYorhel3-17/+3
Performance improvement of ~15ms for all release and VN browse pages. There are in total 20 known languages in the DB, and 12 of them are actually used (i.e. a release in that language exists). Which means 8 of the listed language filters won't produce any results (yet), but I'd say that's an accaptable trade-off.
2009-10-10Greatly reduced default number of columns returned by dbUserGetYorhel3-6/+10
Most of the columns are only used in some rare situations, so fetching all that information is unecessary. To fetch this information, a what => 'extended' is now required. This change should be most noticable for the user list (now less than half of the previous data is fetched from the database).
2009-10-10Get unread posts count in htmlHeader() instead of Util::AuthYorhel3-13/+20
This way the counter resets itself immediately when opening the unread thread page, which is more intuitive.
2009-10-10Make "My Messages (n)" stand out when n>0Yorhel1-1/+1
Not very obstructive now that number will automatically reset itself after opening the threads.
2009-10-10Display number of unread posts in user menuYorhel3-2/+23
Instead of displaying the total number of threads. Posts are marked as read when the thread is opened.
2009-10-10Updated Producer and VN pages with developer/publisher informationYorhel3-16/+34
2009-10-09Handler::Releases: Display producer role on release pagesYorhel1-11/+16
Still the VN & producer pages to go...
2009-10-09Added producer role (developer/publisher) to DB and release editorYorhel2-11/+19
They aren't displayed on the site yet, though.
2009-10-09Handler::Releases: Fixed display of media in filtersYorhel1-1/+1
2009-10-09SQL: Converted releases_media.medium to an ENUM typeYorhel1-1/+1
2009-10-07Changed language selector into a Javascript dropdownYorhel1-6/+2
2009-10-07L10N: Extracted last bits of JavascriptYorhel1-2/+2
2009-10-07L10N: Extracted VN screenshot uploaderYorhel1-2/+1
2009-10-07L10N: Extracted release media and the media selectorYorhel1-12/+6
2009-10-07L10N: Extracted VN relation editorYorhel1-4/+3
2009-10-07L10N: Extracted release list statusesYorhel3-13/+13
Should be converted to enums at some point... integers don't do the trick here.
2009-10-07L10N: Extracted some common Javascript stringsYorhel2-2/+2
2009-10-07L10N: Generalized age() for all languages by using maketext() internallyYorhel1-19/+4
This way the translators can TL/improve their own translation of the age display, instead of asking me to fix it.
2009-10-05JS: Moved, split and rewrote release <-> VN & producer linkingYorhel5-15/+11
+ removed last traces of forms.js + converted code to use tables, as that is easier to expand more accurate for this purpose. The reason I probably didn't use tables before was that the innerHTML property doesn't work on tr elements. The split was mainly because the producer linking is going to be expanded with an additional field later on.
2009-10-05JS: Moved, rewrote and improved VN tag linkingYorhel1-16/+17
- You can now click the spoiler column to scroll through the options - Or mouse-over the spoiler column to see a JS dropdown with the options (no more select box, which introduces several more clicks to do the same)
2009-10-04JS: Moved and rewrote VN relations editorYorhel1-10/+10
+ Some fixes and improvements in the dropdown search + Renamed 'relations' field to 'vnrelations', as other relations are going to be implemented as well New relation editor code is somewhat smaller than the old, mostly thanks to the tag() function. Also tried to make things less error-prone and easier to maintain by referencing things using self-explainable class names instead of the ordering of the HTML tags.
2009-10-03JS: Rewrote and generalized row group expand codeYorhel4-8/+8
2009-10-03JS: Updated and generalized list expand/collapse functionsYorhel2-4/+4
2009-10-03JS: Rewrote VN tagspoil & JS tabs and merged addClass and removeClassYorhel1-0/+1
2009-10-02JS: Rewrote release list dropdownYorhel1-1/+1
Abstacted a simple set of reusable functions for generating dropdown lists, as I'm likely going to need that more often.