Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Change Last Pictures script to show Last Albums  (Read 5768 times)

0 Members and 1 Guest are viewing this topic.

squid2

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Change Last Pictures script to show Last Albums
« on: September 12, 2010, 09:17:10 pm »

Hello,
I'm using a script on my site which shows the last added pictures. It works fine, but is there a way to make it show the last albums? (just like "lastalb")

My main.php has "cp_latest.php" included, which looks like this:
Code: [Select]
<?php

// thumbnails are links? 0=no, 1=yes
$cpg_include_link 1;
 
// link points to album or single pic? 0=album, 1=single pic
if($show == 'single') {
$cpg_link_singlepic 1;
} else {
$cpg_link_singlepic 0;
}

// how many thumbs do you need?
$cpg_how_many 8;

// specify certain album, "" = all
$cgp_limit_album "";

// get random pic 0=no, 1=yes
if($random == "Y") {
$cpg_random 1;
} else {
$cpg_random 0;
}

// -----------------------------------------------------
// Don't edit below this line
// -----------------------------------------------------

@include_once("cp_latest-inc.php");
if(
$cpgconn == 1) {
print cpg_thumb($cpg_include_link,$cpg_link_singlepic,$cpg_how_many,$cgp_limit_album,$cpg_random);
} else {
echo('This gallery feature is temporarily unavailable. Check back in a few minutes.' "\n");
}

?>

This is the "cp_latest-inc.php":
Code: [Select]
<?
// ------------------------------------------------------------------------- //
//  include script for CPG (c) 2003 GauGau (mail@gaugau.de) V1.4             //
//  http://gaugau.de/                                                        //
// ------------------------------------------------------------------------- //
//  Coppermine Photo Gallery v1.1                                     //
// ------------------------------------------------------------------------- //
//  Copyright (C) 2002,2003  Gr&eacute;gory DEMAR <gdemar@wanadoo.fr>               //
//  http://www.chezgreg.net/coppermine/                                      //
// ------------------------------------------------------------------------- //
//  Based on PHPhotoalbum by Henning StÝverud <henning@stoverud.com>         //
//  http://www.stoverud.com/PHPhotoalbum/                                    //
// ------------------------------------------------------------------------- //
//  This program is free software; you can redistribute it and/or modify     //
//  it under the terms of the GNU General Public License as published by     //
//  the Free Software Foundation; either version 2 of the License, or        //
//  (at your option) any later version.                                      //
// ------------------------------------------------------------------------- //

/////////////////// edit the following lines //////////////////////////////
$url_of_cpg_dir='http://domain-name.com/gallery/';    // full path to your coppermine gallery (with trailing slash)
$absolute_path_to_coppermine='/home2/username/public_html/gallery/'; // absolute path on your server to coppermine gallery (with trailing slash)
// to find more about absolute paths, check http://www.php.net/manual/en/function.phpinfo.php and look for 'DOCUMENT_ROOT' in your phpinfo.php
$cpg_decimal_point=","; //what character is used to separate decimals in your country, e.g. in Germany ",", in GB "."
$cpg_thousands_separator=","; //what character is used to separate thousands in your country, e.g. in Germany ".", in GB & US ",", in France " "
$cpg_lang_pics = "Pictures"; //translate this
$cpg_lang_views = "views"; //translate this
$cpg_lang_random = "Random pic of this album"; //translate this
$cpg_lang_keywords = "Keywords"; //translate this
/////// don't edit below this line unless you know what your're doing /////////

include_once( $absolute_path_to_coppermine.'/include/config.inc.php');

print <<<EOT
<script language="javascript" type="text/javascript">
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
</script>
EOT;


// definition taken from init.inc.php
$CONFIG['TABLE_PICTURES']        = $CONFIG['TABLE_PREFIX']."pictures";
$CONFIG['TABLE_ALBUMS']                = $CONFIG['TABLE_PREFIX']."albums";
$CONFIG['TABLE_COMMENTS']        = $CONFIG['TABLE_PREFIX']."comments";
$CONFIG['TABLE_CATEGORIES']        = $CONFIG['TABLE_PREFIX']."categories";
$CONFIG['TABLE_CONFIG']                = $CONFIG['TABLE_PREFIX']."config";
$CONFIG['TABLE_USERGROUPS']        = $CONFIG['TABLE_PREFIX']."usergroups";
$CONFIG['TABLE_VOTES']                = $CONFIG['TABLE_PREFIX']."votes";
$CONFIG['TABLE_USERS']                = $CONFIG['TABLE_PREFIX']."users";

