From 40ccf77ca0c6745d8b75e925e915cdf51a924312 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 27 Feb 2011 16:16:40 +0100 Subject: Define "PackageComments.DelUsersID" as "NULL". Signed-off-by: Lukas Fleischer --- web/lib/pkgfuncs.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'web/lib') diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index 53868b64..6da29b4c 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -181,7 +181,7 @@ function package_comments_count($pkgid = 0) { $dbh = db_connect(); $q = "SELECT COUNT(*) FROM PackageComments "; $q.= "WHERE PackageID = " . mysql_real_escape_string($pkgid); - $q.= " AND DelUsersID = 0"; + $q.= " AND DelUsersID IS NULL"; } $result = db_query($q, $dbh); @@ -201,7 +201,7 @@ function package_comments($pkgid = 0) { $q.= "FROM PackageComments, Users "; $q.= "WHERE PackageComments.UsersID = Users.ID"; $q.= " AND PackageID = ".mysql_real_escape_string($pkgid); - $q.= " AND DelUsersID = 0"; # only display non-deleted comments + $q.= " AND DelUsersID IS NULL"; # only display non-deleted comments $q.= " ORDER BY CommentTS DESC"; if (!isset($_GET['comments'])) { -- cgit v1.2.3-24-g4f1b