Description
Leave Management System Project v1.0 is vulnerable to multiple Authenticated SQL Injection vulnerabilities.
Vulnerabilities
CVE-2023-44480
The 'setcasualleave' parameter of the admin/setleaves.php resource does not validate the characters received and they are sent unfiltered to the database. The vulnerable code is:
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET CasualLeave = '".$setcasualleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET CasualLeave = '".$setcasualleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET CasualLeave = '".$setcasualleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET CasualLeave = '".$setcasualleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
CVE-2023-44481
The 'setearnleave' parameter of the admin/setleaves.php resource does not validate the characters received and they are sent unfiltered to the database. The vulnerable code is:
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET EarnLeave = '".$setearnleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET EarnLeave = '".$setearnleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET EarnLeave = '".$setearnleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET EarnLeave = '".$setearnleave."' WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
CVE-2023-44482
The 'setsickleave' parameter of the admin/setleaves.php resource does not validate the characters received and they are sent unfiltered to the database. The vulnerable code is:
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET SickLeave = '".$setsickleave."'WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET SickLeave = '".$setsickleave."'WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET SickLeave = '".$setsickleave."'WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
$setsickleave = strip_tags(trim($_POST['setsickleave']));
$setearnleave = strip_tags(trim($_POST['setearnleave']));
$setcasualleave = strip_tags(trim($_POST['setcasualleave']));
...
$update = "UPDATE employees SET SickLeave = '".$setsickleave."'WHERE Dept = '".$row2["Dept"]."'";
$conn->query($update);
Our security policy
We have reserved the IDs CVE-2023-44480, CVE-2023-44481 and CVE-2023-44482 to refer to these issues from now on.
Disclosure policy
System Information
Version: Leave Management System Project v1.0
Operating System: Any
Mitigation
There is currently no patch available for this vulnerability.
References