Page 1 of 1
phoca gallery top list module
Posted: 30 Oct 2008, 17:00
by crazyluki
hi!
it will be wonderful if you create Jan toplist module to show 5-10-15 top downloaded/watched images
is it possible?
Re: phoca gallery top list module
Posted: 30 Oct 2008, 21:50
by crazyluki
few second ago i had created for my this module
i use mod_php to use this on my site.
Code: Select all
<?php
echo '<table border="0" width="100">
<tr>
<td>Title</td>
<td>Hits</td>
</tr>';
$num = mysql_query("SELECT title, hits FROM `jos_phocagallery`
ORDER BY `jos_phocagallery`.`hits` DESC
LIMIT 0 , 15 ");
while ($row = mysql_fetch_array($num, MYSQL_BOTH)) {
echo ' <tr>
<td>';
echo substr($row[title],0,20);
echo '</td width="120">
<td align="right">';
echo '<b>'.$row[hits].'</b>';
echo '</td>
</tr>';
}
echo '</table>';
?>
Re: phoca gallery top list module
Posted: 30 Oct 2008, 23:35
by Jan
The latest module will be done after I do the random image module, category tree and plugin for version 2
Jan
Re: phoca gallery top list module
Posted: 31 Oct 2008, 13:10
by crazyluki
sorry for offtopic, but i have one suggestion.
you could extend random image module to horizontal or vertical align of images
Re: phoca gallery top list module
Posted: 31 Oct 2008, 18:32
by Jan
the images are displayed in float boxes so if there is a place, images will be displayed horizontally, if not (e.g. module on the right side), then images will be displayed vertically ... you can set this behaviour by setting width of the module...
Jan