![]() |
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!!!!! |
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 :)) Code:
total posts<br> |
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.
|
All times are GMT. The time now is 08:57 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|