RESULTS: Most Anticipated MMOG of 2013

Thanks for your vote!

Voting will close on Sunday, January 6th, and we'll announce our results on Monday, January 7th. You may return once per hour to help your game rise to the top. Rally your friends and champion the cause!

function _most_anticipated_print_results($cid) {
$nid = 246999;

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 "

" . $name . "

";
}
echo "

";
}

echo "Top Three Results:
";
_most_anticipated_print_results(2);
?>