Print

[claude258]

Is there any chances that you write this mod for cpg 1.3.5? Is there a lot of codes to change?

[pslawinski]

Is there any chances that you write this mod for cpg 1.3.5? Is there a lot of codes to change?

I don't think there is much to change.  I think all I have to do is rename cpg_db_query() to db_query().

I can try, but I don't have a great method of testing the script on 1.3.x, my testing setup only has one image...

If anyone from the dev team sees this can you tell me if there are any major differences in the way meta albums are handled between 1.3.x and 1.4.x?

[pslawinski]

Rewritten script:

All references to cpg_db_ were changed to db_

Let me know if you encounter any problems.

Code for index.php is the same for 1.3.x and can be found in reply #19

Demo here

theme.php
Add:

Code: [Select]

$template_sub_menu = <<<EOT
          {BUTTONS}$template_sys_menu_spacer
  <a href="galleryStats.php">Gallery Statistics<font color="#FF0000">(NEW)</font></a>
EOT;

include/functions.inc.php
Find:

Code: [Select]

// Retrieve the data for a picture or a set of picture
function get_pic_data($album, &$count, &$album_name, $limit1=-1, $limit2=-1, $set_caption = true)

Replace With:

Code: [Select]

function build_caption(&$rowset,$must_have=array(), $custInfo=array(), $indexType='')
{
    global $CONFIG, $THEME_DIR;
    global $album_date_fmt, $lastcom_date_fmt, $lastup_date_fmt, $lasthit_date_fmt, $cat;
    global $lang_get_pic_data, $lang_meta_album_names, $lang_errors;
   
foreach ($rowset as $key => $row)
{
        $caption='';

        $caption .= ($row['title']) ? '<span class="thumb_title">' . $row['title'] . '</span>' : '';

        if ($CONFIG['views_in_thumbview'] || in_array('hits',$must_have)) {
            $caption .= '<span class="thumb_title">' . sprintf($lang_get_pic_data['n_views'], $row['hits']).'</span>';
        }
        if ($CONFIG['caption_in_thumbview']){
            $caption .= $row['caption'] ? "<span class=\"thumb_caption\">".strip_tags(bb_decode($row['caption']))."</span>" : '';
        }
        if ($CONFIG['display_comment_count']) {
            $comments_nr = count_pic_comments($row['pid']);
            if ($comments_nr > 0) {
                $caption .= "<span class=\"thumb_num_comments\">".sprintf($lang_get_pic_data['n_comments'], $comments_nr )."</span>";
            }
        }
        if ($CONFIG['display_uploader'] /*&& !in_array($row['owner_id'],$CONFIG['ADMIN_USERS']) *|| ($CONFIG['display_admin_uploader'] && in_array($row['owner_id'],$CONFIG['ADMIN_USERS']))*/) {
            $caption .= ($row['owner_id'] && $row['owner_name']) ? '<span class="thumb_title"><a href ="profile.php?uid='.$row['owner_id'].'">'.$row['owner_name'].'</a></span>' : '';
        }

        if (in_array('msg_date',$must_have)) {
            $caption .= '<span class="thumb_caption">'.localised_date($row['msg_date'], $lastcom_date_fmt).'</span>';
        }
        if (in_array('msg_body',$must_have)) {
            $msg_body = strip_tags(bb_decode($row['msg_body'])); // I didn't want to fully bb_decode the message where report to admin isn't available. -donnoman
            $msg_body = utf_strlen($msg_body) > 50 ? utf_substr($msg_body,0,50).'...': $msg_body;
            if ($CONFIG['enable_smilies']) $msg_body = process_smilies($msg_body);
            if ($row['author_id']) {
                $caption .= '<span class="thumb_caption"><a href ="profile.php?uid='.$row['author_id'].'"><font color="#000000" style="text-decoration:underline">'.$row['msg_author'].'</font></a>: '.$msg_body.'</span>';
            } else {
                    $caption .= '<span class="thumb_caption">'.$row['msg_author'].': '.$msg_body.'</span>';
            }
        }
        if (in_array('ctime',$must_have)) {
            $caption .= '<span class="thumb_caption">'.localised_date($row['ctime'], $lastup_date_fmt).'</span>';
        }
        if (in_array('pic_rating',$must_have)) {
            if (defined('THEME_HAS_RATING_GRAPHICS')) {
                $prefix= $THEME_DIR;
            } else {
                $prefix= '';
            }
            $caption .= "<span class=\"thumb_caption\">".'<img src="'.$prefix.'images/rating'.round($row['pic_rating']/2000).'.gif" alt=""/>'.'<br />'.sprintf($lang_get_pic_data['n_votes'], $row['votes']).'</span>';
        }
        if (in_array('mtime',$must_have)) {
                $caption .= "<span class=\"thumb_caption\">".localised_date($row['mtime'], $lasthit_date_fmt);
                if (GALLERY_ADMIN_MODE) {
                  $caption .="<br/>".$row['lasthit_ip'];
                }
                $caption .='</span>';
        }


if($custInfo != '')
{
switch($indexType)
{
case 'usrcom':
$index = $row['owner_id'];
$caption .= "<span class=\"thumb_num_comments\">".sprintf($lang_get_pic_data['n_comments'], $custInfo[$index]);
$caption .='</span>';
break;

case 'usrvot':
$index = $row['owner_id'];
$caption .= "<span class=\"thumb_caption\">".sprintf($lang_get_pic_data['n_votes'], $custInfo[$index]);
$caption .='</span>';
break;

case 'usrvie':
$index = $row['owner_id'];
$caption .= "<span class=\"thumb_title\">".sprintf($lang_get_pic_data['n_views'], $custInfo[$index]);
$caption .='</span>';
break;

case 'albcom':
$index = $row['aid'];
$caption .= "<span class=\"thumb_num_comments\">".sprintf($lang_get_pic_data['n_comments'], $custInfo[$index]);
$caption .='</span>';
break;

case 'albvot':
$index = $row['aid'];
$caption .= "<span class=\"thumb_caption\">".sprintf($lang_get_pic_data['n_votes'], $custInfo[$index]);
$caption .='</span>';
break;

case 'albvie':
$index = $row['aid'];
$caption .= "<span class=\"thumb_title\">".sprintf($lang_get_pic_data['n_views'], $custInfo[$index]);
$caption .='</span>';
break;
}

}

        $rowset[$key]['caption_text'] = $caption;
}
}

