phoca gallery top list module

[crazyluki]

hi!
it will be wonderful if you create Jan toplist module to show 5-10-15 top downloaded/watched images
is it possible?

[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>';
?>

[Jan]

The latest module will be done after I do the random image module, category tree and plugin for version 2

Jan

[crazyluki]

sorry for offtopic, but i have one suggestion.
you could extend random image module to horizontal or vertical align of images

[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