Added link "View topic"...ok!

[fotografo74]

Hi 
My friend has modified gallery.php and gallery.template.php ( little modify)
See attached image ( Clicca qui per vedere il topic relativo alla foto=View topic  )
Forum test: www.macroforum.org/prova/index.php
Seems it's ok!

Antonio

[fotografo74]

Added too topic replies  number for the posted photos ( in  myImages too) ! 
Antonio

[dimdom]

May you share the codes with us?

[fotografo74]

May you share the codes with us?

Of course 
For the topic's link ( sources/gallery.php and theme/default/galley.template.php )

Gallery.php
Search for function ViewPicture():

Code: [Select]

function ViewPicture()
{
global $context, $mbname, $db_prefix, $modSettings, $user_info, $scripturl, $txt, $ID_MEMBER, $boardurl;

isAllowedTo('smfgallery_view');

// Get the picture ID
$id = (int) $_REQUEST['id'];
if (empty($id))
fatal_error($txt['gallery_error_no_pic_selected']);


// Show top Tabs
TopButtonTabs();


$dbresult = db_query("
SELECT
ID_PICTURE, USER_ID_CAT, ID_CAT , ID_TOPIC, ID_MEMBER
FROM {$db_prefix}gallery_pic
WHERE ID_PICTURE = $id  LIMIT 1", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult);


$USER_ID_CAT = $row['USER_ID_CAT'];
$ID_TOPIC =  $row['ID_TOPIC'];  // Edit by Roberto (associazione ID_TOPIC)


mysql_free_result($dbresult);

// other code.................................
...........................................

In gallery.template.php
Search for function template_view_picture() and near line 1380, before Show previous and next links, insert this code

Code: [Select]

{
echo '
<tr class="windowbg2">
<td align="center"><b>
<a href="http://www.yoursite/index.php/topic,' . $context['gallery_pic']['ID_TOPIC'] . '.0.html">Clicca qui per vedere il topic relativo alla foto</a>
</b>
</td>
</tr>';
}


[fotografo74]

For the topic replies number in MyImasges page go to near  line 3107/3108 and replace

Code: [Select]

// Check if it is the user ids gallery mainly to show unapproved pictures or not
 if ($ID_MEMBER == $userid)
    $dbresult = db_query("SELECT p.ID_PICTURE, p.commenttotal,
    p.filesize, p.thumbfilename, p.approved, p.views, p.ID_MEMBER, m.realName, p.date, p.mature, t.numReplies
       FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m, {$db_prefix}topics AS t
WHERE p.ID_MEMBER = $userid AND p.ID_MEMBER = m.ID_MEMBER  AND p.ID_TOPIC = t.ID_TOPIC
    ORDER BY p.ID_PICTURE DESC
    LIMIT $context[start]," . $modSettings['gallery_set_images_per_page'], __FILE__, __LINE__);
else
    $dbresult = db_query("SELECT p.ID_PICTURE, p.commenttotal, p.filesize, p.thumbfilename,
    p.approved, p.views, p.ID_MEMBER, m.realName, p.date,p.mature, t.numReplies
        FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m, {$db_prefix}topics AS t
         WHERE p.ID_MEMBER = $userid AND p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1  AND p.ID_TOPIC = t.ID_TOPIC
         ORDER BY p.ID_PICTURE DESC
    LIMIT $context[start]," . $modSettings['gallery_set_images_per_page'], __FILE__, __LINE__);



while($row = mysql_fetch_assoc($dbresult))
{

if ($row['mature'] == 1 && $ID_MEMBER != $userid)
{
if (CanViewMature() == false)
$row['thumbfilename'] = 'mature.gif';
}

if($rowlevel == 0)
echo '<tr>';

echo '<td align="center"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row['thumbfilename']  . '" /></a><br />';

if($ID_MEMBER == $userid)
{
if($row['approved'] == 1)
echo '<b>', $txt['gallery_myimages_app'], '</b><br />';
else
echo '<b>', $txt['gallery_myimages_notapp'], '</b><br />';
}
    echo $txt['smfgallery_commenti'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['numReplies'] . '</a>)<br />';

In modifications.english.php i have smf.gallery_commenti=replies


For the topic replies number in categories pages go to near  line 5407 and replace

Code: [Select]

// Show the pictures
$dbresult = db_query("
SELECT
p.ID_PICTURE, p.totalratings, t.ID_TOPIC, t.numReplies, p.rating, p.commenttotal, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.realName, p.date, p.description, p.mature
FROM {$db_prefix}gallery_pic as p
LEFT JOIN {$db_prefix}members AS m ON (p.ID_MEMBER = m.ID_MEMBER)
        LEFT JOIN {$db_prefix}topics AS t ON (p.ID_TOPIC = t.ID_TOPIC)
WHERE  p.ID_CAT = $cat AND p.approved = 1 ORDER BY $sortby $orderby
LIMIT $context[start]," . $modSettings['gallery_set_images_per_page'], __FILE__, __LINE__);
$rowlevel = 0;

if (!isset($context['gallery_cat_norate']))
$context['gallery_cat_norate'] = 0;

while($row = mysql_fetch_assoc($dbresult))
{
if ($row['mature'] == 1)
{
if (CanViewMature() == false)
$row['thumbfilename'] = 'mature.gif';
}


if ($rowlevel == 0)
echo '<tr>';

echo '<td align="center">';
if (!empty($modSettings['gallery_set_t_title']))
echo $row['title'] . '<br />';

echo '<a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="', $modSettings['gallery_url'], $row['thumbfilename'], '" /></a><br />';

echo '<span class="smalltext">';
if (!empty($modSettings['gallery_set_t_rating']) && $context['gallery_cat_norate'] != 1)
{
if ($gallerySettings['gallery_points_instead_stars'])
echo $txt['gallery_form_rating'] . $row['rating'] . '<br />';
else
echo $txt['gallery_form_rating'] . GetStarsByPrecent(($row['totalratings'] != 0) ? ($row['rating'] / ($row['totalratings']* 5) * 100) : 0) . '<br />';

}

if (!empty($modSettings['gallery_set_t_views']))
echo $txt['gallery_text_views'] . $row['views'] . '<br />';
if (!empty($modSettings['gallery_set_t_filesize']))
echo $txt['gallery_text_filesize'] . round($row['filesize'] / 1024, 2) . 'KB<br />';
if (!empty($modSettings['gallery_set_t_date']))
echo $txt['gallery_text_date'] . timeformat($row['date']) . '<br />';
if (!empty($modSettings['gallery_set_t_comment']))
echo $txt['smfgallery_commenti'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['numReplies'] . '</a>)<br />';
if (!empty($modSettings['gallery_set_t_username']))
{
if ($row['realName'] != '')
echo $txt['gallery_text_by'] . ' <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['realName'] . '</a><br />';
else
echo $txt['gallery_text_by'] . ' ' . $txt['gallery_guest'] . '<br />';
}



[fotografo74]

Logically i use only poste images, i disabled personal album and comments 

[dimdom]

Thank you!

[fotografo74]

Thank you!

You're welcome !