UBB.Developers Forums UBB.threads 6 V6 Modifications Beta-[6.3-6.4] My Photos 1.0

Michael and Chuck, good job on this hack!

I've had a few good PMs come through from my site letting me know what a nice addition we've made.

No bugs to report at this time under v6.4

Omeatron, in your instruction you write:
$data_dir = "http://www.reeftalk.com/photos" ; //URL of your photo dir where those jpeg stored (with no / at end)

in your ppanel.php you write:
//URL of your photo dir where those jpeg stored (with / at end)

Which is correct ?

I don't bring this hack to work

I also get this error:

SQL ERROR: Sun, Feb 01 2004 12:48:53 +0100 Unable to do_query: SELECT id,cat,title,bigimage,medsize FROM pp_photos WHERE userid = 5 ORDER BY date DESC LIMIT 0,16
Table 'usr_web17_1.pp_photos' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/web17/html/dclan/ubbthreads/mysql.inc.php on line 160

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/web17/html/dclan/ubbthreads/mysql.inc.php on line 133

I dont understand why always usr_web17_1 and not usr_web17_4 which is configured in pppanel.php is used. I try to follow your instructions for different databases but I guess I dont understand how to do it correctly. I attach my pppanel.php for a little review. Thanks.

Zarzal

no / at end

As far as different databases as long as the username and password is the same a simple mysql select datase command right before the query works.

However as Michael pointed out some servers do not like the select database command.

mysql_select_db ("photopost")or die("Could not select database");

Ok, I got it. It seem's there is a misunderstanding. The correct modification for different database and the same user/password look like this:

mysql_select_db ("photopostdbnamehere")or die("Could not select database");

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";
$result = mysql_query($query);
$sth = $dbh -> do_query($query);
$numrows = $dbh -> total_rows($sth);

if ( $numrows < 16 ) $nextpage = 0;

$i=0;
$color = "lighttable";
$photorow="";
$photopanel="";

mysql_select_db ("ubbdbnamehere")or die("Could not select database");

the mysql_select_db should not be on top and end of the file. It must be put direct before and after the select.

Finished, User Happy

me again, sorry I have a final request. I use Dalans facelift and quickreply. Now I like to move the new box like this:

[]http://www.dragonclan-forum.de/move.jpg[/]

How I do it ? I m not so good in hacking templates All what I can say it must be done in ubbt_instant_ubbcode.tmpl I hate tables

Zarzal could you post a attachment of updated file.. please.
Thanks

here it comes ... just rename to .php and edit the dbmanes inside

Thank you very much. I needed to change the prefix on the database to nothing on mine but very happy to have this working.

Great idea guys and thanks to all that helped create this one.

Zarzal have you modified the html to show the box where you want?

Intead of this that I say

<br />
<table width="350" cellpadding="1" cellspacing="1" class="tablesurround">
<tr>
<td>
<table cellpadding="4" cellspacing="1" width="100%" class="tableborders">
<tr>
<td valign="top" class="tdheader">
<center><b>Photos</b>
</td>
</tr>
<td align="center" class="lighttable">
<br /><a href="javascript:void(0)" onclick="openPhotoPanel()">Insert My Photos into Post</a><br /><br />
</td>
</tr>
</table>
</td>
</tr>
</table>

In the instant ubbcode template

Do something like this

Find this:

<table border="0"><tr><td class="tdheader">
<b>{$ubbt_lang['INST_GRAEMLIN']}</b>
</td>
<td valign="top" class="tdheader">
<b>{$ubbt_lang['INST_UBB']}</b>
</td>
<td valign="top" class="tdheader">
<b>{$ubbt_lang['FONT_COLOR']}</b>
</td>
</tr>

Change it to this:

<table border="0"><tr><td class="tdheader">
<b>{$ubbt_lang['INST_GRAEMLIN']}</b>
</td>
<td valign="top" class="tdheader">
<b>{$ubbt_lang['INST_UBB']}</b>
</td>
<td valign="top" class="tdheader">
<b>{$ubbt_lang['FONT_COLOR']}</b>
</td>
<td valign="top" class="tdheader">
<center><b>Photos</b>
</td>
</tr>

