Exemplos de getCategory_name em PHP

Exemplo n.º 1

Arquivo: archive_manager.php Projeto: sudogem/brcms

 $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
 $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
 $row_data .= '<td>';
 $row_data .= $j++;
 $row_data .= '</td>';
 $row_data .= '<td>';
 $row_data .= '<input type="checkbox" name="cid[]" id="cb' . $i . '" value="' . $my_articles[$i]->articleID . '" onClick="isChecked(this.checked);"/>';
 $row_data .= '</td>';
 $row_data .= '<td>';
 $row_data .= '<a href="' . VIEW_ARTICLE_URL . $my_articles[$i]->articleID . '">';
 $title = getArticleTitle($my_articles[$i]->articleID);
 $row_data .= '&nbsp;' . $title;
 $row_data .= '</a>';
 $row_data .= '</td>';
 $row_data .= '<td class="blue2">';
 $category_name = getCategory_name($my_articles[$i]->articleID);
 $row_data .= '&nbsp;' . $category_name;
 $row_data .= '</td>';
 $row_data .= '<td ';
 switch ($my_articles[$i]->stageID) {
     case 1:
         // draft
         $row_data .= 'class="black">';
         break;
     case 2:
         //writing
         $row_data .= 'class="cyan">';
         break;
     case 3:
         //editing
         $row_data .= 'class="blue">';

Exemplo n.º 2

Arquivo: report_newscontents.php Projeto: sudogem/brcms

}
$_SESSION['newscontent_report'] = $article_versions;
//print_r($article_versions);
$row_data = '';
for ($i = 0; $i < count($article_versions); $i++) {
    if ($article_versions[$i]->articleID) {
        $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
        $row_data .= '<tr class="tdhover" id="tdata" bgcolor = "' . $bgcolor . '">';
        $row_data .= '<td>';
        $row_data .= $i + 1;
        $row_data .= '</td>';
        $row_data .= '<td class="blue">';
        $row_data .= '&nbsp;' . $article_versions[$i]->title;
        $row_data .= '</td>';
        $row_data .= '<td class="viola">';
        $category_name = getCategory_name($article_versions[$i]->articleID);
        $row_data .= '&nbsp;' . $category_name;
        $row_data .= '</td>';
        $row_data .= '<td class="cyan">';
        $author_name = getArticle_authors($article_versions[$i]->articleID);
        $row_data .= '&nbsp;' . $author_name;
        $row_data .= '</td>';
        $row_data .= '<td class="blue2">';
        $category_name = getFrontpage_type($article_versions[$i]->articleID);
        $row_data .= '&nbsp;' . $category_name;
        $row_data .= '</td>';
        $row_data .= '<td class="green">';
        $row_data .= '&nbsp;' . getstage_name($article_versions[$i]->stageID);
        $row_data .= '</td>';
        $row_data .= '<td class="brown">';
        $row_data .= '&nbsp;' . friendlyDate2($article_versions[$i]->created);

Exemplo n.º 3

Arquivo: preview_publisher_reports.php Projeto: sudogem/brcms

$publisher_articles_reports = $_SESSION['report_published_articles'];
for ($i = 0; $i < count($publisher_articles_reports); $i++) {
    if ($publisher_articles_reports[$i]->articleID) {
        $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
        $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
        $row_data .= '<td>';
        $row_data .= $i + 1;
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= '<a href="' . VIEW_ARTICLE_URL . $publisher_articles_reports[$i]->articleID . '">';
        $title = getArticleTitle($publisher_articles_reports[$i]->articleID);
        $row_data .= '&nbsp;' . $title;
        $row_data .= '</a>';
        $row_data .= '</td>';
        $row_data .= '<td class="blue2">';
        $category_name = getCategory_name($publisher_articles_reports[$i]->articleID);
        $row_data .= $category_name;
        $row_data .= '</td>';
        $row_data .= '<td>';
        $category_name = getFrontpage_type($publisher_articles_reports[$i]->articleID);
        $row_data .= '&nbsp;' . $category_name;
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= getArticle_authors_info($publisher_articles_reports[$i]->articleID, 'fullname');
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= getUser_info($publisher_articles_reports[$i]->edited_by, 'fullname');
        $row_data .= '</td>';
        $row_data .= '<td class="brown">';
        $row_data .= '&nbsp;' . friendlydate2($publisher_articles_reports[$i]->created);
        $row_data .= '</td>';

Exemplo n.º 4

Arquivo: edit_article.php Projeto: sudogem/brcms

        $tasklist .= '</option>';
    }
}
// Get all the news category
$sql = " select * from category ";
if (!($result = $db->query($sql))) {
    die('Error:' . $db->error());
}
// Populate all the news-category into an array..
$category = array();
while ($row = $db->fetcharray()) {
    $category[] = $row;
}
$db->freeresult();
// Get the current category of the article..
$current_category_name = getCategory_name($_SESSION['articleID']);
$category_names = '';
foreach ($category as $field => $data) {
    // set the default category of the article..
    if ($data->category_name == $current_category_name) {
        $category_names .= '<option value="' . $data->categoryID . '" selected>';
        $category_names .= $data->category_name;
        $category_names .= '</option>';
    } else {
        // loop other categorys
        $category_names .= '<option value="' . $data->categoryID . '">';
        $category_names .= $data->category_name;
        $category_names .= '</option>';
    }
}
// Return the allowable stages to be set given the stageID of the article..

Exemplo n.º 5

Arquivo: temp_view_article-detail.php Projeto: sudogem/brcms

$_SESSION['articleID'] = $articleID;
// PROBLEM MIGHT BE SOMETHING HERE.....
/*
$sql = " select * from articles a, ";
$sql .= " article_author aa ";
$sql .= " where aa.userID = " . intval($userID);
$sql .= " and aa.articleID = " . intval($articleID) ;
*/
$sql = " select * from article_versions av ";
$sql .= " where av.stageID=2";
// editing stage
$sql .= " and av.articleID=" . $articleID;
$sql .= " order by av.created ASC ";
print $sql;
if (!($result = $db->query($sql))) {
    die('Error:' . $db->error());
}
$view_article_detail = array();
while ($row = $db->fetcharray()) {
    $view_article_detail[] = $row;
}
//print_r ($view_article_detail);
$db->freeresult();
$category_name = getCategory_name($articleID);
$article_authors = getUser_info($userID, 'fullname');
// ok baby, let start compiling the page now..go! go! go! {mh}
$tpl = new template_parser('../templates/view_article_detail.tpl.php');
$tags = array('{ARTICLE_TITLE}' => $view_article_detail[0]->title, '{CATEGORY}' => $category_name, '{AUTHOR}' => $article_authors, '{DATE_CREATED}' => friendlyDate($view_article_detail[0]->created), '{ARTICLE_BODY}' => $view_article_detail[0]->article_body, '{SITENAME}' => 'CMS Adminss', '{HEADER}' => ' ', '{TOPNAV}' => 'Place the fixed button here like #. of users - online, log-out btn can also place here..', '{SIDENAV}' => 'user_menu2.php', '{FOOTER}' => 'footer.php');
$tpl->parse_template($tags);
print $tpl->display();
//print '<h1>So far you have ' . $n  . ' article(s) been written :)</h1>';

Exemplo n.º 6

Arquivo: view_article.php Projeto: sudogem/brcms

            if ($field == 'categoryID') {
                $article_categoryID = $article_category[$j]->categoryID;
            }
        }
        if ($categoryID == $article_categoryID) {
            $subsections .= '<li><a href="' . VIEW_ARTICLE_URL2 . $article_category[$j]->articleID . '">' . $article_category[$j]->title . '</a></li>';
        }
    }
    $subsections .= '</ul>';
    $subsections .= '</div>';
    if (($t = $i + 1) % 4 == 0) {
        $subsections .= '<div class="clear"></div>';
    }
}
$articleID = $_GET['articleID'];
$heading_category = getCategory_name($articleID, 'category_name');
$other_headlines_cat = ' other ' . $heading_category . ' headlines';
$link = "download_doc.php?articleID=" . intval($view_article[0]->articleID);
/**
 * Get the active banner ads 148x300
 */
