{{[REQUEST]}} Add PM count to post count

How can I add the person's pm count to their post count. And then add all the pm count to the total post count at the top??

Could someone please help me with this. I've been asking for months and still no help!

Hmm...there's maybe a really non-server intensive way to do it...but i don't know it.


maybe create a script like this..

drop this in your vB directory...

<?php

include('./global.php');

$users = $DB_site->query("SELECT userid,posts FROM user");


while ($userrow = $DB_site->fetch_array($users)) {
    $pm = $DB_site->query("SELECT count(*) FROM privatemessage WHERE fromuserid=$userrow[userid] AND folderid>=0");
    $pmcount = mysql_result ($pm,0);
    $update = $DB_site->query("UPDATE user SET posts=posts+$pmcount WHERE userid=$userrow[userid]");
}

?>

Try running that and see if it works - maybe not the most efficient code or anything..but it might work

Originally posted by BDJ
Well, I don't know about old private messages, but the new ones should be easy enough to do.
Try adding this code to the private.php file (right after the INSERT command for a PM).

$DB_site->query("UPDATE user SET posts=posts+1 WHERE userid=$bbuserinfo[userid]");

Can you give me the line where to insert this?
I added it and it didn't work "Probably added it in the wrong place"

Version 2.0.0

look under the section that starts with

if ($HTTP_POST_VARS[action] == 'dosend')

then, go down a little bit and you'll see a line that starts like this:
$DB_site->query("INSERT INTO privatemessage....

then,just insert that line of code after that.

(if it doesn't work - tell me; i'll test it out on my system. Right now, this is all from my head - don't know if it'll actually work)

does not work

here is what i added

// enhanced - added $receipt to insert
$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,showsignatur e,iconid,messageread,folderid,receipt) VALUES (NULL,$touserinfo[userid],$touserinfo[userid],$bbuserinfo[userid],'".addslashes(htmlspecialchars($title))."','".add slashes($message)."',".time(). ",'$signature','$iconid',0,0,$receipt)");
$DB_site->query("UPDATE user SET posts=posts+1 WHERE userid=$bbuserinfo[userid]");
// enhanced

200 posts WHOOAH!

Any clues dude?

I don't know dude...I just installed it on my system and it worked fine..

hmmmm

did you install it in the same place as me?
Where I cut and pasted?

yep.

doesn't work for me at all

Ed Sullivan, I know you can do this. Can you help us out?