PHP UserUpgrades / Subscription Revenue Report


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.