Revenue collection fix

Fix to the revenue collection.   please use the SQL sent via e-mail for
users roles and tickets.