[Block] Random Download Block

[IchBin]

This should display a random item from the downloads manager in TP.

Sorry about all the inline CSS but I didn't feel like putting it anywhere else...

Code Select Expand


global $scripturl;

$tp_prefix = $settings['tp_prefix'];

$request = db_query("SELECT * FROM {$tp_prefix}dlmanager
WHERE type = 'dlitem' ORDER BY rand() LIMIT 1", __FILE__, __LINE__);

$row = mysql_fetch_array($request);

echo '
<ul style="padding: 0; list-style-type: none;">
<li><a href="', $scripturl ,'?action=tpmod;dl=get', $row['id'] ,'"><img src="', $row['icon'],'" /></a></li>
<li><b><a href="', $scripturl ,'?action=tpmod;dl=get', $row['id'] ,'">', $row['name'] ,'</a></b></li>
<li style="font-size: x-small"><hr />Uploaded:</li>
<li style="font-size: x-small"><i>', timeformat($row['created']) ,'</i></li>
<li style="font-size: x-small">Downloads: <b>', $row['downloads'] ,'</b></li>
<li style="font-size: x-small">Views: <b>', $row['views'] ,'</b></li>
</ul>';