Age | Commit message (Collapse) | Author | Files | Lines |
|
Use a user's highest vote on a child tag in the calculation of the
rating of a parent, rather than the average.
|
|
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.
|
|
|
|
Conflicts:
lib/VNDB/DB/Discussions.pm
util/updates/update_2.3.sql
|
|
Which is a more accurate description, and doesn't confuse with the
tagging system.
Note than even all internal uses of the word 'tag' have been replaced,
as I'm not a huge fan of different terminology in the code and UI. This
update might break some things related to the discussion board.
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
...taking into account the votes on child tags and one user
voting on multiple child tags.
Doing this realtime is slow... very slow. Tried playing around
with storing the ratings in a normal table for caching, but don't
have enough data to do proper benchmarks and determine the fastest
method yet.
|
|
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
|
|
|
|
|
|
This would at least annoy the people who'll try to manipulate
the rankings, and will make finding duplicate users a bit easier.
(Not that it's really a problem at the moment)
|
|
The following query should be run periodically to update the rankings:
SELECT update_vnpopularity();
I'll fix Multi::Maintenance to do this automatically.
|
|
|
|
TODO: update d3 and automatically convert all 'patch' media releases
in the DB to use this flag.
|
|
|
|
|
|
YAWF's formValidate() automatically removes them from all input, which
could result in a few unexpected changes when editing a v/r/p entry.
|
|
|
|
discussion board
|
|
Because I can't say no to a performance increase of 4 to 7ms
for -every- pageview!
Makes use of postgresql triggers and stored procedures.
|
|
|
|
I wasn't planning on really touching the database in the rewrite,
but oh well, I've always wanted to do this, anyway.
|
|
And added triggers to keep these up to date, and made it possible
to sort on the change and vote count on the userlist
|
|
git-svn-id: svn://vndb.org/vndb@114 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@103 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@101 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
smallint, and added (yet another) foreign key constraint to the threads table
git-svn-id: svn://vndb.org/vndb@100 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
properly references changes.id
git-svn-id: svn://vndb.org/vndb@99 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
/data/rg/
git-svn-id: svn://vndb.org/vndb@93 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
boolean type.
git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
for determining when a thumbnail has been generated after uploading a screenshot, and got rid of the javascript image preloader
git-svn-id: svn://vndb.org/vndb@84 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
polishing)
git-svn-id: svn://vndb.org/vndb@83 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@77 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
- Added noindex tag to iid-ttag browser
- Replaced last poster with age of last post on home page
- Merged user vote lists into new vnlist
- Removed 'hide votes' feature
- Fixed users+1 stats bug
- Fixed FF3 JS hack
- Old VNList code is still present, need to decide what to do with that
git-svn-id: svn://vndb.org/vndb@74 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
user, removed the /u+/pending URL, and small bugfix in dump.sql
git-svn-id: svn://vndb.org/vndb@69 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
hide DB entries
git-svn-id: svn://vndb.org/vndb@60 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@55 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
the way
git-svn-id: svn://vndb.org/vndb@54 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@49 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
git-svn-id: svn://vndb.org/vndb@32 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
notes field to the new GTIN field
git-svn-id: svn://vndb.org/vndb@31 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|
|
small bugfix in the VNDBID pattern matching
git-svn-id: svn://vndb.org/vndb@28 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
|