[geeklog-cvs] geeklog-1.3/plugins/staticpages functions.inc,1.21,1.22
geeklog-cvs-admin at lists.geeklog.net
geeklog-cvs-admin at lists.geeklog.net
Thu Jun 26 00:09:06 EDT 2003
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);
More information about the geeklog-cvs
mailing list