[SMALL RELEASE] Average Posts / Day

[cpriest]

i am sorry if this was released before i thought maybe some non-php programmers might need it

#####open member.php

##find:
$userinfo=$DB_site->query_first("SELECT username,joindate,lastpost,usertitle,email,showema il,invisible,homepage,icq,aim,yahoo,biography,post s FROM user WHERE userid=$userid");

##add below:
$postinfo=$DB_site->query_first("select count(postid) as total_posts, sum(LENGTH(pagetext)) as total_chars from post where userid='$userid'");

$user_join_timestamp = date("U",$userinfo[joindate]);
$system_timestamp = date("U");
$ts_difference = round(($system_timestamp - $user_join_timestamp ) / 86400);
$average_posts = round($userinfo[posts] / $ts_difference ,2);
$average_chars_per_post = round($postinfo[total_chars] / $postinfo[total_posts]);

####open your getinfo template

##find:
$totalposts

##add next to it:
(An average of $average_posts posts per day with an averge of average_chars_per_post per post)


[EDIT]:
with this code it will also show average count of letters / post!!!!!