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. XOOPS general usage questions 
  4.  / how do I track the number of notifications sent?
Register
1
deka87
how do I track the number of notifications sent?

  • 2009/9/23 14:19

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


hi, i'm planing to advertise thirt party services thru notifications sent to my users and i need to track the number of notifications sent dayly or monthly. is it possible to do? thanks!
2
ghia
Re: how do I track the number of notifications sent?

  • 2009/9/23 17:12

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


What kind of result / report do you want?

An easy possible solution is also to duplicate all mail to your address in the notification mail sender (function notifyUser in /kernel/notification.php).
$xoopsMailer->setToEmails($xoopsConfig['adminmail']);                                             // gv copy to site admin

3
deka87
Re: how do I track the number of notifications sent?

  • 2009/9/23 18:40

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


hi ghia. well i actually wonder how many users do receive the notification mails. like if there were like 50 events like ad posting this month and 2000 users are subscribed to this event then i have 100 000 notifications sent. this is the number i need actually to let the advertiser know how many impressions his/her ad will get. i can count the number of events per month but the number of subscribers varies depending on the event so i thought i may find it in logs or anything just to have an approximate number i could deal with then.
4
deka87
Re: how do I track the number of notifications sent?

  • 2009/9/24 16:31

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


so is it possible guys?
5
ghia
Re: how do I track the number of notifications sent?

  • 2009/9/26 10:11

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


You could look the subscribed number of users up in the notification table
SELECT count(not_uid), `not_itemid`,`not_category`,`not_event` 
FROM `xoops_xoopsnotifications`  
WHERE not_modid =4 
group by `not_itemid`,`not_category`,`not_event`;

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

368 user(s) are online (34 user(s) are browsing Support Forums)

Members: 0

Guests: 368

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