Age | Commit message (Collapse) | Author | Files | Lines |
|
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.
|
|
Still need to add some links to the browser to parts of the site.
|
|
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.
|
|
|
|
It should work perfectly now...
|
|
The return value of dbTagTree() is also somewhat easier to work with.
|
|
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)
|
|
For three reasons:
- Speed
tag_vn_calc() is now more than 10 times faster (granted, it could
have been a lot faster even with the bayesian rating, but whatever)
- Consistency with the tag scores displayed on the VN pages (which are
raw averages as well)
- It didn't always make sense
|
|
Ideally, all tag relations should be removed when hiding a VN, but that
would make hiding a destructive action, while currently it can still be
reverted easilily.
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
There's no need for that anymore with the merge and state options
|
|
|
|
|
|
|
|
|
|
|
|
Couldn't think of anything more useful to display than simply all
tags without parents and a few of their subtags.
|
|
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.
|
|
|
|
|
|
Just prototyping, current implementation is too slow for actual use.
|
|
|
|
(interface is somewhat on the half-hearted side, but oh well)
|
|
And a "Don't forget to submit" text, and various important bugfixes,
and... geez, time for a coke with some cookies!
|
|
The usual: it's still pretty much useless and unfinished, will polish
up things later.
|
|
Consistent with all other aliases field
|
|
But it already starts to look like something that might work.
|
|
|
|
|
|
|
|
Mostly playing around with the possibilities,
tag page layout & database scheme are far from final
|