$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 .= ' ' . $title; $row_data .= '</a>'; $row_data .= '</td>'; $row_data .= '<td class="blue2">'; $category_name = getCategory_name($my_articles[$i]->articleID); $row_data .= ' ' . $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">';
} $_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 .= ' ' . $article_versions[$i]->title; $row_data .= '</td>'; $row_data .= '<td class="viola">'; $category_name = getCategory_name($article_versions[$i]->articleID); $row_data .= ' ' . $category_name; $row_data .= '</td>'; $row_data .= '<td class="cyan">'; $author_name = getArticle_authors($article_versions[$i]->articleID); $row_data .= ' ' . $author_name; $row_data .= '</td>'; $row_data .= '<td class="blue2">'; $category_name = getFrontpage_type($article_versions[$i]->articleID); $row_data .= ' ' . $category_name; $row_data .= '</td>'; $row_data .= '<td class="green">'; $row_data .= ' ' . getstage_name($article_versions[$i]->stageID); $row_data .= '</td>'; $row_data .= '<td class="brown">'; $row_data .= ' ' . friendlyDate2($article_versions[$i]->created);
$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 .= ' ' . $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 .= ' ' . $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 .= ' ' . friendlydate2($publisher_articles_reports[$i]->created); $row_data .= '</td>';
$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..
$_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>';
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 . '">';
} 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>';
} $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 .= ' ' . $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>';
$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 .= ' ' . $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">';
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 .= ' ' . niceDate($archive[$i]->dateline); $row_data .= '</td>'; $row_data .= '<td>'; $row_data .= '<a href="' . VIEW_ARTICLE_URL2 . $archive[$i]->articleID . '">'; $row_data .= ' ' . $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;