2) {
$_REQUEST['what']=(iconv('utf-8','windows-1251',$_REQUEST['what'] ));
$sql = "SELECT m . * , m.id AS mod_id, IF(m.cine>0,m.cine,c.cine) as price, c.name, b.name AS brand, c.brend_id
FROM catalogs_modifications AS m
LEFT JOIN catalogs_products AS c ON c.id = m.product_id
LEFT JOIN catalogs_brends AS b ON b.id = brend_id
WHERE m.code LIKE '%".htmlspecialchars($_REQUEST['what'],ENT_QUOTES)."%' AND m.active>0";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_affected_rows()!=0) {
while ($item=mysql_fetch_assoc($result)) {
// наличие товара
$sql5 = "SELECT c.name as city, o.count
FROM catalogs_keys_products_cities as o
LEFT JOIN catalogs_cities as c
ON o.city_id=c.id
WHERE o.mod_code='".$item['code']."' AND o.count>0 ";
$result5 = mysql_query($sql5) or die(mysql_error());
if (mysql_affected_rows()!=0) {
$onStockDesc='';
while ($onStock=mysql_fetch_assoc($result5)) {
$onStockDesc.=$onStock['city']."(".$onStock['count'].") ";
}
} else { $onStockDesc='нет';}
// Отправляем данные
// code, mod_id, product_id, brend_id, brend, price в качестве option
//round($item['price'] - ($item['price']*20/100))
$param=$item['code']."|".$item['mod_id']."|".$item['product_id']."|".$item['brend_id']."|".$item['brand']."|".round($item['price'] - ($item['price']*$item['sale']/100))."|".$onStockDesc."|".$item['color']."|".$item['size'];
$param=(iconv('windows-1251','utf-8',$param ));
$item['name']=(iconv('windows-1251','utf-8',$item['name'] ));
$item['size']=(iconv('windows-1251','utf-8',$item['size'] ));
$item['color']=(iconv('windows-1251','utf-8',$item['color'] ));
$onStockDesc=(iconv('windows-1251','utf-8',$onStockDesc ));
$MegaFind[$param]=trim($item['name']." ".$item['size']." ".$item['color']." | ".$onStockDesc);
}
if (!empty($MegaFind)) {
$out='';
$out.='";
echo $out;
}
} else { echo "
не найдено
"; }
} else { $out=''; echo $out; }
break;
case 'searchEmail':
// вычитываем модели относящиеся к заданной серии
if ( strlen($_REQUEST['what'])>2) {
$_REQUEST['what']=(iconv('utf-8','windows-1251',$_REQUEST['what'] ));
$sql = "SELECT u.*
FROM zlo_users as u
LEFT JOIN zlo_users_group AS g ON u.group = g.id
WHERE u.email LIKE '%".htmlspecialchars($_REQUEST['what'],ENT_QUOTES)."%'";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_affected_rows()!=0) {
while ($row=mysql_fetch_assoc($result)) {
// Отправляем данные
// code, mod_id, product_id, brend_id, brend, price в качестве option
$param=$row['id']."|".$row['username']."|".$row['email']."|".$row['tel']."|".$row['tel2']."|".$row['city']."|".$row['address']."|".$row['group'];
$param=(iconv('windows-1251','utf-8',$param));
$MegaFind[$param]=trim($row['email']);
}
if (!empty($MegaFind)) {
$out='';
$out.='";
echo $out;
}
} else { echo "
не найдено
"; }
} else { $out=''; echo $out; }
break;
case 'searchTel':
// вычитываем модели относящиеся к заданной серии
if ( strlen($_REQUEST['what'])>2) {
$_REQUEST['what']=(iconv('utf-8','windows-1251',$_REQUEST['what'] ));
$sql = "SELECT u.*
FROM zlo_users as u
LEFT JOIN zlo_users_group AS g ON u.group = g.id
WHERE u.tel LIKE '%".htmlspecialchars($_REQUEST['what'],ENT_QUOTES)."%'";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_affected_rows()!=0) {
while ($row=mysql_fetch_assoc($result)) {
// Отправляем данные
// code, mod_id, product_id, brend_id, brend, price в качестве option
$param=$row['id']."|".$row['username']."|".$row['email']."|".$row['tel']."|".$row['tel2']."|".$row['city']."|".$row['address']."|".$row['group'];
$param=(iconv('windows-1251','utf-8',$param));
$MegaFind[$param]=trim($row['tel']);
}
if (!empty($MegaFind)) {
$out='';
$out.='";
echo $out;
}
} else { echo "
не найдено
"; }
} else { $out=''; echo $out; }
break;
case 'userCheckData':
// вычитываем модели относящиеся к заданной серии
if ( strlen($_REQUEST['what'])>2) {
$_REQUEST['what']=htmlspecialchars((iconv('utf-8','windows-1251',$_REQUEST['what'])),ENT_QUOTES);
$sql = "SELECT u.*
FROM zlo_users as u
LEFT JOIN zlo_users_group AS g ON u.group = g.id
WHERE u.".$_REQUEST['field']." LIKE '%".$_REQUEST['what']."%'";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_affected_rows()!=0) {
echo "