76 lines
3.0 KiB
PHP
76 lines
3.0 KiB
PHP
|
|
<?php
|
||
|
|
/* $Id: home.php 8 2009-01-11 06:02:53Z john $ */
|
||
|
|
|
||
|
|
$includeblog=true;
|
||
|
|
$page = 'latestblogs';
|
||
|
|
include "header-ajax.php";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$smarty->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";
|
||
|
|
}
|
||
|
|
?>
|