By FvanT on

I would like to create a report on the Forum activity on my site, showing the total number of posts per user and the activity per recent period (e.g. week. month).

Is the best to approach to write some php & sql ? IS it a matter of counting node types per user ? Hopefully someone tells me i missed the modules or page they already created in my searches :)

⋅ Categories: Drupal 5.x

Comments

FvanT’s picture

FvanT commented

as a first attempt i am trying something like so

<?php

    $result = db_query("select name, count(*) as volume from {node}, {users} where node.type='forum' and node.uid=users.uid group by name"); 

    print "<div><table>";
    while ($row = db_fetch_array($result)) {
        print "<tr> <td> {$row["name"]}  </td><td> {$row["volume"]} </td> </tr>" ;
    }
    print "</table></div>";

?>