function get_rss()
{
global $aa;
require_once e_PLUGIN . "content/handlers/content_class.php";
$aa = new content();
$rss = array();
$array = $aa->getCategoryTree('', '', FALSE);
foreach ($array as $k => $v) {
$name = '';
for ($i = 0; $i < count($array[$k]); $i++) {
$name .= $array[$k][$i + 1] . " > ";
$i++;
}
$name = substr($name, 0, -3);
$feed['name'] = $name;
$feed['url'] = 'content';
//the identifier for the rss feed url
$feed['topic_id'] = $k;
//the topic_id, empty on default (to select a certain category)
$feed['path'] = 'content';
//this is the plugin path location
$feed['text'] = 'this is the rss feed for content category : ' . $name;
$feed['class'] = '0';
$feed['limit'] = '9';
$rss[] = $feed;
}
return $rss;
}
function status()
{
$sql = e107::getDb();
$aa = new content();
if ($maincat = $sql->retrieve("pcontent", "content_id, content_heading", " WHERE content_parent = '0' ORDER BY content_heading", true)) {
$i = 0;
foreach ($maincat as $row) {
$count = 0;
$array = $aa->getCategoryTree("", $row['content_id'], TRUE);
$validparent = implode(",", array_keys($array));
$qrycat = " content_parent REGEXP '" . $aa->CONTENTREGEXP($validparent) . "' ";
$count = $sql->count("pcontent", "(*)", "WHERE " . $qrycat . " AND content_refer != 'sa' ");
$var[$i]['icon'] = "<img src='" . e_PLUGIN_ABS . "content/images/content_16.png' style='width: 16px; height: 16px; vertical-align: bottom' alt='' /> ";
$var[$i]['title'] = $row['content_heading'];
$var[$i]['url'] = e_PLUGIN . "content/admin_content_config.php?content." . $row['content_id'];
$var[$i]['total'] = $count;
$i = $i + 1;
}
}
return $var;
}
while ($rowm = $sqlm->db_Fetch()) {
$ICON = "";
$HEADING = "";
$AUTHOR = "";
$CATEGORY = "";
$DATE = "";
$INFO = "";
$LIST_CAPTION = $rowm['content_heading'];
//global var for this main parent
$mainparent = $rowm['content_id'];
//get path variables
$content_recent_pref = $aa->getContentPref($mainparent);
$content_recent_pref["content_icon_path"] = $content_recent_pref["content_icon_path"] ? $content_recent_pref["content_icon_path"] : "{e_PLUGIN_ABS}content/images/icon/";
$content_icon_path = $tp->replaceConstants($content_recent_pref["content_icon_path"]);
//prepare query string
$array = $aa->getCategoryTree("", $mainparent, TRUE);
$validparent = implode(",", array_keys($array));
$qry = " content_refer !='sa' AND content_parent REGEXP '" . $aa->CONTENTREGEXP($validparent) . "' AND content_class REGEXP '" . e_CLASS_REGEXP . "' ";
//check so only the preferences from the correct content_type (article, content, review etc) are used and rendered
if (substr($contentmode, 8) == $rowm['content_id']) {
if ($mode == "new_page" || $mode == "new_menu") {
$lvisit = $this->getlvisit();
$qry = $qry . " AND content_datestamp>" . $lvisit;
} else {
$qry = $qry . " " . $datequery;
}
$qry .= " ORDER BY content_datestamp DESC LIMIT 0," . intval($arr[7]);
//get recent content for each main parent
$sqli = new db();
if (!($resultitem = $sqli->db_Select("pcontent", "*", $qry))) {
$LIST_DATA = CONTENT_MENU_LAN_5 . " " . $rowm['content_heading'];
$content_pref = e107::unserialize($row['content_pref']);
//$content_pref = $eArrayStorage->ReadxxxArray($row['content_pref']);
$content_pref["content_cat_icon_path_large"] = $content_pref["content_cat_icon_path_large"] ? $content_pref["content_cat_icon_path_large"] : "{e_PLUGIN}content/images/cat/48/";
$content_pref["content_cat_icon_path_small"] = $content_pref["content_cat_icon_path_small"] ? $content_pref["content_cat_icon_path_small"] : "{e_PLUGIN}content/images/cat/16/";
$content_cat_icon_path_large = $tp->replaceConstants($content_pref["content_cat_icon_path_large"]);
$content_cat_icon_path_small = $tp->replaceConstants($content_pref["content_cat_icon_path_small"]);
$content_icon_path = $tp->replaceConstants($content_pref["content_icon_path"]);
if ($content_pref["content_submit"] && check_class($content_pref["content_submit_class"])) {
$content_submit_type_table_string .= $tp->parseTemplate($CONTENT_SUBMIT_TYPE_TABLE, FALSE, $newcontent_shortcodes);
$count = $count + 1;
}
}
if ($count == "0") {
$text .= "<div style='text-align:center;'>" . CONTENT_ADMIN_SUBMIT_LAN_0 . "</div>";
} else {
$text = $CONTENT_SUBMIT_TYPE_TABLE_START . $content_submit_type_table_string . $CONTENT_SUBMIT_TYPE_TABLE_END;
}
}
$caption = CONTENT_ADMIN_SUBMIT_LAN_1;
$ns->tablerender($caption, $text);
}
if (isset($qs[0]) && $qs[0] == "content" && $qs[1] == "submit" && is_numeric($qs[2]) && !isset($qs[3])) {
//check if valid categories exist for this main parent
$array = $aa->getCategoryTree("", intval($qs[2]), TRUE);
$validparent = implode(",", array_keys($array));
$qry = " content_parent REGEXP '" . $aa->CONTENTREGEXP($validparent) . "' ";
$sql2 = new db();
//$contenttotal = $sql2 -> db_Count($plugintable, "(*)", "WHERE ".$qry." ".$datequery." AND content_class REGEXP '".e_CLASS_REGEXP."' " );
$aform->show_create_content("submit");
}
require_once FOOTERF;
$fl = new e_file();
global $tp;
$deltest = array_flip($_POST);
// check query
if (isset($_POST['delete'])) {
$tmp = array_pop(array_flip($_POST['delete']));
list($delete, $del_id) = explode("_", $tmp);
}
$sql = e107::getDb();
// ##### DB ---------------------------------------------------------------------------------------
if (isset($delete) && $delete == 'cat') {
$record = $sql->retrieve($plugintable, 'content_id,content_heading,content_parent', "content_id = '{$del_id}' ");
$content_id = $record['content_id'];
$content_heading = $record['content_heading'];
$content_parent = $record['content_parent'];
$checkarray = $aa->getCategoryTree("", $content_id, TRUE);
unset($agc);
//unset the globalised getCategoryTree array
$checkvalidparent = implode(",", array_keys($checkarray));
$checkqry = " content_parent REGEXP '" . $aa->CONTENTREGEXP($checkvalidparent) . "' ";
//check if subcats present
if (count($array) > 1) {
//subcategories found don't delete
$checkermsg .= CONTENT_ADMIN_CAT_LAN_36 . "<br />";
$checksubcat = TRUE;
} else {
$checkermsg .= CONTENT_ADMIN_CAT_LAN_39 . "<br />";
$checksubcat = FALSE;
}
//check if items present
if ($sql->count($plugintable, "(*)", "WHERE " . $checkqry . " ")) {
