Hi there,

I've just installed zenphoto and (partially) integrated it into my wordpress site with skins. It works beautifully on its own. Everything displays correctly.

However, on my homepage I want to also include some images from zenphoto. Unfortunately, when I use

define('WEBPATH', 'zenphoto');
require_once(WEBPATH . "/zp-core/template-functions.php");

I get "MySQL Error: Zenphoto could not connect to the database server.Check your zp-config.php file for the correct host, user name, and password.Note that you may need to change the host from localhost if your web server uses a separate MySQL server, which is common in large shared hosting environments like Dreamhost and GoDaddy.Also make sure the server is running, if you control it."

I have checked zp-config.php multiple times and it is indeed correct. I feel pretty confident saying it's correct because when I visit my normal zenphoto gallery, everything works. It's just when I try to include the template functions on another page that it goes bananas.

I've spent about an hour googling and poking at the thing and nothing seems to work. Any thoughts?

You have not told us what the structure of your site is. For instance, is Zenphoto installed in the <web root>/zenphoto folder?

Sorry, this is a known issue that the "zenphoto as a plugin" way sadly simply does s not work with Wordpress anymore. We were also not able to solve that as we don't know what and why Wordpress seems to override the db connection.

We solved that on zenphoto.org by using some custom Wordpress template functions to get the info directly without using Zenphoto functions (on the download page for the latest images for the screenshots, themes and showcase)-

On our extensions section there are also some Wordpress plugins to help.

To sbillard: Yes, that is where it is. Wordpress is also in the root, although not in a folder.

To acrylian: Interesting! I'm glad I didn't spend too much more time struggling with this, then. Do you have an example of these custom functions somewhere that you could link me to? The code itself, I mean. I will check out the plugins... All the ones I've seen so far work in posts, but not in templates, which is where I really need to work it in. I'll poke around somemore.

Thanks for your replies.

We have the same setup on zenphoto.org. We actually would like to find out why that including does not work but are stuck as we don't really know where to look right now.

Sorry, I don't have a link to those functions as I did them directly for our specific use to get the latest images directly from the zenphoto cache (I was too lazy to implement any image processing). I will take a look later if I maybe can generalize them a little.

That would be an ENORMOUS help. It'd be great to at least have a place to jump off from.

Here we go: http://www.zenphoto.org/trac/attachment/wiki/ZenphotoPlugins/get-latest-zp-image-for-wp.zip
It is really basic, gets only one image as it was meant for that and has just quickly generalized. You will probably have to adjust and modify it a great deal for your purpose.

Hi Acrylian,

I've used your function to display latest images on index page of my wordpress website, but for a strange reason I get this error:

Query failed : Table 'morarte_zigu_test.zp_albums' doesn't exist

It seems that the function opens the DB of my wordpress installation and not the DB of Zenphoto Gallery installation, BUT I've made the right connection parameters in order to connect to the right DB...

Do you have any idea?

Thank you as ever..

Dimitri

Do you really first used the function to connect to the database of Zenphoto and then the one for the latest image? Double, triple check the db details. It is working on our site although in a modified version.

As I did...

code in the function.php

