Difference between revisions of "User talk:Aperfectring/Random image page"

Revision as of 21:29, 17 February 2010

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)

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.

Usage

INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table.

@@ Line 9: / Line 9: @@
 :#That file will be filtered out, because it is not in <nowiki>[[Category:Meetup in LAT LON]]</nowiki>.
 :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. --[[User:Aperfectring|aperfectring]] 17:51, 17 February 2010 (UTC)
+== Schema suggestion ==
+=== `image` table ===
+{|border=1
+!Column name !! Type
+|-
+|imageID || CHAR(64)
+|-
+|imageName || VARCHAR(65535)
+|-
+|votesUp || INT() UNSIGNED
+|-
+|votesDown || INT() UNSIGNED
+|-
+|isCached || BOOL
+|}
+=== `category` table ===
+{|border=1
+!Column name !! Type
+|-
+|catID || INT() UNSIGNED
+|-
+|catName || CHAR(64)
+|}
+=== `wikiCatted` and `reportCatted` tables ===
+{|border=1
+!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.
+=== Usage ===
+INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table.