rendered paste body#
$sql = "UPDATE s_roster SET
#
#
nickname=" . $sdb->quote_smart($_POST['nickname']) .",
#
{$sql}
#
name=" . $sdb->quote_smart($_POST['name']) .",
#
origin=" . intval($_POST['origin']) .",
#
location=" . $sdb->quote_smart($_POST['location']) .",
#
birth_date='" . $birth_date ."',
#
sex='" . ( ($_POST['sex'] == 'male') ? 'm' : 'f' ) ."',
#
website=" . $sdb->quote_smart($_POST['website']) .",
#
email=" . $sdb->quote_smart($_POST['email']) .",
#
msn=" . $sdb->quote_smart($_POST['msn']) .",
#
mouse=" . $sdb->quote_smart($_POST['mouse']) .",
#
storage=" . $sdb->quote_smart($_POST['storage']) .",
#
headphones=" . $sdb->quote_smart($_POST['headphones']) .",
#
monitor=" . $sdb->quote_smart($_POST['monitor']) .",
#
cpu=" . $sdb->quote_smart($_POST['cpu']) .",
#
memory=" . $sdb->quote_smart($_POST['memory']) .",
#
graphic_card=" . $sdb->quote_smart($_POST['graphic_card']) .",
#
soundcard=" . $sdb->quote_smart($_POST['soundcard']) .",
#
motherboard=" . $sdb->quote_smart($_POST['motherboard']) .",
#
connection=" . $sdb->quote_smart($_POST['connection']) .",
#
about=" . $sdb->quote_smart($_POST['about'])." WHERE user_id=". intval($userdata['user_id']);
#
$sdb->get_query($sql);