Photopost to vb/Home Intergration v1.7 [Archive]

PixelFx

05-28-2003, 10:00 PM

////////////////////////////////////////////////////////
// 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.php?p=434862&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/forum/showthread.php?&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/showthread.php?s=&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.

PixelFx

05-29-2003, 03:58 PM

Check attach for screenshot of how this hack could look on your website. Again please note, I have vbulletin 2.30, photopost 3.3.1 intergation with vbuleltin, vbhome 4.2 installed, with the above code for this to work.

Lord Man

05-29-2003, 04:10 PM

Cooool
great job, thanks

Dan

05-29-2003, 05:38 PM

I really wish I had photopost now..... -cries-

/me clicks install incase he ever gets it

Nice hack though

Kars10

05-29-2003, 05:46 PM

Thanks PixelFX!
I check it out!

Kars :)

Alien

05-30-2003, 03:55 AM

Very nice work! I'll use this...

Kevorkian

05-30-2003, 12:43 PM

uhm ThumbnailIncluder.php where is? ^^''

Craigr

05-30-2003, 02:06 PM

Today at 02:43 PM Kevorkian said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=401963#post401963)
uhm ThumbnailIncluder.php where is? ^^''

You can get it in the photopost members forums.

Craig

Dean C

05-30-2003, 03:27 PM

Photopost is a paid product just for the record :)

- miSt

DPoole

06-02-2003, 09:01 AM

where is this file ????

phpinclude

Koutaru

06-02-2003, 09:16 AM

look in your templates

DPoole

06-02-2003, 04:11 PM

ok if i run the ThumbnailIncluder.php it shows me latest pic that been uploaded so i know its connecting and thats bits fine but can i get it to show on the VBhome can i heck - it just aint showing

I get a sort of black line and the page seems to of shunk in width

any ideas

DPoole

06-02-2003, 07:52 PM

how do i get it so that when i click on the picture it opens in new window as at moment for me its opening and closeing down vbhome.

I had a mess and i think its got something to do with thumbnailincluder.php but knowing what code to add is even harder

PixelFx

06-02-2003, 09:20 PM

I'll look into it, you would have to add some target code I'm guessing that would say load a new browser page. aka something like target"_blank" I didn't write the thumbnailer it's self however, you could possible setup when you setup your templates to load a new page there.

Again I'll look into it and post what I find :)

Update:

I'm currently working on a update and testing this with phopost 4.0 pro.. so many have to post a 1.1 version of this script.

DPoole

06-02-2003, 09:31 PM

cheers pixel - really aprreciate if this was possible

gmarik

06-05-2003, 02:56 PM

Really great. I'll install this as soon as you make a downloadable readme.txt file, ok?! The demo looks just perfect!

PixelFx

06-08-2003, 04:56 AM

I'm working on a update for photopost pro 4.0, I want to make sure it still installs ok with that, then will post update, and txt file with it :)

gmarik

06-08-2003, 07:06 PM

PixelFx, yes, please make it to work with version 4.0, so I could see it action. Could you post in the hack the modified thumnailinclude.php file needed for this hack?

Thanks, Marco

PixelFx

06-08-2003, 09:00 PM

working on the hack more today... because the thumnailinclude.php includes code from photopost all I can do is link the forum at photopost where you can download it to keep it legal. Which I will add a link for in the text version. Gotta keep everyone happy :)

update:
going out of town, for a few days, will try and post text release and update for photopost 4.0 intergration when I get back... :) have a great weekend guys...

Russ_T

06-17-2003, 12:01 AM

This looks like a great hack, just I don't understand the line

EDIT: phpinclude ADD the line below:

Thanks for your time

Smoothie

06-17-2003, 12:06 AM

the phpinclude template in your admin cp.

Russ_T

06-17-2003, 12:30 AM

Thanks for your help :D

Russ_T

06-17-2003, 01:57 AM

Hmm

I followed the instructions fine and have got everything how it should be but I get "Query failed", is there a way I can turn on more detailed error reporting so I can see WHAT failed please?

http://www.zclub.net/gallery/thumbincluder.php

It doesn't include on my vbHome at the moment although $gallery is definately in there.

Thanks a lot

Smoothie

06-17-2003, 02:29 AM

did ya edit the thumbincluder.php file?

Russ_T

