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.
Not a member yet? Click here to register.
Forgot Password?

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

Asked Modified Viewed 4,842 times
D
Darra
D
Darra 10
  • Member, joined since
  • Contributed 54 posts on the community forums.
  • Started 18 threads in the forums
  • Started this discussions
asked
Member

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.
0 replies

5 posts

A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

[bcolor=#000000]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.....![/bcolor]

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

<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 :

<?php
/*-------------------------------------------------------+
| PHPFusion 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."
0 replies
D
Darra
D
Darra 10
  • Member, joined since
  • Contributed 54 posts on the community forums.
  • Started 18 threads in the forums
  • Started this discussions
answered
Member

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.
Edited by Darra on 30-04-2011 19:27,
0 replies
A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

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... :)
0 replies
— 2 months later —
D
Darra
D
Darra 10
  • Member, joined since
  • Contributed 54 posts on the community forums.
  • Started 18 threads in the forums
  • Started this discussions
answered
Member

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... >_<
0 replies
— 2 years later —
N
ntn
N
ntn 10
  • Junior Member, joined since
  • Contributed 19 posts on the community forums.
  • Started 8 threads in the forums
answered
Junior Member

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
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 5 posts
  • Votes 0 votes
  • Topic users 3 members

3 participants

N
N
ntn 10
  • Junior Member, joined since
  • Contributed 19 posts on the community forums.
  • Started 8 threads in the forums
A
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
D
D
Darra 10
  • Member, joined since
  • Contributed 54 posts on the community forums.
  • Started 18 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet