KozmoK
Active member
Attached is a simple php file you can edit with your db info etc, that will give you this revenue report for your user upgrade/subscriptions.
This uses the xf_user_upgrade_log logs to gather data.
I just execute it from the command line, you can wrap it around pretty html or php, or even have cron run it and send you a daily email.
[root@KOZ]# php subscriptions.php
Last Year: 43,790.64
This Year: 23,456.42
Last Month: 3,663.99
This Month: 2,493.54
NOTE: this does not handle or substract refunds.
This uses the xf_user_upgrade_log logs to gather data.
I just execute it from the command line, you can wrap it around pretty html or php, or even have cron run it and send you a daily email.
[root@KOZ]# php subscriptions.php
Last Year: 43,790.64
This Year: 23,456.42
Last Month: 3,663.99
This Month: 2,493.54
NOTE: this does not handle or substract refunds.