From 7ce4ce0aa4d9741ec2ac18ccb8474ebf1992abb1 Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Tue, 8 Jan 2008 22:36:17 +0000
Subject: [PATCH] mod/chat:chat_cron() - IS NOT NULL is better - MDL-11674

---
 mod/chat/lib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/chat/lib.php b/mod/chat/lib.php
index 87ecc56066..4842fbfedc 100644
--- a/mod/chat/lib.php
+++ b/mod/chat/lib.php
@@ -212,7 +212,7 @@ function chat_cron () {
 
     $sql = "DELETE
               FROM {$CFG->prefix}chat_messages
-             WHERE ($subselect) > 0 AND timestamp < ( ".time()." -($subselect) * 24 * 3600)"; 
+             WHERE ($subselect) IS NOT NULL AND timestamp < ( ".time()." -($subselect) * 24 * 3600)"; 
 
     execute_sql($sql, false);
 
-- 
2.39.5