Want to show how many messages has been sent

I want to show my members:
How many messages has ben sent totally sice start and last 3 days.
Is that possible?

Sure...

1. Calc the unixtime and subtract 3 days.
2. Execute
SELECT COUNT(*) FROM #__uddeim WHERE datum>=$timestamp

I mean to show on the frontpage as statistcs and totally for all members
Like "Our members has sent 6000 mail last 3 days"
"Our members has sent 60 000 mail since start"

Post edited by: Andrej, at: 2008/10/25 22:29

"Our members has sent 6000 mail last 3 days"

1. Calc the unixtime and subtract 3 days.
2. Execute
SELECT COUNT(id) FROM #__uddeim WHERE datum>=$timestamp

"Our members has sent 60 000 mail since start"

1. Execute
SELECT MAX(id) FROM #__uddeim

In what map do i find this code?

Is there a possibility that you could do a module for it?

Sure, how much do you want to pay for it?

Post edited by: slabbi, at: 2008/10/26 21:49