diff options
Diffstat (limited to 'www-ssl')
-rwxr-xr-x | www-ssl/admin/Recentchanges.php | 22 | ||||
-rwxr-xr-x | www-ssl/inc/funktion_user.php | 46 |
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 (" <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 (" <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"; } - - ?> |