[geeklog-cvs] geeklog-1.3/public_html/admin/plugins/staticpages index.php,1.19,1.20

[dhaun at geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/public_html/admin/plugins/staticpages
In directory internal.geeklog.net:/tmp/cvs-serv26271/public_html/admin/plugins/staticpages

Modified Files:
	index.php 
Log Message:
Added paging for the list of Static Pages (for more than 50 pages).


Index: index.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/public_html/admin/plugins/staticpages/index.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** index.php	11 Mar 2003 17:00:57 -0000	1.19
--- index.php	12 Mar 2003 11:34:05 -0000	1.20
***************
*** 13,17 ****
  // | Authors: Tony Bibbs       - tony at tonybibbs.com                            |
  // |          Phill Gillespie  - phill at mediaaustralia.com.au                   |
! // |          Tom Willett      - twillett at users.sourceforge.net
  // +---------------------------------------------------------------------------+
  // |                                                                           |
--- 13,18 ----
  // | Authors: Tony Bibbs       - tony at tonybibbs.com                            |
  // |          Phill Gillespie  - phill at mediaaustralia.com.au                   |
! // |          Tom Willett      - twillett at users.sourceforge.net                |
! // |          Dirk Haun        - dirk at haun-online.de                           |
  // +---------------------------------------------------------------------------+
  // |                                                                           |
***************
*** 288,336 ****
      $sp_templates->set_var('lang_url', $LANG_STATIC['url']);
  
! 	//if (empty($page)) $page = 1;
! 	//$limit = (50 * $page) - 50;
! 	//$result = DB_query("SELECT *,UNIX_TIMESTAMP(sp_date) AS unixdate FROM {$_TABLES['staticpage']} ORDER BY sp_date DESC LIMIT $limit,50");
!         $perms = SP_getPerms ('', '3');
!         if (!empty ($perms)) {
!             $perms = ' WHERE ' . $perms;
          }
! 	$result = DB_query("SELECT *,UNIX_TIMESTAMP(sp_date) AS unixdate FROM {$_TABLES['staticpage']}" . $perms . " ORDER BY sp_date DESC");
! 	$nrows = DB_numRows($result);
! 	if ($nrows > 0) {
!  		for ($i = 1; $i <= $nrows; $i++) {
! 			//$scount = (50 * $page) - 50 + $i;
! 			$A = DB_fetchArray($result);
!             $sp_templates->set_var('sp_id', $A['sp_id']);
!             $sp_templates->set_var('page_edit_url',COM_buildURL($_CONF['site_admin_url'] . '/plugins/staticpages/index.php?mode=edit&sp_id=' . $A['sp_id']));
!             $sp_templates->set_var('row_number', $i);
!             $sp_templates->set_var('page_display_url',COM_buildURL($_CONF['site_url'] . '/staticpages/index.php?page=' . $A['sp_id']));
!             $sp_templates->set_var ('page_clone_url', COM_buildURL ($_CONF['site_admin_url'] . '/plugins/staticpages/index.php?mode=clone&sp_id=' . $A['sp_id']));
!             $sp_templates->set_var('sp_title', stripslashes ($A['sp_title']));
!             $sp_templates->set_var('username', DB_getItem($_TABLES['users'],'username',"uid = {$A["sp_uid"]}"));
! 			$curtime = COM_getUserDateTimeFormat($A['unixdate']);
!             $sp_templates->set_var('sp_date', $curtime[0]);
!             $sp_templates->parse('list_item', 'row', true);
! 		}
!         $sp_templates->set_var('lang_nopages_msg', '');
!         /*
! 		$retval .= "<tr><td colspan=6>";
! 		if (DB_count($_TABLES['staticpage']) > 50) {
! 			$prevpage = $page - 1; 
! 			$nextpage = $page + 1;
! 			$num_pages = DB_count($_TABLES['staticpage']) / 50;
! 			if ($page > 1) {
! 				$retval .= "<a href={$_CONF["site_admin_url"]}/plugins/staticpages/index.php?mode=list&page=$prevpage>{$LANG50[1]}</a> &nbsp";
! 			}
! 			if ($page < $num_pages) {
! 				$retval .= "<a href={$_CONF["site_admin_url"]}/plugins/staticpages/index.php?mode=list&page=$nextpage>{$LANG50[2]}</a> ";
! 			}
! 		}
! 		$retval .= "</td></tr>
!         */
! 	} else {
!         $sp_templates->set_var('lang_nopages_msg', $LANG_STATIC['nopages']);
!         $sp_templates->set_var('list_item', '');
      }
! 	$sp_templates->set_var('end_block', COM_endBlock());	
  
      $retval .= $sp_templates->parse('output', 'list');
--- 289,351 ----
      $sp_templates->set_var('lang_url', $LANG_STATIC['url']);
  
!     $perpage = 50;
!     if ($page <= 0) {
!         $page = 1;
!     }
! 
!     $perms = SP_getPerms ('', '3');
!     if (!empty ($perms)) {
!        $perms = ' WHERE ' . $perms;
!     }
! 
!     $result = DB_query ("SELECT COUNT(*) AS count FROM {$_TABLES['staticpage']}" . $perms);
!     $C = DB_fetchArray ($result);
!     $numpages = ceil ($C['count'] / $perpage);
! 
!     if ($page > $numpages) {
!         $page = 1;
!     }
!     $start = ($page - 1) * $perpage;
! 
!     $result = DB_query ("SELECT *,UNIX_TIMESTAMP(sp_date) AS unixdate FROM {$_TABLES['staticpage']}" . $perms . " ORDER BY sp_date DESC LIMIT $start,$perpage");
!     $nrows = DB_numRows ($result);
!     if ($nrows > 0) {
!         for ($i = 1; $i <= $nrows; $i++) {
!             $A = DB_fetchArray($result);
!             $sp_templates->set_var ('sp_id', $A['sp_id']);
!             $sp_templates->set_var ('page_edit_url',
!                     COM_buildURL ($_CONF['site_admin_url']
!                     . '/plugins/staticpages/index.php?mode=edit&sp_id='
!                     . $A['sp_id']));
!             $sp_templates->set_var ('row_number', $i + $start);
!             $sp_templates->set_var ('page_display_url',
!                     COM_buildURL ($_CONF['site_url']
!                     . '/staticpages/index.php?page=' . $A['sp_id']));
!             $sp_templates->set_var ('page_clone_url',
!                     COM_buildURL ($_CONF['site_admin_url']
!                     . '/plugins/staticpages/index.php?mode=clone&sp_id='
!                     . $A['sp_id']));
!             $sp_templates->set_var ('sp_title', stripslashes ($A['sp_title']));
!             $sp_templates->set_var ('username', DB_getItem ($_TABLES['users'],
!                     'username', "uid = {$A["sp_uid"]}"));
!             $curtime = COM_getUserDateTimeFormat ($A['unixdate']);
!             $sp_templates->set_var ('sp_date', $curtime[0]);
!             $sp_templates->parse ('list_item', 'row', true);
          }
!         $sp_templates->set_var ('lang_nopages_msg', '');
! 
!         $baseurl = $_CONF['site_admin_url'] . '/plugins/staticpages/index.php';
!         if ($numpages > 1) {
!             $sp_templates->set_var ('google_paging',
!                     COM_printPageNavigation ($baseurl, $page, $numpages));
!         } else {
!             $sp_templates->set_var ('google_paging', '');
!         }
!     } else {
!         $sp_templates->set_var ('lang_nopages_msg', $LANG_STATIC['nopages']);
!         $sp_templates->set_var ('list_item', '');
!         $sp_templates->set_var ('google_paging', '');
      }
!     $sp_templates->set_var ('end_block', COM_endBlock ());	
  
      $retval .= $sp_templates->parse('output', 'list');