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,showemail,invisible,homepage,icq,aim, yahoo,biography,posts 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'");
##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!!!!!
Looks pretty cool.
You said the code is crappy though...will it cause any unnecessary load time due to bad queries?
Is it optimized?
nono, no extra queries it just uses the variables it gets from the usual UserInfo queries anyway.
all it is, is some calculating, and it's optimized to my best knowledge :)
and i said it's crappy because it's really simple ;)
just updated the code above to one more feature ;)
fix
An average of $average_posts posts per day with an average of $average_chars_per_post per post
I'm also getting an error on line
$average_posts = round($userinfo[posts] / $duh,2);
Wrong parameter count for round()
ver. 1.1.3
And here's my formatting (no reason, just posting :))
total posts<br>
Average of $average_posts posts per day<br>
Average of $average_chars_per_post characters per post
Where do you get $duh?
woops i am sorry i had two different formats of the code, and i rewrote it with nicer variable names and forgot to change that one
now it should work ;)
Still getting an error for
$average_posts = round($userinfo[posts] / $ts_difference ,2);
Warning: Wrong parameter count for round() in member.php3 on line 623
BlackJack i guess you're using php3 right ? unfortunately php3 doesnt support the precision in the round command
just replace the line with
$average_posts = round($userinfo[posts] / $ts_difference);
then, delete the ",2"
That did it. Thanks.
Another thing :) I get an error at the top of a page if the person hasn't made posts, and an instance with 1 post,
Warning: Division by zero in /www/thzclan/forums/member.php3 on line 624
The only way when you NOW can get an division by zero error, is when the user's posts are deleted, but his postnumber isn't, so it still reads like 22 posts even if he hasn't got any..
But otherwise, it works fine.. for me though :)
How would you do this for vBB2. Can somebody make it or remodel it quickly. It would be really useful.
Thx
Originally posted by mrlister
How would you do this for vBB2. Can somebody make it or remodel it quickly. It would be really useful.
Thx
it is already in vb2. Click on user profile and have a look.
oh ok. thx it's just that in the member.php thing it said something about mail so i got confused