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.

[themonarch]

I'm trying to tweak this script to just call one user's photo(s) and use that over in each member's profile... here's what I edited in thumbnailer, but it's not working right. It calls user 1's thumbnails.

//Display Setting (Changes to fit your page)
$q_switch = "theuser";            // "random" or "most_views" or "latest" or "theuser"
$limit = 10;                        //number of image to show
$table_width = "80%";            //width of the table generated
$column = 2;                    //number of columns of the table generated
$photo_cell_align = "center";    //alignment of those cells

and then this further down:

//added by themonarch
		case "theuser":
            if ( !IsSet($cat) ) {
                $group_title = "Individual Users Photo";
                $query = "SELECT id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating FROM photos WHERE bigimage!='' AND userid='$bbuserid'";
            }
            else {
                $query = "SELECT id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating FROM photos WHERE bigimage!='' AND userid='Sbbuserid'";
                $group_title = "Individual Users Photos";
            }
            break;
			//themonarch

You can see it here:
http://www.allartistaccess.com/media...2.php?userid=1

If you change the userid to userid=43, it still pulls user 1's images.

[Mickie D]

bloody 3am in the morning i have been doingthis for lol

here is a screenie of my new addon ... and it also has my hacked thumbincluder.php (allowing it to display top uploaders)

sorry all are lame thumbs but its my test board (local) wont add no beta hacks i made to my forums until i test this a bit more

[Mickie D]

@ themonarch

i would be interested in helping you finish this

and also i am now making the amount of pictures uploaded show up in post bit (finding this not as easy though)

[PixelFx]

small Note, I'm working on update for photopost 4.1 and reading back the last few posts, mickie some great ideas and looks like work put into this ... I'm working on 2.0 update that will have addons posted soon I hope, got hit with two contracts last few days so should be back on track tomorrow I hope, for a few hours to update before next contract...

I've got huge update on my personal site coming up to test this and some new new features for the thumbnail includer

[Mickie D]

yeah i have been playing with this alot

i really like this hack and i dont mind sharing with anyone what i have made, also my templates are poor because i was so happy i got it working i just ram'd it on my site asap, i am sorting out my templates now and should have it all done proppa (without the <hr> tag lol to divide it)

also i am working on other ways for the thumbincluder to call other aspects of the photopost database, i will keep everyone posted on what is going on and what i have done.

PS i noted your pm pixelfx about the thumbincluder and modding it (i will tell matt about what i have done to it and ask his permissions b4 i share anything) and i will only post my thumbincluder that i mod on the photopost site !!!

[Intex]

Looking forward to these updates guys . Is anybody on working on some sort of notification when a new gallery photo is uploaded. I think that is one of the most wanted missing elements.

[PixelFx]

I'm currently testing update for photopost 4.1 final vb2 / vb3.0 support for next update. I'm also playing with specific news and catigory linking for specific gallery and vbforums on there own news pages if that made sence. It's working well but still testing, I'm also working on custom templates in photopost 4.1 for better site intergration both on forum home / vbhome / support for vbindex.

Mickie D is also doing a great job on forum home, and pulling other photopost data to the forum home etc. ALthough we are not yet currectly working directly together we have common goals which as you can see in the posts above help the community over all.

I'm still relatively new to hacking vbulletin, so this is a learning process for me which is quite fun, however is time consumming so I'll try and support and post updates in a timely manner.

[Harlequin]

There's something important to mention here (if it hasn't been mentioned already somewhere in this thread).


I was receiving the 'Query Failed' message for a day or two until I finally started searching around on threads and found someone's solution that worked like a charm, and while I forget who it is, they're a great, great person to get this going and noticing something that I had completely skipped.


In an untouched thumbinclude.php around line 177 they'll be a bunch of these similiar-looking $query statements. >

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


Note the 'photos'.



It's a simple oversight, but if you've added a prefix on to Photopost's queries during it's install, say 'photopost_photos' (as I have it on my forum), then you would most certainly get the Query Failed message as I did.


So to remedy this, I added the prefix:

$query = "SELECT id,user,userid,cat,title,bigimage,views FROM photopost_photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY views DESC LIMIT $limit";


And boom, it came up and worked beautifully.


Each of the $query statements in the thumbinclude.php need to be edited the same way if they're making a call to 'photos' rather than, like in my example, 'photopost_photos'.

<edit>

Btw, ty Pixel and Mickie.

And heck, this may have actually been mentioned in this thread. My brain ain't with it.

[PixelFx]

thanks for the update, I haven't gotten your error, but it's good to get every angle possible sorted out

I just setup my local webserver on xp so will be trying to install on it this hack to test it there as well. Then update my txt files, and add mickie D hack info as well

do you have a link for your site? would be nice to see how you made use of the script

[Harlequin]

I'm not releasin' anything about the site just yet. It's one of those 'in beta' things.


Though I've converted this to work with vBIndex, though it wasn't that hard or anything to just move the variables over.