<form action="' . getStringFromServer('PHP_SELF') . '" method="post">
<input type="hidden" name="post_changes" value="y" />
<input type="hidden" name="change_status" value="y" />
<input type="hidden" name="group_forum_id" value="' . $f->getID() . '" />
<input type="hidden" name="group_id" value="' . $group_id . '" />
<strong>' . _('Allow Anonymous Posts?') . '</strong><br />
<input type="radio" name="allow_anonymous" value="1"' . ($f->AllowAnonymous() == 1 ? ' checked="checked"' : '') . ' /> ' . _('Yes') . '<br />
<input type="radio" name="allow_anonymous" value="0"' . ($f->AllowAnonymous() == 0 ? ' checked="checked"' : '') . '/> ' . _('No') . '<br />
<strong>' . _('Is Public?') . '</strong><br />
<input type="radio" name="is_public" value="1"' . ($f->isPublic() == 1 ? ' checked="checked"' : '') . ' /> ' . _('Yes') . '<br />
<input type="radio" name="is_public" value="0"' . ($f->isPublic() == 0 ? ' checked="checked"' : '') . ' /> ' . _('No') . '<br />
<input type="radio" name="is_public" value="9"' . ($f->isPublic() == 9 ? ' checked="checked"' : '') . ' />' . _('Deleted') . '<br />
<p>' . html_build_select_box_from_assoc(array("0" => _('No Moderation'), "1" => _('Moderated Level 1'), "2" => _('Moderated Level 2')), "moderation_level", $f->getModerationLevel()) . '
<br>' . _('Moderated Level 1') . ': ' . _('To moderate anonymous posts (if allowed in public forum) and posts from non-member users.') . '<br>' . _('Moderated Level 2') . ': ' . _('To moderate ALL posts.') . '<p>
<strong>' . _('Forum Name') . ':</strong><br />
<input type="text" name="forum_name" value="' . $f->getName() . '" size="20" maxlength="30" />
<p>
<strong>' . _('Email All Posts To:') . '</strong><br />
<input type="text" name="send_all_posts_to" value="' . $f->getSendAllPostsTo() . '" size="30" maxlength="50" />
<p>
<strong>' . _('Description') . ':</strong><br />
<input type="text" name="description" value="' . $f->getDescription() . '" size="40" maxlength="80" /><br />
<p>
<input type="submit" name="submit" value="' . _('Update') . '" />
</form><p>';
//echo '<a href="'.getStringFromServer('PHP_SELF').'?group_id='.$group_id.'&group_forum_id='.$group_forum_id.'&delete=1">'._('Delete Message').'</a><br />';
/**
* printSelection - prints the select box for the user to get the files to edit
*
* @param string the checked item (if any)
* @param string the path to the plugins conf dir
*/
function printSelection($checked, $pluginpath)
{
global $feedback, $gfcgfile;
$config_files = array();
// array that'll have the config files
if (strlen($pluginpath) >= 1) {
if ($pluginpath[strlen($pluginpath) - 1] != '/') {
$pluginpath .= '/';
}
}
// check if we can get local.inc
@($handle = fopen($gfcgfile, 'r+'));
if (!$handle) {
// Open readonly but tell you can't write
$handle = fopen($gfcgfile, 'r');
$feedback .= _('Could not open local.inc file for read/write. Check the permissions for apache') . '<br />';
}
if ($handle) {
$config_files['local.inc'] = $gfcgfile;
fclose($handle);
} else {
// say we couldn't open local.inc
$feedback .= _('Could not open local.inc file for read. Check the permissions for apache') . '<br />';
}
//get the directories from the plugins dir
/*if (chdir($pluginpath)) {
$handle = opendir('.');
$j = 0;
while ($filename = readdir($handle)) {
//Don't add special directories '..' or '.' to the list
if (($filename!='..') && ($filename!='.') && ($filename!="CVS") ) {
$handle2 = @opendir($filename); // open the etc dir of the plugin
if ($handle2){
while ($filename2 = readdir($handle2)) {
if (strstr($filename2,'.conf') || strstr($filename2,'.inc') || ($filename2=='config.php')) {
$config_files['(' . $filename . ') - ' . $filename2] = $pluginpath . $filename . '/' . $filename2;
}
}
fclose($handle2);
}
}
}
fclose($handle);
} else {
// say we couldn't get into etc plugins dir
$feedback .= _('Could not open plugins etc dir for reading. Check the permissions for apache<br>');
}*/
echo '<br /><div align="center">';
echo html_build_select_box_from_assoc($config_files, 'files', $checked, true);
echo ' <input type="submit" name="choose" value="' . _('Choose') . '"/>';
echo '</div><br />';
}
<td>' . $rbac_edit_section_names[$keys[$i]] . '</td>
<td>' . db_result($res, $q, 'name') . '</td>
<td>' . html_build_select_box_from_assoc($role->getRoleVals($keys[$i]), "data[" . $keys[$i] . "][" . db_result($res, $q, 'group_artifact_id') . "]", $role->getVal($keys[$i], db_result($res, $q, 'group_artifact_id')), false, false) . $txt . '</td></tr>';
}
}
//
// File release system - each package can be public/private
//
} elseif ($keys[$i] == 'frspackage') {
$res = db_query("SELECT package_id,name,is_public \n\t\t\tFROM frs_package WHERE group_id='{$group_id}'");
for ($q = 0; $q < db_numrows($res); $q++) {
echo '<tr ' . $HTML->boxGetAltRowStyle($j++) . '>
<td>' . $rbac_edit_section_names[$keys[$i]] . '</td>
<td>' . db_result($res, $q, 'name') . '</td>
<td>' . html_build_select_box_from_assoc($role->getRoleVals($keys[$i]), "data[" . $keys[$i] . "][" . db_result($res, $q, 'package_id') . "]", $role->getVal($keys[$i], db_result($res, $q, 'package_id')), false, false) . '</td></tr>';
}
//
// Handle all other settings for all roles
//
} else {
echo '<tr ' . $HTML->boxGetAltRowStyle($j++) . '>
<td><strong>' . $rbac_edit_section_names[$keys[$i]] . '</strong></td>
<td>-</td>
<td>' . html_build_select_box_from_assoc($role->getRoleVals($keys[$i]), "data[" . $keys[$i] . "][0]", $role->getVal($keys[$i], 0), false, false) . '</td>
</tr>';
}
}
echo $HTML->listTableBottom();
echo '<input type="submit" name="submit" value="' . _('Submit') . '">
</form>';
project_admin_footer(array());
/**
* ExecuteAction - Executes the action passed as parameter
*
* @param string action to execute.
*/
function ExecuteAction($action)
{
global $HTML;
if ($action == "change_status") {
//change a forum
$forum_name = getStringFromRequest('forum_name');
$description = getStringFromRequest('description');
$send_all_posts_to = getStringFromRequest('send_all_posts_to');
$allow_anonymous = getIntFromRequest('allow_anonymous');
$is_public = getIntFromRequest('is_public');
$moderation_level = getIntFromRequest('moderation_level');
$group_forum_id = getIntFromRequest('group_forum_id');
/*
Change a forum
*/
$f = new Forum($this->g, $group_forum_id);
if (!$f || !is_object($f)) {
exit_error(_('Error'), _('Error getting Forum'));
} elseif ($f->isError()) {
exit_error(_('Error'), $f->getErrorMessage());
}
if (!$f->userIsAdmin()) {
exit_permission_denied();
}
if (!$f->update($forum_name, $description, $allow_anonymous, $is_public, $send_all_posts_to, $moderation_level)) {
exit_error(_('Error'), $f->getErrorMessage());
} else {
$feedback = _('Forum Info Updated Successfully');
}
return $feedback;
}
if ($action == "add_forum") {
//add forum
$forum_name = getStringFromRequest('forum_name');
$description = getStringFromRequest('description');
$is_public = getStringFromRequest('is_public');
$send_all_posts_to = getStringFromRequest('send_all_posts_to');
$allow_anonymous = getStringFromRequest('allow_anonymous');
$moderation_level = getIntFromRequest('moderation_level');
/*
Adding forums to this group
*/
if (!$this->p->isForumAdmin()) {
form_release_key(getStringFromRequest("form_key"));
exit_permission_denied();
}
$f = new Forum($this->g);
if (!$f || !is_object($f)) {
form_release_key(getStringFromRequest("form_key"));
exit_error(_('Error'), _('Error getting Forum'));
} elseif ($f->isError()) {
form_release_key(getStringFromRequest("form_key"));
exit_error(_('Error'), $f->getErrorMessage());
}
if (!$f->create($forum_name, $description, $is_public, $send_all_posts_to, 1, $allow_anonymous, $moderation_level)) {
form_release_key(getStringFromRequest("form_key"));
exit_error(_('Error'), $f->getErrorMessage());
} else {
$feedback = _('Forum created successfully');
}
return $feedback;
}
if ($action == "delete") {
//Deleting messages or threads
$msg_id = getStringFromRequest('deletemsg');
$forum_id = getIntFromRequest('forum_id');
$f = new Forum($this->g, $forum_id);
if (!$f || !is_object($f)) {
exit_error(_('Error'), _('Error getting Forum'));
} elseif ($f->isError()) {
exit_error(_('Error'), $f->getErrorMessage());
}
if (!$f->userIsAdmin()) {
exit_permission_denied();
}
$fm = new ForumMessage($f, $msg_id);
if (!$fm || !is_object($fm)) {
exit_error(_('Error'), _('Error Getting ForumMessage'));
} elseif ($fm->isError()) {
exit_error(_('Error'), $fm->getErrorMessage());
}
$count = $fm->delete();
if (!$count || $fm->isError()) {
exit_error(_('Error'), $fm->getErrorMessage());
} else {
$feedback = sprintf(ngettext('%1$s message deleted', '%1$s messages deleted', $count), $count);
}
return $feedback;
}
if ($action == "delete_forum") {
//delete the forum
/*
Deleting entire forum
*/
$group_forum_id = getIntFromRequest('group_forum_id');
$f = new Forum($this->g, $group_forum_id);
if (!$f || !is_object($f)) {
exit_error(_('Error'), _('Error getting Forum'));
} elseif ($f->isError()) {
exit_error(_('Error'), $f->getErrorMessage());
}
if (!$f->userIsAdmin()) {
exit_permission_denied();
}
if (!$f->delete(getStringFromRequest('sure'), getStringFromRequest('really_sure'))) {
exit_error(_('Error'), $f->getErrorMessage());
} else {
$feedback = _('Successfully Deleted');
}
return $feedback;
}
if ($action == "view_pending") {
//show the pending messages, awaiting moderation
$group_id = $this->group_id;
$forum_id = getStringFromRequest("forum_id");
if ($this->isGroupAdmin()) {
$this->PrintAdminOptions();
}
$sql = "SELECT forum_name, group_forum_id FROM forum_group_list WHERE group_id='{$group_id}' and moderation_level > 0";
$res = db_query($sql);
if (!$res) {
echo db_error();
return;
}
global $sys_db_row_pointer;
$moderated_forums = array();
for ($i = 0; $i < db_numrows($res); $i++) {
$aux = db_fetch_array($res);
$moderated_forums[$aux[1]] = $aux[0];
}
if (count($moderated_forums) == 0) {
echo $HTML->feedback(_('No forums are moderated for this group'));
forum_footer(array());
exit;
}
if (!$forum_id) {
//get the first one
$keys = array_keys($moderated_forums);
$forum_id = $keys[0];
}
echo '
<script language="JavaScript" type="text/javascript">
function confirmDel() {
var agree=confirm("Proceed? Actions are permanent!");
if (agree) {
return true;
} else {
return false;
}
}
</script>
<p><form name="pending" action="pending.php" method="post">
<input type="hidden" name="action" value="update_pending" />
<input type="hidden" name="form_key" value="' . form_generate_key() . '">
<input type="hidden" name="group_id" value="' . getIntFromRequest("group_id") . '" />
<input type="hidden" name="forum_id" value="' . $forum_id . '" />
';
//$moderated_forums["A"] = "All Forums for this group"; // to show all
echo html_build_select_box_from_assoc($moderated_forums, forum_id, $forum_id);
echo ' <input name="Go" type="submit" value="Go"><p>';
$title = array();
$title[] = _('Forum Name');
$title[] = _('Message');
$title[] = "Action";
$sql = "SELECT msg_id,subject,pm.group_forum_id,gl.forum_name FROM forum_pending_messages pm, forum_group_list gl WHERE pm.group_forum_id='{$forum_id}' AND pm.group_forum_id=gl.group_forum_id AND gl.group_forum_id='{$forum_id}'";
$res = db_query($sql);
if (!$res) {
echo db_error();
return;
}
$options = array("1" => "No action", "2" => "Delete", "3" => "Release");
//array with the supported actions
//i�ll make a hidden variable, helps to determine when the user updates the info, which action corresponds to which msgID
for ($i = 0; $i < db_numrows($res); $i++) {
$ids .= db_result($res, $i, 'msg_id') . ",";
}
$i = 2;
echo $HTML->listTableTop($title);
while ($onemsg = db_fetch_array($res)) {
//$url = 'pendingmsgdetail.php?msg_id=' . $onemsg[msg_id];
//<a href=\"javascript:msgdetail('$url');\">$onemsg[subject]</a>
$url = "http://www.google.com";
echo "\n\t\t\t\t<tr" . $HTML->boxGetAltRowStyle($i++) . ">\n\t\t\t\t\t<td>{$onemsg['forum_name']}</td>\t\n\t\t\t\t\t<td><a href=\"#\" OnClick=\"window.open('pendingmsgdetail.php?msg_id={$onemsg['msg_id']}&forum_id={$onemsg['group_forum_id']}&group_id={$group_id}','PendingMessageDetail','width=800,height=600,status=no,resizable=yes');\">{$onemsg['subject']}</a></td>\n\t\t\t\t\t<td><div align=\"right\">" . html_build_select_box_from_assoc($options, "doaction[]", 1) . "</div></td>\n\t\t\t\t</tr>";
}
echo $HTML->listTableBottom();
echo '
<p>
<input type="hidden" name="msgids" value="' . $ids . '">
<div align="right"><input type="submit" onClick="return confirmDel();" name="update" value="' . _('Update') . '"></div>
</form>
';
}
if ($action == "update_pending") {
$group_id = getIntFromRequest("group_id");
$forum_id = getIntFromRequest("forum_id");
$msgids = getStringFromRequest("msgids");
//the message ids to update
$doaction = getArrayFromRequest("doaction");
//the actions for the messages
$msgids = split(",", $msgids);
array_pop($msgids);
//this last one is empty
/*if ($this->isGroupAdmin()) {
$this->PrintAdminOptions();
}*/
$results = array();
//messages
for ($i = 0; $i < count($msgids); $i++) {
switch ($doaction[$i]) {
case 1:
//no action
break;
case 2:
//delete
db_begin();
$sql = "DELETE FROM forum_pending_attachment WHERE msg_id='{$msgids[$i]}'";
if (!db_query($sql)) {
$feedback .= "DB Error ";
$feedback .= db_error() . "<br>";
db_rollback();
break;
}
$sql = "DELETE FROM forum_pending_messages WHERE msg_id='{$msgids[$i]}'";
if (!db_query($sql)) {
$feedback .= "DB Error ";
$feedback .= db_error() . "<br>";
db_rollback();
break;
}
db_commit();
$feedback .= _('Forum deleted');
break;
case 3:
//release
$sql = "SELECT * FROM forum_pending_messages WHERE msg_id='{$msgids[$i]}'";
$res1 = db_query($sql);
if (!$res1) {
$feedback .= "DB Error " . db_error() . "<br>";
break;
}
$sql = "SELECT * FROM forum_pending_attachment WHERE msg_id='{$msgids[$i]}'";
$res2 = db_query($sql);
if (!$res2) {
$feedback .= "DB Error " . db_error() . "<br>";
break;
}
$f = new Forum($this->g, $forum_id);
if (!$f || !is_object($f)) {
exit_error(_('Error'), _('Error getting new Forum'));
} elseif ($f->isError()) {
exit_error(_('Error'), $f->getErrorMessage());
}
$fm = new ForumMessage($f);
// pending = false
if (!$fm || !is_object($fm)) {
exit_error(_('Error'), "Error getting new ForumMessage");
} elseif ($fm->isError()) {
exit_error(_('Error'), "Error getting new ForumMessage: " . $fm->getErrorMessage());
}
$group_forum_id = db_result($res1, 0, "group_forum_id");
$subject = db_result($res1, 0, "subject");
$body = db_result($res1, 0, "body");
$post_date = db_result($res1, 0, "post_date");
$thread_id = db_result($res1, 0, "thread_id");
$is_followup_to = db_result($res1, 0, "is_followup_to");
$posted_by = db_result($res1, 0, "posted_by");
$has_followups = db_result($res1, 0, "has_followups");
$most_recent_date = db_result($res1, 0, "most_recent_date");
if ($fm->insertreleasedmsg($group_forum_id, $subject, $body, $post_date, $thread_id, $is_followup_to, $posted_by, $has_followups, time())) {
$feedback .= "( {$subject} ) " . _('Pending forum released') . "<br>";
if (db_numrows($res2) > 0) {
//if there�s an attachment
$am = new AttachManager();
//object that will handle and insert the attachment into the db
$am->SetForumMsg($fm);
$userid = db_result($res2, 0, "userid");
$dateline = db_result($res2, 0, "dateline");
$filename = db_result($res2, 0, "filename");
$filedata = db_result($res2, 0, "filedata");
$filesize = db_result($res2, 0, "filesize");
$visible = db_result($res2, 0, "visible");
$msg_id = db_result($res2, 0, "msg_id");
$filehash = db_result($res2, 0, "filehash");
$mimetype = db_result($res2, 0, "mimetype");
$am->AddToDBOnly($userid, $dateline, $filename, $filedata, $filesize, $visible, $filehash, $mimetype);
foreach ($am->Getmessages() as $item) {
$feedback .= "{$msg_id} - " . $item . "<br>";
}
}
$deleteok = true;
} else {
if ($fm->isError()) {
if ($fm->getErrorMessage() == _('Couldn\'t Update Master Thread parent with current time')) {
//the thread which the message was replying to doesn�t exist any more
$feedback .= "( " . $subject . " ) " . _('The thread which the message was posted to doesn\'t exist anymore, please delete the message.') . "<br>";
} else {
$feedback .= "{$msg_id} - " . $fm->getErrorMessage() . "<br>";
}
$deleteok = false;
}
}
if (isset($am) && is_object($am)) {
//if there was an attach, check if it was uploaded ok
if (!$am->isError()) {
$deleteok = true;
} else {
//undo the changes to the forum table
db_begin();
$sql = "DELETE FROM forum WHERE msg_id='{$fm->getID}()'";
if (!db_query($sql)) {
$feedback .= "DB Error ";
$feedback .= db_error() . "<br>";
db_rollback();
break;
}
db_commit();
$deleteok = false;
}
}
if ($deleteok) {
//delete the message and attach
db_begin();
$sql = "DELETE FROM forum_pending_attachment WHERE msg_id='{$msgids[$i]}'";
if (!db_query($sql)) {
$feedback .= "DB Error ";
$feedback .= db_error() . "<br>";
db_rollback();
break;
}
$sql = "DELETE FROM forum_pending_messages WHERE msg_id='{$msgids[$i]}'";
if (!db_query($sql)) {
$feedback .= "DB Error ";
$feedback .= db_error() . "<br>";
db_rollback();
break;
}
db_commit();
}
}
}
html_feedback_top($feedback);
$page = 0;
$this->ExecuteAction("view_pending");
}
}