06-17-2003, 06:31 AM

$Url_Path = "http://www.zclub.net/gallery/"; //URL of your photo album, where the index.php is (with / at end)
$data_dir = "http://www.zclub.net/gallery/data/" ; //URL of your photo dir where those jpeg stored (with / at end)
$images_dir =$Url_Path."images/"; //URL of your photopost images dir where default missing thumb image is stored (with / at end)
$rel_dir = "data/"; // path to the data directory where pictures reside RELATIVE
// to the location of THIS file (used for checking thumbs)
//Database Setting
//You must change these values in order to run this script
//These value are not visible in the output page source

$host = "localhost"; //Server Name
$user= "hehe"; //Username
$password= "hoho"; //Password
$database="haha"; //Photopost database name or forum database name

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

Like that but with REAL usernames etc :)

Smoothie

06-17-2003, 06:37 AM

the relative path looks wrong;
// path to the data directory where pictures reside RELATIVE

Russ_T

06-17-2003, 01:31 PM

I did originally try a relative url but that didn't work so I changed it to that, sorry, I have now changed it to

"/data"

because my thumbincluder is in www.zclub.net/gallery/ and data is www.zclub.net/gallery/data

Still getting a query failure though :(

http://www.zclub.net/gallery/thumbincluder.php

Thanks for your time, much appreciated!

Intex

06-17-2003, 01:50 PM

PixelFX - very nice hack. Is there any way you could make this work with Tigga's excellent myvbindex?

I've just purchased Photopost, so this would be a great asset to the homepage.

cinq

06-18-2003, 03:43 AM

Cannot get this to work , running vb2.2.9 , pp3.3.1 , vbhome4.2

All i get is compressed articlebits and a huge blank area on the right side of the index page.

PixelFx

06-18-2003, 06:51 AM

I didn't test the hack with vb2.2.9, however when I set it up I was using vb 2.3.0 final, photopost 3.3.1 and vbhome 4.2, I don't know if it works with 2.2.9 ..

I'm currently working on trying to intergrate this hack with photopost 4.0, vb 2.3.0, and vbhome 4.2..

I'm also playing around with photopost 4.0 and vb3.0 intergration with my test board...

nothing stable yet, but good learning experience..

----

Russ_T your relitive path would be, something like, /usr/home/accountname/gallery/data,

not your http path....

the best way to find that info out is if you have SSH/telnet access on your server. You would just cd to the data dir, then type pwd to get the full path information...

Smoothie

06-18-2003, 08:17 AM

works fine on 2.2.9

Russ_T

06-18-2003, 09:02 AM

Hi, thanks for the tip, I now have the link set up correctly, I'm gonna go destroy my vbulletin 2.3.0, vbhome 4.2, photopost 4.0 install and start a fresh using this tip :D

Thanks, I await the update eagerly :D

DPoole

06-18-2003, 12:44 PM

not bad hack but i never got it to work on my vbhome for some reason i just got a black line.

Anyway i went about this another way and its paid off and without any hacking either.

In thumbincluder i changed Line 223 to this so when i clicked on Pics they opened in new window.

print "<A class=\"$class_link\" href=\"$Url_Path"."showphoto.php?photo=".$line['id']. "\" target=\"_blank\">";

Make sure u edit the file first so it actually does connect to your photopost database.

Now i know that was working i just added this code to my forum home template and it works a dream (i have it set to show last 8 new pics)

<IFRAME border="0" name="frame" scrolling=no
src="/******/thumbincluder.php" frameBorder="0" width="960" height="125"> </IFRAME>

**** location of where its stored on your server

yep i know its an iframe but if u read above the code is edited so it opens in new window - try it - works a treat for me anyway.

PixelFx

06-18-2003, 06:54 PM

kewl idea :)

One of the things I've been wanting to do with the thumbnailincluder was add a feature to togge which gallery catigory the gallery image links to. I'm not quite sure what's involved with that yet...

but looking into it, anyone want to try and take a stab at it?

cinq

06-18-2003, 11:47 PM

Yesterday at 06:17 PM Smoothie said this in Post #31 (https://vborg.vbsupport.ru/showthread.php?postid=410229#post410229)
works fine on 2.2.9