// Retrieve the data for a picture or a set of picture
function get_pic_data($album, &$count, &$album_name, $limit1=-1, $limit2=-1, $set_caption = true)

Find:

Code: [Select]

default : // Invalid meta album

Replace with

Code: [Select]


        case 'mostcom': //Most Commented Images

$album_name = "Most Commented Images";

$query = "SELECT pid FROM {$CONFIG['TABLE_COMMENTS']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
$index = $row[0];
$mostCommented[$index] = @$mostCommented[$index] + 1;
}

$count = count($mostCommented);

arsort($mostCommented, SORT_NUMERIC);
foreach(array_slice(array_keys($mostCommented),$limit1,$limit2) as $image)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.pid = '$image' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
$rowset[] = $row[0];
}

$preVal = $CONFIG['display_comment_count'];
$CONFIG['display_comment_count'] = 1;
                if ($set_caption) build_caption($rowset,array('ctime'));
$CONFIG['display_comment_count'] = $preVal;

                return $rowset;
                break;

        case 'mostvot': // Most Voted on Images

$album_name = "Most Voted on Images";

$query = "SELECT pid, votes FROM {$CONFIG['TABLE_PICTURES']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
if($row[1] != 0) $mostVoted[$row[0]] = $row[1];
}

$count = count($mostVoted);

arsort($mostVoted, SORT_NUMERIC);
foreach(array_slice(array_keys($mostVoted),$limit1,$limit2) as $image)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.pid = '$image' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
$rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array('ctime', 'pic_rating'));

                return $rowset;
                break;

        case 'mostcomusr': // Most Commented Users

$album_name = "Most Commented Users";

$query = "SELECT owner_id FROM {$CONFIG['TABLE_COMMENTS']} as c, {$CONFIG['TABLE_PICTURES']} as p WHERE c.pid = p.pid";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
$mostCommentedUser[$row[0]] = @$mostCommentedUser[$row[0]] + 1;
}

$count = count($mostCommentedUser);

arsort($mostCommentedUser, SORT_NUMERIC);
foreach(array_slice(array_keys($mostCommentedUser),$limit1,$limit2) as $user)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.owner_id = '$user' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
$rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostCommentedUser, 'usrcom');

                return $rowset;
                break;

        case 'mostvotusr': // Most Voted on Users

$album_name = "Most Voted on Users";

$query = "SELECT owner_id, votes FROM {$CONFIG['TABLE_PICTURES']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
if($row[1] != 0) $mostVotedUser[$row[0]] = @$mostVotedUser[$row[0]] + $row[1];
}

$count = count($mostVotedUser);

arsort($mostVotedUser, SORT_NUMERIC);
foreach(array_slice(array_keys($mostVotedUser),$limit1,$limit2) as $user)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.owner_id = '$user' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
$rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostVotedUser, 'usrvot');

                return $rowset;
                break;

        case 'mostvieusr': // Users With the Most Views

