1
rickh
Show which notifications users have set
  • 2005/3/31 20:06

  • rickh

  • Just popping in

  • Posts: 94

  • Since: 2004/4/9 6


Hello,

I want to know which users have set e-mail notifications (especially for news and articles modules). I've already searched the database with phpmyadmin, but i cannot find this information.

Someone knows where to find it?

2
ackbarr
Re: Show which notifications users have set

the notification records are stored in the table _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 _modules and _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 Modulen.not_category AS Categoryn.not_event AS Eventu.uname AS Usern.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
.namen.not_categoryn.not_event


To see just the ones by users who receive notifications by email:
SELECT m.name AS Modulen.not_category AS Categoryn.not_event AS Eventu.uname AS Usern.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.namen.not_categoryn.not_event

3
rickh
Re: Show which notifications users have set
  • 2005/3/31 22:46

  • rickh

  • Just popping in

  • Posts: 94

  • Since: 2004/4/9 6


thanks a lot!

Login

Who's Online

377 user(s) are online (148 user(s) are browsing Support Forums)


Members: 0


Guests: 377


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits