Hi. I've got this installed and ALMOST working...
you can see what happens here: http://www.stevetenebrini.com
the latest images shows up as text and the text links successfully to the photoblog but a thumbnail never shows up. What am I missing?
This is what my code looks like:
<?php
/*
Plugin Name: Pixelpost Latest Photo
Plugin URI: http://www.raminia.com/weblog/wp-hacks
Description: Using <?php show_latest_pixelpost_thumbnail() ?> in Wordpress (inside index.php of wordpress1.2 and e.g. inside sidebar.php of wordpress1.5), shows the latest image from your Pixelpost photoblog in the wordpress blog. Similar to latest photo, <?phpshow_random_pixelpost_thumbnail()?> will show the random thumbnails from pixelpost. Compatible with Pixelpost version 1.3 or higher.
Author: Ramin Mehran
Version: 1.1
Author URI: http://weblog.raminia.com
*/
/* Installation:
// 0) upload this plugin to Wordpress plugin folder <main folder>/wp-content\plugins
and the Edit this part: */
// 1)
// Relative address of Pixelpost main directory on the local server to the main address of the wordpress directory:
// for example: if your blog is placed at
// "/public_html/blog/"
// and you photoblog is placed at
// "/public_html/photoblog/"
// the relative address will be:
// "../photoblog/"
//
// Don't forget the tailing slash '/'
//
$PixelPost_local_address = "pixelpost/";
// 2)
// URL address of the Pixelpost photoblog (do not miss the trailing "/" )
$PixelPost_URL = "http://www.stevetenebrini.com/";
// 3)
// set number of photos to show on wp
$num_thum_toshow = 1;
$num_rand_thum_toshow = 1;
/* 4)use <?php show_latest_pixelpost_thumbnail(); ?> in your wordpress weblog when you want the latest thumbnail appear */
/* use <?php show_random_pixelpost_thumbnail(); ?> where you want to the random thumbnails appear */
/* Stop Editing if you don't know php and you did not changed the name of index.php
of the Pixelpost photoblog. */
//-------------------------------------------------------------------------------------
$main_file_name = "pixelpost/index.php"; // name of the main page of your photoblog. If you didn't change it intentionaly it's "index.php"
// Global
Global $pixelpost_image_thumbnail;
Global $pixelpost_rand_image_thumbnail;
$pixelpost_rand_image_thumbnail ='';
$pixelpost_image_thumbnail ='';
if (strpos ($_SERVER['PHP_SELF'],'wp-admin')) // check if the script is running in the admin menu
{
// if in admin menu change the relative address slightly from what is at the top
$PixelPost_local_address = "pixelpost/" .$PixelPost_local_address;
}
// save the address of the pixelpost database settings
$pixelpost_settings_address = $PixelPost_local_address ."includes/pixelpost.php";
if (file_exists($pixelpost_settings_address))
{
require($pixelpost_settings_address);
// book a visitor
$host = $_SERVER['HTTP_HOST'];
$referer = $_SERVER['HTTP_REFERER'];
/* start up mysql */
$pixepost_DB_link = mysql_connect($pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass) ;
if (mysql_error()) {
$pixelpost_rand_image_thumbnail .= "Error in DB connect: ".mysql_error()."<br/>";
$pixelpost_image_thumbnail .= "Error in DB connect: ".mysql_error()."<br/>";
}
mysql_select_db($pixelpost_db_pixelpost) ;
if (mysql_error()) {
$pixelpost_rand_image_thumbnail .= "Error in DB select: ".mysql_error()."<br/>";
$pixelpost_image_thumbnail .= "Error in DB select: ".mysql_error()."<br/>";
}
// if PHP 4.2+
//mysql_select_db($pixelpost_db_pixelpost,$pixepost_ DB_link) || die("Error: ". mysql_error());
// get config
if($cfgquery = mysql_query("select * from ".$pixelpost_db_prefix."config")) {
$cfgrow = mysql_fetch_array($cfgquery);
$upload_dir = $cfgrow['imagepath'];
$tz = $cfgrow['timezone'];
$datetime = gmdate("Y-m-d H:i:s",time()+(3600 * $tz));
$cdate = $datetime; // for future posting
} else {
$pixelpost_rand_image_thumbnail .= "<br/>pixelpost does not seem to be installed yet.";
$pixelpost_image_thumbnail .= "<br/>pixelpost does not seem to be installed yet.";
// echo "pixelpost does not seem to be installed yet.";
//exit;
}
// Get number of photos in database
$photonumb = mysql_query("select count(*) as count from ".$pixelpost_db_prefix."pixelpost where datetime<='$datetime'");
$row = mysql_fetch_array($photonumb);
$pixelpost_photonumb = $row['count'];
// Get Current Image.
$query = mysql_query("select * from ".$pixelpost_db_prefix."pixelpost where datetime<='$cdate' order by datetime DESC limit 0,$num_thum_toshow");
if (mysql_error())
$pixelpost_image_thumbnail .= 'MySQL Error: '.mysql_error(). ' ';
$rcounter = 0;
while($row = mysql_fetch_array($query)) {
$rcounter++;
//$row = mysql_fetch_array($query);
if(!$row['image']) {
echo "Coming Soon (query fail)!";
//exit;
}
$image_name = $row['image'];
$image_title = pullout($row['headline']);
$image_id = $row['id'];
$image_datetime = $row['datetime'];
$image_datetime_formatted = strtotime($image_datetime);
$image_datetime_formatted = date($cfgrow['dateformat'],$image_datetime_formatted);
$image_category = $row['category'];
$image_date = substr($row['datetime'],0,10);
$image_time = substr($row['datetime'],11,5);
$image_date_year_full = substr($row['datetime'],0,4);
$image_date_year = substr($row['datetime'],2,2);
$image_date_month = substr($row['datetime'],5,2);
$image_date_day = substr($row['datetime'],8,2);
//changed by ramin
$image_notes = pullout($row['body']);
if (file_exists($PixelPost_local_address ."thumbnails/thumb_$image_name")){
list($local_width,$local_height,$type,$attr) = getimagesize($PixelPost_local_address ."thumbnails/thumb_$image_name");
$pixelpost_image_thumbnail .= "<a href='" .$PixelPost_URL .$main_file_name ."?showimage=$image_id'><img src='" .$PixelPost_URL ."thumbnails/thumb_$image_name' alt='$image_title' title='$image_title' width='$local_width' height='$local_height' /></a>";
}else $pixelpost_image_thumbnail .= "[".$image_name."]";
} // end while
// Get random image
$query = mysql_query("select * from ".$pixelpost_db_prefix."pixelpost where datetime<='$cdate' order by rand() asc limit 0,$num_rand_thum_toshow");
if (mysql_error())
$pixelpost_rand_image_thumbnail .= 'MySQL Error: '.mysql_error(). ' ';
$rndcounter = 0;
while($row = mysql_fetch_array($query)) {
$rndcounter++;
//$row = mysql_fetch_array($query);
if(!$row['image']) {
echo "Coming Soon (query fail)!";
//exit;
}
$image_name = $row['image'];
$image_title = pullout($row['headline']);
$image_id = $row['id'];
$image_datetime = $row['datetime'];
$image_datetime_formatted = strtotime($image_datetime);
$image_datetime_formatted = date($cfgrow['dateformat'],$image_datetime_formatted);
$image_category = $row['category'];
$image_date = substr($row['datetime'],0,10);
$image_time = substr($row['datetime'],11,5);
$image_date_year_full = substr($row['datetime'],0,4);
$image_date_year = substr($row['datetime'],2,2);
$image_date_month = substr($row['datetime'],5,2);
$image_date_day = substr($row['datetime'],8,2);
//changed by ramin
$image_notes = pullout($row['body']);
if (file_exists($PixelPost_local_address ."thumbnails/thumb_$image_name")) {
list($local_width,$local_height,$type,$attr) = getimagesize($PixelPost_local_address ."thumbnails/thumb_$image_name");
$pixelpost_rand_image_thumbnail .= "<a href='" .$PixelPost_URL .$main_file_name ."?showimage=$image_id'><img src='" .$PixelPost_URL ."thumbnails/thumb_$image_name' alt='$image_title' title='$image_title' width='$local_width' height='$local_height' /></a>";
}else $pixelpost_rand_image_thumbnail .= "[".$image_name."]";
} // end while
if ($rndcounter<1)
$pixelpost_rand_image_thumbnail .= 'Warning Nothing is fetched from db!';
if ($rcounter<1)
$pixelpost_image_thumbnail .= 'Warning Nothing is fetched from db!';
// close db connection IF PHP4.2+
/*
if ($pixepost_DB_link) {
mysql_close($pixepost_DB_link );
}
*/
//if PHP 4.2-
mysql_close();
mysql_connect( DB_HOST,DB_USER,DB_PASSWORD);
mysql_select_db(DB_NAME);
} else{
$pixelpost_rand_image_thumbnail = "Error: pixelpost.php is not accessable. Error in PixelPost_local_address=$PixelPost_local_address.";
$pixelpost_image_thumbnail = "Error: pixelpost.php is not accessable. Error in PixelPost_local_address=$PixelPost_local_address.";}
// ################################################## ########################################//
// functions
// ################################################## ########################################//
function show_latest_pixelpost_thumbnail()
{
// Gloabal
Global $pixelpost_image_thumbnail;
echo $pixelpost_image_thumbnail;
}
function show_random_pixelpost_thumbnail()
{
Global $pixelpost_rand_image_thumbnail;
echo $pixelpost_rand_image_thumbnail;
}
function clean($string) {
//$string = utf8_encode($string);
$string = addslashes($string);
return $string;
}
function pullout($string) {
$string = stripslashes($string);
//$string = utf8_decode($string);
//$string = nl2br($string);
return $string;
}
?>