doc: Nils Weber doesnt have an 'e' in his firstname

3 files changed, 887 insertions, 0 deletions

diff --git a/doc/nils-diplom/Dateistruktur/results/admin_result.php b/doc/nils-diplom/Dateistruktur/results/admin_result.php
new file mode 100755
index 0000000..00a6863
--- /dev/null
+++ b/doc/nils-diplom/Dateistruktur/results/admin_result.php
@@ -0,0 +1,489 @@
+<?php
+	
+	include("../header.php");
+
+	$user = $_SESSION['user'];
+	
+	if (! isset($_GET['ID']))
+	{$message="Um Details anzuzeigen klicken sie bitte in der Übersicht den entsprechenden Link";}
+
+	$sql = "SELECT count(lesson_id) FROM lessons where aktiv=1"; // wieviele Aufgabe sind derzeit aktiv
+		
+		$stmt = dbconnect($sql);
+
+		OCIExecute($stmt);
+				
+		$nrows = OCIFetchStatement($stmt,$results);  	
+
+		if ( $nrows == 1 ) 
+			{
+				OCIExecute($stmt);
+
+				while(OCIFetch($stmt))
+				{
+					$max = OCIResult($stmt, $results); // Anzahl der zu lösenden Aufgaben
+				}
+			}
+
+	//.....Info zu allen AKTIVIERTEN Nutzern.......
+
+	$sql = "select F_name as VORNAME, NAME, tmp.STATUS, S.STUD_ID as DEATILS from STUDENTS S JOIN (SELECT Count(distinct LESSON_ID) as STATUS, stud_ID from logon group by stud_ID) tmp on s.STUD_ID = tmp.STUD_ID and S.AKTIV=1";
+
+	$stmt = dbconnect($sql);
+
+	OCIExecute($stmt);
+
+?>
+
+
+								<tr >
+								<td><div class=titel_15>AUSWERTUNGEN</div></td>
+								</tr>
+
+								<tr>
+								<td><br></td>
+								</tr>
+								
+								<tr>
+								<td bgcolor=#e99900 colspan=2><div class=text>Übersicht über alle Studenten - Klick in die Spalte Detail zeigt die Einzelauswertung der Studenten im unteren Bereich der Seite....</div></td>
+								</tr>
+
+								<tr>
+								<td>
+								
+							
+				
+
+
+
+<?
+
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+if ( $nrows > 0 ) 
+	{
+		   print "<BR><TABLE BORDER=\"1\"  class=text>\n";
+		   print "<TR>\n";
+		   while ( list( $key, $val ) = each( $results ) ) 
+			   {
+				print "<TH>$key</TH>\n";
+			   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      $col=0;
+	  reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) 
+			{
+			 $data = $column['value'];
+			
+			 if ($col==2)
+				{
+				 $percent = round($data[$i] * 100/$max);	
+				 
+				 if ($percent <= 25) 
+					print "<td width=300>&nbsp;<img src=\"/dipl/css/balken_rot.gif\" width=$percent height=10 > $data[$i]  Aufgaben gelöst ($percent %)</td>"; 
+				 if ($percent > 25 and $percent < 50)
+					print "<td width=300>&nbsp;<img src=\"/dipl/css/balken_orange.gif\" width=$percent height=10 > $data[$i]  Aufgaben gelöst ($percent %)</td>";
+				 if ($percent >= 50)
+					print "<td width=300>&nbsp;<img src=\"/dipl/css/balken_gelb.gif\" width=$percent height=10 > $data[$i]  Aufgaben gelöst ($percent %)</td>";
+				 if ($percent == 100)
+					print "<td width=300>&nbsp;<img src=\"/dipl/css/abgeschlossen.gif\"> Alle Aufgaben erfolgreich gelöst.</td>";
+				 }
+			
+			 else if ($col==3)
+				print "<TD><a href=\"/dipl/results/admin_result.php?ID=$data[$i]&" . SID . "\"\">>></a></TD>";
+			 else
+				print "<TD>$data[$i]</TD>\n"; // Name und vorname ausgeben....
+			 $col++;
+			}
+      print "</TR>\n";
+   }
+	print "<tr><td colspan=3 class=text>$nrows Studenten sind derzeit im Praktikum aktiv.<BR></td></tr>";
+	print "</TABLE><BR>";
+}
+
+
+$id = $_GET['ID'];
+
+$sql="select F_NAME, NAME from STUDENTS WHERE STUD_ID='$id'"; // Namen des STUDEnten auswählen, dessen DETaILs angezeigt werden sollen...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+while(OCIFetch($stmt))
+				{
+					$fname = OCIResult($stmt, "F_NAME");
+					$name = OCIResult($stmt, "NAME");
+				}
+
+?>
+
+<br><br>
+</td>
+</tr>
+
+<?
+
+	$sql = "SELECT distinct STUDENTS.F_NAME as VORNAME, STUDENTS.NAME, STUDENTS.GROUPS as GRUPPE, STUDENTS.DATUM as \"zugelassen seit:\", count(ERROR_LOG.STUD_ID) as Versuche from STUDENTS, ERROR_LOG where STUDENTS.STUD_ID not in (select distinct STUD_ID from LOGON) and TYP = 0 and ERROR_LOG.STUD_ID (+) = STUDENTS.STUD_ID group by STUDENTS.STUD_ID, STUDENTS.NAME, STUDENTS.F_NAME, STUDENTS.GROUPS, STUDENTS.DATUM";
+
+	$stmt = dbconnect($sql);
+
+	OCIExecute($stmt);
+
+?>
+
+		<tr>
+		<td bgcolor=#e99900 colspan=2><div class=text>Übersicht über alle Studenten die fürs Praktikum aktiviert sind, jedoch noch keine Aufgabe gelöst haben....</div></td>
+		</tr>
+
+		<tr>
+		<td>
+
+<?
+
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+if ( $nrows > 0 ) 
+	{
+		   print "<BR><TABLE BORDER=\"1\"  class=text>\n";
+		   print "<TR>\n";
+		   while ( list( $key, $val ) = each( $results ) ) 
+			   {
+				print "<TH>$key</TH>\n";
+			   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      
+	  reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) 
+			{
+			 $data = $column['value'];
+			 print "<TD>$data[$i]</TD>\n"; // Name und vorname ausgeben....
+			}
+      print "</TR>\n";
+   }
+	print "<tr><td colspan=3 class=text>$nrows Studenten sind derzeit im Praktikum zugelassen ohne Aufgaben gelöst zu haben...<BR></td></tr>";
+	print "</TABLE><BR>";
+}
+
+?>
+
+<br><br>
+</td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#e99900 colspan=2><div class=text>DETAILS von <b><? print $fname . " " . $name;?></b>:</div></td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#F7F7F7 colspan=2><div class=text><b>Die richtigen Lösungen:</b></div></td>
+</tr>
+
+<tr>
+<td>
+
+<?
+
+$id = $_GET['ID'];
+
+
+$sql="select LO.NR, tmp.STATEMENT from LESSON_ORDER LO join (select L.LESSON_ID, L.STATEMENT from LOGON L where STUD_ID='$id')tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR"; // wähle alle studenten aus, die fertig sind...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+
+if ( $nrows > 0 ) {
+   print "<BR><TABLE BORDER=\"1\" class=text width=560>\n";
+   print "<TR>\n";
+   while ( list( $key, $val ) = each( $results ) ) {
+      print "<TH>$key</TH>\n";
+   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) {   
+         $data = $column['value'];
+         print "<TD>$data[$i]</TD>\n";
+      }
+      print "</TR>\n";
+   }
+  print "</TABLE><BR>";
+} else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind noch keine Aufgaben gelöst worden....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}      
+
+
+
+?> 
+
+</td>
+</tr>
+
+
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#F7F7F7 colspan=2><div class=text><b>Aufgaben, die bisher noch nicht bearbeitet wurden:</b></div></td>
+</tr>
+<tr>
+<td>
+
+<?
+
+
+$sql="select LO.NR from LESSON_ORDER LO join (select LESSON_ID from LESSONS where AKTIV=1 and LESSON_ID not in (select LESSON_ID from ERROR_LOG where STUD_ID='$id' union select LESSON_ID from LOGON where STUD_ID='$id'))tmp on LO.LESSON_ID=tmp.LESSON_ID group by LO.NR"; // wähle alle studenten aus, die fertig sind...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+
+if (isset($_GET['ID']) and $nrows > 0 ) {
+   print "<BR><TABLE BORDER=\"1\" class=text width=560>\n";
+   print "<TR>\n";
+   while ( list( $key, $val ) = each( $results ) ) {
+      print "<TH>$key</TH>\n";
+   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) {   
+         $data = $column['value'];
+         print "<TD>$data[$i]</TD>\n";
+      }
+      print "</TR>\n";
+   }
+  print "</TABLE><BR>";
+} else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind alle Aufgaben schon versucht worden zu lösen....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}      
+
+
+
+?> 
+
+</td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+
+<tr>
+<td bgcolor=#FFDE00 colspan=2><div class=text><b>Lösungsversuche:</b></div></td>
+</tr>
+
+
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#F7F7F7 colspan=2><div class=text><b>Aufgaben, die beim ersten Versuch gelöst wurden:</b></div></td>
+</tr>
+<tr>
+<td>
+
+<?
+
+$sql="select LO.NR from LESSON_ORDER LO join (select distinct LESSON_ID from LOGON where STUD_ID='$id' and LESSON_ID not in (select LESSON_ID FROM ERROR_LOG where STUD_ID='$id'))tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR"; // Versuche pro Aufgabe...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+
+if ( $nrows > 0 ) {
+   print "<br><TABLE BORDER=\"1\" class=text width=560>\n";
+   print "<TR>\n";
+   while ( list( $key, $val ) = each( $results ) ) {
+      print "<TH>$key</TH>\n";
+   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) {   
+         $data = $column['value'];
+         print "<TD>$data[$i]</TD>\n";
+      }
+      print "</TR>\n";
+   }
+   print "</TABLE><BR>";
+} else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind noch keine Aufgaben beim ersten Versuch gelöst worden....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}      
+
+?>
+
+
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#F7F7F7 colspan=2><div class=text><b>Lösungsversuche pro Aufgabe:</b></div></td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td>
+
+<?
+
+$sql="select LO.NR, sum(tmp.versuche) as VERSUCHE from LESSON_ORDER LO join (select LESSON_ID, count(LESSON_ID) as versuche from ERROR_LOG where STUD_ID='$id' group by LESSON_ID union select distinct LESSON_ID, count(LESSON_ID) as versuche from LOGON where STUD_ID='$id' group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID group by LO.NR"; // Versuche pro Aufgabe...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+
+if ( $nrows > 0 ) {
+   print "<TABLE BORDER=\"1\" class=text width=560>\n";
+   print "<TR>\n";
+   while ( list( $key, $val ) = each( $results ) ) {
+      print "<TH>$key</TH>\n";
+   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) {   
+         $data = $column['value'];
+         print "<TD>$data[$i]</TD>\n";
+      }
+      print "</TR>\n";
+   }
+   print "</TABLE><BR>\n";
+} else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind noch keine Aufgaben gelöst worden....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}      
+
+
+
+?>
+
+</td>
+</tr>
+
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#F7F7F7 colspan=2><div class=text><b>Die fehlerhaften Statements nach Aufgabe sortiert:</b></div></td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td>
+
+<?
+
+$sql="select LO.NR, tmp.STATEMENT from LESSON_ORDER LO join (select L.LESSON_ID, L.STATEMENT from ERROR_LOG L where STUD_ID='$id')tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR"; // wähle alle studenten aus, die fertig sind...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+
+if ( $nrows > 0 ) {
+   print "<TABLE BORDER=\"1\" class=text width=560>\n";
+   print "<TR>\n";
+   while ( list( $key, $val ) = each( $results ) ) {
+      print "<TH>$key</TH>\n";
+   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) {   
+         $data = $column['value'];
+         print "<TD>$data[$i]</TD>\n";
+      }
+      print "</TR>\n";
+	  
+   }
+   print "<tr><td colspan=3 class=text>Bisher wurden $nrows Anfragen abgesetzt.<BR></td></tr>";
+   print "</TABLE>\n";
+} else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind noch keine Aufgaben gelöst worden....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}
+
+
+?>
+
+</td>
+</tr>
+
+</table>
+</table>
+</table>
+
+
+<? 
+include("../footer.php");
+?>
+
+
+
diff --git a/doc/nils-diplom/Dateistruktur/results/statistic.php b/doc/nils-diplom/Dateistruktur/results/statistic.php
new file mode 100755
index 0000000..74e0fb8
--- /dev/null
+++ b/doc/nils-diplom/Dateistruktur/results/statistic.php
@@ -0,0 +1,211 @@
+<?php
+	
+	include("../header.php");
+
+	$user = $_SESSION['user'];
+	
+	$sql = "select max(tmp.versuche) from ERROR_LOG join (SELECT LESSON_ID, count(lesson_ID) as VERSUCHE FROM error_log group by LESSon_ID)tmp on tmp.LESSON_ID=ERROR_LOG.LESSON_ID"; // wieviele Aufgabe sind derzeit aktiv
+	
+		$stmt = dbconnect($sql);
+
+		OCIExecute($stmt);
+				
+		$nrows = OCIFetchStatement($stmt,$results);  	
+
+		if ( $nrows == 1 ) 
+			{
+				OCIExecute($stmt);
+
+				while(OCIFetch($stmt))
+				{
+					$max = OCIResult($stmt, $results); // Anzahl der zu lösenden Aufgaben
+				}
+			}
+
+
+	$sql = "select LO.NR, VERSUCHE_insgesamt from LESSON_ORDER LO join (SELECT LESSON_ID, count(lesson_ID) as VERSUCHE_insgesamt FROM error_log group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR";
+
+	$stmt = dbconnect($sql);
+
+	OCIExecute($stmt);
+
+?>
+
+				<tr >
+				<td><div class=titel_15>STATISTIK</div></td>						
+				</tr>
+				<tr>
+				<td><br></td>
+				</tr>
+				<tr>
+				<td bgcolor=#e99900 colspan=2><div class=text><b>Überblick über die Lösungsversuche pro Aufgabe:</b></div></td>
+				</tr>
+				<tr>
+				<td>
+								
+<?
+
+
+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...
+
+if ( $nrows > 0 ) 
+	{
+		   print "<BR><TABLE BORDER=\"1\"  class=text>\n";
+		   print "<TR>\n";
+		   while ( list( $key, $val ) = each( $results ) ) 
+			   {
+				print "<TH>$key</TH>\n";
+			   }
+   print "</TR>\n";
+   
+   for ( $i = 0; $i < $nrows; $i++ ) {
+      $col=0;
+	  reset($results);
+      print "<TR>\n";
+      while ( $column = each($results) ) 
+			{
+			 $data = $column['value'];
+			
+			 if ($col==1)
+				{
+				 $percent = $data[$i] * 100/$max;  //wieviel Prozent der aufgaben hat der Student gelöst 
+
+				 $width = $percent * 400/100; // Darstellung per Balkendiagramm
+				 
+				 if ($percent <= 25) 
+					print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_gruen.gif\" width=$width height=10 > $data[$i] Anfragen</td>"; 
+				 if ($percent > 25 and $percent < 50)
+					print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_orange.gif\" width=$width height=10 > $data[$i] Anfragen</td>";
+				 if ($percent >= 50)
+					print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_rot.gif\" width=$width height=10 > $data[$i] Anfragen</td>";
+				}
+			
+			 else
+				print "<TD>$data[$i]</TD>\n"; 
+			 $col++;
+			}
+      print "</TR>\n";
+   }
+	print "<tr><td colspan=3 class=text>Verteilung der Anzahl Anfragen nach Aufgaben.<BR></td></tr>";
+	print "</TABLE><BR>";
+	}
+
+
+?>
+
+<br><br>
+</td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td bgcolor=#e99900 colspan=2><div class=text><b>durchschnittlich zur Lösung benötigte Zeit in Tagen:</b>:</div></td>
+</tr>
+<tr>
+<td colspan=2><div class=text>&nbsp;</div></td>
+</tr>
+<tr>
+<td>
+
+<?
+
+$sql="select max(schnitt) from LESSON_ORDER LO join (select LESSON_ID, round(sum(time)/count(LESSON_ID),1) as schnitt  from (select LESSON_ID, STUD_ID, max(datum) - min(datum) as time from (select stud_ID, datum, LESSON_ID from ERror_log union select stud_ID, datum, LESSON_ID from Logon) group by (LESSON_ID, STUD_ID)) group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR";
+
+$stmt = dbconnect($sql);
+
+		OCIExecute($stmt);
+				
+		$nrows = OCIFetchStatement($stmt,$results);  	
+
+		if ( $nrows == 1 ) 
+			{
+				OCIExecute($stmt);
+
+				while(OCIFetch($stmt))
+				{
+					$tagmax = OCIResult($stmt, $results); // Anzahl der zu lösenden Aufgaben
+				}
+			}
+
+
+
+
+$sql="select LO.NR, schnitt as \"benötigte Zeit\" from LESSON_ORDER LO join (select LESSON_ID, round(sum(time)/count(LESSON_ID),1) as schnitt  from (select LESSON_ID, STUD_ID, max(datum) - min(datum) as time from (select stud_ID, datum, LESSON_ID from ERror_log union select stud_ID, datum, LESSON_ID from Logon) group by (LESSON_ID, STUD_ID)) group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR";// benötigte Zeit ermitteln...
+
+$stmt = dbconnect($sql);
+
+OCIExecute($stmt);
+
+$nrows = OCIFetchStatement($stmt,$results);
+
+
+if ( $nrows > 0 ) 
+	{
+	   print "<BR><TABLE BORDER=\"1\" class=text width=560>\n";
+	   print "<TR>\n";
+	   while ( list( $key, $val ) = each( $results ) ) 
+			{
+				print "<TH>$key</TH>\n";
+			}
+		   print "</TR>\n";
+		   
+		   for ( $i = 0; $i < $nrows; $i++ ) 
+			   {
+				  $col=0;
+				  reset($results);
+				  print "<TR>\n";
+				  while ( $column = each($results) ) 
+						{
+						 $data = $column['value'];
+						
+						 if ($col==1)
+							{
+							 
+							 $wert = (float)(ereg_replace(",", ".", $data[$i])); // umwandeln in float
+							 $percent = $wert * 100/$tagmax;  //wieviel Prozent der aufgaben hat der Student gelöst 
+
+							 $width = $percent * 4;
+							 							 
+							 if ($percent >= 0 and $percent <= 25) 
+								print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_gruen.gif\" width=$width height=10 > $wert Tage</td>"; 
+							 if ($percent > 25 and $percent < 50)
+								print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_orange.gif\" width=$width height=10 > $wert Tage</td>";
+							 if ($percent >= 50)
+								print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_rot.gif\" width=$width height=10 > $wert Tage</td>";
+							 /*if ($percent == 0) 
+								print "<td width=500>&nbsp;$wert Tage</td>";
+								if ($percent > 0 and $percent < 1) 
+								print "<td width=500>&nbsp;<img src=\"/dipl/css/balken_rot.gif\" width=2 height=10 >$wert Tage</td>";*/
+							 }
+					
+							 else
+								print "<TD>$data[$i]</TD>\n"; // Name und vorname ausgeben....
+							 $col++;
+						}
+					print "</TR>\n";
+				} 
+	}
+else 
+	{
+		if (isset($_GET['ID'])) 
+			{
+				$message = "Es sind noch keine Aufgaben gelöst worden....";
+			}
+
+		print "<tr><td class=text>" . $message . "<BR></tr></td>";
+	}      
+
+?> 
+
+</td>
+</tr>
+
+</table>
+</table>
+</table>
+
+
+<? 
+include("../footer.php");
+?>
\ No newline at end of file
diff --git a/doc/nils-diplom/Dateistruktur/results/user_result.php b/doc/nils-diplom/Dateistruktur/results/user_result.php
new file mode 100755
index 0000000..dc09f63
--- /dev/null
+++ b/doc/nils-diplom/Dateistruktur/results/user_result.php
@@ -0,0 +1,187 @@
+<?php

