OK folks...even though I said I'd not cough up the details, here's how it going to happen. I'll be spinning the virtual roulette wheel around 5:00PM PST today.
Disclaimer - nerd territory ahead.
1. Create a temporary table containing one row for each user id that has posted since Tuesday, March 1.
Note for non-nerds...1109635200 is the UNIX time stamp for Tue, 01 Mar 2005 00:00:00 GMT.
2. Run a SQL query using the MySQL random funtion to select one row from the above temporary table.
3. Take the user id generated by the above query, and manually check the user's profile to verify C-Dory information exists. If yes...we have a winner. If no, re-run step 2 until we do.
As of right now, we have 280 users who have posted since March 1. The number of eligible folks will be somewhat smaller, as not all of these members have C-Dory information in their Profile.
Good luck to all..check back in this evening!
Disclaimer - nerd territory ahead.
1. Create a temporary table containing one row for each user id that has posted since Tuesday, March 1.
Code:
SQL-query:
CREATE TABLE cbrat_raffle AS SELECT DISTINCT poster_id
FROM phpbb_posts
WHERE post_time >1109635200
Note for non-nerds...1109635200 is the UNIX time stamp for Tue, 01 Mar 2005 00:00:00 GMT.
2. Run a SQL query using the MySQL random funtion to select one row from the above temporary table.
Code:
SQL-query:
SELECT poster_id
FROM cbrat_raffle
ORDER BY RAND( )
LIMIT 1
3. Take the user id generated by the above query, and manually check the user's profile to verify C-Dory information exists. If yes...we have a winner. If no, re-run step 2 until we do.
As of right now, we have 280 users who have posted since March 1. The number of eligible folks will be somewhat smaller, as not all of these members have C-Dory information in their Profile.
Good luck to all..check back in this evening!