Hmm thats odd , mine are all clean installs on localhost and followed the instructions down to the word.
And not just one time too :(

I am currently using the instructions given by Craigr ( thread here (http://www.teckwizards.com/forum/showthread.php?s=&threadid=1295) ) and it works.

Smoothie

06-19-2003, 02:07 AM

Today at 03:54 PM PixelFx said this in Post #34 (https://vborg.vbsupport.ru/showthread.php?postid=410456#post410456)
kewl idea :)

One of the things I've been wanting to do with the thumbnailincluder was add a feature to togge which gallery catigory the gallery image links to. I'm not quite sure what's involved with that yet...

but looking into it, anyone want to try and take a stab at it? Already have images grabbed from a specified gallery on my site.

DPoole

06-19-2003, 02:22 AM

how m8 are u going to share the info ?

Smoothie

06-19-2003, 02:51 AM

All the info to display thumbs from a specific cat are here:
http://www.photopost.com/members/forum/showthread.php?s=&threadid=26550

DPoole

06-19-2003, 07:01 AM

sorted - never even though of reading their own forums :)

works a treat now

PixelFx

06-19-2003, 08:43 AM

hehe, I read the photopost forum for the thumbnail includer, guess I need to read it again, what I saw was something to exclude directories, what I was looking for was something to just choose a specific catigory, however excluding works as well :)

I've just about got my next update ready hoping by the weekend...

smoothie thanks for your help in thread :)

gmarik

06-19-2003, 09:12 AM

PixelFx, can't wait. Friday or Saturday?

Russ_T

06-19-2003, 10:38 AM

I can't wait either :) Hopefully it might work with my vBulletin 2.3, vBHome 4.2 and Photopost 4.0 combo :)

Smoothie

06-19-2003, 04:10 PM

PixelFx-

Actually, you can choose a specific category, instead of excluding all but one category. This is good for my site, where all I want is one category to be displayed

PixelFx

06-19-2003, 08:12 PM

Vbhome 4.2 / Photopost 4.0 / vb 2.3.0 work well together... I just did a clean install and everything seems to be working well.

I just have to make install script, with some easter eggs ;)

Demo: updated
http://www.pixelfx.ca/index.php

Guidster

07-04-2003, 08:40 PM

Here is what I did to suit my needs running 2.2.9, Photopost 4.0 and vBPortal:

On the vBportal homepage, I simply added a center block, selected php script as the type and then added the following line:
include("http://www.allthingsmoto.com/photopost/thumbincluder.php");

I decided to add the thumbnails to the forumdisplay template in lieu of an already busy forum home page, so I added the following to forumdisplay.php:

// +--------------------------------------------------------------
// | Photopost to vbhome Link
// +--------------------------------------------------------------
$templatesused.= 'home_gallery';
eval( '$gallery = "' . gettemplate( 'home_gallery' ) . '";' );

This is identical to what Pixels instructions said to add to the index.php of forumhome.

I created a custom home_gallery template, added the postthumbnail line in the phpinclude template and then called the $posthumbnail from the home_gallery template. Works like a charm!

If you want to see yet another example of these modifications, you can visit www.allthingsmoto.com for the vBportal integration and http://www.allthingsmoto.com/forums/forumdisplay.php?forumid=114 to see the thumbnails on my forumdisplay.

Photopost and VB are an awesome pair indeed!

PixelFx

07-04-2003, 11:31 PM

yup :) I just updated the install doc I'm working on to include vb 2.3.0 and photopost 4.0.1 :) should be up soon.

:)

Intex

07-05-2003, 01:20 PM

PixelFX - great hack!

How easy would this be to implement with say myvbindex which is another cool homepage hack by Tigga on vb.org.

I'm also running photopost 4.

Thx.

PixelFx

07-10-2003, 12:09 AM

HACK UPDATED IN FIRST POST, v1.5 posted, works with vbulletin 2.30, photopost 401, and vbhome 4.2.

Things to do,

Working on Txt File Install, for the above, txt file install for vbindex, vbportal, support.

:)

Intex

07-10-2003, 05:59 PM

Hi PixelFX - I tried this for myvbindex under advisement and everything went according to plan apart from when you actually view the homepage it shows 'QUERY FAILED'. I believe this is due to the relative path being incorrect for the images and data directory.

I'm on a windows system and tried various paths. My apache install is c:\program files\apache group\apache\htdocs (htdocs is the web root). Any ideas on what this should be?

