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; }
$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']; } else { $LIST_DISPLAYSTYLE = $arr[2] ? "" : "none";
$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;