Add-On Releases - vBadvanced & Photopost Latest comments on front page.

**********************UPDATE 12/03/2006**************************
If you have downloaded the file before this update then i recomend that you re-download it and use the latest file.


In this latest edit I have made the file check the photo height and width and show the correct size thumbnail (thanks to Cocko for bringing this to my attention )

I believe this is the last edit that will be needed as i have done everything I can think of for this and it does what it is supposed to now, That is it shows the latest 5 comments and only those comments that have an actual comment in it and not just a rating with a blank comment.

It displays the username of the user who posted the comment and links to his/her profile (vb profile) it puts the rating under the photo (with instructions on how to remove it) and now it checks the width and height and sizes the thumbnail accordingly.

Thanks

phill






*****************END UPDATE**************************************
**********************UPDATE 12/02/2006**************************

If you have installed this already re-download the hack and use the updated cmps_comms.php it has more built in functionality.


Main edits.

1. ability to disallow cats from showing.

2. Stops empty comments from showing and grabs the latest 5 comments that have comments in them.

3. I put the ratings onto it so they show under the thumbnails (I included instructions on how to remove it)


So please re-download the zip file and use that one it is the latest build of this hack.

Thanks

Phill
*****************END UPDATE**************************************

This hack will put the 5 latest comments from photopost pro into a block on the front page of your vbadvanced cmps.

Demo Here

or see screenshot attached.


To install this.

1. Open cmps_comms.php and edit all the variables to your own.

once done save.

2. open cpms_coms_block.php and change the path to the script to reflect yours.

once done save.

3. Upload cmps_comms.php to your photopost folder

4. upload cpms_coms_block.php to your module folder (cmps modules)

5. go to your vbulletin admin control panel.

6. in the left pane choose vBa CMPS and expand it, then choose 'add module'

7. choose php file

• module title 'whatever you want to call it'
  
• column 'which ever one you want it in'
  
• active 'yes'
  
• update all pages 'yes'
  
• file to include 'cpms_coms_block.php'
  
• identifier 'comms block'
  
• clean file output 'yes'
  
• use shell template 'yes'

and save......


you should now have the block on your front page.

If it looks funny or is not is the block or something, go back untick clean file output and save then go back and retick clean file output and save, that should clear up the problem (no idea why it does that but it does)

Hope you like this hack

please click install if you use this

This was brought to you by http://www.ThatsShocking.com

[phill2003]

I have done the ratings and stopping the blank comments from appearing

I think i know what you mean with the photos i will have to see what i can do.

[phill2003]

Originally Posted by Cocko

the settings may compress the image size instead of rebuild image size.
hope its clearer now

I think i have sorted out this problem now if its what i think it is lol.

[Cocko]

Originally Posted by phill2003

I think i have sorted out this problem now if its what i think it is lol.

sounds good.
tested.
but the box disappeared.

will try again..

[optrex]

I get the following error - any help?

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 ') AND comment != '' ORDER BY date desc LIMIT 5' at line 2

[phill2003]

Is it just a standard file have you changed anything apart from the variables you need to change?

[optrex]

no, nothing other than the variables.

[phill2003]

Ok try changing the ' for " see if that makes a difference.

[optrex]

still no joy, this is the php that I think it refers to

// You may need to change the db_table_prefix if you altered it from default pp_ to something else or removed it
$result = mysql_query("SELECT username,cat,comment,photo,userid,rating
FROM pp_comments WHERE cat NOT IN ($cat_exclusions) AND comment != ''
ORDER BY date desc 
LIMIT 5" ) or die(mysql_error());
while($row = mysql_fetch_array( $result )) {

[phill2003]

Try reuploading the file see if it got corrupted because to be honest unless its something to do with php5 i cant see anything wrong with it. (but i am not an expert by any means)

Another thought, have you set any cats to be disallowed? if not it may be worth getting rid of

cat NOT IN ($cat_exclusions) AND

[jgommel]

I too am getting the following error after following the directions...

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 ') AND comment != '' ORDER BY date desc LIMIT 5' at line 2

I'm going to go over the two .php files again and make sure I didn't miss anything, but I'm about 99% sure I have not.