Free Popular knowledgebase articles RSS feed

[Sheep]

Popular Knowledgebase Articles RSS> I'll do it tomorow (in 13hours) at my bored lunch pause, easy stuff (5mins coding)

[craigbrass]

Oooo, thanks Antoine

[Sheep]

in modules/knowledgebase/rss_view.php

Search

PHP Code:

if ($_SWIFT["settings"]["kb_enrss"] != 1)
{
 exit;
} 


add after

PHP Code:

if (isset($_GET['do']) && $_GET['do']=="popular")
{
 
    $maxitems = intval($_SWIFT["settings"]["kb_maxpopulararticles"]);
    if (empty($maxitems))
    {
        $maxitems = $_SWIFT["settings"]["kb_maxpopulararticles"] = 6;
    }
    $itemlist = $kbarticleidlist = array();
    $dbCore->query("SELECT kbarticles.*, kbarticlelinks.*, kbcategories.categorytype FROM `". TABLE_PREFIX ."kbarticles` AS kbarticles LEFT JOIN `". TABLE_PREFIX ."kbarticlelinks` AS kbarticlelinks ON (kbarticles.kbarticleid = kbarticlelinks.kbarticleid) LEFT JOIN `". TABLE_PREFIX ."kbcategories` AS kbcategories ON (kbarticlelinks.kbcategoryid = kbcategories.kbcategoryid) LEFT JOIN `". TABLE_PREFIX ."tgroupassigns` AS tgroupassigns ON (kbarticlelinks.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '". TGROUP_KNOWLEDGEBASE ."') WHERE (tgroupassigns.tgroupid = '". intval($_SWIFT["tgroup"]["tgroupid"]) ."') OR (kbarticlelinks.kbcategoryid = 0) ORDER BY kbarticles.views DESC LIMIT ". intval($maxitems) .";");
    $index = 1;
    while ($dbCore->nextRecord())
    {
 
        if ($dbCore->Record["articlestatus"] != "published" || $dbCore->Record["categorytype"] != "public")
        {
            continue;
        }
        if (!in_array($dbCore->Record["kbarticleid"], $kbarticleidlist))
        {
            $itemlist[$index] = $dbCore->Record;
            $index++;
        }
    }
 
    $xml->addParentTag("rss", array("version" => "2.0"));
    $xml->addParentTag("channel");
        $xml->addTag("title", sprintf($_SWIFT["language"]["rsskb"], $_kbcategory["title"]));
        $xml->addTag("link", $_SWIFT["swiftpath"]."index.php?_m=knowledgebase&_a=view&parentcategoryid=".intval($_kbcategoryid));
        $xml->addTag("description", sprintf($_SWIFT["language"]["rsskbdesc"], $_SWIFT["settings"]["general_companyname"]));
        $xml->addTag("language", $_SWIFT["adminlanguage"]);
        $xml->addTag("copyright", $_SWIFT["settings"]["general_companyname"]);
        foreach ($itemlist as $key => $val)
        {        
            $xml->addParentTag("item");
                $xml->addTag("title", $val["subject"]);
                $xml->addTag("link", $_SWIFT["swiftpath"]."index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=". intval($key));
                $xml->addTag("description", $val["contents"]);
            $xml->endParentTag("item");
        }          
 
    $xml->endParentTag("channel");
    $xml->endParentTag("rss");
    header("Content-Type: text/xml".SWIFT_CRLF);
    echo $xml->returnXML();
    exit();
} 


The SQL querry isn't enougth to display the content of the kb article (i'm too lazzy to do it). This is just a copy paste from a kayako's querry.

But you have the big idea

now go to
rss/index.php?_m=knowledgebase&_a=view&do=popular

[Jamie Edwards]

Thread split. Thanks for coding this up, Antoine

[sqzdog]

What editor do I use to edit this code? It is just a bunch of jumbled characters.

[craigbrass]

Your on a leased licence. Unfortunatly that doesn't come with source code (hence it being encoded). You can email jamie.edwards <!at!> kayako <!dot!> com to get the file(s) you need in unencoded form.

[sqzdog]

I would have NEVER figured that out. Thanks!

[craigbrass]

Your welcome.