database_query($sql) or die($database->database_error()." SQL was: $sql");
if( $database->database_affected_rows($resource) )
echo '{"result" : "success"}';
else
echo '{"result" : "failure"}';
exit();
}
// CREATE CATEGORY
else if( $task=="createblogentrycat" )
{
$lvar_id = SE_Language::edit(0, $blogentrycat_title, NULL, LANGUAGE_INDEX_SUBNETS);
$sql = "INSERT INTO se_blogentrycats (blogentrycat_languagevar_id,blogentrycat_title) VALUES ('{$lvar_id}','{$blogentrycat_title}')";
$resource = $database->database_query($sql) or die($database->database_error()." SQL was: $sql");
if( $database->database_affected_rows($resource) )
echo '{"result" : "success", "blogentrycat_id" : '.$database->database_insert_id().', "blogentrycat_languagevar_id" : '.$lvar_id.'}';
else
echo '{"result" : "failure"}';
exit();
}
// EDIT CATEGORY
else if( $task=="editblogentrycat" )
{
// Get langvar id
$sql = "SELECT * FROM se_blogentrycats WHERE blogentrycat_id='{$blogentrycat_id}' LIMIT 1";
$resource = $database->database_query($sql) or die($database->database_error()." SQL was: $sql");
if( !$database->database_num_rows($resource) )
{
echo '{"result" : "failure"}';
exit();
}
$result = $database->database_fetch_assoc($resource);
$lvar_id = $result['blogentrycat_languagevar_id'];
SE_Language::edit($lvar_id, $blogentrycat_title);
$sql = "UPDATE se_blogentrycats SET blogentrycat_title='{$blogentrycat_title}' WHERE blogentrycat_id='{$blogentrycat_id}' LIMIT 1";
$resource = $database->database_query($sql) or die($database->database_error()." SQL was: $sql");
if( $database->database_affected_rows($resource) || $resource )
echo '{"result" : "success"}';
else
echo '{"result" : "failure"}';
exit();
}
// SAVE CHANGES
elseif($task == "dosave")
{
$setting_permission_blog = $_POST['setting_permission_blog'];
$sql = "UPDATE se_settings SET setting_permission_blog='$setting_permission_blog'";
$database->database_query($sql) or die($database->database_error()." SQL was: $sql");
$setting = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_settings LIMIT 1"));
$result = 1;
}
// GET BLOG ENTRY CATEGORIES
$categories_array = se_blog::blog_category_list($blogentrycat_showusercreated);
// ASSIGN VARIABLES AND SHOW GENERAL SETTINGS PAGE
$smarty->assign('result', $result);
$smarty->assign('blogentrycats', $categories_array);
include "admin_footer.php";
?>