#!/usr/bin/php
<?php

/// init
	global $ini;
	global $node;

	require(dirname(__FILE__)."/../include/functions.php");
	init(1);

### Collect domains per client

	$sql="SELECT
			SUM(domain.active) AS domains,
			client.id AS cliid,
			client.name AS cliname

		FROM client
			LEFT JOIN domain ON domain.clientid=client.id
		WHERE 1
		AND `client`.`active`=1
		GROUP BY `client`.`id`
		ORDER BY domains, `client`.`name`
	;";

	$res=DBquery($sql);

	while ($row=$res->fetch_assoc()) {
		echo $row['cliname'].' '.$row['domains']."\n";
	}

DBclose();