445 lines
10 KiB
PHP
445 lines
10 KiB
PHP
<?php
|
|
|
|
// A plug-in for the Serendipity PHP blog (http://www.s9y.org) by Matthew Maude <s9y@risingdawn.org>
|
|
// Show recent/popular/random thumbnails from a Coppermine (http://coppermine.sourceforge.net) gallery
|
|
|
|
|
|
if (IN_serendipity !== true) {
|
|
die ("Don't hack!");
|
|
}
|
|
|
|
@serendipity_plugin_api::load_language(dirname(__FILE__));
|
|
|
|
class serendipity_plugin_coppermine extends serendipity_plugin
|
|
{
|
|
|
|
var $title = PLUGIN_CPGS_NAME;
|
|
|
|
function introspect(&$propbag)
|
|
{
|
|
global $serendipity;
|
|
|
|
$propbag->add('name',PLUGIN_CPGS_NAME);
|
|
$propbag->add('description',PLUGIN_CPGS_DESC);
|
|
|
|
$propbag->add('stackable', true);
|
|
$propbag->add('author', 'Matthew Maude');
|
|
$propbag->add('version', '1.4.1');
|
|
$propbag->add('requirements', array('serendipity' => '0.8'));
|
|
$propbag->add('groups', array('IMAGES'));
|
|
$propbag->add('configuration', array('cm_server','cm_prefix','cm_path','cm_title','cm_db','cm_user','cm_pass','cm_size','cm_count','cm_type','cm_plugin_title','cm_albumlink','cm_album','cm_gallerypath','cm_resolve'));
|
|
|
|
return true;
|
|
|
|
}
|
|
|
|
function introspect_config_item($name, &$propbag){
|
|
|
|
switch($name) {
|
|
|
|
case 'cm_resolve':
|
|
$propbag->add('type', 'boolean');
|
|
$propbag->add('name', PLUGIN_CPGS_THUMB_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_THUMB_DESC);
|
|
$propbag->add('default', 'true');
|
|
break;
|
|
|
|
case 'cm_type':
|
|
$propbag->add('type', 'radio');
|
|
$propbag->add('name', PLUGIN_CPGS_TYPE_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_TYPE_DESC);
|
|
$propbag->add('radio', array(
|
|
'value' => array('recent', 'random', 'popular'),
|
|
'desc' => array(PLUGIN_CPGS_RECENT, PLUGIN_CPGS_RANDOM, PLUGIN_CPGS_POPULAR)
|
|
));
|
|
$propbag->add('default', 'recent');
|
|
break;
|
|
|
|
case 'cm_plugin_title':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_TITLE_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_TITLE_DESC);
|
|
$propbag->add('default', 'My Images');
|
|
break;
|
|
|
|
|
|
case 'cm_server':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_SERVER_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_SERVER_DESC);
|
|
$propbag->add('default', 'localhost');
|
|
break;
|
|
|
|
case 'cm_db':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_DB_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_DB_DESC);
|
|
$propbag->add('default', 'coppermine');
|
|
break;
|
|
|
|
case 'cm_prefix':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_PREFIX_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_PREFIX_DESC);
|
|
$propbag->add('default', 'cpg132_');
|
|
break;
|
|
|
|
case 'cm_user':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_USER_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_USER_DESC);
|
|
$propbag->add('default', 'username');
|
|
break;
|
|
|
|
case 'cm_pass':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_PASSWORD_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_PASSWORD_DESC);
|
|
$propbag->add('default', 'password');
|
|
break;
|
|
|
|
case 'cm_path':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_URL_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_URL_DESC);
|
|
$propbag->add('default', 'http://gallery.com');
|
|
break;
|
|
|
|
case 'cm_gallerypath':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_GALLLINK_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_GALLLINK_DESC);
|
|
$propbag->add('default', 'http://gallery.com');
|
|
break;
|
|
|
|
case 'cm_title':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_GALLNAME_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_GALLNAME_DESC);
|
|
$propbag->add('default', 'More images...');
|
|
break;
|
|
|
|
case 'cm_count':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_COUNT_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_COUNT_DESC);
|
|
$propbag->add('default', '4');
|
|
break;
|
|
|
|
case 'cm_size':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_SIZE_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_SIZE_DESC);
|
|
$propbag->add('default', '100');
|
|
break;
|
|
|
|
case 'cm_album':
|
|
$propbag->add('type', 'string');
|
|
$propbag->add('name', PLUGIN_CPGS_FILTER_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_FILTER_DESC);
|
|
$propbag->add('default', '');
|
|
break;
|
|
|
|
case 'cm_albumlink':
|
|
$propbag->add('type', 'boolean');
|
|
$propbag->add('name', PLUGIN_CPGS_ALBUM_NAME);
|
|
$propbag->add('description', PLUGIN_CPGS_ALBUM_DESC);
|
|
$propbag->add('default', true);
|
|
break;
|
|
|
|
default:
|
|
return false;
|
|
|
|
}
|
|
|
|
return true;
|
|
|
|
}
|
|
|
|
function generate_content(&$title){
|
|
|
|
$title = $this->get_config('cm_plugin_title');
|
|
|
|
global $serendipity;
|
|
|
|
$dbserver = $this->get_config('cm_server');
|
|
$prefix = $this->get_config('cm_prefix');
|
|
$path = $this->get_config('cm_path');
|
|
$gallerypath = $this->get_config('cm_gallerypath');
|
|
$dbname = $this->get_config('cm_db');
|
|
$dbuser = $this->get_config('cm_user');
|
|
$dbpass = $this->get_config('cm_pass');
|
|
$size = $this->get_config('cm_size');
|
|
$count = $this->get_config('cm_count');
|
|
$gallery = $this->get_config('cm_title');
|
|
$resolve = $this->get_config('cm_resolve');
|
|
|
|
$type = $this->get_config('cm_type');
|
|
$cm_title = $this->get_config('cm_plugin_title');
|
|
|
|
$album = $this->get_config('cm_album');
|
|
$albumlink = $this->get_config('cm_albumlink');
|
|
|
|
$filter = '';
|
|
|
|
|
|
if (!empty($album)){
|
|
|
|
$show = array();
|
|
$hide = array();
|
|
|
|
$ids = preg_split('/[\s,]/',$album,-1,PREG_SPLIT_NO_EMPTY);
|
|
foreach ($ids as $id){
|
|
|
|
if (preg_match('/^!/',$id) && is_numeric(substr($id,1))){
|
|
|
|
$hide[] = substr($id,1);
|
|
|
|
} else if (is_numeric($id)){
|
|
|
|
$show[] = $id;
|
|
|
|
}
|
|
|
|
}
|
|
|
|
if (count($show) || count($hide)){
|
|
|
|
$filter = ' WHERE aid ';
|
|
|
|
if (count($show)){
|
|
$filter .= 'IN (';
|
|
$c = 0;
|
|
foreach ($show as $id){
|
|
$filter .= $id;
|
|
if ($c < count($show)-1) $filter .= ',';
|
|
++$c;
|
|
}
|
|
$filter .= ') ';
|
|
if (count($hide)) $filter .= ' AND aid ';
|
|
}
|
|
|
|
if (count($hide)){
|
|
$filter .= 'NOT IN (';
|
|
$c = 0;
|
|
foreach ($hide as $id){
|
|
$filter .= $id;
|
|
if ($c < count($hide)-1) $filter .= ',';
|
|
++$c;
|
|
}
|
|
$filter .= ') ';
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
switch($type) {
|
|
|
|
case 'random':
|
|
$order = 'RAND()';
|
|
break;
|
|
|
|
case 'popular':
|
|
$order = 'hits DESC';
|
|
break;
|
|
|
|
case 'recent':
|
|
default:
|
|
$order = 'pid DESC';
|
|
break;
|
|
|
|
}
|
|
|
|
|
|
//if ($cm_title != "") $title = $cm_title;
|
|
|
|
|
|
$DB = @mysql_connect($dbserver, $dbuser, $dbpass);
|
|
|
|
if (!$DB) {
|
|
echo 'Unable to connect to the database server<br>';
|
|
return;
|
|
}
|
|
|
|
if (! @mysql_select_db($dbname,$DB) ) {
|
|
echo 'Unable to locate the picture database<br>';
|
|
$this->finished($DB);
|
|
return;
|
|
}
|
|
|
|
$query = "SELECT * FROM " . $prefix . "pictures " . $filter . " ORDER BY " . $order . " LIMIT 0," . $count;
|
|
|
|
$result = @mysql_query($query,$DB);
|
|
if (!$result){
|
|
echo 'Error performing query: ' . mysql_error() . '<br>';
|
|
$this->finished($DB);
|
|
return;
|
|
}
|
|
|
|
?>
|
|
|
|
<style type="text/css">
|
|
<!--
|
|
|
|
<?php
|
|
|
|
readfile(dirname(__FILE__).'/styles.css');
|
|
|
|
?>
|
|
|
|
-->
|
|
|
|
</style>
|
|
|
|
<div class="cm_block">
|
|
|
|
<?php
|
|
|
|
$defthumbnail = $serendipity['serendipityHTTPPath'].'plugins/serendipity_plugin_coppermine/none.jpg';
|
|
|
|
if ($resolve){
|
|
$file = @fopen($path.'/images/thumb_nopic.jpg',"r");
|
|
if ($file){
|
|
fclose($file);
|
|
$defthumbnail = $path.'/images/thumb_nopic.jpg';
|
|
} else {
|
|
$file = @fopen($path.'/images/nopic.jpg',"r");
|
|
if ($file){
|
|
fclose($file);
|
|
$defthumbnail = $path.'/images/nopic.jpg';
|
|
}
|
|
}
|
|
}
|
|
|
|
while ( $row = mysql_fetch_array($result) ) {
|
|
|
|
echo '<div class="cm_cell">
|
|
';
|
|
|
|
$albumid = $row['aid']; //This gets the picture's associated album name
|
|
$pos = $row['pid']; //This finds the picture's coppermine location
|
|
|
|
$width = $row['pwidth'];
|
|
$height = $row['pheight'];
|
|
|
|
if (!isset($row['pwidth']) || empty($row['pwidth']) || $row['pwidth'] <= 0 ||
|
|
!isset($row['pheight']) || empty($row['pheight']) || $row['pheight'] <= 0){
|
|
|
|
$defimage = '<a href="' . $path . '/displayimage.php?album=' . $albumid . '&pos=-' . $pos . '">' .
|
|
'<img src="' . $defthumbnail . '" title="' . $row['filename'] . '" alt="' . $row['filename'] . '" class="cm_thumbnail" style="width:' . $size . 'px; height:' . $size . 'px;"></a>';
|
|
|
|
if ($resolve){
|
|
|
|
if (preg_match("/[^\\.]+$/i",$row['filename'],$matches)){
|
|
|
|
$ext = strtolower($matches[0]);
|
|
$guess = $path.'/images/thumb_'.$ext.'.jpg';
|
|
$file = @fopen($guess,"r");
|
|
if ($file){
|
|
fclose($file);
|
|
echo '<a href="' . $path . '/displayimage.php?album=' . $albumid . '&pos=-' . $pos . '">' .
|
|
'<img src="' . $guess . '" title="' . $row['filename'] . '" alt="' . $row['filename'] . '" class="cm_thumbnail" style="width:' . $size . 'px; height:' . $size . 'px;"></a>';
|
|
|
|
} else echo $defimage;
|
|
|
|
} else echo $defimage;
|
|
|
|
} else echo $defimage;
|
|
|
|
} else {
|
|
|
|
$aspect = $width / $height;
|
|
|
|
if ($aspect >= 1){
|
|
|
|
$width = $size;
|
|
$height = floor($size / $aspect);
|
|
|
|
$hpad = 0;
|
|
$vpad = floor(($width - $height) / 2);
|
|
|
|
} else {
|
|
|
|
$width = floor($size * $aspect);
|
|
$height = $size;
|
|
|
|
$vpad = 0;
|
|
$hpad = floor(($height - $width) / 2);
|
|
|
|
}
|
|
|
|
echo '<a href="' . $path . '/displayimage.php?album=' . $albumid . '&pos=-' . $pos . '">' .
|
|
'<img src="' . $path . '/albums/' . $row['filepath'] . thumb_.$row['filename'] . '" title="' . $row['filename'] . '" alt="' . $row['filename'] . '" class="cm_thumbnail" style="padding: '.$vpad.'px '.$hpad.'px '.$vpad.'px '.$hpad.'px;" width="' . $width . '" height="' . $height . '"></a>';
|
|
|
|
}
|
|
|
|
if ($albumlink){
|
|
|
|
$albumresult = @mysql_query("SELECT * FROM " . $prefix . "albums WHERE aid = '" . $albumid . "'",$DB);
|
|
|
|
if (!$albumresult) {
|
|
echo 'Error performing query: ' . mysql_error() . '<br>';
|
|
$this->finished($DB);
|
|
return;
|
|
}
|
|
|
|
while ( $albumname = mysql_fetch_array($albumresult) ) {
|
|
|
|
echo '<div class="cm_info"><a href="' . $path . '/thumbnails.php?album=' . $albumid . '">' . $albumname['title'] . '</a></div>';
|
|
|
|
}
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
</div>
|
|
|
|
<?php
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
<?php
|
|
|
|
if (!empty($gallerypath)){
|
|
|
|
?>
|
|
|
|
<div class="cm_gallery">
|
|
<a href="<?php echo $gallerypath; ?>"><?php echo $gallery; ?></a>
|
|
</div>
|
|
|
|
<?php
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
</div>
|
|
|
|
<?php
|
|
|
|
$this->finished($DB);
|
|
|
|
}
|
|
|
|
function finished(&$db){
|
|
|
|
global $serendipity;
|
|
|
|
mysql_close($db);
|
|
|
|
$serendipity['dbConn'] = mysql_connect($serendipity['dbHost'], $serendipity['dbUser'], $serendipity['dbPass']);
|
|
mysql_select_db($serendipity['dbName']);
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
?>
|