Download content RSS feed

[SMFHacks]

This will require a minor edit to Downloads2.php since this will not be what everyone needs here

Around line 1279
change

Code: [Select]

// Get the download information
$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_FILE, p.totalratings, p.rating, p.allowcomments, p.ID_CAT, p.keywords,
p.commenttotal, p.filesize, p.filename, p.orginalfilename, p.fileurl, p.extrafilescount,
p.approved, p.views, p.title, p.ID_MEMBER, m.real_name, p.date, p.description,
    c.title CAT_TITLE, c.ID_PARENT, c.disablerating, p.credits, p.totaldownloads,  p.lastdownload,
    c.minposts, c.agelimit, p.ID_PICTURE, mg.online_color, p.ID_TOPIC
FROM ({db_prefix}down_file as p,  {db_prefix}down_cat AS c)
LEFT JOIN {db_prefix}members AS m ON  (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}membergroups AS mg  ON (m.ID_GROUP = mg.ID_GROUP)
WHERE p.ID_FILE = $id AND p.ID_CAT = c.ID_CAT LIMIT 1");

    // Check if download exists
    if ($smcFunc['db_affected_rows']()== 0)
    fatal_error($txt['downloads_error_no_downloadexist'], false);

    $row = $smcFunc['db_fetch_assoc']($dbresult);


To

Code: [Select]

// Get the download information
$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_FILE, p.totalratings, p.rating, p.allowcomments, p.ID_CAT, p.keywords,
p.commenttotal, p.filesize, p.filename, p.orginalfilename, p.fileurl, p.extrafilescount,
p.approved, p.views, p.title, p.ID_MEMBER, m.real_name, p.date, p.description,
    c.title CAT_TITLE, c.ID_PARENT, c.disablerating, p.credits, p.totaldownloads,  p.lastdownload,
    c.minposts, c.agelimit, p.ID_PICTURE, mg.online_color, p.ID_TOPIC, c.image, c.filename imagefilename
FROM ({db_prefix}down_file as p,  {db_prefix}down_cat AS c)
LEFT JOIN {db_prefix}members AS m ON  (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}membergroups AS mg  ON (m.ID_GROUP = mg.ID_GROUP)
WHERE p.ID_FILE = $id AND p.ID_CAT = c.ID_CAT LIMIT 1");

    // Check if download exists
    if ($smcFunc['db_affected_rows']()== 0)
    fatal_error($txt['downloads_error_no_downloadexist'], false);

    $row = $smcFunc['db_fetch_assoc']($dbresult);


if ($row['image'] == '' && $row['imagefilename'] == '')
{

}
else
{
if ($row['filename'] == '')
$row['description'] =  '<img src="' . $row['imagefilename'] . '" alt="" />' . "\n"  . $row['description'];
else
$row['description'] =  '<img src="' . $modSettings['down_url'] . 'catimgs/' . $row['imagefilename'] . '" alt="" />' . "\n" . $row['description';
}





[coolfx35]

I made the code changes you made but I still don't get any images
http://forum.youmobile.org/downloads/?sa=view;down=3875

[SMFHacks]

This one should fix it.

Code: [Select]

// Get the download information
$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_FILE, p.totalratings, p.rating, p.allowcomments, p.ID_CAT, p.keywords,
p.commenttotal, p.filesize, p.filename, p.orginalfilename, p.fileurl, p.extrafilescount,
p.approved, p.views, p.title, p.ID_MEMBER, m.real_name, p.date, p.description,
    c.title CAT_TITLE, c.ID_PARENT, c.disablerating, p.credits, p.totaldownloads,  p.lastdownload,
    c.minposts, c.agelimit, p.ID_PICTURE, mg.online_color, p.ID_TOPIC, c.image, c.filename imagefilename
FROM ({db_prefix}down_file as p,  {db_prefix}down_cat AS c)
LEFT JOIN {db_prefix}members AS m ON  (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}membergroups AS mg  ON (m.ID_GROUP = mg.ID_GROUP)
WHERE p.ID_FILE = $id AND p.ID_CAT = c.ID_CAT LIMIT 1");

    // Check if download exists
    if ($smcFunc['db_affected_rows']()== 0)
    fatal_error($txt['downloads_error_no_downloadexist'], false);

    $row = $smcFunc['db_fetch_assoc']($dbresult);


if ($row['image'] == '' && $row['imagefilename'] == '')
{

}
else
{
if ($row['imagefilename'] == '')
$row['description'] =  '<img src="' . $row['imagefilename'] . '" alt="" />' . "\n"  . $row['description'];
else
$row['description'] =  '<img src="' . $modSettings['down_url'] . 'catimgs/' . $row['imagefilename'] . '" alt="" />' . "\n" . $row['description'];
}





[coolfx35]

still not working, please check your forum personal messages

[coolfx35]

It's working now thank you

[SMFHacks]

Glad you have it working

[coolfx35]

Glad you have it working

Thank you for all your help, we are glad to purchase your product.

[coolfx35]

How to control the RSS feed content number ? it's currently 50

how to change it ?

thank you,

[SMFHacks]

In Sources/Downloads2.php
Find and change

Code: [Select]

WHERE p.approved = 1 AND (c.view IS NULL || c.view =1) GROUP by p.ID_FILE ORDER BY p.ID_FILE DESC LIMIT 50


[coolfx35]

If i want to display a special message only in categories that is empty (no downloads added yet).

Which part of the code I can echo a message only when the table is empty ?

thank you,

[coolfx35]

If i want to display a special message only in categories that is empty (no downloads added yet).

Which part of the code I can echo a message only when the table is empty ?

thank you,

[SMFHacks]

In downloads2.template.php around line 174

Code: [Select]

// Options
if ($g_manage)
{
echo '<th scope="col" class="smalltext last_th">',$txt['downloads_cat_options'],'</th>';
$count++;
}

echo '
        </tr></thead>';


$downloadClass = 'windowbg';

foreach ($context['downloads_files'] as $i => $file)
Before

Code: [Select]

foreach ($context['downloads_files'] as $i => $file)


[coolfx35]

Where I can edit/modify the top buttons "buttonlist floattop" ? which file ?

thank you

[coolfx35]

Hi,
I solved the button issue above.

Now I am looking on how to add OG:TAGS to the rest of the download module, not just the download page. I want to add specific OG:tags to the index page and category pages too.

Please help,

[SMFHacks]

You would need to use $context['html_headers'] .= 'your  og tags here';
In Sources/Downloads2.php