assign('homepage', 'homepage'); $userid=7653; // Blog - Recent Blogs Everyone $s_blog = "blogentry_date DESC"; $v_blog = 0; $p_blog = 1; // SET WHERE CLAUSE $where_blog = "CASE WHEN se_blogentries.blogentry_user_id='{$userid}' THEN TRUE WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_blogentries.blogentry_user_id AND friend_user_id2='{$userid}' AND friend_status='1' LIMIT 1)) "/* THEN TRUE WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_SUBNET) AND'{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_blogentries.blogentry_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) */."THEN TRUE WHEN ((se_blogentries.blogentry_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_blogentries.blogentry_user_id AND friends_secondary.friend_user_id2='{$userid}'"/* AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/." LIMIT 1)) THEN TRUE ELSE FALSE END"; if($where_blog == "") { $where_blog .= "WHERE se_blogentries.blogentry_user_id <> '70695'"; } else { $where_blog .= " AND se_blogentries.blogentry_user_id <> '70695'"; } // CREATE blog OBJECT $blog = new se_blog(); // GET TOTAL blogs $total_blogentries = $blog->blog_entries_total($where_blog); // MAKE ENTRY PAGES $blogentries_per_page = 24; $page_vars = make_page($total_blogentries, $blogentries_per_page, $p_blog); // GET blog ARRAY $blogentry_array = $blog->blog_entries_list($page_vars[0], $blogentries_per_page, $s_blog, $where_blog); // GET BLOG ENTRY CATEGORIES $blogentrycats_query = $database->database_query("SELECT * FROM se_blogentrycats WHERE blogentrycat_user_id=0 ORDER BY blogentrycat_id ASC"); $blogentrycats_array = array(); while( $blogentrycat=$database->database_fetch_assoc($blogentrycats_query) ) { $blogentrycats_array[] = array( 'blogentrycat_id' => $blogentrycat['blogentrycat_id'], 'blogentrycat_title' => $blogentrycat['blogentrycat_title'] ); } // ASSIGN SMARTY VARIABLES AND DISPLAY blogs PAGE $smarty->assign('total_blogentries', $total_blogentries); $smarty->assign_by_ref('blogentries', $blogentry_array); $smarty->assign_by_ref('blogentrycats', $blogentrycats_array); if(count($blogentry_array)>0){ include "footer-save.php"; } ?>