Thanks for your vote!

Thanks for casting your vote! We'll announce the winners of our Favorite Diablo III Class Poll next week. Meanwhile, keep an eye on Ten Ton Hammer to see who's winning, and don't forget to tell your friends to cast their votes, too. You can vote up to once per day to keep your favorite class in the lead!

function _favorite_class_print_results($cid) {
$nid = 231247;

echo "

    ";
    $name_sql = "SELECT extra FROM webform_component " .
    "WHERE nid = %d AND cid = %d";
    $name_result = db_fetch_object(db_query($name_sql, $nid, $cid));
    $name_data = unserialize($name_result->extra);
    $name_data = $name_data['items'];
    $name_data = explode("\n", $name_data);
    $names = array();
    foreach ($name_data as $name) {
    $names[substr($name, 0, strpos($name, '|'))] = substr($name, strpos($name, '|')+1);
    }

    $sql = "SELECT data, COUNT(data) AS count " .
    "FROM webform_submitted_data " .
    "WHERE nid = %d AND cid = %d AND data != ''" .
    "GROUP BY data " .
    "ORDER BY count DESC " .
    "LIMIT 3";
    $results = db_query($sql, $nid, $cid);
    while ($result = db_fetch_object($results)) {
    $name = isset($names[$result->data]) ? $names[$result->data] : $result->data;
    echo "

  1. " . $name . "
  2. ";
    }
    echo "

";
}

echo "Top Three Results:
";
_favorite_class_print_results(1);
?>

Last Updated: Mar 13, 2016

Comments