TinyPortal

Quote from: YahMan on October 05, 2005, 01:56:48 AM
I've been trying to get this to work, but no luck so far.

Code Select Expand

AND aid <> 111 and owner_name='Carver'

I think it's got something to do with this, but what does it do?

Quote from: snork13 on November 05, 2005, 10:59:20 PM
Here is what i do to get coppermine gallery images into the portal, thought i would share.
Downloaded and install Coppermine Fetch (CPMFetch)  (http://coppermine-gallery.net/forum/index.php?board=57.0), and using a php block, add

Code Select Expand

//gallery block added
echo '<table class="tborder" border="0" width="158" cellspacing="0" cellpadding="4">
<tr><td width="100%" class="titlebg">'.$txt['portal_27'].'</td>
<tr><td class="windowbg2" width="100%" align="center">';
include "coppermine.php";
$objCpm = new cpm("/gallery");
echo ' <div align="left">';
$objCpm->cpm_formatStats("There are %f photos in the gallery <br><ul><li> %a members have albums <br><li> The gallery has beenÂÃ,  viewed %v times <br><li>%n members have commented on photos </ul>");
echo '</div>';
$objCpm->cpm_viewRandomMedia(1,1);
//$objCpm->cpm_close();
echo'</td></tr></table><br />';
thanks for sharing the portal bloc, it rocks and looks super!
-snork13
live demo for a limited time
www.phantasyposters.com/forum (http://www.phantasyposters.com/forum)
test/cpmfetch

Quote from: domp on November 21, 2005, 06:40:03 PM
set up your coppermine.php and put this in a block:

Code Select Expand

print "A random selection:<CENTER>";
include "../gallery/cpmfetch/coppermine.php";
$objCpm = new cpm("/gallery");
$objCpm->cpm_viewRandomMedia(1,1);
$objCpm->cpm_close();
print "</center>";

Sure works 4usÂÃ,  :-)

Quote from: gerrymo on December 11, 2005, 09:50:28 PM
No it doesnt need to be in the same directory. I have the three directories in root: smf, cpg (coppermine), and cpmfetch (Coppermine fetch). Using the code beow I have random images showing in a block on the front page.

Code Select Expand


print "A random selection from our Gallery:<CENTER>";
include "../cpmfetch/cpmfetch.php";
$objCpm = new cpm("/cpg");
$objCpm->cpm_viewRandomMedia(1,5);
$objCpm->cpm_close();
print "</center>";


(Line 4 denotes 1 row of 5 photos)

Quote from: crip on December 11, 2005, 10:02:31 PM
Hopeless

Quote from: crip on December 11, 2005, 10:02:31 PM
Hopeless

QuoteTrying to display some images:

Your installation seems correct so far, you should see a small grid of thumbnails from your gallery
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ynohtna/websites/elmira-anthony.ca/cpmfetch/cpmfetch_dao.php on line 710



If you do not see thumbnails, or get more warnings then something is pretty wrong. As long as you are using standard prefixes in Coppermine, you should see everything. If you are not using standard prefixes, then you need to adjust them by editing the first three variables in the cpmfetch.php file.

Quote//The following 3 entries can be adjusted if you are using non-standard prefixes in CPG   
   var $thumbnailprefix = "thumb_";
   var $intermedprefix = "normal_";      
   var $fullsizeprefix = '';   
   var $defaultimagesize = "thumb_";

QuoteÂÃ,  ##ÂÃ,  When calling this function, there are four variables you can set.
ÂÃ,  ##ÂÃ,  The number of pictures to display, last updated/random images,
ÂÃ,  ##ÂÃ,  where the Coppermine directory is (relative to where the file
ÂÃ,  ##ÂÃ,  that's calling this function, and the output method.

QuoteImpressive result Ray but I think the gallery it is not CPG.

Quotefunction ssi_CoppermineImages($num_pics = 5, $order = 'lastup', $wherescoppermine = 'coppermine/', $output_method = 'echo')
{
  ##  When calling this function, there are four variables you can set.
  ##  The number of pictures to display, last updated/random images,
  ##  where the Coppermine directory is (relative to where the file
  ##  that's calling this function, and the output method.
  ##
  ##  Default values are 5, 'lastup', 'coppermine/', 'echo'
  ##  If you need to skip a default value, use null.  For example, (null, 'random') displays 5 random
  ##  images.
  ##
  ##  The variable $wherescoppermine depends on where you are calling ssi_CoppermineImages from.
  ##  For example, my directory structure is like this:  root -> coppermine
  ##                                                     root -> smf
  ##  If I call ssi_Coppermine from a file located in root, the variable would be coppermine/
  ##
  ##  Here are a few examples:
  ##  To display 10 random images, you'd call: ssi_CoppermineImages(10, 'random');
  ##  To get the last 5 updated images into an array, you'd call: ssi_CoppermineImages(null,null,null,'return');

  if (is_null($wherescoppermine)) $wherescoppermine = 'coppermine/';
  if (is_null($order)) $order = 'lastup';
  if (is_null($num_pics)) $num_pics = 5;
  if (is_null($output_method)) $output_method = 'echo';

  $cpgtable = 'cpg132_';  // Change to your Coppermine table prefix
  $titlelen = 15; // Maximum number of letters displayed under the pictures

  $return = array();
  $cpgConfig = array();

  $result55 = db_query("
    SELECT extension, mime, content
    FROM {$cpgtable}filetypes", __FILE__, __LINE__);
  while ($row = mysql_fetch_array($result55))
    $file_types[$row['extension']] = $row;
  mysql_free_result($result55);

  $temp55 = db_query("
    SELECT *
    FROM {$cpgtable}pictures
    WHERE approved='YES'", __FILE__, __LINE__);
  $return['pic_total'] = mysql_num_rows($temp55);
  mysql_free_result($temp55);

  $temp55 = db_query("
  SELECT *
  FROM {$cpgtable}albums", __FILE__, __LINE__);
  $return['alb_total'] = mysql_num_rows($temp55);
  mysql_free_result($temp55);

  $temp55 = db_query("
    SELECT * FROM {$cpgtable}config", __FILE__, __LINE__); 
  while ($row55 = mysql_fetch_array($temp55))
  $cpgConfig[$row55['name']] = $row55['value'];
  mysql_free_result($temp55);

  $fullpath = $cpgConfig['fullpath'];
  $cpgpath = $cpgConfig['ecards_more_pic_target'];

  if ($order == 'lastup')
    $orderby = 'pid';
  else
    $orderby = 'RAND()';
   
  $request5 = db_query("
    SELECT pid, filepath, filename, filesize, title, aid
    FROM {$cpgtable}pictures
    WHERE approved='YES'
    ORDER BY $orderby DESC
    LIMIT $num_pics", __FILE__, __LINE__);

  $imagecounter = 0;
  $return['pictures'] = array();
  while ($row5=mysql_fetch_array($request5))
  {
    $imagecounter++;
    $filename = $row5['filename'];
    if (!is_array($filename))
      $filename = explode('.',$filename);
    $EOA = count($filename)-1;
    $filename[$EOA] = strtolower($filename[$EOA]);
    $mime_content = $file_types[$filename[$EOA]];

    $filepathname = null;
    $custom_thumb = null;
    $custom_thumb_path = $wherescoppermine.$fullpath.$row5['filepath'].'thumb_';

    if ($mime_content['content'] != 'image')
    {
      $thumb_extensions = Array('.gif','.png','.jpg');
      $file_base_name = str_replace('.'.$mime_content['extension'],'',basename($row5['filename']));
      foreach ($thumb_extensions as $extension)
      {
        if (file_exists($custom_thumb_path.$file_base_name.$extension))
        {
          $filepathname = $custom_thumb_path.$file_base_name.$extension;
          $custom_thumb = 1;
          break;
        }
      }
      if (is_null($filepathname))
      {
        foreach ($thumb_extensions as $extension)
        {
          if (file_exists($wherescoppermine.'images/thumb_'.$mime_content['extension'].$extension))
          {
            $filepathname = $wherescoppermine.'images/thumb_'.$mime_content['extension'].$extension;
            break;
          }
        }
      }
    }
    else
    {
      $filepathname = $custom_thumb_path.$row5['filename'];
    }
    if ($orderby == 'pid')
      $display = 'lastup&&cat=0&pos='.($imagecounter-1);
    else
      $display = 'random&&cat=0&pos=-'.$row5['pid'];

    $return['pictures'][] = array(
      'imagelnk' => $wherescoppermine.'displayimage.php?album='.$display,
      'imageurl' => $filepathname,
      'imagetitle' => (strlen($row5['title']) > $titlelen ? substr($row5['title'],0,$titlelen).'...' : $row5['title']) . ($mime_content['content'] != 'image' ? ($custom_thumb == 1 ? ($row5['title'] != '' ? '
' : '').'('.$mime_content['content'].', '.round($row5['filesize']/1024).'K)' : '
('.round($row5['filesize']/1024).'K)') : '')
    );
  }
  mysql_free_result($request5);
  if ($output_method == 'echo')
  {
    foreach($return['pictures'] as $pictures)
    {
      echo '
        <div class="div" style="float: left; width: 150px; height: 130px; text-align: center;">
        <a href="' . $pictures['imagelnk'] . '">
        <img src="' . $pictures['imageurl'] . '" height="100" width="100" border="0" alt="" /></a>

        <span style="font-size: x-small">'.$pictures['imagetitle'].'</span></div>';
    }
    echo '
     
<div style="clear: both;"></div>
      <span>The Gallery has ' . $return['pic_total'] . ' files in ' . $return['alb_total'] . ' albums.  You should go <a href="'.$wherescoppermine.'index.php">see</a> them!</span>';
  }
  else
  {
    return $return;
  }
}

Quote from: carver on February 20, 2006, 03:15:48 AM
You can pick your download for fetch here...
Coppermine Fetch (http://www.fistfullofcode.com/projects/copperminefetch/downloads.php)

Quote from: MetalHellsangel on February 20, 2006, 08:04:54 AM
I tried reading the documententation for the cpmfetch but I'm still a little confused, is there a way to show the filename under the file?,

t.y.i.a.,
Angel

Quote from: ÂÃ,»cripÂÃ,« on February 26, 2006, 11:51:59 PM
I use the 0.4 stable version of cpmfetch, I was having problems with that version so I swicth and everything works well now..

maybe you can try an earlier stable version will help?

Quote from: carver on September 22, 2005, 01:32:19 AM
Thought some of you might find a use for this script. It will pull a random photo from the coppermine photo gallery.
The code in red can be edited to suit your needs
<?php

include_once( '/home/bowfishi/public_html/gallery/include/config.inc.php');

db_connect() || die(mysql_error());

function db_connect()
{
         global $CONFIG;
         $result = @mysql_connect($CONFIG['dbserver'],
$CONFIG['dbuser'], $CONFIG['dbpass']);
         if (!$result)
                 return false;
         if (!mysql_select_db($CONFIG['dbname']))
                 return false;
         return $result;
}

$result = mysql_query("SELECT filename,filepath from cpg132_pictures WHERE
approved='YES' AND aid <> 111 and owner_name='Carver' ORDER BY RAND() DESC LIMIT 1");
$row = mysql_fetch_array($result);

$filename = 'thumb_' . $row['filename'];
$filepath = $row['filepath'];

Header('Location:http://www.mysite.com/gallery/albums/' . $filepath .
$filename);
exit;
?>


You can put this in an HTML block and call this script as an image.

Code Select Expand

<BODY>
<IMG src="http://www.mysite.com/random_pic.php">
</BODY>

Quoteprint "<CENTER>";

include "../cpmfetch/cpmfetch.php";
$objCpm = new cpm('/gallery');

$objCpm->cpm_viewLastAddedMedia (1,8,array("imagesize" => "Thumb","imageheight" => "75","imagewidth" => "75","windowtarget" => "_new","alttag" =>"From Album: %a Added: %w"));
$objCpm->cpm_close();
print "</center>";

Quote from: evillair on February 26, 2006, 11:14:10 PM
I finaly got this to work but it's only grabbing my uploaded images.
I've tried changing some of the values like it said in the readme but none of it works. Anyone else having this?

Here's what I am using. (Teck's code he posted, slighty changed)

Code Select Expand


echo '<div align="center">';
include "./cpmfetch/cpmfetch.php";
$objCpm = new cpm("/galleries/");

$objCpm->cpm_unlock_private(); /* <--I've tried setting this to (true) but it gives me errors.*/

echo ' <div align="left">';
echo ' <b>Stats</b><br>';
$objCpm->cpm_formatStats("Albums: <b>%a</b> <br> Images: <b>%f</b> <br> Hits: <b>%v</b><br><br>");

echo '</div><div align="left"><b>Random Reference</b><br>';
$options = array( 'subtitle' => 'Name: <b>%t</b><br> Author: <b>%o</b> <br> Here since <b>%D</b> days <br>' , "imagestyle" => "test1");
$objCpm->cpm_viewRandomMediaFrom ( 1, 1, $source = "", $options);

$objCpm->cpm_close();
echo'<p><a href="http://pixelmorgue.com/galleries/index.php?cat=8"><u>Photo References</u></a></p></div></div>';

I've went through all the setting making sure guest have access and that it reads from all categories but no luck.

Quote from: blink on July 13, 2006, 05:53:41 PM
here is my code, you can change the amount of thumbs to show.Ã,  It sound like a coppermine permissions issue though.

Quoteprint "<CENTER>";

include "../cpmfetch/cpmfetch.php";
$objCpm = new cpm('/gallery');

$objCpm->cpm_viewLastAddedMedia (1,8,array("imagesize" => "Thumb","imageheight" => "75","imagewidth" => "75","windowtarget" => "_new","alttag" =>"From Album: %a Added: %w"));
$objCpm->cpm_close();
print "</center>";

Quote from: Maya on November 18, 2006, 06:28:08 AM
Okay...almost there... installed cpmfetch, and used this code

Code Select Expand

print "<center>";
include "../cpmfetch/cpmfetch.php";
$objCpm = new cpm("/gallery");
$objCpm->cpm_viewRandomMedia(1,5,array("imagesize" => "Thumb","imageheight" => "78","imagewidth" => "104","windowtarget" => "_new","alttag" =>"From Album: %a Added: %w"));
$objCpm->cpm_close();
print "</center>";

Have the gallery coming in to an i-frame right now and it looks great, but when u click any of the pics in this block, it takes u to a new page of just the coppermine gallery.

Any way to make it call up the 'gallery' iframe page?

Quote from: auvn on December 15, 2006, 03:36:18 AM
everytime when I click on a random image,fetched from coppermine gallery to front page, a new window with coppermine gallery pop up. Is there anyway or code for use to allow you to go to the coppermine gallery framed in SMF without new pop-up window
thanks

Quoteecho "<CENTER>";
chdir("../gallery/cpmfetch/");
include "cpmfetch.php";                   
$objCpm = new cpm();
$objCpm->cpm_viewRandomMedia(2,1);
$objCpm->cpm_close();
chdir("../../");
echo 'View Gallery (http://pentaxworld.com/gallery)';
echo "</center>";

Quoteecho "<CENTER>";
chdir("../gallery/cpmfetch/");
include "cpmfetch.php";                   
$objCpm = new cpm();
$objCpm->cpm_viewLastAddedMedia(1,1);
$objCpm->cpm_close();
chdir("../../");
echo 'View Gallery (http://pentaxworld.com/gallery)';
echo "</center>";

Quote from: gerrymo

Code Select Expand


print "A random selection from our Gallery:<CENTER>";
include "../cpmfetch/cpmfetch.php";
$objCpm = new cpm("/cpg");
$objCpm->cpm_viewRandomMedia(1,5);
$objCpm->cpm_close();
print "</center>";


(Line 4 denotes 1 row of 5 photos)

Quote from: edifier on February 27, 2007, 07:05:08 PM
          Hello

    I'm still a newb and after reading this entire thread, didn't feel i was ready to tackle this yet. But was praying Fantastico would take care of all that for me :D

Quotejust need to get the pictures in order so they look decent

Quote from: SteveW on April 22, 2007, 10:39:37 PM
Hi - I can see it has been asked in this thread but I couldnt see a solution yet..

When someone clicks on the image (thumbnail) in tinyportal block, it loads coppemine without tinyportal header/footer etc (not wrapped)

Is there a solution for this or would it be to do with cpmfetch?

Quote from: khoking on April 24, 2007, 06:10:29 AM
I am having the same problem. When someone click on the image in my TP front page, it link to a double // in Coppermine Gallery, resulting the header of my Gallery not shown.

Quote from: SteveW on April 24, 2007, 06:31:31 PM
I would say that is a CPMfetch issue in the config file. Check the paths in the config file and remove the / and retry?

Quote from: fangweile on June 08, 2007, 05:39:38 AM
how to make the randoms photos from coppermine to show vertically instead of horizontally.

Quote from: RoarinRow on August 22, 2007, 01:44:36 AM
This code works for me just fine as far as displaying the pictures and no errors in the log. 

Code Select Expand

echo "<CENTER>";
chdir("../gallery/cpmfetch/");
include "cpmfetch.php";                  
$objCpm = new cpm();
$objCpm->cpm_viewRandomMedia(1,6,array("imageheight" => "75"));
$objCpm->cpm_close();
chdir("../../");
echo '<a href="http://www.mysite.com/forum/index.php?action=forum">View Gallery</a>';
echo "</center>";

However, I get 16 debug errors half related to TP and the other to SMF.  I am using the 'Errors On Top' modification, which shows me that information.  Anyone  have this mod who sees this same 'debug' message?  Any harm if I ignore it   :2funny:

Otherwise, it pulls in the pictures just fine.   :up:

I'm on CPG 1.4.12 with CPMfetch 2.0.0 on SMF 1.1.3 TP .0983

Quote from: RoarinRow on August 22, 2007, 01:44:36 AM
This code works for me just fine as far as displaying the pictures and no errors in the log. 

Code Select Expand

echo "<CENTER>";
chdir("../gallery/cpmfetch/");
include "cpmfetch.php";                  
$objCpm = new cpm();
$objCpm->cpm_viewRandomMedia(1,6,array("imageheight" => "75"));
$objCpm->cpm_close();
chdir("../../");
echo '<a href="http://www.mysite.com/forum/index.php?action=forum">View Gallery</a>';
echo "</center>";

However, I get 16 debug errors half related to TP and the other to SMF.  I am using the 'Errors On Top' modification, which shows me that information.  Anyone  have this mod who sees this same 'debug' message?  Any harm if I ignore it   :2funny:

Otherwise, it pulls in the pictures just fine.   :up:

I'm on CPG 1.4.12 with CPMfetch 2.0.0 on SMF 1.1.3 TP .0983