carbontwelve

My Final Code is this:

<?php

/*
Plugin Name: ZenGo
Plugin URI: https://www.photogabble.co.uk
Description: Displays the recent additions to the zenphoto gallery
Version: 0.5
Author: Simon Dann
Author URI: https://www.photogabble.co.uk
*/

function zenlatest ($max){
global $wpdb;
if ($max == "") { $max = 1; }

$zenimages = $wpdb->get_results("SELECT zen_images.filename AS filename, zen_images.desc AS file_desc, zen_album.folder AS folder, zen_images.title AS title FROM zen_images AS zen_images INNER JOIN zen_albums AS zen_album ON zen_album.id = zen_images.albumid WHERE zen_images.show =1 ORDER BY zen_images.id DESC LIMIT 0, ". $max ."");

foreach ($zenimages as $zenimage ) {
echo '<a href="/zenphoto/'. $zenimage->folder .'/'. $zenimage->filename . '"><img src="/zenphoto/'. $zenimage->folder .'/image/thumb/'. $zenimage->filename .'"></a>';
}

}

?>

Thanks Matt, i also forgot to add ARRAY_A

At least now its sorta working ??

Ok people, i didnt realise that you had to global $wpdb, well not until I ran though the sample code I got from the live archive plugin again.

Honest mistake to make I guess…

Bugs: “.$_SERVER[‘SERVER_NAME’].$_SERVER[‘ORIG_PATH_INFO’].” Wouldnt work on my server for the Plugin_UrlBuild function. I had to enter my url manualy. Has this been written for php5?

Found out how to turn off the thing that phased all my pages and put borders around my smiles by turning off the thing commenting out last line.
//add_filter(‘the_content’, ‘Plugin_Image’);
Because I dont need it…

plus the gallery doesnt accept the https://www.website.com/photography/galleryname/photoname arcetecture and just seems to try and go to https://www.website.com/?gallery_id=1 even when im calling from https://www.website.com/photography and where it should revert to https://www.website.com/photography/?gallery_id=1 at the very least. It would be better if it went for https://www.website.com/photography/1/ at the very least.

I shall try to fix the other issues im facing appart from the /photography/galleryname/imagename as im not sure how to work that. I shall also probably include some form of admin panel for changing the values so editing the php file isnt needed.

I really like the plugin, if the above where fixed and it didnt mess up the css of all my pages by putting boxes around all my images |: bad naughty plugin, then this would be perfect.

i just want the image gallery the rest of the functionality is useless to me…

oh sorry how very rude of me. I forgot to thankyou for the link, it has proved to of use.

the thing is i dont want to syndicate another gallery into my website, I want to use a plugin or similar that becomes part of the wordpress admin.

i could possibly write one if you wanted, not that i need it but it would give me somthing to do