root/trunk/inc/communities/mine.inc.php

Revision 15, 1.8 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'] =  'My communities';
26
27$my_communities_r = $db->query('SELECT name, community.id_comm as id_comm, description, nb_members, last_post_date, community.id as id FROM community LEFT JOIN user_comm USING (id_comm) WHERE user_comm.id=? AND user_comm.status=? ORDER BY last_post_date DESC', array($_SESSION['my_id'], 'ok') );
28
29if(DB::isError($my_communities_r))
30    error_log($my_communities_r->getUserInfo());
31
32while($my_community = $my_communities_r->fetchRow())
33{
34    $day = date('Ymd', $my_community['last_post_date']);
35    $key = $my_community['id_comm'];
36    if($day != $last_day)
37    {
38        $my_community['day'] = $day;
39        $last_day = $day;
40        if($last_comm_day_key) $my_communities[$last_comm_day_key]['next_day'] = $day;
41        $last_comm_day_key = $key;
42    }
43
44    $my_communities[$key] = $my_community;
45}
46
47$_SMARTY['my_communities'] =  $my_communities;
48
49?>
Note: See TracBrowser for help on using the browser.