| 1 | <?php |
|---|
| 2 | |
|---|
| 3 | |
|---|
| 4 | |
|---|
| 5 | |
|---|
| 6 | |
|---|
| 7 | |
|---|
| 8 | |
|---|
| 9 | |
|---|
| 10 | |
|---|
| 11 | |
|---|
| 12 | |
|---|
| 13 | |
|---|
| 14 | |
|---|
| 15 | |
|---|
| 16 | |
|---|
| 17 | |
|---|
| 18 | |
|---|
| 19 | |
|---|
| 20 | |
|---|
| 21 | |
|---|
| 22 | |
|---|
| 23 | |
|---|
| 24 | |
|---|
| 25 | |
|---|
| 26 | |
|---|
| 27 | |
|---|
| 28 | |
|---|
| 29 | |
|---|
| 30 | |
|---|
| 31 | |
|---|
| 32 | $_SMARTY['Title'] = 'Home'; |
|---|
| 33 | |
|---|
| 34 | $idx = 0; |
|---|
| 35 | |
|---|
| 36 | $nyrk['total'] = $db->getOne('SELECT value FROM global_data WHERE name=?', array('nb_nodians')); |
|---|
| 37 | $nyrk['actually'] = $db->getOne('SELECT value FROM global_data WHERE name=?', array('actually')); |
|---|
| 38 | |
|---|
| 39 | $my['info'] = get_cache_user_info($_SESSION['my_id']); |
|---|
| 40 | $my['info']['nb_unread_messages'] = $db->getOne('SELECT COUNT(id) FROM message WHERE id=? AND flag=? AND box=?', array($_SESSION['my_id'], 'new', 'inbox')); |
|---|
| 41 | |
|---|
| 42 | |
|---|
| 43 | if($_SESSION['nb_foaf_timestamp'] < time() - 86400) |
|---|
| 44 | { |
|---|
| 45 | $foaf_id = $db->getCol('SELECT DISTINCT ( id_friend ) FROM relation WHERE id IN (\'!\') GROUP BY id_friend', 0, array(implode("','", $my['info']['friends_id']))); |
|---|
| 46 | |
|---|
| 47 | foreach($foaf_id as $ids) |
|---|
| 48 | $foaf[$ids]=1; |
|---|
| 49 | |
|---|
| 50 | foreach($_SESSION['my_friends_id'] as $ids) |
|---|
| 51 | $foaf[$ids]=1; |
|---|
| 52 | |
|---|
| 53 | $my['info']['nb_friends_of_friends'] = count($foaf)-1; |
|---|
| 54 | |
|---|
| 55 | $_SESSION['nb_foaf'] = $my['info']['nb_friends_of_friends']; |
|---|
| 56 | $_SESSION['nb_foaf_timestamp']=time(); |
|---|
| 57 | } |
|---|
| 58 | else |
|---|
| 59 | $my['info']['nb_friends_of_friends'] = $_SESSION['nb_foaf']; |
|---|
| 60 | |
|---|
| 61 | error_log($config['domain'].' | '.$_SESSION['my_login'].' | network size ==> '.$_SESSION['nb_foaf']); |
|---|
| 62 | |
|---|
| 63 | $idx=0; |
|---|
| 64 | foreach($my['info']['friends_id'] as $friend_id) |
|---|
| 65 | { |
|---|
| 66 | if($idx>9) |
|---|
| 67 | break; |
|---|
| 68 | $my['friends'][$friend_id] =& get_cache_user_info($friend_id); |
|---|
| 69 | $my['friends'][$friend_id]['photo'] = build_thumb_url($friend_id); |
|---|
| 70 | $idx++; |
|---|
| 71 | } |
|---|
| 72 | |
|---|
| 73 | |
|---|
| 74 | if($my['info']['communities_id']) |
|---|
| 75 | { |
|---|
| 76 | $my_comm_r = $db->query('SELECT c.id AS id, c.id_comm AS id_comm, c.name AS name, c.nb_members AS nb_members, c.moderated AS moderated, c.last_post_date AS last_post_date FROM community AS c LEFT JOIN user_comm AS u USING (id_comm) WHERE u.id=? ORDER BY c.last_post_date DESC LIMIT 0,10', array($_SESSION['my_id'])); |
|---|
| 77 | while($my_comm = $my_comm_r->fetchRow()) |
|---|
| 78 | { |
|---|
| 79 | $my['communities'][$my_comm['id_comm']] = $my_comm; |
|---|
| 80 | $my['communities'][$my_comm['id_comm']]['photo'] = build_logo_thumb_url($my_comm['id'], $my_comm['id_comm']); |
|---|
| 81 | } |
|---|
| 82 | } |
|---|
| 83 | |
|---|
| 84 | |
|---|
| 85 | $_SMARTY['leftmenu']["/profile/$url_id"] = 'View my own profile'; |
|---|
| 86 | |
|---|
| 87 | if($my['info']['nb_photos'] > 0) |
|---|
| 88 | $_SMARTY['leftmenu']["/album/$url_id"] = 'Album'; |
|---|
| 89 | $_SMARTY['leftmenu']["/metalbum/$url_id"] = 'Meta Album'; |
|---|
| 90 | |
|---|
| 91 | if($my['info']['nb_blogs'] > 0) |
|---|
| 92 | $_SMARTY['leftmenu']["/blog/$url_id"] = 'Blog'; |
|---|
| 93 | |
|---|
| 94 | if($my['info']['nb_bookmarks'] > 0) |
|---|
| 95 | $_SMARTY['leftmenu']["/bookmarks/$url_id"] = 'Bookmarks'; |
|---|
| 96 | |
|---|
| 97 | |
|---|
| 98 | |
|---|
| 99 | |
|---|
| 100 | $_SMARTY['my'] = $my; |
|---|
| 101 | |
|---|
| 102 | ?> |
|---|