| 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 : C:/nginx/html/Admin/Waldo/ |
Upload File : |
<?
// Admiv/Waldo/userUpdate.phpinc
#d_On();
// Update existing dates.
$startdate = $sessionInfo['sessionStart'];
$enddate = $sessionInfo['sessionEnd'];
$currentDate = $startdate;
$endloop = 0;
while ( $endloop < 366 && $currentDate <= $enddate ) {
$sDate = str_replace('-','',$currentDate);
$location = formValue('location_'.$sDate);
$locationOriginal = formValue('locationOriginal_'.$sDate);
$note = formValue('note_'.$sDate);
$noteOriginal = formValue('noteOriginal_'.$sDate);
if ( $location != $locationOriginal || $note != $noteOriginal ) {
// Change made.
d_line('Change made for '.$currentDate.'.','i');
d_Var('$currentDate',$currentDate);
d_Var('$location',$location);
d_Var('$locationOriginal',$locationOriginal);
d_Var('$note',$note);
d_Var('$noteOriginal',$noteOriginal);
if ( $locationOriginal == '' && $noteOriginal == '' ) {
// INSEERT date.
$query = "
INSERT
INTO `calendaruser` (
userId,
userYRTR,
userDate,
userLocation,
userNote
) VALUES (
".$_SESSION['userId'].",
'".query_safe($_SESSION['YRTR']['User'])."',
'".query_safe($currentDate)."',
'".query_safe($location)."',
'".query_safe($note)."'
)
";
d_Var('calendaruserInsert',$query,'q');
$calendaruserInsert = query_do($query);
@d_Var('$calendaruserInsert',$calendaruserInsert);
displayNotice($currentDate.' added.');
} else {
if ( $location || $note ) {
// UPDATE date.
d_Line('UPDATE date.','i');
$query = "
UPDATE `calendaruser`
SET userLocation = '".query_safe($location)."',
userNote = '".query_safe($note)."'
WHERE userDate = '".query_safe($currentDate)."'
AND userId = ".$_SESSION['userId']."
";
d_Var('calendaruserUpdate',$query,'q');
$calendaruserUpdate = query_do($query);
@d_Var('$calendaruserUpdate',$calendaruserUpdate);
displayNotice($currentDate.' updated.');
} else {
// DELETE date.
d_Line('DELETE date.','i');
$query = "
DELETE
FROM `calendaruser`
WHERE userDate = '".query_safe($currentDate)."'
AND userId = ".$_SESSION['userId']."
";
d_Var('calendaruserDelete',$query,'q');
$calendaruserDelete = query_do($query);
@d_Var('$calendaruserDelete',$calendaruserDelete);
displayNotice($currentDate.' removed.');
}
}
}
$currentDate = date('Y-m-d', strtotime('+1 day', strtotime($currentDate)));
$endloop++;
}
$startdate = '';
$enddate = '';
unset($preset);
#d_Off();
?>