query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(1));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(2));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(3));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(4));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(5));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(6));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(7));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(8));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(9));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(10));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(11));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(12));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(13));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(14));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(15));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(16));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
#####################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(17));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
##########################################################################
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(18));
$arrsmiles = $querysmiles -> fetchAll();
$count = 0;
foreach($arrsmiles as $val) {
$str = preg_replace('|' . preg_quote($val['smiles_code']) . '|', ' ', $str, $config['resmiles'] - $count, $cnt);
$count += $cnt;
if ($count >= $config['resmiles']) {
break;
}
}
#####################################
if (is_admin(array(101, 102, 103, 105))) {
$querysmiles = DB :: $dbh -> query("SELECT `smiles_name`, `smiles_code` FROM `smiles` WHERE `smiles_cats`=? ORDER BY LENGTH(`smiles_code`) DESC;", array(19));
$arrsmiles = $querysmiles -> fetchAll();
foreach($arrsmiles as $val) {
$str = str_replace($val['smiles_code'], ' ', $str);
}
}
return $str;
}