Users can now change receive status for coupons

[mailer.git] / inc / modules / member / what-cash_coupon.php

diff --git a/inc/modules/member/what-cash_coupon.php b/inc/modules/member/what-cash_coupon.php
index ae1938a4281fb0a8e05265930ea41a8f0f86f541..da4e810d4b8c9d28ad6bac0363a8447c0c5c65f3 100644 (file)
--- a/inc/modules/member/what-cash_coupon.php
+++ b/inc/modules/member/what-cash_coupon.php
@@ -147,6 +147,30 @@ LIMIT 1",
                // No code entered!
                displayMessage('{--MEMBER_COUPON_CODE_EMPTY--}');
        }
+} elseif (isFormSent('change')) {
+       // Change receive status, depending on its current state
+       if (getUserData('receiving_coupons') == 'Y') {
+               // Unsubscribe from coupons
+               $message = '{--MEMBER_COUPON_RECEIVE_STATUS_UNSUBSCRIBED--}';
+               $newStatus = 'N';
+       } else {
+               // Subscribe to coupons
+               $message = '{--MEMBER_COUPON_RECEIVE_STATUS_SUBSCRIBED--}';
+               $newStatus = 'Y';
+       }
+
+       // And change it in the database
+       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `receiving_coupons`='%s' WHERE `userid`=%s LIMIT 1",
+               array($newStatus, getMemberId()), __FILE__, __LINE__);
+
+       // Did something change?
+       if (!SQL_HASZEROAFFECTED()) {
+               // Records have been updated
+               displayMessage($message);
+       } else {
+               // Nothing changed!
+               displayMessage('{--MEMBER_COUPON_RECEIVE_STATUS_UNCHANGED--}');
+       }
 } else {
        // Load form template
        loadTemplate('member_cash_coupon', false);