Thx.

PixelFx

07-10-2003, 08:28 PM

I've tested this on linux box. But not on windows. Possible sugguestion would be to try

your relitive path as

"c:\program files\apache group\apache\htdocs\forum"

or how ever it's setup on your system.

do you have phpmyadmin setup on your system? I've been debating on setting up an apache test site on my local host as well. If I do then I'll update the txt file for windows as well. If anyone has a windows local box setup, can ya please post here as well.

not sure if that helps but I'll message around with it on my xp system and see what i come up with :P

Intex

07-11-2003, 04:06 AM

PixelFX - yep I have phpmyadmin setup ona local system - so if you want to do any testing, just PM me.

I'll try some other path variations including the one you've highlighted above and let you know.

Intex

07-11-2003, 04:29 AM

OK, I've tried various variations for the path and still get the same 'Query Failed' error. My windows path to the gallery is:

C:\Program Files\Apache Group\Apache\htdocs\gallery

The thumbincluder.php file is located in the root of gallery folder above. My configurations settings are currently set to:

$Url_Path = "http://mysite.com/gallery/"; //URL of your photo album, where the index.php is (with / at end)

$data_dir = "http://mysite.com/gallery/data/" ; //URL of your photo dir where those jpeg stored (with / at end)

$images_dir =$Url_Path."images/"; //URL of your photopost images dir where default missing thumb image is stored (with / at end)

$rel_dir = "C:/Program Files/Apache Group/Apache/htdocs/gallery"; // path to the data directory where pictures reside RELATIVE
// to the location of THIS file (used for checking thumbs)
//Database Setting
//You must change these values in order to run this script
//These value are not visible in the output page source

$host = "localhost"; //Server Name
$user= "removed"; //Username
$password= "removed"; //Password
$database="removed"; //Photopost database name or forum database name

I've tried a variety of paths for the $rel_dir , including:

1. "C:\Program Files\Apache Group\Apache\htdocs\gallery"
2. "C:/Program Files/Apache Group/Apache/htdocs/gallery" (to make sure PHP is ok with the path)
3. "C:\\Program Files\\Apache Group\\Apache\\htdocs\\gallery" (which vB required for installation)
4. "C:\Progra~1/Apache~1/Apache/htdocs/gallery" (short name in case LFN's are causing the problem"

PixelFx

07-12-2003, 06:08 AM

Although I'm on linux this is how I have my thumbnail includer setup. Also I have the thumbnail includer setup in my gallery/root.

$Url_Path = "http://www.shukenja.com/gallery/"; //URL of your photo album, where the index.php is (with / at end)
$data_dir = "http://www.shukenja.com/gallery/data/" ; //URL of your photo dir where those jpeg stored (with / at end)
$images_dir =$Url_Path."images/"; //URL of your photopost images dir where default missing thumb image is stored (with / at end)
$rel_dir = "data/"; // path to the data directory where pictures reside RELATIVE
// to the location of THIS file (used for checking thumbs)

rather than use path names I've used full site url etc... for linking the file up.

again it's not windows but you can see how I Have it setup... It works perfectly on my setup but I can't account for all systems, will try to help where I can though.

if anyone else us using a localhost windows box/system for running their forum and use this hack, if you find a solution please feel free to post it here.

Also if you use this hack please click installed on the forum ;)

Intex

07-12-2003, 08:40 AM

PixelFX - I can confirm those don't work on my windows system.

PixelFx

07-12-2003, 11:14 AM

wonder what is missing, anyone else have ideas?

Intex

07-12-2003, 11:59 AM

Is there any way I can do some troubleshoot to find out? Maybe turning on / creating some debugging within the script so we can see what paths its using?

Intex

07-13-2003, 09:00 AM

Anybody?

PixelFx

07-13-2003, 09:31 PM

Russ_T has just replied to a thread you have subscribed to entitled - Photopost, vBulletin & vBHome Intergration v1.5 - Updated - in the Beta Hacks forum of vBulletin.org Forum. You can now reply to the thread by replying to this message. All you need to do is to make sure this code appears in the e-mail subject: [thread-53539-]

Here are the contents of the post:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Heya,

