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 !!!

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.

:)

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 !!!

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

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

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

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:

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

//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

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

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

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

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

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

From memory, this is exactly the same problem.

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?

@ 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 :)

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

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.

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.

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?

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.

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?

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

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.

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

this allows u to exclude certain sections from showing.

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

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

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

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

*** pay no attn to this post

i just read intex got it working so edited :)

well done ***

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)

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

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.
and then this further down:
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.

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

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

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

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 !!! :)

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.

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

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.

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

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.