hi!
it will be wonderful if you create Jan toplist module to show 5-10-15 top downloaded/watched images
is it possible?
phoca gallery top list module
-
- Phoca Member
- Posts: 32
- Joined: 15 Aug 2008, 21:39
Re: phoca gallery top list module
few second ago i had created for my this module
i use mod_php to use this on my site.
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>';
?>
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: phoca gallery top list module
The latest module will be done after I do the random image module, category tree and plugin for version 2
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 15 Aug 2008, 21:39
Re: phoca gallery top list module
sorry for offtopic, but i have one suggestion.
you could extend random image module to horizontal or vertical align of images
you could extend random image module to horizontal or vertical align of images
- Jan
- Phoca Hero
- Posts: 47887
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: phoca gallery top list module
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
Jan
If you find Phoca extensions useful, please support the project