AdminRealms.php

<?php

include_once("include/db.php");


# Return list of users
function getAdminRealms($params) {
	global $db;

	$sql = "SELECT ID, Name, Disabled FROM realms";
	$res = $db->query($sql);

	$resultArray = array();

		# loop through rows
		while ($row = $res->fetchObject()) {
			$item = array();

			$item['ID'] = $row->id;
			$item['Name'] = $row->name;
			$item['Disabled'] = $row->disabled;

			# push this row onto array
			array_push($resultArray,$item);
		}

	# get number of rows
	$sql = "SELECT count(*) FROM realms";
	$res = $db->query($sql);
	$numResults = $res->fetchColumn();

	return array($numResults,$resultArray);
}

?>