database_query($sql) or die($database->database_error()." SQL was: $sql");
if( !$database->database_num_rows($resource) )
{
header("Location: admin_levels.php");
exit();
}
$level_info = $database->database_fetch_assoc($resource);
// SET RESULT AND ERROR VARS
$result = FALSE;
$is_error = FALSE;
// SAVE CHANGES
if($task == "dosave")
{
$level_blog_view = $_POST['level_blog_view'];
$level_blog_create = $_POST['level_blog_create'];
$level_blog_category_create = !empty($_POST['level_blog_category_create']);
$level_blog_entries = $_POST['level_blog_entries'];
$level_blog_style = $_POST['level_blog_style'];
$level_blog_search = $_POST['level_blog_search'];
$level_blog_trackbacks_allow = $_POST['level_blog_trackbacks_allow'];
$level_blog_trackbacks_detect = $_POST['level_blog_trackbacks_detect'];
$level_blog_html = $_POST['level_blog_html'];
$level_blog_privacy = is_array($_POST['level_blog_privacy']) ? $_POST['level_blog_privacy'] : array();
$level_blog_comments = is_array($_POST['level_blog_comments']) ? $_POST['level_blog_comments'] : array();
// FORMAT HTML CORRECTLY
$level_blog_html = preg_replace('/[,\s]+/', ',', $level_blog_html);
// CHECK THAT A NUMBER BETWEEN 1 AND 999 WAS ENTERED FOR BLOG ENTRIES
if( !is_numeric($level_blog_entries) || $level_blog_entries<1 || $level_blog_entries>999 )
{
$is_error = 1500110;
}
else
{
// GET PRIVACY AND PRIVACY DIFFERENCES
if( empty($level_blog_privacy) || !is_array($level_blog_privacy) ) $level_blog_privacy = array(63);
rsort($level_blog_privacy);
$new_privacy_options = $level_blog_privacy;
$level_blog_privacy = serialize($level_blog_privacy);
// GET COMMENT AND COMMENT DIFFERENCES
if( empty($level_blog_comments) || !is_array($level_blog_comments) ) $level_blog_privacy = array(63);
rsort($level_blog_comments);
$new_comments_options = $level_blog_comments;
$level_blog_comments = serialize($level_blog_comments);
// SAVE SETTINGS
$sql = "
UPDATE
se_levels
SET
level_blog_view='$level_blog_view',
level_blog_create='$level_blog_create',
level_blog_category_create='$level_blog_category_create',
level_blog_entries='$level_blog_entries',
level_blog_search='$level_blog_search',
level_blog_privacy='$level_blog_privacy',
level_blog_comments='$level_blog_comments',
level_blog_style='$level_blog_style',
level_blog_trackbacks_allow='$level_blog_trackbacks_allow',
level_blog_trackbacks_detect='$level_blog_trackbacks_detect',
level_blog_html='$level_blog_html'
WHERE
level_id='{$level_info['level_id']}'
LIMIT
1
";
$resource = $database->database_query($sql) or die($database->database_error()." SQL was: $sql");
if( !$level_blog_search )
$database->database_query("UPDATE se_blogentries INNER JOIN se_users ON se_users.user_id=se_blogentries.blogentry_user_id SET se_blogentries.blogentry_search='1' WHERE se_users.user_level_id='{$level_info['level_id']}'") or die("Error: ".$database->database_error()."
File: ".__FILE__."
Line: ".__LINE__."
Query: ".$sql);
$database->database_query("UPDATE se_blogentries INNER JOIN se_users ON se_users.user_id=se_blogentries.blogentry_user_id SET se_blogentries.blogentry_privacy='{$new_privacy_options[0]}' WHERE se_users.user_level_id='{$level_info['level_id']}' && se_blogentries.blogentry_privacy NOT IN('".join("','", $new_privacy_options)."')") or die("Error: ".$database->database_error()."
File: ".__FILE__."
Line: ".__LINE__."
Query: ".$sql);
$database->database_query("UPDATE se_blogentries INNER JOIN se_users ON se_users.user_id=se_blogentries.blogentry_user_id SET se_blogentries.blogentry_comments='{$new_comments_options[0]}' WHERE se_users.user_level_id='{$level_info['level_id']}' && se_blogentries.blogentry_comments NOT IN('".join("','", $new_comments_options)."')") or die("Error: ".$database->database_error()."
File: ".__FILE__."
Line: ".__LINE__."
Query: ".$sql);
$level_info = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_levels WHERE level_id='{$level_info['level_id']}'"));
$result = TRUE;
}
}
// GET PREVIOUS PRIVACY SETTINGS
for( $c=6; $c>0; $c-- )
{
$priv = pow(2, $c)-1;
$upl = user_privacy_levels($priv);
if( !$upl ) continue;
SE_Language::_preload($upl);
$privacy_options[$priv] = $upl;
}
for( $c=6; $c>=0; $c-- )
{
$priv = pow(2, $c)-1;
$upl = user_privacy_levels($priv);
if( !$upl ) continue;
SE_Language::_preload($upl);
$comment_options[$priv] = $upl;
}
// ASSIGN VARIABLES AND SHOW BLOG SETTINGS PAGE
$smarty->assign('result', $result);
$smarty->assign('is_error', $is_error);
$smarty->assign_by_ref('level_info', $level_info);
$smarty->assign('level_blog_privacy', unserialize($level_info['level_blog_privacy']));
$smarty->assign('level_blog_comments', unserialize($level_info['level_blog_comments']));
$smarty->assign('level_blog_html', str_replace(',', ', ', $level_info['level_blog_html']));
$smarty->assign('blog_privacy', $privacy_options);
$smarty->assign('blog_comments', $comment_options);
include "admin_footer.php";
?>