All pastes #551074 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-06-08 17:17 UTC
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);