Update of /cvsroot/php-blog/serendipity/plugins/serendipity_event_entryproperties
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19254/plugins/serendipity_event_entryproperties
Modified Files:
serendipity_event_entryproperties.php
Log Message:
Fixing broken SQL (works on PostgreSQL now, no strange things on SQLite, so hopefully this works too for other DBs
Index: serendipity_event_entryproperties.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/plugins/serendipity_event_entryproperties/serendipity_event_entryproperties.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- serendipity_event_entryproperties.php 6 Dec 2004 10:08:59 -0000 1.6
+++ serendipity_event_entryproperties.php 6 Dec 2004 16:19:33 -0000 1.7
@@ -292,9 +292,9 @@
case 'frontend_fetchentry':
$conds = array();
if ($_SESSION['serendipityAuthedUser'] === true) {
- $conds[] = " (ISNULL(ep_access.property) OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = " . (int)$serendipity['authorid'] . ")) ";
+ $conds[] = " (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = " . (int)$serendipity['authorid'] . ")) ";
} else {
- $conds[] = " (ISNULL(ep_access.property) OR ep_access.value = 'public') ";
+ $conds[] = " (ep_access.property IS NULL OR ep_access.value = 'public') ";
}
if (count($conds) > 0) {
@@ -308,7 +308,8 @@
$conds = array();
if (!isset($addData['noSticky']) || $addData['noSticky'] !== true) {
- $conds[] = 'ep_sticky.value IS NULL AS orderkey,';
+ $conds[] = 'ep_sticky.value AS orderkey,';
+ // $conds[] = 'ep_sticky.value IS NULL AS orderkey,';
} else {
$conds[] = '1 AS orderkey,';
}
|
