[geeklog-cvs] geeklog-1.3/public_html lib-common.php,1.205,1.206

dhaun at geeklog.net dhaun at geeklog.net
Sat Mar 15 13:25:00 EST 2003


Update of /usr/cvs/geeklog/geeklog-1.3/public_html
In directory internal.geeklog.net:/tmp/cvs-serv1845

Modified Files:
	lib-common.php 
Log Message:
Older Stories block was off by one story


Index: lib-common.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/public_html/lib-common.php,v
retrieving revision 1.205
retrieving revision 1.206
diff -C2 -d -r1.205 -r1.206
*** lib-common.php	11 Mar 2003 09:37:50 -0000	1.205
--- lib-common.php	15 Mar 2003 18:24:57 -0000	1.206
***************
*** 2856,2860 ****
      global $_TABLES, $_CONF;
  
!     $sql = "SELECT sid,tid,title,comments,unix_timestamp(date) AS day FROM {$_TABLES['stories']} WHERE (perm_anon = 2) AND (date <= NOW()) AND (draft_flag = 0) AND (featured = 0) ORDER BY date DESC LIMIT {$_CONF['limitnews']}, {$_CONF['limitnews']}";
      $result = DB_query( $sql );
      $nrows = DB_numRows( $result );
--- 2856,2860 ----
      global $_TABLES, $_CONF;
  
!     $sql = "SELECT sid,tid,title,comments,unix_timestamp(date) AS day FROM {$_TABLES['stories']} WHERE (perm_anon = 2) AND (date <= NOW()) AND (draft_flag = 0) ORDER BY featured DESC, date DESC LIMIT {$_CONF['limitnews']}, {$_CONF['limitnews']}";
      $result = DB_query( $sql );
      $nrows = DB_numRows( $result );





More information about the geeklog-cvs mailing list