function main()
{
global $db;
do_table_header("Obsedb CMS Mod Library");
print "<tr><td style=\"background: #fff;\">";
$phpVersion = phpversion();
if ($phpVersion >= 5) {
print '<h3 style="padding-left: 5px;"><span style="color: green;">Beta</span></h3>';
if (!isset($_REQUEST['platform'])) {
$xmlfile = simplexml_load_file('http://content.Obsedbcms.com/platforms.xml');
foreach ($xmlfile as $platform) {
print '<div style="font-size: 10pt; padding: 10px; width: 300px; background-color: #fff; border: 1px solid #f5f5f5;">';
print '<a href="content.php?platform=' . $platform->var . '">' . $platform->title . '</a>';
print '</div><br />';
}
} else {
$xmlfile = simplexml_load_file('http://content.Obsedbcms.com/' . $_REQUEST[platform]);
foreach ($xmlfile as $Mod) {
print '<div style="padding: 10px; width: 300px; background-color: #fff; border: 1px solid #f5f5f5;">';
print '<div style="font-size: 10pt;">' . $Mod->title . '</div>';
print '<a href="content.php?do=import_Mod&Mod=' . $Mod->url . '">Import Mod</a>';
print '</div><br />';
}
}
} else {
print '<h3 style="margin: 0px;"><span style="color: green;">Error</span></h3>';
print "You must have PHP version 5 or greater to access the content download system.";
}
print "</td></tr>";
do_table_footer();
}
function manage()
{
global $db;
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_Mods` WHERE `id` = '{$_REQUEST['id']}';");
do_table_header("Downloads: " . clean($Mod->fields['title']));
$result = $db->Execute("SELECT id,title,Modid FROM `Obsedb_downloads` WHERE `Modid` = '{$_REQUEST['id']}' ORDER BY `title`;");
while ($row = $result->FetchNextObject()) {
echo "<tr>\n\t\t\t\t\t<td style='font-size: 8pt;'>\n\t\t\t\t\t<a href=\"downloads.php?do=edit&id={$row->ID}\">[edit download]</a>\n\t\t\t\t\t<a href=\"downloads.php?do=delete&id={$row->ID}\">[delete]</a> \n\t\t\t\t\t" . clean($row->TITLE) . "\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
}
}
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 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 viewStatistics()
{
global $db;
$result = $db->Execute("SELECT id FROM Obsedb_cheats");
$totalCheats = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_companies");
$totalCompanies = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_downloads");
$totalDownloads = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_Mods");
$totalMods = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_news");
$totalNews = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_previews");
$totalPreviews = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_reviews");
$totalReviews = $result->RecordCount();
$result = $db->Execute("SELECT id FROM Obsedb_screenshots");
$totalScreenshots = $result->RecordCount();
do_table_header('Database Statistics');
echo '
<tr>
<td class="formlabel">';
echo '
<table border="0" cellspacing="0" cellpadding="5" width="100%">
<tr>
<td align="center"><strong>Total Cheats</strong><br />' . $totalCheats . '</td>
<td align="center"><strong>Total Companies</strong><br />' . $totalCompanies . '</td>
<td align="center"><strong>Total Downloads</strong><br />' . $totalDownloads . '</td>
</tr>
<tr>
<td align="center"><strong>Total Mods</strong><br />' . $totalMods . '</td>
<td align="center"><strong>Total Articles</strong><br />' . $totalNews . '</td>
<td align="center"><strong>Total Previews</strong><br />' . $totalPreviews . '</td>
</tr>
<tr>
<td align="center"><strong>Total Reviews</strong><br />' . $totalReviews . '</td>
<td align="center"><strong>Total Screenshots</strong><br />' . $totalScreenshots . '</td>
<td align="center"></td>
</tr>
</table>';
echo '
</td>
</tr>';
do_table_footer();
}
function manage()
{
global $db;
$result = $db->Execute("SELECT id,title\n\t\t\t\t\tFROM `Obsedb_Mods`\n\t\t\t\t\tWHERE `id` = '{$_REQUEST['id']}';");
do_table_header("Cheats: " . clean($result->fields['title']));
$result = $db->Execute("SELECT id,title,Modid\n\t\t\t\t\tFROM `Obsedb_cheats`\n\t\t\t\t\tWHERE `Modid` = '{$_REQUEST['id']}'\n\t\t\t\t\tORDER BY `title`;");
echo '<tr><td style="font-size: 8pt;" class="formlabel">';
if ($result->RecordCount() == 1) {
echo '<b>There is 1 cheat for this Mod.</b>';
} else {
echo '<b>There are ' . $result->RecordCount() . ' cheats for this Mod.</b>';
}
echo '</td></tr>';
while ($row = $result->FetchNextObject()) {
echo "<tr>\n\t\t\t\t\t<td style='font-size: 8pt;' class='formlabel'>\n\t\t\t\t\t<a href=\"cheats.php?do=edit&id={$row->ID}\">[edit cheat]</a>\n\t\t\t\t\t<a href=\"cheats.php?do=delete&id={$row->ID}\">[delete]</a> \n\t\t\t\t\t" . clean($row->TITLE) . "\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
}
do_table_footer();
}
function list_sections()
{
global $db;
do_module_header('Sections', 'Manage all the sections of your website');
do_table_header('Mod Sections');
do_blank_row('<a href="Mods.php?do=add_section">Add Section</a>');
$result = $db->Execute("SELECT id,title FROM `Obsedb_Mods_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
do_blank_row("<b>" . stripslashes($row->TITLE) . "</b>");
do_blank_row(" · <a href='Mods.php?do=Edit+Section&id={$row->ID}'>Change the section name</a>");
do_blank_row(" · <a href='Mods.php?do=Delete+Section&id={$row->ID}'>Delete the section</a>");
}
do_table_footer();
do_table_header('News Sections');
do_blank_row('<a href="news.php?do=add_section">Add Section</a>');
$result = $db->Execute("SELECT id,title FROM `Obsedb_news_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
do_blank_row("<b>" . stripslashes($row->TITLE) . "</b>");
do_blank_row(" · <a href='news.php?do=Edit+Section&id={$row->ID}'>Change the section name</a>");
do_blank_row(" · <a href='news.php?do=Delete+Section&id={$row->ID}'>Delete the section</a>");
}
do_table_footer();
do_table_header('Previews Sections');
do_blank_row('<a href="previews.php?do=add_section">Add Section</a>');
$result = $db->Execute("SELECT id,title FROM `Obsedb_previews_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
do_blank_row("<b>" . stripslashes($row->TITLE) . "</b>");
do_blank_row(" · <a href='previews.php?do=Edit+Section&id={$row->ID}'>Change the section name</a>");
do_blank_row(" · <a href='previews.php?do=Delete+Section&id={$row->ID}'>Delete the section</a>");
}
do_table_footer();
do_table_header('Reviews Sections');
do_blank_row('<a href="reviews.php?do=add_section">Add Section</a>');
$result = $db->Execute("SELECT id,title FROM `Obsedb_reviews_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
do_blank_row("<b>" . stripslashes($row->TITLE) . "</b>");
do_blank_row(" · <a href='reviews.php?do=Edit+Section&id={$row->ID}'>Change the section name</a>");
do_blank_row(" · <a href='reviews.php?do=Delete+Section&id={$row->ID}'>Delete the section</a>");
}
do_table_footer();
}
do_submit_row();
echo '<input type="hidden" name="do" value="edit_mailbag_confirm">';
echo '<input type="hidden" name="id" value="' . $mailbag->fields['id'] . '">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'edit_mailbag_confirm') {
$rs = $db->Execute("SELECT * FROM `Obsedb_mailbag` WHERE `id` = '{$_REQUEST['id']}'");
$record = array('title' => $_REQUEST['title'], 'message' => $_REQUEST['message'], 'reply' => $_REQUEST['reply']);
$sql = $db->GetUpdateSQL($rs, $record);
$db->Execute($sql);
SPMessage("Success | Changes have been saved.", "mailbag.php");
}
if ($_REQUEST['do'] == 'add_mailbag') {
do_form_header('mailbag.php');
do_table_header('Add Letter');
do_text_row('Title', 'title');
do_textarea_row('Message', 'message');
do_textarea_row('Reply', 'reply');
do_submit_row();
echo '<input type="hidden" name="do" value="add_mailbag_confirm">';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'add_mailbag_confirm') {
$record = array('title' => $_REQUEST['title'], 'message' => $_REQUEST['message'], 'reply' => $_REQUEST['reply']);
$db->AutoExecute('Obsedb_mailbag', $record, 'INSERT');
SPMessage("Success | Letter has been added.", "mailbag.php");
}
if ($_REQUEST['do'] == 'Delete Letter') {
$db->Execute("DELETE FROM `Obsedb_mailbag` WHERE `id` = '{$_REQUEST['id']}'");
<?php
include "global.php";
$cp->header();
define('Obsedb_LOADED', true);
do_module_header('Plugin Manager');
do_table_header('Installed Plugins');
foreach (glob("../sources/admin_plugins/*.plugin") as $filename) {
include "{$filename}";
?>
<tr>
<td class="formlabel">
<a href="loadplugin.php?load=<?php
echo $plugin_filename;
?>
"><b><?php
echo $plugin_title;
?>
</b></a>
</td>
</tr>
<?php
}
do_table_footer();
$cp->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');
}
if ($_REQUEST['do'] == 'manage_sections') {
do_form_header('links.php');
do_table_header('Sections');
$result = $db->Execute("SELECT id,title FROM `Obsedb_links_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
$bgcolor = $bgcolor == "#ECECFF" ? "#FFFFFF" : "#ECECFF";
echo '<tr><td bgcolor="' . $bgcolor . '" colspan="2"><input type="radio" value="' . $row->ID . '" name="id"> ' . stripslashes($row->TITLE) . '</td></tr>';
}
echo '<tr>
<td colspan="2">
<input type="submit" name="do" value="Edit Section">
<input type="submit" name="do" value="Delete Section">
</td>
</tr>';
do_table_footer();
echo '</form>';
}
if ($_REQUEST['do'] == 'Delete Section') {
if ($_REQUEST['do'] == 'Edit Poll Options') {
$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']}'");
function manageSections()
{
global $db;
do_form_header('reviews.php');
do_table_header('Sections');
$result = $db->Execute("SELECT id,title FROM `Obsedb_reviews_sections` ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
$bgcolor = $bgcolor == "#ECECFF" ? "#FFFFFF" : "#ECECFF";
echo '<tr><td bgcolor="' . $bgcolor . '" colspan="2"><input type="radio" value="' . $row->ID . '" name="id"> ' . stripslashes($row->TITLE) . '</td></tr>';
}
echo '<tr>
<td colspan="2">
<input type="submit" name="do" value="Edit Section">
<input type="submit" name="do" value="Delete Section">
</td>
</tr>';
do_table_footer();
echo '</form>';
}
<?php
do_table_header("Database Upgrade");
print "<tr><td bgcolor=\"#ffffff\">";
print "Upgrading your Obsedb database to version 1.4.2<br /><br />";
$db->Execute("ALTER TABLE `Obsedb_Mods` CHANGE `release` `release_date` TEXT;") or die($db->ErrorMsg());
print "Success! <b>DELETE THIS FILE</b>";
print "</td></tr>";
do_table_footer();
<?php
do_module_header('Sample Plugin Page', 'This is simply an example of how to code a plugin.');
do_table_header('Sample Plugin');
do_blank_row('This is a sample plugin.');
do_table_footer();
function main()
{
global $db;
$sections = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
do_table_header('View all companies by title');
echo "<tr><td class=\"formlabel\">";
foreach ($sections as $key => $value) {
echo "<b><a href=\"companies.php?s={$value}\">{$value}</a></b> ";
}
echo "</td></tr>";
do_table_footer();
do_form_header('companies.php');
do_table_header('All Companies');
if (isset($_REQUEST['s'])) {
$where = "WHERE Obsedb_companies.title LIKE '" . $_REQUEST[s] . "%'";
}
$result = $db->Execute("SELECT Obsedb_companies.id,Obsedb_companies.title,Obsedb_companies.homepage\n\t\t\t\t\t\tFROM Obsedb_companies\n\t\t\t\t\t\t{$where}\n\t\t\t\t\t\tORDER BY Obsedb_companies.title;");
echo '<tr>';
echo '<td bgcolor="#DDDDDD" style="border-bottom: 1px solid #808080; border-top: 1px solid #808080;"><b>Title</b></td>';
echo '<td bgcolor="#DDDDDD" style="border-bottom: 1px solid #808080; border-top: 1px solid #808080;"><b>Homepage</b></td>';
echo '</tr>';
while ($row = $result->FetchNextObject()) {
$bgcolor = $bgcolor == "#FFFFFF" ? "#F1EFE2" : "#FFFFFF";
echo '<tr><td bgcolor="' . $bgcolor . '">';
echo '<label for="id' . $row->ID . '">';
echo '<input type="radio" id="id' . $row->ID . '" name="id" VALUE="' . $row->ID . '">' . stripslashes($row->TITLE);
echo '</label>';
echo '</td>';
echo '<td bgcolor="' . $bgcolor . '">' . stripslashes($row->HOMEPAGE) . '</td>';
echo '</tr>';
}
echo '<tr><td colspan="2" bgcolor="#FFFFFF">';
echo '<input type="submit" name="do" value="Edit Company">';
echo '<input type="submit" name="do" value="Delete Company">';
echo '<input type="submit" name="do" value="View Matrix">';
echo '</tr></td>';
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.";
}
<?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();
function generate_matrix($type)
{
global $db;
// Related News
$result = $db->Execute("\n\t\tSELECT * FROM `Obsedb_matrix`\n\t\tWHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'news';");
do_table_header("Related News");
echo '<TR><TD CLASS="formlabel">';
while ($row = $result->FetchNextObject()) {
$article = $db->Execute("\n\t\t\tSELECT id,title\n\t\t\tFROM `Obsedb_news`\n\t\t\tWHERE `id` = '{$row->RELID}';");
echo '<a href="rcm_matrix.php?type=news&do=viewmatrix&id=' . $article->fields['id'] . '">';
echo stripslashes($article->fields['title']);
echo '</a>';
echo " ( <A HREF=\"rcm_matrix.php?do=delete_resource&did={$row->ID}&type={$type}&id={$_REQUEST['id']}\">Delete</A> )<BR />";
}
echo '<b><a href="rcm_matrix.php?do=create&type=' . $type . '&reltype=news&id=' . $_REQUEST['id'] . '">Create New Link</a></b>';
echo '</TD></TR>';
do_table_footer();
do_table_header("Related Mods");
echo '<TR><TD CLASS="formlabel">';
$result = $db->Execute("\n\t\tSELECT * FROM `Obsedb_matrix`\n\t\tWHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'Mods'\n\t");
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_Mods` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=Mods&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=Mods&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
do_table_header("Related Pages");
$result = $db->Execute("SELECT * FROM `Obsedb_matrix` WHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'pages'");
echo '<tr><td class="formlabel" colspan="2">';
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_pages` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=pages&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=pages&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
do_table_header('Related Reviews');
echo "<tr><td class=\"formlabel\" colspan=\"2\">";
$result = $db->Execute("SELECT * FROM `Obsedb_matrix` WHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'reviews'");
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_reviews` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=reviews&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=reviews&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
do_table_header('Related Previews');
$result = $db->Execute("SELECT * FROM `Obsedb_matrix` WHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'previews'");
echo '<tr><td class="formlabel" colspan="2">';
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_previews` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=previews&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=previews&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
do_table_header('Related Companies');
$result = $db->Execute("SELECT * FROM `Obsedb_matrix` WHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'companies'");
echo '<tr><td class="formlabel" colspan="2">';
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_companies` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=companies&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=companies&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
do_table_header('Related Screenshots');
$result = $db->Execute("SELECT * FROM `Obsedb_matrix` WHERE `ctype` = '{$type}' AND `cid` = '{$_REQUEST['id']}' AND `reltype` = 'screenshots'");
echo '<tr><td class="formlabel" colspan="2">';
while ($row = $result->FetchNextObject()) {
$Mod = $db->Execute("SELECT id,title FROM `Obsedb_screenshots` WHERE `id` = '{$row->RELID}'");
echo '<a href="rcm_matrix.php?type=screenshots&do=viewmatrix&id=', $Mod->fields['id'], '">', stripslashes($Mod->fields['title']), '</a>';
echo ' (<a href="rcm_matrix.php?do=delete_resource&did=' . $row->ID . '&type=' . $type . '&id=' . $_REQUEST[id] . '">Delete</a>)<br />';
}
echo '<b><a href="rcm_matrix.php?do=create&type=', $type, '&reltype=screenshots&id=', $_REQUEST[id], '">Create New Link</a></b>';
echo '</td></tr>';
do_table_footer();
}
function manage_users()
{
global $db;
do_form_header('administrators.php');
do_table_header($this->phrase['manage_users']);
$result = $db->Execute("SELECT * FROM `Obsedb_members` ORDER BY `PSEUDO`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td class=\"formlabel\"><input type=\"checkbox\" name=\"id\" value=\"{$row->ID}\"></td>" . "<td class=\"formlabel\" width=\"100%\"><b>{$row->PSEUDO}</b></td></tr>";
}
echo "<tr><td colspan=\"2\" class=\"formlabel\">" . "<input type=\"submit\" name=\"do\" value=\"" . $this->phrase['do_edit_user'] . "\"> " . "<input type=\"submit\" name=\"do\" value=\"" . $this->phrase['do_delete_user'] . "\"> " . "<input type=\"submit\" name=\"do\" value=\"" . $this->phrase['do_reset_password'] . "\"> " . "</td></tr>";
do_table_footer();
echo "</form>";
}
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();
}
}
function search2()
{
global $db;
do_table_header('Search results for "<i>' . stripslashes($_REQUEST['keywords']) . '</i>"');
switch ($_REQUEST['type']) {
case 'null':
die('Error: You must select a type of content to search.');
break;
case 'companies':
$result = $db->Execute("SELECT * FROM `Obsedb_companies` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=company&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'Mods':
$result = $db->Execute("SELECT * FROM `Obsedb_Mods` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=Mods&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'links':
$result = $db->Execute("SELECT * FROM `Obsedb_links` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=links&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'news':
$result = $db->Execute("SELECT * FROM `Obsedb_news` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=news&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'previews':
$result = $db->Execute("SELECT * FROM `Obsedb_previews` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=previews&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'reviews':
$result = $db->Execute("SELECT * FROM `Obsedb_reviews` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=reviews&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
case 'pages':
$result = $db->Execute("SELECT * FROM `Obsedb_pages` WHERE `title` LIKE '{$_REQUEST['keywords']}%' ORDER BY `title`");
while ($row = $result->FetchNextObject()) {
echo "<tr><td><a href=\"rcm_matrix.php?type=pages&do=viewmatrix&id={$row->ID}\">" . stripslashes($row->TITLE) . " (View Matrix)</a></td></tr>";
}
break;
}
do_table_footer();
}
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_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();
}
do_text_row('Filename', 'filename');
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.");
}
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>';
}
if ($_REQUEST['do'] == 'edit_page_confirm') {
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>
</tr>';
echo '<tr><td class="formlabel" align="right"><b>Open link in a new window</b></td>
<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 '
