Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
Joined: Jul 2001
Posts: 808
Zarzal Offline OP
Coder
OP Offline
Coder
Joined: Jul 2001
Posts: 808
This code is for the pal boxes in Threads7 (beta1). It pull 5 pictures (default random) from the PhotoPost database and display them in pal box.

You need to set the database names according to your setup. The script switch the database to make selects from the PhotoPost db and then switch back to Threads database. You need set the cache time (I use 5 minutes) and always build off ind the Threads7 control panel.

This script works without a PhotoPost Threads7 integration. It just take the pictures from the db.

The original is from Omegatron/Chuck S. for Threads 6.5x

PHP Code
// This script should pull 5 random pictures from
// PhotoPost and display it.
// Please modify the two lines with the databse
// connection to your settings.
//
// The base idea for this script comes from Chuck S. */

// Set it up to your path settings !
require_once("/home/..../ubbthreads/photopost.inc.php");

// Set this to your PhotoPost db prefix. Default is pp_
$pp_db_prefix = "pp_";

function
pp_get_ext( $filename ) {
return
substr($filename, strrpos($filename,"."));
}

function
pp_is_image( $filename ) {
$retval = 0;

$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );

if (
in_array(strtolower($ext), $mediatypes) )
$retval = 1;

return(
$retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "random";

switch (
$q_switch) {
case
"most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY c.views DESC"
;
break;
case
"lastest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY date DESC"
;
break;
case
"random":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()"
;
break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list(
$pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {
if (
pp_is_image($photo) ) {
$photolen = strlen($photo);
$theext = pp_get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

$temp_user = $line['userid'];
$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
$mthumb = "<img border="0" src="{$data_dir}{$pcat}/thumbs/{$photo}" alt="$thumbtag" />";

// One box for each feature
$featured .= <<<PPPRINT

<tr align="center"><td align="center" class="alt-1">
<a href="
{$url_path}showphoto.php?photo={$pid}">$mthumb</a>

by
{$puser}
</td></tr>

PPPRINT;

$counted++;
}

if (
$counted == 5 ) break;
}
mysql_free_result($result);

// change the dbname to your ubb7 database name
// we need to switch back to Threads7 database
mysql_select_db ("dbname")or die("Could not select database");

$body = <<<PPPRINT
$featured
PPPRINT;


Sponsored Links
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Thanks smile You have photopost working with threads 7?


- Allen wavey
- What Drives You?
Joined: Jul 2001
Posts: 808
Zarzal Offline OP
Coder
OP Offline
Coder
Joined: Jul 2001
Posts: 808
no, right now I run ubb6.5.5 with pp 5.31 and just pull the featured photos to ubb7beta1 for testing. This work without integration. I open a thread on PP support for the integration. It must be total rewritten. The database structure ist very different from ubb6.5 to ubb7. The ol PP integration can take nearly everything from the huge users table in ubb6.5 but in v7 this table is split in 5 tables. I start some tries but give up.

I compare some differents an Chuck say they need first a license for ubb7 to look in to it.

Joined: Jul 2002
Posts: 79
Power User
Offline
Power User
Joined: Jul 2002
Posts: 79
Ok so where does this code go?

My testing site for version 7 is not in the same folder as the photopost and my main forum... can that still work?


Eager to see this and THANKS

Joined: Jul 2001
Posts: 808
Zarzal Offline OP
Coder
OP Offline
Coder
Joined: Jul 2001
Posts: 808
This box code works with every installed PhotoPost somewhere. The only thing you need is access to the photopost.inc.php
The script connects to the Photopost database throught this file. Then select the photos and build the output. If this finished the script switch back the database connection to threads.
Thats why you have to edit the both database connetions in this script matching your settings.

Its pretty simple. No integration is needet. I run Photopost with a threads V6.5 integration on my production V6.5.5 Threads board. I setup on a other webpage threads V7 for testing and pull from the PP the pictures, works very well.

Just test it - its easy and should work on your system too.

An other point is a threads V7 integration and the pppanel script hack. I look forward into this. The integration must done by PP, thats complex but I will take a closer look to the pppanel script. Maybe I bring this to work.

Sponsored Links
Joined: Jul 2002
Posts: 79
Power User
Offline
Power User
Joined: Jul 2002
Posts: 79

I am committed to get the 5 randoms photo up this weekend

Quote
Parse error: parse error, unexpected $ in /homepages/1/d118328893/htdocs/clubadventist/forum/cache_builders/custom/portal_box_10.php on line 108

this is in one of the custom islands

Stan

By the way, Chuck has done the code to tie it version 7.

Joined: Jul 2002
Posts: 79
Power User
Offline
Power User
Joined: Jul 2002
Posts: 79
as far as I can count there are not 108 lines...



PPPRINT;

$counted++;
}

if ( $counted == 5 ) break;
}
mysql_free_result($result);

// change the dbname to your ubb7 database name
// we need to switch back to Threads7 database
mysql_select_db ("db177660228")or die("Could not select database");

$body = <<$featured
PPPRINT;
/* BODY HERE */
$body = <<EOF;




Joined: Jul 2002
Posts: 79
Power User
Offline
Power User
Joined: Jul 2002
Posts: 79
Here is the whole code
Quote
//* PHP CODE HERE */
// This script should pull 5 random pictures from
// PhotoPost and display it.
// Please modify the two lines with the databse
// connection to your settings.
//
// The base idea for this script comes from Chuck S. */

// Set it up to your path settings !
require_once("/homepages/1/d118328893/htdocs/clubadventist/photopost/index.php");

// Set this to your PhotoPost db prefix. Default is pp_
$pp_db_prefix = "pp_";

function pp_get_ext( $filename ) {
return substr($filename, strrpos($filename,"."));
}

function pp_is_image( $filename ) {
$retval = 0;

$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );

if ( in_array(strtolower($ext), $mediatypes) )
$retval = 1;

return( $retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "random";

switch ($q_switch) {
case "most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY c.views DESC";
break;
case "lastest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY date DESC";
break;
case "random":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()";
break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list($pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {
if ( pp_is_image($photo) ) {
$photolen = strlen($photo);
$theext = pp_get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

$temp_user = $line['userid'];
$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
$mthumb = "$thumbtag";

// One box for each feature
$featured .= <<

$mthumb

by {$puser}
Joined: Jul 2001
Posts: 808
Zarzal Offline OP
Coder
OP Offline
Coder
Joined: Jul 2001
Posts: 808
the problem is simple to solve:
PHP Code
require_once("/homepages/1/d118328893/htdocs/clubadventist/photopost/index.php"); 
is wrong. Change it to:

PHP Code
require_once("/your path here to/photopost.inc.php"); 


Joined: Jul 2002
Posts: 79
Power User
Offline
Power User
Joined: Jul 2002
Posts: 79
I am not the fluent in php, or pretty much anything these dasy (ask my kids smile )

How far back does that path go??

should it be

/homepages/1/d118328893/htdocs/clubadventist/photopost.inc.php

or /clubadventist/photopost.inc.php?

Can not get either one to work

I copy and paste the db name from my control panel in my forums, in the end line..

Yet it comes back and says db not found "Could not select database" which comes from the end of the php code..

photopost in ins
/clubadventist/photopost/

I would have thought photopost.inc.php would have been in the /photopost/ folder.

there is a 'inc_photopost.php' in the photopost folder....

Am using photopost 5.5

Thanks for your kind patience...

Stan

Sponsored Links
Joined: Feb 2004
Posts: 182
Member
Offline
Member
Joined: Feb 2004
Posts: 182
Originally Posted by StanCA
I would have thought photopost.inc.php would have been in the /photopost/ folder.

there is a 'inc_photopost.php' in the photopost folder....
Hi Stan,
do you have photopost.inc.php in your forum list? If I have the file with upload, list must be adapted only to your photopost. Then you can put the link to photopost.inc.php.
I send photopost.inc.php as a photopost.txt file, am not able to do but I them uploads... Must change the ending .txt in .inc.php.

Attached Images
2272-photopost.txt (660 Bytes, 88 downloads)
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Does the photopost.inc.php file go in the includes folder or the scripts folder? smile


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
This line looks a little buggy:

FROM {$pp_db_prefix}photos p


- Allen wavey
- What Drives You?
Joined: Jul 2001
Posts: 808
Zarzal Offline OP
Coder
OP Offline
Coder
Joined: Jul 2001
Posts: 808
yes, looks strange but work smile I look in the very old pal box for threads 6 and there are the same syntax. I dont have any clue how this work.

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
The current code in inc.features.php is a little different than what's posted here, tho I still can't get it to work smash


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
OK, found the current way of getting this to work.
  1. Take the inc.features.php file in photopost and re-name it to inc.features2.php
  2. uncomment lines 25 and 26, filling out your photopost database info
  3. edit line #32 to 1 (so it displays one column vertically in your sidebar)
  4. remove this (starting at line # 146)
    PHP Code

    if ( $ViewPerm[$pcat] == 1 )
    {
    continue;
    }

  5. uncomment line #238 (#235 after you remove the above smile ) and fill out your threads database info
  6. remove this section (to keep from having 2 titles for the custom island):
    Code

    <thead>
    <tr>
    <td class="tcat" colspan="$columns" align="center">
    <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('featurepal');"><img id="collapseimg_featurepal" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_featurepal].gif" alt="" border="0" /></a>
    Featured Photos
    </td>
    </tr>
    </thead>
  7. upload to your photopost directory
  8. add this code to your custom portal island box (updating the path at the top)
    Code

    /* PHP CODE HERE */
    include('/var/yourpathto/gallery/inc_features2.php');

    /* BODY HERE */
    $body = <<<EOF
    $photopostfeature
    EOF;


voila! It should be working smile I see them fine in mozilla, but not in IE smash
http://www.praisecafe.org/forum/ubbthreads.php/ubb/cfrm


- Allen wavey
- What Drives You?
Joined: Sep 2006
Posts: 6
Lurker
Offline
Lurker
Joined: Sep 2006
Posts: 6
Allen.. I confim they aren't showing up on your site using I.E. here too.

I got Zarzal's code to work on my site (UBB.t V7.0.2 & PP V5.6.2) by removing the code at the bottom that asks for the ubb database:

Code
mysql_select_db ("dbname")or die("Could not select database");

So the end of my content island code looks like this:
Code
PPPRINT;

$counted++;
}

if ( $counted == 5 ) break;
}
mysql_free_result($result);


/* DO NOT CHANGE THE LINE BELOW */

$body = <<<PPPRINT

$featured

PPPRINT;

EOF;
/* DO NOT CHANGE THE LINE ABOVE */

Also note the spelling error in the script "lastest" should be "latest". In addition to the default "random", "latest" works, but "most_view" does not. I haven't played with it to determine why.

I also had to uploaded and modify the text file Zarzal posted earlier in the thread, and saved it in the PP directory as photopost.inc.php. This appears to be a file that was present in an earlier version of PP, but is not present in the latest download. inc-photopost.php appears to have much of the same code as Zaral's script.. but I was not able to figure out a way to make it work (with my very limited PHP skills).

And lastly, I set the cache to '3' on the content island to have it rebuild the random set of images every 3 minutes.

Anyway, the result is a pretty clean sidebar box which only shows the user name under each image. (your implementation has a link to the user's gallery, how many images they have and how many comments). Have a look on my site to see the result.

The only other buggy behavior I've found (and haven't yet figured it out) is the sidebar sometimes pulls random images from categories that only have copied images in them (admin copied to a feature category). In those cases, there is no thumbail in the category to pull.. so a red-X appears. Not sure if this is an issue with PP or the PAL script. You won't run into the problem unless you've set up some Admin/Mod only categories in PP (or other similar categories) that only have images that are copied into them from other categories. My "SS Exhibit" category is an example of this.

Let me know if you need more info.

Oh.. and thanks Zarzal!

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I edited the file to fix the images smile I kinda like the extra info now, tho I may go to a simpler layout in the future smile

http://www.praisecafe.org/forum/ubbthreads.php/ubb/cfrm


- Allen wavey
- What Drives You?
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
I have tried this mod running Threads 7.1Beta5 and Photopost 5.62 (integrated) and when I plug in the code provided I get this error:

Parse error: syntax error, unexpected $end in /home/xxx/public_html/forums/cache_builders/custom/portal_box_9.php on line 104

I basically plugged in the "complete" code that stanCA has in his post above. What am I doing wrong?

Basil

Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Here is everything I have in my custom portal box:

PHP Code

/* PHP CODE HERE, IF NECESSARY */
// This script should pull 5 random pictures from
// PhotoPost and display it.
// Please modify the two lines with the databse
// connection to your settings.
//
// The base idea for this script comes from Chuck S. */

// Set it up to your path settings !
require_once("/home/mysite/public_html/bcforum/includes/photopost.inc.php");

// Set this to your PhotoPost db prefix. Default is pp_
$pp_db_prefix = "pp_";

function
pp_get_ext( $filename ) {
return
substr($filename, strrpos($filename,"."));
}

function
pp_is_image( $filename ) {
$retval = 0;

$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );

if (
in_array(strtolower($ext), $mediatypes) )
$retval = 1;

return(
$retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "random";

switch (
$q_switch) {
case
"most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY c.views DESC"
;
break;
case
"lastest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY date DESC"
;
break;
case
"random":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()"
;
break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list(
$pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {
if (
pp_is_image($photo) ) {
$photolen = strlen($photo);
$theext = pp_get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

$temp_user = $line['userid'];
$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
$mthumb = "<img border="0" src="{$data_dir}{$pcat}/thumbs/{$photo}" alt="$thumbtag" />";

// One box for each feature
$featured .= <<<PPPRINT

<tr align="center"><td align="center" class="alt-1">
<a href="
{$url_path}showphoto.php?photo={$pid}">$mthumb</a>

by
{$puser}
</td></tr>

PPPRINT;

$counted++;
}

if (
$counted == 5 ) break;
}
mysql_free_result($result);

// change the dbname to your ubb7 database name
// we need to switch back to Threads7 database
mysql_select_db ("MyDBNAME IS HERE")or die("Could not select database");

$body = <<<PPPRINT
$featured
PPPRINT;

/* DO NOT CHANGE THE LINE BELOW */
$body = <<<EOF

Body of the custom box here

EOF;
/* DO NOT CHANGE THE LINE ABOVE */



When I try to save it, I get unxepected $END at line...blah blah (see previos post).

Last edited by Basil Fawlty; 02/25/2007 3:38 PM.
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
UPDATE - I managed to get rid of the Parse Error (I think it was an extra space after the EOF; but not the thing still does not pull in picture to my Portal. Zarzal - you mentioned over on UBBCENTRAL that you were runnning this with Threads 7.1 - is your photopost integrated with your threads or not? I did download the photopost.inc.php file you provided and point to it ini the script file, but th eprotal has nothing in it when I display it.

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Can you post a link to the page throwing the error?


- Allen wavey
- What Drives You?
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Originally Posted by AllenAyres
Can you post a link to the page throwing the error?

Hi Allen! Well, to be honest, I seem to have fixed that particular error (I think it was an extra space after the EOF;) Anyway, that's the good news. The bad news is, When I put that custom Pal on my portal, the box shows up with only the title header but nothing in it. Here is what I currently have in that Custom Pal Box:

PHP Code

/* PHP CODE HERE */
// This script should pull 5 random pictures from
// PhotoPost and display it.
// Please modify the two lines with the databse
// connection to your settings.
//
// The base idea for this script comes from Chuck S. */

// Set it up to your path settings !
require_once("/home/mysite/public_html/forum/photopost/photopost.inc.php");

// Set this to your PhotoPost db prefix. Default is pp_
$pp_db_prefix = "pp_";

function
pp_get_ext( $filename ) {
return
substr($filename, strrpos($filename,"."));
}

function
pp_is_image( $filename ) {
$retval = 0;

$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );

if (
in_array(strtolower($ext), $mediatypes) )
$retval = 1;

return(
$retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "random";

switch (
$q_switch) {
case
"most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY c.views DESC"
;
break;
case
"lastest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY date DESC"
;
break;
case
"random":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()"
;
break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list(
$pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {
if (
pp_is_image($photo) ) {
$photolen = strlen($photo);
$theext = pp_get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

$temp_user = $line['userid'];
$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
$mthumb = "<img border="0" src="{$data_dir}{$pcat}/thumbs/{$photo}" alt="$thumbtag" />";

// One box for each feature
$featured .= <<<PPPRINT

<tr align="center"><td align="center" class="alt-1">
<a href="
{$url_path}showphoto.php?photo={$pid}">$mthumb</a>

by
{$puser}
</td></tr>

PPPRINT;

$counted++;
}

if (
$counted == 5 ) break;
}
mysql_free_result($result);

// change the dbname to your ubb7 database name
// we need to switch back to Threads7 database
mysql_select_db ("threadsv7")or die("Could not select database");

$body = <<<PPPRINT
$featured
PPPRINT;
/* BODY HERE */
$body = <<<EOF
EOF;





I'm using the photopost.inc.php file that Zarzal (I think) posted as a text file and edited to point to my photopost DB. I guess its working since I'm not getting an error that it can't connect to the DB.

I am not getting any error, but all I get when I place the pal on the Portals page is the header and the box itself is empty.

I'm running Threads 7.1(Beta 5) and Photopost 5.62 and its running in the "integrated" mode with my Threads.

Any ideas?

Thanks,
Basil

Last edited by Basil Fawlty; 02/26/2007 10:00 AM.
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Well, it *was* working on my site, now it's not. smash I think I overwrote my custom islands when I upgraded.

I'll have to figure it out, but basically from what I can see on your code you don't have anything displaying because you don't have anything between the:

$body = <<content should be here
EOF;

You'll get blank content islands everytime.


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
There you go, from the first post here, your last 2 lines should look like these 3 lines:

$body = <<$featured
PPPRINT;


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I think that would solve stan's problem from the last page as well. You've got

$body = blah

blah;

in there twice toward the bottom, it's gotta be once. You can do it like this:

$body = <<$featured
EOF;

But either way should work, just make sure you don't have it in there twice.


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Mine are working again: http://www.praisecafe.org/forum/ubbthreads.php/ubb/cfrm

If you follow my instructions toward the bottom of page 1 here it works well. Your custom island should only have this in it:

PHP Code

/* PHP CODE HERE */
include('/yourpathto/gallery/inc_features2.php');

/* BODY HERE */
$body = <<<EOF
$photopostfeature
EOF;


Be sure and update your path to the inc_features2.php file.


- Allen wavey
- What Drives You?
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Originally Posted by AllenAyres
There you go, from the first post here, your last 2 lines should look like these 3 lines:

$body = <<$featured
PPPRINT;

That did it! Its working for me now! Except when I choose the "random" case it seems I have a lot of thumbnails missing, or well, thats minor - at least its working.

Thank you thank you thank you!

Basil

Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
Has anyone got this working with 7.1 and PP 5.62

I've got PP "intergated" with 7.1 and I tried to copy and past the text from the first post and got nothing. I read the post with the photopost.inc.php txt file attach.


Ok I did it Allen's way with the feature2.php and got it to display. But the thumbnails are all black. If you click on them it opens the photopost window with the fullsize image.

Also, Allen, how did you make so only registered users could see the photos? I think I found this option in PP.

Last edited by Cuervo; 03/03/2007 7:18 AM. Reason: more info

-Cuervo
zOMG and oNOES
Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
Well I have it all working with the exception of the thumbnails showing up black inside uBBthreads. I see one other user had that issue, does anyone know a fix?


-Cuervo
zOMG and oNOES
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Originally Posted by Cuervo
Has anyone got this working with 7.1 and PP 5.62

I have it working with 7.1 and PP 5.62 (integrated). I will try to provide as must information as possible. First, I am using Imagemagik instead of GD in my PP. I don't know if that makes any difference, but thought I'd mention it. Ok, here is exactly, in total, what I have in my Custom PAL (I've just changed some minor things for security reasons, but you will want to put your paths and database names in anyway):

PHP Code

/* PHP CODE HERE */
// This script should pull 5 random pictures from
// PhotoPost and display it.
// Please modify the two lines with the databse
// connection to your settings.
//
// The base idea for this script comes from Chuck S. */

// Set it up to your path settings !
require_once("/home/mysite/public_html/forums/photopost/inc_photopost.php");

// Set this to your PhotoPost db prefix. Default is pp_
$pp_db_prefix = "pp_";

function
pp_get_ext( $filename ) {
return
substr($filename, strrpos($filename,"."));
}

function
pp_is_image( $filename ) {
$retval = 0;

$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );

if (
in_array(strtolower($ext), $mediatypes) )
$retval = 1;

return(
$retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "lastest";

switch (
$q_switch) {
case
"most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY c.views DESC"
;
break;
case
"lastest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY date DESC"
;
break;
case
"random":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM
{$pp_db_prefix}photos p
LEFT JOIN
{$pp_db_prefix}categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()"
;
break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list(
$pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {
if (
pp_is_image($photo) ) {
$photolen = strlen($photo);
$theext = pp_get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

$temp_user = $line['userid'];
$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
$mthumb = "<img border="0" src="{$data_dir}{$pcat}/thumbs/{$photo}" alt="$thumbtag" />";

// One box for each feature
$featured .= <<<PPPRINT

<tr align="center"><td align="center" class="alt-1">
<a href="
{$url_path}/showphoto.php?photo={$pid}">$mthumb</a><br>
by
{$puser}
</td></tr>

PPPRINT;

$counted++;
}

if (
$counted == 5 ) break;
}
mysql_free_result($result);

// change the dbname to your ubb7 database name
// we need to switch back to Threads7 database
//MAKE SURE TO USE YOUR CORRECT THREADS 7.1 DB NAME!
mysql_select_db ("threads")or die("Could not select database");

$body = <<<PPPRINT
$featured
PPPRINT;


Notice that I am pointing to inc_photopost.php in the "Require_Once" statement above. This is a file that now comes with PP 5.62.

Within the file inc_photopost.php you will want to uncomment the database lines near the top of the file like this:

PHP Code

$link
= mysql_connect ("localhost", "usernam", "password") or die('I cannot connect to the database.');
mysql_select_db ("photopost")or die("Could not select photopost database");



Be sure to edit to reflect YOUR user name and password for the PP database. Also, make sure the "photopost" database name is what you are using in the mysql_select_db statement.

Not also, you can change this line:

// which type of images do you want to show
$q_switch = "lastest"; (Yes, I know it is mispelled)

you can replace "lastest" with "random" or "most_view" depending on what category of images you want to pull from the PP database.

I hope this helps. It works fine for me,

Basil





Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
Basil,

Thanks for getting back to this post so soon!

Well, I am using GD2 so I too am not sure if that matters. I did get it working finally.

I used Allen's post from page one. I would post my inc_features2.php but it has a copyright in it and I don't want to get in any trouble on this forum for posting it. But, if you follow Allen's post to the letter you will get it working. The is one small difference on my install. Since my PP is integrated with my ubbt I didn't have to set any of the parameters for my database. So I DIDN'T uncomment any lines of code.

My issue with the black thumbnails was fixed by adding a trailing / to the data path in my photopost config. This is located on the "edit integration" page of the admin section. The field is URL to your PhotoPost DATA directory and for me to get the thumbnails to work I had to edit the field to this

Code
http://forums.yourdomain.com/photopost/data/
So it all works now! Thanks for the help!

Last edited by Cuervo; 03/03/2007 11:35 AM.

-Cuervo
zOMG and oNOES
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Glad you got it working. I'm not sure what the difference is in using the inc_features2 file versus the inc_photopost.php like I did, but mine works fine also.

Cheers,
Basil

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
The inc.features2.php is just photopost's current code for this mod, so I use it rather than trying to re-create the wheel smile

paths and url's are critical for either mod to get working, always right click on the thumbs to see where it's trying to pull the images from if your thumbnails aren't showing up. smile


- Allen wavey
- What Drives You?
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Does the "features2.php" files just get placed in the includes dor of PP then you point to THAT instead of the inc_photopost.php like I'm doing? (and where do I get this features2.php file?)

Basil

Last edited by Basil Fawlty; 03/03/2007 11:56 AM.
Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
The inc_features2.php is something Allen modded from the inc_features.php that comes with PP and is located in the /photopost dir.

I'm sure how yours or this one works, but it seems to work well. The only other thing I would like to see is the "more photos" link in at the bottom of the photos. It lets people do a refresh on the photos.


-Cuervo
zOMG and oNOES
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Originally Posted by AllenAyres
The inc.features2.php is just photopost's current code for this mod, so I use it rather than trying to re-create the wheel smile

paths and url's are critical for either mod to get working, always right click on the thumbs to see where it's trying to pull the images from if your thumbnails aren't showing up. smile

ALlen, I tried going it your way with the modified inc_features2.php file, using the directions you provided, but now I don't see any pictures at all. I'm not getting any errors either, so I'm pretty sure I'm connecting to the DB ok? The portal shows up ok, but no pictures (thumbs) are in it.

Basil

Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
Check your PMs Basil.

And can anyone suggest a way so that when you click on the thumbnail image it will open the larger one in its own window instead of loading over the forums?


-Cuervo
zOMG and oNOES
Joined: Oct 2001
Posts: 139
Journeyman
Offline
Journeyman
Joined: Oct 2001
Posts: 139
Saw you PM and replied - I have exactly the same code in my portal as you (except the path to inc_features2.php is different of course) Plus I have the exact same code as you do in inc)features2.php file (and my PP is integrated with Threads 7.1 like yours is). Yet, when I do it that way, all I get is th ePortal Title and a small blank box with NO thumbs. frown

Joined: Nov 2001
Posts: 29
User
Offline
User
Joined: Nov 2001
Posts: 29
Strange, I can't think of anything else I did to get it working other then that bad path to my thumbnails. But, you had it working with the other methode so that should not be an issue for you.

Let me look at my stuff again. You are calling the $photopostfeature from inside the portal, yes? I'm sure you are, I just can't think of anything else.


-Cuervo
zOMG and oNOES
Page 1 of 2 1 2

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,092
Joined: July 2001
Forum Statistics
Forums63
Topics37,545
Posts293,796
Members13,838
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online 284
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 20
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,806
Greg Hard 4,625
Top Posters(30 Days)
isaac 18
Top Likes Received
isaac 44
Gizmo 10
Brett 7
Morgan 2
Top Likes Received (30 Days)
isaac 4
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2020 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200916.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.099s Queries: 97 (0.031s) Memory: 3.7219 MB (Peak: 4.2814 MB) Data Comp: Zlib Server Time: 2020-09-21 13:38:20 UTC
Valid HTML 5 and Valid CSS