Then find this:

</table>
</td>
</tr>
</table>

and replace it with something like this:

</table>
</td>
<td valign="top">
<table border="1">
<tr>
<td align="center" class="lighttable">
<br /><a href="javascript:void(0)" onclick="openPhotoPanel()">Insert My Photos into Post</a><br /><br />
</td>
</tr>
</table>
</td>
</tr>
</table>

Thanks, right now I finished it on myself. Du some other modifications and the facelift I encounter some missing tags and fix my template. Thanks anyway.

this is a great add on, I like it.

Zarzal, Photos, NOT Photo's ......

That's the original text from Omegatron But I see he change it.

Chuck,
Ok, I am running seperate batabases with the same passwords.
I got this:
$data_dir = "http://www.qualityfishing.net/gallery" ;

My query now looks like this:
}
mysql_select_db ("proguide_gallery")or die("Could not select database");
$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";
$result = mysql_query($query);
$sth = $dbh -> do_query($query);
$numrows = $dbh -> total_rows($sth);

if ( $numrows < 16 ) $nextpage = 0;

$i=0;
$color = "lighttable";
$photorow="";
$photopanel="";
mysql_select_db ("proguide_forum")or die("Could not select database");

I sill get the same error everyone else way getting.
So as you told me I added to the top of the file and have this:
require ("main.inc.php");
// configure your database settings
$host = "localhost"; // Vertexhost
$user= ""; // ??????
$password= ""; // ?????
$database=""; // proguide_gallery or proguide_forum


Still the error message. What am I missing???

I m not sure if you just post an example with:

// configure your database settings
$host = "localhost"; // Vertexhost
$user= ""; // ?????? <- databaseusername for PP
$password= ""; // ????? <- pwd for this user
$database=""; // proguide_gallery or proguide_forum

but you have to fill it out with your settings. This is needet for my board, running 2 seperatet DB's with the same username and password.

sample:
$host = "localhost"; // Vertexhost
$user= "mydbusername"; // ?????? <- databaseusername for PP
$password= "pwdofuser"; // ????? <- pwd for this user
$database="proguide_gallery"; // proguide_gallery or proguide_forum


after this you need to set the following for creating a first time contact to the PP_DB:

// Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ("I cannot connect to the database.");

The rest seems to be correct. Just take my example tha I attach some messages above and edit it to reflect your account settings. It should work.

yep, I have it as this:

$host = "localhost"; //
$user= "thisismydbusername"; //
$password= "thisismydbpassword"; //
$database="proguide_gallery"; //

No go. I made it this:

$host = "localhost"; //
$user= "thisismyusername"; //
$password= "thisismypassword"; //
$database="proguide_gallery"; //
// Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ("I cannot connect to the database.");

