PIMP YOUR GALLERY TUT!!

[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: [Select]

    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: [Select]

  $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: [Select]

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: [Select]

ORDER BY
You can replace

Code: [Select]

views with

Code: [Select]

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: [Select]

DESC LIMIT 5

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

Code: [Select]

WHERE ID_CAT = '???'
It should be used like-

Code: [Select]

     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: [Select]

         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: [Select]

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: [Select]

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: [Select]

         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: [Select]

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: [Select]

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?