| Title | Shenzhen Gongji Technology Co., Ltd. XBROTHER Dynamic Environment Monitoring System V300R004C00B300 and below CWE-89 (SQL Injection) |
|---|
| Description | The order parameters at the /xbreport/api/v1/plamange/plansImmediate endpoint are vulnerable to unauthorized SQL injection. An attacker can exploit this vulnerability without any authentication.
In the backend code (PlanController.getImmediatePlans), the sort parameter is directly passed to MyBatis ${orderField} without any validation (no ClassUtil.checkOrder or ClassUtil.findField), and the order parameter is directly passed to ${order}. Both are concatenated into the ORDER BY clause as raw strings, leading to SQL injection.
Successful exploitation allows an attacker to extract database contents including database version, current user, database names, table names, column names, and any stored data via error-based injection techniques (updatexml, extractvalue, floor+group by). |
|---|
| Source | ⚠️ https://ucn9h68n9289.feishu.cn/wiki/Wu7hwNYaCiNpEUk5t7yc7n7QnPc?from=from_copylink |
|---|
| User | Anonymous User |
|---|
| Submission | 07/24/2026 11:23 (2 months ago) |
|---|
| Moderation | 09/23/2026 17:48 (2 months later) |
|---|
| Status | Duplicate |
|---|
| VulDB entry | 394566 [Shenzhen Gongji Technology XBROTHER Dynamic Environment Monitoring System up to 300R004C00B300 plansImmediate PlanController.getImmediatePlans order/sort sql injection] |
|---|
| Points | 0 |
|---|