User talk:Aperfectring/Random image page
I like the idea! But when I think about some of the images, there are cases where voting is just tiresome:
- Some of the pictures I have taken (and one of the two pictures I saw at my first try of your page) are blurry...
- ... or they are really really boring like this one ...
- ... also there is
and similar pictures.
While it is possible (and probable) that they will be voted down each time they show up, it will take very long for them to end up at the lower end of the list. It would speed things up if there was a "This picture really sucks, I want to give it -10 points" button. That's just my 2 cents because I'm lazy and I don't want to see the boring pictures often, I won't mind if you ignore this proposal. Yeah, ignoring is probably best. Why am I still typing? Ah, deleting this post is too much effort. I think I'll find something to occupy myself now. Bye. - Danatar 17:41, 17 February 2010 (UTC)
- Yeah, that will happen, but there are also a lot of hidden gems that people wouldn't see otherwise, my tendency is to err on the side of caution, so that we can see all the images!
- Same as point #1
- That file will be filtered out, because it is not in [[Category:Meetup in LAT LON]].
- There has been talk of adding a blacklist, but I think the best way is to just have the probability weight the choice of images based on their current rating. Unfortunately that means there will be some boring images you have to slog through, but as time goes on, it should get better and better. --aperfectring 17:51, 17 February 2010 (UTC)
Contents
Schema suggestion
`image` table
| Column name | Type |
|---|---|
| imageID | CHAR(64) |
| imageName | VARCHAR(65535) |
| votesUp | INT() UNSIGNED |
| votesDown | INT() UNSIGNED |
| isCached | BOOL |
`category` table
| Column name | Type |
|---|---|
| catID | INT() UNSIGNED |
| catName | CHAR(64) |
`wikiCatted` and `reportCatted` tables
| Column name | Type |
|---|---|
| catID | INT() UNSIGNED |
| imageID | CHAR(64) |
`wikiCatted` is emptied and repopulated on each sweep of the wiki. `reportCatted` is added to when people use the app. (Perhaps that table should have IP address and timestamp as well?)
Usage
INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table.
