I need to see the query at the user side, but when i activated the SQL debug it only works logged as admin.

I really need to see the sql query as one user determinated, because i have a big problem with notifications (i write a post before, but i don't see it publicated)

Maybe with a littel hack i can see it?

Thanks.

---

Well, it's publicated, i'm going to explain my problem:

I'm under XOOPS 2.2.4 and cbb 3.02

I have a big problem with some users and "Global notification: New post"

When User A from Group1 writes a post on Forum1, User B form Group2 recibed a notification, but he dont have any right to see or recibe it.

But if User C from Group1 writes a new post on Forum1, User B dont recibed nothing (it's the correct way)

It dont happends with all users, only whith someone.

Each user are in a sepparated groups, there are not any user in two or more groups.

Well, assigning User A to Webmaster groups, i can see the sql queries.

This is the line which is wrong and makes my nmotifications crash:

UPDATE DSS_xoopsnotifications SET not_modid = 5, not_category = 'global', not_itemid = 0, not_event = 'new_post', not_uid = 13, not_mode = 3 WHERE not_id = 81

The user A uid is 20, and this line uid 13 is flagged to recibe notifications, but it's very wrong.

I forget!

It only happens when User A and B have flagged "Notifications -> Global -> New post", but User A dont recibed nothing.

If user A dont have it flagged, user B dont recibed the notification.

I post this a xoopsforge too, but i haven't recibed support, and i really need it. I dont want nobody spend he/she time, but i dont know what is wrong with this :(

More information.

Posts write by ADMIN at Forum 1

User 1 -> Global Notifications: New post
User 2 -> Global Notifications: New post

User 2 recibe notification, but not User 1 (Wrong)

----------------

Posts write by ADMIN at Forum 1

User 1 -> Global Notifications: New post
User 2 -> No notifications

No body recibe notifications (Wrong)

----------------

Posts write by ADMIN at Forum 1

User 1 -> No notifications
User 2 -> Global Notifications: New post

User 2 recibe notification (Wrong)

----------------

Posts write by ADMIN at Forum 3

User 1 -> Global Notifications: New post
User 2 -> Global Notifications: New post

No body recibe notifications (Right)

Mi only solution is: no activate Global notifications :(