PP Review Count in Postbit

This is an Addon for Reviewpost and VB 3.5.4 that will show the total number of products a user has uploaded to your Photopost Reviews Gallery. For the other PP Products please see my profile. I apologize for any errors in advance, I am new at this

Special thanks to everyone in the coders forum as well as Zachery, Hambil, Geoligist, Developer and tn3yguy! And of course Photopost!

This hack is based on the Referers in Postbit Hack by Developer.

For support please click install!



Notes before you install!!

1. This hack will add on query per postbit on your showthread pages. On my site it is unnoticeable but if you experience a load problem then try disabling it. I am working on a second version but it will require actually hacking PP code and this is the easier version.

2. I have 2 versions of the XML, for those that have their pp in the same database as VB and for folks that dont. This is unnavoidable since RP users seem to have dramatically different databases. I personally have my VB and RP installs in the same dbase so I have not tested the XML for seperate dbases. Please let me know if it doesnt work or if there is a better way.

3. [RP/VB in Same Dbase] - Once you download the XML file (RP Products In Postbit.xml) you will need to open it in a Text Editor and edit the phrase 'pptablename' to the name of your PP Photos table. If you are using the default install then it should be 'products' or 'rp_products' if you chose a prefix. Do not edit this with an editor like Write or Word, use plain old notepad. Then save it and install below.

4. [RP/VB in different Dbase] -If you are using a seperate database for VB and RP then edit the XML file (RP Products In Postbit - sep dbase.xml) and replace 'databasename' with the name of the Database that RP is installed in, then do the edit in #3 for the table name.

5. Go to your Admin cp > Plugin System > Download/Upload Plugin. Then upload the plugin.

6. Go to your Admin cp > Styles and Templates > Postbit Templates and add the following:

For Postbit

Find:

 
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>

Add After:

 
<if condition="$show['profile']">
    <div class="smallfont">My Products: $trackpadsrprevpbit</div>
</if>

For Postbit Legacy

Find:

 
<div>
$vbphrase[posts]: $post[posts]
</div>

Add After:

 
<if condition="$show['profile']">
    <div class="smallfont">My Products: $trackpadsrprevpbit</div>
</if>

And that is it! Please click install!

[trackpads]

Reserved

[Snake]

Awesome!

[trackpads]

Thanks!!

[criscokid]

This looks like a really fantastic mod!! Is it possible to alter to show the total number of reviews a user has posted? On my site admins do all the product uploading - my users would find it cool if the number of reviews they'd posted showed up in their postbit.

[chriszep]

hello
hot last reviewpost and vb version
I have separate dbase and got this pb :

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT COUNT(*) AS count FROM colleurs-de-plastiquecom4 WHERE userid = 37;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-de-plastiquecom4 WHERE userid = 37' at line 1
Error Number : 1064
Date : Wednesday, May 24th 2006 @ 03:20:32 PM
Script : http://www.xxxxxxxxxxxxxxxxxxx/forum...ead.php?t=5430
Referrer : http://www.xxxxxxxxxxxxxxx/forums/forumdisplay.php?f=17
IP Address : xxxxxxxxxx
Username : xxxxxxxxxxxxxxxxxxx
Classname : vb_database

this is the code of the module

global $db, $vbulletin;

if ($this->post['userid'])
{
$rpproductssinpostbit = $db->query_first("SELECT COUNT(*) AS count FROM colleurs-de-plastiquecom4 WHERE userid = $post[userid]");
$trackpadsrpprodpbit = vb_number_format($rpproductssinpostbit['count']);
}

thanks

[OrangeFlea]

Originally Posted by criscokid

This looks like a really fantastic mod!! Is it possible to alter to show the total number of reviews a user has posted? On my site admins do all the product uploading - my users would find it cool if the number of reviews they'd posted showed up in their postbit.

Anyone able to answer this question?

[criscokid]

Is it possible to alter to show the total number of reviews a user has posted? On my site admins do all the product uploading - my users would find it cool if the number of reviews they'd posted showed up in their postbit.