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"; ?>