2005/3/31 20:06
rickh
Just popping in
Posts: 94
Since: 2004/4/9 6
2005/3/31 22:37
ackbarr
Posts: 1449
Since: 2002/10/2
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
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
2005/3/31 22:46
Advanced Search
289 user(s) are online (221 user(s) are browsing Support Forums)
Members: 0
Guests: 289