$tempCompanyEmail = $row['value'];
// Get SystemURL
$query = "Select * FROM tblconfiguration where setting='SystemURL' limit 0,1";
$result = mysql_query($query) or die("tblconfiguration: SystemURL not found");
if (mysql_num_rows($result) == 0) {
die("tblconfiguration: SystemURL not found");
}
$row = mysql_fetch_assoc($result);
$tempSystemURL = $row['value'];
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$rss = new rss('utf-8');
$rss->channel($tempCompanyName . ' Tickets', $tempSystemURL, $tempCompanyName . ' Tickets');
$rss->language('en-us');
$rss->copyright('Copyright ' . $tempCompanyName);
$rss->managingEditor($tempCompanyEmail);
$rss->category('CategoryName');
$rss->startRSS();
$query = "Select * FROM tbltickets " . $tempSQL . " order by lastreply desc limit 0," . $constTicketsToDisplay;
$result = mysql_query($query) or die("No Tickets Found");
if (mysql_num_rows($result) == 0) {
die("No Tickets Found");
}
while ($row = mysql_fetch_assoc($result)) {
$rss->itemTitle("<![CDATA[" . $row['title'] . "]]>");
$rss->itemLink("<![CDATA[" . $tempSystemURL . "/admin/supporttickets.php?action=viewticket&id=" . $row['id'] . "]]>");
$rss->itemDescription("<![CDATA[" . $row['message'] . "]]>");
$rss->itemAuthor($row['name'] . " " . $row['email']);
$rss->addItem();
}
echo $rss->RSSdoneVar();