UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods UBBthreads and PhotoPost PHP integrated index v2

Oh my your making my day. A new version of Photopost to play with soon and finally Reviewpost HMM I am gonna be busy.

I assume your sticking with 3.3 being the CSS version with templates coming later in like 3.4? At least thats what I remember on our last conversation.

I'm having one problem with this integration.

I only employed part of the hack. On my Threads board, I have a row of photos that says, "The latest photos added to our Photo Gallery". There, I call the 5 latest pics that have been uploaded, and the hack works fine.

I'd like to restrict these pics to the 5 latest photos uploaded from one specific gallery. However, when I try to edit the hack to list the gallery id (in my case, 503), I end up getting an error (the page stops loading after the "5 latest pics" title). I assume the line of code where I'm having problems is the one that reads:

$forcats = "";

I can't figure out what I'm doing wrong. I just insert the category number inside the quotes, right?

Coy,

You can thank JoshPet for this fix. The code was missing a farther defining. It needs the following peice of code in there.

BELOW this:

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


ADD THIS:

if ($forcats) {
$forcats = "AND cat = '$forcats'";
}


I already tested this and it works great. Kudos to Josh.

Coy can't seem to get away from me.

LOL

Yes well what would alot of people do around here without you to help them out

[]

Coy can't seem to get away from me. [/]

Thank goodness!

Thanks to Josh (and everyone involved) for the fix. I'll go give it a try now.

I never did get back here to comment that this fix still doesn't work for me. If I try to specify a category, I end up with no photos displaying at all. I've tried a bunch of different category numbers with no success.

Also, I just noticed that My Optional Stats box doesn't display all the stats it should. Currently, it says:

599 Registered User(s).; threads and page views.
324 photos posted with 22,536 page views.

You can see it's missing the total number of threads and page views. Have I set a path incorrectly? I tried to install the mod again using the most recent version in this thread, but the same thing happens.

Thanks, as always

http://www.iyarilimon.com/ubbthreads/ubbthreads.php

Coy,

Try this it works as I am using this on my site
if ($forcats) {
$forcats = "AND cat = '$forcats'";
}

Then as far as the most version of this hack. You forgot the first step! Your right though Michael's hack has this left out. I had to tweak a few things. There is a query you have to add to ubbthreads.php Check the hack and install the part in that file for the stats to show.

The most recent rendition of this hack is on page four.

Here is the code from the hack you need to add that your missing.

In Ubbthreads.php after:

// ---------------------
// Grab the tablewrapper
list($tbopen,$tbclose) = $html -> table_wrapper();

add this:

$sth = $dbh->do_query("
SELECT COUNT(B_Topic), SUM(B_Counter)
FROM {$config['tbprefix']}Posts
GROUP BY B_Topic
ORDER BY B_Topic
");
list($num_replies, $num_threads, $num_thread_views) = array(0, 0, 0);
$num_rows = $dbh->total_rows($sth);
if ($num_rows >= 1) {
list($num_replies) = $dbh->mysql_fetch_row($sth);
if ($num_rows >= 2) {
list($num_threads, $num_thread_views) = $dbh->mysql_fetch_row($sth);
}
}
$dbh->finish_sth($sth);
$num_posts = $num_threads + $num_replies;

Omegatron << Then as far as the most version of this hack. You forgot the first step! >>

You are absolutely correct -- I had neglected the ubbthreads.php portion of this mod. Unfortunately, now that I've added it (and verified that I've included the recent fix for displaying particular categories), it still isn't working.

As you know, I've had problems with other aspects of Photopost when mods are concerned. For now, I'll chalk this up to quirks of my system, and ask Josh to do some investigative work for me while he works on my elusive "table wrappers" issue.

Hi All,

It has been a while since I actively added anything here, but this hack has a serious !!! security issue in it.

I will not post it here but I should be very carefull in applaying it as it gives others some most usefull info.

I sended a PM to omegatron about it.

Best Regards,
Boris

That is just so weird. All the thing in ubbthreads.php is a query to get the totals. The defined output is called in the table in the template. I tell you YOU AND PHOTOPOST have issues.

Boris it isnt my hack but I have modified the version here of mine on page 4 with a fix for this security hole. I have emailed the main author of this program to place this fix on all of his sites and his version of the hack as well.

Thanks for the heads up.

Although one can see the MYSQL password info. If everyone sets their host to localhost which everyone does anyway there is no way for them to use the information they can see. However it is best to move that into a PHP file which I did and then set a require statement in the template to use such said file.

[]Coy,

Try this it works as I am using this on my site
if ($forcats) {
$forcats = "AND cat = '$forcats'";
}

Then as far as the most version of this hack. You forgot the first step! Your right though Michael's hack has this left out. I had to tweak a few things. There is a query you have to add to ubbthreads.php Check the hack and install the part in that file for the stats to show.
[/]

Omegatron.... my fix doesn't work if you want to list more than one category like this:

$forcats = "511,507,522";


Modify the code like this:

if ($forcats) {
$forcats = "AND cat in ($forcats)";
}


That will allow for multiple categories to be included.

Coy's problem was that she was listing the main categories... which had no photos.... you have to list the category number of the subcategory which actually has the photos.

LOL I thought I pasted the new code in their. To many freaking files. I do know it works though as I am using it

Anybody encounter and fix the issue with Username changes in UBBT, which does not change the username in Photopost?

I allowed several name changes and now have users wanting to re-upload ther same photos under their new name.

Thanks

Mike,

Try this fix and you should be set.

Okay at line 1067 find this code:

if ( $Globals['vbversion'] == "w3t6" ) {
$profilelink = "{$Globals['vbulletin']}/showprofile.php?Cat=&User=$tusername&Number=$tuserid";
$postreply = "<font color="{$Globals['headfontcolor']}" face="{$Globals['mainfonts']}" size="{$Globals['fontmedium']}"><b>Post a Reply</b></font>";
}
else {
$profilelink = "{$Globals['vbulletin']}/showprofile.php?Cat=&user=$tusername";


REPLACE WITH:

if ( $Globals['vbversion'] == "w3t6" ) {
$profilelink = "{$Globals['vbulletin']}/showprofile.php?Cat=&User=$tuserid";
$postreply = "<font color="{$Globals['headfontcolor']}" face="{$Globals['mainfonts']}" size="{$Globals['fontmedium']}"><b>Post a Reply</b></font>";
}
else {
$profilelink = "{$Globals['vbulletin']}/showprofile.php?Cat=&user=$tuserid";

Chuck,

Thanks for the quick response.

That fix allows me to interact with the UBBT DB from PP, but I don't know that it will correct the underlying issue...
- Username "AA" establishes a member gallery and photos are referenced as "Member: AA"

- User AA changes display name to "BB" in UBBT

- Photopost gallery still refernces "Member: AA".

The link in PP will bring you to the correct member profile in UBBT, but the point is that the photos in PP are referencing another name than what the user is now displaying.

As I do this.... I remembered that I chose to access the UBBT DB through PP, but I use a seperate MySql DB for PP. I thought using a seperate MySql would be easier if I ever had to split the UBBT and PP onto different servers due to high demands.

Mike

Give me a few to look through the files and see what I can find out.

I had to make a slight change to this section to get the right numbers to show up.

Cool you are the php guru

I can't wait till you upgrade to 6.2 so we can finally get the lightbulbs to work right.

You need this piece in the ubbthreads.php and the light bulbs will work. Notice the addition on U_Number and the assignment of $UserID

Sweet!!

Knew it was something simple. You the man!!