| Age | Commit message (Collapse) | Author | Files | Lines |
|---|
|
With the new TUWF, kv_validate() returns undef when the param isn't
present and an empty string if it is, but left empty. This is a more
efficient way to differentiate between empty and nonexistent than the
previous YAWF-method of grepping all param names.
|
|
|
|
Haven't found any bugs this way, yet. I doubt there'll be any problems,
but it's a nice new feature that could help quite a bit. :-D
|
|
|
|
Configuration change: Make sure you more the cookie_prefix option from
%S to %O. (It's now a TUWF option rather than a VNDB one)
|
|
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.
|
|
|
|
|
|
- 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
|
|
This will correctly handle fetching stuff from the database when
permanent filters are enabled.
This update also removes compatibility with some old VN browse URLs. The
old 'ti' and 'te' (tag include/exclude) query parameters are now
ignored, and searching for a language in the query string (e.g.
"q=English") won't enable the language filter.
|
|
This makes the UI slightly uglier and less intuitive. I'll see if I can
find a way around that. This update is required for the permanent
browsing filters to be fast and reliable.
|
|
This caused the search to break when no language filters were set.
|
|
The original language is the language of the first release of the VN,
and is cached in vn.c_olang. (Geez, the vn table has more caching
columns than actual information >.>)
|
|
|
|
Also requested several times before.
|
|
Has been requested quite often, now finally implemented.
|
|
Had to fix some bugs here and there and add some new functionality to
the abstractions at some places, but it appears to be working now. There
are still a few TODOs left, I'll get to those in a bit.
|
|
This replaces the "cookie_auth" setting, and applies to all cookies in
use by VNDB.
|
|
|
|
The ORDER BY was previously specified using an 'order' argument, which
would then be directly inserted into the query. The new method is the
same as what I used for the public API: two 'sort' and 'reverse'
arguments. This should be less error-prone and more readable.
This changes quite a lot of code, so I hope I haven't forgotten to
update something along the way.
|
|
With this method I managed to reuse the VN list table code for the lists
on both the VN browser and the tag pages. And optimized away the
dbTagVNs() function while I was at it (dbVNGet() is powerful enough)
|
|
Sorting from least to most popular VN make sense now, you won't have to
wade through those entries without any vote at all.
|
|
Was a good idea after all...
|
|
It's even realtime! To my surprise this calculation isn't very heavy, or
PostgreSQL is just extremely fast. The GetVN query on /v/all takes 100ms
in the worst case (instead of the usual 30-60ms). Can always cache this
later on.
|
|
|
|
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.
|
|
+ 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.
|
|
|
|
Interface consistency.
|
|
|
|
and age()
|
|
|
|
User ranks are easy... but the language names are used everywhere!
|
|
|
|
|
|
|
|
|
|
TODO:
- spoiler settings?
- auto-complete tag names
- exclude filter
- Improved UI? current location isn't very intuitive
- Improve previous tag browser to make use of the VN search?
|
|
Because many people still link to things like /v/all?q=English. Platform
searches are less common, so I doubt many people care about URL
compatibility for that,
|
|
It was a rather stupid and buggy idea...
|
|
|
|
This should make a nice connection between the few kinds of database
entries we have.
|
|
The tags work fine already. I'll keep the categories on the VN pages
and in the history for now, though.
|
|
|
|
|
|
The following query should be run periodically to update the rankings:
SELECT update_vnpopularity();
I'll fix Multi::Maintenance to do this automatically.
|
|
With two exceptions:
- Empty browse tables (/u1/list, /u3/hist, ..)
- Empty <tbody> on /v+/edit and /v/new
I'm not purist enough to work around those bugs. (well, maybe I'll fix the
empty browse table thing, as it's not really user friendly either)
|
|
|
|
Three-box-layout didn't work very well together with the screenshots
on the homepage and the CSS icon hack needed a to get rid of
a strange top margin.
With this, the following browsers should render all pages correctly:
FF2, FF3 and the latest Opera, Safari and Chrome
|
|
These changes are all pretty much related, so couldn't really do
that in multiple commits.
|
