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.]
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.
$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__);
WHERE approved = '1'
Shows only images been approved or not.
This following code orders the thumbnails with the next comman which can be anything.
ORDER BY
You can replace
views
with
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.
DESC LIMIT 5
The next code is to organize the thumbnails by category if you only want 1 you add this code.
WHERE ID_CAT = '???'
It should be used like-
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..
SMFHacks.com 
SMFHacks
Members
Total Members: 10807
Stats
Users Online
Author