Plogger Image Gallery Integration

[keekwai]

I,ve installed Plogger on my server and temporarily have it fetched into an iFrame in an empty module index.php file.

Link .. ajarnmark.com/gallery.html

I have Plogger installed in a folder in my root directory called "gallery"

DF is also installed in the root.

It works OK ... but I'd rather do it the way Plogger wants me to ... but I have no idea how to insert their script. Here are the instructions.

Code::

To integrate Plogger into your website, place the following PHP statements in the .php file you wish display the gallery in: First line of the .php file -> <?php require("plogger.php"); ?> In the HEAD section -> <?php the_plogger_head(); ?> In the BODY section where you want the gallery - <?php the_plogger_gallery(); ?>

N.B "plogger.php" is in root/gallery/plogger.php

Is there a way to insert that into a module index.php or maybe a Content page?

[Kendle]

In your empty module index.php file ...

Code::

if (!defined('CPG_NUKE')) { exit; } require("gallery/plogger.php"); global $modheader; ob_start(); the_plogger_head(); $modheader .= ob_get_contents(); ob_end_clean(); require('header.php'); the_plogger_gallery();

possibly ... dunno, try it

[keekwai]

No. That doesn't work. I get this error

Code::

Fatal error: Call to undefined function OpenTable() in /home/ajarnmar/public_html/includes/cmsinit.inc on line 710

This is the state of th index.php so far.

Code::

<?php /** * CPG Dragonfly CMS * Copyright © 2004 - 2006 by CPG-Nuke Dev Team, dragonflycms.org * Released under the GNU GPL version 2 or any later version * $Id: index.php,v 1.4 2006/10/07 07:54:11 nanocaiordo Exp $ */ // protect against direct access if (!defined('CPG_NUKE')) { exit; } require("gallery/plogger.php"); global $modheader; ob_start(); the_plogger_head(); $modheader .= ob_get_contents(); ob_end_clean(); require('header.php'); the_plogger_gallery(); // close the table that we have created // there isn't any need to include the footer, as the index page handles this already // require('footer.php');

[Kendle]

Line 710 of cmsinit.inc is within the cpg_error() function, so something went wrong but it fell over trying to tell you what it was, which isn't very helpful.

Maybe, temporaily, comment out line 710 in cmsinit.inc so at least you get to see the real error message before it falls over.

[keekwai]

No go there .. just an error about the line being commented out and a database error

Code::

A database error has occurred The webmaster has been notified of the error [ Home ] [ Go Back ] Fatal error: Call to undefined function CloseTable() in /home/ajarnmar/public_html/includes/cmsinit.inc on line 714

[Kendle]

Hopefully you (as webmaster presumably) will receive an email telling you what the exact error is, but at least we now know it's a database error.

(and as your psuedo module isn't doing any database calls it's probably in plogger)

[keekwai]

Here's the email I received ...

Code::

On /gallery.html While executing query "SELECT COUNT(*) FROM cms_session WHERE uname='343c5500b29a3b632b27ce1ddac12158'" the following error occured: Table 'ajarnmar_gallery.cms_session' doesn't exist In: /home/ajarnmar/public_html/header.php on line: 44

Plogger only has 6 tables in a separate database called "ajarnmar_gallery"

Code::

plogger_albums plogger_collections plogger_comments plogger_config plogger_pictures plogger_thumbnail_config

Looks like it's looking for a DF table ????

[Kendle]

My guess is that plogger has taken over the connection to the database, so that when DF tries to access it's tables it's now connected to plogger's database rather than its own.

You could try putting plogger's tables in your DF database, or, in gallery/plog-includes/plog-functions.php change line 516 from this :-

Code::

$PLOGGER_DBH = mysql_connect(PLOGGER_DB_HOST, PLOGGER_DB_USER, PLOGGER_DB_PW) or die(plog_tr('Plogger cannot connect to the database because: ').mysql_error());

to this :-

Code::

$PLOGGER_DBH = mysql_connect(PLOGGER_DB_HOST, PLOGGER_DB_USER, PLOGGER_DB_PW, true) or die(plog_tr('Plogger cannot connect to the database because: ').mysql_error());

This should tell plogger to establish it's own separate connection to the database rather than hyjack the connection DF had previously established.

[keekwai]

Making progress now. I tried the file edit on plog-functions.php first. Same problem.

I changed it back and tried the database option and moved the Plogger tables into the DF database and edited Plogger's "plog-config.php"

... and that works! ... Sort of. See here .. Link ajarnmark.com/gallery.html

Everything is at the bottom of the page. I'm still using the index.php above in the Module folder. i.e

Code::

<?php /** * CPG Dragonfly CMS * Copyright © 2004 - 2006 by CPG-Nuke Dev Team, dragonflycms.org * Released under the GNU GPL version 2 or any later version * $Id: index.php,v 1.4 2006/10/07 07:54:11 nanocaiordo Exp $ */ // protect against direct access if (!defined('CPG_NUKE')) { exit; } require("gallery/plogger.php"); global $modheader; ob_start(); the_plogger_head(); $modheader .= ob_get_contents(); ob_end_clean(); require('header.php'); the_plogger_gallery(); // close the table that we have created // there isn't any need to include the footer, as the index page handles this already // require('footer.php');

[keekwai]

OK .. I had a Google ad in Ploggers header.php. I removed that and now it looks OK ... but the links are wrong.

When I click on an album .. the link is ...

Code::

http://ajarnmark.com/index.php?level=collection&id=2

...instead of ...

Code::

http://ajarnmark.com/gallery/index.php?level=collection&id=2

It's going to DF's Index instead of Ploggers.


Link .. ajarnmark.com/gallery.html

NOTE: It seems Ploggers css is taking over a little too. The titles in my blocks have changed from white to blue.

EDIT. I just altered Ploggers css .. so that's OK now. But the linking is still broken.

[Kendle]

In gallery/plog-config.php there's this directive :-

Code::

define('PLOGGER_EMBEDDED', '');

Might be an idea to change this to :-

Code::

define('PLOGGER_EMBEDDED', '1');

[keekwai]

OK .. tried that. No change. It's still pointing to the DF index.

[Kendle]

Well, last suggestion from me cos I've no further ideas after this one, turn off LEO.

If that doesn't work you're probably looking at asking someone to port plogger to make it a proper DF module, tho I question why you would do so when there's coppermine already in place (even tho coppermine is a bit of pig to be fair).

[keekwai]

It's just the cluttered ugly look of coppermine that gets me. I also don't need users being able to upload pics.

... but thanks for all the help so far. If I can't get it working this way I can always go back to the iFrame method. It looked OK. I just think iFrames are a bit of a sloppy way to go.

EDIT: Just turned LEO off .... IT WORKS! Dam! Thanks for that. Have a virtual beer on me!

[layingback]

keekwai wrote:

It's just the cluttered ugly look of coppermine that gets me. I also don't need users being able to upload pics.

If by "cluttered" and "ugly" you mean the imagery, then have you considered reDesign3 theme which simplifies the graphics used in coppermine immensely - and offers you easy control over changing them?

But if it is the general multiplicity of links that offends have you considered Pro_News to display the CPG albums? I added photo gallery support - 1 album per article configurable up to 32 images per page - expressly to address my concern over the "cluttered ugly look of coppermine". And it has the added advantage of permitting, optionally, text description alongside the images. Also user access to the displayed CPG album is not required at display time - meaning that on many of my sites CPG is not available at all. Here's an example.