Get Coppermine data under navbar

[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.

[calorie]

Try something like this:

$copphotos = '';
if (defined('VBA_PORTAL'))
{
	// stick your code in here
}

// next put the code in a plugin using hook global_start
// then use $copphotos in vBa templates under $navbar

// tweak to taste

[DjTaz]

Thanks Calorie , but the problem is more to figure out how to get the data from the php script (the variable $copphotos ) into the template.

I'm not really sure how to make it display or how to do the eval on it to make it show on a template.

It doesnt seem to want to display for me no matter what i try once its in a template - but if i do an echo on the original script it works ok.

[calorie]

Did you put the code in a plugin using the global_start hook?

[DjTaz]

Nope , ill give that a try in the morning when im more awake - its pointless doing things now , im way too tired - thanks for the help

Nope , i still cant get this working - I know im missing something , but im not sure what.

Basically - the coppermine.php file gets a variable called $copphotos and i cant seem to transfer that information into the forums.

An echo $copphotos on the coppermine.php file outputs exactly what i want , but i cant seem to figure out how to transfer that data into a VB template so it will output on a page ... i looked for some tutorials , but theres nothing specific to what i want that i can see ... i could do it on the older Vbb, but i dont think i was using vb standards.

----------------------------------------------
I think the issue here may be because im trying to do this on a VbAdvanced page , and it may be a bit different to a normal VB page

If i replace the ////// WHAT DO I PUT HERE ??? //// in the php code with

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_gallery_random') . '";');

the gallery photos go into the first column on the left and it seems to work ok , but i cant get it up to the very top just below the navbar full width.

I know im really close , but i cant figure it out.

[DjTaz]

-------------------------------------------------------


ok scrap all that - i figured it out eventually !!!