<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"); } }