Latest PhotoPost Comments Module

[John_770]

This module will display the latest 5 (configurable) comments from PhotoPost Pro including the associated photo thumbnails.

I noticed there was a similar module posted here as well, but the code wasn't working on my installation so I constructed my own.

Tested and working on VB 3.68, VBA CMPS v3.0 RC1, PP Pro 5.6.2, don't know if it will work otherwise.


1. Open pp_latestcomments.php and make the changes as annotated. Save and upload to your vBadvanced modules folder.

2. Add 2 new templates (Code below - included in .zip also):

adv_portal_pp_latestcomments

$pp_latestcommentsbits

adv_portal_pp_latestcomments_bits

Replace the two instances of YOURGALLERYURL with your gallery root folder url (ie: http://www.mysite.com/gallery) and the one instance of YOURVBULLETINURL with your vBulletin root folder url (ie: http://www.mysite.com/forums).

<tr>
	<td class="alt1" align="left">
		<span class="smallfont"><a href="http://YOURGALLERYURL/showphoto.php?photo=$pp_latestcomments[photo]"><strong>$pp_latestcomments[title]</strong></a><br>$pp_latestcomments[comment]<br>by <a href="http://YOURVBULLETINURL/member.php?u=$pp_latestcomments[userid]">$pp_latestcomments[username]</a>
	</td>
	<td class="alt2" align="center">
		<table cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td style="background: url(http://YOURGALLERYURL/data/$pp_latestcomments[cat]/thumbs/$pp_latestcomments[bigimage]); background-color: #FAFAF8; background-repeat: no-repeat; background-position: center;"><a href="http://YOURGALLERYURL/showphoto.php?photo=$pp_latestcomments[photo]"><center>$pp_latestcomments[thumb]</center></a>
				</td>
			</tr>
		</table>
		<span class="smallfont">Rating:$pp_latestcomments[rating]</span>
	</td>
</tr>

3. Navigate to vBulletin admincp / vBa CMPS / Add Module / PHP File:

Module Title: Latest Gallery Comments
Active: Yes
File to Include: pp_latestcomments.php
Module Parent: None
Identifier: pplatestcomments
Templates Used:
adv_portal_pp_latestcomments
adv_portal_pp_latestcomments_bits
Initialize BB Code Parser: No
Initialize Forum Permissions: No
Initialize Moderator Cache/Permissions: No
Initialize Ignored Users: No
Clean File Output: No
Title Row Colspan: 2
Save

Place module where desired.

4. Done

[puregraf]

awesome! will install now

[puregraf]

nm i figured it out, love this module!

[zglows]

this is really cool! thanks a lot

[optrex]

I run using 2 databases -can anyone tell me what I need to modify please?

[stevec]

how and where do I add the two templates, adv_portal_pp_latestcomments, and adv_portal_pp_latestcomments_bits?

thanks, sorry I'm new

[bosss]

hello!

i have photoplog - can i found something like this to photoplog?

regards
bosss

[stevec]

Well I tried my best but I really didn't know where the two templates adv_portal_pp_latestcomments, and adv_portal_pp_latestcomments_bits go

I locked my site up with a database error

if any of you guys could tell me how to add the templates I'd appreciate it

Thanks!
Steve

[kepler001]

very nice thx

[jschvili]

Is there a way to only show the latest, random or most popoular picture från PhotoPost on the CMPS fronpage as a module on the side?

[nyfoto]

Originally Posted by jschvili

Is there a way to only show the latest, random or most popoular picture från PhotoPost on the CMPS fronpage as a module on the side?

I also would like to know this

[MediaHound]

Awesome... installed, tyvm.

[Cocko]

Any ideas how to see bb codes in latest comments cmps box?

cmps 2.2.1
vbulletin 3.6.4
pp pro 5.5

In general same question for template based boxes.
Can't see bb code parse option in cmps 2.2.1 .

Thanks for reply.

Regards,
Cocko

[Cello]

I'm getting this error when even trying to install it. Can anyone help?

SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM albumpicture AS albumpicture
LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
LEFT JOIN user AS user ON(user.userid = album.userid)
WHERE album.state = 'public'
ORDER BY rand(NOW()) DESC LIMIT 0, 5;

MySQL Error : Unknown column 'album.state' in 'where clause'
Error Number : 1054

[ckgb]

Photoplog one would be nice ))

[vbuser49]

Hello.

I installed this and I get a database error on the home page. Basically it's a table prefix error as I can see:

MySQL Error : Table 'user_mysite.mst_pp_comments' doesn't exist

Maybe it's just a matter of getting rid of the mst_ ? How would I do that please?

The correct database table pp_comments is there in the database.

[vbuser49]

bump

[pengrus]

Where do we add the two templates?