Thumbs o index (latest images)

[Michael-CGC]

Hi there

I've tried serching but couldn't find what I'm looking for 

I have 2 rows showing 'Latest additions' (6 images) on my index. Under every thumb there's 2 lines: Image uploader (username) and date added.

Here's my quastion. Is it possible to add 2 extra line that shows which album and category the thumb belong?

In advance thank you
Michael

[Michael-CGC]

Anyone please? Is it possible? 

[Nibbler]

It's possible yes, and I'm 90% sure it has been posted before, or something very similar.

[Michael-CGC]

It's possible yes, and I'm 90% sure it has been posted before, or something very similar.

Hi Nibbler

Thank you for your reply  Do you know I can get the code?

[Joachim Müller]

By clicking here

[Michael-CGC]

Hi GAUGAU

I've tried searching I don't know how many time. I just can't find what I'm searching for  Please help me?

[Joachim Müller]

haven't tested, but should be in include/functions.inc.php:
Find

Code Select Expand

$rowset[$key]['caption_text'] = $caption; after the

Code Select Expand

case 'lastup': // Last uploads-section (around line 620) and add the album name there.

[Michael-CGC]

haven't tested, but should be in include/functions.inc.php:
Find

Code Select Expand

$rowset[$key]['caption_text'] = $caption; after the

Code Select Expand

case 'lastup': // Last uploads-section (around line 620) and add the album name there.

Hi Gau Gau

I'm not goog at coding  What should I add (code) after where you mentioned?

[Michael-CGC]

Please help a stupid noob 

[Nibbler]

Change

Code Select Expand

                if($select_columns != '*' ) $select_columns .= ',title, caption, owner_id, owner_name, aid';

                $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $ALBUM_SET ORDER BY pid DESC $limit");

                $rowset = db_fetch_rowset($result);
                mysql_free_result($result);

                if ($set_caption) foreach ($rowset as $key => $row){
                        $user_link = ($CONFIG['display_uploader'] && $row['owner_id'] && $row['owner_name']) ? '<span class="thumb_title"><a href ="profile.php?uid='.$row['owner_id'].'">'.$row['owner_name'].'</a></span>' : '';
                        $caption = $user_link.'<span class="thumb_caption">'.localised_date($row['ctime'], $lastup_date_fmt).'</span>';
                        $rowset[$key]['caption_text'] = $caption;
                }

to

Code Select Expand

               $select_columns = '*';

                $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p, {$CONFIG['TABLE_ALBUMS']} as a, {$CONFIG['TABLE_CATEGORIES']} AS c WHERE p.aid =a.aid AND a.category = c.cid AND approved = 'YES' $ALBUM_SET ORDER BY pid DESC $limit");

                $rowset = db_fetch_rowset($result);
                mysql_free_result($result);

                if ($set_caption) foreach ($rowset as $key => $row){
                        $user_link = ($CONFIG['display_uploader'] && $row['owner_id'] && $row['owner_name']) ? '<span class="thumb_title"><a href ="profile.php?uid='.$row['owner_id'].'">'.$row['owner_name'].'</a></span>' : '';
                        $caption = $user_link.'<span class="thumb_caption">'.localised_date($row['ctime'], $lastup_date_fmt).'</span>';
$caption .= '<span class="thumb_caption">'.$row['title'].'</span>';
$caption .= '<span class="thumb_caption">'.$row['name'].'</span>';
                        $rowset[$key]['caption_text'] = $caption;
                }

[Michael-CGC]

Hi Nibbler

I did what you suggested, but I'm getting database errror in the categories   Beside that category and album is now showing under new images on index  

[Michael-CGC]

The error seems to be the categories  :-\\ How to I remove the category part from the code, so it only show album name ? One other thing. I like to have the album name under random pictures. Where can I add the code and what's the code for it ? Is it the same as above ?

Thx
Michael