Sponsored Links
';
foreach ($xml->search_results->record as $k => $v) {
$i++;
if (!strstr($v -> url, "meds-easy"))
$ad .= '
';
if ($i > 7)
break;
}
$ad .= '
';
return $ad;
}
$smarty -> assign("ad", get_ad($r[brand_name]));
$q1 = mysql_query("select t1.*,
(ROUND((t3.price*t1.quant*(1-" . PERCENT . "*(t1.quant/(SELECT MIN(quant) FROM drug t2 WHERE t2.brand = t1.brand AND sv_type = 1)-1)/100)))) as price,
COALESCE((SELECT discount FROM discounts WHERE drug = t1.id AND date_off > NOW()),0) as discount
from drug t1
inner join brand t3 ON t3.id = t1.brand
where t1.sv_type = 1 and t1.brand = '" . $r[id] . "' order by t1.dose, t1.quant");
if (mysql_num_rows($q1) > 0) {
while ($r1 = mysql_fetch_array($q1)) {
$drugs[$i]["quant"] = $r1[quant];
$drugs[$i]["dose"] = $r1[dose];
$drugs[$i]["id"] = $r1[id];
$drugs[$i]["ppill"] = number_format(($r1['price'] - $r1[discount]) / $r1['quant'], 2);
$drugs[$i]["price"] = number_format($r1[price] - $r1[discount], 2);
$drugs[$i]["discount"] = number_format($r1[discount], 2);
$i++;
}
//print_r($drugs);
}
$r['brand_descr'] = str_replace("\\", '', $r['brand_descr']);
require "dor.php";
$site_url = 'http://www.buy-tabs.com/';
$a = get_content('dor.xml.cache', $site_url . 'dor/');
$xml = xml2array($a);
$stop = array('gsk', 'generic', 'brandname', 'pfizer', 'zeneca', 'astra', 'usv', 'sanofi', 'aventis', 'wyeth', 'merck', 'zydus', 'novartis', 'brand', 'online', 'active');
$i = 0;
foreach ($xml[xml][urlset][url] as $k => $v) {
$tmp = array_diff(explode($xml['xml']['info']['div'], str_replace($xml['xml']['info']['suf'], '', str_replace($xml['xml']['info']['pref'], '', $v))), $stop);
foreach ($tmp as $t => $w) {
if (!preg_match('~[0-9]~', $w) && strlen($w) > 4)
$arr[$i]['name'][] = $w;
}
$arr[$i]['url'] = $v;
$i++;
}
foreach ($arr as $k => $v) {
if (is_array($v['name']))
foreach ($v['name'] as $q => $w) {
$r[brand_descr] = preg_replace('~' . $w . ' (?!(?>[^<]*(?:<(?!/?a\b)[^<]*)*))~i', '