Still no go. ; (

any ideaa??

Steelhead,

As long as your database supports the mysql_select_db thing you should be able to add the same user permissions from your forum to your gallery database. That would be the easy thing add that mysql user to the proguide_gallery database and then change the query in pppanel.php to this

mysql_select_db ("proguide_gallery")or die("Could not select database");
$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";
$result = mysql_query($query);
$sth = $dbh -> do_query($query);
$numrows = $dbh -> total_rows($sth);

Hi,

It seems that if you have multiple (catagory) folders in your data (picture) directory it doesn't know which one to pick for the users of the board if you put in a /"proper folder" it doesn't work the only way I could get it working was to delete all but the bb users folder and use the path to data without the /. Can this be fixed ? I also had to put the database name in manually in a few places because it was hard coded in, is there a mod for that or is that wat you intended?

Jersey,

You are correct you do not need to place a / at the end. No big deal but what is all this it doesnt know what folder to pick

$imgurl = "[img]{$data_dir}/$ppcat/{$user['U_Number']}{$photo_name}-med{$theext}[/img]";

The above is the default photopost format

data/whichcat/usernumberphotonameextention

[]Omegatron said:
Jersey,

You are correct you do not need to place a / at the end. No big deal but what is all this it doesnt know what folder to pick

$imgurl = "[img]{$data_dir}/$ppcat/{$user['U_Number']}{$photo_name}-med{$theext}[/img]";

The above is the default photopost format

data/whichcat/usernumberphotonameextention [/]

Ok, I'll try to get you to understand.. :-)

first just as a note you have a conflict in your directions. In the directions it says no slash and in the comments on the php after the path it says to put a slash (or vice-versa) can't remember without looking. It was the same on this sites download and also the other you posted it on.

OK, to the meat of the problem:

My path "www.The-Jersey-Devil.com/photopost/data" is were the bb users photos are (in the "500" sub folder) and folder "501" is where another catagories photo's are (I had to remove the 501 catagory for it to work).

Both the 500 folder and the 501 folder are created by photopost when the catagory is created. I tried www.The-Jersey-Devil.com/photopost/data/500 and I get "blank pics" in the select image screen when trying to add a pic to the post. If you look at the path of the "blank" thumb pics it shows the path is pointing at the 501 folder ??. So I tried "www.The-Jersey-Devil.com/photopost/data/500/" and still no go.

Anyway I need several differant catagories and the only way it wil work is with JUST the 500 folder inside the data folder. If you put the 501 back it trys to pull the images from there.

The only way I got it to work was with the path:
"www.The-Jersey-Devil.com/photopost/data" and only leaving the "500" sub folder in there if the 501 was ther no go.

If I extend the path to:
"www.The-Jersey-Devil.com/photopost/data/500" it won't work.


If the 501 folder is in there with this path:
"www.The-Jersey-Devil.com/photopost/data" it won't work.

Hope that explains it



Thanks

I had a similar issue the problem was solved by selecting a chmod value of 2777 so that files would inherit the group and not apache since I use SU-EXEC on that virtual Server. what would happen is the folder would get made but no files would move into it. one problem I did notice is that it appears that you may need to fix the permissions every time you create a new category (for the category folder) so that the files inherit properly. This is most likely because of the way I have my server set up but since I am admin and can get to the directories and modify them easily and it is not a big issue for me.

[]Pappy said:
I had a similar issue the problem was solved by selecting a chmod value of 2777 so that files would inherit the group and not apache since I use SU-EXEC on that virtual Server. what would happen is the folder would get made but no files would move into it. one problem I did notice is that it appears that you may need to fix the permissions every time you create a new category (for the category folder) so that the files inherit properly. This is most likely because of the way I have my server set up but since I am admin and can get to the directories and modify them easily and it is not a big issue for me. [/]

I'm running Win 2003 Server, does this still apply ? Keep in mind the folders work properly and the catagories work well, the files move into them fine. Just the hack doen't when ther is another folder in the data folder.

Thanks

Jersey,

This hack does not care about what cat they are in.

you need to set your data_dir to this

$data_dir = "http://www.the-jersey-devil.com/photopost/data";


It pulls the photos based on userid. The cat variable is inherited from the query

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";

Sounds to me like you have some server issues.

If you look at how the image is displayed you will see what I mean.

It takes your data path and appends the cat number on it and then appends the userid and file name

That is how photopost stores information.

[]Omegatron said:
Jersey,

This hack does not care about what cat they are in.

you need to set your data_dir to this

$data_dir = "http://www.the-jersey-devil.com/photopost/data";


It pulls the photos based on userid. The cat variable is inherited from the query

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";

Sounds to me like you have some server issues.

If you look at how the image is displayed you will see what I mean.

It takes your data path and appends the cat number on it and then appends the userid and file name

That is how photopost stores information. [/]

I was just going to post this reply, it seems that if the catagory is created after the hack it works... OR it just decided to start working on it's own.. I did reboot and it is windows

Either way Thank you very much...

This is a wonderfull mod and the help in getting it working was second to none...

NEXT page won't work. I've sat starring at this for hours. I can't figure out why "Next Page" won't work, can someone help please.

here it is..

<?
// Popup Graemlin Panel
//
// Copyright David Lozier 2003. All Rights reserved.
//
// This software may be used and modified freely provided that
// the copyright notice remains intact at the head of the file.
//
// This software may NOT be distributed without expressed written
// consent from the author.
//
// The author accepts no liability for any loss or damages whatsoever
// incurred directly or indirectly from the use of this software.
// The author of this software makes no claims as to its fitness for
// any purpose whatsoever. If you wish to use this software you
// should first satisfy yourself that it meets your requirements.
//
// Email: [][email protected][/]
// URL: http://www.chattersonline.com

// configure your database settings
$host = "localhost"; // Server Name
$user= "edited-out"; // Username
$password= "edited-out"; // Password
$database="the_jersey_devil"; // Photopost database name or forum database name

// Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ("I cannot connect to the database.");

require ("main.inc.php");

$pp_prefix="photopost_";
$data_dir ="http://www.the-jersey-devil.com/photopost/data"; //URL of your photo dir where those jpeg stored (with no / at end)

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

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

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

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

return( $retval );
}