+

+	include("../header.php");

+

+	$user = $_SESSION['user'];

+

+	//$sql = "SELECT lesson_ID as Aufgabe, Datum, Statement as Lösung FROM logon WHERE STUD_ID = '$user' order by logon.DATUM"; 

+

+	$sql ="SELECT LO.NR as Aufgabe, tmp.DATUM, tmp.STATEMENT FROM LESSON_ORDER LO join (SELECT * FROM LOGON WHERE STUD_ID = '$user') tmp ON tmp.LESSON_ID = LO.LESSON_ID order by LO.NR";

+

+	$stmt = dbconnect($sql);

+

+	OCIExecute($stmt);

+

+?>

+

+

+<tr >

+<td class=titel>persönliche Auswertung von <?echo $_SESSION['fname'] . " " . $_SESSION['name']?></td>

+</tr>

+

+<tr>

+<td><br></td>

+</tr>

+

+<tr>

+<td bgcolor=#e99900 colspan=2 class=text>Ihre bisher erfolgreichen Anfragen waren:</td>

+</tr>

+

+<tr>

+<td>

+				

+

+

+

+<?

+

+

+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...

+

+

+if ( $nrows > 0 ) {

+   print "<BR><TABLE Border=1 class=text>\n";

+   print "<TR>\n";

+   while ( list( $key, $val ) = each( $results ) ) {

+      print "<TH>$key</TH>\n";

+   }

+   print "</TR>\n";

+   

+   for ( $i = 0; $i < $nrows; $i++ ) {

+      reset($results);

+      print "<TR>\n";

+      while ( $column = each($results) ) {   

+         $data = $column['value'];

+         print "<TD>$data[$i]</TD>\n";

+      }

+      print "</TR>\n";

+   }

+   

+		print "<tr><td colspan=3 class=text>$nrows Datensätzen ausgewählt<BR></td></tr>";

+		print "</TABLE><BR>";

+	} 

