summaryrefslogtreecommitdiff
path: root/www-ssl
diff options
context:
space:
mode:
Diffstat (limited to 'www-ssl')
-rwxr-xr-xwww-ssl/admin/Recentchanges.php22
-rwxr-xr-xwww-ssl/inc/funktion_user.php46
2 files changed, 37 insertions, 31 deletions
diff --git a/www-ssl/admin/Recentchanges.php b/www-ssl/admin/Recentchanges.php
index 564c9e96..b6cb5a9f 100755
--- a/www-ssl/admin/Recentchanges.php
+++ b/www-ssl/admin/Recentchanges.php
@@ -3,9 +3,27 @@
$title = "ChangeLog";
$header = "Datenbank-Auszug";
include ("./inc/header.php");
-include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.php");
-funktion_db_list("ChangeLog");
+$SQL = "SELECT * FROM `ChangeLog` ORDER BY `Time` DESC LIMIT 0,10000";
+$Erg = mysql_query($SQL, $con);
+
+echo mysql_error($con);
+
+echo "<table border=1>\n";
+echo "<tr>\n\t<th>Time</th>\n\t<th>User</th>\n\t<th>Commend</th>\n\t<th>SQL Commad</th>\n</tr>\n";
+
+for ($n = 0 ; $n < mysql_num_rows($Erg) ; $n++)
+{
+ echo "<tr>\n";
+ echo "\t<td>". mysql_result( $Erg, $n, "Time"). "</td>\n";
+ echo "\t<td>". UID2Nick(mysql_result( $Erg, $n, "UID")). displayavatar(mysql_result( $Erg, $n, "UID")). "</td>\n";
+ echo "\t<td>". mysql_result( $Erg, $n, "Commend"). "</td>\n";
+ echo "\t<td>". mysql_result( $Erg, $n, "SQLCommad"). "</td>\n";
+ echo "</tr>\n";
+}
+
+echo "</table>\n";
include ("./inc/footer.php");
?>
diff --git a/www-ssl/inc/funktion_user.php b/www-ssl/inc/funktion_user.php
index f679245d..c98598f8 100755
--- a/www-ssl/inc/funktion_user.php
+++ b/www-ssl/inc/funktion_user.php
@@ -1,7 +1,8 @@
<?php
-function UID2Nick($UID) {
- include ("./inc/db.php");
+function UID2Nick($UID)
+{
+ global $con;
$SQL = "SELECT Nick FROM `User` WHERE UID='$UID'";
$Erg = mysql_query($SQL, $con);
@@ -19,8 +20,9 @@ function UID2Nick($UID) {
}
-function TID2Type($TID) {
- include ("./inc/db.php");
+function TID2Type($TID)
+{
+ global $con;
$SQL = "SELECT Name FROM `EngelType` WHERE TID='$TID'";
$Erg = mysql_query($SQL, $con);
@@ -55,32 +57,20 @@ function ReplaceSmilies($eckig) {
return $neueckig;
}
-function displayavatar($dumdidum) {
- include ("./inc/db.php");
- global $displayavatar;
+function displayavatar($UID)
+{
+ global $con;
- $asql = "select * from User where UID = $dumdidum";
- $aerg = mysql_query ($asql, $con);
- if (($displayavatar<>0) && (mysql_num_rows($Erg)) )
- return ("&nbsp;<img src=\"./inc/avatar/avatar". mysql_result($aerg, 0, "Avatar"). ".gif\">");
+ $asql = "select * from User where UID = $UID";
+ $aerg = mysql_query ($asql, $con);
+ if( mysql_num_rows($aerg) )
+ if( mysql_result($aerg, 0, "Avatar") > 0)
+ return ("&nbsp;<img src=\"./inc/avatar/avatar". mysql_result($aerg, 0, "Avatar"). ".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);
-}
-
-function UIDgekommen($UID) {
- include ("./inc/db.php");
+function UIDgekommen($UID)
+{
+ global $con;
$SQL = "SELECT `Gekommen` FROM `User` WHERE UID='$UID'";
$Erg = mysql_query($SQL, $con);
@@ -92,6 +82,4 @@ function UIDgekommen($UID) {
return "0";
}
-
-
?>