client Home page customization

hi everybody, i'm still new on customizing WHMCS. Im trying to code a website installer wizard to help unskilled users to setup there hosting and domain name and install our custom CMS and.

The wizard have 3 steps

1. Choose hosting package
   

1. Register a domain
   

1. Install CMS
   

for step 1 and 2 the wizard should check if current loggedin client has an active hosting plane and domain name, then i can echo out proper massage on the wizard.

for step 3 i need to creat a custome table column to mark if the client has already installed my CMS or not (1= installed, 0= not installed).

NOTE: i coded HTML markup of the wizard (see attached image) directly on clientareahome.tpl page (becouse this is the only way i could make).

What i need to move on is :

1. Connect to database
   

1. retreave data from database
   

1. create conditions and if statement to show propers massages on the wizard.
   

Unfortunately my knowladge of WHMCS stope at this point, ...

any ideas on how to do these????

Thank you