Could you do a mini guide on how to upgrade from the previous version and changes please?

Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Russ_T, if you have version 1.0 installed it should work fine when you upgrade to photopost 4.0.1 .. a lot of the changes in 1.5 are just clean ups of code, etc.

I'm currently working on a txt file, as long as your on linux your forums, vbhome and photoshop should work. Clean install or upgrading to new versions of vbulletin or photopost.

This hack in it's current state should be compatable with vb2.2.x scripts.

when vb3.0 goes gold I'll look at trying to make a version for that :)

Intex

07-14-2003, 04:58 PM

PixelFX - did you get anywhere with your windows test box. I can't figure this thing out and I'd really like this feature on the HP.

PixelFx

07-14-2003, 06:39 PM

I haven't had much chance to work on it, still would have to setup mysql etc on the system which I've not had time to do yet... been a busy week :)

Intex

07-14-2003, 06:43 PM

OK, no probs. Thx.

On a slightly different note do you know of any hack that lets the vB forum members know if a new photo has been uploaded? See my request here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=55282).

Alien

07-15-2003, 06:14 AM

Works perfectly, thanks so much for putting together some nice clear instructions!

-Jason

PixelFx

07-16-2003, 06:28 AM

your welcome :) Alien,

Mickie D

07-20-2003, 11:28 AM

is it possable to add a photo uploads section to the post bit ???

ie

Posts 3400
Member 1
Location UK
Pic Uploads 23 <---or something like that

under the avatar somewhere have it show how many pictures each member has added .. i think that will gr8ly increase the amount of pictures newbies and any other members will add :)

let me know if this is possable please

but thank you very much this hack is fantastic :)

Russ_T

07-20-2003, 12:38 PM

Hi,

I'm getting a query failed output but have no idea why, I'll look into it more but is there a common problem I might be having?

Thanks

Alien

07-25-2003, 01:15 PM

