| 제목 | AdithyaYelloju Restaurant-Management-System 7f0e7e84255e8fcfd488e83f8f91451bbbff6b9c SQL Injection |
|---|
| 설명 | The affected components are `User/cancel.php` and `User/cancel_t.php`, two endpoints used to cancel an order. Both endpoints take the `id` GET parameter and concatenate it directly into a SQL `DELETE` statement without any escaping or session/ownership check:
```php
// User/cancel.php
$id=$_GET["id"];
mysqli_query($conn,"delete from order_list where id='$id'");
```
```php
// User/cancel_t.php
$id=$_GET["id"];
mysqli_query($conn,"delete from t_order where id='$id'");
```
There is no `session_start()`, no `$_SESSION['user']` check, no anti-CSRF token, and no record-ownership verification. An attacker can close the quote and append `OR id>0 -- ` to mass-delete every row in the `order_list` or `t_order` tables. Verified in the lab against `User/cancel_t.php` (deleted all `t_order` rows in one request).
|
|---|
| 원천 | ⚠️ https://github.com/AdithyaYelloju/Restaurant-Management-System/issues/7 |
|---|
| 사용자 | 100001001X (UID 100909) |
|---|
| 제출 | 2026. 09. 01. PM 01:28 (30 날 ago) |
|---|
| 모더레이션 | 2026. 09. 30. AM 10:09 (29 days later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 411924 [AdithyaYelloju Restaurant-Management-System 까지 7f0e7e84255e8fcfd488e83f8f91451bbbff6b9c Order Cancellation User/cancel.php mysqli_query id SQL 주입] |
|---|
| 포인트들 | 20 |
|---|