Photopost to vb/Home Intergration v1.7

////////////////////////////////////////////////////////
// Photopost 4.6.6 to vbhome/forum Intergration (vb2.0 & vbadvanced 1.01 vb3 Intergation
// Created by PixelFX & Respective Developers
// Version 2.0 in design
//////////////////////////////==========================

NEW UPDATE COMING: I've got this system working with vb3.o and v2.0

New Credits:
Updated Hack: PixelFX
New Thumbnail Includer: Midnightz
And Thanks to everyone below.

Update Coming Soon!

INTRODUCTION:
After searching the web and a few sites, I wanted a way to show single / latest gallery images on my
vbhome/vbulletin forum. This hack, was setup in hopes to help others get a similar result to get gallery
images from photopost to show up on your vbhome/vbulletin front page. The concepts for this hack came is
from a combo of locations, as well as adding some of my own custom hacks and templates.

NOTE 4 vbindex: This hack should work with both vbhome & vbindex, the only difference for vbindex is you would make changes to the vbindex index.php not the vbhome index.php, also you would setup templates for use in the vbindex templates rather vbhome. Make sence? I'll rate a seperate txt for that soon.

CREDITS:
- Grunt for phpinclude,
- Matt Chroust for thumbincluder.php,
- Craigr for helping at vbhome, with support
- TECK for vbhome 4.2
- Enthusiast, Inc. for PhotoPost 4.1.0, RC1 & community
- Jelsoft Enterprises Limited for vbulletin 2.3.2
- vBulletin.org for support learning how to hack vb
- PixelFX for vb/home templates & some custom php vb hacking below.
- midnightz for updated thumbnail includer (see end of thread)

HACK ADDONS:
Forum home addon - Mickie D Follow Link below for addon download
https://vborg.vbsupport.ru/showpost....&postcount=123

Catigory Exclude Addon - PixelFX Credits in zip file,
http://files.pixelfx.ca/catigory_exclude_addon1.0.zip

LICENCE INFO:
To get all required files you need licenced copy of vbulletin v2.2.x / 2.3.2 & photopost pro 4.1.0+ /

I'm working on version for vb3.0 gamma/RC1 as well, which is in testing

FILES NEED:
vBulletin 2.3.3+ (installed) Tested on 2.2.x as well
PhotoPost 4.51+ (Choose to intergrate with vbulletin when you install photopost.)
vBHome 4.2+ (clean install)
thumbincluder.php tweaked, and link to database.
thumbincluder.txt modified by pixelfx for catigory addon - coming soon.
thumbincluder.txt version 2, by midnightz

I take no credit for the thumbnailincluder.php which is needed for this hack to run. Although I have made edits
to it, for my next version of this script

LOCATION OF THUMBNAIL-INCLUDER:
(requires membership account and licence for photopost)
http://www.photopost.com/members/for...threadid=26550

for the thumbnailincluder11.txt rename to what ever ya want file.php be sure you set varables to your liking.
Then upload, To your gallery's root directory. I've found you can use multiple files and it works fine See addon coming soon for that.

Example: http://www.url.com/gallery/thumbnailincluder.php

SUPPORT:
I will only support this hack on this thread currently. aka here,
if you would like to create addons please PM me
https://vborg.vbsupport.ru/showthrea...threadid=53539

BEFORE YOU DO ANYTHING BACK UP YOUR FORUM DATABASE & GALLERY,
FILES ETC. USE AT YOUR OWN RISK.
I've tested this on my two vb sites, and it works awesome. However I can't predict what it
will do on sites that are heavely hacked.

LAST UPDATED:
December 7th,2003

(note that update news info can befound at end of thread)

Note: This should work if you edit the forum/index.php but only if you want images to show up in
your forums rather than your vbhome. This is something I need to test more, so will post alternate update shortly for that.

NOTE: this version is for vbhome 4.2 to php 4.1.0 intergration, again addon will be posted soon.
NOTE: Text File Download at buttom of file,

MAIN DEMO:
NA - Coming soon.. for version 2.0

COMING SOON:
Addon - News & Specific Image Catigory on it's own page.
Example of addon:
- Supports Random Images
- Supports Recent Images
- Supports Most Popular Images

This works with main hack, and or sub pages (coming soon!)

TESTED ON:
vbulletin v2.3.2 Final, Photopost 4.1.0 RC2 , and vbhome v4.2 (clean install)

PLEASE CLICK INSTALL:
If you use this hack, thanks

News Update: [12.04.2004]
I'm still working on a vb 3.0.3/pp4.8.5 version of this. Its also got a unique gallery/news system with the update. It's taken a while for me to get it out as I've been swamped with contracts, but I hope to release update soon.

[Mickie D]

ok m8 i sent you my includer hopefully that works for you

if it dont work dont dispear as i know it works with windows apache servers

and also tell me when you go straight to your includer.php

i.e www.yoursite.com/whatever/thumbincluder.php what happens ?????

let me know

[PixelFx]

I think for windows I read that you need to make your url_path,

