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&amp;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();
}
Example #2
0
 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"], "&lt;") !== 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);
Example #3
0
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&amp;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();
}