Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Edit administration/news.php so you can see and edit news only from one category

It's just like title says. There is administration/news.php and i want to make another administration/news2.php

and in this administration/news2.php i could see and edit news only from one specific category.

I don't know how to do this, but i think i need to create news2.php and copy all code from administration/news.php there. Then i need to add some kind of news_cat='Your Category ID Here' to administration/news2.php ?

i think this is very easy to someone, tell me if you know how to do it.
Please Do not Send me PM related to any Requests. Whatever you want, whatever you want to post to me, Just Reply on the Threads only. I may not be available for you anytime due to my problems. So it will be better if some other person can also help you if he knows. So, please post in the Forums Only.....!

Here, is the Code for your news2.php. Just give a Link for this in some Panel as :

CodeDownload  
<a href='".BASEDIR."administration/news2.php".$aidlink."'>Submit News 2</a>



Code for news2.php : // Set your News Category ID in variable $your_news_cat in the code :
CodeDownload  

<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: news.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";

// Set your News Category ID here
$your_news_cat = 18;

if (!checkrights("N") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect("../index.php"); }

require_once THEMES."templates/admin_header_mce.php";
include LOCALE.LOCALESET."admin/news.php";

if ($settings['tinymce_enabled']) {
   echo "<script language='javascript' type='text/javascript'>advanced();</script>n";
} else {
   require_once INCLUDES."html_buttons_include.php";
}