path = "c:\www\root\photopost\" etc for exmaple

rather than the way I have it listed for the use with linux.

----------

I can do the vbindex version or get mickie to who ever has more time its a fun script to play with

I'm about to do clean install of it and test my new addon with pixelfx.ca

[Mickie D]

Mine is

$rel_dir = "data/";

i run apache under XP aswell (same as him)

as long as your thumbincluder.php is in your main gallery folder it will be fine

arrggghhh hold on what is your permissions on thumbincluder.php file under windows security (permissions) ????

i am thinking it might not have access rights ???

[Intex]

Mickie D - Thx. for the new file. I've uploaded this and just changed the relevant sections you highlighted with #####. Although I've not tested it on the homepage, I can tell you that running the thumbincluder file directly, thus:

http://mysite.com/gallery/thumbincluder.php

Produces the following:

Query Failed

From memory, this is exactly the same problem.

Today at 08:46 PM Mickie D said this in Post #91
ok m8 i sent you my includer hopefully that works for you

if it dont work dont dispear as i know it works with windows apache servers

and also tell me when you go straight to your includer.php

i.e www.yoursite.com/whatever/thumbincluder.php what happens ?????

let me know

[Intex]

There are no XP based permissions set on that directory. Photopost operates correctly, so surely that should be fine?

Are you talking about granting specific permissions to the Apache server?

Today at 08:57 PM Mickie D said this in Post #93
Mine is

$rel_dir = "data/";

i run apache under XP aswell (same as him)

as long as your thumbincluder.php is in your main gallery folder it will be fine

arrggghhh hold on what is your permissions on thumbincluder.php file under windows security (permissions) ????

i am thinking it might not have access rights ???

[Mickie D]

@ pixelfx .. up 2 you m8 if you want to make a vbindex addon .. it would probably be better than mine lol

did you try my addon for the forum home pixelfx ?

but if you want me to make the vbindex hack i will

[PixelFx]

I haven't had a chance to try it yet, building my personal site, at the moment, and doing clean install with photo's latest version...

also I've heavely modified my thumbnail-includes's / plural
----
I need to setup vbindex on my local host to make the changes, I don't think there is much of a change for how vbhome and vbindex link photo's to the main page, with how this hack works. Infact I think you could do the same as the vbhome install I have in the first post but make your vbindex index.php rather than your vbhome index.php

although I have tested that yet, I think that would be the only change in the instructions... I think however making it work with xp, is another story all together

I'll try and post your addon shortly :P I cleaned up the first post quite a bit last night to make the installer and information for the hack easier to read.

let me know what you think

[Intex]

OK - I think I'm onto something now. Looking at the actual queries within thumbinclude.php, I noticed that it was referencing tables that don't even exist (highlighted in yellow / bold below), i.e.

    switch ($q_switch) {
        case "most_views":
            if ( !IsSet($cat) ) {
                $group_title = "Most Popular Images - All Categories";
                $query = "SELECT id,user,userid,cat,title,bigimage,views FROM photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";
            }
            else {
                $query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopostphotos WHERE bigimage!='' AND approved='1' $exclude_cat AND cat in ($catquery) ORDER BY views DESC LIMIT $limit";
                $group_title = "Most Popular Images - $catname";
            }

When I installed photopost, this got installed into the same database as the vB forum. All of my photopost tables have a prefix of photopost, i.e. photopostphotos, photopostcategories. I therefore looked through the file and changed the SQL statements I could find and changed them so that they had the prefix 'photopost' in front, i.e.

    switch ($q_switch) {
        case "most_views":
            if ( !IsSet($cat) ) {
                $group_title = "Most Popular Images - All Categories";
                $query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopostphotos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";
            }
            else {
                $query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopostphotos WHERE bigimage!='' AND approved='1' $exclude_cat AND cat in ($catquery) ORDER BY views DESC LIMIT $limit";
                $group_title = "Most Popular Images - $catname";
            }

I can't see how this would work given those SQL statements previously, but even when I change the SQL statements (4 x photopostphotos and 2 x photopostcategories), I still get the same 'Query Failed'.

It must be related to this, so any other ideas now?

[Intex]

OK - Success !! Changing each of the queries did actually work - it was just that my page was cached .

So basically, the only thing you need to make people aware of is if they have a different photopost prefix option set (when they installed - see Photopost Config options: PhotoPost Database Prefix (cannot be changed)), then they need to alter each of the lines of code where the SQL statements are, to include the prefix of their photopost database tables as shown in my example above. I'd actually put the code changes here, but it would breach copyright .

Of course, if someone can find out what the variable is for this config option in Photopost, then the variable could be setup in the thumbincluder file .

Anyway, thx to PixelFX and Mickie D for trying to help with this one. If anything it made me actually go through the thumbincluder file line by line until I actually found the problem .

[Intex]

Now onto some configuration issues . Everything works perfectly with the exception of one thing. It seems that private galleries are shown which isn't obviously the desired effect. How do you stop it showing photos that are in members private galleries?