eZ Community » Forums » General » How to remove notifications from all...
expandshrink

How to remove notifications from all users?

How to remove notifications from all users?

Monday 02 November 2009 9:39:55 pm - 1 reply

Anyone knows how to remove notification subscription from all users who have managed to click on button before cronjob was set up? I have cleared the notificationevent table but want to remove old registrations too.

Its a deathtrap btw, it should not be possible to subscribe before that cronjob is set up, managed to kill the job when only few hundred was sent out, there was thousands in queue.. I hope that button is not there in forum anymore in 4.2?

EDIT: it seems clearing ezsubtree_notification_rule table should help, let me know if this could create any problems.

Modified on Monday 02 November 2009 10:14:18 pm by zurgutt -

Saturday 07 November 2009 1:03:42 pm

Hi,

Subscription date is not stored, you have no way to filter notification rules by subscription date.

PS :You should not manually accessing tables, you may be able to remove all notifications by doing something like that :

$db = eZDB::instance();
$rows = $db->arrayQuery('SELECT DISTINCT content_object_id FROM ezuser WHERE 1');
foreach( $rows as $row )
{
    eZSubtreeNotificationRule::removeByUserID($row['content_object_id']);
}

Good luck !

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from