[dirgotronix]

Here's the quick script I wrote up, works pretty well from what I can tell, although it is somewhat slow for users with high post counts (although my server is only a P200, it's slow in its old age)

PHP Code:

<?
require("config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

$result = mysql_query("SELECT pagetext FROM post WHERE userid = $userid ORDER BY dateline ASC");
$number = mysql_num_rows($result);
$i = "0";
$totalcount = "0";
    while($number > $i) {
        $results = mysql_fetch_row($result);
        $string = $results[0];

        $tok = strtok($string," ");
        $count = "0";
        while(!($tok === FALSE)){
            //echo "Word=$tok<br>";
            $count ++;
            $totalcount ++;
            $tok = strtok(" ");

        }
    //echo $i . " " . $count . "<br>";
    $i++;
    }
$average = $totalcount / $number;
$average = number_format($average,3);
echo "Userid $userid has $average Words per post.";
mysql_close($db);
?>