SSI function

[Vincent Volmer]

Hello mr. SMFHacks,

I'm trying to get an SSI function working for the Downloads MOD but I'm breaking my head over it... haha

It's working for the 'light' version of this MOD but now I would like to display the thumbnails to. Could you please help with the query and how to display the images. For the rest I can add it manual to the SSI.php of course. See the code below.

Thanks in advance....!
Vincent

Code: [Select]

//Begin Random Downloads horizontaal
function ssi_downloads_randomdownloads_hor_img( $limit = 5, $output_method = 'echo')
{
   global $smcFunc, $modSettings, $boardurl, $scripturl, $txt;

    $limit = (int)  $limit;
   
$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_FILE, p.totalratings, p.rating, p.commenttotal,
p.filesize, p.views, p.title, p.ID_MEMBER, m.real_name,
p.date, p.description, p.totaldownloads, f.thumbfilename, f.ID_PICTURE,
mg.online_color
FROM {db_prefix}down_file as p
LEFT JOIN {db_prefix}members AS m ON (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}membergroups AS mg  ON (m.ID_GROUP = mg.ID_GROUP)
LEFT JOIN {db_prefix}down_file_pic AS f ON (f.ID_PICTURE = p.ID_PICTURE)
WHERE  p.approved = 1 GROUP by RAND() LIMIT $limit");

echo '<center><table cellspacing="20"><tr>';

   if ($output_method == 'echo')
   {
     while($row = $smcFunc['db_fetch_assoc']($dbresult))
     {

      echo '<td width="120"><div align="center"><a href="' . $scripturl . '?action=downloads;sa=view;down=' . $row['ID_FILE'] . '"><img src="',$modSettings['down_url'] . $row['thumbfilename'] . '" alt="' .$row['title'] . '" /></a><br />';

      if ($row['real_name'] != '')
         echo 'Aangeboden door: <br /> <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['real_name'] . '</a><br />' . timeformat($row['date']) . '';
     
      else
         echo $txt['downloads_text_by'] . ' ' . $txt['downloads_guest'] . '';
         
      echo '</div></td>';
     }
     $smcFunc['db_free_result']($dbresult);
     
   }
   else
   {  $data = array();
      while($row = $smcFunc['db_fetch_assoc']($dbresult))
      {
         $data[] = $row;
      }
     
     
      return $data;
   }
echo '</tr></table></center>';

}

//END Random downloads horizontaal


[SMFHacks]

Made a couple small changes should work good now

Code: [Select]

//Begin Random Downloads horizontaal
function ssi_downloads_randomdownloads_hor_img( $limit = 5, $output_method = 'echo')
{
   global $smcFunc, $modSettings, $boardurl, $scripturl, $txt;

    $limit = (int)  $limit;
   
    if (empty($modSettings['down_url']))
$modSettings['down_url'] = $boardurl . '/downloads/';
   
$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_FILE, p.totalratings, p.rating, p.commenttotal,
p.filesize, p.views, p.title, p.ID_MEMBER, m.real_name,
p.date, p.description, p.totaldownloads, f.thumbfilename, f.ID_PICTURE,
mg.online_color
FROM ({db_prefix}down_file as p)
LEFT JOIN {db_prefix}members AS m ON (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}membergroups AS mg  ON (m.ID_GROUP = mg.ID_GROUP)
LEFT JOIN {db_prefix}down_file_pic AS f ON (f.ID_PICTURE = p.ID_PICTURE)
WHERE  p.approved = 1 GROUP by RAND() LIMIT $limit");

echo '<center><table cellspacing="20"><tr>';

   if ($output_method == 'echo')
   {
     while($row = $smcFunc['db_fetch_assoc']($dbresult))
     {

      echo '<td width="120"><div align="center">';
      echo '
      <a href="' . $scripturl . '?action=downloads;sa=view;down=' . $row['ID_FILE'] . '">';
     
      if (!empty($row['thumbfilename']))
      echo '<img src="',$modSettings['down_url'] . $row['thumbfilename'] . '" alt="' .$row['title'] . '" />';
      else
      echo $row['title'];
     
     echo '</a><br />';

      if ($row['real_name'] != '')
         echo 'Aangeboden door: <br /> <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['real_name'] . '</a><br />' . timeformat($row['date']) . '';
     
      else
         echo $txt['downloads_text_by'] . ' ' . $txt['downloads_guest'] . '';
         
      echo '</div></td>';
     }
     $smcFunc['db_free_result']($dbresult);
     
   }
   else
   {  $data = array();
      while($row = $smcFunc['db_fetch_assoc']($dbresult))
      {
         $data[] = $row;
      }
     
     
      return $data;
   }
echo '</tr></table></center>';

}

//END Random downloads horizontaal


[Vincent Volmer]

Made a couple small changes should work good now

Thank you very much for your support on this! Its looking very nice (see attachment).

Vincent