';
$_SESSION['username'] = $login;
$_SESSION['user_info'] = $info;
//** store & update login info into msopuser table **//
$link = link_cm();
$sql = 'select * from msopuser where msopuser = "' . $info[0]['uid'][0] . '"';
//print $sql;
$res = mysql_query($sql, $link);
if (mysql_num_rows($res)!='0'){ // if the user is already registered update their info
$q = 'update msopuser set ';
}else{
$q = 'insert into msopuser set ';
$q .= 'msopuser = "' . $info[0]['uid'][0] . '", ';
}
$q .= 'emp_id = "' . $info[0]['jplbadgenumber'][0] . '"';
$q .= ',full_name = "' . $info[0]['cn'][0] . '"';
$q .= ',email = "' . $info[0]['mail'][0] . '"';
$q .= ',phone = "' . $info[0]['jplphonenumber'][0] . '"';
$q .= ',mail_stop = "' . $info[0]['jplmailstop'][0] . '"';
$q .= ',location = "' . $info[0]['jpllocation'][0] . '"';
$q .= ',user_type = "' . $info[0]['employeetype'][0] . '"';
$q .= ',first_name = "' . $info[0]['givenname'][0] . '"';
$q .= ',last_name = "' . $info[0]['sn'][0] . '"';
$q .= ',mi = "' . $info[0]['jplmiddleinitial'][0] . '"';
$q .= ',section = "' . $info[0]['departmentnumber'][0] . '"';
$q .= ',modified="' . date("Y-m-d") . '"';
if (mysql_num_rows($res)!='0') {
$q .= ' where msopuser = "' . $info[0]['uid'][0] . '"';
}
//print "
$q ";
$result = mysql_query($q,$link);
echo '';
}else{
print $msg . '
';
}
}
?>