// // ## END COPYRIGHT, LICENSE AND WARRANTY NOTICE ## // /*! \file edit_subscription.php */ $Module = $Params['Module']; $http = eZHTTPTool::instance(); if ($http->hasPostVariable('RemoveSubscriptionButton')) { if (is_array($http->postVariable('SubscriptionIDArray'))) { foreach ($http->postVariable('SubscriptionIDArray') as $subscriptionID) { $userData = eZUserSubscriptionData::fetchById($subscriptionID); $subscriptionList = eZSubscription::fetchListByEmail($userData->attribute('email'), eZSubscription::VersionStatusPublished, array(array(eZSubscription::StatusPending, eZSubscription::StatusApproved, eZSubscription::StatusConfirmed, eZSubscription::StatusRemovedSelf, eZSubscription::StatusRemovedAdmin))); foreach ($subscriptionList as $subscription) { eZSubscription::removeAll($subscription->Attribute('id')); } eZUserSubscriptionData::removeAll($subscriptionID); } } } if ($http->hasPostVariable('searchString') && trim($http->postVariable('searchString')) != "") { $search = trim(strtolower($http->postVariable('searchString'))); $db = eZDB::instance(); $searchSQL = "SELECT email FROM ezsubscriptionuserdata WHERE LOWER(firstname) LIKE '%" . $db->escapeString($search) . "%' or LOWER(name) LIKE '%" . $db->escapeString($search) . "%' or LOWER(email) LIKE '%" . $db->escapeString($search) . "%' group by email LIMIT 50"; $searchResult = $db->arrayQuery($searchSQL); $subscriberList = array(); foreach ($searchResult as $email) { $subscriberList[] = eZUserSubscriptionData::fetch($email['email']); } $countSQL = "SELECT id FROM ezsubscriptionuserdata WHERE LOWER(firstname) LIKE '%" . $db->escapeString($search) . "%' or LOWER(name) LIKE '%" . $db->escapeString($search) . "%' or LOWER(email) LIKE '%" . $db->escapeString($search) . "%' group by email"; $countResult = $db->arrayQuery($countSQL); $subscriberCount = count($countResult);