Recent SMF Gallery Images Block

[softtouch_ph]

This code display the recent gallery images on the frontpage or center blocks.
Its in no way optimized, but works.
I am not a php programmer and do not know php at all, I just tried it with trial and error, so be patient with me...

Code Select Expand

  global $context, $settings, $options, $txt, $scripturl, $modSettings, $ID_MEMBER;
  global $db_prefix, $boarddir,$boardurl;

   $maxpictures = 9; // How many pictures shall be displayed?
   $maxrowlevel = 3; // How many rows of pictures?

  echo'
    <table align="center"><tr><td>';

    $dbresult = db_query("SELECT ID_CAT, title, roworder, description, image FROM {$db_prefix}gallery_cat ORDER BY roworder ASC", __FILE__, __LINE__);
    while ($row = mysql_fetch_assoc($dbresult))
    {
      $cat = $row['ID_CAT'];
      $dbresult2 = db_query("SELECT p.ID_PICTURE, p.commenttotal, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER  AND p.ID_CAT = $cat AND p.approved = 1 ORDER BY ID_PICTURE DESC", __FILE__, __LINE__);
      while ($row2 = mysql_fetch_assoc($dbresult2))
      {
        $dataimg[]=$row2['ID_PICTURE'];
      }
      mysql_free_result($dbresult2);
    }
    mysql_free_result($dbresult);
    rsort($dataimg);

    echo '<table cellspacing="0" cellpadding="10" border="0" align="center" width="90%">
            <tr><td align="center" colspan="' . $maxrowlevel . '">' . '</td>
            </tr>';
    $rowlevel = 0;
    $pictures = 0;
    foreach ($dataimg as $img)
    {
      $dbresult2 = db_query("SELECT p.ID_PICTURE, p.commenttotal, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, p.ID_CAT, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER  AND p.ID_PICTURE = $img AND p.approved = 1 ORDER BY ID_PICTURE DESC", __FILE__, __LINE__);
      $row2 = mysql_fetch_assoc($dbresult2);

      $cat = $row2['ID_CAT'];

      $dbresult = db_query("SELECT ID_CAT, title, roworder, description, image FROM {$db_prefix}gallery_cat WHERE ID_CAT = $cat ORDER BY roworder ASC", __FILE__, __LINE__);
      $row = mysql_fetch_assoc($dbresult);
      $category = $row['title'];
      $catnum = $row['ID_CAT'];
      mysql_free_result($dbresult);


      if($rowlevel == 0)
        echo '<tr>';
      echo '<td align="center"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row2['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row2['thumbfilename']  . '" border="0" /></a><br />';
      echo '<span class="smalltext">' . 'In: ' . '<a href="' . $scripturl . '?action=gallery;cat=' . $catnum . '">' . $category.'</a><br />';
      echo 'Date: ' . timeformat($row2['date']) . '<br />';
      echo 'Comments:' . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row2['ID_PICTURE'] . '">' . $row2['commenttotal'] . '</a>)<br />';
      echo 'By:' . ' <a href="' . $scripturl . '?action=profile;u=' . $row2['ID_MEMBER'] . '">'  . $row2['realName'] . '</a><br />';
      echo '</span></td>';
      if($rowlevel < ($maxrowlevel-1))
        $rowlevel++;
      else
      {
        echo '</tr>';
        $rowlevel = 0;
      }
      mysql_free_result($dbresult2);
      $pictures++;
      if ($pictures == $maxpictures)
        break;
    }
    if($rowlevel !=0) echo '</tr>';
    echo '</table></tr></table>';


[Assistance]

Random Image Block by Thurnok