// Connect to database
if($cpgconn != 1) {
if(db_connect() == FALSE) {
// die("<b>Coppermine critical error</b>:<br />Unable to connect to database !<br /><br />MySQL said: <b>".mysql_error()."</b>");
$cpgconn = 0;
} else {
$cpgconn = 1;
}
}

// If connected, process through
if($cpgconn == 1) {
// get config data
$result = mysql_query("SELECT * from {$CONFIG['TABLE_CONFIG']} WHERE name='fullpath'");
$row = mysql_fetch_row($result);
$cpg_album_path=$row[1];
$result = mysql_query("SELECT * from {$CONFIG['TABLE_CONFIG']} WHERE name='mini_pfx'");
$row = mysql_fetch_row($result);
$cpg_mini_pfx=$row['1'];
$result = mysql_query("SELECT * from {$CONFIG['TABLE_CONFIG']} WHERE name='thumbcols'");
$row = mysql_fetch_row($result);
$cpg_thumbcols=$row['1'];

if ($function == 'cpg_thumb' || $function == 'recentTopics' || $function == 'whosOnline' || $function == 'welcome' || $function == 'menubar' || $function == 'logout' || $function == 'login' || $function == 'topBoards' || $function == 'topTopicsViews' || $function == 'topTopicsReplies' || $function == 'latestMember' || $function == 'boardStats')
{
        $function(); // Execute Function
        exit;
}
}

function cpg_thumb()
{
GLOBAL $CONFIG,$url_of_cpg_dir,$cpg_album_path,$cpg_mini_pfx,$cpg_thumbcols,$cpg_lang_random,$cpg_lang_views,$cpg_lang_keywords;
$numargs = func_num_args();
$arg_list = func_get_args();
if ($numargs > 0) {$cpg_include_link=$arg_list[0];}
if ($numargs > 1) {$cpg_link_singlepic=$arg_list[1];}
if ($numargs > 2) {$cpg_how_many=$arg_list[2];}
if ($numargs > 3) {$cgp_limit_album=$arg_list[3];}
if ($numargs > 4) {$cpg_random=$arg_list[4];}
if ($numargs > 5) {$cpg_link_target=$arg_list[5];}
if ($cpg_link_target==""){$cpg_link_target="_top";}


//get pic info
$query = "SELECT * from {$CONFIG['TABLE_PICTURES']} WHERE approved='YES' ";
if($cgp_limit_album!=""){$query.="AND aid='".$cgp_limit_album."'";}
$query.=" AND user2!='1' ORDER BY ";
if($cpg_random=="1"){$query.="RAND()";}else{$query.="ctime";}
$query.=" DESC LIMIT 0,".$cpg_how_many;
$result = mysql_query($query);
if ($cpg_how_many!=1)
{
$return_value="";
//$td_start="<div align=center>";
//$td_end="</div>";
$td_start="";
$td_end="";
$cpg_table_end="";
$tr_start="";
$tr_end="";
}
else
{
$return_value="";
$td_start="";
$td_end="";
$cpg_table_end="";
$tr_start="";
$tr_end="";
}
$counter=0;
if ($cpg_thumbcols > $cpg_how_many) {$cpg_thumbcols=$cpg_how_many;}

while ($row = mysql_fetch_array($result)) {
//------
if ($counter==0){$return_value.=$tr_start;}
$return_value.=$td_start;
if ($cpg_include_link==1)
  {
  $return_value.= "<a href=\"";
    if ($cpg_link_singlepic==1)
      {
       if ($cpg_link_target=="popup")
          {
          $return_value.="javascript:;\" onClick=\"MM_openBrWindow('".$url_of_cpg_dir."displayimage.php?pid=".$row['pid']."&fullsize=1','".uniqid(rand())."','toolbar=yes,status=yes,resizable=yes,width=".($row['pwidth']+16).",height=".($row['pheight']+16)."')\"";
          }
          else
          {
          $return_value.=$url_of_cpg_dir."displayimage.php?&pos=-".$row['pid'];
          }
      }
    else
      {
      $return_value.=$url_of_cpg_dir."thumbnails.php?album=".$row['aid'];
      }
  $return_value.="\" ";

  if($cpg_link_target=="popup"){$return_value.="";}else{$return_value.="target=\"_bklank".$cpg_link_target."\"";}
  $return_value.=">";
  }
$return_value.= "<img src=\"".$url_of_cpg_dir.$cpg_album_path.$row['filepath'].$cpg_mini_pfx.$row['filename']."\" width= 74 height=74 class=thumb border=\"0\" alt=\"\" title=\"";
if ($row['title']!="") {$return_value.= $row['title']."&#10;";}
if ($row['caption']!="") {$return_value.= $row['caption']."&#10;";}
if ($row['keywords']!="") {$return_value.= $cpg_lang_keywords . ": " . $row['keywords']."&#10;";}
if ($row['hits']!="") {$return_value.= $row['hits']." ".$cpg_lang_views."&#10;";}
if($cpg_random=="1")  {$return_value.= $cpg_lang_random;}
$return_value.= "\" class=\"padright\">";
if ($cpg_include_link==1){$return_value.="</a>";}
$return_value.=$td_end."\n";
$counter++;
if ($counter==$cpg_thumbcols){$counter=0;$return_value.=$tr_end;}
}

$return_value.=$cpg_table_end;
return $return_value;
}

