How to remove notifications from all users?

Next topic

Author	Message
zurgutt -	Monday 02 November 2009 12:39:55 pm 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. Certified eZ developer looking for projects. zurgutt at gg.ee
Romain Petit	Saturday 07 November 2009 4:03:42 am 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 !

Author

Message

Monday 02 November 2009 12:39:55 pm

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.

Certified eZ developer looking for projects.
zurgutt at gg.ee

Romain Petit

Saturday 07 November 2009 4:03:42 am

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 !

eZ debug

Timing:	Jan 18 2025 02:06:48
Script start
Timing:	Jan 18 2025 02:06:48
Module start 'layout'
Timing:	Jan 18 2025 02:06:48
Module start 'content'
Timing:	Jan 18 2025 02:06:49
Module end 'content'
Timing:	Jan 18 2025 02:06:49
Script end

Main resources:

Total runtime	0.5938 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	589.4688	152.6406
Module start 'layout'	0.0066	0.0035	742.1094	39.4766
Module start 'content'	0.0101	0.5822	781.5859	521.8828
Module end 'content'	0.5923	0.0014	1,303.4688	8.2813
Script end	0.5937		1,311.7500

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.5563	16	0.0002
Check MTime	0.0014	0.2317	16	0.0001
Mysql Total
Database connection	0.0006	0.1091	1	0.0006
Mysqli_queries	0.5517	92.9156	54	0.0102
Looping result	0.0005	0.0761	52	0.0000
Template Total	0.5642	95.0	2	0.2821
Template load	0.0023	0.3946	2	0.0012
Template processing	0.5618	94.6173	2	0.2809
Template load and register function	0.0001	0.0175	1	0.0001
states
state_id_array	0.0009	0.1593	1	0.0009
state_identifier_array	0.0008	0.1303	2	0.0004
Override
Cache load	0.0019	0.3218	13	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1246	2	0.0004
Fetch class attribute name	0.0015	0.2455	3	0.0005
XML
Image XML parsing	0.0006	0.0948	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0010	3	0.0000
General
dbfile	0.0008	0.1344	17	0.0000
String conversion	0.0000	0.0018	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs