function main() { global $db; do_table_header('Downloads'); echo "<tr><td class=\"formlabel\"><b>"; $alpha = 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'); foreach ($alpha as $value) { echo "<a href=\"downloads.php?browse={$value}\">{$value}</a> "; } echo "</b></td></tr>"; if (empty($_REQUEST['browse'])) { $browse = 'A'; } else { $browse = $_REQUEST['browse']; } $sections = FetchSections('Obsedb_Mods_sections'); $Mods = $db->Execute("SELECT id,title,section\n\t\t\t\t\t\t\t\tFROM `Obsedb_Mods`\n\t\t\t\t\t\t\t\tWHERE `title` LIKE '" . $browse . "%'\n\t\t\t\t\t\t\t\tORDER BY `title`;"); while ($row = $Mods->FetchNextObject()) { echo '<tr><td style="font-size: 8pt;" class="formlabel">'; echo '<a href="downloads.php?do=add&id=' . $row->ID . '">[add download]</a> '; echo '<a href="downloads.php?do=manage&id=' . $row->ID . '">[manage downloads]</a> '; echo ' <b>' . clean($row->TITLE) . '</b> (' . $sections["{$row->SECTION}"] . ')'; echo '</td></tr>'; } do_table_footer(); }
function editReview() { global $db; $sections = FetchSections('Obsedb_reviews_sections'); $review = $db->Execute("SELECT * FROM `Obsedb_reviews` WHERE `id` = '{$_REQUEST['id']}';"); do_form_header('reviews.php'); do_table_header('Post New Review'); do_text_row('Title', 'title', clean($review->fields['title'])); do_select_row('Section', 'section', $sections, $review->fields['section']); $this->do_Mod_select_row($review->fields['Modid']); do_text_row("Modplay", "Modplay", clean($review->fields['Modplay'])); do_text_row("Graphics", "graphics", clean($review->fields['graphics'])); do_text_row("Sound", "sound", clean($review->fields['sound'])); do_text_row("Value", "value", clean($review->fields['value'])); do_text_row("Tilt", "tilt", clean($review->fields['tilt'])); do_textarea_row('Introduction', 'intro', stripslashes($review->fields['intro'])); do_textarea_row('Full Text', 'text', stripslashes($review->fields['text'])); do_submit_row(); echo '<input type="hidden" name="do" value="edit_review_confirm">'; echo '<input type="hidden" name="id" value="' . $review->fields['id'] . '">'; do_table_footer(); echo '</form>'; }
$db->Execute($sql); echo '<a href="screenshots.php">Click Here to Continue</a>'; } if ($_REQUEST['do'] == 'Delete Screenshot') { $result = $db->Execute("\n SELECT * FROM Obsedb_screenshots \n WHERE `id` = '{$_REQUEST['id']}'"); $path = $PATH_TRANSLATED; $path = str_replace("/user/screenshots.php", "/", $path); unlink($path . $result->fields['thumb']); unlink($path . $result->fields['screen']); $db->Execute("DELETE FROM `Obsedb_screenshots` WHERE `id` = '{$_REQUEST['id']}'"); SPMessage("Screenshot has been removed."); } if ($_REQUEST['do'] == 'manage_sections') { do_form_header('screenshots.php'); do_table_header('Sections'); $sections = FetchSections('Obsedb_screenshots_sections'); foreach ($sections as $key => $value) { $BGCOLOR = $BGCOLOR == "#ECECFF" ? "#FFFFFF" : "#ECECFF"; echo "<tr>\n <td bgcolor=\"{$BGCOLOR}\" colspan=\"2\">\n <input type=\"radio\" value=\"{$key}\" name=\"id\">" . stripslashes($value) . "\n </td>\n </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') { $db->Execute("DELETE FROM `Obsedb_screenshots_sections` WHERE `id` = '{$_REQUEST['id']}'");
switch ($_REQUEST['do']) { case 'search_Mods': $location .= " > <a href=\"search.php\">Advanced Search</a> > <b>Search Results</b>"; break; default: $location .= " > <b>Advanced Search</b>"; break; } require_once "global.php"; do_header(); if (!isset($_REQUEST['do'])) { include "templates/search_main.inc.php"; } if ($_REQUEST['do'] == 'search_Mods') { // Cache section names $sections = FetchSections('Obsedb_Mods_sections'); // Cache companies $companies = FetchCompanies(); // Field validation if (empty($_REQUEST['keywords'])) { echo "Error: No keywords entered.<br />"; } else { if ($_REQUEST['platform'] != 'all') { $platform = "`section` = '" . $_REQUEST['platform'] . "' "; } else { $platform = "`section` LIKE '%' "; } if ($_REQUEST['exact'] == '1') { $title = "`title` = '" . $_REQUEST['keywords'] . "' "; } else { $title = "`title` LIKE '%" . $_REQUEST['keywords'] . "%' ";
$rs = $db->Execute("SELECT * FROM `Obsedb_links` WHERE `id` = '-1'"); $record = array('title' => $_REQUEST['title'], 'url' => $_REQUEST['url'], 'section' => $_REQUEST['section']); $sql = $db->GetInsertSQL($rs, $record); $db->Execute($sql); echo '<center>Link has been successfully added, <a href="links.php">click here to continue</a>.</center>'; } if ($_REQUEST['do'] == 'edit_link_confirm') { $rs = $db->Execute("SELECT * FROM `Obsedb_links` WHERE `id` = '{$_REQUEST['id']}'"); $record = array('title' => $_REQUEST['title'], 'url' => $_REQUEST['url'], 'section' => $_REQUEST['section']); $sql = $db->GetUpdateSQL($rs, $record); $db->Execute($sql); SPMessage('Success: Link has been updated.', 'links.php'); } if ($_REQUEST['do'] == 'Edit Link') { $link = $db->Execute("SELECT * FROM `Obsedb_links` WHERE `id` = '" . $_REQUEST['id'] . "'"); $sections = FetchSections('Obsedb_links_sections'); $fields = array('title' => array('type' => 'text', 'title' => 'Title', 'name' => 'title', 'value' => clean($link->fields['title'])), 'url' => array('type' => 'text', 'title' => 'URL', 'name' => 'url', 'value' => clean($link->fields['url'])), 'section' => array('type' => 'select', 'title' => 'Section', name => 'section', 'value' => $sections, 'selected' => $link->fields['section']), 'submit' => array('type' => 'submit', 'title' => 'Save Link')); $hidden = array('id' => $_REQUEST['id']); 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']}'");
<table border="0" cellspacing="0" cellpadding="5" width="100%"> <tr> <td width="100%"><b>Latest Reviews</b></td> </tr> <?php global $spconfig; $limit = $spconfig['frontpage_reviews_limit']; $bgcolor = ''; $ReviewSections = FetchSections('Obsedb_reviews_sections'); $ReviewQuery = $db->Execute("SELECT id,title,section FROM `Obsedb_reviews` ORDER BY `id` DESC LIMIT 0,{$limit}"); while ($ReviewRow = $ReviewQuery->FetchNextObject()) { $bgcolor = $bgcolor == "#FFFFFF" ? "#E9E9E9" : "#FFFFFF"; ?> <tr> <td bgcolor="<?php echo $bgcolor; ?> " colspan="3" style="padding: 3px;"> <font style="font-size: 11px;"> <?php echo $ReviewSections["{$ReviewRow->SECTION}"]; ?> : <a href="reviews.php?do=view&id=<?php echo $ReviewRow->ID; ?> "><?php echo stripslashes($ReviewRow->TITLE); ?>
function edit_Mod() { global $db, $LANG; $Mod = $db->Execute("SELECT * FROM `Obsedb_Mods` WHERE `id` = '{$_REQUEST['id']}';"); $row = $Mod->FetchNextObject(); $sections = FetchSections('Obsedb_Mods_sections'); $companies = FetchSections('Obsedb_companies'); $esrb = array('N/A' => 'N/A', 'RP - Rating Pending' => 'RP - Rating Pending', 'EC - Early Childhood' => 'EC - Early Childhood', 'E - Everyone' => 'E - Everyone', 'E10+ - Everyone 10+' => 'E10+ - Everyone 10+', 'T - Teen' => 'T - Teen', 'M - Mature' => 'M - Mature', 'AO - Adults Only' => 'AO - Adults Only'); $coop = array('Unknown' => 'Unknown', 'No' => 'No', 'Yes' => 'Yes'); $form = array('1' => array('type' => 'text', 'title' => $LANG['title'], 'name' => 'title', 'value' => stripslashes($row->TITLE)), '2' => array('type' => 'select', 'title' => $LANG['section'], 'name' => 'section', 'value' => $sections, 'selected' => $row->SECTION), '3' => array('type' => 'select', 'title' => $LANG['developer'], 'name' => 'developer', 'value' => $companies, 'selected' => $row->DEVELOPER), '4' => array('type' => 'select', 'title' => $LANG['publisher'], 'name' => 'publisher', 'value' => $companies, 'selected' => $row->PUBLISHER), '5' => array('type' => 'select', 'title' => $LANG['esrb_rating'], 'name' => 'esrb', 'value' => $esrb, 'selected' => $row->ESRB), '6' => array('type' => 'text', 'title' => $LANG['genre'], 'name' => 'genre', 'value' => stripslashes($row->GENRE)), '7' => array('type' => 'text', 'title' => $LANG['release_date'], 'name' => 'release_date', 'value' => stripslashes($row->RELEASE_DATE)), '8' => array('type' => 'text', 'title' => $LANG['multiplayer'], 'name' => 'multiplayer', 'value' => stripslashes($row->MULTIPLAYER)), '9' => array('type' => 'text', 'title' => $LANG['boxshot'], 'name' => 'boxshot', 'value' => stripslashes($row->BOXSHOT)), '10' => array('type' => 'select', 'title' => $LANG['coop'], 'name' => 'coop', 'value' => $coop, 'selected' => $row->COOP), '11' => array('type' => 'textarea', 'title' => $LANG['description'], 'name' => 'description', 'value' => $row->DESCRIPTION), '12' => array('type' => 'spacer', 'title' => $LANG['minimum']), '13' => array('type' => 'text', 'title' => $LANG['system'], 'name' => 'req_system', 'value' => stripslashes($row->REQ_SYSTEM)), '14' => array('type' => 'text', 'title' => $LANG['ram'], 'name' => 'req_ram', 'value' => stripslashes($row->REQ_RAM)), '15' => array('type' => 'text', 'title' => $LANG['video_memory'], 'name' => 'req_video', 'value' => stripslashes($row->REQ_VIDEO)), '16' => array('type' => 'text', 'title' => $LANG['harddrive'], 'name' => 'req_space', 'value' => stripslashes($row->REQ_SPACE)), '17' => array('type' => 'text', 'title' => $LANG['mouse'], 'name' => 'req_mouse', 'value' => stripslashes($row->REQ_MOUSE)), '18' => array('type' => 'text', 'title' => $LANG['directx'], 'name' => 'req_directx', 'value' => stripslashes($row->REQ_DIRECTX)), '19' => array('type' => 'text', 'title' => $LANG['sound'], 'name' => 'req_sound', 'value' => stripslashes($row->REQ_SOUND)), '20' => array('type' => 'spacer', 'title' => 'Upload Box Art'), '23' => array('type' => 'blank', 'title' => 'This will overwrite your current boxart.'), '21' => array('type' => 'file', 'title' => 'Image', 'name' => 'image'), '22' => array('type' => 'spacer', 'title' => 'Custom Fields')); $result = $db->Execute("SELECT * FROM Obsedb_customfields WHERE module = 'Mods' ORDER BY title;"); while ($row = $result->FetchNextObject()) { $field = $db->Execute("SELECT * FROM Obsedb_Mods_customdata WHERE Modid = {$_REQUEST['id']} AND fieldid = {$row->ID};"); $form[] = array('type' => $row->TYPE, 'title' => $row->TITLE, 'name' => "field{$row->ID}", 'value' => stripslashes($field->fields['value'])); } $form[] = array('type' => 'submit', 'title' => 'Save Mod'); $hidden = array('id' => $_REQUEST['id']); GenerateForm('Mods.php', $LANG['edit_Mod'], 'edit_Mod_confirm', $form, $hidden, 'true'); }
do_table_footer(); do_form_footer(); } if ($_REQUEST['do'] == 'edit_section_confirm') { $rs = $db->Execute("SELECT * FROM `Obsedb_news_sections` WHERE `id` = '{$_REQUEST['id']}'"); $record = array('title' => $_REQUEST['title']); $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') {
function main() { global $db; if (isset($_REQUEST['section'])) { $where = "WHERE Obsedb_news.section = {$_REQUEST['section']}"; } // Globalize Variables $search = $_REQUEST['search']; $keyword = $_REQUEST['keyword']; $month = $_REQUEST['month']; $year = $_REQUEST['year']; do_header(); echo '<form method="post" action="archive.php">'; echo '<table border="0" cellspacing="0" cellpadding="0" width="100%">'; echo '<tr>'; echo '<td width="25%">Keywords:</td>'; echo '<td width="25%">Month:</td>'; echo '<td width="25%">Year:</td>'; echo '<td width="25%"></td>'; echo '</tr>'; echo '<tr>'; echo '<td width="25%"><input type="text" name="keyword" size="15"></td>'; echo '<td width="25%"><select name="month">'; echo '<option value="' . date("m") . '">' . date("F") . '</option>'; echo '<option value="01">January</option>'; echo '<option value="02">February</option>'; echo '<option value="03">March</option>'; echo '<option value="04">April</option>'; echo '<option value="05">May</option>'; echo '<option value="06">June</option>'; echo '<option value="07">July</option>'; echo '<option value="08">August</option>'; echo '<option value="09">September</option>'; echo '<option value="10">October</option>'; echo '<option value="11">November</option>'; echo '<option value="12">December</option>'; echo '</select></td>'; echo '<td width="25%"><select name="year">'; $thisyear = date("Y"); $startyear = $thisyear; while ($startyear >= $thisyear - 5) { if ($startyear == $thisyear) { echo "<option value=\"{$startyear}\" selected>{$startyear}</option>"; } else { echo "<option value=\"{$startyear}\">{$startyear}</option>"; } $startyear--; } echo '</select></td>'; echo '<td width="25%"><input type="submit" value="List Articles" name="submit"></td>'; echo '</tr>'; echo '</table>'; echo '<input type="hidden" name="search" value="1">'; echo '</form>'; echo '<table border="0" cellspacing="0" cellpadding="4" width="100%">'; $sections = FetchSections("Obsedb_news_sections"); $specialdata = "<b>News Sections</b><br />"; foreach ($sections as $key => $value) { $specialdata .= " "; $specialdata .= '<a href="archive.php?section=' . $key . '">' . stripslashes($value) . '</a><br />'; } $specialdata .= "<br />"; // Decide which query to use if ($search == 1) { if (!empty($keyword)) { $where = " AND `title` LIKE '%{$keyword}%'"; } $result = $db->Execute("SELECT id,title,author,date,section FROM Obsedb_news WHERE date LIKE '" . $year . "." . $month . ".%' {$where} ORDER BY date DESC"); } else { $result = $db->Execute("SELECT id,title,author,date,section FROM Obsedb_news ORDER BY date DESC LIMIT 0,50"); } while ($row = $result->FetchNextObject()) { echo '<tr>'; echo '<td><a href="index.php?do=viewarticle&id=' . $row->ID . '">' . $row->TITLE . '</a></td>'; echo '<td>' . $row->DATE . '</td>'; echo '<td>' . $row->AUTHOR . '</td>'; echo '</tr>'; } echo '</table><br /><br />'; do_footer(); }