Views pager

<?php {    
  $maxdisp  = 25;	
  $shownum  = variable_get("blogger_shownum", 0);  
  $blogger_order  = variable_get("blogger_order", 0); 
  $blogger_case   = variable_get("blogger_case", 0); 
  $blogger_avatar = variable_get("blogger_avatar", 0); 
  $blogger_avatar_width = variable_get("blogger_avatar_width", 0);
  $blogger_avatar_height = variable_get("blogger_avatar_height", 0);
 
  $sql_counts = " SELECT DISTINCT (u.name)"
	           ." FROM {users} u"
	           ." INNER JOIN {node} n ON n.uid=u.uid"
	           ." WHERE u.name<>'' AND n.type='blog' AND n.status=1"
		       ;
  $dse_sql_counts = db_query($sql_counts);
  $cnt_sql_counts = db_num_rows($dse_sql_counts);
  $sql_counts = "SELECT $cnt_sql_counts";
 
  $sql = " SELECT n.uid, u.name, count(u.name) AS numitems, u.picture, n.title "
      ." FROM {node} n "
      ." INNER JOIN {users} u ON u.uid = n.uid "
	  ." WHERE n.type = 'blog' AND n.status=1 "
	  ." GROUP BY n.uid"
	  .($blogger_order<>0 ? " ORDER BY " : "")
	  .($blogger_order==1 ? "u.name" : "")
	  .($blogger_order==2 ? "numitems DESC, u.name" : "")
	  ;
  $sql = db_rewrite_sql($sql);
 
  //$results = pager_query($sql, 1, 0, $sql_count, COMMENT_PUBLISHED, $uid, $uid);
  $results = pager_query($sql, $maxdisp, 0, $sql_counts);
 
  $i=1;
  while ($node = db_fetch_object($results)) {  
    //l($node->title, "node/$node->nid") .' '. theme('mark', node_mark($node->nid, $node->changed)),
    switch ($blogger_case)  
	{
      default:
      case 0:
        break;
      case 1: //smallcase
        $node->name = strtolower($node->name);
        break;
      case 2: //uppercase
        $node->name = strtoupper($node->name);
        break;
      case 3: //Wordcase
        $node->name = ucwords($node->name);
        break;
    }
 
    //Latest blog
	$sql = " SELECT n.title, nid "
	      ." FROM {node} n "
		  ." WHERE n.uid = '$node->uid' AND n.type='blog' AND n.status=1"
		  ." ORDER BY n.created DESC"
		  ." LIMIT 1"
		  ;
    $latest_blogs = db_query($sql);
    $latest_blog  = db_fetch_object($latest_blogs);
	//  
	if (($blogger_avatar) AND ($node->picture<>"")) 
	{ 
	  $blogger_img  = base_path().$node->picture;
	  $showpict = "<img src='$blogger_img' align='center'"
	           .($blogger_avatar_width<>0 ?  " width=$blogger_avatar_width " : " ")
	  		   .($blogger_avatar_height<>0 ? " height=$blogger_avatar_height " : " ")  
		       ."></>";
	}
	else
	{ $showpict = ""; }
	//  
    if (!$blogger_avatar)
	{  
      $rows[] = array(
        l($node->name, "blog/$node->uid"),
        $node->numitems,
        l($latest_blog->title, "node/$latest_blog->nid")
      );
    } else {
	  $rows[] = array(
        l($node->name, "blog/$node->uid"),
        $node->numitems,
        l($latest_blog->title, "node/$latest_blog->nid"),
		"$showpict"
	  );
	}
  }
  if (!$blogger_avatar) { $header = array( t('Name'), t('Numbers of Blogs'),t('Latest Blog') ); }
  else { $header = array( t('Name'), t('Numbers of Blogs'),t('Latest Blog'), t('Avatar') ); }
 
  $output = '<div id="blogger">';
  $output .= theme('table', $header, $rows);
  $output .= theme('pager', NULL, $maxdisp, 0);
  $output .= '</div>';
 
  return $output;
} ?>