root/trunk/inc_hp/index.inc.php

Revision 15, 3.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
26$user['info'] = array_merge ($user['info'],  $db->getRow('SELECT user_contact.email AS email, user_contact.im AS im, user_contact.im_type AS im_type, user_contact.address AS address, user_contact.zip AS zip, user_contact.city AS city, user_contact.country AS country, user_general.relationship_status AS relationship_status,  user_general.web AS web,  user_general.description AS description, user_interests.passions AS passions, user_interests.sports AS sports, user_professional.6nergies_url AS 6nergies_url  FROM user_general, user_contact, user_interests, user_professional WHERE user_general.id=? AND user_general.id=user_contact.id AND user_general.id=user_interests.id AND user_general.id=user_professional.id LIMIT 1', array($user['info']['id'])) );
27
28
29// $blog_r = $db->query('SELECT * FROM blog WHERE id=? AND status=? ORDER BY date DESC LIMIT 2', array($user['info']['id'], 'online'));
30
31
32if($rss_blog = $db->getRow('SELECT id_blog, title, link, rss FROM rss_blog WHERE id=?', array($user['info']['id'])) )
33{
34        $ticket_r = $db->query('SELECT id_ticket, title, description, link, date FROM rss_blog_ticket WHERE id=? ORDER BY date DESC LIMIT 3', array($user['info']['id']));
35        while($ticket = $ticket_r->fetchRow())
36                $rss_blog['item'][$ticket['link']] = $ticket;
37
38        $_SMARTY['rss_blog'] = $rss_blog;
39}
40else
41{
42        $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 3', array($user['info']['id'], 'online'));
43        if(DB::isError($blog_r))
44                error_log($_SERVER['HTTP_HOST'].' | '.$blog_r->getUserInfo());
45        else
46                while($blog = $blog_r->fetchRow())
47                {
48                        $blogs[$blog['id_blog']] = $blog;
49                }
50
51        $_SMARTY['blogs'] =  $blogs;
52}
53
54
55
56$album_r = $db->query('SELECT * FROM album WHERE id=? ORDER BY RAND() LIMIT 3', array($user['info']['id']));
57while($album = $album_r->fetchRow())
58{
59        $albums[$album['id_image']] = $album;
60    $albums[$album['id_image']]['thumb'] = build_album_thumb_url($user['info']['id'], $album['id_image']);
61    $albums[$album['id_image']]['photo'] = build_album_url($user['info']['id'], $album['id_image'], $album['format']);
62}
63
64$bookmark_r = $db->query('SELECT * FROM bookmarks WHERE id=? ORDER BY RAND() LIMIT 5', array($user['info']['id']));
65while($bookmark = $bookmark_r->fetchRow())
66{
67        $bookmarks[$bookmark['link']] = $bookmark;
68}
69$idx=0;
70foreach($user['info']['friends_id'] as $friend_id)
71{
72    if($idx>5) continue;
73        $friend = get_cache_user_info($friend_id, 'id, login, fname, lname, photo');
74    if($friend['photo'] != 'n')
75    {
76        $friends[$friend_id] = $friend;
77        $idx++;
78
79    }
80    unset($friend);
81}
82
83
84
85$_SMARTY['blogs'] =  $blogs;
86$_SMARTY['albums'] =  $albums;
87$_SMARTY['bookmarks'] =  $bookmarks;
88$_SMARTY['friends'] =  $friends;
89
90
91?>
Note: See TracBrowser for help on using the browser.