$album_name = "Users With the Most Views";

$query = "SELECT owner_id, hits FROM {$CONFIG['TABLE_PICTURES']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
if($row[1] != 0) $mostViewedUser[$row[0]] = @$mostViewedUser[$row[0]] + $row[1];
}

$count = count($mostViewedUser);

arsort($mostViewedUser, SORT_NUMERIC);
foreach(array_slice(array_keys($mostViewedUser),$limit1,$limit2) as $user)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.owner_id = '$user' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
$rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostViewedUser, 'usrvie');

                return $rowset;
                break;

        case 'topcom': // Top Commenters

$album_name = "Top Commenters";

$query = "SELECT author_id FROM {$CONFIG['TABLE_COMMENTS']} as c, {$CONFIG['TABLE_PICTURES']} as p WHERE c.pid = p.pid";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
$mostCommentingUser[$row[0]] = @$mostCommentingUser[$row[0]] + 1;
}

$count = count($mostCommentingUser);

arsort($mostCommentingUser, SORT_NUMERIC);
foreach(array_slice(array_keys($mostCommentingUser),$limit1,$limit2) as $user)
{
$query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} as p WHERE p.owner_id = '$user' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
if($row[0] != NULL) $rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostCommentingUser, 'usrcom');


                return $rowset;
                break;

        case 'mostcomalb': // Most Commented Album

$album_name = "Most Commented Album";

$query = "SELECT aid FROM {$CONFIG['TABLE_COMMENTS']} as c, {$CONFIG['TABLE_PICTURES']} as p WHERE c.pid = p.pid";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
$mostCommentedAlbum[$row[0]] = @$mostCommentedAlbum[$row[0]] + 1;
}

$count = count($mostCommentedAlbum);

arsort($mostCommentedAlbum, SORT_NUMERIC);
foreach(array_slice(array_keys($mostCommentedAlbum),$limit1,$limit2) as $album)
{
$query = "SELECT *,a.title AS title FROM {$CONFIG['TABLE_PICTURES']} as p, {$CONFIG['TABLE_ALBUMS']} as a WHERE p.aid = '$album' AND a.aid = '$album' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
if($row[0] != NULL) $rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostCommentedAlbum, 'albcom');


                return $rowset;
                break;

        case 'mostvotalb': // Most Voted on Album

$album_name = "Most Voted on Album";

$query = "SELECT aid, votes FROM {$CONFIG['TABLE_PICTURES']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
if($row[1] != 0) $mostVotedAlbum[$row[0]] = @$mostVotedAlbum[$row[0]] + $row[1];
}

$count = count($mostVotedAlbum);

arsort($mostVotedAlbum, SORT_NUMERIC);
foreach(array_slice(array_keys($mostVotedAlbum),$limit1,$limit2) as $album)
{
$query = "SELECT *,a.title AS title FROM {$CONFIG['TABLE_PICTURES']} as p, {$CONFIG['TABLE_ALBUMS']} as a WHERE p.aid = '$album' AND a.aid = '$album' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
if($row[0] != NULL) $rowset[] = $row[0];
}

                if ($set_caption) build_caption($rowset,array(), $mostVotedAlbum, 'albvot');


                return $rowset;
                break;

        case 'mostviealb': // Most Viewed Album

$album_name = "Most Viewed Album";

$query = "SELECT aid, hits FROM {$CONFIG['TABLE_PICTURES']}";
$result = db_query($query);
$rowset = db_fetch_rowset($result);
mysql_free_result($result);

foreach($rowset as $row)
{
if($row[1] != 0) $mostViewedAlbum[$row[0]] = @$mostViewedAlbum[$row[0]] + $row[1];
}

$count = count($mostViewedAlbum);

arsort($mostViewedAlbum, SORT_NUMERIC);
foreach(array_slice(array_keys($mostViewedAlbum),$limit1,$limit2) as $album)
{
$query = "SELECT *,a.title AS title FROM {$CONFIG['TABLE_PICTURES']} as p, {$CONFIG['TABLE_ALBUMS']} as a WHERE p.aid = '$album' AND a.aid = '$album' ";
$result = db_query($query);
$rowsets[] = db_fetch_rowset($result);
mysql_free_result($result);
}

$rowset = array();
foreach($rowsets as $row)
{
if($row[0] != NULL) $rowset[] = $row[0];
}


                if ($set_caption) build_caption($rowset,array(), $mostViewedAlbum, 'albvie');


                return $rowset;
                break;

        default : // Invalid meta album


Extract galleryStats13X.zip into your main directory.

[claude258]

I cant find the first code to replace in include/functions.inc.php
Code: function build_caption(&$rowset,$must_have=array()) 

