PIMP YOUR GALLERY TUT!!

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
   Badge Awards
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   Buy Website Traffic
   Site Showcase
   Email Marketing Software

Advanced search

[Jpg]

Ok, let me add this in...

----------

Done, Now they work like a charm.

[Me_angus]

Add this where? And is the bug fix you mentioned in SSI Mod topic?

Need to add this to query  WHERE approved = 1

[SMFHacks]

Yeah same fix this is just for the random image.

[Jpg]

Any ideas man?
I noticed that the logo, etc...
Doesn't show up in the add images section,etc....hmmm....
I'll take a look into this.

[Jpg]

I'm back with another tutorial on Gallery Lite...Show top 5 most popular images in the gallery in a category.

This is the code for most popular/most viewed images in your gallery.
[This is for a php block with tinyportal if you have.]

Code:

    global $scripturl,$db_prefix,$modSettings,$boardurl;

  echo'<p align="left"><font  size="1"><b>Popular</b></font></p>';
  echo'<table cellspacing="0" cellpadding="5" border="0"  align="center" width="90%"><tr>';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
  $request = db_query("SELECT thumbfilename,ID_PICTURE FROM {$db_prefix}gallery_pic WHERE approved = '1' GROUP BY thumbfilename ORDER BY views DESC LIMIT 5", __FILE__,__LINE__);
  while ($row = mysql_fetch_assoc($request))
  echo' <center><td align="center" colspan="3"><a href="', $scripturl, '?action=gallery;sa=view;id=',
  $row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] .

  $row['thumbfilename'] ,'" /></a></center>';
  echo'</td></tr>';
  echo'</table></br>';
  mysql_free_result($request);

Lemme break some of this code apart for everyone to learn some php.

This section of the code controls what data of the code above shows.

 

Code:

  $request = db_query("SELECT thumbfilename,ID_PICTURE FROM {$db_prefix}gallery_pic WHERE approved = '1' GROUP BY thumbfilename ORDER BY views DESC LIMIT 5", __FILE__,__LINE__);

Code:

WHERE approved = '1'

Shows only images been approved or not.



This following code orders the thumbnails with the next comman which can be anything.

Code:

ORDER BY

You can replace

Code:

views

with

Code:

date

to do it by newest if you want.


The next code shows the number of thumbnails descending. Just change the number 5 to anything else you want.

Code:

DESC LIMIT 5

The next code is to organize the thumbnails by category if you only want 1 you add this code.

Code:

WHERE ID_CAT = '???'

It should be used like-

Code:

     global $scripturl,$db_prefix,$modSettings,$boardurl;

  echo'<p align="left"><font  size="1"><b>Category 1</b></font></p>';
  echo'<table cellspacing="0" cellpadding="5" border="0"  align="center" width="90%"><tr>';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
$request = db_query("SELECT thumbfilename, ID_CAT, ID_PICTURE FROM {$db_prefix}gallery_pic  WHERE ID_CAT = '1' GROUP BY thumbfilename ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
$row = mysql_fetch_assoc($request);
  while ($row = mysql_fetch_assoc($request))
  echo' <center><td align="center" colspan="3"><a href="', $scripturl, '?action=gallery;sa=view;id=',
  $row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] .

  $row['thumbfilename'] ,'" /></a></center>';
  echo'</td></tr>';
  echo'</table></br>';
  mysql_free_result($request);

There are other commands but these are the basics.
-------------
I actually redid the whole gallery package with completely different templates and drop down menus to go through categories...and I learned how to integrate it with the default profile...
I also learned how to add shadows to images...but I don't think SmfHacks would appreciate a hooked up version of gallery lite running around with unique features that gallery pro doesn't even have...
So I'll keep it personal...I really wish I had gallery pro though.
I wouldn't even need to hook up gallery lite. <.<
I'll release probably the full hack later on when I finish it..lol..

[Jpg]

Yowza, haven't even been using TP lately..but then again I think I should release one more trick I have.

Well this trick gives you newest and most popular 5 images on your gallery main...but looks just like Gallery Pro...in the fact I used the catbgs and tite classses to decorate them.


Add them below this code:

Code:

         echo '</tr>';
         if($g_manage)
         {
            echo '<tr class="titlebg">
            <td colspan="6"> </td>
         </tr>';
         }
         else
            echo '<tr class="titlebg">
            <td colspan="4"> </td>
         </tr>';

         mysql_free_result($dbresult2);

      }
      mysql_free_result($dbresult);
      echo '</table><br /><br /><br />';

Newest Code-

Code:

