Reply to thread

Message

<blockquote data-quote="Michael Morris" data-source="post: 2408191" data-attributes="member: 87">For those capacle of reading it - here's the (tenatively) final code that does the counting.[php]function calculate_winner($category){&nbsp; &nbsp; global $DB_site;&nbsp; &nbsp; // Initialize internal arrays&nbsp; &nbsp; $votes = array();&nbsp; &nbsp; $drop_list = array(0 =&gt; 0);&nbsp; &nbsp; // Get the votes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getvotes = $DB_site-&gt;query(&quot;SELECT $category FROM ennies&quot;);&nbsp; &nbsp; // Build the votes array&nbsp; &nbsp; while ($getvote = $DB_site-&gt;fetch_array($getvotes))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $votes[] = $getvote[$category];&nbsp; &nbsp; }&nbsp; &nbsp; for ($x = 1; $x &lt; 5; $x++)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; // Initialize $voted_for array&nbsp; &nbsp; &nbsp; &nbsp; $voted_for = array(&nbsp; &nbsp; &nbsp; &nbsp; 1 =&gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; 2 =&gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; 3 =&gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; 4 =&gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; 5 =&gt; 0&nbsp; &nbsp; &nbsp; &nbsp; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Now unset members of $voted_for on the drop list&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach ($drop_list as $drop)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; unset($voted_for[$drop]);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Iterate over the ballots to count votes&nbsp; &nbsp; &nbsp; &nbsp; foreach ($votes as $ballot)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Break the tally string up into an array.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tally = split_str($ballot);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Reverse the array because the ballots are stored backwards.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tally = array_reverse($tally);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Flip the array to align the keys with the drop values. This also destroys unwanted duplicate entries.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tally = array_flip($tally);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Drop out votes for candidates that have been elminated in prior voting rounds.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach ($drop_list as $drop)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; unset($tally[$drop]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Flip the array back to put the values back where they belong.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tally = array_flip($tally);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Now count the ballot on the first element IF any elements still exist.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (count($tally))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $voted_for[reset($tally)]++;&nbsp; &nbsp; &nbsp; &nbsp; // Increment the element of $voted for corresponding&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // to the first element of tally&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Sort by value, retaining keys, arrange in reverse order.&nbsp; &nbsp; &nbsp; &nbsp; arsort($voted_for);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (count($voted_for) == 2)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $finalists = array_flip($voted_for);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (count($finalists) == 2)&nbsp; &nbsp; // If it drops to 1 there is a tie.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winners[0] = reset($finalists);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winners[1] = end($finalists);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winners[0] = reset($voted_for);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winners[1] = end($voted_for);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winners[2] = &quot;tie&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Return the result for this category back to the main ennies program. Note that this function gets called multiple times - once for each category.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $winners;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Find all the keys of the array.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $voted_keys = array_keys($voted_for);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Pop the last element into the drop list&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $drop_list[] = array_pop($voted_keys);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/php]As you can see, once the system has narrowed things down to 2 finalists it sorts them out and returns them. If they are tied it is set to return two gold winners but not return a silver - we're still debating what to do in that situation, one that is in any event unlikely to occur anyway.EDIT: Added additional comment text (in orange) to clarify the flow for laymen.</blockquote>

[QUOTE="Michael Morris, post: 2408191, member: 87"] For those capacle of reading it - here's the (tenatively) final code that does the counting. [php]function calculate_winner($category) { global $DB_site; // Initialize internal arrays $votes = array(); $drop_list = array(0 => 0); // Get the votes $getvotes = $DB_site->query("SELECT $category FROM ennies"); // Build the votes array while ($getvote = $DB_site->fetch_array($getvotes)) { $votes[] = $getvote[$category]; } for ($x = 1; $x < 5; $x++) { // Initialize $voted_for array $voted_for = array( 1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0 ); // Now unset members of $voted_for on the drop list foreach ($drop_list as $drop) { unset($voted_for[$drop]); } // Iterate over the ballots to count votes foreach ($votes as $ballot) { // Break the tally string up into an array. $tally = split_str($ballot); // Reverse the array because the ballots are stored backwards. $tally = array_reverse($tally); // Flip the array to align the keys with the drop values. This also destroys unwanted duplicate entries. $tally = array_flip($tally); // Drop out votes for candidates that have been elminated in prior voting rounds. foreach ($drop_list as $drop) { unset($tally[$drop]); } // Flip the array back to put the values back where they belong. $tally = array_flip($tally); // Now count the ballot on the first element IF any elements still exist. if (count($tally)) { $voted_for[reset($tally)]++; // Increment the element of $voted for corresponding } // to the first element of tally } //Sort by value, retaining keys, arrange in reverse order. arsort($voted_for); if (count($voted_for) == 2) { $finalists = array_flip($voted_for); if (count($finalists) == 2) // If it drops to 1 there is a tie. { $winners[0] = reset($finalists); $winners[1] = end($finalists); } else { $winners[0] = reset($voted_for); $winners[1] = end($voted_for); $winners[2] = "tie"; } // Return the result for this category back to the main ennies program. Note that this function gets called multiple times - once for each category. return $winners; } else { //Find all the keys of the array. $voted_keys = array_keys($voted_for); // Pop the last element into the drop list $drop_list[] = array_pop($voted_keys); } } }[/php] As you can see, once the system has narrowed things down to 2 finalists it sorts them out and returns them. If they are tied it is set to return two gold winners but not return a silver - we're still debating what to do in that situation, one that is in any event unlikely to occur anyway. EDIT: Added additional comment text (in orange) to clarify the flow for laymen. [/QUOTE]

Verification