Add PM's To The Postcount!

[SgtSling]

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

[FlyingDutchman]

yupz, this line:

PHP Code:

$pmcount = $DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$touserinfo[userid]"); 


doesn't work... non-object, so plz check the db (don't have phpmyadmin running right now so can't check really...

[FlyingDutchman]

the only thing i can think of is that userid="$touserinfo[userid]" needs to be userid="$bbuserinfo[userid]"...
but still it doesn't work...

exact error for me:

Fatal error: Call to a member function on a non-object in functions.php on line 209

everytime thesame ++++ :bored: :dead:

[[D]Vincent]

That's weird because that's the exact query used in private.php. Get Zzed to release his hack or something.

[[D]Vincent]

Okay try:
$pmcount = mysql_query("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='$touserinfo[userid]'");

If that doesn't work try:
$pmcount = mysql_query("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='$bbuserinfo[userid]'");

If that doesn't work then get Zzed to release his hack.

[Zzed]

Here is the hack: https://vborg.vbsupport.ru/showthrea...threadid=42360

[[D]Vincent]

Vincent]Okay install that hack and after:

PHP Code:

 $pmratio = 100 * $pmcount[msgs] / $pmquota; 


Add:

PHP Code:

 $postspms = $pmcount[msgs] + $post[posts]; 


And open the template postbit and replace $post[posts] with $postspms. Then it should work.

[FlyingDutchman]

why doesn't it work when i just put $pmcount[msgs] in the templates? i should get the number of pm's right? but i get nothing! (talking about Zzeg's hack...)