function AddSite($sitename, $siteaddress, $sitecontact)
{
/* perform data checks */
$sitename = mysql_real_escape_string($sitename);
$siteaddress = mysql_real_escape_string($siteaddress);
$sitecontact = mysql_real_escape_string($sitecontact);
$siteuid = NIDB\CreateUID('T', 4);
/* insert the new site */
$sqlstring = "insert into nidb_sites (site_uid, site_uuid, site_name, site_address, site_contact) values ('{$siteuid}', uuid(), '{$sitename}', '{$siteaddress}', '{$sitecontact}')";
$result = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>{$sqlstring}</i><br>");
?>
<div align="center"><span class="message"><?php
echo $sitename;
?>
added</span></div><br><br><?php
}
function AddSubject($lastname, $firstname, $dob, $gender, $ethnicity1, $ethnicity2, $handedness, $education, $phone, $email, $maritalstatus, $smokingstatus, $cancontact, $altuid, $guid) {
if ($GLOBALS['debug']) {
print "$fullname, $dob, $gender, $ethnicity1, $ethnicity2, $handedness, $education, $phone, $email, $maritalstatus, $smokingstatus, $cancontact, $altuid, $guid";
}
/* perform data checks */
$name = mysql_real_escape_string("$lastname^$firstname");
$dob = mysql_real_escape_string($dob);
$gender = mysql_real_escape_string($gender);
$ethnicity1 = mysql_real_escape_string($ethnicity1);
$ethnicity2 = mysql_real_escape_string($ethnicity2);
$handedness = mysql_real_escape_string($handedness);
$education = mysql_real_escape_string($education);
$phone = mysql_real_escape_string($phone);
$email = mysql_real_escape_string($email);
$maritalstatus = mysql_real_escape_string($maritalstatus);
$smokingstatus = mysql_real_escape_string($smokingstatus);
$cancontact = mysql_real_escape_string($cancontact);
$altuid = mysql_real_escape_string($altuid);
$guid = mysql_real_escape_string($guid);
$altuids = explode(',',$altuid);
# create a new uid
do {
$uid = NIDB\CreateUID('S',3);
$sqlstring = "SELECT * FROM `subjects` WHERE uid = '$uid'";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$count = mysql_num_rows($result);
} while ($count > 0);
# create a new family uid
do {
$familyuid = NIDB\CreateUID('F');
$sqlstring = "SELECT * FROM `families` WHERE family_uid = '$familyuid'";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$count = mysql_num_rows($result);
} while ($count > 0);
/* insert the new subject */
$sqlstring = "insert into subjects (name, birthdate, gender, ethnicity1, ethnicity2, handedness, education, phone1, email, marital_status, smoking_status, uid, uuid, guid, cancontact) values ('$name', '$dob', '$gender', '$ethnicity1', '$ethnicity2', '$handedness', '$education', '$phone', '$email', '$maritalstatus', '$smokingstatus', '$uid', ucase(md5(concat(RemoveNonAlphaNumericChars('$name'), RemoveNonAlphaNumericChars('$dob'),RemoveNonAlphaNumericChars('$gender')))), '$guid', '$cancontact')";
if ($GLOBALS['debug']) { PrintSQL($sqlstring); }
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$dbid = mysql_insert_id();
# create familyRowID if it doesn't exist
$sqlstring2 = "insert into families (family_uid, family_createdate, family_name) values ('$familyuid', now(), 'Proband-$uid')";
if ($GLOBALS['debug']) { PrintSQL($sqlstring2); }
$result2 = MySQLQuery($sqlstring2,__FILE__,__LINE__);
$familyRowID = mysql_insert_id();
$sqlstring3 = "insert into family_members (family_id, subject_id, fm_createdate) values ($familyRowID, $dbid, now())";
if ($GLOBALS['debug']) { PrintSQL($sqlstring3); }
$result3 = MySQLQuery($sqlstring3,__FILE__,__LINE__);
//$sqlstring = "select uid from subjects where subject_id = $dbid";
//$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
//$row = mysql_fetch_array($result, MYSQL_ASSOC);
//$uid = $row['uid'];
foreach ($altuids as $altuid) {
$altuid = trim($altuid);
$sqlstring = "insert ignore into subject_altuid (subject_id, altuid) values ($dbid, '$altuid')";
if ($GLOBALS['debug']) { PrintSQL($sqlstring); }
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
}
?><div align="center"><span style="background-color: darkred; color: white"><?php
echo $subjectname;
?>
added <span class="uid"><?php
echo FormatUID($uid);
?>
</span></span></div><br><br><?
}
function AddPrefs($prefsname)
{
/* perform data checks */
$instancename = mysql_real_escape_string($instancename);
# create a new instance uid
do {
$instanceuid = NIDB\CreateUID('I');
$sqlstring = "SELECT * FROM `instance` WHERE instance_uid = '{$instanceuid}'";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$count = mysql_num_rows($result);
} while ($count > 0);
$sqlstring = "select user_id from users where username = '******'username'] . "'";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$ownerid = $row['user_id'];
/* insert the new instance */
$sqlstring = "insert into instance (instance_uid, instance_name, instance_ownerid) values ('{$instanceuid}', '{$instancename}', '{$ownerid}')";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
?>
<div align="center"><span class="message"><?php
echo $instancename;
?>
added</span></div><?php
}
function AddProject($projectname, $admin, $pi, $instanceid, $sharing, $costcenter, $startdate, $enddate, $datausers, $phiusers) {
/* perform data checks */
$projectname = mysql_real_escape_string($projectname);
$admin = mysql_real_escape_string($admin);
$pi = mysql_real_escape_string($pi);
$sharing = mysql_real_escape_string($sharing);
$costcenter = mysql_real_escape_string($costcenter);
$startdate = mysql_real_escape_string($startdate);
$enddate = mysql_real_escape_string($enddate);
$projectuid = NIDB\CreateUID('P',4);
/* insert the new project */
$sqlstring = "insert into projects (project_uid, project_name, project_admin, project_pi, instance_id, project_sharing, project_costcenter, project_startdate, project_enddate, project_status) values ('$projectuid', '$projectname', '$admin', '$pi', '$instanceid', '$sharing', '$costcenter', '$startdate', '$enddate', 'active')";
$result = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>$sqlstring</i><br>");
?><div align="center"><span class="message"><?php
echo $projectname;
?>
added</span></div><br><br><?
}