echo'
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="titlebg">
               <td align="center" width="100%" >Newest</td>
            </tr></table>
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="windowbg2">
         <td align="center" width="100%" >';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
      $dbresult = 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.approved = 1 ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
      $rowlevel = 0;
      while($row = mysql_fetch_assoc($dbresult))
      {
         if($rowlevel == 0)

         echo '<center><td align="center" width="100%" ><span class="img-shadow"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row['thumbfilename']  . '" border="0" /></a></span><br />';
         echo ' <td align="center" width="100%" ><span class="smalltext">' . $txt['gallery_text_views'] . $row['views'] . '<br />';
         echo $txt['gallery_text_filesize'] . round($row['filesize'] / 1024, 2) . 'KB<br />';
         echo $txt['gallery_text_date'] . timeformat($row['date']) . '<br />';
         echo $txt['gallery_text_comments'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['commenttotal'] . '</a>)<br />';
         echo $txt['gallery_text_by'] . ' <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['realName'] . '</a><br />';

         echo '</span>';
      }
  echo'</td></tr></center>';
  echo'</table></br>';
      mysql_free_result($dbresult);

Popular/Top 5 Most Viewed-

Code:

echo'
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="titlebg">
               <td align="center" width="100%" >Popular</td>
            </tr></table>
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="windowbg2">
         <td align="center">';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
      $dbresult = 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.approved = 1 ORDER BY views DESC LIMIT 5", __FILE__, __LINE__);
      $rowlevel = 0;
      while($row = mysql_fetch_assoc($dbresult))
      {
         if($rowlevel == 0)

         echo '<center><td align="center"  ><span class="img-shadow"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row['thumbfilename']  . '" border="0" /></a></span><br />';
         echo ' <td align="center" width="100%" ><span class="smalltext">' . $txt['gallery_text_views'] . $row['views'] . '<br />';
         echo $txt['gallery_text_filesize'] . round($row['filesize'] / 1024, 2) . 'KB<br />';
         echo $txt['gallery_text_date'] . timeformat($row['date']) . '<br />';
         echo $txt['gallery_text_comments'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['commenttotal'] . '</a>)<br />';
         echo $txt['gallery_text_by'] . ' <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['realName'] . '</a><br />';

         echo '</span>';
      }
  echo'</td></tr></center>';
  echo'</table></br>';
      mysql_free_result($dbresult);

[Jump1979man]

nice work.

[SoulPleX]

'add shadows to images' what does this mean?  If i place my mouse over a image in my gallery i want it to blow up in a bigger box for viewing. I hope that made since. Is adding shadows to images th same then?? 

[MinasC]

woooooow , great work Jpg !!!!

[Hassan]

Yowza, haven't even been using TP lately..but then again I think I should release one more trick I have.

Well this trick gives you newest and most popular 5 images on your gallery main...but looks just like Gallery Pro...in the fact I used the catbgs and tite classses to decorate them.


Add them below this code:

Code:

         echo '</tr>';
         if($g_manage)
         {
            echo '<tr class="titlebg">
            <td colspan="6"> </td>
         </tr>';
         }
         else
            echo '<tr class="titlebg">
            <td colspan="4"> </td>
         </tr>';

         mysql_free_result($dbresult2);

      }
      mysql_free_result($dbresult);
      echo '</table><br /><br /><br />';

Newest Code-

Code:

echo'
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="titlebg">
               <td align="center" width="100%" >Newest</td>
            </tr></table>
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="windowbg2">
         <td align="center" width="100%" >';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
      $dbresult = 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.approved = 1 ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
      $rowlevel = 0;
      while($row = mysql_fetch_assoc($dbresult))
      {
         if($rowlevel == 0)

         echo '<center><td align="center" width="100%" ><span class="img-shadow"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row['thumbfilename']  . '" border="0" /></a></span><br />';
         echo ' <td align="center" width="100%" ><span class="smalltext">' . $txt['gallery_text_views'] . $row['views'] . '<br />';
         echo $txt['gallery_text_filesize'] . round($row['filesize'] / 1024, 2) . 'KB<br />';
         echo $txt['gallery_text_date'] . timeformat($row['date']) . '<br />';
         echo $txt['gallery_text_comments'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['commenttotal'] . '</a>)<br />';
         echo $txt['gallery_text_by'] . ' <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['realName'] . '</a><br />';

         echo '</span>';
      }
  echo'</td></tr></center>';
  echo'</table></br>';
      mysql_free_result($dbresult);

Popular/Top 5 Most Viewed-

Code:

echo'
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="titlebg">
               <td align="center" width="100%" >Popular</td>
            </tr></table>
<table cellspacing="0" cellpadding="5" border="0" align="center" width="100%" class="tborder">
            <tr class="windowbg2">
         <td align="center">';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
      $dbresult = 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.approved = 1 ORDER BY views DESC LIMIT 5", __FILE__, __LINE__);
      $rowlevel = 0;
      while($row = mysql_fetch_assoc($dbresult))
      {
         if($rowlevel == 0)

         echo '<center><td align="center"  ><span class="img-shadow"><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row['thumbfilename']  . '" border="0" /></a></span><br />';
         echo ' <td align="center" width="100%" ><span class="smalltext">' . $txt['gallery_text_views'] . $row['views'] . '<br />';
         echo $txt['gallery_text_filesize'] . round($row['filesize'] / 1024, 2) . 'KB<br />';
         echo $txt['gallery_text_date'] . timeformat($row['date']) . '<br />';
         echo $txt['gallery_text_comments'] . ' (<a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '">' . $row['commenttotal'] . '</a>)<br />';
         echo $txt['gallery_text_by'] . ' <a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['realName'] . '</a><br />';

         echo '</span>';
      }
  echo'</td></tr></center>';
  echo'</table></br>';
      mysql_free_result($dbresult);

this just doesn't work for me and i did everthing that was asked?

Help Support the SMFHacks.com mod making.