For some odd reason, I noticed shortly after adding this that my page render times increased hugely.. I went up to 5.x seconds when I was under 1.. I removed it until I figure something else out... :(

Intex

07-26-2003, 10:49 AM

PixelFX - I've still not worked out the issue with the windows path. Have you (or anyone else) been successful with this yet?

Mickie D

07-26-2003, 02:02 PM

also the last bit of code for the php_include template

$postthumbnail = implode("", file("http://www.yourdomain.com/gallery/thumbincluder.php"));

is thre no elseif ode you could use ???

because i have my gallery site on another domain and my gallery domain went down for 24 hours and all my members told me there was an error and i was taking ages to load :(

maybe if you had php code where if the first url is unreachable then it would take another url to an image with GALLERY CURRENTLY OFFLINE instead of messing all the forums up :(

PixelFx

07-26-2003, 05:57 PM

I'm still learning php but will look into it,

I'm trying to get my code to show up with multiple Thumbnail includers on the same forum, with multi-ple catigories. showing up specifically.

DEMO: http://games.shukenja.com/swg/index.php

Mickie D

07-26-2003, 08:41 PM

thanks very much i dont get any errors or any problems unless my other url goes down then the implode code gives about 4 errors.. and that really slows my site down .. but hopefully my gallery wont go down anymore :(

PixelFx

07-31-2003, 01:37 AM

well as far as I know if your on linux, this script is pretty stable.. I'm working on an even more intergated system

gmarik

08-02-2003, 11:12 AM

Pixel, have you hacked your PhotoPost as well and if so, what exactly, can you tell it?

Mickie D

08-03-2003, 12:24 PM

07-31-03 at 03:37 AM PixelFx said this in Post #71 (https://vborg.vbsupport.ru/showthread.php?postid=421925#post421925)
well as far as I know if your on linux, this script is pretty stable.. I'm working on an even more intergated system

sorry i was not clear :(

there is nothing wrong with your coding :) it works fine

but i have my gallery on another site (not the same as my forums) and when the gallery site is down because of the gallery site hosts

then my forums get alot of errors from the other site being down

but i suppose if you keep your gallery on the same site as the forums then it will be fine, but unlucky me has it on another site and if the gallery goes down then my forums might aswell be down aswell because the speeds are crazy slow and my forums get alot alot of errors :(

hope that makes sense

PixelFx

08-19-2003, 06:50 PM

Updated first post, added text file, and cleaned up code a bit.. Working on more updated, tested with latest version of photopost and vbulletin 2.3.2, works great on my sites.

Demo: http://www.lxg.ca/index.php :)

Intex

08-20-2003, 03:54 PM

PixelFx - did you get anywhere with the windows integration? I'd gladly pay for someone to get this sorted.

PixelFx

08-20-2003, 06:08 PM

Intex what windows os are you using? I'm toying with the idea of setting up a test board on my xp box...

Intex

08-21-2003, 04:34 AM

I'm using Windows XP as well.

gmarik

08-23-2003, 07:34 AM

It's getting better and better. Thank's, Pix!

Intex

08-24-2003, 07:21 AM

PixelFX - let me know if I can assist. I'd really like to get this operational and as I'd mentioned previously - I'm will to pay for it :).

PixelFx

08-28-2003, 08:23 AM

Note to: Intex
I've been building my new graphics workstation the last few days, so haven't had a chance to setup my windows box, to text this script on it yet, but it is on my ta do list.

Once I have update for windows varient, I'll post it on the site.

-----------
Note to vb.org Members:
As for linux version which is posted, what ya guys think?
And any bugs or issues anyone finds please let me know.

Thanks

Mickie D

08-28-2003, 07:10 PM

i have a windows server and it runs fine ???

is your server apache or IIS

if IIS i think that is whats causing it :( (i hate IIS)

also i have major edited mine to run from my forums index aswell as my vbindex but pixel fix's code is ok !!!

PixelFx

08-28-2003, 07:42 PM

Mickie D,

Got for it, with your permission I'll add your credit, and code to the front page of this hack / update txt, as an addon if you would like. Add it to this thread.

I don't use IIS either, all my stuff will be running on apache as well. So far I've tested this hack on my main site even added exclusive catigories, and multi-ple thumbnail includers on the same database, etc, and it all loads perfectly.

:)

Mickie D

08-28-2003, 07:59 PM

ok no worries i always do my own coding on hacks :)

never wrote a hack for others so please dont be harsh on me people if its not to clear :) i will try my best :)

and also my coding i am sure can be made better but it runs fine for me !!!

Mickie D

08-28-2003, 10:10 PM

ok pixelfix i have wrote a quite detailed addon to your hack for the forum index (i.e it will display pictures on your main board home above whos online)

please PM me your addy pixelpx and i will send you a copy first and if you want to add it to the hack thats up to you and if you want to change my text that is also up 2 you

PixelFx

08-30-2003, 07:48 PM

I updated the front page of this hack,

Note to Mickie D,
I got it, I'll addd your addon shortly to the install txt on the front page of this thread :) I updated credits :)

thanks :)

Mickie D

08-31-2003, 07:36 AM

no worries m8

also the file i sent you was for only forum home

i.e www.yoursite.com/forum/index.php (what my addon does is it shows thumbincluder pictures above whos online)

i will add a screen shot shortly :)

i have not wrote my addon for vbindex yet

but dont worry all you guys with vbindex and want to use this i will write it in the next day or 2 :) its not very hard to do either only one file mod and create a template and mod a template :)

Intex

08-31-2003, 08:41 AM

PixelFX - ok thx. no problems. Let me know - I'll be waiting to test :).

Mickie D - I'm using Apache, but I'm using myvbindex as my homepage hack. Can you copy me your configuration file for thumbincluder.php, specifically PixelFX and myself weren't sure about the paths. Here is my config settings for thumbincluder.php:

//PhotoPost Setting
//You must change these values in order to run this script

$Url_Path = "http://mysite.com/gallery/"; //URL of your photo album, where the index.php is (with / at end)
$data_dir = "http://mysite.com/gallery/data/" ; //URL of your photo dir where those jpeg stored (with / at end)
$images_dir =$Url_Path."images/"; //URL of your photopost images dir where default missing thumb image is stored (with / at end)
$rel_dir = "data/"; // path to the data directory where pictures reside RELATIVE

My actual site structure is:

mysite.com (root)
|--- myvbindex.php (equivalent to vbindex)
|--- Gallery (photopost location)
|--- thumbincluder.php
|--- Forum (vbulletin install)

I believe its just the path info that's incorrect, so if you could copy me your settings as above, I'd appreciate it :).

Mickie D

08-31-2003, 08:50 AM

//PhotoPost Setting
//You must change these values in order to run this script

