Also ich habe da leider nix mit ASC od. DESC gefunden.
Hier mal der Code zum angucken:
<?php
include('mainfile.php');
include('header.php');
require_once("includes/sql_layer.php");
global $user, $cookie, $text, $prefix, $touser;
cookiedecode($user);
$username = $cookie[1];
if ($username == "") {
$username = "Anonymous";
}
$nutzersql = mysql_query("select * from $prefix"._users." where uname='$username'");
$eintrager=mysql_fetch_array($nutzersql);
$eemail = $eintrager["femail"];
$eurl = $eintrager["url"];
if($op=='signin')
{
opentable();
echo "<center><b>"._GBDABEI." $touser "._GBINPUT."</b></center>";
echo "<br>";
echo"<center>"._GBCAREFULL."</center>";
closetable();
echo "<br><br>";
opentable();
echo "<form action=guestbook.php?op=add&touser=$touser method=post>";
echo "<table width=\"50%\"><tr><td><b>"._GBYOURNAME."</b></td><td>$username</td></tr>\n"
."<tr><td><b>"._GBYOUREMAIL."</b></td><td>$eemail</td></tr>\n"
."<tr><td><b>"._GBYOURURL."</b></td><td>$eurl</td></tr>\n"
."<tr><td><b>"._GBYOURENTRY."</b></td><td><textarea name=\"text\" cols=\"41\" rows=\"10\"></textarea></td></tr>\n"
."<tr><td align=\"right\"><input type=\"reset\" NAME=\"reset\" value=\""._RESET."\"></td><td align=\"left\"><input type=submit value=\""._SEND."\"></td></tr></table>\n"
."</form>";
closetable();
}
if($op=='add')
{
$edate = date("Y-m-d");
$eintrag_sql = mysql_query("insert into $prefix"._userguest." (touser, text, wann, wer, email, url) VALUES ('$touser','$text','$edate','$username','$eemail','$eurl') ");;
opentable();
echo "<br><br><center><b>"._GBTHX."</b><br><a href=guestbook.php?touser=".$touser.">"._GBBACK." $touser</a>";
closetable();
}
Function delmessage(){
Global $gid, $prefix, $touser, $dbi, $op, $intro;
sql_query("DELETE FROM $prefix"._userguest." WHERE gid='$gid'", $dbi);
opentable();
print "<br><center>"._USERGB_DELETEMESSG2."<br><a href=guestbook.php?touser=".$touser.">"._INPUTHERE." $touser</a></center>";
closetable();
}
if($op=='')
{
$lesen_sql=mysql_query("select * from $prefix"._userguest." where touser='$touser'");
$ezahl = mysql_num_rows($lesen_sql);
opentable();
print("<center><b>"._GBFROM." ".$touser."</b></center>");
print("<br><center>"._GBREGUSER."</center><br>");
print("<br><center>"._GBNOW." ".$ezahl." "._GBEXIST."<br>");
if($user) print("<a href=guestbook.php?op=signin&touser=$touser><br>"._INPUTHERE."</a><br></center>");
closetable();
echo "<br><br>";
print("<table width='100%'border=0>");
for($i=1;$i<=$ezahl;$i++)
{
$eintrag=mysql_fetch_array($lesen_sql);
$euid=$eintrag["wer"];
$usersql=mysql_query("select user_avatar from $prefix"._users." where uname='$euid'");
$uavatar=mysql_fetch_array($usersql);
$avatar=$uavatar["user_avatar"];
print("<tr>");
print("<td BGCOLOR='$bgcolor3' width='30%'>");
print(""._INPUTDATE." ".$eintrag["wann"]."<br>");
print(""._INPUTNAME." ".$eintrag["wer"]."<br><br>");
print("<img src=images/forum/avatar/".$avatar." border=0><br><br>");
print("<img src=modules/Guestbook/images/mail.gif border=0> <a href=mailto:".$eintrag["email"].">".$eintrag["email"]."</a><br>");
print("<img src=modules/Guestbook/images/url.gif border=0> <a href=".$eintrag["url"].">".$eintrag["url"]."</a><br>");
print("<img src=modules/Guestbook/images/phpnuke.gif border=0> <a href=modules.php?name=Your_Account&op=userinfo&uname=".$eintrag["wer"].">Infos über ".$eintrag["wer"]."</a><br><br><br>");
Global $gid, $eintrag, $touser, $prefix, $cookie;
$result = mysql_query("select * from $prefix"._userguest." where touser='$touser'");
$querydel=mysql_fetch_array($result);
if ($querydel["touser"] == $cookie["1"]){
print("<br><a href=\"guestbook.php?op=del&touser=$touser&gid=".$eintrag["gid"]."\">"._USERGB_DELMESSAGE."<br>ID ".$eintrag["gid"]."</a>");
}
print("</td>");
print("<td BGCOLOR='$bgcolor1' width='70%'>".$eintrag["text"]."</td>");
print("</tr>");
}
print("</table>");
}
switch($op) {
case "del":
delmessage($gid);
break;
}
include('footer.php');
?>
pragmaMx Support Forum
