$rehref = "Монета "; if ($rows_main['gname'])$rehref .= $rows_main['gname']." "; $rehref .= $rows_main['aname']; if ($rows['ametal'])$rehref .= " ".$rows_main['ametal']; if ($rows['year']) $rehref .= " ".$rows_main['year']; $namecoins = $rehref; $tpl['rehref'] = contentHelper::strtolower_ru($rehref)."_cpc".$rows_main['priceshopcoins']."_cpr".$rows_main['parent']."_pcn0.html"; $sql_n = "select priceshopcoins.*, group.name as gname, `pricename`.name as aname, `pricemetal`.metal as ametal, pricesimbols.simbols as asimbols, `pricecondition`.`condition` as acondition from `priceshopcoins`,`pricename`,pricemetal, pricesimbols, pricecondition,`group` where priceshopcoins.parent='$parent' and `priceshopcoins`.`name`=`pricename`.`pricename` and priceshopcoins.metal=pricemetal.pricemetal and priceshopcoins.simbols=pricesimbols.pricesimbols and priceshopcoins.condition=pricecondition.pricecondition and priceshopcoins.group=group.group order by pricecondition.position;"; //echo $sql_n; $tpl['result_n'] = $price_class->getDataSql($sql_n); $tpl['arrayprice'] = $tpl['arrayamount'] = $tpl['arraycondition'] = array(); $condition = 0; foreach ($tpl['result_n'] as $rows_n) { if ($condition != $rows_n['condition'] && $condition!=9) { $tpl['arraycondition'][$rows_n['condition']] = $rows_n['acondition']; $condition = $rows_n['condition']; } $tpl['arrayprice'][$rows_n['acondition']] += $rows_n['priceend']; $tpl['arrayamount'][$rows_n['acondition']] ++; } } else { $sql_n = "select priceshopcoins.*, group.name as gname, `pricename`.name as aname, `pricemetal`.metal as ametal, pricesimbols.simbols as asimbols, `pricecondition`.`condition` as acondition