$Url_Path = "http://www.mysite.com/image/"; //URL of your photo album, where the index.php is (with / at end)
$data_dir = "http://www.mysite.com/image/data/" ; //URL of your photo dir where those jpeg stored (with / at end)
$images_dir =$Url_Path."images/"; //URL of your photopost images dir where default missing thumb image is stored (with / at end)
$rel_dir = "data/"; // path to the data directory where pictures reside RELATIVE
// to the location of THIS file (used for checking thumbs)
//Database Setting
//You must change these values in order to run this script
//These value are not visible in the output page source

Mickie D

08-31-2003, 08:52 AM

it looks identicle to yours m8y

send me a copy of your thumincluder as ... i remember i did edit mine a little :(

i will compare them and see what i did

Intex

08-31-2003, 09:49 AM

Mickie D - I've just PM'd you my thumbincluder file :).

Mickie D

08-31-2003, 06:46 PM

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

08-31-2003, 06:51 PM

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

08-31-2003, 06:57 PM

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

08-31-2003, 06:58 PM

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 (https://vborg.vbsupport.ru/showthread.php?postid=430126#post430126)
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

08-31-2003, 07:02 PM

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 (https://vborg.vbsupport.ru/showthread.php?postid=430132#post430132)
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

08-31-2003, 07:06 PM

@ 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

08-31-2003, 07:23 PM

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

08-31-2003, 07:42 PM

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

08-31-2003, 08:08 PM

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

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 :cool:.

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 :D.

Intex

08-31-2003, 08:18 PM

Now onto some configuration issues :D. 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?

lasto

08-31-2003, 08:44 PM

Intex i aint read all the posts but what are you trying to achieve in lymans terms plz :)

Intex

08-31-2003, 08:46 PM

My earlier posts were to do with a specific problem of not getting the hack to work. This has now been sovled and I posted the solution.

All that I need now is to exclude photopost photos that are 'private' from showing on the homepage. At the moment it's showing private photos which would usually require a password for a member to see.

lasto

08-31-2003, 09:56 PM

u need to get a hack for that from photoposts members area m8

this allows u to exclude certain sections from showing.

PixelFx

08-31-2003, 10:16 PM

See first page for catigory exclude addon.....

Intex

09-01-2003, 09:41 AM

PixelFX. Thx. for taking the time to demonstrate that. I'll take a look at this shortly :).

PixelFx

09-01-2003, 10:00 AM

np ;) I'll clean it up shortly and add it to the front page in txt file...

lasto

09-01-2003, 12:33 PM

yep well done Pixelfx will keep eye on post as well :)

Mickie D

09-01-2003, 08:53 PM

*** pay no attn to this post

i just read intex got it working so edited :)

well done ***

Mickie D

09-01-2003, 09:04 PM

This hack is awsome pixelfx there is no limitations to what you can do with it and the thumbincluder.php

i currently have it running on my PPC search engine and my sql links site lol

also as per my pm good news i nealy have thumbincluder.php showing top 5 uploaders (well quite a bit away lol, it shows top uploaders and makes my pages go completely crazy... still better than it was not working at all yesterday lol ... i will keep plugging away and will let you know how i get on)

Mickie D

09-01-2003, 10:38 PM

right i have this now working with a huge difference :)

i can call anything from photopost now :)

i modified the thumbincluder to call a script from the photopost scripts instead of using $user, $database,

i called a script using

require

that has the database user and pass included and also has all the globals used

now i have got my pictures aswell as top submitters and diskspace used

it is pretty complicated to do and i will need to talk to pixelfx

i am on holiday in the next few days so i will be away for a while hopefully i can leave all my guides in pixelfx's hands and he can sort it ???

or just wait for me to get back :)

themonarch

09-02-2003, 12:18 AM

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,med height,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,med height,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/mediapost/thumbnailer2.php?userid=1

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

Mickie D

09-02-2003, 12:50 AM

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

09-02-2003, 05:40 PM

@ 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

09-03-2003, 09:28 AM

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

09-03-2003, 03:18 PM

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

09-04-2003, 03:59 PM

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

09-04-2003, 07:16 PM

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

09-16-2003, 12:17 AM

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

09-16-2003, 05:49 AM

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

09-17-2003, 09:29 AM

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.

PixelFx

09-17-2003, 06:23 PM

