root/trunk/inc/communities/last.inc.php

Revision 15, 1.9 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$_SMARTY['Title'] =  'Communities';
26
27$last_comm_r = $db->query('SELECT community.id as id, community.id_comm as id_comm, community.name as name, community.description as description, community.nb_members, community_cat.name as cat_name, community.date as date FROM community LEFT JOIN community_cat USING (id_cat) WHERE community.date > ? ORDER BY community.date DESC', array(time()-604800));
28
29while($last_comm = $last_comm_r->fetchRow())
30{
31        $last_communities[$last_comm['id_comm']] = $last_comm;
32    $last_communities[$last_comm['id_comm']]['logo'] = build_logo_thumb_url($last_comm['id'], $last_comm['id_comm']);
33
34    $day = date('Ymd', $last_comm['date']);   
35
36    if($day != $last_day)
37    {
38        $last_communities[$last_comm['id_comm']]['day'] = $day;
39        $last_day=$day;
40        if($last_comm_day) $last_communities[$last_comm_day]['next_day']=$day;
41        $last_comm_day = $last_comm['id_comm'];
42    }
43}
44
45
46$_SMARTY['last_communities'] =  $last_communities;
47?>
Note: See TracBrowser for help on using the browser.