1 files changed, 83 insertions, 0 deletions
diff --git a/inc/funktion_user.php b/inc/funktion_user.php
new file mode 100755
index 00000000..a420a09a
--- /dev/null
+++ b/inc/funktion_user.php
@@ -0,0 +1,83 @@
+<?php
+
+function UID2Nick($UID) {
+  include ("./inc/db.php");
+  
+  $SQL = "SELECT Nick FROM `User` WHERE UID='$UID'";
+  $Erg = mysql_query($SQL, $con);
+
+  //echo $UID."#";
+  return mysql_result($Erg, 0);
+}
+
+
+function TID2Type($TID) {
+  include ("./inc/db.php");
+  
+  $SQL = "SELECT Name FROM `EngelType` WHERE TID='$TID'";
+  $Erg = mysql_query($SQL, $con);
+
+  return mysql_result($Erg, 0);
+}
+
+
+function htmlescape($eckig) {
+
+	$neueckig = $eckig;
+	$neueckig = str_replace("&","&amp;",$neueckig);
+	$neueckig = str_replace("<","&lt;",$neueckig); 
+	$neueckig = str_replace(">","&gt;",$neueckig);
+
+	// replace smilies
+	
+	$neueckig = str_replace(";o))","<img src=\"./inc/smiles/icon_redface.gif\">",$neueckig);
+	$neueckig = str_replace(":-))","<img src=\"./inc/smiles/icon_redface.gif\">",$neueckig);
+	$neueckig = str_replace(";o)","<img src=\"./inc/smiles/icon_wind.gif\">",$neueckig);
+	$neueckig = str_replace(":)","<img src=\"./inc/smiles/icon_smile.gif\">",$neueckig);
+        $neueckig = str_replace(":-)","<img src=\"./inc/smiles/icon_smile.gif\">",$neueckig);
+	$neueckig = str_replace(":(","<img src=\"./inc/smiles/icon_sad.gif\">",$neueckig);
+        $neueckig = str_replace(":-(","<img src=\"./inc/smiles/icon_sad.gif\">",$neueckig);
+	$neueckig = str_replace(":o(","<img src=\"./inc/smiles/icon_sad.gif\">",$neueckig);
+	$neueckig = str_replace(":o)","<img src=\"./inc/smiles/icon_lol.gif\">",$neueckig);
+	$neueckig = str_replace(";o(","<img src=\"./inc/smiles/icon_cry.gif\">",$neueckig);
+	$neueckig = str_replace(";(","<img src=\"./inc/smiles/icon_cry.gif\">",$neueckig);
+        $neueckig = str_replace(";-(","<img src=\"./inc/smiles/icon_cry.gif\">",$neueckig);
+        $neueckig = str_replace("8)","<img src=\"./inc/smiles/icon_rolleyes.gif\">",$neueckig);
+	$neueckig = str_replace("8o)","<img src=\"./inc/smiles/icon_rolleyes.gif\">",$neueckig);
+	$neueckig = str_replace(":P","<img src=\"./inc/smiles/icon_evil.gif\">",$neueckig);
+	$neueckig = str_replace(":-P","<img src=\"./inc/smiles/icon_evil.gif\">",$neueckig);
+	$neueckig = str_replace(":oP","<img src=\"./inc/smiles/icon_evil.gif\">",$neueckig);
+	$neueckig = str_replace(";P","<img src=\"./inc/smiles/icon_mad.gif\">",$neueckig);
+	$neueckig = str_replace(";oP","<img src=\"./inc/smiles/icon_mad.gif\">",$neueckig);
+	$neueckig = str_replace("?)","<img src=\"./inc/smiles/icon_question.gif\">",$neueckig);
+	return $neueckig;
+}
+
+function displayavatar($dumdidum) {
+include ("./inc/db.php");
+        
+       $asql = "select * from User where UID = $dumdidum";
+       $aerg = mysql_query ($asql, $con);
+       $displayavatar= mysql_result($aerg, 0, "Avatar");
+       if ($displayavatar<>0){
+            return ("&nbsp;<img src=\"./inc/avatar/avatar$displayavatar.gif\">");
+       }
+
+}
+
+function Ausgabe_Feld($RID) {
+// gibt, nach übergabe der der SchichtID (SID) und der RaumID (RID),
+// die eingetragenden und und offenden Schichteintäge zurück
+ 	include ("./inc/db.php");
+    	include ("./inc/config.php");
+//echo "####################", $Erg, "####################<br>";
+	
+        $SQL2 = "SELECT * FROM `Raeume` ";
+	if ($RID != "") {
+		$SQL2.= "WHERE (RID = '".$RID."')";
+	}
+	return mysql_query($SQL2, $con);
+}
+
+
+?>