| 37 | | /* |
| 38 | | $blog_r = $db->query(' |
| 39 | | SELECT |
| 40 | | blog.id, |
| 41 | | cache_user.fname as fname, |
| 42 | | cache_user.lname as lname, |
| 43 | | id_blog, |
| 44 | | title, |
| 45 | | chapeau, |
| 46 | | ticket, |
| 47 | | date |
| 48 | | FROM |
| 49 | | blog,cache_user |
| 50 | | WHERE |
| 51 | | blog.id=cache_user.id AND |
| 52 | | blog.status=? |
| 53 | | ORDER BY date DESC |
| 54 | | LIMIT 20 |
| 55 | | ', array('online')); |
| 56 | | while($blog =& $blog_r->fetchRow()) |
| 57 | | { |
| 58 | | if(strlen($blog['ticket'])>100) |
| 59 | | $blogs[$blog['date'].str_pad($blog['id_blog'],6,0)] =& $blog; |
| 60 | | } |
| 61 | | $blog_r = $db->query(' |
| 62 | | SELECT |
| 63 | | rss_blog_ticket.id, |
| 64 | | cache_user.fname as fname, |
| 65 | | cache_user.lname as lname, |
| 66 | | id_blog, |
| 67 | | title, |
| 68 | | description as chapeau, |
| 69 | | link, |
| 70 | | date |
| 71 | | FROM |
| 72 | | rss_blog_ticket,cache_user |
| 73 | | WHERE |
| 74 | | rss_blog_ticket.id=cache_user.id AND |
| 75 | | rss_blog_ticket.date<? |
| 76 | | ORDER BY date DESC |
| 77 | | LIMIT 20 |
| 78 | | ', array(time())); |
| 79 | | while($blog =& $blog_r->fetchRow()) |
| 80 | | { |
| 81 | | if(strlen($blog['chapeau'])>100) |
| 82 | | $blogs[$blog['date'].str_pad($blog['id_blog'],6,0)] =& $blog; |
| 83 | | } |
| 84 | | krsort($blogs); |
| 85 | | |
| 86 | | $smarty->assign('blogs' , array_slice($blogs,0,15)); |
| 87 | | |
| 88 | | */ |
| 89 | | $smarty->assign('page' , $page); |
| | 37 | $_SMARTY['page' ] = $page; |