Add PhotoPost Pro to each forum.

[Zachariah]

/* ----------------- 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.)

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

[Zachariah]

What if VB and PhotoPost are in different DB's ?

inc_vbcat.php

- Unhash these @ the top of the file

// If you use the same userid/password to access both databases, you don't need to
// uncomment the mysql_connect - this is only if you require different ids to access
// the PhotoPost database.
//$link = mysql_connect ("localhost", "$dbuserid", "$dbuserpassword") or die('I cannot connect to the database.');
//mysql_select_db ("pp_database")or die("Could not select photopost database");


- Fill in the photopost DB info

@ very botem of the file
// If you use PhotoPost in a seperate database from vB, you'll need to reselect the vB database!
//mysql_select_db ("vb_database");

Why do my images show up but only as black spots ?

Edit: photopost/config-int.php
- add the " / " slash @ the end of:

$data_dir = "http://www.website.com/photopost/data/";

In Red

Why do I get a header of the box and not images ?

- photopost/config-int.php

// If your PhotoPost tables have a prefix, put it here
// Example:
// pp_ = "pp_";
$pp_db_prefix = "pp_";

Default prefix.

[Zachariah]

There are 2 templates:

$feature
$customfeature (no image info)


Extra Image Info:

photopost/inc_vbcat.php


$feature .= <<<PPPRINT
<td align="center" class="alt1">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td style="background: url({$data_dir}{$pcat}/thumbs/$photo); background-color: #000000; background-repeat: no-repeat; background-position: center;"><a href="{$url_path}/showphoto.php?photo={$pid}">$sthumb</a></td>
</tr>
</table>
<font size="1" face="verdana,arial"><!--{$ptitle}<br />-->
by {$puser}<br />
&middot; &middot; &middot;<br />
<a href="{$url_path}/showgallery.php?cat={$pcat}">$catname</a><br />
$cphotos photos<br />$cposts comments<br /></font>
</td>
PPPRINT;

1) Add Title of Image
Find and remove RED:
<!--{$ptitle}<br />-->


FAQs:

Remove thumbs from threads (https://vborg.vbsupport.ru/showpost.php?p=942619&postcount=19)

[HC.]

Great
just what I was looking for the new site
Thanks

[IrPr]

Thanks Zach !

[COBRAws]

There is a "Show photos from category" and we have to enter Category IDs there, how can I disable that and make it so any PP category pic will show in this hack?

[Zachariah]

There is a "Show photos from category" and we have to enter Category IDs there, how can I disable that and make it so any PP category pic will show in this hack?

This Hack is to add selected image group(s) from the gallery to select forums.

EX:

In a forum we talk about Science and the images that show are from 2 science catagories in the gallery. This could work on any subject (forum) that you need image interaction.

+-+-++-+-+-+-+-+-+-+-+-+-+-++-+-+-+
- What did you need or have in mind ?

* Image Order - newest, random, most viewed, top rated, most comments
* Image Count - enter value
* Number of Columns - enter value
* Exclude Catagories - enter value(s)
* Only Catagories - enter value(s)

On every page or just a select few ?

[Deska]

Very nice hack:)

I have question:
How to add all images categories without have to type image category ID one by one?

[SaN-DeeP]

thats great. thanks

[trackpads]

Excellent!!

[b6gm6n]

Awesome mod, cheers

-b6

[COBRAws]

This Hack is to add selected image group(s) from the gallery to select forums.

EX:

In a forum we talk about Science and the images that show are from 2 science catagories in the gallery. This could work on any subject (forum) that you need image interaction.

+-+-++-+-+-+-+-+-+-+-+-+-+-++-+-+-+
- What did you need or have in mind ?

* Image Order - newest, random, most viewed, top rated, most comments
* Image Count - enter value
* Number of Columns - enter value
* Exclude Catagories - enter value(s)
* Only Catagories - enter value(s)

On every page or just a select few ?
I just wanted to know if there was an easy way of just showing any PhotoPost category on the forums. but its good as it is. very useful!

[The Realist]

Im getting this error: Fatal error: Field ppgcount is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

Any ideas?

[Zachariah]

Im getting this error: Fatal error: Field ppgcount is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

Any ideas?

AdminCP => Plugin System => Plugin Manager

Hook Location: forumdata_start
Plugin: Add PhotoPost Pro - ForumDisplay

This is not working right.
- Perhaps not Active ?
- Perhaps not There ?

There should be 4 lines of code there. I have seen @ times on import of plugins a large amount of space saved before the code in a plug-in. If there is you can remove the extra space or reinstall again over.

[The Realist]

The plugin installed ok M8, but I had to remove it because it was saying the same error code when I tried to edit/manage other parts of my forum.

[The Realist]

Tried all ways and still getting:

Fatal error: Field ppgcount is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

Not my day.

[Zachariah]

Tried all ways and still getting:

Fatal error: Field ppgcount is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

Not my day.

Weird
- Just did an install here.
http://www.socalrailfan.com/forums/forumdisplay.php?f=13

Think there is something else installed that might gum up the works ?

[b6gm6n]

Great mod made even greater if an option was available to remove thumbs from threads and show just on forum display...either or etc...can be a little distracting from users posts, as an intro to a forum its great tho...

-b6

[Zachariah]

Plugin: Add PhotoPost Pro - Main
Hook Location: global_start

Remove:
if (THIS_SCRIPT == 'showthread'){
$search_text = '$navbar';
$vbulletin->templatecache['SHOWTHREAD'] = str_replace($search_text,
$search_text.fetch_template('forumdisplay_ppgaller y'),$vbulletin->templatecache['SHOWTHREAD']);
}


- I'll add later w/ option in AdminCP to toggle per forum.

[b6gm6n]

cheers

-b6

[The Realist]

Well I'll just have to leave this one for now until a fix is found.

Laters

Weird
- Just did an install here.
http://www.socalrailfan.com/forums/forumdisplay.php?f=13

Think there is something else installed that might gum up the works ?

[vbreal]

what about recent gallery submissions on profile

[Zachariah]

what about recent gallery submissions on profile

I'll cook one up and post the code.

[phkk]

Im getting this error: Fatal error: Field ppgcount is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

[dutchbb]

superb

[fosman]

Everything is working okay other then the thumbs. The thumbs are just blank black.. There's nothing in there. What am I doing wrong? :confused:

Screen attached

[xavierspl]

The install for this seemed to be pretty straight forward, but when I installed, I got nothing. No errors, and no changes. I've double checked the install process, and can't find anything I've missed. Any ideas?

[Zachariah]

Everything is working okay other then the thumbs. The thumbs are just blank black.. There's nothing in there. What am I doing wrong? :confused:

Screen attached

Go to your photopost/config-int.php and verify this:

data_dir = "http://www.website.com/photopost/data/";

verify that the " / " slash (in red) is at the end of the url

[fosman]

Thx for your reply mate

I've tried what you suggested .... but with no luck :surprised: It still not showing the thumbs :-(

[fosman]

Hi mate

I figured out what the problem is! Images thumbs are showing at forumhome, but not the thumbs for video clips. Does anyone what to do, so thumbs for videos also show? :o/

[Zachariah]

I think default a image (some media icon) vs. a freezframe clip is placed as a thumbnail.

[fosman]

I saw in inc_features.php and inc_vbcat that the codes didn't fetched medie other then image formats like *jpg, gif and so on. I've added my self mpg. mpeg, avi and wmv. These files are now showing in forumhome, but without thumbnails :confused:

[Zachariah]

I saw in inc_features.php and inc_vbcat that the codes didn't fetched medie other then image formats like *jpg, gif and so on. I've added my self mpg. mpeg, avi and wmv. These files are now showing in forumhome, but without thumbnails :confused:

I'll have to look @ that. I did not test on non-images. :o

[puregraf]

hi, i got a global error after i installed the hack when trying to go to the vba main page and photopost main page.. so i disabled the hook_location global start for the add photopost pro admin and add photopost main and it fixed it.. did i do something wrong? id like to get the hack working, thanks in advance

[Zachariah]

hi, i got a global error after i installed the hack when trying to go to the vba main page and photopost main page.. so i disabled the hook_location global start for the add photopost pro admin and add photopost main and it fixed it.. did i do something wrong? id like to get the hack working, thanks in advance

What was the error ? :surprised:
Also take a look @ post 2,3 for setup info, it could be simple opps.

Yell if ya still need help. :cool:

[puregraf]

What was the error ? :surprised:
Also take a look @ post 2,3 for setup info, it could be simple opps.

Yell if ya still need help. :cool:

hi, i also posted this on the photopost site, whichever gets answered first :knockedout:


---

this is what i have
Hook Location : global_start
Add PhotoPost Pro - AdminCP Add PhotoPost Pro to each forum [Edit] [Delete]
Add PhotoPost Pro - Main Add PhotoPost Pro to each forum [Edit] [Delete]


in the admin cp add photopost pro i have:


print_table_header($vbphrase['ppg_title']);
print_input_row($vbphrase['ppgcount'], 'forum[ppgcount]', $forum['ppgcount']);
print_input_row($vbphrase['ppgorder'], 'forum[ppgorder]', $forum['ppgorder']);
print_input_row($vbphrase['ppgcat'], 'forum[ppgcat]', $forum['ppgcat']);
print_yes_no_row($vbphrase['ppginfo'], 'forum[ppginfo]', $forum['ppginfo']);


and in the main add photopost pro i have:

include('/home/puregraf/public_html/graffiti-gallery/inc_vbcat.php');

if ($foruminfo['ppgcat']){
include('/home/puregraf/public_html/graffiti-space/inc_vbcat.php');

if (THIS_SCRIPT == 'showthread'){
$search_text = '$navbar';
$vbulletin->templatecache['SHOWTHREAD'] = str_replace($search_text,
$search_text.fetch_template('forumdisplay_ppgaller y'),$vbulletin->templatecache['SHOWTHREAD']);
}
if (THIS_SCRIPT == 'forumdisplay'){
$search_text = '$navbar';
$vbulletin->templatecache['FORUMDISPLAY'] = str_replace($search_text,
$search_text.fetch_template('forumdisplay_ppgaller y'),$vbulletin->templatecache['FORUMDISPLAY']);
}
}


also, step 4, i didnt understand what to do? it says: 4)
Forums & Moderators => Forum Manager => Edit forum => Add PhotoPost Pro on this Forum
- Leave "Select Catagory" blank to not show images

but i dont get it? i went to Forums & Moderators, then Forum Manager, then Edit Forum?? which one am i clicking edit for? i tried clicking edit for one of them, but there was no "add photopost pro on this forum" option? please help, thanks

[UtahNissans]

This work with photopost 5.11?

[Zachariah]

This work with photopost 5.11?

ya I do not see a problem. I do not think the DB has changed.

[TheOutdoors]

I've reinstalled this 3 times and I'm getting the same error. When I go to edit a forum to update the settings, and click Save, I receive the error "MySQL Error : Unknown column 'ppgcount' in 'field list'"

I uncommented out the lines in inc_vbcat.php to point to my PP database (it's separate from my VB database), but I still get this error.

It's like the database table wasn't updated properly with the new fields...what do I do next?

[chriszep]

hello
I have photopost 5.30 & vb 3.51
I see in my admin cp the options for inserting photopost
I done all step but in my forum I see nothing (no black thumb, nothing )
I used a fresh style (just change colour)

I edit the
Quote:
Edit: Plugin
Hook Location : global_start
Add PhotoPost Pro - Main


thanks

[Zachariah]

hello
I have photopost 5.30 & vb 3.51
I see in my admin cp the options for inserting photopost
I done all step but in my forum I see nothing (no black thumb, nothing )
I used a fresh style (just change colour)

I edit the
Quote:



thanks

Hello,

Each forum has a setting to choose witch gallery category(s) to pull images from.

AdminCP => Forums & Moderators
- Forum Manager | Edit a forum
- Add New Forum

At the bottem of the setting page of each forum.

https://vborg.vbsupport.ru/attachment.php?attachmentid=45174&d=1144112758

[chriszep]

Hello,

Each forum has a setting to choose witch gallery category(s) to pull images from.

AdminCP => Forums & Moderators
- Forum Manager | Edit a forum
- Add New Forum

At the bottem of the setting page of each forum.

https://vborg.vbsupport.ru/attachment.php?attachmentid=45174&d=1144112758


hello I have this and I completed it
if I put wrong categorys , what will happen ? an error on forum home or nothing appear ?

[Ophelia]

Our gallery is set up to not use any adornments on the thumbs, just to show flat thumbs. Out of the box install on this one puts rounded corners and a drop shadow on the thrumb. How would we go about removing those?

[top end ms]

[B][SIZE="4"]Why do I get a header of the box and not images ?

- photopost/config-int.php

// If your PhotoPost tables have a prefix, put it here
// Example:
// pp_ = "pp_";
$pp_db_prefix = "pp_";

Default prefix.


Excelent way to ruine the PhotoPost software.

"// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation."

Looks like I have to REINSTALL EVERYTHING NOW!!! Good lookin'

[Zachariah]

Excelent way to ruine the PhotoPost software.

"// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation."

Looks like I have to REINSTALL EVERYTHING NOW!!! Good lookin'

This does not ruine anything.

photopost/config-int.php

Standard setup EX:
//-----------------------------------------------------------------------------------//
// Forum Integration Configuration File
//
// For users using our forum integration files, there are a few things
// we need to know - like the location of PhotoPost and your forums; this
// prevents us from doing alot of extra processing in these scripts we otherwise
// would have to do.
//
// Follow the guides to set your paths and enable the integration options you
// want.
//-----------------------------------------------------------------------------------//

// We need to know the server paths to both your vB installation and your PhotoPost installation
$vbpath = "/www/pp/forums";
$pppath = "/www/pp/pro";

// We need the URL path to your PhotoPost and vb installation
$url_path = "http://192.168.0.4/pro/";
$vb_urlpath = "http://192.168.0.4/forums/";

// The URL of your photo dir where your images are stored (with / at end)
$data_dir = "http://192.168.0.4/pro/data/";

// If your PhotoPost tables have a prefix, put it here
// Example:
// pp_ = "pp_";
$pp_db_prefix = "pp_";

[chriszep]

Hello,

Each forum has a setting to choose witch gallery category(s) to pull images from.

AdminCP => Forums & Moderators
- Forum Manager | Edit a forum
- Add New Forum

At the bottem of the setting page of each forum.

https://vborg.vbsupport.ru/attachment.php?attachmentid=45174&d=1144112758


I found the problem after several headech , I need to put vb & photopost or it's not working , I do everything but with my slq base it doesn't works, now with everything on the same that 's good
great works !

[jwashburn]

I cant seem to get anything to appear

image count 4
image order 1
category 500
show imagebit yes

[kbb]

I seemed to have installed everything correctly and have the photopost box displayed at the top of my selected forum but there are no images displayed? Any ideas? The url is http://www.kernowbodyboarding.co.uk/forums/forumdisplay.php?f=1

[Liquid1ce]

^^ i have exacly the same error

[cavyspirit]

Also trying to get this to work with PP5.5 and vB3.6

[Cocko]

I've reinstalled this 3 times and I'm getting the same error. When I go to edit a forum to update the settings, and click Save, I receive the error "MySQL Error : Unknown column 'ppgcount' in 'field list'"

I uncommented out the lines in inc_vbcat.php to point to my PP database (it's separate from my VB database), but I still get this error.

It's like the database table wasn't updated properly with the new fields...what do I do next?

have the same error

running vb 3.6.2, pp 5.5
same sql for both pp & vb

somebody found out ?
(see below)

---

Datenbankfehler in vBulletin 3.6.2:

Invalid SQL:
UPDATE forum SET
title_clean = 'Intern',
title = 'Intern',
description_clean = '',
description = '',
link = '',
displayorder = 1,
parentid = -1,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options - 4, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options - 16384, options),
options = IF(options & 256, options, options + 256),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
styleid = 0,
password = '',
agelock = '0',
agelock_age = '',
agelock_method = '0',
allow_sff = 1,
sff_data = '-1',
whoquotedme = 1,
forum_hlfg = '0',
ppgcount = '',
ppgorder = '',
ppgcat = '',
ppginfo = '0'
WHERE forumid = 3;

MySQL-Fehler : Unknown column 'ppgcount' in 'field list'
Fehler-Nr. : 1054
Datum : Friday, November 10th 2006 @ 11:34:17 AM
Skript : http://www. --- /vb3/admincp/forum.php?do=update
Referrer : http://www. --- /vb3/admincp/forum.php?do=edit&f=3&s=
IP-Adresse : ---
Benutzername : Cocko
Klassenname : vB_Database_MySQLi

[Cocko]

fixed issue with database additions.

forums configuration enabled with categories and number of shown images
but nothing happens in forums view.

this hack is worth to work on it until its running.

any hints about ?

[Cocko]

any ideas for vb 3.6.3 ?

[Zachariah]

I have not looked @ this in a while as I do not own the product, but ill take a look @ the errors and see about a re-wright where many setting can be edited in the AdminCP.

[Cocko]

I have not looked @ this in a while as I do not own the product, but ill take a look @ the errors and see about a re-wright where many setting can be edited in the AdminCP.

seems a little bit harder to re-code ?
(pp 5.5 / 5.6 to vb 3.6.x)

[Zachariah]

seems a little bit harder to re-code ?
(pp 5.5 / 5.6 to vb 3.6.x)

No, its not hard just getting the chance to do it :D

[Cocko]

i'm wating ;)

[Cocko]

weeks later *lol*

seems that there are no news for this hack..

[Zachariah]

thanks for the nudge :)
- my time gets thin @ times working on vBGallery, vBPortal, shoutcast stuff.

And outside ... in the Sun. I did not know the thing was still out there for the last 3-4 months. :laugh: :cool:

I will get back on it. I am reworking my website so that I can cover support on all the issues. vs 25 websits. :D

[SherryG]

This looks like a terrific hack! Any chance on getting this one for 3.6.4?

[smoknz28]

Sherry, I think he intends on working with 3.6.x...but from the post prior to yours...looks like he's swamped with other priorities. I'm with ya though...patiently waiting. ;)

[Rik Brown]

Just attempted an install and get the following error message when trying to save forum information:

Unknown column 'ppgcount' in 'field list'

I've seen references to this error in previous messages but no indication on how to fix it. Has anyone who has encountered this figured out how to fix it?

If so, please advise. Thanks. -- Rik

BTW, I have my PP and VB databases installed in the same directory. I'm running vb 3.6.4 and PP 5.31.

[Rik Brown]

Re: Unknown column 'ppgcount' in 'field list'

I came back for a 2nd attempt at installing this very nice mod and found that the plugin xml file simply wasn't adding any of the 4 required columns to our "forums" table.

In our case, the problem was with the ... NOT NULL DEFAULT '' statement which created SQL syntax error messages by mySQL. By removing the DEFAULT '' and running the queries manually (didn't attempt to alter the XML file for which this change should also work) everything is now fine.

FYI, we are running mySQL 5.0.24-standard and vb 3.6.4.

Hope that helps others and thanks to Zachariah for a really neat mod!

Cheers! -- Rik

[Spika]

Hello, this MOD is for Photopost Pro o Photopost VBGallery?
Inside the readme.txt I see this:

This hack will allow you to select witch catagories from Photopost vBGallery...
Thanks

[Spika]

I have installed and I get this error in the forum I have enabled album:

Warning: main() [function.main]: open_basedir restriction in effect. File(/config-int.php) is not within the allowed path(s): (/var/www/vhosts/gstrail.es/httpdocs:/tmp) in /var/www/vhosts/gstrail.es/httpdocs/photopost/inc_vbcat.php on line 15

Warning: main(config-int.php) [function.main]: failed to open stream: Operation not permitted in /var/www/vhosts/gstrail.es/httpdocs/photopost/inc_vbcat.php on line 15

Fatal error: main() [function.require]: Failed opening required 'config-int.php' (include_path='.:') in /var/www/vhosts/gstrail.es/httpdocs/photopost/inc_vbcat.php on line 15

I have installed Vbulletin 3.6.4 and Photopost Pro 5.62. in a VPS.
If is a permission problem in PHP.info I have safemode LOCAL: Off / REMOTE: On

Thanks in advanced

[Spika]

Anyone can help me about the above post?

[DaveS]

Just to note down my experiences.
I have vBulletin 3.6.4 and Photopost Pro 5.6.2
I have vB installed in root/forums and Photopost installed in root/photopost
I've installed the mod straight as it stands and followed the install instructions.
It installed perfectly, but thumbnails didn't display at all.

After some investigation I saw that the thumbnail URL was not formed properly.
I edited the inc_vbcat.php file that goes in the Photopost folder and made the following corrections.

From:
<td style="background: url({$data_dir}{$pcat}/thumbs/$photo)

To:
<td style="background: url({$data_dir}/{$pcat}/thumbs/$photo)

Note the added slash between the {$data_dir}{$pcat}. The above correction needs to be made in 2 places, when you open up the file to edit it should be easily apparent where they are as they are close together.

Hope this helps someone with the same problem.
Mod works a treat though and is really great.

[Rik Brown]

We use a popular hack to create a left column for our forums. I'd like to move this hack so that it would display in that left column instead of its current placement. I assume that would require a new "hook." Does anyone know how to accomplish that?

Thanks. -- Rik

[Quantnet]

Can this mod be used to show photo on the Forum Home only ?

[Z82]

Just to note down my experiences.
I have vBulletin 3.6.4 and Photopost Pro 5.6.2
I have vB installed in root/forums and Photopost installed in root/photopost
I've installed the mod straight as it stands and followed the install instructions.
It installed perfectly, but thumbnails didn't display at all.

After some investigation I saw that the thumbnail URL was not formed properly.
I edited the inc_vbcat.php file that goes in the Photopost folder and made the following corrections.

From:
<td style="background: url({$data_dir}{$pcat}/thumbs/$photo)

To:
<td style="background: url({$data_dir}/{$pcat}/thumbs/$photo)

Note the added slash between the {$data_dir}{$pcat}. The above correction needs to be made in 2 places, when you open up the file to edit it should be easily apparent where they are as they are close together.

Hope this helps someone with the same problem.
Mod works a treat though and is really great.


Did this, made the db config changes in inc_vbcat.php and enabled it in a couple of forums inyet I get absolutely nothing on my site :?

Anyone got any ideas?

[Z82]

Anyone?

[Z82]

Ahh I sussed it, I had the wrong URL in the hook but my next question is how do I just get this on Index page?

[VViper]

Hi There, what a wonderful mod, i love it it works fantastic and was just what i needed.
Thankyou for your hard work and excellent modification. You are truely a guru.

My hat goes off to you. :)

[VViper]

Hi Zac i had trouble finding the thread again.

I cannot get the images to display. It shows the category but not the images.

any ideas?

I am running 3.6.7 VB and latest Photopost.

Its an awesome mod, but it was a shame i had to upgrade VB3.6.7 :(

Do you have time to fix this wonderful mod.

[Zachariah]

Hi Zac i had trouble finding the thread again.

I cannot get the images to display. It shows the category but not the images.

any ideas?

I am running 3.6.7 VB and latest Photopost.

Its an awesome mod, but it was a shame i had to upgrade VB3.6.7 :(

Do you have time to fix this wonderful mod.

Are the images black or just not there ?

[b6gm6n]

works for me...latest vB no changes!

[VViper]

Hi zac, the images are just not there.
The thing appears to be collapsed.

[VViper]

He there zac here is an example from the site.

http://www.gpcricket.com.au/forum/forumdisplay.php?f=35

I dont know why it doesnt show, your other mod for the forum home works a treat.

This is a really good mod i just wish it would work :(

waiting in anticipation VV

[yotsume]

WOW this thread has been dead for a while!

To bad this works great on the latest everything! My question is how can I add this to my forum home and also on my vbadvanced home as a module.

Hope soemone can help...

Yotsume

[yotsume]

I have this installed on vbulletin 3.6.8 and Photopost 6. When the mod is enabled I can not edit forums and get this error: MySQL Error: Unknown column 'ppgcount' in 'field list'
Error Number : 1054

How can I fix this so it runs on my board? When I deactivate the mod I can edit forums again.

Love this mod and need it bad! Thanks!

[Ville]

Same problem as yotsume. :(

It may have been PhotoPost 6.0 or vBulletin 3.6.8 that broke this add-on since both included substantial database changes.

Is this add-on still being maintained as is suggested by the header? I would also very much like to have this on my forum!

Thanks!

[stuartn]

I have this installed on vbulletin 3.6.8 and Photopost 6. When the mod is enabled I can not edit forums and get this error: MySQL Error: Unknown column 'ppgcount' in 'field list'
Error Number : 1054

How can I fix this so it runs on my board? When I deactivate the mod I can edit forums again.

Love this mod and need it bad! Thanks!

I too have the same error message coming up - I would love to get it working sooner rather than later.

[stuartn]

Re: Unknown column 'ppgcount' in 'field list'

I came back for a 2nd attempt at installing this very nice mod and found that the plugin xml file simply wasn't adding any of the 4 required columns to our "forums" table.

In our case, the problem was with the ... NOT NULL DEFAULT '' statement which created SQL syntax error messages by mySQL. By removing the DEFAULT '' and running the queries manually (didn't attempt to alter the XML file for which this change should also work) everything is now fine.

FYI, we are running mySQL 5.0.24-standard and vb 3.6.4.

Hope that helps others and thanks to Zachariah for a really neat mod!

Cheers! -- Rik

Thanks Rik,

Did your trick and hey bingo all working a treat.

[VViper]

I just updated to the latest version of Photopost and VB and this modification doesnt work any more.
Is anyone else having the same problem?

It shows the Category but doesnt display any photos. You click on collapse but it doesnt show any photos.

[Zachariah]

I'll need to get access to 6.x Pro's "inc_features.php" file.
- I'll ask Chuck @ photopost to shoot it to me in e-mail.

[Majava]

Would love to use this, downloaded it, tried to install it, but just cannot get rid of that error: 1054. Uninstalling until the bugs are worked out.

EDIT: I dont know enough about all this to go mucking around with SQL queries and the like. Anything that requires such things without step by step instructions an imbecile could understand, I would think constitutes an "incomplete" modification. Not all of us know the ins and outs.

[yotsume]

This was fixed for me by the creator but I just went to install it on my new site and I am back to square one with the same database error. Can anyone post real instructions on how to fix this! ASAP LIKE!

Thanks!

I have this installed on vbulletin 3.6.8 and Photopost 6. When the mod is enabled I can not edit forums and get this error: MySQL Error: Unknown column 'ppgcount' in 'field list'
Error Number : 1054

How can I fix this so it runs on my board? When I deactivate the mod I can edit forums again.

Love this mod and need it bad! Thanks!

[yotsume]

Originally Posted by Rik Brown https://vborg.vbsupport.ru/external/2011/11/11.gif (https://vborg.vbsupport.ru/showthread.php?p=1158438#post1158438)
Re: Unknown column 'ppgcount' in 'field list'

I came back for a 2nd attempt at installing this very nice mod and found that the plugin xml file simply wasn't adding any of the 4 required columns to our "forums" table.

In our case, the problem was with the ... NOT NULL DEFAULT '' statement which created SQL syntax error messages by mySQL. By removing the DEFAULT '' and running the queries manually (didn't attempt to alter the XML file for which this change should also work) everything is now fine.

FYI, we are running mySQL 5.0.24-standard and vb 3.6.4.

Hope that helps others and thanks to Zachariah for a really neat mod!

Cheers! -- Rik


So how do I alter the product file to get rid of this database error once and for all!!??

[popmyzit]

I'll need to get access to 6.x Pro's "inc_features.php" file.
- I'll ask Chuck @ photopost to shoot it to me in e-mail.

Hello Zachariah,
would love to get an update for this great mod.

Any update on this my friend?

thanks again :)

[popmyzit]

I just updated to the latest version of Photopost and VB and this modification doesnt work any more.
Is anyone else having the same problem?

It shows the Category but doesnt display any photos. You click on collapse but it doesnt show any photos.

yeah have the same... hope Zach come back with the fix :D

[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 www.yoursite.com/yourPPinstalldir/showgallery.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]

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 www.yoursite.com/yourPPinstalldir/showgallery.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.

[styleforum]

Hm, then I don't know if I can help you. I'm not much of an expert, just did some poking around. You might consider looking at your DB with phpMyAdmin and checking the forum table to see that the 4 fields are in there right, and then the pp_ tables to see that stuff looks right in there. It's all pretty logical if you look at the php for this mod for the field names and stuff.

[TomC18]

I got it. I uninstalled VBGallery, which was disabled as I now use photopost pro, and it started working.

[styleforum]

Great!

[CallieJo]

Got it working with vb3.7 beta 5 and the newest version of pp after a bit of tweaking from helpful info located in this thread.

The last thing that I had to do was to put my database name and pass on line 26 of the file instead of keeping the variables there.

As for getting blank nothings, I had put my url instead of the path to gallery in the main plugin. Putting the path solved the blank nothings.

Just wanted to note that it does work with the current vb beta and pp.

Thanks for this mod.

I'd love to get the stats (total number of photos) in the stats area on forumhome. I tried 2 hacks from photopost.com without any luck at all. If anyone comes up with this, please let me know as it's much needed. Also needed for classifieds & reviews as well...so please keep that in mind also. Just- stats: total# for each pp script on forumhome. Thanks.

[CallieJo]

I have this working perfectly for standard vb forums (on 3.7 beta 6).

However, when I try to enable it for GARS (http://www.thevbgeek.com/) based forums it doesn't show.

I looked at forumdisplay and GARS_forumdisplay to see if I needed to add something to make it work in GARS templated forums but cannot find anything related to this Photopost product.

Is there something I can add to the GARS forumdisplay to make this work?

Thanks*

EDITED:

I found that if I add the forumdisplay_ppgallery template code in the gars forumdisplay below the navbar thingie that it will work. Is this wise?

[stuartn]

I have found that no matter which category I put in, unless its the top parent of 500 nothing will show. My category for my gallery is 520 but nothing shows at all under this. Is thier a fix at all or is it how its meant to work.

[we_scooter]

How to add spicific PICTURe from the gallery to the header or navbar to be the photo of the Day choosen by me .. admin ?

[tommyxv]

Running vb 3.7.1 and PP 6.11. I have the blank collaspable box with no photos in it. And fixes for this? Tried everything I seen posted here already.

[tommyxv]

FYI: when you put the full path to the inc_vbcat.php in the global start plugin, you get a blank page. If you put the full URL to it or just leave it blank, you'll get the the collapsable box with no pics. So putting the url in instead of the path is NOT correct. Have to fix the blank page using the full path. It is trying to work when doing it that way.

[tommyxv]

Any fix for this? Not working on vb 3.7.x and photopost 6.11. :(

[tommyxv]

Bump, any one?? I talk to Chuck over at PhotoPost and he said the inc_features.php hasn't changed since 5.x so it's vB 3.7x that is breaking this. Any help would be great!

Thanks

[tommyxv]

Bump....PLEASE help me to get this to work with vb 3.7 and pp 6.11. Thanks

[tommyxv]

bump...anyone?

[tommyxv]

bump....can someone get this to work with vb3.7 please. Thanks.

[Zachariah]

I do not have the time @ the moment or access to the software to work on an update.
I created this hack based on access to a clients system I had with PRO installed.

[tommyxv]

ok.

[PimvanJ]

Running vb 3.7.1 and PP 6.11. I have the blank collaspable box with no photos in it. And fixes for this? Tried everything I seen posted here already.

Have You set the correct $pp_db_prefix in config-int.php?
I run 3.7.3 and PP 6.1 without any problem.

[CallieJo]

Any update for 4.0 coming? Pretty please... - willing to pay Zachariah.

[Ricsca]

Upgrade for vb 4 plase ;)