Hi,

I'm trying to add a few new user fields to my small website that can be displayed below the greeting on the joomla login module.

I want to show:

Opening Balance (a fixed value differing per user and stored in the user database) 

Return on Investment (a fixed value, the same for each user and stored in the database)

and a current balance (a calculated value based on the opening balance multiplied by the Return on Investment).

Using PHPmyadmin I have added openingBalance to the jos_user table and have populated each users opening balance.

I have added ROI to the jos_user table and have populated it for each user with the same ROI (is there a smarter way to do this as this value is the same for everyone).

My question is how do I show the opening and current balances in the frontend of the login module and how do I format the opening and current balance to be in the format $X,XXX.XX ?

 I'm sure its only a couple of lines of code but PHP is horribly confusing to me.

 My goal is to show the following in the login module:

 Hi, Bob,

Your opening balance is $X,XXX.XX

Your current balance is $X,XXX.XX

[logout]

 

Thanks.