Help need domain prices on WHMCS index.php for only 9 Extension

[thehost5968]

Hi

 

I need domain prices on WHMCS index.php for only 9 Extension here is the list:

 

.com £ 18.38

.net £ 18.38

.org £ 18.38

.info £ 18.38

.biz £ 18.38

.us £ 18.38

.eu £ 18.38

.co.uk £ 9.17

.in £ 4.38

 

I also need it to be Multiple Currency

 

here is the table:

 

<tr style="text-align: left;">
<td style="text-align: left;" class="tld-list" width="7%"><b>.com</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.net</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.org</b></td>
<td style="text-align: left;" class="tld-price" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
</tr>
<tr style="text-align: left;">
<td style="text-align: left;" class="tld-list" width="7%"><b>.info</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.biz</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.us</b></td>
<td style="text-align: left;" class="tld-price" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
</tr>
<tr style="text-align: left;">
<td style="text-align: left;" class="tld-list" width="7%"><b>.eu</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">18.38</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.co.uk</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">9.17</span></td>
<td style="text-align: left;" class="tld-list" width="7%"><b>.in</b></td>
<td style="text-align: left;" width="26%"><span class="lowercase">GBP</span> <span class="red-text">4.38</span></td>
</tr>

 

I did try this:

 

Select
   tblpricing.`id`,
   tblpricing.`type`,
   tblpricing.`currency`,
   tblpricing.`relid`,
   tblpricing.`msetupfee`,
   tblpricing.`qsetupfee`,
   tbldomainpricing.`extension`,
   tbldomainpricing.`order`
From
tbldomainpricing tbldomainpricing LEFT OUTER JOIN tblpricing tblpricing ON (tbldomainpricing.id = tblpricing.relid)
Where 
    ( tblpricing.type = 'domainregister' ) 
Order by
   tbldomainpricing.`order` Asc

but then what to do i do not now.

 

So could some one help me out?