deskthority

Code: Select all

<?php
//
// Draws winners for the Deskhority Awards 2013 Voter Prizes
//

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

draw_winner('Mystery Prize from 7bit', '6986,6988');
draw_winner('Ducky, SkiData or Realforce from 002', '6987,6992');
draw_winner('Shine Special from Ducky Nordic', '6989,6991');
draw_winner('Keyboard cable from Pexon PCs', '6984,6994');
draw_winner('Keycap sets from Signature Plastics', '6983,6990', 4);
draw_winner('Minila from The Keyboard Company', '6985,6993,6995');

//
// Gets contestants from db, shuffles them five times, picks random winner
//
function draw_winner($title, $topic_ids, $nr_of_winners = 1)
{
    global $db;

    // Gets all unique voters in the right topics with at least 10 posts,
    // except admin and award ceremony guest stars:
    $result = $db->sql_query("
        SELECT
            distinct(b.username)
        FROM
            phpbb_poll_votes a
        LEFT JOIN
            phpbb_users b
        ON
            a.vote_user_id = b.user_id
        WHERE
            a.topic_id in ($topic_ids)
        AND
            b.user_posts >= 10
        AND
            b.group_id <= 4
        AND
            b.user_id <> 55
        ");

    $contestants = array();
    while ($row = $db->sql_fetchrow($result)) {
        $contestants[] = $row['username'];
    }

    $drawn = 0;
    while ($drawn < $nr_of_winners) {
        $drawn++;
        echo "Deskthority Awards 2013 - $title Prize Winner"
            . ($nr_of_winners < 2 ? '' : ' ' . $drawn) . "!<br />\n<br />\n";

        show_contestants(count($contestants) . ' contestants: ', $contestants);

        for ($i = 5; $i--; ) {
            shuffle($contestants);
            show_contestants("<br />\nShuffling... ", $contestants);
        }

        $winner = mt_rand(0, count($contestants) - 1);

        echo "<br />\nDrawing random winner: " . $contestants[$winner]
            . "<br />\n<br />\nCongratulations!<br /><br /><br />\n";

        unset($contestants[$winner]);
    }
}

function show_contestants($title, &$contestants)
{
    echo $title . implode(', ', $contestants) . "<br />\n";
}
?>