root/trunk/inc_hp/blog.inc.php

Revision 15, 2.0 KB (checked in by alexx, 7 years ago)
  • fix last bug in communities (see [14])
  • execute a "conversion smarty style" script ;) : for i in find . -type f | grep "\.php$" | grep -v "\.svn"; do perl -pi -e "s/\\\$smarty->assign\((.*),(.*)\);/\\\$_SMARTY\[\$1\] = \$2;/" $i; done
Line 
1<?php
2/****************************************************** Open .node ***
3 * Description:   
4 * Status:        Stable.
5 * Author:        Alexandre Dath <alexandre@dotnode.com>
6 * $Id$
7 *
8 * Copyright (C) 2005 Alexandre Dath <alexandre@dotnode.com>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 2 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program; if not, write to the Free Software Foundation,
22 * Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
23 ******************** http://opensource.ikse.net/projects/dotnode ***/
24
25
26if($rss_blog = $db->getRow('SELECT id_blog, title, link, rss FROM rss_blog WHERE id=?', array($user['info']['id'])) )
27{
28        $ticket_r = $db->query('SELECT id_ticket, title, description, link, date FROM rss_blog_ticket WHERE id=? ORDER BY date DESC LIMIT 10', array($user['info']['id']));
29        while($ticket = $ticket_r->fetchRow())
30                $rss_blog['item'][$ticket['link']] = $ticket;
31
32        $_SMARTY['rss_blog'] = $rss_blog;
33}
34else
35{
36    $blog_r = $db->query('SELECT 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 status=? ORDER BY date DESC LIMIT 10', array($user['info']['id'], 'online'));
37    if(DB::isError($blog_r))
38        error_log($_SERVER['HTTP_HOST'].' | '.$blog_r->getUserInfo());
39    else
40        while($blog = $blog_r->fetchRow())
41        {
42            $blogs[$blog['id_blog']] = $blog;
43        }
44
45    $_SMARTY['blogs'] =  $blogs;
46}
47?>
Note: See TracBrowser for help on using the browser.