getdomainpricing.php

<?php 
/** 
 * API function 
 * Get domain pricing
 * includes/api/getdomainpricing.php 
 */ 
 
if (!defined("WHMCS")) {
	die("This file cannot be accessed directly");
}

$apiresults = ['result' => 'error', 'message' => 'No Result found'];

$query = "SELECT tblpricing.currency, tblpricing.msetupfee, tblpricing.qsetupfee, tblpricing.ssetupfee, 
								tblpricing.asetupfee, tblpricing.bsetupfee, tblpricing.monthly, tblpricing.quarterly, 
								tblpricing.semiannually, tblpricing.annually, tblpricing.biennially, 
								(
									SELECT tblcurrencies.prefix 
									FROM tblcurrencies 
									WHERE id = tblpricing.currency
								) AS curprefix,
								(
									SELECT tblcurrencies.suffix 
									FROM tblcurrencies 
									WHERE id = tblpricing.currency
								) AS cursuffix,
								(
									SELECT tbldomainpricing.extension 
									FROM tbldomainpricing 
									WHERE id = tblpricing.relid
								) AS tld
						FROM tblpricing
						WHERE tblpricing.type= 'domainregister'
							AND !(
								SELECT tbldomainpricing.extension 
								FROM tbldomainpricing 
								WHERE id = tblpricing.relid
							)";
try {
	
	$satement = mysql_query($query);
	
	$domains = [];
	
	while($row = mysql_fetch_assoc($satement)) { $domains[] = $row;	}
	
	$apiresults = ['result' => 'success', 'domain_pricing' => $domains];	
		
} catch (Exception $e){
	
	$apiresults = ['result' => 'error', 'message' => $e->getMessage()];
	
	echo json_encode($apiresults);
	die();
}

echo json_encode($apiresults);
die();

This is a simple script to get WHMCS domain pricing through the API