Datenbankabfrage ob username existiert

Code: Alles auswählen

$username = stripslashes(strtoupper($_GET["u"]));

Code: Alles auswählen

$username = stripslashes(strtoupper($_GET["u"]));
$query = mysql_query("SELECT memberName,avatar,posts FROM smf_members WHERE memberName = '".mysql_real_escape_string($_GET["u"])."' LIMIT 1") or die (mysql_error());
if ((!$query) or (mysql_num_rows($query) == 0)) { 
  	mysql_free_result($query);
	exit;
}
$row = mysql_fetch_array($query);
mysql_free_result($query);

$zeit = date("H:i:s", time()); 
$datum = date("d.m.Y", time()); 
$ip = $_SERVER["REMOTE_ADDR"]; 
$posts = $row["posts"];

$pic = imagecreatefromgif("banner/banner.gif");

if (!($row["avatar"] == NULL)) {
$avatarpic = ImageCreateFromJPEG($row["avatar"]);
Imagecopy($pic, $avatarpic, 0, 0, 0, 0, 90, 60);
}
$weiss = ImageColorAllocate($pic, 255, 255, 255); 
$schwarz = ImageColorAllocate($pic, 0, 0, 0); 
$weinrot = ImageColorAllocate($pic, 99, 0, 0);

Imagestring($pic, 5, 100, 1, $username, $weinrot);
ImageString($pic, 2, 100, 25, "Beiträge: ".$posts, $schwarz);
ImageString($pic, 4, 300, 1, "Uhrzeit: ".$zeit, $schwarz); 
ImageString($pic, 4, 300, 15, "Datum: ".$datum, $schwarz); 
Imagestring($pic, 4, 300, 30, "Deine IP: ".$ip, $schwarz); 
 

ImagePNG($pic); 
ImageDestroy($pic);
ImageDestroy($avatarpic);