+

+else 

+	{

+		print "<TABLE BORDER=\"1\">\n";

+		print "<tr><td class=text>Bisher wurden noch keine Aufgaben erfolgreich gelöst...<BR>\n</td></tr>";

+		print "</TABLE><BR>";

+

+	}

+?> 

+<br><br>

+</td>

+</tr>

+

+<tr>

+<td bgcolor=#e99900 colspan=2 class=text>Anfrageversuche waren:</td>

+</tr>

+

+<tr>

+<td>

+

+<?

+

+//$sql = "SELECT lesson_ID as Aufgabe, Datum, Statement as Lösung FROM ERROR_LOG WHERE STUD_ID = '$user' order by ERROR_LOG.DATUM";

+

+$sql = "SELECT LO.NR as Aufgabe, tmp.DATUM, tmp.STATEMENT FROM LESSON_ORDER LO join (SELECT * FROM ERROR_LOG WHERE STUD_ID = '$user') tmp ON tmp.LESSON_ID = LO.LESSON_ID order by LO.NR";

+

+$stmt = dbconnect($sql);

+

+OCIExecute($stmt);

+

+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...

+

+

+if ( $nrows > 0 ) {

+   print "<BR><TABLE BORDER=\"1\" class=text>\n";

+   print "<TR>\n";

+   while ( list( $key, $val ) = each( $results ) ) {

+      print "<TH>$key</TH>\n";

+   }

+   print "</TR>\n";

+   

+   for ( $i = 0; $i < $nrows; $i++ ) {

+      reset($results);

+      print "<TR>\n";

+      while ( $column = each($results) ) {   

+         $data = $column['value'];

+         print "<TD>$data[$i]</TD>\n";

+      }

+      print "</TR>\n";

+   }

+  

+		print "<tr><td colspan=3 class=text>$nrows Datensätzen ausgewählt<BR></td></tr>";

+		print "</TABLE><BR>";

+	} 

