| 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/siteneed/ |
Upload File : |
<?
// admin/siteneed/siteneed_FormProcess.phpinc
// Process the siteneed form.
t_Begin();
if ( $f['uuid'] != $_SESSION['uuid'] ) {
// Not a page reload.
if ( $f['siteneedId'] ) {
// UPDATE siteneed.
$query = "
UPDATE `siteneed`
SET siteneedName = '".query_safe($f['siteneedName'])."'
, siteneedText = '".query_safe($f['siteneedText'])."'
, siteneedFix = '".query_safe($f['siteneedFix'])."'
, siteneedstatusId = ".$f['siteneedstatusId']."
, siteneedActive = ".$f['siteneedActive']."
, siteneedDone = ".$f['siteneedDone']."
, ModifiedOn = '".currentDateTime()."'
, ModifiedBy = ".$_SESSION['user']['trueId']."
WHERE siteneedId = ".$f['siteneedId']."
";
d_Var('siteneedUPDATE',$query,'q');
$siteneedUPDATE = query_do($query);
d_Var('$siteneedUPDATE',$siteneedUPDATE,'l');
displayMessage('Siteneed '.$f['siteneedName'].' updated.');
} else {
if (!$f['AddedOn']) {
$f['AddedOn'] = currentDateTime();
}
// INSERT siteneed.
$query = "
INSERT INTO `siteneed` (
siteneedName
, siteneedText
, siteneedFix
, siteneedstatusId
, siteneedActive
, siteneedDone
, AddedOn
, AddedBy
) VALUES (
'".query_safe($f['siteneedName'])."'
, '".query_safe($f['siteneedText'])."'
, '".query_safe($f['siteneedFix'])."'
, ".$f['siteneedstatusId']."
, ".$f['siteneedActive']."
, ".$f['siteneedDone']."
, '".$f['AddedOn']."'
, ".$_SESSION['user']['trueId']."
)
";
d_Var('siteneedINSERT',$query,'q');
$siteneedINSERT = query_do($query);
d_Var('$siteneedINSERT',$siteneedINSERT,'l');
$f['siteneedId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var("\$f['siteneedId']",$f['siteneedId']);
displayMessage('Siteneed '.$f['siteneedName'].' added.');
}
// Remember that the form was processed.
$_SESSION['uuid'] = $f['uuid'];
} else {
// Page was reloaded.
displayMessage('Page reloaded.','warn');
}
t_End();
?>