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 sql_query()
{
do_form_header("dbtools.php");
do_table_header("SQL Query Tool");
echo '<tr><td class="formlabel"><textarea name="query" rows="5" cols="50"></textarea><br />';
echo 'Please do not enter more than one query at a time.</td></tr>';
do_submit_row("Go");
do_table_footer();
echo '<input type="hidden" name="do" value="run_query">';
do_form_footer();
}
function edit_template($title)
{
global $db;
do_table_header("Manage Templates");
$result = $db->Execute("SELECT * FROM Obsedb_templates WHERE `title` = '{$title}';");
do_form_header('templates.php');
do_blank_row("Editing Template");
print "<tr><td class=\"formlabel\">\n" . "<textarea rows=\"20\" cols=\"70\" name=\"html\">" . stripslashes($result->fields['html']) . "</textarea></td></tr>";
do_submit_row("Save Template");
print '<input type="hidden" name="title" value="' . $title . '">';
print '<input type="hidden" name="do" value="save">';
do_table_footer();
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_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 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();
}
}
}
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']}');");
SPMessage('Success: Section has been created.', 'links.php?do=manage_sections');
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_settings()
{
global $db, $LANG, $spconfig;
do_form_header('Mods.php');
do_table_header($LANG['Mods_config']);
$options = array('0' => $LANG['disabled'], '1' => $LANG['enabled']);
do_select_row($LANG['show_tools'], 'Mod_tools', $options, $spconfig['Mod_tools']);
do_select_row($LANG['popup_tools'], 'Mod_tools_popups', $options, $spconfig['Mod_tools_popups']);
do_submit_row($LANG['save_settings']);
do_table_footer();
echo '<input type="hidden" name="do" value="save_settings">';
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 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>';
}
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">';
echo '</form>';
}
if ($_REQUEST['do'] == 'save_profile') {
$rs = $db->Execute("SELECT * FROM `Obsedb_members` WHERE `ID` = '" . $_SESSION['pwzid'] . "'");
$record = array('PSEUDO' => $_REQUEST['username'], 'EMAIL' => $_REQUEST['email']);
if (isset($_REQUEST['curpass'])) {
if (md5($_REQUEST['curpass']) == $rs->fields['PASS']) {
$sql = $db->GetUpdateSQL($rs, $record);
$db->Execute($sql);
if (!empty($_REQUEST['newpass']) && $_REQUEST['newpass'] == $_REQUEST['newpass_confirm']) {
$db->Execute("UPDATE `Obsedb_members` SET `PASS` = '" . md5($_REQUEST[newpass]) . "' WHERE `id` = '" . $_SESSION['pwzid'] . "'");
}
} else {
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 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>';
}
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>';
}
if ($_REQUEST['do'] == 'edit_page_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_pages` WHERE `id` = '{$_REQUEST['id']}'");
$record = array('title' => $_REQUEST['title'], 'content' => $_REQUEST['content']);
