nickpage.php

<?php

$nickpage	= mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_nickpage WHERE uid=".$_SESSION['uid'].""));
$userdaten 	= mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_userdaten WHERE uid=".$_SESSION['uid'].""));
$esc = mysqli_fetch_array(db_query("SELECT bdate FROM ".$db_prefix."_userdaten WHERE uid = '". mysqli_real_escape_string($sql_open,$_SESSION['uid']) ."' "));

if ($_POST['aendern_nickpage']) {		
	if ($nickpage['uid'] != $_SESSION['uid']) {	
		db_query("INSERT ".$db_prefix."_nickpage SET uid = '".$_SESSION['uid']."'");
	}
	$explode = explode(".",$_POST['bdate']);
	$bdate = mktime(0,0,0,$explode[1],$explode[0],$explode[2]);
	db_query("UPDATE ".$db_prefix."_nickpage SET
			sex = '".htmlspecialchars($_POST['sex'])."',
			ort = '".htmlspecialchars($_POST['ort'])."',
			land = '".htmlspecialchars($_POST['land'])."',
			hobbys = '".htmlspecialchars($_POST['hobbys'])."',
			beruf = '".htmlspecialchars($_POST['beruf'])."',
			icq = '".htmlspecialchars($_POST['icq'])."',
			msn = '".htmlspecialchars($_POST['msn'])."',
			aim = '".htmlspecialchars($_POST['aim'])."',
			skype = '".htmlspecialchars($_POST['skype'])."',
			www = '".htmlspecialchars($_POST['www'])."',
			www1 = '".htmlspecialchars($_POST['www1'])."',
			www2 = '".htmlspecialchars($_POST['www2'])."',
			www3 = '".htmlspecialchars($_POST['www3'])."'
			WHERE uid=".$_SESSION['uid']."");
	db_query("UPDATE ".$db_prefix."_userdaten SET bdate = '". mysqli_real_escape_string($sql_open,$bdate) ."' WHERE uid = '". mysqli_real_escape_string($sql_open,$_SESSION['uid']) ."' ");
					
	if ($_POST['ava'] == '') {	
		db_query("UPDATE ".$db_prefix."_nickpage SET ava = '' WHERE uid=".$_SESSION['uid']."");
		
	} else {
		db_query("UPDATE ".$db_prefix."_nickpage SET ava = '".mysqli_real_escape_string($sql_open,$_POST['ava'])."' WHERE uid=".$_SESSION['uid']."");
		
	}
	$meldung = 'Deine Daten wurden aktualisiert!<br>';
	$nickpage	= mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_nickpage WHERE uid=".$_SESSION['uid'].""));
	$esc = mysqli_fetch_array(db_query("SELECT bdate FROM ".$db_prefix."_userdaten WHERE uid = '". mysqli_real_escape_string($sql_open,$_SESSION['uid']) ."' "));
}
?>

<form action="" method="post">
<table cellspacing="3" align="center">	
	<tr>
		<td><strong>Geschlecht: &nbsp;</strong></td>
		<td>
		<select name="sex">
			<option value="" <?php if ($nickpage['sex'] == "") echo 'selected';?>>Bitte w&auml;hlen</option>
			<option value="weiblich" <?php if ($nickpage['sex'] == 'weiblich') echo 'selected';?>>weiblich</option>
			<option value="mnnlich" <?php if ($nickpage['sex'] == 'mnnlich') echo 'selected';?>>m&auml;nnlich</option>
		</select>
		</td>
	</tr>
	<tr>
		<td><b>Geburtsdatum: &nbsp;</b></td>
		<td><input type="date" name="bdate" class="tcal" value="<?php echo date("d.m.Y", $esc['bdate']);?>"></td>
	</tr>
	<tr>
		<td><strong>Wohnort: &nbsp;</strong></td>
		<td>
			<input name="ort" value="<?php echo $nickpage['ort'];?>">
		</td>
	</tr>
	<tr>
		<td><strong>Land: &nbsp;</strong></td>
		<td>
			<input name="land" value="<?php echo $nickpage['land'];?>">
		</td>
	</tr>
	<tr>
		<td><b>Hobbys: &nbsp;</b></td>
		<td><input name="hobbys" value="<?php echo $nickpage['hobbys'];?>"></td>
	</tr>
	<tr>
		<td><b>Beruf: &nbsp;</b></td>
		<td><input name="beruf" value="<?php echo $nickpage['beruf'];?>"></td>
	</tr>
	<tr>
		<td><b>ICQ: &nbsp;</b></td>
		<td><input name="icq" value="<?php echo $nickpage['icq'];?>"></td>
	</tr>
	<tr>
		<td><b>MSN: &nbsp;</b></td>
		<td><input name="msn" value="<?php echo $nickpage['msn'];?>"></td>
	</tr>
	<tr>
		<td><b>AIM: &nbsp;</b></td>
		<td><input name="aim" value="<?php echo $nickpage['aim'];?>"></td>
	</tr>
	<tr>
		<td><b>Skype: &nbsp;</b></td>
		<td><input name="skype" value="<?php echo $nickpage['skype'];?>"></td>
	</tr>
	<tr>
		<td><b>Homepage:</b> (ohne http://)  &nbsp;</td>
		<td><input name="www" value="<?php echo $nickpage['www'];?>"></td>
	</tr>
	<tr>
		<td><b>Lieblingswebsite 1:</b> (ohne http://)  &nbsp;</td>
		<td><input name="www1" value="<?php echo $nickpage['www1'];?>"></td>
	</tr>
	<tr>
		<td><b>Lieblingswebsite 2:</b> (ohne http://)  &nbsp;</td>
		<td><input name="www2" value="<?php echo $nickpage['www2'];?>"></td>
	</tr>
	<tr>
		<td><b>Lieblingswebsite 3:</b> (ohne http://)  &nbsp;</td>
		<td><input name="www3" value="<?php echo $nickpage['www3'];?>"></td>
	</tr>	
  	<tr>
		<td valign="top">
			<strong>Link zu deinem Ava: &nbsp;</strong><br>
			Maximale Bildgre: 200 x 250 Pixel
		</td>
   		<td>
			<? if ($nickpage['ava'] == '') { ?>
			<input name="ava" value="" size="40">						
			<? } else { ?>
			<input name="ava" value="<?php echo $nickpage['ava'];?>" size="40">	
			<? } ?>			
		</td>
	</tr>
	<tr>
		<td height="10" colspan="2"></td>
	</tr>
	<tr>
		<td colspan="2" align="center">
			<img src="<? if ($nickpage['ava'] == '') {echo 'images/noava.gif';} else { echo $nickpage['ava'];}?>" style="max-height:250; max-width:200; border-width:1px;"><br>
			<br>
			<input type="submit" name="aendern_nickpage" value="nderungen speichern">
		</td>
	</tr>		
</table>

<center>
<br>
	<?php echo $meldung;?>
</center>
</form>