[geeklog-cvs] geeklog-1.3/plugins/staticpages functions.inc,1.21,1.22

[geeklog-cvs-admin at lists.geeklog.net]

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

Modified Files:
	functions.inc 
Log Message:
Modified Select query to order by sp_date so that if more then 1 staticpage has centerblock option on for the same page, only the last one edited will appear.

Index: functions.inc
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/plugins/staticpages/functions.inc,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** functions.inc	30 May 2003 12:24:31 -0000	1.21
--- functions.inc	26 Jun 2003 04:09:04 -0000	1.22
***************
*** 371,375 ****
          $perms = ' AND ' . $perms;
      }
!     $spsql = "SELECT sp_id,sp_content,sp_title,sp_format,sp_php FROM {$_TABLES['staticpage']} WHERE (sp_centerblock = 1) AND " . $moresql . $perms;
      $result = DB_query ($spsql);
  
--- 371,375 ----
          $perms = ' AND ' . $perms;
      }
!     $spsql = "SELECT sp_id,sp_content,sp_title,sp_format,sp_php FROM {$_TABLES['staticpage']} WHERE (sp_centerblock = 1) AND " . $moresql . $perms . " ORDER BY sp_date DESC";
      $result = DB_query ($spsql);