Generate Account List for Site

[CMerritt]

Is there a way to generate a list of accounts (e.g. domains/subdomains) out of WHMCS or WHM that could be included on my site? We're a hobby community, so I'd like to create a list so users can see who is hosted on the server and get involved with those sites.

 

Thanks for your help. I searched and couldn't come up with anything.

[brian!]

to do this, you'd probably need to query the WHMCS database to get a list of domains associated with hosting products... depending on your site, you might be able to do that in your code directly, or you could use a Data Feed to output the result on your site.

 

http://docs.whmcs.com/Data_Feeds

 

the basic SQL query to get an alphabetical list is quite simple...

 

SELECT domain FROM tblhosting ORDER BY domain

now it's possible that list might include domains that aren't associated with hosting products, and so you may not want to list them - in that instance, it will just be a case of modifying the SQL to only show domains from certain products.