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

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

[Cocko]

Originally Posted by 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?

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]

Originally Posted by 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.

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

[Zachariah]

Originally Posted by Cocko

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

[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:

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

[SherryG]

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