All pastes #551077 Raw Edit

Stuff

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