$sql = "UPDATE categories SET seo_fname='" . jb_escape_sql($_REQUEST['file_' . $cat_id]) . "', seo_title='" . jb_escape_sql($_REQUEST['title_' . $cat_id]) . "', seo_desc='" . jb_escape_sql($_REQUEST['desc_' . $cat_id]) . "', seo_keys='" . jb_escape_sql($_REQUEST['keys_' . $cat_id]) . "' where category_id='" . jb_escape_sql($cat_id) . "' ";
if ($sql != $old_sql) {
//echo "$sql<br>";
JB_mysql_query($sql) or die(mysql_error());
$old_sql = $sql;
}
}
}
// update category cache
JB_cache_del_keys_for_form(1);
JB_cache_del_keys_for_all_cats(1);
$JBMarkup->ok_msg('Changes Saved.');
}
?>
<hr>
<h3>mod_rewrite for Categories</h3>
<div style='background-color: #F0FFFF; border:solid 2px #CCFFFF;margin:10px'>
Important: Please edit the extra fields for the categories below. To go down the category level, click on the parent category link. Some categories may be marked 'ambiguous filename' - please change the file name to a unique file name to avoid clashes. Title, Description and keywords are limited to 255 characters (anything more may clog the search engines!). Click the save button below to save changes. <b>If Cache is enabled, you will need to refresh your cache by going to Main Config and clicking on Save after saving this form.</b>
</div>
<form method='post' action='mod_rewrite.php'>
<?php
$MODE = "REWRITE";
$JB_CAT_MOD_REWRITE = "YES";
JB_showAllCat($_REQUEST['cat'], 1, 3, 'EN', 1);
?>
<input type='submit' value="Save" name='save' style='font-size: 14pt;' >
</form>
</p>
<?php
JB_admin_footer();
echo $row['category_id'];
?>
">
<input type="hidden" name="cat" value="<?php
echo $row['parent_category_id'];
?>
">
<input type="hidden" name="action" value="edit">
<input type="submit" value="Save">
</td>
</tr>
</table>
</form>
</p>
<hr>
<p> </p>
<table cellspacing="1" border="1" align="left" width="100%">
<?php
}
$MODE = "ADMIN";
JB_showAllCat($_REQUEST['cat'], 1, 3, $_SESSION["LANG"], $_SESSION['form_id']);
?>
</table>
<?php
?>
</div>
<?php
JB_admin_footer();