XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Show which notifications users have set
Register
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 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
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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

354 user(s) are online (305 user(s) are browsing Support Forums)

Members: 0

Guests: 354

more...

Donat-O-Meter

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

Latest GitHub Commits