in the instructions I had said it should work with both vbhome and vbindex. I just used the example of vbhome since thats what I use ;)

I'll post an update that mickie D sent me that is for vbindex shortly...

Harlequin

09-17-2003, 10:31 PM

I can't waaait!

PixelFx

09-27-2003, 01:16 PM

Here is the addon, Mickie D made for showing the photopost in your forumhome.

http://files.pixelfx.ca/forumindex_addon1.7.zip

Updated News Sept 27th

I'm Currently working on the next update v1.8/2.0
Photopost v4.1.2, Vbulletin v2.3.2, / vb3.0.0 addon

Intex

09-28-2003, 09:58 AM

PixelFX - it maybe worth mentioning on the main page that the hack can also be modified to work with myvbindex. This is what I'm using and I'll be glad to help anybody out with installing it.

PixelFx

09-28-2003, 09:45 PM

I'll add that when I release v1.8 soon, I'm working on a much large hack based on this one called, News & Gallery Catigory Hack, which also supports users with there own custom pages with unique galleries & or news feeds. which will be in vb 2.0 :)

update october 4th,

been working on update for this hack, using the new photopost v4.1.2 and vb 2.3.2 or vb 3.0, I'm rewriting a lot of the code in the thumbnail includer... I hope to have update some time in the near future, if work doesn't kill me first ;)

gmarik

10-19-2003, 04:43 PM

The new upadet is not very different, isn'it?
Any plans for the future releases?!

PixelFx

10-19-2003, 11:12 PM

Photopost just released version 4.1.4, I've been working on an update with template support, news & catigory intergration, so you can have your own gallery and your own news on it's own page etc...

so far it's for vb2.3.2, and photopost 4.1.4, I've almost completely rewritten the thumbnail includer, the new system will be in a few parts to support cms systems and non cms etc, I'm still working on install info, and testing it.

so yes there will be a future release, just swamped with off line stuff till after november 10th then plan to release a killer update to this hack :)

gmarik

10-19-2003, 11:41 PM

Man, what you do is absolutely what I need.
What's about the CMS part and have you thought about another way, to display the PP categorys? Any way to show a category as a vBhomelite block automaticly?!

Many questions, but you're the only one out here, who's developing important vB applications and support them. Yours, Marco

PixelFx

10-20-2003, 12:45 AM

the first version is vbhome lite or works with it :) tested it twice now about to do new install for it on pixelfx, to make new installer for it :)

gmarik

10-23-2003, 03:36 PM

And how for a new PhotoPost GUI?!

PixelFx

10-23-2003, 10:18 PM

small update:

Photopost 4.1.5 was release, so trying to test my updated hack with that, I'll try and get updates for this hack out as soon as humanly possible ;) Working on lots of updates and addons, including catigory and news system, :) for unique galleries ;) when intergrated with photopost/vbulletin ..

themonarch

10-26-2003, 01:08 PM

Hey all you photopost/vbulletin hackers! :)

Excellent work PixelFX and Mickie D!

Well, that project I was working on got scrubbed (allartistaccess.com) and I never did get it working. Was swamped on 3 other projects after that. Well, now I've got some more free time and if I get something working or something to add, I will.

Peace and PHP forever!

PixelFx

11-16-2003, 06:56 PM

Updated:
Well it's been a crazy month... I'm slowly getting ready for the next upgrade of this script intergration addon. Below is some of the features I'm working on slowly.

////////////////////////////////////////////////////////
// Photopost to vb/Home Intergration v2.0
// Created by PixelFX & Respective Developers
// Version 2.0
//////////////////////////////===================

Features in next version
- Full Intergration for vbulletin 2.3.3 + photopost 4.6 Final when released
- New Addon: Personal News & Gallery Catigory Hack
This allows members to have there own private web page with link to there own gallery, and have news from the forums specific to there own page show up on there page :) Custom Php file as well.
- Custom Style Support or Unique Style Support Intergration. Planned

Other:
- Template Changes, for both vb & photopost,
- Works with or with out vbhome.

ETA for release NA, however I wanted to post and say the hack isn't dead, I'll also be working on stupport of this hack for vbulletin 3.0.0 Gamma / RC1 when that is released.

comments welcome... I'll get demo up soon as I get a chance, before releasing this as a beta for this interested in this work :)