[Block] popular Categories for download system

[fussilet]

author : [Sinan]

link : http://www.simplemachines.org/community/index.php?topic=240522.20

demo: http://www.fussilet.com

phpblock code :

Code Select Expand

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND c.ID_CAT = BÖLÜM
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 35",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

replace AND c.ID_CAT = BÖLÃœM  == > AND c.ID_CAT = '1'

or
AND c.ID_CAT = '2'
or
AND c.ID_CAT = '3'
or
AND c.ID_CAT = '4'..........................

[Smoky]

very nice Fussilet!! good organization!!  :up:

[fussilet]

thanks Smoky

[Smoky]

HoÅŸgeldin

[fussilet]

We tolerated

[bbTURK]

thanks fussilet
--
some chit chat
smoky, are you learning Turkish?
we use "HoÅŸgeldin" like that
"Welcome to tinyportal.co.uk!"
bu you can use  "Bir ÅŸey deÄŸil" or "Önemli deÄŸil" after thank.

[fussilet]

your welcome bbTurk

[hettapiburger]

hello

am not sure whats wrong but..my home page were blank whenever i put this code in my phpblock code..

can u help me?

thank you in advance

[IchBin]

The only way you are going to get help, is if you help us help you. Can you post what you did? Did you change the CAT id to match your downloads cat id?

[hettapiburger]

i havent change anything..but just put the code on php block code..and then i notice that i should change something as noted by fussilet..i thought it will be ok..but the result was just the same..