More info next to thumb on Index Page

[JohannM]

I have recently upgraded from 1.4.xx to 1.5.8

I used to have a field called "Event Date" and "Event Location" next the the album thumb as seen on the index page.

With 1.4.xx I knew where and how to add the fields ( e.g. in the table "ALBUMS" I had fields "event_date" and "event_location", I modified albmgr.php, theme.inc.php, etc. and it worked fine with 1.4.xx calling the info to display.

Now with my new version, I looked and tried everything, but simply cannot find the correct place to add or do the the placement.

Searches on the board reveiled nothing in this matter.

Someone be able to help me please ?

Screenshot of HERE-TO-PUT included where I want the info ... the field with data already in my table "ALBUMS"

Thanx

[Αndré]

Posting your old mod will avoid to re-create it from scratch. However, searching for

Code Select Expand

{ALB_DESC}
in themes/sample/theme.php should give you an idea where to put your custom code (don't forget to copy the corresponding code parts/blocks/functions to your theme's theme.php file).

[JohannM]

Hi André

Thanx for your quick responce.

I checked my old version's scripts .... and I knew exactly where and how to add those fields, een in the database side ...

Currently (and in the previous versions), I added those changes to my theme.inc.php

Here are the cude: ( I // the fields temporary )

if (!function_exists('theme_display_album_list'))  {  //{THEMES}
/******************************************************************************
** Section <<<theme_display_album_list>>> - START
******************************************************************************/
function theme_display_album_list(&$alb_list, $nbAlb, $cat, $page, $total_pages)
{


    global $CONFIG, $STATS_IN_ALB_LIST, $statistics, $template_tab_display, $template_album_list, $lang_album_list;

    $theme_alb_list_tab_tmpl = $template_tab_display;

    $theme_alb_list_tab_tmpl['left_text'] = strtr($theme_alb_list_tab_tmpl['left_text'], array('{LEFT_TEXT}' => $lang_album_list['album_on_page']));
    $theme_alb_list_tab_tmpl['page_link'] = strtr($theme_alb_list_tab_tmpl['page_link'], array('{LINK}' => 'index.php?cat=' . $cat . '&amp;page=%d'));

    $tabs = create_tabs($nbAlb, $page, $total_pages, $theme_alb_list_tab_tmpl);

    $album_cell = template_extract_block($template_album_list, 'album_cell');
    $empty_cell = template_extract_block($template_album_list, 'empty_cell');
    $tabs_row = template_extract_block($template_album_list, 'tabs');
    $stat_row = template_extract_block($template_album_list, 'stat_row');
    $spacer = template_extract_block($template_album_list, 'spacer');
    $header = template_extract_block($template_album_list, 'header');
    $footer = template_extract_block($template_album_list, 'footer');
    $rows_separator = template_extract_block($template_album_list, 'row_separator');

    $count = 0;

    $columns = $CONFIG['album_list_cols'];
    $column_width = ceil(100 / $columns);
    $thumb_cell_width = $CONFIG['alb_list_thumb_size'] + 2;

    starttable('100%');

    if ($STATS_IN_ALB_LIST) {
        $params = array('{STATISTICS}' => $statistics,
            '{COLUMNS}' => $columns,
            );
        echo template_eval($stat_row, $params);
    }

    echo $header;

    if (is_array($alb_list)) {
        foreach($alb_list as $album) {
            $count ++;

            $params = array('{COL_WIDTH}' => $column_width,
                '{ALBUM_TITLE}' => $album['album_title'],
                '{THUMB_CELL_WIDTH}' => $thumb_cell_width,
                '{ALB_LINK_TGT}' => "thumbnails.php?album={$album['aid']}",
                '{ALB_LINK_PIC}' => $album['thumb_pic'],
                '{ADMIN_MENU}' => $album['album_adm_menu'],
                //'{EVENT_LOCATION}' => $album['event_location'],
                //'{EVENT_DATE}' => $album['event_date'],
                //'{JOBNUMBER}' => $album['jobnumber'],
                '{ALB_DESC}' => $album['album_desc'],
                '{ALB_INFOS}' => $album['album_info'],
                '{ALB_HITS}' => $album['alb_hits'],
                );
            $params = CPGPluginAPI::filter('theme_album_params', $params);

            echo template_eval($album_cell, $params);

            if ($count % $columns == 0 && $count < count($alb_list)) {
                echo $rows_separator;
            }
        }
    }

    $params = array('{COL_WIDTH}' => $column_width,
          '{SPACER}' => $thumb_cell_width
          );
    $empty_cell = template_eval($empty_cell, $params);

    while ($count++ % $columns != 0) {
        echo $empty_cell;
    }

    echo $footer;
    // Tab display
    $params = array('{COLUMNS}' => $columns,
        '{TABS}' => $tabs,
        );
    echo template_eval($tabs_row, $params);

    endtable();

    echo $spacer;
}
/******************************************************************************
** Section <<<theme_display_album_list>>> - END
******************************************************************************/
}  //{THEMES}



Also on my index pgae round line (approx) 688 i added the params:

    if (USER_ADMIN_MODE && $cat == (USER_ID + FIRST_USER_CAT)) {
        $sql = 'SELECT a.aid, a.jobnumber, a.event_location, a.event_date, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM ' . $CONFIG['TABLE_ALBUMS'] . ' AS a LEFT JOIN ' . $CONFIG['TABLE_PICTURES'] . ' AS p ON a.thumb=p.pid WHERE a.owner=' . $USER_DATA['user_id'] . $album_filter . ' ORDER BY a.jobnumber DESC , a.pos ' . $limit;


This worked on my old version, but now it seems not to get the info from the database ...

Thanx for your quick responce

[Αndré]

Code Select Expand

if (USER_ADMIN_MODE && $cat == (USER_ID + FIRST_USER_CAT)) {
means this just works for your personal gallery (category ID > 10000). I assume this is not intended, thus you extended the wrong SQL query.

[JohannM]

So where do you think i must add these fields in a query, or what should I do now ?

Thanx again for your help ...

http://www.youth-sport-fotos.com/index.php

[JohannM]

Also, I am the only one that can add photos to the albums ... and even in ADMIN mode, I can not see those fields ..

[Αndré]

Have you added the custom tokens {EVENT_LOCATION}, {EVENT_DATE} and {JOBNUMBER} to your theme ($template_album_list and $template_album_list_cat)?

[JohannM]

André

I am realy sorry to be so stupid ... for the past 8 years I used coppermine on all my photo websites, but with this new version im am just too stupid to figure it out ... and I have 6 sites running on the old version, all down now because of the new versions of PHP, Appach and Sql ...

Hope you dont mind, but I am going to paste my complete theme.inc.php and index.php here ...

PS: Is there another easy way to call the date from the database like eg.  $CURRENT_ALBUM_DATA['event_lacation'];  or something ?

I appreciate your help ... Im sure there will be other users that might find this helpfull ...

you may also have a look at : http://www.boy-idols.com/index.php?cat=4

You will note I have fields there ( Age, Hair, Etc ) ... that is still old coppermine version, so if I enable plugins, the whole website is screwed up, thats why I decided to upgrade all of the sites ...

I just need to know where and how to add or change my custom tokens ...

[Αndré]

I just need to know where and how to add or change my custom tokens ...

I already told you:

$template_album_list and $template_album_list_cat

If those blocks don't exist in your theme's theme.php file, copy them from themes/sample/theme.php and add your tokens to the desired locations, probably somewhere near {ALB_DESC}.

[JohannM]

I already did

If you read the files I attached, you will see it is in there.

Im just not sure if the arguments or the way to call the info is correct ...

If you have paypal or a way for me to send you money, I will be glad to pay for your help.

[Αndré]

In index.php, find

Code Select Expand

$sql = "SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner "
and replace with

Code Select Expand

$sql = "SELECT a.aid, a.jobnumber, a.event_location, a.event_date, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner "

find

Code Select Expand

        if (!in_array($aid, $FORBIDDEN_SET_DATA) || $CONFIG['allow_private_albums'] == 0) {
            $link_pic_count = !empty($alb_stat['link_pic_count']) ? $alb_stat['link_pic_count'] : 0;
            $last_upload_date = ($count || ($CONFIG['link_pic_count'] && $link_pic_count > 0 )) ? localised_date($alb_stat['last_upload'], $lang_date['lastup']) : '';
            $alb_list[$alb_idx]['aid'] = $alb_thumb['aid'];
            $alb_list[$alb_idx]['album_title'] = $alb_thumb['title'];
            $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']);
            $alb_list[$alb_idx]['pic_count'] = $count;
            $alb_list[$alb_idx]['last_upl'] = $last_upload_date;
            $alb_list[$alb_idx]['link_pic_count'] = $link_pic_count;
            $alb_list[$alb_idx]['alb_hits'] = sprintf($lang_list_albums['alb_hits'], $alb_hits);
            $alb_list[$alb_idx]['album_info'] = theme_album_info($count, $link_pic_count, $last_upload_date);
            $alb_list[$alb_idx]['album_adm_menu'] = album_adm_menu($alb_thumb['aid'], $cat, $alb_thumb['owner']);
        } elseif ($CONFIG['show_private']) { // uncomment this else block to show private album description
            $link_pic_count = !empty($alb_stat['link_pic_count']) ? $alb_stat['link_pic_count'] : 0;
            $last_upload_date = ($count || ($CONFIG['link_pic_count'] && $link_pic_count > 0 )) ? localised_date($alb_stat['last_upload'], $lang_date['lastup']) : '';
            $alb_list[$alb_idx]['aid'] = $alb_thumb['aid'];
            $alb_list[$alb_idx]['album_title'] = $alb_thumb['title'];
            $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']);
            $alb_list[$alb_idx]['pic_count'] = $count;
            $alb_list[$alb_idx]['last_upl'] = $last_upload_date;
            $alb_list[$alb_idx]['link_pic_count'] = $link_pic_count;
            $alb_list[$alb_idx]['alb_hits'] = sprintf($lang_list_albums['alb_hits'], $alb_hits);
            $alb_list[$alb_idx]['album_info'] = theme_album_info($count, $link_pic_count, $last_upload_date);
            $alb_list[$alb_idx]['album_adm_menu'] = album_adm_menu($alb_thumb['aid'], $cat, $alb_thumb['owner']);
        }
and replace with

Code Select Expand

        if (!in_array($aid, $FORBIDDEN_SET_DATA) || $CONFIG['allow_private_albums'] == 0) {
            $link_pic_count = !empty($alb_stat['link_pic_count']) ? $alb_stat['link_pic_count'] : 0;
            $last_upload_date = ($count || ($CONFIG['link_pic_count'] && $link_pic_count > 0 )) ? localised_date($alb_stat['last_upload'], $lang_date['lastup']) : '';
            $alb_list[$alb_idx]['aid'] = $alb_thumb['aid'];
            $alb_list[$alb_idx]['album_title'] = $alb_thumb['title'];
            $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']);
            $alb_list[$alb_idx]['pic_count'] = $count;
            $alb_list[$alb_idx]['last_upl'] = $last_upload_date;
            $alb_list[$alb_idx]['link_pic_count'] = $link_pic_count;
            $alb_list[$alb_idx]['alb_hits'] = sprintf($lang_list_albums['alb_hits'], $alb_hits);
            $alb_list[$alb_idx]['album_info'] = theme_album_info($count, $link_pic_count, $last_upload_date);
            $alb_list[$alb_idx]['album_adm_menu'] = album_adm_menu($alb_thumb['aid'], $cat, $alb_thumb['owner']);
            $alb_list[$alb_idx]['event_location'] = $alb_thumb['event_location'];
            $alb_list[$alb_idx]['event_date'] = $alb_thumb['event_date'];
            $alb_list[$alb_idx]['jobnumber'] = $alb_thumb['jobnumber'];
        } elseif ($CONFIG['show_private']) { // uncomment this else block to show private album description
            $link_pic_count = !empty($alb_stat['link_pic_count']) ? $alb_stat['link_pic_count'] : 0;
            $last_upload_date = ($count || ($CONFIG['link_pic_count'] && $link_pic_count > 0 )) ? localised_date($alb_stat['last_upload'], $lang_date['lastup']) : '';
            $alb_list[$alb_idx]['aid'] = $alb_thumb['aid'];
            $alb_list[$alb_idx]['album_title'] = $alb_thumb['title'];
            $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']);
            $alb_list[$alb_idx]['pic_count'] = $count;
            $alb_list[$alb_idx]['last_upl'] = $last_upload_date;
            $alb_list[$alb_idx]['link_pic_count'] = $link_pic_count;
            $alb_list[$alb_idx]['alb_hits'] = sprintf($lang_list_albums['alb_hits'], $alb_hits);
            $alb_list[$alb_idx]['album_info'] = theme_album_info($count, $link_pic_count, $last_upload_date);
            $alb_list[$alb_idx]['album_adm_menu'] = album_adm_menu($alb_thumb['aid'], $cat, $alb_thumb['owner']);
            $alb_list[$alb_idx]['event_location'] = $alb_thumb['event_location'];
            $alb_list[$alb_idx]['event_date'] = $alb_thumb['event_date'];
            $alb_list[$alb_idx]['jobnumber'] = $alb_thumb['jobnumber'];
        }

I haven't checked that in detail, but I think a lot of your other modifications aren't needed.

[JohannM]

Andrè

You are a star !!! AN absolute star ... its working now, Im uploading all the new files to my server now. What do I owe you ?

Just one more question, in each Category I have albums, bit the albums need to be sorted by "jobnumber" Desending, you will notice I have in some instances more than 20 albums in one category, so basicly ( with the previous version ) I want the latest one to bo on top ... hop you understand what I mean ...

I think it is to do with one of the sql quiries on the index page, just not sore which one ...

Can you halp please ?

[JohannM]

Thanx, figured it out !!!