function add_section()
{
do_form_header("screenshots.php");
do_table_header("Add Section");
do_text_row("Title", "title");
do_submit_row("Add Section");
echo '<input type="hidden" name="do" value="add_section_confirm">';
do_table_footer();
do_form_footer();
}
function add_poll()
{
global $db;
do_form_header('polls.php');
do_table_header('Add New Poll');
do_text_row('Title', 'title');
do_table_footer();
do_table_header('Poll Options');
do_text_row('Option 1', 'option1');
do_text_row('Option 2', 'option2');
do_text_row('Option 3', 'option3');
do_text_row('Option 4', 'option4');
do_text_row('Option 5', 'option5');
do_text_row('Option 6', 'option6');
do_text_row('Option 7', 'option7');
do_text_row('Option 8', 'option8');
do_text_row('Option 9', 'option9');
do_text_row('Option 10', 'option10');
do_submit_row('Add Poll');
do_table_footer();
echo '<input type="hidden" name="do" value="add_poll_confirm">';
do_form_footer();
echo "You may add more options later if you need more than ten.";
}
function edit_section()
{
global $db;
$result = $db->Execute("SELECT * FROM Obsedb_screenshots_sections WHERE id = {$_REQUEST['id']}");
if ($result) {
$row = $result->FetchRow();
do_form_header("screenshots.php");
do_table_header("Edit Section");
do_text_row("Title", "title", stripslashes($row[title]));
do_submit_row("Update");
echo '<input type="hidden" name="do" value="edit_section_confirm">';
echo '<input type="hidden" name="id" value="' . $row[id] . '">';
do_table_footer();
do_form_footer();
}
}
GenerateForm('links.php', 'Edit Link', 'edit_link_confirm', $fields, $hidden);
}
if ($_REQUEST['do'] == 'add_section') {
do_form_header('links.php');
do_table_header("Add Section");
do_text_row("Title", "title");
do_submit_row();
echo '<input type="hidden" name="do" value="add_section_confirm">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'Edit Section') {
$section = $db->Execute("SELECT * FROM `Obsedb_links_sections` WHERE `id` = '{$_REQUEST['id']}'");
do_form_header('links.php');
do_table_header("Edit Section");
do_text_row("Title", "title", clean($section->fields['title']));
do_submit_row();
echo '<input type="hidden" name="do" value="edit_section_confirm">';
echo '<input type="hidden" name="id" value="' . $section->fields['id'] . '">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'edit_section_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_links_sections` WHERE `id` = '{$_REQUEST['id']}'");
$record = array('title' => $_REQUEST['title']);
$sql = $db->GetUpdateSQL($rs, $record);
$db->Execute($sql);
SPMessage('Success: Section has been updated.', 'links.php?do=manage_sections');
}
if ($_REQUEST['do'] == 'add_section_confirm') {
$db->Execute("INSERT INTO `Obsedb_links_sections` (title) VALUES ('{$_REQUEST['title']}');");
}
if ($_REQUEST['do'] == 'edit_section_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_previews_sections` WHERE `id` = '{$_REQUEST['id']}'");
$record = array('title' => $_REQUEST['title']);
$sql = $db->GetUpdateSQL($rs, $record);
$db->Execute($sql);
echo '<center>Changes have been saved, <a href="previews.php">click here to continue</a>.</center>';
}
if ($_REQUEST['do'] == 'add_section_confirm') {
$db->Execute("INSERT INTO `Obsedb_previews_sections` (title) VALUES ('{$_REQUEST['title']}');");
echo '<center>Section has been successfully created, <a href="previews.php">click here to continue</a>.</center>';
}
if ($_REQUEST['do'] == 'add_news') {
do_form_header('previews.php');
do_table_header('Post New Preview');
do_text_row('Title', 'title');
do_sections_row();
do_textarea_row('Introduction', 'intro');
do_textarea_row('Full Text', 'text');
do_submit_row();
echo '<input type="hidden" name="do" value="add_news_confirm">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'add_news_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_previews` WHERE `id` = '-1'");
$record = array('title' => $_REQUEST['title'], 'section' => $_REQUEST['section'], 'intro' => $_REQUEST['intro'], 'text' => $_REQUEST['text']);
$sql = $db->GetInsertSQL($rs, $record);
$db->Execute($sql);
echo '<center>Preview has been successfully added, <a href="previews.php">click here to continue</a>.</center>';
}
do_form_header('pages.php');
do_table_header('Add Page');
do_text_row('Page Title', 'title');
do_table_footer();
do_table_header('Page Content');
do_textarea_row('', 'content');
do_submit_row("Continue");
do_table_footer();
echo '<input type="hidden" name="do" value="add_page_confirm">';
echo '</form>';
}
if ($_REQUEST['do'] == 'Edit Page') {
$menuitem = $db->Execute("SELECT * FROM `Obsedb_pages` WHERE `id` = '{$_REQUEST['id']}'");
do_form_header('pages.php');
do_table_header('Edit Page');
do_text_row('Page Title', 'title', clean($menuitem->fields['title']));
do_table_footer();
do_table_header('Page Content');
do_textarea_row('', 'content', stripslashes($menuitem->fields['content']));
do_submit_row('Continue');
do_table_footer();
echo '<input type="hidden" name="id" value="' . $menuitem->fields['id'] . '">';
echo '<input type="hidden" name="do" value="edit_page_confirm">';
echo '</form>';
}
if ($_REQUEST['do'] == 'add_page_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_pages` WHERE `id` = '-1'");
$record = array('title' => $_REQUEST['title'], 'content' => $_REQUEST['content']);
$sql = $db->GetInsertSQL($rs, $record);
$db->Execute($sql);
echo '<center>Page has been successfully added, <a href="pages.php">click here to continue</a>.</center>';
$result = $db->Execute("SELECT *\n\t\t\t\t\t\t\tFROM Obsedb_polls_options\n\t\t\t\t\t\t\tWHERE poll_id = {$_REQUEST['id']}\n\t\t\t\t\t\t\tORDER BY id DESC");
do_form_header('polls.php');
do_table_header('Poll Options');
while ($row = $result->FetchNextObject()) {
$bgcolor = $bgcolor == "#ECECFF" ? "#FFFFFF" : "#ECECFF";
echo "<TR>\n\t\t\t\t<TD BGCOLOR='{$bgcolor}' COLSPAN='2'>\n\t\t\t\t<INPUT TYPE='radio' name='id' value='{$row->ID}'>\n\t\t\t\t" . stripslashes($row->TEXT) . "</TD>\n\t\t\t </TR>";
}
echo "\n\t\t\t<TR>\n\t\t\t\t<TD COLSPAN='2' CLASS='formlabel'>\n\t\t\t\t<INPUT TYPE='submit' NAME='do' VALUE='Edit Option'>\n\t\t\t\t<INPUT TYPE='submit' NAME='do' VALUE='Delete Option'>\n\t\t\t\t</TD>\n\t\t\t</TR>";
do_table_footer();
do_form_footer();
}
if ($_REQUEST['do'] == 'Edit Option') {
$option = $db->Execute("SELECT * FROM Obsedb_polls_options WHERE id = '{$_REQUEST['id']}'") or die($db->ErrorMsg());
do_form_header('polls.php');
do_table_header('Editing Poll Option');
do_text_row('Text', 'text', stripslashes($option->fields['text']));
do_submit_row('Save Changes');
do_table_footer();
echo '<input type="hidden" name="id" value="' . $option->fields['id'] . '">';
echo '<input type="hidden" name="do" value="edit_option_confirm">';
do_form_footer();
}
if ($_REQUEST['do'] == 'edit_option_confirm') {
$result = array('text' => $_REQUEST['text']);
$db->AutoExecute('Obsedb_polls_options', $result, 'UPDATE', "id = '{$_REQUEST['id']}'");
SPMessage("Success | Changes have been saved.", "polls.php");
}
if ($_REQUEST['do'] == 'Delete Option') {
if (!empty($_REQUEST['id'])) {
$db->Execute("DELETE FROM Obsedb_polls_options WHERE id = '{$_REQUEST['id']}'");
SPMessage("Success | Option has been removed", "polls.php");
do_submit_row('Install');
do_table_footer();
echo '<input type="hidden" name="do" value="install2">';
do_form_footer();
}
if ($_REQUEST['do'] == 'install2') {
$record["title"] = $_REQUEST['title'];
$record["url"] = $_REQUEST['filename'];
$db->AutoExecute("Obsedb_modules", $record, 'INSERT');
SPMessage('Success | Module has been added to control panel', 'modules.php');
}
if ($do == 'edit') {
$result = $db->Execute("\n SELECT * FROM Obsedb_modules\n WHERE `id` = '{$id}'");
do_form_header('modules.php');
do_table_header('Module Configuration');
do_text_row('Name', 'title', stripslashes($result->fields['title']));
do_text_row('Target', 'url', stripslashes($result->fields['url']));
do_submit_row('Save Changes');
do_table_footer();
print '<input type="hidden" name="do" value="edit_confirm">';
print '<input type="hidden" name="id" value="' . $id . '">';
do_form_footer();
}
if ($do == 'edit_confirm') {
$title = $cp->getParam('title');
$url = $cp->getParam('url');
$record = array('title' => $title, 'url' => $url);
$db->AutoExecute('Obsedb_modules', $record, "UPDATE", "`id` = '{$id}'");
SPMessage("Module configuration has been saved.");
}
$cp->footer();
function search_content()
{
global $db;
do_form_header('rcm_matrix.php');
do_table_header('Search Content');
do_text_row('Keywords', 'keywords');
echo '<tr>
<td class="formlabel" align="right"><b>Content Type</b></td>
<td class="formlabel"><select name="type">' . '<option value="null"> - </option>' . '<option value="companies"> Companies</option>' . '<option value="Mods"> Mods</option>' . '<option value="news"> News</option>' . '<option value="pages"> Pages</option>' . '<option value="previews"> Previews</option>' . '<option value="reviews"> Reviews</option>' . '</select></td></tr>';
do_submit_row('Begin Search');
do_table_footer();
echo '<input type="hidden" name="do" value="search2">';
echo '</form>';
}
function reset_password()
{
global $db, $cp;
$id = $cp->getParam('id');
do_form_header('administrators.php');
do_table_header($this->phrase['change_password']);
do_text_row($this->phrase['new_password'], "password");
do_submit_row($this->phrase['save_changes']);
do_table_footer();
echo '<input type="hidden" name="do" value="reset_confirm">';
echo '<input type="hidden" name="id" value="' . $id . '">';
echo '</form>';
}
$sql = $db->GetUpdateSQL($rs, $record);
$db->Execute($sql);
SPMessage('Success | Changes have been saved.', 'news.php');
}
if ($_REQUEST['do'] == 'add_section_confirm') {
$db->Execute("INSERT INTO `Obsedb_news_sections` (title) VALUES ('{$_REQUEST['title']}');");
SPMessage('Success | Section has been successfully created.', 'news.php');
}
if ($_REQUEST['do'] == 'add_news') {
$sections = FetchSections('Obsedb_news_sections');
do_form_header('news.php');
do_table_header('Post New Article');
do_text_row('Title', 'title');
do_text_row('Author', 'author');
do_select_row('Section', 'section', $sections);
do_text_row('Creation Date', 'date', date($spconfig['date_format']));
listArticleImages();
do_textarea_row('Introduction', 'intro');
do_textarea_row('Full Text', 'text');
do_submit_row();
echo '<input type="hidden" name="do" value="add_news_confirm">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'add_news_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_news` WHERE `id` = '-1'");
$record = array('title' => $_REQUEST['title'], 'author' => $_REQUEST['author'], 'section' => $_REQUEST['section'], 'intro' => $_REQUEST['intro'], 'text' => $_REQUEST['text'], 'date' => $_REQUEST['date'], 'newsimage' => $_REQUEST['newsimage']);
$sql = $db->GetInsertSQL($rs, $record);
$db->Execute($sql);
SPMessage('Success | News has been successfully added.', 'news.php');
}
switch ($_REQUEST['do']) {
case 'save_profile':
$refresh = "profile.php";
break;
}
include "global.php";
$cp->header();
echo '<font style="font-size: 12pt; font-weight: bold;">Manage Your Profile</font>';
echo '<p>';
if (!isset($_REQUEST['do'])) {
$result = $db->Execute("SELECT * FROM `Obsedb_members` WHERE `ID` = '" . $_SESSION['pwzid'] . "'");
do_form_header('profile.php');
do_table_header('Personal Details');
do_text_row('Username', 'username', stripslashes($result->fields['PSEUDO']));
do_text_row('E-mail Address', 'email', stripslashes($result->fields['EMAIL']));
echo '<tr>
<td class="formlabel" align="right"><b>Current Password</b></td>
<td class="formlabel"><input type="password" name="curpass"></td>
</tr>';
echo '<tr>
<td class="formlabel" align="right"><b>New Password</b></td>
<td class="formlabel"><input type="password" name="newpass" size="60"></td>
</tr>';
echo '<tr>
<td class="formlabel" align="right"><b>Confirm New Password</b></td>
<td class="formlabel"><input type="password" name="newpass_confirm" size="60"></td>
</tr>';
do_submit_row('Update Profile');
do_table_footer();
echo '<input type="hidden" name="do" value="save_profile">';
function editSection()
{
global $db;
$section = $db->Execute("SELECT * FROM `Obsedb_reviews_sections` WHERE `id` = '{$_REQUEST['id']}'");
do_form_header('reviews.php');
do_table_header("Edit Section");
do_text_row("Title", "title", stripslashes($section->fields['title']));
do_submit_row();
echo '<input type="hidden" name="do" value="edit_section_confirm">';
echo '<input type="hidden" name="id" value="' . $section->fields['id'] . '">';
do_table_footer();
echo '</form>';
}
function edit_phrases($category, $label)
{
global $db, $cp;
$phrases = $cp->getPhrases($category);
do_form_header('configuration.php');
do_table_header($label);
foreach ($phrases as $key => $value) {
do_text_row($key, $key, $value);
}
do_submit_row('Save Phrases');
do_table_footer();
print "<input type=\"hidden\" name=\"category\" value=\"" . $category . "\">";
print "<input type=\"hidden\" name=\"do\" value=\"save_phrases\">";
do_form_footer();
}
function edit()
{
global $db;
$result = $db->Execute("SELECT * FROM Obsedb_customfields WHERE id = {$_REQUEST['id']};");
$field = $result->FetchRow();
do_form_header('customfields.php');
do_table_header('Edit Custom Field');
do_text_row('Field Name', 'title', stripslashes($field['title']));
echo '<tr>' . '<td class="formlabel" align="right"><b>Module</b></td>' . '<td class="formlabel">' . '<select name="module">';
if ($field['module'] == 'Mods') {
echo '<option value="Mods" selected>Mods Manager</option>';
} else {
echo '<option value="Mods">Mods Manager</option>';
}
echo '</select>' . '</td></tr>';
echo '<tr>' . '<td class="formlabel" align="right"><b>Field Type</b></td>' . '<td class="formlabel">' . '<select name="type">';
if ($field['type'] == 'text') {
echo '<option value="text" selected>Single-Line Text Box</option>';
} else {
echo '<option value="text">Single-Line Text Box</option>';
}
if ($field['type'] == 'textarea') {
echo '<option value="textarea" selected>WYSIWYG Editor</option>';
} else {
echo '<option value="textarea">WYSIWYG Editor</option>';
}
echo '</select>' . '</td></tr>';
do_submit_row('Update');
do_table_footer();
echo '<input type="hidden" name="do" value="edit_confirm">';
echo '<input type="hidden" name="id" value="' . $_REQUEST['id'] . '">';
do_form_footer();
}
function GenerateForm($target, $title, $do, $fieldarray, $hiddendata = '', $upload = 'false')
{
// ==============================
// Generate a form from an array
// ==============================
if ($upload == 'false') {
do_form_header($target);
} else {
print '<form method="post" action="' . $target . '" enctype="multipart/form-data">';
}
do_table_header($title);
foreach ($fieldarray as $key => $value) {
switch ($value["type"]) {
case 'text':
do_text_row($value["title"], $value["name"], $value["value"]);
break;
case 'submit':
do_submit_row($value["title"]);
break;
case 'textarea':
do_table_footer();
do_table_header($value["title"]);
do_textarea_row('', $value["name"], $value["value"]);
break;
case 'select':
do_select_row($value["title"], $value["name"], $value["value"], $value["selected"]);
break;
case 'spacer':
do_table_footer();
do_table_header($value["title"]);
break;
case 'file':
print "<tr><td class=\"formlabel\" align=\"right\"><b>" . $value["title"] . "</b></td>";
print "<td class=\"formlabel\"><input type=\"file\" name=\"" . $value["name"] . "\"></td></tr>";
break;
case 'blank':
do_blank_row($value["title"]);
break;
}
}
do_table_footer();
echo '<input type="hidden" name="do" value="' . $do . '">';
if (!empty($hiddendata)) {
foreach ($hiddendata as $key => $value) {
echo "<input type=\"hidden\" name=\"{$key}\" value=\"{$value}\">";
}
}
}
function edit_section()
{
global $db, $LANG;
$section = $db->Execute("SELECT * FROM `Obsedb_Mods_sections` WHERE `id` = '{$_REQUEST['id']}'");
echo '<form method="post" action="Mods.php">';
do_table_header($LANG['edit_section']);
do_text_row($LANG['title'], "title", clean($section->fields['title']));
do_submit_row($LANG['update']);
echo '<input type="hidden" name="do" value="edit_section_confirm">';
echo '<input type="hidden" name="id" value="' . $section->fields['id'] . '">';
do_table_footer();
echo '</form>';
}
function editAnnouncementForm()
{
global $db;
$result = $db->Execute("SELECT * FROM `Obsedb_announcements` WHERE `id` = '{$_REQUEST['id']}'");
do_form_header('index2.php');
do_table_header('Edit Announcement');
do_text_row($this->phrase['username'], 'user', $result->fields['user']);
do_text_row($this->phrase['title'], 'title', stripslashes($result->fields['title']));
do_textarea_row($this->phrase['message'], 'text', stripslashes($result->fields['text']));
do_submit_row('Save Changes');
do_table_footer();
echo '<input type="hidden" name="do" value="edit_confirm">';
echo '<input type="hidden" name="id" value="' . $_REQUEST[id] . '">';
echo '</form>';
}
<td class="formlabel">
<input type="checkbox" name="target" value="_blank">
</td></tr>';
do_submit_row('Continue');
do_table_footer();
echo '<input type="hidden" name="do" value="add_link_confirm">';
echo '</form>';
}
}
if ($_REQUEST['do'] == 'Edit Link') {
$menuitem = $db->Execute("SELECT * FROM `Obsedb_menu_items` WHERE `id` = '{$_REQUEST['id']}'");
do_form_header('menu_manager.php');
do_table_header('Edit Menu Item');
do_text_row('Link Title', 'title', stripslashes($menuitem->fields['title']));
do_text_row('URL', 'url', stripslashes($menuitem->fields['url']));
do_text_row('Order', 'ordering', stripslashes($menuitem->fields['ordering']));
echo '<tr><td class="formlabel"><b>Location</b></td>
<td class="formlabel">
<select name="location">';
$locations = array('left' => 'Left Menu', 'right' => 'Right Menu', 'top' => 'Top Menu', 'bottom' => 'Bottom Menu');
foreach ($locations as $key => $value) {
if ($menuitem->fields['location'] == $key) {
echo "<option value=\"{$key}\" selected>{$value}</option>";
} else {
echo "<option value=\"{$key}\">{$value}</option>";
}
}
echo '
</select>
</td>
</tr>';
