function delete_cat_form() { global $params, $lang; if (!isset($params['id']) or !is_valid_id($params['id'])) { stderr($lang['categories_error'], $lang['categories_no_id']); } $q = sql_query("SELECT * FROM categories WHERE id = " . intval($params['id'])); if (false == mysqli_num_rows($q)) { stderr($lang['categories_error'], $lang['categories_exist_error']); } $r = mysqli_fetch_assoc($q); $q = sql_query("SELECT COUNT(*) FROM torrents WHERE category = " . intval($r['id'])); $count = mysqli_fetch_array($q, MYSQLI_NUM); $check = ''; if ($count[0]) { $select = "<select name='new_cat_id'>\n<option value='0'>{$lang['categories_select']}</option>\n"; $cats = genrelist2(); foreach ($cats as $c) { $select .= $c['id'] != $r['id'] ? "<option value='{$c["id"]}'>" . htmlsafechars($c['name'], ENT_QUOTES) . "</option>\n" : ""; } $select .= "</select>\n"; $check .= "<tr>\n <td align='right' width='50%'>{$lang['categories_select_new']}<br /><span style='color:red;font-weight:bold;'>{$lang['categories_del_warning']}</span></td>\n <td>{$select}</td>\n </tr>"; } $htmlout = ''; $htmlout .= "<form action='staffpanel.php?tool=categories&action=categories' method='post'>\n <input type='hidden' name='mode' value='takedel_cat' />\n <input type='hidden' name='id' value='" . (int) $r['id'] . "' />\n \n <table class='torrenttable' align='center' width='80%' bgcolor='#555555' cellspacing='2' cellpadding='2'>\n <tr>\n <td colspan='2' class='colhead'>{$lang['categories_del_about']}" . htmlsafechars($r['name'], ENT_QUOTES) . "</td>\n </tr>\n <tr>\n <td align='right' width='50%'>{$lang['categories_del_name']}</td>\n <td>" . htmlsafechars($r['name'], ENT_QUOTES) . "</td>\n </tr>\n <tr>\n <td align='right'>{$lang['categories_del_description']}</td>\n <td>" . htmlsafechars($r['cat_desc'], ENT_QUOTES) . "</td>\n </tr>\n <tr>\n <td align='right'>{$lang['categories_del_image']}</td>\n <td>" . htmlsafechars($r['image'], ENT_QUOTES) . "</td>\n </tr>\n {$check}\n <tr>\n <td colspan='2' align='center'>\n <input type='submit' class='btn' value='{$lang['categories_del_delete']}' /><input type='button' class='btn' value='{$lang['categories_cancel']}' onclick=\"history.go(-1)\" /></td>\n </tr>\n </table>\n </form>"; echo stdhead($lang['categories_del_stdhead'] . $r['name']) . $htmlout . stdfoot(); }
tr("" . $language['poster'] . "", "<input type=text name=poster size=80 value='" . safeChar($row["poster"]) . "'><br>" . $language['poster1'] . "\n", 1); tr("" . $language['trail'] . "", "<input type=text name=tube size=80 value='" . safeChar($row["tube"]) . "'><br>" . $language['sam1'] . "\n", 1); tr("" . $language['name'] . "", "<input type=\"text\" name=\"name\" value=\"" . safechar($row["name"]) . "\" size=\"80\" />", 1); tr("" . $language['sdesc'] . "", "<input type =\"text\" name=\"description\" size=\"80\" value=\"" . SafeChar($row["description"]) . "\"><br>" . $language['sdesc1'] . "", 1); tr("" . $language['nfo'] . "", "<input type=radio name=nfoaction value='keep' checked>Keep current<br>" . "<input type=radio name=nfoaction value='update'>Update:<br><input type=file name=nfo size=80>", 1); if (strpos($row["ori_descr"], "<") === false || strpos($row["ori_descr"], "<") !== false) { $c = ""; } else { $c = " checked"; } tr("" . $language['desc'] . "", "<textarea name=\"descr\" rows=\"10\" cols=\"80\">" . safeChar($row["ori_descr"]) . "</textarea><br>" . $language['desc1'] . "", 1); $s = "<select name=\"type\">\n"; if (get_user_class() >= UC_MODERATOR) { $cats = genrelist(); } else { $cats = genrelist2(); } foreach ($cats as $subrow) { $s .= "<option value=\"" . $subrow["id"] . "\""; if ($subrow["id"] == $row["category"]) { $s .= " selected=\"selected\""; } $s .= ">" . safechar($subrow["name"]) . "</option>\n"; } $s .= "</select>\n"; tr("" . $language['type'] . "", $s, 1); $so = "<select name=\"scene\">\n<option value=\"no\"" . ($row["scene"] == "no" ? " selected" : "") . ">Non-Scene</option>\n<option value=\"yes\"" . ($row["scene"] == "yes" ? " selected" : "") . ">Scene</option>\n</select>\n"; tr("" . $language['rel'] . "", $so, 1); $sp = "<select name=\"request\">\n<option value=\"no\"" . ($row["request"] == "no" ? " selected" : "") . ">No</option>\n<option value=\"yes\"" . ($row["request"] == "yes" ? " selected" : "") . ">Yes</option>\n</select>\n"; tr("" . $language['req'] . "", $sp, 1); tr("" . $language['vis'] . "", "<input type=\"checkbox\" name=\"visible\"" . ($row["visible"] == "yes" ? " checked=\"checked\"" : "") . " value=\"1\" /> Visible on main page<br /><table border=0 cellspacing=0 cellpadding=0 width=420><tr><td class=embedded>" . $language['vis1'] . "</td></tr></table>", 1);
function delete_cat_form() { global $params; if (!isset($params['id']) or !is_valid_id($params['id'])) { stderr('MOD ERROR', 'No category ID selected'); } $q = @mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM categories WHERE id = " . intval($params['id'])); if (false == mysqli_num_rows($q)) { stderr('MOD ERROR', 'That category does not exist or has been deleted'); } $r = mysqli_fetch_assoc($q); $q = sql_query("SELECT COUNT(*) FROM torrents WHERE category = " . intval($r['id'])); $count = mysqli_fetch_array($q, MYSQLI_NUM); $check = ''; if ($count[0]) { $select = "<select name='new_cat_id'>\n<option value='0'>Select Category</option>\n"; $cats = genrelist2(); foreach ($cats as $c) { $select .= $c['id'] != $r['id'] ? "<option value='{$c["id"]}'>" . htmlsafechars($c['name'], ENT_QUOTES) . "</option>\n" : ""; } $select .= "</select>\n"; $check .= "<tr>\r\n <td align='right' width='50%'>Select a new category:<br /><span style='color:red;font-weight:bold;'>Warning: There are torrents in this category, so you need to select a category to move them to.</span></td>\r\n <td>{$select}</td>\r\n </tr>"; } $htmlout = ''; $htmlout .= "<form action='staffpanel.php?tool=categories&action=categories' method='post'>\r\n <input type='hidden' name='mode' value='takedel_cat' />\r\n <input type='hidden' name='id' value='{$r['id']}' />\r\n \r\n <table class='torrenttable' align='center' width='80%' bgcolor='#555555' cellspacing='2' cellpadding='2'>\r\n <tr>\r\n <td colspan='2' class='colhead'>You are about to delete category: " . htmlsafechars($r['name'], ENT_QUOTES) . "</td>\r\n </tr>\r\n <tr>\r\n <td align='right' width='50%'>Cat Name:</td>\r\n <td>" . htmlsafechars($r['name'], ENT_QUOTES) . "</td>\r\n </tr>\r\n\t <tr>\r\n <td align='right' width='50%'>Parent ID:</td>\r\n <td>" . htmlsafechars($r['parent_id'], ENT_QUOTES) . "</td>\r\n </tr>\r\n\t <tr>\r\n <td align='right' width='50%'>Table Type:</td>\r\n <td>" . htmlsafechars($r['tabletype'], ENT_QUOTES) . "</td>\r\n </tr>\r\n <tr>\r\n <td align='right'>Description:</td>\r\n <td>" . htmlsafechars($r['cat_desc'], ENT_QUOTES) . "</td>\r\n </tr>\r\n <tr>\r\n <td align='right'>Image:</td>\r\n <td>" . htmlsafechars($r['image'], ENT_QUOTES) . "</td>\r\n </tr>\r\n {$check}\r\n <tr>\r\n <td colspan='2' align='center'>\r\n <input type='submit' class='btn' value='Delete' /><input type='button' class='btn' value='Cancel' onclick=\"history.go(-1)\" /></td>\r\n </tr>\r\n </table>\r\n </form>"; echo stdhead("Deleting category {$r['name']}") . $htmlout . stdfoot(); }