$banner = new rotate_banner();
$bannerdata = $banner->view_banner('148x300');
$ads148x300 = '';
if ($bannerdata) {
    if (checkhttptext($bannerdata->banner_clickURL)) {
        $ads148x300 .= '<p><a href="' . $PHP_SELF . '?bannerID=' . $bannerdata->bannerID . '">';
        $ads148x300 .= '<img src="' . makeRelativePath($bannerdata->banner_imageurl, 7) . '" border="0" ></a>';
        $ads148x300 .= '</p>';
    } else {
        $ads148x300 .= '<p><a href="' . $PHP_SELF . '?bannerID=' . $bannerdata->bannerID . '">';

Exemplo n.º 7

Arquivo: article_reports.php Projeto: sudogem/brcms

 }
 if ($no_records_found) {
     $result_msg = 'No Records Found';
 } else {
     for ($i = 0; $i < count($reports); $i++) {
         if ($reports[$i]->article_versionID) {
             $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
             $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
             $row_data .= '<td>';
             $row_data .= $i + 1;
             $row_data .= '</td>';
             $row_data .= '<td class="blue">';
             $row_data .= $reports[$i]->title;
             $row_data .= '</td>';
             $row_data .= '<td class="viola">';
             $category_name = getCategory_name($reports[$i]->articleID);
             $row_data .= $category_name;
             $row_data .= '</td>';
             $row_data .= '<td class="brown" >';
             $row_data .= getArticle_authors_info($reports[$i]->articleID, 'fullname');
             $row_data .= '</td>';
             $row_data .= '<td class="cyan">';
             $row_data .= getUser_info($reports[$i]->edited_by, 'fullname');
             $row_data .= '</td>';
             $row_data .= '<td class="black">';
             $row_data .= friendlyDate2($reports[$i]->created);
             $row_data .= '</td>';
             $row_data .= '<td class="brown">';
             $date = $reports[$i]->modified ? friendlyDate2($reports[$i]->modified) : '0';
             $row_data .= $date;
             $row_data .= '</td>';

Exemplo n.º 8

Arquivo: preview_newsdirector_reports.php Projeto: sudogem/brcms

}
$rpt_title .= " articles as of {$month} {$year}. ";
$newsdirector_articles_reports = $_SESSION['report_newsdirector_articles'];
for ($i = 0; $i < count($newsdirector_articles_reports) - 1; $i++) {
    if ($newsdirector_articles_reports[$i]->articleID) {
        $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
        $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
        $row_data .= '<td>';
        $row_data .= $i + 1;
        $row_data .= '</td>';
        $row_data .= '<td class="blue">';
        $title = $newsdirector_articles_reports[$i]->title;
        $row_data .= '&nbsp;' . $title;
        $row_data .= '</td>';
        $row_data .= '<td class="viola">';
        $category_name = getCategory_name($newsdirector_articles_reports[$i]->articleID);
        $row_data .= $category_name;
        $row_data .= '</td>';
        $row_data .= '<td class="brown" >';
        $row_data .= getArticle_authors_info($newsdirector_articles_reports[$i]->articleID, 'fullname');
        $row_data .= '</td>';
        $row_data .= '<td class="cyan">';
        $row_data .= getUser_info($newsdirector_articles_reports[$i]->edited_by, 'fullname');
        $row_data .= '</td>';
        $row_data .= '<td class="black">';
        $row_data .= friendlyDate2($newsdirector_articles_reports[$i]->created);
        $row_data .= '</td>';
        $row_data .= '<td class="brown">';
        $date = $newsdirector_articles_reports[$i]->modified ? friendlyDate2($newsdirector_articles_reports[$i]->modified) : '0';
        $row_data .= $date;
        $row_data .= '</td>';

Exemplo n.º 9

Arquivo: preview_editor_reports.php Projeto: sudogem/brcms

$month = $_SESSION['month'];
$year = $_SESSION['year'];
$editor_articles_reports = $_SESSION['report_editor_articles'];
for ($i = 0; $i < count($editor_articles_reports); $i++) {
    if ($editor_articles_reports[$i]->articleID) {
        $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
        $row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
        $row_data .= '<td>';
        $row_data .= $i + 1;
        $row_data .= '</td>';
        $row_data .= '<td class="blue">';
        $title = getArticleTitle($editor_articles_reports[$i]->articleID);
        $row_data .= '&nbsp;' . $title;
        $row_data .= '</td>';
        $row_data .= '<td class="blue2">';
        $category_name = getCategory_name($editor_articles_reports[$i]->articleID);
        $row_data .= $category_name;
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= getArticle_authors_info($editor_articles_reports[$i]->articleID, 'fullname');
        $row_data .= '</td>';
        $row_data .= '<td ';
        switch ($editor_articles_reports[$i]->status) {
            case 'revise':
                $row_data .= 'class="blue">';
                break;
            case 'rejected':
                $row_data .= 'class="red">';
                break;
            case 'approved':
                $row_data .= 'class="green">';

Exemplo n.º 10

Arquivo: archive.php Projeto: sudogem/brcms

    if ($archive[$i]->articleID) {
        $i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
        $row_data .= '<tr class="tdhover" id="tdata" bgcolor = "' . $bgcolor . '" align = "left">';
        $row_data .= '<td>';
        $row_data .= $j++;
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= '&nbsp;' . niceDate($archive[$i]->dateline);
        $row_data .= '</td>';
        $row_data .= '<td>';
        $row_data .= '<a href="' . VIEW_ARTICLE_URL2 . $archive[$i]->articleID . '">';
        $row_data .= '&nbsp;' . $archive[$i]->title;
        $row_data .= '</a>';
        $row_data .= '</td>';
        $row_data .= '<td>';
        $category_name = getCategory_name($archive[$i]->articleID);
        $row_data .= $category_name;
        $row_data .= '</td>';
        $row_data .= '</tr>';
    }
}
/**
 * Populate all the years into an array..
 */
$sql = " select distinct(created_year) from articles ";
if (!($result = $db->query($sql))) {
    die('Error:' . $db->error());
}
$listofyear = array();
while ($row = $db->fetcharray()) {
    $listofyear[] = $row;