From d75eb892a69b878087ac5624257aa7b2a33b4c14 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Thu, 1 Jul 2010 20:38:28 +0200 Subject: [PATCH] Fix unsubscription issue with axletter MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Raphaël Barrois --- include/massmailer.inc.php | 2 +- modules/axletter/axletter.inc.php | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/include/massmailer.inc.php b/include/massmailer.inc.php index d4f0789..269a570 100644 --- a/include/massmailer.inc.php +++ b/include/massmailer.inc.php @@ -173,7 +173,7 @@ abstract class MassMailer rand(), "X.org rulez")); XDB::execute("UPDATE {$this->_subscriptionTable} as ni SET ni.hash = {?} - WHERE ni.uid != {?}", + WHERE ni.uid = {?}", $hash, $user->id()); } diff --git a/modules/axletter/axletter.inc.php b/modules/axletter/axletter.inc.php index 18818c7..761724c 100644 --- a/modules/axletter/axletter.inc.php +++ b/modules/axletter/axletter.inc.php @@ -117,10 +117,10 @@ class AXLetter extends MassMailer if (is_null($uid) && $hash) { return false; } - $res = XDB::query("SELECT * + $res = XDB::query("SELECT uid FROM axletter_ins WHERE $field={?}", $user); - if (!$res->numRows()) { + if ($res->numRows() != 1) { return false; } XDB::execute("DELETE FROM axletter_ins -- 2.1.4