/*
Move msg to deleted status
*/
$sql = "UPDATE news_bytes SET is_approved='2' WHERE id=" . db_ei($id);
$result = db_query($sql);
if (!$result || db_affected_rows($result) < 1) {
$GLOBALS['Response']->addFeedback('error', $Language->getText('news_admin_index', 'update_err') . ' ' . db_error());
} else {
$GLOBALS['Response']->addFeedback('info', $Language->getText('news_admin_index', 'newsbyte_deleted'));
}
}
}
$GLOBALS['Response']->redirect('/news/admin');
}
}
news_header(array('title' => $Language->getText('news_admin_index', 'title')));
if ($request->get('approve')) {
/*
Show the submit form
*/
$sql = "SELECT groups.unix_group_name,news_bytes.* " . "FROM news_bytes,groups WHERE id=" . db_ei($id) . " " . "AND news_bytes.group_id=groups.group_id ";
$result = db_query($sql);
if (db_numrows($result) < 1) {
exit_error($Language->getText('global', 'error'), $Language->getText('news_admin_index', 'not_found_err'));
}
$username = user_getname(db_result($result, 0, 'submitted_by'));
$news_date = util_timestamp_to_userdateformat(db_result($result, 0, 'date'), true);
echo '
<H3>' . $Language->getText('news_admin_index', 'approve') . '</H3>
<P>
<FORM ACTION="" METHOD="POST">
if (!$result || db_affected_rows($result) < 1) {
$feedback .= ' ERROR doing update ';
$feedback .= db_error();
} else {
$feedback .= ' NewsByte Deleted. ';
}
}
}
/*
Show the list_queue
*/
$approve = '';
$list_queue = 'y';
}
}
news_header(array('title' => 'NewsBytes'));
if ($approve) {
/*
Show the submit form
*/
$sql = "SELECT groups.unix_group_name,news_bytes.* " . "FROM news_bytes,groups WHERE id='{$id}' " . "AND news_bytes.group_id=groups.group_id ";
$result = db_query($sql);
if (db_numrows($result) < 1) {
exit_error('Error', 'Error - not found');
}
echo '
<H3>Approve a NewsByte</H3>
<P>
<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="for_group" VALUE="' . db_result($result, 0, 'group_id') . '">
<INPUT TYPE="HIDDEN" NAME="id" VALUE="' . db_result($result, 0, 'id') . '">
} else {
$group_id = null;
}
if ($request->valid(new Valid_Pv())) {
$pv = $request->get('pv');
} else {
$pv = 0;
}
$pm = ProjectManager::instance();
if ($group_id) {
$title = $Language->getText('news_index', 'news_for', $pm->getProject($group_id)->getPublicName());
} else {
$title = $Language->getText('news_index', 'news');
}
$params = array('title' => $title, 'help' => 'communication.html#news-service', 'pv' => $pv);
news_header($params);
if ($pv != 2) {
if ($pv == 1) {
echo '<H3>' . $Language->getText('news_index', 'news') . '</H3>';
} else {
echo "<TABLE width='100%'><TR><TD>";
echo '<H3>' . $Language->getText('news_index', 'news') . '</H3>';
echo "</TD>";
echo "<TD align='left'> ( <A HREF='?group_id={$group_id}&pv=1'><img src='" . util_get_image_theme("msg.png") . "' border='0'> " . $Language->getText('global', 'printer_version') . "</A> ) </TD>";
echo "</TR></TABLE>";
}
echo '<P>' . $Language->getText('news_index', 'choose_news') . '<P>';
} else {
echo '<P>';
}
/*
/*
create a new discussion forum without a default msg
if one isn't already there
*/
//if news is declared as private, force the $promote_news to '0' value (not to be promoted)
$promote_news = $request->get('promote_news');
if ($promote_news == '3' && $request->get('private_news')) {
$promote_news = "0";
}
news_submit($group_id, $request->get('summary'), $request->get('details'), $request->get('private_news'), $promote_news);
}
}
/*
Show the submit form
*/
news_header(array('title' => $Language->getText('news_index', 'news'), 'help' => 'NewsService.html'));
$pm = ProjectManager::instance();
/*
create a new discussion forum without a default msg
if one isn't already there
*/
echo '
<H3>' . $Language->getText('news_submit', 'submit_news_for', $pm->getProject($group_id)->getPublicName()) . '</H3>
<P>
' . $Language->getText('news_submit', 'post_explain', $GLOBALS['sys_name']) . '
<P>
<FORM ACTION="" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
<B>' . $Language->getText('news_submit', 'for_project', $pm->getProject($group_id)->getPublicName()) . '</B>
<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="1">
<P>
/*
create a new discussion forum without a default msg
if one isn't already there
*/
//if news is declared as private, force the $promote_news to '0' value (not to be promoted)
$promote_news = $request->get('promote_news');
if ($promote_news == '3' && $request->get('private_news')) {
$promote_news = "0";
}
news_submit($group_id, $request->get('summary'), $request->get('details'), $request->get('private_news'), $request->get('send_news_to'), $promote_news);
}
}
/*
Show the submit form
*/
news_header(array('title' => $Language->getText('news_index', 'news'), 'help' => 'communication.html#news-service'));
$pm = ProjectManager::instance();
$project = $pm->getProject($group_id);
/*
create a new discussion forum without a default msg
if one isn't already there
*/
echo '
<H3>' . $Language->getText('news_submit', 'submit_news_for', $project->getPublicName()) . '</H3>
<P>
' . $Language->getText('news_submit', 'post_explain', $GLOBALS['sys_name']) . '
<P>
<FORM ACTION="" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
<B>' . $Language->getText('news_submit', 'for_project', $project->getPublicName()) . '</B>
<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="1">
/*
Move msg to rejected status
*/
$news_id = getArrayFromRequest('news_id');
$sql = "UPDATE news_bytes " . "SET is_approved='2' " . "WHERE id IN ('" . implode("','", $news_id) . "')";
$result = db_query($sql);
if (!$result || db_affected_rows($result) < 1) {
$feedback .= _('Error On Update:');
$feedback .= db_error();
} else {
$feedback .= _('NewsBytes Rejected.');
}
}
}
}
news_header(array('title' => _('News admin')));
if ($approve) {
/*
Show the submit form
*/
$sql = "SELECT groups.unix_group_name,groups.group_id,news_bytes.* " . "FROM news_bytes,groups WHERE id='{$id}' " . "AND news_bytes.group_id=groups.group_id ";
$result = db_query($sql);
if (db_numrows($result) < 1) {
exit_error(_('Error'), _('NewsByte not found'));
}
$group =& group_get_object(db_result($result, 0, 'group_id'));
$user =& user_get_object(db_result($result, 0, 'submitted_by'));
echo '
<h3>' . sprintf(_('Approve a NewsByte For Project: %1$s'), $group->getPublicName()) . '</h3>
<p />
<form action="' . getStringFromServer('PHP_SELF') . '" method="post">
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with GForge; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
require_once '../env.inc.php';
require_once $gfwww . 'include/pre.php';
require_once $gfwww . 'news/news_utils.php';
require_once $gfcommon . 'forum/Forum.class.php';
$group_id = getIntFromRequest('group_id');
$limit = getIntFromRequest('limit');
$offset = getIntFromRequest('offset');
news_header(array('title' => _('News')));
echo _('<p>Choose a News item and you can browse, search, and post messages.</p>');
/*
Put the result set (list of forums for this group) into a column with folders
*/
if (!$group_id || $group_id < 0 || !is_numeric($group_id)) {
$group_id = 0;
}
if ($group_id && $group_id != $sys_news_group) {
$sql = "SELECT * FROM news_bytes WHERE group_id='{$group_id}' AND is_approved <> '4' ORDER BY post_date DESC";
} else {
$sql = "SELECT * FROM news_bytes WHERE is_approved='1' ORDER BY post_date DESC";
}
if (!$offset || $offset < 0 || !is_numeric($offset)) {
$offset = 0;
}
private function displayHeader()
{
news_header(array('title' => $GLOBALS['Language']->getText('news_admin_index', 'title'), 'help' => 'communication.html#news-service', 'project_id' => $this->request->get('project_id')));
}