function cpg_single()
{
$numargs = func_num_args();
$arg_list = func_get_args();
if ($numargs > 0){return cpg_thumb(1,1,1,"",0,$arg_list[0]);}
else{return cpg_thumb(1,1,1,"",0);}
}

function cpg_total_pics($cgp_limit_album)
{
GLOBAL $CONFIG,$cpg_decimal_point,$cpg_thousands_separator;
  $query = "SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES'";
  if($cgp_limit_album!=""){$query.=" AND aid='".$cgp_limit_album."'";}
  $result = mysql_query($query);
  $nbEnr = mysql_fetch_array($result);
  $pic_count = $nbEnr[0];
  mysql_free_result($result);
  return number_format($pic_count,0,$cpg_decimal_point,$cpg_thousands_separator);
}

function cpg_total_views($cgp_limit_album)
{
GLOBAL $CONFIG,$cpg_decimal_point,$cpg_thousands_separator;
  $query = "SELECT sum(hits) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1";
  if($cgp_limit_album!=""){$query.=" AND aid='".$cgp_limit_album."'";}
  $result = mysql_query($query);
  $nbEnr = mysql_fetch_array($result);
  $view_count = $nbEnr[0];
  mysql_free_result($result);
  return number_format($view_count,0,$cpg_decimal_point,$cpg_thousands_separator);
}

