Counting the votes?

Ah, thanks for the quick reply.

I was just looking into using CCK computed field and extracting the values from the "votingapi_vote" table but I'm not an SQL hero so I'm struggling with the correct query. (Problem is that the table saves all votings ever done, so one needs to filter for the correct node_id and the latest user votes. Which is obviously more than my brain can handle this morning :)

Views doesn't seem to put out any of the votes, no matter how I try...

The Views w/o relationships didn't work for me, so I ended up writing a little custom module that calculates the votes and prints out a table. Might share when it's done. :)

Here the current implementation in my project. A module called doodle_calculate, which puts out an extra table for the results. It comes with this .module code:

<?php

function doodle_calculate(&$node) {
  
 // print "<pre>"; print_r($nid);print "</pre>";
    
   $sql = 'select v.tag, sum(v.value) / 100 as val from (select tag, uid, max(timestamp) as timestamp from {votingapi_vote} ' .
      "where $node->nid=content_id " .     
      "group by tag, uid) m " .
      "join votingapi_vote v on v.tag=m.tag and v.uid=m.uid and v.timestamp=m.timestamp " .
      "group by v.tag ";
     
   // print "<pre>$sql</pre>";
     
     $allresults = db_query($sql);
      
     while ($result = db_fetch_array($allresults)) {
        $my_tag[] = $result['tag'];
        $my_val[] = $result['val'];
     }

   // print "<pre>"; print_r($my_results);print "</pre>";
   if (is_array($my_tag) && count($my_tag)) { 

           print "<h3 class=\"h3-doodle\">Doodle Result</h3>";
           print "<div class=\"doodleresults\">";
           print "<table class=\"date-picker-formatter-table\" border=\"1\">";
           print "<tr>"; foreach($my_tag as $r) print "<td class=\"answer\">" . date('d/m/Y H:i', $r) . "</td>"; print "</tr>";
           print "<tr class=\"result odd\">"; foreach($my_val as $r) print "<td class=\"answer\">$r</td>"; print "</tr>";
           print "</table></div>";
   
   }
   
   // return $my_results;
}     
?>

And this in the node...tpl.php:

  <?php if($node->type == "doodle") { doodle_calculate($node);
  } ?> 

Plus some formatting in the css. If anyone knows a way to better integrate this into the CCK proceedings, I'd welcome hints. The extra table is not my favorite but I didn't find a way to add the results right below the CCK fields (which would have given the doodle look).

Awesome. I'm very interested in implementing this new version, and will do testing soon.

The "maybe" count is also cool and had been a feature request in my Intranet a while ago.