`
<?php

/* * Connect to the Zenphoto database on a Wordpress template file.*/

$conf['mysql_user'] = 'xxxxx';
$conf['mysql_pass'] = 'xxxxxx';
$conf['mysql_host'] = 'localhost'; // Won't need to change this 90% of the time.
$conf['mysql_database'] = 'xxxxxx';

function connectZenphotoDB($host,$user,$pass,$db) {
// mysql connection
$mysqlcon = @mysql_connect($host,$user,$pass);
if(!$mysqlcon) {
die("Could not connect - Query failed : " . mysql_error());
}
if(!@mysql_select_db($db)) {
die("db could not be selected - Query failed : " . mysql_error());
}
}

/**
* Print the thumb of the latest image of an album from the zenphoto image cache directly on a Wordpress page template file.
* This function does not do any image processing!
*
* This assumes Wordpress is installed in the root and Zenphoto within a folder $zenphotopath.
*
* @param string $albumname folder name of the album (note subalbums names contain the parents!: toplevel/sub)
* @param string $zenphotopath the path to the Zenphoto installation with trailing slash (/zenphoto)
* @param string $albumsdbtable the albums table, don't forget the prefix!
* @param string $imagesdbtable the images table, don't forget the prefix!
*/
function printLatestZenphotoImageFromAlbum($albumname="Nuova Cartella",$zenphotopath="http://www.ziguline.com/gallery",$albumsdbtable="zp_albums",$imagesdbtable="zp_images") {
$albumid = "";

// getting the id of the album chosen
$albumquery = "SELECT [code][/code]id[code]FROM[/code]".$albumsdbtable."[code]WHERE[/code]folder[code]= '".$albumname."' ORDER BY[/code]id
`
DESC";
$albumresult = mysql_query($albumquery) or die("Query failed : " . mysql_error());
$albumid = mysql_fetch_row($albumresult);
$albid = $albumid[0];
$title = "";
$folder = $albumname;

// getting latest image from the album
$imagequery = "SELECT `filename`,`title`,`desc` FROM `".$imagesdbtable."` WHERE `albumid` = ".$albid." ORDER BY `id` DESC LIMIT 1";
$imageresult = mysql_query($imagequery) or die("Image query failed : " . mysql_error());
$image = mysql_fetch_row($imageresult);
//echo "Latest image: "; print_r($image); echo "";
$imagename = explode(".",$image[0]);
// echo "Image: ".$imagename[0]." / suffix: ".$imagename[1];
// if "showcase" use title of latest images else the one of the latest album of this section
$title = $image[1];

// print the image from Zenphoto's image cache if it exists, else print a replacement one from the theme
// The file name must exactly fit, so be sure to change the "w238_h128_cw238_ch128" part to the actual dimensions
// of your thumbs in the cache or implement some image processing here
if(file_exists($zenphotopath.'cache/'.$folder.'/'.$imagename[0].'_w238_h128_cw238_ch128_thumb.'.$imagename[1])) {
echo '<img src="'.$zenphotopath.'cache/'.$folder.'/'.$imagename[0].'_w238_h128_cw238_ch128_thumb.'.$imagename[1].'" alt="'.$title.'" />';
} else {
// if no image in the cache has been found load a fixed replacement image, show a message or whatever else
echo "Sorry, no image found in cache...";
}
}
define('DEBUG_ERROR', true); // set to true to supplies the calling sequence with zp_error
?>

and then in the index.php of my theme:

`<?php printLatestZenphotoImageFromAlbum();?>`

You first have to call `connectZenphotoDB()` with your db details. It does not do anything by itself...

You are right!

now I'm struggling with the right name of image in the cache ; )

Thank you.

Have a nice Christmas Time!

Dimitri

Well, yeah, it's just a hacked workaround until we hopefully find out why the "plugin way" does not work anymore.

How to modify so that I can get some n number of latest pics not from a album but latest images from overall gallery? I can't figure out since I have no experience of coding.

Any help?

Sorry, you will have to learn a few things to do it yourself. You will understand that I can't do that for you.

Ok...I have found a proper WP Plugin...will try to fork it to work according to my needs.

Hi all, I have the same problem.

If I just call template-functions.php

`require_once(WEBPATH . "/zp-core/template-functions.php");`

it's ok, but, if I call it in some function, f.e.:

`
function init()
{
require_once(WEBPATH . "/zp-core/template-functions.php");
}
init();
`
I have "MySQL Error: Zenphoto could not connect to the database server." message. Why?

p.s. sorry for my english.

You can't place function definitions within function definitions...

Which means you must do the `require+once()` outside of the function otherwise the functions it defines are not available outside that function itself.