$userob = new user;
$user = $userob -> authenticate();

$StyleSheet= $user['U_StyleSheet'];
$Status = $user['U_Status'];
$ubbt_language = ${$config['cookieprefix']."w3t_language"};

if (empty($ubbt_language)) { $ubbt_language = $config['language']; }

require ("$thispath/languages/$ubbt_language/instant_markup.php");

if (empty($StyleSheet) || ($StyleSheet == "usedefault") ) {
$StyleSheet = $theme['stylesheet'];
}

$theme['css_wrapper'] = $StyleSheet;
$myLang = "<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />";
$styleLink = "<link rel="stylesheet" href="{$config['styledir']}/$StyleSheet.css" type="text/css" />";

$html = new html;
list($tbopen,$tbclose) = $html -> table_wrapper();

if ( !isset($page) || $page == 0 ) {
$page = 0;
$nextpage = 1;
$prevpage = -1;
}
else {
$nextpage = $page + 1;
if ( $page > 1 ) $prevpage = $page - 1;
else $prevpage = 0;

$page = ($page*16);
}

mysql_select_db ("the_jersey_devil")or die("Could not select database"); //name of the photopostdb here

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user['U_Number']} ORDER BY date DESC LIMIT $page,16";
$result = mysql_query($query);
$sth = $dbh -> do_query($query);
$numrows = $dbh -> total_rows($sth);

if ( $numrows < 16 ) $nextpage = 0;

$i=0;
$color = "lighttable";
$photorow="";
$photopanel="";

mysql_select_db ("the_jersey_devil")or die("Could not select database"); //name of the ubbthreadsdb here

while (list($ppid, $ppcat, $pptitle, $photo, $medsize) = $dbh -> fetch_array($sth)) {
if ( is_image($photo) ) {
$photolen = strlen($photo);
$theext = get_ext($photo);
$photo_name = str_replace( $theext, "", $photo );

if ( $medsize > 0 ) $imgurl = "[img]{$data_dir}/$ppcat/{$user['U_Number']}{$photo_name}-med{$theext}[/img]";
else $imgurl = "&#091;img&#093;{$data_dir}/$ppcat/{$user['U_Number']}$photo&#091;/img&#093;";

$mthumb = "<img border="0" src="{$data_dir}/{$ppcat}/{$user['U_Number']}{$photo_name}-thumb{$theext}" alt="" />";

$photorow .= <<<EOF
<td width="25%" align="center" valign="middle" class="$color">
<a href="javascript:void(0)" onclick="updatePost(' $imgurl')">$mthumb</a>
</td>
EOF;

$i++;
if ($i==4) {
$i=0;
$photopanel .= "<tr>$photorow</tr>";
$photorow = "";
$color = $html -> switch_colors($color);
}
}
}
if (!empty($photorow)) {
$photopanel .= "<tr>$photorow";
}

