WooYun.org

$mysql = new mysql();
$search_arr = array("/\bunion /i","/\bselect /i","/\bupdate /i","/\boutfile /i","/\bor /i","/\bdelete /i","/\binsert /i"); 
$replace_arr = array("union ","select ","update ","outfile ","or ","delete ","insert "); 
$_POST = stripSql($_POST,$search_arr,$replace_arr);
$_GET = stripSql($_GET,$search_arr,$replace_arr);
$_COOKIE = stripSql($_COOKIE,$search_arr,$replace_arr);
unset($search_arr, $replace_arr);
if(!get_magic_quotes_gpc()){
	$_POST = addslash($_POST);
	$_GET = addslash($_GET);
	$_COOKIE = addslash($_COOKIE);
	$_SERVER = addslash($_SERVER);
}
@extract($_POST, EXTR_SKIP);
@extract($_GET, EXTR_SKIP);
sriipSql:
function stripSql($str,$search_arr,$replace_arr) {
	if(is_array($str)) {
		foreach($str as $key => $value) {
			$result[$key] = stripSql($value,$search_arr,$replace_arr);
		}
	} else {
		$result = preg_replace($search_arr,$replace_arr,$str);
	}
	return $result;
把我们的 union+空格  替换成 union  
//这个过滤有些问题我们只要把空格替换诸如：+| N个空格| tab | enter | 等
index.php?8'+/*!Union*/+/*!SelEct*/+1,2,3,4,version(),6,7,8,
在magic_quotes_gpc关闭时 会调用 addslash过滤GET POST COOKIES
Function addslash{
if(is_array($str)) {
		foreach($str as $key => $value) {
			$result[$key] = addslash($value);
		}
	} else {
		$result = @mysql_real_escape_string($str) ? mysql_real_escape_string($str) : addslashes($str);
	}
	return $result;
调用mysql_real_escape_string函数来转义Sql语句中特殊字符，它有一个特征就是会考虑到连接的当前字符集
除了
例如 Set names GBK  就是期望返回GKB集编码
上面说了mysql_real_escape_string会考虑当前连接的字符集
除了mysql_set_charset 能改变默认字符集.其它的都是默认latin-1
Mysql_real 这时使用的是默认的 导致和addslashes处理一样的效果
SQL注入
U.php 50-65行
	case 'list':
	
		$totalNum = $mysql->numTable("member", $where);
		$pageNum = 20;
		$totalPage = intval($totalNum/$pageNum) == $totalNum/$pageNum ? $totalNum/$pageNum : intval($totalNum/$pageNum)+1;
		$page = $page ? $page : 1;
		$page = $page>$totalPage ? $totalPage : $page;
		$page = $page<1 ? 1 : $page;
		$members = $mysql->select("member","id,name,time,money,provience,city,picture",$where,array("id DESC"),array(($page-1)*$pageNum,$pageNum));
		require(INCLUDE_PATH."page.class.php");
		$pageClass = new page($page,$totalNum,$pageNum, WEB_URL."member/u.php?action=list", true);
		$pageCode = $pageClass->getCode();
		$smarty->assign("webTitle","会员列表");
		$smarty->assign("uList", $members);
		$smarty->assign("pageCode", $pageCode);
		$smarty->display("member/m_u_list.html");
function numTable($table='',$wheres=false)
	{
		$table = $this->dbPrefix.$table;
		$sql = "SELECT COUNT(*) AS num FROM `$table`";
		if($wheres)
		{
			$sql .= " WHERE ";
			if(is_array($wheres))
			{
				foreach($wheres as $key => $val)
				{
					$whr[] = "`$key`='".$val."'";
				}
				$sql .= implode(" AND ",$whr);
			}
			elseif(is_string($wheres))
			{
				$sql .= $wheres;
			}
		}
		$result = $this->fetch($this->query($sql));
		return $result['num'];
	}
Where 没初始化 导致可执行任意sql语句
http://localhost/stcms_html/member/u.php?action=list&where={sql}