CVE-2020-21012CWE-89sql-injection

CVE-2020-21012

Critical · published October 1, 2021

CVSS v3.1
9.8
EPSS
4%
Percentile
89.1
In the wild
Unconfirmed
What it is

⚠️ A simple email parameter is all it takes to unlock this vulnerability! 🕵️‍♂️ The Sourcecodester Hotel and Lodge Management System 2.0 is wide open to unauthenticated SQL injection attacks! Consider this like a hotel that lets anyone walk into the management office just by saying they have a booking — they can change room assignments, access guest information, or even adjust bills without any verification! An attacker could exploit this vulnerability to execute arbitrary SQL commands, potentially accessing or manipulating sensitive customer data, tampering with room bookings, or even deleting critical information. The consequences could be absolutely devastating for the business and its customers!

Put simply

Consider this like a hotel that lets anyone walk into the management office just by saying they have a booking — they can change room assignments, access guest information, or even adjust bills without any verification! This vulnerability allows attackers to insert malicious SQL code through the 'email' parameter on various edit pages, bypassing authentication checks entirely and giving them direct access to the database.

What to do

An attacker could exploit this vulnerability to execute arbitrary SQL commands, potentially accessing or manipulating sensitive customer data, tampering with room bookings, or even deleting critical information. The consequences could be absolutely devastating for the business and its customers! To mitigate this risk, patch the system to the latest version as soon as possible. Additionally, validate and sanitize all user inputs to prevent SQL injection and consider implementing prepared statements for database queries. Don't leave your database open to attack! You've got this! Follow these steps, and you'll be one step closer to security hero status! 🦸‍♀️

The record
Technical detail
CVSS v3.1
9.8 · CRITICAL
Vector
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
CVSS v4.0
Not supplied
EPSS
0.03501 · 89.1th percentile
Weakness
CWE-89 · Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Published
2021-10-01T23:15Z
Affected products (1)
ProductVersionsFixed in
nikhil-bhalerao/hotel_and_lodge_management_systemall versions—
References (2)
EPSS history
Timeline
  • 01 OCT 18:21Z
    Sourcecodester Hotel and Lodge Management System 2.0 is vulnerable to unauthenticated SQL injection and can allow remote attackers to execute arbitrary SQL…
    cvelistv5