if ($numrows == 0 && $page == 0) {
$photopanel .= <<<EOF
<td colspan="4" align="center" valign="middle" class="$color">You have no images in your PhotoPost gallery.</td>
</tr>
EOF;
}
elseif ($i==1) {
$photopanel .= <<<EOF
<td width="25%" align="center" valign="middle" class="$color">
</td>
<td width="25%" align="center" valign="middle" class="$color">
</td>
<td width="25%" align="center" valign="middle" class="$color">
</td>
</tr>
EOF;
}
elseif ($i==2) {
$photopanel .= <<<EOF
<td width="25%" align="center" valign="middle" class="$color">
</td>
<td width="25%" align="center" valign="middle" class="$color">
</td>
</tr>
EOF;
}
elseif ($i==3) {
$photopanel .= <<<EOF
<td width="25%" align="center" valign="middle" class="$color">
</td>
</tr>
EOF;
}

echo <<<UBBTPRINT
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>PhotoPost Panel</title>
$myLang
$styleLink
<script language="JavaScript" type="text/JavaScript">
function updatePost(GraemlinCode) {
BodyVal = opener.document.replier.Body.value;
opener.document.replier.Body.value = BodyVal + GraemlinCode;
}
</script>
</head>
<body>
$tbopen
<tr>
<td align="left" colspan="4" class="tdheader">
Instant PhotoPost
</td>
</tr>
$photopanel
</tr>
<tr>
<td colspan="2" class="lighttable">
UBBTPRINT;

if ( $prevpage != -1 ) echo "<< <a href="pppanel.php?page=$prevpage">PREV PAGE</a>";

echo <<<UBBTPRINT
</td>
<td colspan="2" class="lighttable" align="right">
UBBTPRINT;

if ( $nextpage > 0 ) echo "<a href="pppanel.php?page=$nextpage">NEXT PAGE</a> >>";

echo <<<UBBTPRINT
</td>
</tr>
<tr>
<td colspan="4" class="lighttable" align="center">
<a href="#" onclick="javascript:window.close();">close window</a>
</td>
</tr>
$tbclose
</body>
</html>
UBBTPRINT;


?>

Jersey the next page function works just fine. You can PM me a user that has more than 16 photos to check out but I assume you probally have a browser or java problem which causes the page not to refresh.

Thanks Chuck, I sent you them..

Just wanting to keep this in thread.. Still can't get the next page thing working, chuck looked at it also.

Thanks Chuck I do appreciate the effort. I'll keep staring at it and maybe it will make sense why it won't work, I know you said you had it working elswhere so it's possible. Now I just have to find a good book on php I am a total newbee to php @ sql but the longer I stare at the stuff the more sense it starts to make.

Being I'm new to this and all I'm not sure but I would think any hacks that are used credit should be given to there respective authors somewhere on the bb, is this so and where do they usually get put?

Scott

Just to clarify the problem:
When you click "next page" the page "refreshes" but the same pictures are displayed. They do not change to the next 16 pictures in the album. So it seems to be a query thingy (yea i'm an newbee)...

My tipp is that it's a problem with global variables.
I assume you've turned register globals off, what is the default value in newer php-versions.

Try to add this to the top of the ppanel.php:

$page = get_input("page","get");

THANK YOU !.... so much, IT WORKS ! I was up for hours for the last few days. I will post the final working copy as it is on my Windows 2003 server... YEA... I love this hack. It makes the bb so much better.

I appreciate everyones time. Hopefully I can contribute over in the futre..

Just a quick question, am I correct in assuming this line

$ubbt_language = ${$config['cookieprefix']."w3t_language"};

should be changed to the actual database prefix i'm using as in:

$ubbt_language = ${$config['cookieprefix']."photopost_language"};

(seems to work either way ?)

If i'm WAY off base take it easy on me..

$ubbt_language = ${$config['cookieprefix']."w3t_language"};

is the correct use.

Thanks Chuck..

Here's the pppanel.php as I have it working on a Windows server 2003 and the most current version of threads and photopost.

Hope this helps someone in the future.

see attachment. You must rename it from .txt to .php

Scott

This is the best damn mod I've ever seen... oh yes...

hehe

/*captain kirk

I.... need... photopost
got.....to...get.....photopost

captain kirk*/