[Theforum] Competition proposal - votes please

Elfur Logadottir elfur at elfur.is
Fri Dec 6 14:12:20 CST 2002

<delurking duration="split-second">

From: "Madhu Menon"

| Sorry for the delay in responding. Internet access has been scarce the
| few days and I'm just catching up with stuff.

same here

| >Right. Here's the proposal, intended to balance between those who build
| >evolt.org through content, cash and general community membership.
| >
| >* We give 3 copies to authors of articles submitted in December based on
| >article rating[1].
| >* We give 3 copies to evolt.org financial donors, picked randomly from
| >those who donate in December.
| >* We give 3 copies to random members of thelist.
| >* We give 1 copy to a random member of thechat.


| (but why only articles submitted in December?)
| And how do we pick the "random" user?

i'm sure the SQL specialist (read: rudy) can give you the specifics, but
something like this:

select random 1 where articles submitted and approved dates > Nov 30 2002


More information about the theforum mailing list