<?

	function get_where_clause($region)
	{
		switch($region)
		{
			case "Total":
				return "";
				break;
			case "us":
				return " AND cm.territory = 1 ";
				break;
			case "eu":
				return " AND cm.territory IN (18,20,24,16,25,30,31,36,39,55,57,58,59,68,192,195,71,6,74,4,210,14,211,82,84,85,90,12,101,106,107,108,109,115,120,121,128,133,142,143,145,146,152,193,190,159,160,15,232,5,11,176,180,3,201,241) ";
				break;
			case "row":
				return " AND ( cm.territory NOT IN (1, 18,20,24,16,25,30,31,36,39,55,57,58,59,68,192,195,71,6,74,4,210,14,211,82,84,85,90,12,101,106,107,108,109,115,120,121,128,133,142,143,145,146,152,193,190,159,160,15,232,5,11,176,180,3,201,241) OR cm.territory IS NULL )";
				break;
		}
		
	}
	
	$dms_master_list = array(
					"download"=> array(
								"us"=> array(1,7, 2, 4, 6, 5, 3),
								"eu"=> array(1, 2,5,3, 153, 130, 33),
								"row"=> array(1,2,5,3)
								),
					"stream"=> array(
								"us"=> array(2,4, 5, 3),
								"eu"=> array(2,5,3),
								"row"=> array(2)
								),
					"mobile"=> array(
								"us"=> array(106, 125, 151, 149, 136, 108, 36),
								"eu"=> array(147, 115, 29, 148),
								"row"=> array(107, 154)
								)
					);

?>