nasatlx/nasatlx_romenig.php

<pre><?
	$conn = mysql_connect("localhost", "root", "XYZAdminLMDlA00--");
	$db = mysql_select_db("moodle2_6_1_2014_02");

	//$query_a = mysql_query("select m_course.*, m_nasatlx.course as cid, m_nasatlx.name from m_nasatlx, m_course where m_nasatlx.course = m_course.id");
	$query_a = mysql_query("select * from m_nasatlx_resps group by cmid");
	$cont = 0;

	$cmids = array();
	$cmids[30] = "1 Exercícios - T1";
	$cmids[193] = "2 Exercícios - T1";
	$cmids[196] = "2 Desafio - T1";
	$cmids[309] = "3 Exercícios - T1";
	$cmids[314] = "3 Discursiva - T1";

	$cmids[68] = "1 Exercícios - T2";
	$cmids[203] = "2 Exercícios - T2";
	$cmids[204] = "2 Desafio - T2";
	$cmids[321] = "3 Exercícios - T2";
	$cmids[324] = "3 Discursiva - T2";

	$cmids[88] = "1 Exercícios - T3";
	$cmids[209] = "2 Exercícios - T3";
	$cmids[215] = "2 Desafio - T3";
	$cmids[330] = "3 Exercícios - T3";
	$cmids[333] = "3 Discursiva - T3";

?>
<? while($d = mysql_fetch_array($query_a)){ ?>
			<h2><? echo $cmids[intVal(strval(($d["cmid"])))]. " " ." - " . intVal(strval(($d["cmid"]))); ?></h2>
<?
				$query_r = mysql_query("select * from m_nasatlx_resps where cmid = ".$d["cmid"]);
				echo "scale1;scale2;scale3;scale4;scale5;scale6;peso1;peso2;peso3;peso4;peso5;peso6;calc1;calc2;calc3;calc4;calc5;calc6\n";
				
				while($d2 = mysql_fetch_array($query_r)){
					echo 
						$d2["scale1"].";".
						$d2["scale2"].";".
						$d2["scale3"].";".
						$d2["scale4"].";".
						$d2["scale5"].";".
						$d2["scale6"].";";
					echo 
						$d2["peso1"].";".
						$d2["peso2"].";".
						$d2["peso3"].";".
						$d2["peso4"].";".
						$d2["peso5"].";".
						$d2["peso6"].";";
					echo 
						$d2["calc1"].";".
						$d2["calc2"].";".
						$d2["calc3"].";".
						$d2["calc4"].";".
						$d2["calc5"].";".
						$d2["calc6"].";\n";
				}
			?>
		<? 
			}

			echo "||".$cont;
		 ?>