I am using cpg 1.3.5

[pslawinski]

I have rewritten the code to be compatible with 1.3.x and it has been tested.  You can find the working code in Reply #22.

[claude258]

Thanks it is working fine with cpg 1.3.5

I might have something I want to change. Can you give me a hint on how to do it? I have tried but I am not a programmer...
I would like to remove the picture views under the thumbnail in almost all sections:

Top Commenters
Most Voted on Album
Most Commented Album
Users With the Most Views
Most Voted on Users
Most Commented Users
Most Voted on Images
Most Commented Images

I would like to avoid some confusion with the album views or comments numbers (displayed lower). In fact, I would like to have it displayed as on your web site.

Thanks again for your work!

[pslawinski]

I might have something I want to change. Can you give me a hint on how to do it? I have tried but I am not a programmer...
I would like to remove the picture views under the thumbnail in almost all sections:

That should be an easy fix.  I'll see what I can do.

[pslawinski]

For 1.3.X if you want to disable page views below thumbnails find the following code:

Code: [Select]

        if ($CONFIG['views_in_thumbview'] || in_array('hits',$must_have)) {
            $caption .= '<span class="thumb_title">' . sprintf($lang_get_pic_data['n_views'], $row['hits']).'</span>';
        }

Comment it out:

Code: [Select]

/*
        if ($CONFIG['views_in_thumbview'] || in_array('hits',$must_have)) {
            $caption .= '<span class="thumb_title">' . sprintf($lang_get_pic_data['n_views'], $row['hits']).'</span>';
        }
*/


[claude258]

Thanks a lot.
It is working great...

[Cypher]

Damn, I cant get it to work.

When I have done those changes, just an emphty page comes up, nothing else. Weird, and I just wanted to get the amoun of views of the files, amount of comments and so on.

Im using the newest version available, 1.4.3?

[pslawinski]

I don't know if there were any changes in 1.4.3 that would affect this.  I use 1.4.2.

Try turning debug mode on and see if there are any errors or notices.  I need a little more information to help you.

[Cypher]

It`s impossible to put that in that debug mode. The site becomes just plank. There`s nothing.

Is there another way to just get the amount of views that visitors have done, amount of pictures and so on?

I have deactivated the category list so the normal stats have gone. And I dont want the damn category list back

[pslawinski]

I don't know what to tell you to do.  I have not used the new version so I have no Idea whether something has been changed that would cause this mod not to work.  I also don't have enough information from what you've told me to do anything.  Try posting your source code or something so I can get a better idea of what you are talking about.

[Joachim Müller]

It`s impossible to put that in that debug mode. The site becomes just plank. There`s nothing.

Fix this issue first before applying the mod, it's a serious error if you can't enable debug_mode. Start a new thread on the proper board for this. When your gallery is fine again (and you can use debug_mode), return to this thread and try re-applying the mod. Usually, mods written for cpg1.4.2 can be used with cpg1.4.3, as cpg1.4.3 only fixes bugs that existed in cpg1.4.2 - it doesn't add new features.

[Cypher]

GauGau is it even possible to get those normal stats - that come when you add the category list to the frontpage - to work without that category list.

(Notice. doesn`t have anything to do with this thread)

[Joachim Müller]

(Notice. doesn`t have anything to do with this thread)

Then don't clutter the thread with unrelated replies.

[copperphoto]

Is it possible that custom thumbnails are not displayed? I have a video with a custom thumb in the ''most voted'' stats and I see a red X instead of the thumb. The same thing apply to the video album which is in the ''most viewd album'' stats (this album only contains videos with custom thumb).
Otherwise, all those thumbs are displayed properly everywhere else (outside gallerystats.php).

Claude   

I have the same problem. I am using version 1.4.3

[pslawinski]

Right click on the picture and get the URL of the image that is not showing up.  Maybe I can be of some assistance but I need more information about the problem.  Also keep in mind that this mod was never made to work with custom thumbnails, that's something you'll have to do yourself.

[claude258]

The URL of one of the images not showing is:
http://claudebriere.net/coppermine/displayimage.php?pos=-260

You can check the gallerystats here: http://claudebriere.net/coppermine/galleryStats.php

For videos, I want to have a custum thumb because I dont want the same ''Coppermine thumb'' for all videos.
So, I make a custom thumb (using Coppermine doc technique: http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#cust_thmb) and I put the image used to produce the custom thumb in a private album that is not available for public.   

Let me know if you have any suggestions...

Thanks.

[pslawinski]

Are you using the latest version of this mod?  I rewrote the mod to use the built-in functions for meta albums.  If the custom thumbnails still do not display correctly then you will have to modify the code for displaying meta albums.