+

+else 

+	{

+		print "<TABLE BORDER=\"1\">\n";

+		print "<tr><td class=text>Es wurden keine Daten gefunden...<BR>\n</td></tr>";

+		print "</TABLE><BR>";

+

+	}

+

+?> 

+<br><br>

+</td>

+</tr>

+

+<tr>

+<td bgcolor=#e99900 colspan=2 class=text>Praktikumsdauer:</td>

+</tr>

+

+<tr>

+<td>

+

+<?

+

+$start = $_SESSION['since'];

+

+$sql = "select round(max(datum) - min(datum),2) as \"BENÖTIGTE ZEIT IN TAGEN\" from (select datum from ERror_log where Stud_id = '$user' union select datum from Logon where Stud_id = '$user')";

+

+$stmt = dbconnect($sql);

+

+OCIExecute($stmt);

+

+$nrows = OCIFetchStatement($stmt,$results);		//Ergebnisse in Array eintragen...

+

+

+if ( $nrows > 0 ) {

+   print "<BR><TABLE BORDER=\"1\" class=text>\n";

+   print "<TR>\n";

+   while ( list( $key, $val ) = each( $results ) ) {

+      print "<TH valign=left>$key</TH>\n";

+   }

+   print "</TR>\n";

+   

+   for ( $i = 0; $i < $nrows; $i++ ) {

+      reset($results);

+      print "<TR>\n";

+      while ( $column = each($results) ) {   

+         $data = $column['value'];

+         print "<TD>$data[$i]</TD>\n";

+      }

+      print "</TR>\n";

+   }

+   print "</TABLE>\n";

+} else {

+   echo "No data found<BR>\n";

+}      

+print "$nrows Records Selected<BR>\n";

+

+?> 

+

+</td>

+</tr>

+

+</table>

+</table>

+</table>

+

+

+<? 

+include("../footer.php");

+?>

+