From a3fc59495b5abcb8e3ae1a72c3be2effd13130e2 Mon Sep 17 00:00:00 2001 From: Michal Vaner Date: Thu, 9 Oct 2008 11:37:23 +0200 Subject: [PATCH] Do not send XMPP notifs to people without address --- PciIds/DBQ.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/PciIds/DBQ.pm b/PciIds/DBQ.pm index 0446fb4..44f1614 100644 --- a/PciIds/DBQ.pm +++ b/PciIds/DBQ.pm @@ -108,6 +108,7 @@ sub new( $ ) { WHERE pending.notification = 1 AND users.nextxmpp <= ? + AND users.xmpp IS NOT NULL ORDER BY pending.user, pending.reason, history.time, history.location', 'dropnotifsxmpp' => 'DELETE FROM pending WHERE notification = 1 AND EXISTS ( SELECT 1 FROM users WHERE users.id = pending.user AND nextxmpp <= ? )', -- 2.39.5