Coppermine Random Photos on vBulletin FORUMHOME (easy)

This is basicaly the easiest way to have random photos from your Coppermine Gallery displayed on your vBulletin home page.
Tested and working perfectly. Here's the installation process containing only 3 steps.

Requirements : Coppermine Photo Gallery Installed.



Installation steps :

1. Download coppermine.php and edit the database info. After you're done, upload it in your forum root.


2. Open your vBulletin index.php file and under require_once('./global.php'); add the following line:

require_once('coppermine.php');

(save the changes > upload the file in the forum root)


3. Open your Style Manager ("Styles & Templates" in the AdminCP menu) and edit the FORUMHOME template.
Depending on where you want your random pictures to appear, you should paste this code eather under $navbar or <!-- end what's going on box -->.
The code you need to paste is:

 
<!-- / COPPERMINE GALLERY -->
<br>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
				<td class='tcat' colspan='0' align=left>
				<span class='smallfont'>
				<strong>&raquo; <a href='$coppath'>Gallery</a>
				</strong></span></td>
				</tr>

 				<tr>
 				<td class='alt1' width='100%' align-middle valign=middle>

$copphotos
</td></tr></table>
<!-- / COPPERMINE GALLERY -->

(Save the template.)



All done.
I know you like it -

Here's the live demo and some screenshots:

[Konstantinos]

i found a bug. it displays thumbs for uploaded pics that ARENT approved yet by the admin. any fix ?

[AcidX]

Originally Posted by Konstantinos

i found a bug. it displays thumbs for uploaded pics that ARENT approved yet by the admin. any fix ?

Are you sure about this?

[DjTaz]

Yes they are sure - the coppermine.php script isnt set to check for approvals , it just randomly checks all the files. Luckily i have a fix for that if you wish

change the code in coppermine.php line 27 from

$MZresult = @mysql_query("SELECT * FROM ".$prefix."_pictures ORDER BY RAND() LIMIT 0,$amount");

to

$MZresult = @mysql_query("SELECT * FROM ".$prefix."_pictures WHERE approved='YES' ORDER BY RAND() LIMIT 0,$amount");

and your in business again with only approved photos showing.

Anyone with VBadvanced , you can get the module for it here : https://vborg.vbsupport.ru/showthread.php?t=119432

[AcidX]

Bug fixed. Thanks Tazie!

I replaced the coppermine.php file. Everyone that installed this mod can download the new version now.

[Martin-TMGRS]

Does anyone know how to port this for VB3.6.3 ?? I've tried to put this on my forum and get this error.

Table 'db149830456.thread' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /index.php(64) : eval()'d code on line 746

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/46/d101530151/htdocs/mkportal/include/VB/vb_out.php on line 42

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/46/d101530151/htdocs/mkportal/include/mk_mySQL.php on line 57

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/46/d101530151/htdocs/mkportal/include/mk_mySQL.php on line 57

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/46/d101530151/htdocs/mkportal/include/mk_mySQL.php on line 57

Any ideas please and thanks in advance

[DjTaz]

Martin - only spotted this now - where exactly did you put this , and where does that error appear ? Is coppermine running ok on its own ?

A little more info is required to get this going please...

[Xbizcafe]

Originally Posted by Konstantinos

why the thumbnails in forum home are much smaller than the thumbs in coppermine home and how to fix this ?

I have same question. Who can help us ?

[DjTaz]

Originally Posted by Xbizcafe

I have same question. Who can help us ?

in the line that says

$copphotos.='<td><a target = "_parent" href="' . $coppath . '/displayimage.php?album=' . $albumid .
'&pos=-' . $pos . '"><IMG SRC="' . $coppath . '/albums/' . $MZrow['filepath'].thumb_.$MZrow['filename'] .'" alt=' . $MZrow['filename'] . ' '. 'border=0
height=60>' . '</a><b><br><font size=1>Uploader:</b><br><a href="member.php?u=' . $MZrow['owner_id'] . '">  ' . $MZrow['owner_name'] . '</a><br><font size=1> ' .$ctime. ' </td>';
}

of coppermine.php change the height=60 to the height you want- you get bigger or smaller

[Soliloquy]

I've installed this (thanks!) and it runs fine, but I'd love to get it to display in the left hand column. Any chance of that?

[DjTaz]

just paste the code into the right hand column tempate instead of forumhome and do the rest the same.

You want a <br> in somewhere to drop it down a line each time , but i dont have that hack so im not sure