| 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 | $user['info'] = get_cache_user_info($url_id); |
|---|
| 29 | |
|---|
| 30 | if($rss_blog = $db->getRow('SELECT id_blog, title, link, rss FROM rss_blog WHERE id=?', array($url_id)) ) |
|---|
| 31 | { |
|---|
| 32 | $ticket_r = $db->query('SELECT id_ticket, title, description, link, date FROM rss_blog_ticket WHERE id=? ORDER BY date DESC LIMIT 10', array($url_id)); |
|---|
| 33 | while($ticket = $ticket_r->fetchRow()) |
|---|
| 34 | $rss_blog['item'][$ticket['link']] = $ticket; |
|---|
| 35 | |
|---|
| 36 | $_SMARTY['rss_blog'] = $rss_blog; |
|---|
| 37 | } |
|---|
| 38 | else |
|---|
| 39 | { |
|---|
| 40 | $blogs = $db->query('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 blog.id=? AND blog.status=? ORDER BY date DESC LIMIT 0,10', array($url_id, 'online') ); |
|---|
| 41 | if (DB::isError($blogs)) { |
|---|
| 42 | error_log($_SERVER['HTTP_HOST'].' | '.__FILE__.' '.$blogs->getMessage()); |
|---|
| 43 | } |
|---|
| 44 | |
|---|
| 45 | while($ticket = $blogs->fetchRow()) |
|---|
| 46 | $blog[$ticket['id_blog']] = $ticket; |
|---|
| 47 | |
|---|
| 48 | $_SMARTY['blog'] = $blog; |
|---|
| 49 | } |
|---|
| 50 | |
|---|
| 51 | |
|---|
| 52 | $user['info'] = get_cache_user_info($url_id); |
|---|
| 53 | |
|---|
| 54 | |
|---|
| 55 | |
|---|
| 56 | $leftmenu["/profile/$url_id"] = 'Profile'; |
|---|
| 57 | |
|---|
| 58 | if($user['info']['nb_photos'] > 0) |
|---|
| 59 | $leftmenu["/album/$url_id"] = 'Album'; |
|---|
| 60 | |
|---|
| 61 | if($user['info']['nb_blogs'] > 0) |
|---|
| 62 | $leftmenu["/blog/$url_id"] = 'Blog'; |
|---|
| 63 | |
|---|
| 64 | if($user['info']['nb_bookmarks'] > 0) |
|---|
| 65 | $leftmenu["/bookmarks/$url_id"] = 'Bookmarks'; |
|---|
| 66 | |
|---|
| 67 | $_SMARTY['leftmenu'] = $leftmenu; |
|---|
| 68 | |
|---|
| 69 | |
|---|
| 70 | |
|---|
| 71 | |
|---|
| 72 | $_SMARTY['user'] = $user; |
|---|
| 73 | |
|---|
| 74 | |
|---|
| 75 | ?> |
|---|