function cpg_hit_ratio($cgp_limit_album)
{
GLOBAL $CONFIG;
//get stats
$result=mysql_query("SELECT sum(hits) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$hit_count = (int)$nbEnr[0];
$result=mysql_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$picture_count = $nbEnr[0];
$cpg_ratio_string=str_replace(".", ",",(floor(((str_replace(".", "", cpg_total_views($cgp_limit_album))/str_replace(".", "", cpg_total_pics($cgp_limit_album)))*10)/($hit_count/$picture_count)))/10);
//$cpg_ratio_string=cpg_total_views($cgp_limit_album).'|'.cpg_total_pics($cgp_limit_album).'|'.$hit_count.'|'.$picture_count;
return $cpg_ratio_string;


}

function cpg_stat_string($cgp_limit_album)
{
GLOBAL $url_of_cpg_dir,$cpg_lang_pics,$cpg_lang_views;
$cpg_stat_string='[<a href="'.$url_of_cpg_dir.'thumbnails.php?album='.$cgp_limit_album.'"><b>';
$cpg_stat_string.=cpg_total_pics($cgp_limit_album);
$cpg_stat_string.='</b> ' . $cpg_lang_pics . '</a>, <a href="'.$url_of_cpg_dir.'thumbnails.php?album=topn&cat=-'.$cgp_limit_album.'"><b>';
$cpg_stat_string.=cpg_total_views($cgp_limit_album);
$cpg_stat_string.='</b> ' . $cpg_lang_views . '</a>';
$cpg_stat_string.=', <span class="tool" title="SF=Spanner-Faktor:&#10;Wie oft sind die Bilder dieses Albums durchschnittlich angeklickt worden, im Vergleich zur gesamten Galerie?">SF: '.cpg_hit_ratio($cgp_limit_album).'</span>';
$cpg_stat_string.=']';
return $cpg_stat_string;
}

function cpg_total_albums()
{
GLOBAL $CONFIG,$cpg_decimal_point,$cpg_thousands_separator;
  $query = "SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} WHERE 1";
  $result = mysql_query($query);
  $nbEnr = mysql_fetch_array($result);
  $album_count = $nbEnr[0];
  mysql_free_result($result);
  return number_format($album_count,0,$cpg_decimal_point,$cpg_thousands_separator);
}

function cpg_total_comments()
{
GLOBAL $CONFIG,$cpg_decimal_point,$cpg_thousands_separator;
  $query = "SELECT count(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE 1";
  $result = mysql_query($query);
  $nbEnr = mysql_fetch_array($result);
  $comments_count = $nbEnr[0];
  mysql_free_result($result);
  return number_format($comments_count,0,$cpg_decimal_point,$cpg_thousands_separator);
}

function cpg_total_cats()
{
GLOBAL $CONFIG,$cpg_decimal_point,$cpg_thousands_separator;
  $query = "SELECT count(*) FROM {$CONFIG['TABLE_CATEGORIES']} WHERE 1";
  $result = mysql_query($query);
  $nbEnr = mysql_fetch_array($result);
  $cats_count = $nbEnr[0];
  mysql_free_result($result);
  return number_format($cats_count,0,$cpg_decimal_point,$cpg_thousands_separator);
}


function cpg_random()
{
return cpg_thumb(1,1,1,"",1);
}

function cpg_search($cpg_size,$cpg_question,$cpg_submit_text)
{
GLOBAL $url_of_cpg_dir;
$cpg_search_string = "<form method=\"get\" action=\"" . $url_of_cpg_dir . "thumbnails.php\" name=\"search_cpg\">
<input type=\"hidden\" name=\"album\" value=\"search\" />
<input type=\"hidden\" name=\"type\" value=\"full\" />
<input type=\"input\" name=\"search\" maxlength=\"255\" size=\"" . $cpg_size . "\" value=\"" . $cpg_question . "\" class=\"textfield\" onfocus=\"this.value=''\" />";
if ($cpg_submit_text!="" and $cpg_submit_text!="0")
  {
  $cpg_search_string.= " <input type=\"submit\" value=\"" . $cpg_submit_text . "\" class=\"submit\" />";
  }
$cpg_search_string.= "</form>";
return $cpg_search_string;
}

function cpg_stats()
{
GLOBAL $CONFIG;
$result=mysql_query("SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$album_count = $nbEnr[0];
mysql_free_result($result);

$result=mysql_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$picture_count = $nbEnr[0];
mysql_free_result($result);

$result=mysql_query("SELECT count(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$comment_count = $nbEnr[0];
mysql_free_result($result);

$result=mysql_query("SELECT count(*) FROM {$CONFIG['TABLE_CATEGORIES']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$cat_count = $nbEnr[0] - $HIDE_USER_CAT;
mysql_free_result($result);

$result=mysql_query("SELECT sum(hits) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1");
$nbEnr = mysql_fetch_array($result);
$hit_count = (int)$nbEnr[0];
mysql_free_result($result);


print $picture_count.", ".$album_count.", ".$cat_count.", ".$comment_count.", ".$hit_count;
}


//function taken from functions.inc.php
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;
}



?>
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.