rendered paste body<img src="img/edyp.gif" alt="Edit profile" />
<?php
$do = $_GET['do'];
$db->Query("SELECT * FROM gr_users WHERE user_id='".$_SESSION['user_id']."'","userinfo");
$userinfo = mysql_fetch_assoc($db->res['userinfo']);
if ($do == 11)
{
$firstname = mysql_real_escape_string($_POST['firstname']);
$lastname = mysql_real_escape_string($_POST['lastname']);
$homepage = mysql_real_escape_string($_POST['homepage']);
$msn = mysql_real_escape_string($_POST['msn']);
$yahoo = mysql_real_escape_string($_POST['yahoo']);
$aim = mysql_real_escape_string($_POST['aim']);
$age = mysql_real_escape_string($_POST['age']);
$location = mysql_real_escape_string($_POST['location']);
$email = mysql_real_escape_string($_POST['email']);
// $avatarpath = mysql_real_escape_string($_POST['avatarpath']);
$profile_text = mysql_real_escape_string($_POST['profile_text']);
$hw_connection = mysql_real_escape_string($_POST['hw_connection']);
$hw_os = mysql_real_escape_string($_POST['hw_os']);
$hw_monitor = mysql_real_escape_string($_POST['hw_monitor']);
$hw_graphics_card = mysql_real_escape_string($_POST['hw_graphics_card']);
$hw_motherboard = mysql_real_escape_string($_POST['hw_motherboard']);
$hw_cpu = mysql_real_escape_string($_POST['hw_cpu']);
$hw_memory = mysql_real_escape_string($_POST['hw_memory']);
$hw_soundcard = mysql_real_escape_string($_POST['hw_soundcard']);
$hw_storage = mysql_real_escape_string($_POST['hw_storage']);
$db->Query("UPDATE gr_users SET firstname='$firstname',lastname='$lastname',homepage='$homepage',msn='$msn',yahoo='$yahoo',
aim='$aim',age='$age',location='$location',email='$email',profile_text='$profile_text',hw_connection='$hw_connection',
hw_os='$hw_os',hw_monitor='$hw_monitor',hw_graphics_card='$hw_graphics_card',hw_motherboard='$hw_motherboard',hw_cpu='$hw_cpu',
hw_memory='$hw_memory',hw_soundcard='$hw_soundcard',hw_storage='$hw_storage' WHERE user_id='".$_SESSION['user_id']."'");
echo "<p style=\"font-size: 12px;\"><br /><b>Your profile is now updated.</b></p><br />\n";
print_r($_POST);
}
?>
<img src="img/roster_personalinfo.gif" alt="Personal information" />
<form action="index.php?module=profile&do=11" method="post">
<table width="553">
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Firstname</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="firstname" value="<?php echo $userinfo['firstname']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Lastname</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="lastname" value="<?php echo $userinfo['lastname']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Homepage</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="homepage" value="<?php echo $userinfo['homepage']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Email</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="email" value="<?php echo $userinfo['email']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Age</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="age" value="<?php echo $userinfo['age']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Location</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="location" value="<?php echo $userinfo['location']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">MSN</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="msn" value="<?php echo $userinfo['msn']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Yahoo</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="yahoo" value="<?php echo $userinfo['yahoo']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">AIM</td>
<td class="forumbackground_desc" align="right"><input type="text" style="border: 1px solid #e9e9e9" name="aim" value="<?php echo $userinfo['aim']; ?>" /></td>
</tr>
<tr>
<td colspan="2"><img src="img/phardware.gif" alt="Hardware" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Line connection</td>
<td align="right"><input type="text" name="hw_connection" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_connection']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Operating system</td>
<td align="right"><input type="text" name="hw_os" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_os']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Monitor</td>
<td align="right"><input type="text" name="hw_monitor" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_monitor']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Graphics card</td>
<td align="right"><input type="text" name="hw_graphics_card" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_graphics_card']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Motherboard</td>
<td align="right"><input type="text" name="hw_motherboard" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_motherboard']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">CPU</td>
<td align="right"><input type="text" name="hw_cpu" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_cpu']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">RAM/Memory</td>
<td align="right"><input type="text" name="hw_memory" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_memory']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Soundcard</td>
<td align="right"><input type="text" name="hw_soundcard" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_soundcard']; ?>" /></td>
</tr>
<tr>
<td style="font-size: 12px; font-family: Verdana, sans">Storage</td>
<td align="right"><input type="text" name="hw_storage" style="border: 1px solid #e9e9e9" value="<?php echo $userinfo['hw_storage']; ?>" /></td>
</tr>
<tr>
<td colspan="2"><b style="font-size: 12px; font-family: Verdana, sans">Profile text<br /></b><textarea name="profile_text" style="border: 1px solid #e9e9e9; width: 543px; height: 200px"><?=$userinfo['profile_text'];?></textarea></td>
</tr>
<tr>
<td> </td>
<td align="right"><input type="submit" style="border: 1px solid #e9e9e9" value="Save profile" /></td>
</tr>
</table>
</form>