Changeset 21 for trunk/inc

Show
Ignore:
Timestamp:
08/12/05 20:59:53 (7 years ago)
Author:
alexx
Message:

Add pagination to friends list

Location:
trunk/inc
Files:
4 modified

Legend:

Unmodified
Added
Removed

  • trunk/inc/friends/list.inc.php

    r15 r21  
    2323 ******************** http://opensource.ikse.net/projects/dotnode ***/ 
    2424 
     25include_once(INCLUDESPATH.'/pager.inc.php'); 
     26 
    2527$_SMARTY['Title'] =  'Friends'; 
    2628 
    … …  
    2830$user['photo'] = build_image_url($url_id); 
    2931 
    30 foreach($user['info']['friends_id'] as $friend_id) 
     32$pager =& Pager_dotnode::factory(null, array('totalItems' => $user['info']['nb_friends'], 'perPage' => 15)); 
     33 
     34list($first_item, $last_item) = $pager->getOffsetByPageId(); 
     35$limit_offset = $first_item-1; 
     36$limit_length = $last_item-$limit_start; 
     37 
     38$friends_range = array_slice($user['info']['friends_id'], $limit_offset, $limit_length); 
     39foreach($friends_range as $dummy=>$friend_id) 
    3140        $friends[$friend_id] = get_cache_user_info($friend_id); 
    3241 
    33 /********** determination du chemain *****************/ 
     42/********** determination du chemin *****************/ 
    3443$user['path'] = array(); 
    3544 
    … …  
    5564        $user['relation_type'] = 'members'; 
    5665 
    57  
    58  
    5966/************** menu ***************************/ 
    6067$leftmenu["/profile/$url_id"] = 'Profile'; 
    … …  
    7077 
    7178$_SMARTY['leftmenu'] = $leftmenu; 
     79/************************************************/ 
    7280 
    73 /************************************************/ 
    7481$_SMARTY['tr_attr'] = array("class='odd' style='vertical-align:top'", "class='even' style='vertical-align:top'"); 
    7582$_SMARTY['user'] =  $user; 
     83$_SMARTY['pager'] = $pager->getLinks(); 
    7684$_SMARTY['friends'] =  $friends; 
    7785?> 

  • trunk/inc/messages/inbox.inc.php

    r20 r21  
    3232 
    3333list($first_item, $last_item) = $pager->getOffsetByPageId(); 
    34 $limit_start = $first_item-1; 
    35 $limit_offset = $last_item-$limit_start; 
     34$limit_offset = $first_item-1; 
     35$limit_length = $last_item-$limit_offset; 
    3636 
    37 $messages_r = $db->query('SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'inbox', $limit_start, $limit_offset )); 
     37$messages_r = $db->query('SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'inbox', $limit_offset, $limit_length )); 
    3838 
    3939if(!DB::isError($messages_r) ) 

  • trunk/inc/messages/saved.inc.php

    r20 r21  
    3232 
    3333list($first_item, $last_item) = $pager->getOffsetByPageId(); 
    34 $limit_start = $first_item-1; 
    35 $limit_offset = $last_item-$limit_start; 
     34$limit_offset = $first_item-1; 
     35$limit_length = $last_item-$limit_offset; 
    3636 
    37 $messages_r = $db->query('SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'save', $limit_start, $limit_offset) ); 
     37$messages_r = $db->query('SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'save', $limit_offset, $limit_length) ); 
    3838 
    3939if(!DB::isError($messages_r) ) 

  • trunk/inc/messages/sent.inc.php

    r20 r21  
    3232 
    3333list($first_item, $last_item) = $pager->getOffsetByPageId(); 
    34 $limit_start = $first_item-1; 
    35 $limit_offset = $last_item-$limit_start; 
     34$limit_offset = $first_item-1; 
     35$limit_length = $last_item-$limit_offset; 
    3636 
    37 $messages_r = $db->query('SELECT id, id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id_from=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'send', $limit_start, $limit_offset) ); 
     37$messages_r = $db->query('SELECT id, id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id_from=? AND box=? ORDER by date DESC LIMIT !,!', array($_SESSION['my_id'],'send', $limit_offset, $limit_length) ); 
    3838 
    3939$cache=array();