| 1 |
<?php |
|---|
| 2 |
|
|---|
| 3 |
|
|---|
| 4 |
|
|---|
| 5 |
|
|---|
| 6 |
|
|---|
| 7 |
|
|---|
| 8 |
|
|---|
| 9 |
|
|---|
| 10 |
|
|---|
| 11 |
|
|---|
| 12 |
|
|---|
| 13 |
|
|---|
| 14 |
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
| 17 |
|
|---|
| 18 |
|
|---|
| 19 |
|
|---|
| 20 |
|
|---|
| 21 |
|
|---|
| 22 |
|
|---|
| 23 |
|
|---|
| 24 |
|
|---|
| 25 |
|
|---|
| 26 |
$_SMARTY['Title'] = 'Blog'; |
|---|
| 27 |
|
|---|
| 28 |
if(is_numeric($token[2]) ) |
|---|
| 29 |
{ |
|---|
| 30 |
$sql = 'SELECT blog.id AS id, id_blog, blog.id_cat,title, chapeau, ticket, date, status, blog_categorie.name as categorie, nb_comments FROM blog LEFT JOIN blog_categorie USING (id,id_cat) WHERE id_blog=?'; |
|---|
| 31 |
if($url_id != $_SESSION['my_id']) |
|---|
| 32 |
$sql .= " AND status='online'"; |
|---|
| 33 |
$blog = $db->getRow($sql, array($token[2]) ); |
|---|
| 34 |
|
|---|
| 35 |
if($blog['id'] != $url_id) |
|---|
| 36 |
{ |
|---|
| 37 |
header('Location: /blog/'.$blog['id'].'/'.$blog['id_blog']); |
|---|
| 38 |
exit(); |
|---|
| 39 |
} |
|---|
| 40 |
|
|---|
| 41 |
|
|---|
| 42 |
|
|---|
| 43 |
if (DB::isError($blog)) { |
|---|
| 44 |
error_log($_SERVER['HTTP_HOST'].' | '.__FILE__.' '.$blog->getMessage()); |
|---|
| 45 |
} |
|---|
| 46 |
|
|---|
| 47 |
$query_values = array($url_id, $blog['id_blog']); |
|---|
| 48 |
$comments = $db->query('SELECT id_comment, id_author, title, comment, date FROM blog_comment WHERE id=? AND id_blog=? ORDER BY date',$query_values ); |
|---|
| 49 |
while($comment = $comments->fetchRow()) |
|---|
| 50 |
{ |
|---|
| 51 |
$blog['comment'][$comment['id_comment']] = $comment; |
|---|
| 52 |
$blog['comment'][$comment['id_comment']]['author'] = get_cache_user_info($comment['id_author']); |
|---|
| 53 |
} |
|---|
| 54 |
|
|---|
| 55 |
$user['info'] = get_cache_user_info($url_id); |
|---|
| 56 |
|
|---|
| 57 |
|
|---|
| 58 |
$leftmenu["/profile/$url_id"] = 'Profile'; |
|---|
| 59 |
|
|---|
| 60 |
if($user['info']['nb_photos'] > 0) |
|---|
| 61 |
$leftmenu["/album/$url_id"] = 'Album'; |
|---|
| 62 |
|
|---|
| 63 |
if($user['info']['nb_blogs'] > 0) |
|---|
| 64 |
$leftmenu["/blog/$url_id"] = 'Blog'; |
|---|
| 65 |
|
|---|
| 66 |
if($user['info']['nb_bookmarks'] > 0) |
|---|
| 67 |
$leftmenu["/bookmarks/$url_id"] = 'Bookmarks'; |
|---|
| 68 |
|
|---|
| 69 |
$_SMARTY['leftmenu'] = $leftmenu; |
|---|
| 70 |
|
|---|
| 71 |
|
|---|
| 72 |
|
|---|
| 73 |
|
|---|
| 74 |
$_SMARTY['user'] = $user; |
|---|
| 75 |
$_SMARTY['blog'] = $blog; |
|---|
| 76 |
} |
|---|
| 77 |
else |
|---|
| 78 |
header('Location: /blog/'.$url_id); |
|---|
| 79 |
|
|---|
| 80 |
?> |
|---|
| 81 |
|
|---|