<?<br /> require ("./main.inc.php");<br /><br /> $query = "SELECT b.B_PosterId,u.U_Totalposts,u.U_Number,u.U_Username FROM w3t_Posts b<br /> LEFT JOIN w3t_Users u ON u.U_Number=b.B_PosterId<br /> WHERE MONTH(FROM_UNIXTIME(b.B_Posted))=8 AND u.U_Status != 'Banned' AND u.U_Extra2 = ''<br /> AND MONTH(FROM_UNIXTIME(u.U_Registered)) < 8 AND MONTH(FROM_UNIXTIME(u.U_LastOn)) > 7";<br /> $sth = $dbh -> do_query($query);<br /><br /> $totalusers = $dbh -> total_rows($sth);<br /> <br /> print "<body><font size=\"1\" face=\"MS Sans Serif, Geneva\">";<br /> print "There were " . number_format($totalusers) . " total posts made during July<br>";<br /> $entries=array();<br /> <br /> for( $x=0; $x < $totalusers; $x++ ) {<br /> list ($PosterId,$totalposts,$number,$username) = $dbh -> fetch_array($sth);<br /> // Excluded members are me and Administrator<br /> if ( $PosterId != 2 && $PosterId != 3 && $totalposts > 75 ) $entries[$PosterId] = $username;<br /> }<br /> <br /> print "The number of members eligable for this drawing is: " . count($entries) . "<br><br>";<br /><br /> $winners = array(); <br /> for ( $x = 1; $x < 11; $x++ ) {<br /> $winner = array_rand($entries);<br /> if ( in_array($winner, $winners) ) {<br /> $x--;<br /> }<br /> else {<br /> print "Pick #$x: <font size=\"5\"><b>" . $entries[$winner] . "</b></font><br />";<br /> $winners[] = $winner;<br /> }<br /> }<br /> <br /> print "</font></body>";<br />?>