Working Thumbincluder... Please?

[dbabaev]

Can someone give me a working version of the Thumbincluder? I have VB 3.0.1, PhotoPost PHP 4.8 RC 3, and vBadvanced CMPS v1.0 RC2. All I want a random thumb on my home page...

I've looked all over and tried many things but no luck... I would really appreciate it. www.russianpimp.com

[dbabaev]

come on, anyone?

[attroll]

This is my attempt at trying to explain how to do this for you. I did it and have it working in one of my sites. So I know it works. You will have to use thumbincluder11 on your site to get this to be used on your front page for latest photos if your using CMPS...

If I missed something our it does not work I will try and explain it and get it working for you. But I can not promise because I do not know what mods you have installed in your site that may interfear with it.

1. Make the changes in the thumbincluder11.php that is included with this message using a editor. It would not let me attach the thumbincluder as a PHP file so once you download it you will have to rename it to a PHP extension. Right now it is TXT.

You will have to change the following lines:

$host = "localhost";        //Server Name
$user= "";                 //Username
$password= "";             //Password
$database="";             //Photopost database name or forum database name
//Display Setting (Changes to fit your page)
$q_switch = "latest";            // "random" or "most_views" or "latest" 
$limit = 2;                        //number of image to show
$table_width = "100%";            //width of the table generated
$column = 2;                    //number of columns of the table generated
$photo_cell_align = "center";    //alignment of those cells

2. After you have made these changes put the file "thumbincluder11.php" in the gallery directory.

3. Go into your ADMINCP template “PHP Include Code Templates/phpinclude_start” and insert the code below. You will have to make some changes to it to match your web site address .

Posted the following in my phpinclude_start template:

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

4. Create a new template in you ADMINCP and call it “adv_portal_thumb”.
In that table put this code:

<!-- thumbnail --> 
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center"><tr><td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
<td class="tcat"> 
<center><b>Latest Pictures</b></center>
</td>
</tr>
<tr><td width="100%" class="alt1">$postthumbnail 
</td></tr></table> 
</td></tr></table>
<!-- /thumbnail -->

5. Still in your Admincp - vBa CMPS - Add Module

- Module Title - Thumbincluder
- Module Identifier - Leave blank
- OR Template to Include - thumb
- Activate and select the column you want it in.
- Save and you are done.

[allandk]

Query failed !!

[teksigns]

anyway to keep this line of code from running unless the main page is loaded .

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

[allandk]

i found the error.. i had prefix in my db name, and it was missing in the code )

[teksigns]

Originally Posted by teksigns

anyway to keep this line of code from running unless the main page is loaded .

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

im assuming this will work ..... correct?

if (defined('VBA_PORTAL')){
$postthumbnail = implode("", file("http://www.yoursite.com/photopost/thumbincluder11.php"));
}

[Fargo]

another thing that ive come across -

If you've installed Photopost into your vBulletin database and have assigned a prefix to your photopost tables, you will need to modify EVERY select statement in this thumbnailincluder file.

For example, In my installation of Photopost, I had it give its tables a prefix of "PP_".
All select statements for category must be changed to PP_category and select statements for photos must be changed to PP_photos.

examples:

SELECT id FROM categories WHERE parent='$cat' ORDER BY catorder ASC
must be changed to
SELECT id FROM PP_categories WHERE parent='$cat' ORDER BY catorder ASC

SELECT id,user,userid,cat,title,bigimage,views FROM photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY RAND() DESC LIMIT $limit";
must be changed to
SELECT id,user,userid,cat,title,bigimage,views FROM PP_photos WHERE bigimage!='' AND approved='1' $exclude_cat ORDER BY RAND() DESC LIMIT $limit";

Easiest thing to do is do a search and replace because there are several statements to alter.

[Fargo]

btw teksigns,
your code worked perfectly, thank you very much for sharing it.

[banjolawyer]

Thanks for the work. I modified the adv_portal_thumb template so that the Title line for the module would be the same as other vbadvanced modules.

PHP Code:

<!-- thumbnail --> 
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center">
<tr>
<td>

<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
<td class="tcat"> 
<span class="smallfont"><b>$vba_options[portal_blockbullet] Latest Photo Gallery Uploads</b></span>
</td>
</tr>
<tr><td width="100%" class="alt1">$postthumbnail 
</td></tr></table> 
</td></tr></table>
<!-- /thumbnail --> 


[banjolawyer]

The change is just changing

PHP Code:

<center><b>Latest Pictures</b></center> 


to

PHP Code:

<span class="smallfont"><b>$vba_options[portal_blockbullet] Latest Photo Gallery Uploads</b></span> 


[Kesomir]

I found that this also doesn't seem to stripslashes (thats the \ before any ")from the picture name. (Actually neither do the photopost ones - odd huh), so I changed the code to fix this;

Find lines 229-233;

PHP Code:

         print "<br>".$line["title"]."<br>".$line["views"]." views";   
         print "</a><br></font></div><br>";
   } else {
         print "<br>".$line["title"];  
         print "</a><Br>by ".$line["user"]."</font></div><br>"; 


Change to this;

PHP Code:


         print "<br>".stripslashes($line["title"])."<br>".$line["views"]." views";   
         print "</a><br></font></div><br>";
   } else {
         print "<br>".stripslashes($line["title"]);  
         print "</a><Br>by ".$line["user"]."</font></div><br>"; 


Hope that helps.

[Ted S]

Seeing how this template goes into the regular php start file am I to assume this script runs every time any vb file is loaded even if the module is not called?

[Kesomir]

Ted, not if you use teksigns small code change above, then it should only be run when a portal page is called.

[gemfsb]

hi

thank you very much for the code

would you pls tell what the word for the popular photo?
($q_switch = "random"; ) what should i put for popular.

thank you

[Ted S]

Wonderful addon and thanks to everyone for contributing even more changes/features!

[gemfsb]

what if I want only the popular photos to display ?

should I write just "popular" instead of "random" is this word modified to the code.

[gemfsb]

update

[gemfsb]

comeon guys, no one knows?

[Kesomir]

gemfsb, the one for popular is;

$q_switch = "most_views";