SimplePortal

Customization => Custom Coding => Topic started by: virsa punjabi on February 21, 2013, 01:38:33 AM

Title: Downloads system block modification to add username
Post by: virsa punjabi on February 21, 2013, 01:38:33 AM
Hi, I have this code on my simple portal
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, m.real_Name, 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 f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY RAND()
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>'; Could anyone please tell me how i can edit this to show user name who has uploaded the song
for example trackname by user
here is the pic how it looks like before modification (http://i48.tinypic.com/ny8r3t.png) [/size] [/font]
Title: Re: Downloads system block modification to add username
Post by: phantomm on February 21, 2013, 02:52:20 AM
Try this code:
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, m.real_Name, 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 f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY RAND()
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a> uploaded by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
Title: Re: Downloads system block modification to add username
Post by: virsa punjabi on February 21, 2013, 03:12:24 AM
Quote from: phantomm on February 21, 2013, 02:52:20 AM
Try this code:
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, m.real_Name, 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 f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY RAND()
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a> uploaded by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
Thank you so much  :D worked like charm thaks heaps:)
Title: Re: Downloads system block modification to add username
Post by: virsa punjabi on February 21, 2013, 03:40:07 AM
One more req.  :nervous-happy: how about username colour in this code?
Title: Re: Downloads system block modification to add username
Post by: phantomm on February 21, 2013, 03:52:20 AM
Maybe someone else will know this, I tried to make it work with other custom block but it didn't worked for me :/

edit:

But try this:
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY RAND()
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a> uploaded by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';


Coloring stolen from [Block] Advanced Who's Online (http://simpleportal.net/index.php?topic=9269.0) by Blue (http://simpleportal.net/index.php?action=profile;u=629).
Title: Re: Downloads system block modification to add username
Post by: WasdMan on February 21, 2013, 04:55:59 AM
Alphabetical order, how do I put the files?
Title: Re: Downloads system block modification to add username
Post by: virsa punjabi on February 21, 2013, 05:02:40 AM
Quote from: phantomm on February 21, 2013, 03:52:20 AM
Maybe someone else will know this, I tried to make it work with other custom block but it didn't worked for me :/

edit:

But try this:
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY RAND()
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a> uploaded by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';


Coloring stolen from [Block] Advanced Who's Online (http://simpleportal.net/index.php?topic=9269.0) by Blue (http://simpleportal.net/index.php?action=profile;u=629).
aww man!! you are a life saver a big hug and thak you again  :D
Title: Re: Downloads system block modification to add username
Post by: virsa punjabi on February 21, 2013, 08:17:37 AM
What about having the recent upload at Top?  :nervous-happy:
Title: Re: Downloads system block modification to add username
Post by: phantomm on February 21, 2013, 08:56:54 AM
This should work ;)
Code: [Select]
global $db_prefix, $scripturl, $smcFunc;

$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY ID_FILE DESC
LIMIT 4");
   echo '
         <table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
            <tr>
               <th style="text-align: left;">Title</td>
               <th colspan="2" style="text-align: right;">Downloads</td>
            </tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 40) .'</a> uploaded by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
SimplePortal 2.3.8 © 2008-2024, SimplePortal