Changeset 15 for trunk/inc/_profile/all.inc.php
- Timestamp:
- 08/09/05 22:30:14 (7 years ago)
- Files:
-
- 1 modified
-
trunk/inc/_profile/all.inc.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/inc/_profile/all.inc.php
r1 r15 28 28 { 29 29 $ticket = $db->getRow('SELECT id_ticket, title, description, link, date, description, content FROM rss_blog_ticket WHERE id=? ORDER BY date DESC LIMIT 1', array($url_id)); 30 $ smarty->assign('blog_rss',$ticket);30 $_SMARTY['blog_rss'] = $ticket; 31 31 } 32 32 else 33 33 { 34 34 $blog = $db->getRow('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 1', array($url_id, 'online') ); 35 $ smarty->assign('blog',$blog);35 $_SMARTY['blog'] = $blog; 36 36 } 37 37 38 38 #$blog = $db->getRow('SELECT id_blog, title, chapeau, ticket, nb_comments FROM blog WHERE id=? AND status=? ORDER BY date DESC LIMIT 0,1', array($url_id, 'online')); 39 #$ smarty->assign('blog', $blog);39 #$_SMARTY['blog'] = $blog; 40 40 41 41 $bookmarks_r = $db->query('SELECT link, comment FROM bookmarks WHERE id=? ORDER BY date DESC LIMIT 0,4', array($url_id)); 42 42 while($bookmark = $bookmarks_r->fetchRow()) 43 43 $bookmarks[] = $bookmark; 44 $ smarty->assign('bookmarks',$bookmarks);44 $_SMARTY['bookmarks'] = $bookmarks; 45 45 46 46 $albums_r = $db->query('SELECT caption,id_image, width, height FROM album WHERE id=? ORDER BY date DESC LIMIT 0,3', array($url_id)); … … 50 50 $albums[] = $photo; 51 51 } 52 $ smarty->assign('albums',$albums);52 $_SMARTY['albums'] = $albums; 53 53 54 54
