Authenticated code execution via unsanitized emp_id query
Published Aug 17, 2023 · Updated Oct 7, 2024
SQL injection in Online Travel Agency System 1.0 allows remote authenticated users to execute arbitrary code through emp_id. employee_detail.php inserts the GET value directly into a quoted SELECT statement passed to mysqli_query, without validation or parameterization. Access to the administrative employee-detail endpoint and a valid session are required; crafted predicates can alter database queries and lead to code execution.
Summary
What happened
SQL injection in Online Travel Agency System 1.0 allows remote authenticated users to execute arbitrary code through emp_id. employee_detail.php inserts the GET value directly into a quoted SELECT statement passed to mysqli_query, without validation or parameterization. Access to the administrative employee-detail endpoint and a valid session are required; crafted predicates can alter database queries and lead to code execution.
The record
- CVE
- CVE-2023-31938
- Published
- Aug 17, 2023
- Updated
- Oct 7, 2024
- Vendor
- Online Travel Agency System Project
- Product
- Online Travel Agency System
- Classifications
- CWE-89, T1190
- Attack vector
- network
- Privileges
- authenticated
Timeline
How it unfolded
- Aug 17, 2023CVE publishedPublication date reported by the CVE source.
- Oct 7, 2024Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=1.0
What conditions does exploitation require?
What is affected?
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
- employee_detail.php emp_id SQL injection procedurefunctional · demonstrated
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo