deskthority

Code: Select all

<?php
/**
 * Draw winners for the Deskhority Awards 2015 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);

// User ids of admin, sponsors and award ceremony guest stars to be excluded from
// draws
$sponsors_and_guests = '2,55,71,78,55,394,1672,1924,2025,3533,3838,4905,6835';

// Store winners so that can only win one prize
$winners = array();

// Draw winners of <title> for polls <poll ids> with optionally <number> of
// prizes (defaults to 1).

draw_winner(
    'Store credit of £100 from the Keyboard Company',
    '12296,12308'
);

draw_winner(
    'Quick Fire Rapid SI and RGB mouse from Cooler Master',
    '12301,12305,12309',
    2
);

draw_winner(
    'Ergo Pro or a Secure Pro keyboard from Matias',
    '12304,12307'
);

draw_winner(
    'Hyper PCB, switches, Teensy and more from 7bit',
    '12298,12303'
);

draw_winner(
    'Assembled Infinity 60% keyboard from Input Club',
    '12297,12299'
);

draw_winner(
    'ErgoDox PVC and carry cases from FalbaTech',
    '12300,12302',
    3
);

/**
 * Gets contestants from db, shuffles them five times, picks random winner(s)
 *
 * Winners are drawn from voters in the given topics, excluding sponsors and
 * previously drawn winners.
 *
 * @param string $title Title of prize(s)
 * @param string $topic_ids Comma separated list of poll topics
 * @param int $nr_of_winners The numbers of winners to draw, 1 by default
 */
function draw_winner($title, $topic_ids, $nr_of_winners = 1)
{
    global $db, $sponsors_and_guests, $winners;

    // Gets all unique voters in the right topics with at least 10 posts,
    // except sponsors, earlier selected winners, admin and award ceremony
    // guest stars:
    $sql = "
        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)
        " . ($sponsors_and_guests ? " AND b.user_id NOT IN ($sponsors_and_guests)" : '') . "
        " . ($winners ? " AND b.username NOT IN ('" . implode("','", $winners) . "')" : '') . "
        AND
            b.user_posts >= 10
        ";


    $result = $db->sql_query($sql);

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

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

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

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

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

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

        $winners[] = $db->sql_escape($contestants[$winner]);
        unset($contestants[$winner]);
    }
    echo "<hr /><br /><br />\n";
}

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