2
the notification records are stored in the table <prefix>_xoopsnotifications , however since they pull information from other tables in the database, to see the information in a nice report you'll need to join this information with records from the <prefix>_modules and <prefix>_users tables.
To see all the notifications, sorted by Module, Category and Event try this query in phpmyadmin (the SQL tab):
SELECT m.name AS Module, n.not_category AS Category, n.not_event AS Event, u.uname AS User, n.not_itemid AS ItemID
FROM <prefix>_xoopsnotifications n
LEFT OUTER JOIN <prefix>_modules m ON n.not_modid = m.mid
LEFT OUTER JOIN <prefix>_users u ON n.not_uid = u.uid
ORDER BY m.name, n.not_category, n.not_event
To see just the ones by users who receive notifications by email:
SELECT m.name AS Module, n.not_category AS Category, n.not_event AS Event, u.uname AS User, n.not_itemid AS ItemID
FROM <prefix>_xoopsnotifications n
LEFT OUTER JOIN <prefix>_modules m ON n.not_modid = m.mid
LEFT OUTER JOIN <prefix>_users u ON n.not_uid = u.uid
[color=008000][b]WHERE u.notify_method = 1[/b][/color]
ORDER BY m.name, n.not_category, n.not_event