| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nginx/html/Scheduler/admin/parse/ |
Upload File : |
<?
// parseProcess_Get_instructorId.phpinc
// Get instructorId.
t_Begin(); // Begin TRACKing parseProcess_Get_instructorId.phpinc.
$query = "
SELECT userId
FROM `userdata`
WHERE INSTRUCTOR = '".query_safe($instructorName)."'
";
d_Var('instructorInfo',$query,'q');
$instructorInfo = query_info($query);
d_Var('$instructorInfo',$instructorInfo);
if ( $instructorInfo ) { // Is this instructor in the database?
$instructorId = $instructorInfo['userId'];
} else { // Is this instructor in the database?
// INSERT instructor into user table.
$query = "
INSERT INTO `user` (
userFirstname
, userLastname
, AddedOn
, AddedBy
) VALUES (
'".query_safe($instructorFirstname)."'
, '".query_safe($instructorLastname)."'
, '".currentDateTime()."'
, ".$_SESSION['user']['trueId']."
)
";
d_Var('instructorINSERT',$query,'q');
$instructorINSERT = query_do($query);
d_Var('$instructorINSERT',$instructorINSERT,'l');
$instructorId = $GLOBALS['_QUERY']['insertId'];
d_Var('$instructorId',$instructorId,'l');
?>
<article style="color:darkorchid;">New <?=$instructorLastname?>, <?=$instructorFirstname?> instructor found on line <?=$thisClass['!line']?>.</article>
<?
// INSERT instructorName into userdata table.
$query = "
INSERT INTO `userdata` (
userId
, INSTRUCTOR
) VALUES (
".$instructorId."
, '".query_safe($instructorName)."'
)
";
d_Var('userdataINSERT',$query,'q');
$userdataINSERT = query_do($query);
d_Var('$userdataINSERT',$userdataINSERT,'l');
// BEGIN INSERT instructor into user_userpermission table with Instructor permission.
if ( !isset($userpermissionId) ) {
// Get $userpermissionId.
$query = "
SELECT userpermissionId
FROM `userpermission`
WHERE userpermissionName = '".query_safe('Instructor')."'
";
d_Var('userpermissionInfo',$query,'q');
$userpermissionInfo = query_info($query);
d_Var('$userpermissionInfo',$userpermissionInfo);
if ( $userpermissionInfo ) {
$userpermissionId = $userpermissionInfo['userpermissionId'];
} else {
$userpermissionId = NULL;
}
}
if ( $userpermissionId ) {
// INSERT instructor into user_userpermission table with Instructor permission.
$query = "
INSERT INTO `user_userpermission` (
userId
, userpermissionId
) VALUES (
".$instructorId."
, ".$userpermissionId."
)
";
d_Var('user_userpermissionINSERT',$query,'q');
$user_userpermissionINSERT = query_do($query);
d_Var('$user_userpermissionINSERT',$user_userpermissionINSERT,'l');
}
// END INSERT instructor into user_userpermission table with Instructor permission.
} // Is this instructor in the database?
d_Var('$instructorId',$instructorId,'');
t_End(); // End TRACKing parseProcess_Get_instructorId.phpinc.
?>