[DjTaz]

Hi All,

Its late and Im tired and stumped ....

I'm trying to get the photos from my Coppermine gallery onto the top of the Vbadvanced page (it could be any VB Page) - between the navbar and the columns.

I have this code and i know it works to get the photos - and i have that saved as coppermine.php - and i have a require_once('coppermine.php'); in the VBA index file under the require_once('global.php'); - If i put an echo on the coppermine.php file it outputs what i want , but im not sure how to send the code to the VbA page under the navbar.

<?php

//***********************************//
//          ** SETTINGS **           //
//***********************************//

$coppath = 		"gallery";  			// PATH TO YOUR GALLERY FROM THE CRANDOM FILE
$hostname = 	"localhost"; 			// The Coppermine hostname - usually localhost
$username = 	"username"; 	// Coopermine Database Username
$copperpass= 	"password";				// Password to the Coppermine database
$copperdb= 		"database";		// Coppermine database
$prefix= 		"cpg148";				// Coppermine Prefix
$amount= 		"6";					// Amount of photos to select

//***********************************//
//***********************************//



$MZrandompic = @mysql_connect($hostname, $username , $copperpass);
if (!$MZrandompic) { echo( '<p>Unable to connect to the database server at this time.</p>' ); exit(); }


if (! @mysql_select_db($copperdb) ) { die( '<p>Unable to locate the picture database at this time.</p>' ); }


$MZresult = @mysql_query("SELECT * FROM ".$prefix."_pictures ORDER BY RAND() LIMIT 0,$amount");
if (!$MZresult) { die('<p>Error performing query: ' . mysql_error() .'</p>'); }



while ( $MZrow = mysql_fetch_array($MZresult) ) { $pos = $MZrow['pid'];
$copphotos.='<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> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ';
}



////// WHAT DO I PUT HERE ??? ////


?>

Anyway - i want to know how to put the information outputted ($copphotos) under the navbar on that specific page - id appreciate some help.

I have tried doing an eval on the code and putting the string $copphotos under the $navbar text in the adv_portal template , but it didnt seem to want to work.

I'm prob only missing something small , so again any help would be appreciated.

I want to make a hack that will put the random photos under the navbar from coppermine - and thats part of the code.