if (isset($_GET['error']) && isnum($_GET['error'])) {
   if ($_GET['error'] == 1) {
      $message = $locale['413'];
   } elseif ($_GET['error'] == 2) {
      $message = sprintf($locale['414'], parsebytesize($settings['news_photo_max_b']));
   } elseif ($_GET['error'] == 3) {
      $message = $locale['415'];
   } elseif ($_GET['error'] == 4) {
      $message = sprintf($locale['416'], $settings['news_photo_max_w'], $settings['news_photo_max_h']);
   }
   if ($message) {   echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>n"; }
}
if (isset($_GET['status'])) {
   if ($_GET['status'] == "sn") {
      $message = $locale['410'];
   } elseif ($_GET['status'] == "su") {
      $message = $locale['411'];
   } elseif ($_GET['status'] == "del") {
      $message = $locale['412'];
   }
   if ($message) {   echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>n"; }
}

if (isset($_POST['save'])) {
   $error = "";
   $news_subject = stripinput($_POST['news_subject']);
   $news_cat = isnum($_POST['news_cat']) ? $_POST['news_cat'] : "0";
   if (isset($_FILES['news_image']) && is_uploaded_file($_FILES['news_image']['tmp_name'])) {
      require_once INCLUDES."photo_functions_include.php";

      $image = $_FILES['news_image'];
      $image_name = stripfilename(str_replace(" ", "_", strtolower(substr($image['name'], 0, strrpos($image['name'], ".")))));
      $image_ext = strtolower(strrchr($image['name'],"."));

      if ($image_ext == ".gif") { $filetype = 1;
      } elseif ($image_ext == ".jpg") { $filetype = 2;
      } elseif ($image_ext == ".png") { $filetype = 3;
      } else { $filetype = false; }

      if (!preg_match("/^[-0-9A-Z_.[]]+$/i", $image_name)) {
         $error = 1;
      } elseif ($image['size'] > $settings['news_photo_max_b']){
         $error = 2;
      } elseif (!$filetype) {
         $error = 3;
      } else {
         $image_t1 = image_exists(IMAGES_N_T, $image_name."_t1".$image_ext);
         $image_t2 = image_exists(IMAGES_N_T, $image_name."_t2".$image_ext);
         $image_full = image_exists(IMAGES_N, $image_name.$image_ext);

         move_uploaded_file($_FILES['news_image']['tmp_name'], IMAGES_N.$image_full);
         if (function_exists("chmod")) { chmod(IMAGES_N.$image_full, 0644); }
         $imagefile = @getimagesize(IMAGES_N.$image_full);
         if ($imagefile[0] > $settings['news_photo_max_w'] || $imagefile[1] > $settings['news_photo_max_h']) {
            $error = 4;
            unlink(IMAGES_N.$image_full);
         } else {
            createthumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t1, $settings['news_photo_w'], $settings['news_photo_h']);
            if ($settings['news_thumb_ratio'] == 0) {
               createthumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t2, $settings['news_thumb_w'], $settings['news_thumb_h']);
            } else {
               createsquarethumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t2, $settings['news_thumb_w']);
            }
         }
      }
      if (!$error) {
         $news_image = $image_full;
         $news_image_t1 = $image_t1;
         $news_image_t2 = $image_t2;
      } else {
         $news_image = "";
         $news_image_t1 = "";
         $news_image_t2 = "";
      }
   } else {
      $news_image = (isset($_POST['news_image']) ? $_POST['news_image'] : "");
      $news_image_t1 = (isset($_POST['news_image_t1']) ? $_POST['news_image_t1'] : "");
      $news_image_t2 = (isset($_POST['news_image_t2']) ? $_POST['news_image_t2'] : "");
   }
   $body = addslash($_POST['body']);
   if ($_POST['body2']) {
      $body2 = addslash(preg_replace("(^<p>s</p>$)", "", $_POST['body2']));
   } else {
      $body2 = "";
   }
   $news_start_date = 0; $news_end_date = 0;
   if ($_POST['news_start']['mday']!="--" && $_POST['news_start']['mon']!="--" && $_POST['news_start']['year']!="----") {
      $news_start_date = mktime($_POST['news_start']['hours'],$_POST['news_start']['minutes'],0,$_POST['news_start']['mon'],$_POST['news_start']['mday'],$_POST['news_start']['year']);
   }
   if ($_POST['news_end']['mday']!="--" && $_POST['news_end']['mon']!="--" && $_POST['news_end']['year']!="----") {
      $news_end_date = mktime($_POST['news_end']['hours'],$_POST['news_end']['minutes'],0,$_POST['news_end']['mon'],$_POST['news_end']['mday'],$_POST['news_end']['year']);
   }
   $news_visibility = isnum($_POST['news_visibility']) ? $_POST['news_visibility'] : "0";
   $news_draft = isset($_POST['news_draft']) ? "1" : "0";
   $news_sticky = isset($_POST['news_sticky']) ? "1" : "0";
   if ($settings['tinymce_enabled'] != 1) { $news_breaks = isset($_POST['line_breaks']) ? "y" : "n"; } else { $news_breaks = "n"; }
   $news_comments = isset($_POST['news_comments']) ? "1" : "0";
   $news_ratings = isset($_POST['news_ratings']) ? "1" : "0";
   if (isset($_POST['news_id']) && isnum($_POST['news_id'])) {
      $result = dbquery("SELECT news_image, news_image_t1, news_image_t2 FROM ".DB_NEWS." WHERE news_id='".$_POST['news_id']."' LIMIT 1");
      if (dbrows($result)) {
         $data = dbarray($result);
         if ($news_sticky == "1") { $result = dbquery("UPDATE ".DB_NEWS." SET news_sticky='0' WHERE news_sticky='1'"); }
         if (isset($_POST['del_image'])) {
            if (!empty($data['news_image']) && file_exists(IMAGES_N.$data['news_image'])) { unlink(IMAGES_N.$data['news_image']); }
            if (!empty($data['news_image_t1']) && file_exists(IMAGES_N_T.$data['news_image_t1'])) { unlink(IMAGES_N_T.$data['news_image_t1']); }
            if (!empty($data['news_image_t2']) && file_exists(IMAGES_N_T.$data['news_image_t2'])) { unlink(IMAGES_N_T.$data['news_image_t2']); }
            $news_image = "";
            $news_image_t1 = "";
            $news_image_t2 = "";
         }
         $result = dbquery("UPDATE ".DB_NEWS." SET news_subject='$news_subject', news_cat='$news_cat', news_end='$news_end_date', news_image='$news_image', news_news='$body', news_extended='$body2', news_breaks='$news_breaks',".($news_start_date != 0 ? " news_datestamp='$news_start_date'," : "")." news_start='$news_start_date', news_image_t1='$news_image_t1', news_image_t2='$news_image_t2', news_visibility='$news_visibility', news_draft='$news_draft', news_sticky='$news_sticky', news_allow_comments='$news_comments', news_allow_ratings='$news_ratings' WHERE news_id='".$_POST['news_id']."'");
         redirect(FUSION_SELF.$aidlink."&status=su".($error ? "&error=$error" : ""));
      } else {
         redirect(FUSION_SELF.$aidlink);
      }
   } else {
      if ($news_sticky == "1") { $result = dbquery("UPDATE ".DB_NEWS." SET news_sticky='0' WHERE news_sticky='1'"); }
      $result = dbquery("INSERT INTO ".DB_NEWS." (news_subject, news_cat, news_news, news_extended, news_breaks, news_name, news_datestamp, news_start, news_end, news_image, news_image_t1, news_image_t2, news_visibility, news_draft, news_sticky, news_reads, news_allow_comments, news_allow_ratings) VALUES ('$news_subject', '$news_cat', '$body', '$body2', '$news_breaks', '".$userdata['user_id']."', '".($news_start_date != 0 ? $news_start_date : time())."', '$news_start_date', '$news_end_date', '$news_image', '$news_image_t1', '$news_image_t2', '$news_visibility', '$news_draft', '$news_sticky', '0', '$news_comments', '$news_ratings')");
      redirect(FUSION_SELF.$aidlink."&status=sn".($error ? "&error=$error" : ""));
   }
} else if (isset($_POST['delete']) && (isset($_POST['news_id']) && isnum($_POST['news_id']))) {
   $result = dbquery("SELECT news_image, news_image_t1, news_image_t2 FROM ".DB_NEWS." WHERE news_id='".$_POST['news_id']."' LIMIT 1");
   if (dbrows($result)) {
      $data = dbarray($result);
      if (!empty($data['news_image']) && file_exists(IMAGES_N.$data['news_image'])) { unlink(IMAGES_N.$data['news_image']); }
      if (!empty($data['news_image_t1']) && file_exists(IMAGES_N_T.$data['news_image_t1'])) { unlink(IMAGES_N_T.$data['news_image_t1']); }
      if (!empty($data['news_image_t2']) && file_exists(IMAGES_N_T.$data['news_image_t2'])) { unlink(IMAGES_N_T.$data['news_image_t2']); }
      $result = dbquery("DELETE FROM ".DB_NEWS." WHERE news_id='".$_POST['news_id']."'");
      $result = dbquery("DELETE FROM ".DB_COMMENTS." WHERE comment_item_id='".$_POST['news_id']."' and comment_type='N'");
      $result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_item_id='".$_POST['news_id']."' and rating_type='N'");
      redirect(FUSION_SELF.$aidlink."&status=del");
   } else {
      redirect(FUSION_SELF.$aidlink);
   }
} else {
   if (isset($_POST['preview'])) {
      $news_subject = stripinput($_POST['news_subject']);
      $news_cat = isnum($_POST['news_cat']) ? $_POST['news_cat'] : "0";
      $body = phpentities(stripslash($_POST['body']));
      $bodypreview = str_replace("src='".str_replace("../", "", IMAGES_N), "src='".IMAGES_N, stripslash($_POST['body']));
      if ($_POST['body2']) {
         $body2 = phpentities(stripslash($_POST['body2']));
         $body2preview = str_replace("src='".str_replace("../", "", IMAGES_N), "src='".IMAGES_N, stripslash($_POST['body2']));
      } else {
         $body2 = "";
      }
      if (isset($_POST['line_breaks'])) {
         $news_breaks = " checked='checked'";
         $bodypreview = nl2br($bodypreview);
         if ($body2) { $body2preview = nl2br($body2preview); }
      } else {
         $news_breaks = "";
      }
      $news_start = array(
         "mday" => isnum($_POST['news_start']['mday']) ? $_POST['news_start']['mday'] : "--",
         "mon" => isnum($_POST['news_start']['mon']) ? $_POST['news_start']['mon'] : "--",
         "year" => isnum($_POST['news_start']['year']) ? $_POST['news_start']['year'] : "----",
         "hours" => isnum($_POST['news_start']['hours']) ? $_POST['news_start']['hours'] : "0",
         "minutes" => isnum($_POST['news_start']['minutes']) ? $_POST['news_start']['minutes'] : "0",
      );
      $news_end = array(
         "mday" => isnum($_POST['news_end']['mday']) ? $_POST['news_end']['mday'] : "--",
         "mon" => isnum($_POST['news_end']['mon']) ? $_POST['news_end']['mon'] : "--",
         "year" => isnum($_POST['news_end']['year']) ? $_POST['news_end']['year'] : "----",
         "hours" => isnum($_POST['news_end']['hours']) ? $_POST['news_end']['hours'] : "0",
         "minutes" => isnum($_POST['news_end']['minutes']) ? $_POST['news_end']['minutes'] : "0",
      );
      $news_image = (isset($_POST['news_image']) ? $_POST['news_image'] : "");
      $news_image_t1 = (isset($_POST['news_image_t1']) ? $_POST['news_image_t1'] : "");
      $news_image_t2 = (isset($_POST['news_image_t2']) ? $_POST['news_image_t2'] : "");
      $news_visibility = isnum($_POST['news_visibility']) ? $_POST['news_visibility'] : "0";
      $news_draft = isset($_POST['news_draft']) ? " checked='checked'" : "";
      $news_sticky = isset($_POST['news_sticky']) ? " checked='checked'" : "";
      $news_comments = isset($_POST['news_comments']) ? " checked='checked'" : "";
      $news_ratings = isset($_POST['news_ratings']) ? " checked='checked'" : "";
      opentable($news_subject);
      echo "$bodypreviewn";
      closetable();
      if (isset($body2preview)) {
         opentable($news_subject);
         echo "$body2previewn";
         closetable();
      }
   }
   $result = dbquery("SELECT news_id, news_subject, news_draft FROM ".DB_NEWS." where news_cat='".$your_news_cat."' ORDER BY news_draft DESC, news_datestamp DESC");
   if (dbrows($result) != 0) {
      $editlist = ""; $sel = "";
      while ($data = dbarray($result)) {
         if ((isset($_POST['news_id']) && isnum($_POST['news_id'])) || (isset($_GET['news_id']) && isnum($_GET['news_id']))) {
            $news_id = isset($_POST['news_id']) ? $_POST['news_id'] : $_GET['news_id'];
            $sel = ($news_id == $data['news_id'] ? " selected='selected'" : "");
         }
         $editlist .= "<option value='".$data['news_id']."'$sel>".($data['news_draft'] ? $locale['438']." " : "").$data['news_subject']."</option>n";
      }
      opentable($locale['400']);
      echo "<div style='text-align:center'>n<form name='selectform' method='post' action='".FUSION_SELF.$aidlink."&action=edit'>n";
      echo "<select name='news_id' class='textbox' style='width:250px'>n".$editlist."</select>n";
      echo "<input type='submit' name='edit' value='".$locale['420']."' class='button' />n";
      echo "<input type='submit' name='delete' value='".$locale['421']."' onclick='return DeleteNews();' class='button' />n";
      echo "</form>n</div>n";
      closetable();
   }

   if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_POST['news_id']) && isnum($_POST['news_id'])) || (isset($_GET['news_id']) && isnum($_GET['news_id']))) {
      $result = dbquery("SELECT news_subject, news_cat, news_news, news_extended, news_start, news_end, news_image, news_image_t1, news_image_t2, news_visibility, news_draft, news_sticky, news_breaks, news_allow_comments, news_allow_ratings FROM ".DB_NEWS." WHERE news_id='".(isset($_POST['news_id']) ? $_POST['news_id'] : $_GET['news_id'])."' LIMIT 1");
      if (dbrows($result)) {
         $data = dbarray($result);
         $news_subject = $data['news_subject'];
         $news_cat = $data['news_cat'];
         $body = phpentities(stripslashes($data['news_news']));
         $body2 = phpentities(stripslashes($data['news_extended']));
         if ($data['news_start'] > 0) $news_start = getdate($data['news_start']);
         if ($data['news_end'] > 0) $news_end = getdate($data['news_end']);
         $news_image = $data['news_image'];
         $news_image_t1 = $data['news_image_t1'];
         $news_image_t2 = $data['news_image_t2'];
         $news_visibility = $data['news_visibility'];
         $news_draft = $data['news_draft'] == "1" ? " checked='checked'" : "";
         $news_sticky = $data['news_sticky'] == "1" ? " checked='checked'" : "";
         $news_breaks = $data['news_breaks'] == "y" ? " checked='checked'" : "";
         $news_comments = $data['news_allow_comments'] == "1" ? " checked='checked'" : "";
         $news_ratings = $data['news_allow_ratings'] == "1" ? " checked='checked'" : "";
      } else {
         redirect(FUSION_SELF.$aidlink);
      }
   }
   if ((isset($_POST['news_id']) && isnum($_POST['news_id'])) || (isset($_GET['news_id']) && isnum($_GET['news_id']))) {
      opentable($locale['402']);
   } else {
      if (!isset($_POST['preview'])) {
         $news_subject = "";
         $news_cat = "0";
         $body = "";
         $body2 = "";
         $news_image = "";
         $news_image_t1 = "";
         $news_image_t2 = "";
         $news_visibility = 0;
         $news_draft = "";
         $news_sticky = "";
         $news_breaks = " checked='checked'";
         $news_comments = " checked='checked'";
         $news_ratings = " checked='checked'";
      }
      opentable($locale['401']);
   }
   $result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." where news_cat_id='".$your_news_cat."' ORDER BY news_cat_name");
   $news_cat_opts = ""; $sel = "";
   if (dbrows($result)) {
      while ($data = dbarray($result)) {
         if (isset($news_cat)) $sel = ($news_cat == $data['news_cat_id'] ? " selected='selected'" : "");
         $news_cat_opts .= "<option value='".$data['news_cat_id']."'$sel>".$data['news_cat_name']."</option>n";
      }
   }
   $visibility_opts = ""; $sel = "";
   $user_groups = getusergroups();
   while(list($key, $user_group) = each($user_groups)){
      $sel = ($news_visibility == $user_group['0'] ? " selected='selected'" : "");
      $visibility_opts .= "<option value='".$user_group['0']."'$sel>".$user_group['1']."</option>n";
   }
   echo "<form name='inputform' method='post' action='".FUSION_SELF.$aidlink."' enctype='multipart/form-data' onsubmit='return ValidateForm(this);'>n";
   echo "<table cellpadding='0' cellspacing='0' class='center'>n<tr>n";
   echo "<td width='100' class='tbl'>".$locale['422']."</td>n";
   echo "<td width='80%' class='tbl'><input type='text' name='news_subject' value='".$news_subject."' class='textbox' style='width: 250px' /></td>n";
   echo "</tr>n<tr>n";
   echo "<td width='100' class='tbl'>".$locale['423']."</td>n";
   echo "<td width='80%' class='tbl'><select name='news_cat' class='textbox'>n";
   echo "<option value='0'>".$locale['424']."</option>n".$news_cat_opts."</select></td>n";
   echo "</tr>n<tr>n";
   echo "<td class='tbl' valign='top'>".$locale['439'].":</td>n<td class='tbl' valign='top'>";
   if ($news_image != "" && $news_image_t1 != "") {
      echo "<label><img src='".IMAGES_N_T.$news_image_t2."' alt='".$locale['439']."' />n";
      echo "<input type='checkbox' name='del_image' value='y' /> ".$locale['421']."</label>n";
      echo "<input type='hidden' name='news_image' value='".$news_image."' />n";
      echo "<input type='hidden' name='news_image_t1' value='".$news_image_t1."' />n";
      echo "<input type='hidden' name='news_image_t2' value='".$news_image_t2."' />n";
   } else {
      echo "<input type='file' name='news_image' class='textbox' style='width:250px;' />n";
      echo sprintf($locale['440'], parsebytesize($settings['news_photo_max_b']))."n";
   }
   echo "</td>n</tr>n<tr>n";
   echo "<td valign='top' width='100' class='tbl'>".$locale['425']."</td>n";
   echo "<td width='80%' class='tbl'><textarea name='body' cols='95' rows='10' class='textbox' style='width:98%'>".$body."

so you decided to post black backgrounded text about me posting pm request to you grin nice (remember main point was to thank you)

thank you it's working very well.
Ok mate ! No problem with that ! Welcome always. :) But you also remember, that it was only for telling you that I do not prefer contact via PM with members. You should have posted in the same thread. I was not showing me angry by this Highlight but only telling :P

Good Day... :)
Hmm, can someone do this for photogallery too? i think i need to create photoalbums2.php and photos2.php to administration folder. And of course i should make photogallery2.php to display these other albums.

And i wonder if you have to do this with sub categories? because if you dont then you can only show 1 album... Actually i dont know do you have to do this with sub categories... >_<
I think, Ankur admin maybe code again for news2.php, somebody admin post news, is that admin can edit news post of that admin out but super admin. My English not very well.
EX:
admin A: post news 1 -> admin A only edit news 1 and can't edit news 2
admin B: post news 2 -> admin B only edit news 2 and can't edit news 1

Super Admin: edit both
Thread Information
Author
Replies
6 posts
Views
3,697 times
Last Post
Last updated on 6 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: ntn, Ankur, Darra