Add PhotoPost Pro to each forum.

/* ----------------- 4/03/2006 4:37PM -----------------
Add PhotoPost Pro to each forum.

This hack will allow you to fill-in catagories from Photopost Pro to display in a film strip format under the $navbar. This will show in every thread of the forum as well.

1 querry

• 1 template
• 4 Fields
• 1 file upload
• 3 plugins
• 5 phrases

Tested on:

• vBulletin 3.5.4
• PhotoPost Pro 5.21

Each forum extra options:

- Image Count:
(How many images would you like to show ?)

- Image Order:
(Enter 1 for newest, 2 for most viewed, 3 for most comments, 4 for highest rated, 5 for random.)

- Select Catagory(s):
(Here you can list catagories you wish to show images from. EX: 1,10,20)

- Show Imagebit:
(Title, Description, Rating, Username, Views, Dimensions, and more.)

+-+-+-+-+-+-+-+-+-+-+-+-

[yotsume]

DATABASE ERROR PROBLEM SOLVED!!!

So Zach solved this and it is very easy to fix. The problem is a conflict using MySQL5x database. So all you have to do to fix the database error is on 4 lines add damn zeros!

Edit the product-pp_ppg_cat.xml file.

Change the four lines that have: NOT NULL DEFAULT ' ')");

to: NOT NULL DEFAULT '0')");

Save the file and import!

ALL FIXED!

THANKS ZACH!!!

I think the first post needs to be updated with MySQL5x instructions.

[OnTheSideDesign]

I have this hack and it works great on my forums. Is there a way to have this on the main forums page? Anyone able to get it to work on vBadvanced? Just curious. I really would love it on my main forums. Thanks so much.

[yotsume]

Adding Photopost Pro thumbs to vbadvanced.... There is a module released over at vbadvanced.com for that specifically. There is a separate hack for adding the thumbs to the forum index. It would be nice to have these options all in one mod:

1. thumbs on forum cmps index
2. thumbs on forum index
3. thumbs in any forum
4. thumbs in user profile

I have separate mods for all of these options. All work great. Might be nice to collect the links to each of these hacks which is actually all based on this one and post them in one convenient place.

[TomC18]

Install went okay. I edited the XML file to add 0 to the four NOT NULL DEFAULT ' ', reloaded and all went well. Dabatbase error gone. Edit a forum to display the film strip for one of the categories and not show other than a collapsable area. I tried the fix in post 67 but that did nothing.

Has there been any fix for this or understanding as to what is going on?

[TomC18]

Just checking back.

[TomC18]

Anyone?

[TomC18]

Guess I'll go ahead and uninstall

[styleforum]

I'm running Photopost 6.0 and vb 3.6.4 and just got this all working after some struggling.

I tried it by the instructions, and after putting values in to a forum's settings, I got the "ppgcount" database error msg.
I tried changing the NOT NULL DEFAULT '' to NOT NULL DEFAULT '0' and got the error message.
I added the tables manually in phpMyAdmin and it worked.

So I uninstalled it and edited the .xml file. I took out the 4 DEFAULT '0' statements entirely. Saved it, imported it, did the settings, and it showed up just like it was supposed to.

So, if you are having this problem, despite the DEFAULT '' solution, try DELETING all the DEFAULT '''s out of your xml file, and installing (with overwrite to yes).

Example: change

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (ppgcount smallint(6) NOT NULL DEFAULT '')");

to:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (ppgcount smallint(6) NOT NULL)");

For all 4 lines that look like that. Then reimport.

BTW, those who are getting empty gallery areas, did you check the numbers you're putting in the category field? The number of the categories with stuff in them, despite the examples (1,10,20), is likely to start with 500 and up. my categories 1 and 2 have nothing in them, and then the next one is 500, 501, and so on. You may just be putting category numbers with nothing in them. You have to pull the category numbers not from the "sort order" numbers in the admin thing, but from the URL for the category view. It will be http://www.yoursite.com/yourPPinstal...llery.php/cat/515 or similar.

Try putting 500,501,502 into that category box and see if that fixes your blank thumb area problem.

Edit: I just tried putting 1,2,3,4 into my category box and I got an empty thumb gallery too.

[styleforum]

Another hack for this I added - it puts the image title in as ALT text for each pic (actually, for the overlay gif that makes the rounded border, but still, it will link that alt text to the actual showphoto page). Maybe good for SEO? Not sure. Anyway, I wanted it. The php already had the query for the image title, whether you are displaying it or not, so I don't think it adds any db overhead. But I'm not an expert.

In inc_vbcat.php:

find:

    if ( pp_is_image($photo) ) {        
        $temp_user = $puserid;
        
        if ( $height > $width )
            $sthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"\" />";
        else
            $sthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"\" />";

add what's in bold:

    if ( pp_is_image($photo) ) {        
        $temp_user = $puserid;
        
        if ( $height > $width )
            $sthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"{$ptitle}\" />";
        else
            $sthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"{$ptitle}\" />";

That's it.

I also changed the template so it reads "Random Images from the Gallery" instead of the name of the forum you're in. Just edit forumdisplay_ppgallery (under forum display templates) and change $foruminfo[title] to whatever you want.

[TomC18]

Originally Posted by styleforum

BTW, those who are getting empty gallery areas, did you check the numbers you're putting in the category field? The number of the categories with stuff in them, despite the examples (1,10,20), is likely to start with 500 and up. my categories 1 and 2 have nothing in them, and then the next one is 500, 501, and so on. You may just be putting category numbers with nothing in them. You have to pull the category numbers not from the "sort order" numbers in the admin thing, but from the URL for the category view. It will be http://www.yoursite.com/yourPPinstal...llery.php/cat/515 or similar.

Try putting 500,501,502 into that category box and see if that fixes your blank thumb area problem.

Edit: I just tried putting 1,2,3,4 into my category box and I got an empty thumb gallery too.

Thanks styleforum, I do have the correct categories entered yet still have the problem.