<?php

$sql = "SELECT a.`asset_id`, a.`asset_name` FROM `assets` a, `asset_types` at WHERE at.`type_name` = 'show' AND at.`type_id` = a.`type_id`";
$result = $db->query( $sql );
if ( PEAR::isError( $result ) ) {
	$response = '{
		"code": 1,
		"response": "' . $result->getMessage() . '"
	}';
} else {
	$shows_list = array();
	while ( $show_row = $result->fetchRow() ) {
		$show_obj = array(
			"id" => $show_row["asset_id"],
			"name" => $show_row["asset_name"],
			"attrs" => array()
		);
		$sql = "SELECT `attr_key`, `attr_val` FROM `attrs` WHERE `asset_id` = " . $show_row["asset_id"];
		$attr_result = $db->query( $sql );
		while ( $attr_row = $attr_result->fetchRow() ) {
			$show_obj["attrs"][$attr_row["attr_key"]] = $attr_row["attr_val"];
		}
		$shows_list[] = $show_obj;
	}
	$response = '{
		"code": 0,
		"response" : ' . json_encode( $shows_list ) . '
	}';
}

?>