<br />
<b>Notice</b>:  ТЕСТОВАЯ ОШИБКА ЧЕРЕЗ trigger_error() in <b>/var/www/fastuser/data/www/electric-doma.ru/utils/CacheManager.php</b> on line <b>44</b><br />


/*  Вариант работы с бд
  function getActualCacheData($typeId,$valueId){
  global $admin_db;
  $cacheLifeInterval = 60 *60*2;
  $q = mysql_query("SELECT `date` FROM `cache` where valueId=$valueId and typeId = $typeId",$admin_db);
  $row = mysql_fetch_assoc($q);
  if (!isset($row) || empty($row) || empty($row['date']))
  return false;


  $cacheDate =strtotime($row['date']);
  $interval = (time() - $cacheDate)-7200;
  if ($interval > $cacheLifeInterval) return false;

  $q = mysql_query("SELECT `json` FROM `cache` where valueId = $valueId and typeId = $typeId",$admin_db);
  $row = mysql_fetch_assoc($q);
  //var_dump($row);
  return  json_decode($row['json'],JSON_OBJECT_AS_ARRAY);

  }
  function saveCache($typeId,$valueId,$data){
  global $admin_db;
  $json = json_encode($data);
  $q = mysql_query("DELETE FROM `cache` WHERE  typeId = $typeId AND valueId= $valueId",$admin_db);
  $query = "INSERT INTO `cache`(`typeId`, `valueId`, `json`) VALUES ($typeId,$valueId,'".mysql_real_escape_string($json)."')";
  $q = mysql_query($query,$admin_db);
  }

 */


 function getCopyDoc($pref,$siteId,$data,$template){
      
    $folder = '/var/www/fastuser/data/www/electric-doma.ru/docs/';
    $templatefolder = '/var/www/fastuser/data/www/electric-doma.ru/templatedocs/';
    $filename = $pref.$siteId . '.docx';
    $docxFile = $folder . $filename;
    $docxUrl = '/docs/' . $filename;

    if (!file_exists($docxFile) ) 
        
    {
        if (!copy($templatefolder . $template, $docxFile))
            
            echo 'Не удалось скопировать файл';

            $params = array('{1}' => $data['site_url'],'{2}' => $data['site_url']);
       
           
            $zip = new ZipArchive();
            
            if (!$zip->open($docxFile)) 
            
                    {
                      echo "не открывается";
                    }

        $documentXml = $zip->getFromName('word/document.xml');

        $documentXml = str_replace(array_keys($params), array_values($params), $documentXml);

        $zip->deleteName('word/document.xml');
        $zip->addFromString('word/document.xml', $documentXml);

        $zip->close();
    
    } 
    
    return $docxUrl;


}


function getCopyPdf($pref,$siteId,$data,$template)

{
    $folder = '/var/www/fastuser/data/www/electric-doma.ru/docs/';
     $templatefolder = '/var/www/fastuser/data/www/electric-doma.ru/templatedocs/';
    $filename = $pref.$siteId . '.pdf';
    $docxFile = $folder . $filename;
    $docxUrl = '/docs/' . $filename;
     if (!file_exists($docxFile) ) 
     
            {
                include(dirname(__FILE__)."/mpdf/mpdf.php");

                    $size = '20,15,21,22,10,10';
                    $format = 'A4';
                    $mpdf = new mPDF('s',$format,'','',$size);
                    $params = array('{1}' => $data['site_url'],'{2}' => $data['site_url']);
                    $html = file_get_contents($templatefolder. $template);
                    $html = str_replace(array_keys($params), array_values($params), $html);


                    $mpdf->WriteHTML($html); // , true, false, true, false, ''
                    $mpdf->Output($docxFile, 'F');
            }

        return $docxUrl;
}


function getActualCacheData($typeId, $valueId) 
{
    $cacheDir = "/var/www";
    //$cacheLifeInterval = 60 * 60 * 24 * 365;
    $cacheFile = $cacheDir . "/cache/$typeId/$valueId.json";
    if (!file_exists($cacheFile))
        return false;

   // $cacheDate = @filemtime($cacheFile);
  //  $interval = (time() - $cacheDate);
  //  if ($interval > $cacheLifeInterval)
  //      return false;

    $data = file_get_contents($cacheFile);
    return json_decode($data, JSON_OBJECT_AS_ARRAY);
}

function clearFolder($folder) 

{
    if (file_exists($folder))
        foreach (glob($folder . '*') as $file)
            unlink($file);
}

function saveCache($typeId, $valueId, $data) 

{
    $cacheDir = "/var/www";
    $json = json_encode($data);
    $cacheFile = $cacheDir . "/cache/$typeId/$valueId.json";
    if (file_exists($cacheFile)) {
        unlink($cacheFile);
    }
    file_put_contents($cacheFile, $json);
}

function clearCacheByPageId($id_page) 

{
    $cacheDir = "/var/www";
    @unlink($cacheDir . '/cache/2/' . $id_page . '.json');
    @unlink($cacheDir . '/cache/3/' . $id_page . '.json');
    @unlink($cacheDir . '/cache/4/' . $id_page . '.json');
    @unlink($cacheDir . '/cache/5/' . $id_page . '.json');
    @unlink($cacheDir . '/cache/6/' . $id_page . '.json');
    @unlink($cacheDir . '/cache/7/' . $id_page . '.json');
}

function clearCacheBySiteId($id_site) 

{
    $cacheDir = "/var/www";
    @unlink($cacheDir . '/cache/1/' . $id_site . '.json');
}

function clearCacheOfAllSites() 

{
    $cacheDir = "/var/www";
    clearFolder($cacheDir . '/cache/1/');
}

function clearCacheOfAll() 

{
    $cacheDir = "/var/www";
    clearFolder($cacheDir . '/cache/1/');
    clearFolder($cacheDir . '/cache/2/');
    clearFolder($cacheDir . '/cache/3/');
    clearFolder($cacheDir . '/cache/4/');
    clearFolder($cacheDir . '/cache/5/');
    clearFolder($cacheDir . '/cache/6/');
    clearFolder($cacheDir . '/cache/7/');
    clearFolder($cacheDir . '/cache/8/');
    clearFolder($cacheDir . '/cache/9/');
}

//$type=1 - Все главные страницы
//$type=2 - Assidents связанные страницы
//$type=3 - обычная страницы для неавторизованного
//$type=4 - клуб для авторизованного
//$type=5 - пенсия
//$type=6 - клуб для неавтооризованного
//$type=7 - обычная страница для авторизованного


function getTVByDefPageId($id, $type, $discountMult) {
    global $admin_db;
    global $adminCdb;
//ini_set('display_errors', 'On');
//error_reporting(E_ALL);
    $data = getActualCacheData($type, $id);
    
      $data = false;
    if ( $data === false) 
    
    
    //Кэш устарел, либо его нет
    
    { 
        $q = mysql_query("SELECT * from pages where id_page='$id'", $admin_db);
        $page_info = mysql_fetch_array($q);


        $data['views'] = $page_info['views'];
        $data['indexPage'] = $page_info['index_page'];
        $data['head.home'] = $page_info['home'];
        $data['head.meta.title'] = $page_info['meta_title_page'];
        $data['head.title'] = $page_info['title_page'];
        $data['head.meta.keywords'] = $page_info['keywords_page'];
        $data['head.meta.description'] = $page_info['description_page'];
        $data['customTag'] = $page_info['customTag'];
        $data['whatsapp'] = '';

        $siteId = $page_info['id_site'];

        $table_suffix = '';
            

        $items = array();
        $w = mysql_query("SELECT * FROM `table_home{$table_suffix}` WHERE `parent_table_home` IS NULL and `id_site`=$siteId ORDER BY `position_table_home` ASC", $admin_db);
        while ($w && $roww = mysql_fetch_assoc($w)) 
        
        {
            $item = array
            (
                'noparent' => true,
                'text' => $roww['text_table_home'],
                'can_order' => $roww['can_order'],
                'can_order_club' => !($table_suffix == '_club' && !(TV::get('userId'))),
                'scale' => $roww['scale_table_home'],
                'count' => $roww['count_table_home'],
                'price' => $roww['price_table_home'],
                'description' => $roww['description_table_home'],
                'order_count' => $roww['order_count_table_home'] == 0 ? '' : $roww['order_count_table_home'],
                'id' => $roww['id_table_home'],
                'price_type' => isset($roww['price_table_type_home']) ? $roww['price_table_type_home'] : 1,
                'price_ot' => isset($roww['price_table_ot_home']) ? $roww['price_table_ot_home'] . '&nbsp;руб' : 0,
                'price_do' => isset($roww['price_table_do_home']) ? $roww['price_table_do_home'] . '&nbsp;руб' : 0,
                'clubprice' => !empty($roww['clubprice_table_home']) ? 'от&nbsp;' . $roww['clubprice_table_home'] . '&nbsp;руб' : '',
            );

            if ($item['price'] != '')
                $item['price'] = 'от&nbsp;' . $item['price'] . '&nbsp;руб';
            else
                $item['price'] = 'Договорная';
            $items[] = $item;
        }
        
        
        //Добавляем кастомный заказ - это наверное который пишет сам клиент от руки в поле для заказа


        $items[] = 'custom_order';


        $q = mysql_query("SELECT * FROM `title_table_home{$table_suffix}` where `id_site`=$siteId  ORDER BY `position_title_table_home` ASC", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $items[] = $row['name_title_table_home'];
            
            $w = mysql_query("SELECT * FROM `table_home{$table_suffix}` WHERE `parent_table_home` = " . mysql_real_escape_string($row['id_title_table_home']) . " ORDER BY `" . 'order_count_table_home' . "` " . 'DESC', $admin_db);
            while ($w && $roww = mysql_fetch_assoc($w)) 
            
            {
                $item = array(
                    'noparent' => false,
                    'text' => $roww['text_table_home'],
                    'can_order' => $roww['can_order'],
                    'price_text' => $roww['price_text'],
                    'can_order_club' => !($table_suffix == '_club' && !(TV::get('userId'))),
                    'scale' => $roww['scale_table_home'],
                    'count' => $roww['count_table_home'],
                    'pure_price' => $roww['price_table_ot_home'],
                    'price' => $roww['price_table_home'],
                    'description' => $roww['description_table_home'],
                    'id' => $roww['id_table_home'],
                    'order_count' => $roww['order_count_table_home'] == 0 ? '' : $roww['order_count_table_home'],
                    'price_type' => isset($roww['price_table_type_home']) ? $roww['price_table_type_home'] : 1,
                    'price_ot' => isset($roww['price_table_ot_home']) ? $roww['price_table_ot_home'] . '&nbsp;руб' : 0,
                    'price_do' => isset($roww['price_table_do_home']) ? $roww['price_table_do_home'] . '&nbsp;руб' : 0,
                    'clubprice' => !empty($roww['clubprice_table_home']) ? 'от&nbsp;' . $roww['clubprice_table_home'] . '&nbsp;руб' : 'от ' . $roww['price_table_home'] . '&nbsp;руб',
                );
                
                if ($item['price'] != '') 
                
                {
                    $item['pure_price'] = $item['price'];
                    $item['price'] = 'от&nbsp;' . $item['price'] . '&nbsp;руб';
                } 
                
                else
                    $item['price'] = 'Договорная';
                    $items[] = $item;
            }
        }


        $child_items = array();
        $w = mysql_query("SELECT * FROM `child_table_home{$table_suffix}` WHERE `id_site` = $siteId ORDER BY `" . 'order_count_table_home' . "` " . 'DESC', $admin_db);
        while ($w && $roww = mysql_fetch_assoc($w)) 
        
        {
            $item = array(
                'noparent' => false,
                'text' => $roww['text_table_home'],
                'can_order' => $roww['can_order'],
                'can_order_club' => !($table_suffix == '_club' && !(TV::get('userId'))),
                'scale' => $roww['scale_table_home'],
                'count' => $roww['count_table_home'],
                'pure_price' => $roww['price_table_ot_home'],
                'price' => $roww['price_table_home'],
                'description' => $roww['description_table_home'],
                'id' => $roww['id_table_home'],
                'order_count' => $roww['order_count_table_home'] == 0 ? '' : $roww['order_count_table_home'],
                'price_type' => isset($roww['price_table_type_home']) ? $roww['price_table_type_home'] : 1,
                'price_ot' => isset($roww['price_table_ot_home']) ? $roww['price_table_ot_home'] . '&nbsp;руб' : 0,
                'price_do' => isset($roww['price_table_do_home']) ? $roww['price_table_do_home'] . '&nbsp;руб' : 0,
                'clubprice' => !empty($roww['clubprice_table_home']) ? 'от&nbsp;' . $roww['clubprice_table_home'] . '&nbsp;руб' : 'от ' . $roww['price_table_home'] . '&nbsp;руб',
            );
            if ($item['price'] != '') 
            
            {
                $item['pure_price'] = $item['price'];
                $item['price'] = 'от&nbsp;' . $item['price'] . '&nbsp;руб';
            } else
                $item['price'] = 'Договорная';


            if (!array_key_exists($roww['parent_table_home'], $child_items)) 
            
            {
                $child_items[$roww['parent_table_home']] = array();
            }

            $child_items[$roww['parent_table_home']][] = $item;
        }

            //кое что здесь убрал в телегу кинул код для сохранения

            $data['content.pricelist.childs'] = $child_items;
            
            $data['content.pricelist'] = $items;
            
           
//Для папки кэша - №-2 - Accidents:

        $data['page.content'] = $page_info['content_page'];
        $data['page.warranty'] = $page_info['warranty_page'];

        
        $data['page.img'] = $page_info['img'];
        $data['page.img_mobile'] = $page_info['img_mobile'];
        
        $data['page.name'] = $page_info['name_page'];
        $data['page.content.title'] = $page_info['title_page'];
        //$data['header.slogan'] = $page_info['name_page'] . ' в [[!city:П]]';
        $data['page.aside.coast.from'] = $page_info['price_page'];
        $data['page.aside.coast.from.club'] = $page_info['club_price_page'];
        
        $gallery = array();
        $q = mysql_query("SELECT * FROM `pages_gallery` WHERE `id_page` = '" . mysql_real_escape_string($page_info['id_page']) . "' order by `order`", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
            $gallery[] = $row;
        $data['page.gallery'] = $gallery;
        
        $galleryR = array();
        $q = mysql_query("SELECT * FROM `pages_contentgallery` WHERE `id_page` = '" . mysql_real_escape_string($page_info['id_page']) . "'  order by `order`", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
            $galleryR[] = $row;
        $data['page.contnetgallery'] = $galleryR;

        $galleryMain = array();
        $q = mysql_query("SELECT * FROM `pages_mainimage` WHERE `id_page` = '" . mysql_real_escape_string($page_info['id_page']) . "'  order by `order`", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
            $galleryMain[] = $row;
        if (count($galleryMain) == 0) 
        
        {
            $q = mysql_query("SELECT * FROM `pages_mainimage` WHERE `id_page` = '" . mysql_real_escape_string($page_info['import_id_page']) . "'  order by `order`", $admin_db);
            while ($q && $row = mysql_fetch_assoc($q))
                $galleryMain[] = $row;
        }
        $data['page.galleryMain'] = $galleryMain;

        $page_banners = array();
        $q = mysql_query("SELECT * FROM `page_banners` WHERE `page_id` = '{$page_info['id_page']}' ORDER BY `order`");
        while ($q && $row = mysql_fetch_assoc($q))
        
        $page_banners[] = $row;
        $data['page.banners'] = $page_banners;


#end
#region Subsub
        $subsub = array();
        if (empty($page_info['subsub'])) 
        
        {
            $q = mysql_query("SELECT `subcats`.`id`, `subcats`.`name` FROM `subcats` INNER JOIN `subpage` ON `subcats`.`id` = `subpage`.`subcatId` WHERE `pageId` = '" . mysql_real_escape_string($page_info['id_page']) . "' GROUP BY `subcats`.`id`", $admin_db);
            while ($q && $row = mysql_fetch_row($q)) 
            
            {
                $sub = array($row[1], array());
                $w = mysql_query("SELECT * FROM `subpage` WHERE `pageId` = '" . mysql_real_escape_string($page_info['id_page']) . "' AND `subcatId` = '" . mysql_real_escape_string($row[0]) . "'", $admin_db);
                while ($w && $roww = mysql_fetch_assoc($w))
                    $sub[1][] = $roww;
                $subsub[] = $sub;
            }
        }
        
        $data['subsub'] = $subsub;

#end
#METRIKA!!!

        $q = mysql_query("SELECT `name_metrika`, `count_metrika` FROM `metrika` where `id_page`='$id'", $admin_db);
        $metrika = mysql_fetch_assoc($q);
        $data['metrika'] = $metrika;

        #region Shop

        $rows = array();
        $q = mysql_query("SELECT * FROM `items` INNER JOIN `shop` ON `shop`.`id_item` = `items`.`id_item` AND `shop`.`id_page` = '" . mysql_real_escape_string($page_info['id_page']) . "' ORDER BY `shop`.`order` ASC");
        $totalSold = 0;
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $rows[] = $row;
            $totalSold += $row['sold'];
        }

        if ($page_info['button_buy'] == '') 
        
        {
            $data['button_buy'] = '';
        } 
        
        else 
        
        {
            $data['button_buy'] = $page_info['button_buy'];
        }
        
        $data['goods'] = $rows;
        $data['goods-sold'] = $totalSold;

        $sql = "SELECT table_pages.*,pages.url_page from table_pages 
 left outer join pages on table_pages.id_linked_page = pages.id_page 
 where table_pages.id_page=$id 
 order by position_table_home";
$q = mysql_query($sql, $admin_db);

$tableContent = '<table class="add-price">
 <thead>
 <tr>
 <th>№ п/п</th>
 <th>Наименование работ</th>
 <th>Оформить заказ</th>
 <th style="width: 90px;">Цена от</th>
 </tr>
 </thead>
 <tbody>';

$i = 1;
$assidents = array();
$innerTable = array();

while ($row = mysql_fetch_assoc($q)) {
    // Определяем атрибут noindex
    $noindexAttr = '';
    if ($row['noindex_flag'] == 1) {
        $noindexAttr = ' data-noindex';
    }

    $price = ($row['price_table_home'] == 0) ? '<span class="realPrice">Бесплатно</span>' : 
        '<span class="realPrice">' . number_format($row['price_table_home'], 0, ',', ' ') . " руб.</span>";

    if ($type == 7 && $row['clubprice_table_home'] != 0 && $row['clubprice_table_home'] != $row['price_table_home']) {
        $price = "<s>" . number_format($row['price_table_home'], 0, ',', ' ') . " руб</s><br><span class='realPrice'>" . 
            number_format($row['clubprice_table_home'], 0, ',', ' ') . " руб.</span>";
    }

    $row['price'] = $price;
    $innerTable[] = $row;
    
    $text_table_home = $row['text_table_home'];
    if ($row['url_page']) {
        $text_table_home = '<a class="order-table-btn" onclick="location.href=\'' . $row['url_page'] . '\';return false;">' . 
            $row['text_table_home'] . "</a>";
    }
    
    // Формируем строку таблицы с учетом noindex

    $tableContent.= '<tr class="odd"'. $noindexAttr. '>
    <td>'. $i. '</td>
    <td class="service-name">'. $text_table_home. '</td>
    <td style="vertical-align: middle;"><a class="order-table-btn">Заказать</a></td>
    <td class="leftSlideOnHover">
        <span>'. $price. '</span><br>
        <var>'. $row['scale_table_home'].'</var>
        <div style="position:relative" class="noshowForUser"></div>
    </td>
</tr>';


    $i++;
}

$tableContent .= '</tbody></table>';

// Добавляем JavaScript для обработки атрибута
$tableContent .= '

<script>
document.addEventListener("DOMContentLoaded", function() {
    document.querySelectorAll("[data-noindex]").forEach(function(element) {
        element.setAttribute("data-noindex", "true");
    });
});
</script>';
     
			
        $tableContent .='<div style="font-size: .8em; text-align:left; color:red;">     Минимальная стоимость работ в [[!city:П]] - 1000 рублей.                          </div>';
        $tableContent .= '<p class="minprice" style="color:red;">   Выезд мастера вечером после 21.00 плюс 1000 рублей к цене работ.                        </p>';
        $tableContent .= '<p class="minprice" style="color:red;">   Закупка и доставка материалов на объект осуществляется - бесплатно.                     </p>';
        $tableContent .= '<p class="minprice" style="color:red;">   Круглосуточный вызов мастера - 24 часа дежурный диспетчер - 8-922-335-2000.             </p>';
        $tableContent .= '<p class="minprice" style="color:red;">   Примечание: цены указаны за работы без учета стоимости запчастей и расходных материалов.    </p>';
        $tableContent .= '<p class="minprice" style="color:red;">   ВНИМАНИЕ: окончательную стоимость работ мастер определяет на месте после визуального осмотра.   </p>'; 
        
        
        $data['tableContent'] = $tableContent;
        $data['innerTableRows'] = $innerTable;


        saveCache($type, $id, $data);
    }
	
    return $data;
}

function getTVByPageId($id, $discountMult = 1) 

{
    global $admin_db;
    global $adminCdb;
    $data = getActualCacheData(2, $id);


    if ($data === false) { //Кэш устарел, либо его нет
        $q = mysql_query("SELECT pages.* from assident INNER JOIN pages ON assident.id_as_page=pages.id_page where assident.id_page=$id AND `type_page` = 'usual' ORDER BY `pages`.`name_page` ASC", $admin_db);
        $assidents = array();
        while ($assident = mysql_fetch_assoc($q)) 
        
        {
            $assidents[] = $assident;
        }
        
        $data['assident'] = $assidents;

        $q = mysql_query("SELECT pages.* from assident INNER JOIN pages ON assident.id_as_page=pages.id_page where assident.id_page=$id AND `type_page` = 'useful'", $admin_db);
        $assidents = array();
        while ($assident = mysql_fetch_assoc($q)) 
        
        {
            $assidents[] = $assident;
        }
        
        $data['useful-pages'] = $assidents;
        
        
        $q = mysql_query("SET sql_mode = ''", $admin_db);
           $q = mysql_query("SELECT article.*,article_gallery.url as image 
from article 
INNER JOIN pages_article ON article.id=pages_article.id_article
LEFT JOIN article_gallery ON article_gallery.id_article=article.id
where pages_article.id_page=$id
GROUP BY article.id", $admin_db);
        
        $articles = array();
        while ($article = mysql_fetch_assoc($q)) 
        
        {
            $articles[] = $article;
        }
        
        $data['articles'] = $articles;


        saveCache(2, $id, $data);
    }
    return $data;
}

function getTVBySiteId($siteId) 

{
    global $admin_db;
    global $adminCdb;
    $data = getActualCacheData(1, $siteId);


//TODO: пытаемся достать всё из кэша
if ($data === false) { // Кэш устарел, либо его нет

    // Первый запрос: информация о сайте
    $stmt1 = $conn->prepare("SELECT * FROM `site` WHERE id_site = ?");
    if (!$stmt1) {
        die('<error>Ошибка подготовки 1‑го запроса: ' . htmlspecialchars($conn->error) . '</error>');
    }
    $stmt1->bind_param('i', $siteId);
    if (!$stmt1->execute()) {
        die('<error>Ошибка выполнения 1‑го запроса: ' . htmlspecialchars($stmt1->error) . '</error>');
    }
    $result1 = $stmt1->get_result();
    while ($row = $result1->fetch_assoc()) {
        $data['cityId'] = $row['id_city'];
        $data['siteType'] = $row['id_tip_site'];
        $data['name_site'] = $row['name_site'];
        $data['site_url'] = $row['site_url'];
        $data['name_town'] = $row['name_town'];
        $data['region'] = $row['region'];
        $data['address'] = $row['address'];
        $data['yandex_verifi'] = $row['yandex_verifi'];
        $data['yandex_informer'] = $row['yandex_informer'];
        $data['yandex_counter'] = $row['yandex_counter'];
        $data['vk_AppId'] = $row['vk_AppId'];
    }
    $stmt1->close();

    // Второй запрос: основной сайт для типа
    $stmt2 = $conn->prepare(
        "SELECT site_url, mail_ru_counter, id_site, yandex_counter
        FROM `site`
        WHERE id_tip_site = ? AND id_city = 1"
    );
    if (!$stmt2) {
        die('<error>Ошибка подготовки 2‑го запроса: ' . htmlspecialchars($conn->error) . '</error>');
    }
    $stmt2->bind_param('i', $data['siteType']);
    if (!$stmt2->execute()) {
        die('<error>Ошибка выполнения 2‑го запроса: ' . htmlspecialchars($stmt2->error) . '</error>');
    }
    $result2 = $stmt2->get_result();
    while ($row = $result2->fetch_assoc()) {
        $url = str_replace("http://", "", $row['site_url']);
        $url = str_replace("/", "", $url);
        $data['mainSiteUrl'] = $url;
        // $data['mail_ru_counter'] = $row['mail_ru_counter'];
        // $data['mail_ru_counter'] = '';
        $data['mainsiteId'] = $row['id_site'];
    }
    $stmt2->close();

    // Третий запрос: сайты в других городах
    $stmt3 = $conn->prepare(
        "SELECT `site`.site_url, `site`.id_site, `city`.name_city
        FROM `site`
        LEFT JOIN `city` ON `site`.id_city = `city`.id_city
        WHERE id_tip_site = ? AND site.deleted = 0"
    );
    if (!$stmt3) {
        die('<error>Ошибка подготовки 3‑го запроса: ' . htmlspecialchars($conn->error) . '</error>');
    }
    $stmt3->bind_param('i', $data['siteType']);
    if (!$stmt3->execute()) {
        die('<error>Ошибка выполнения 3‑го запроса: ' . htmlspecialchars($stmt3->error) . '</error>');
    }
    $result3 = $stmt3->get_result();
    $sites = array();
    while ($row = $result3->fetch_assoc()) {
        $sites[] = $row;
    }
    $data['otherCitiesSites'] = $sites;
    $stmt3->close();
}


        $q = mysql_query("SELECT * FROM `popular_services` where tip_site_id=" . $data['siteType'], $admin_db);
        $popularServices = array();
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $popularServices[] = $row;
        }
        
        $data['popularServices'] = $popularServices;


        $q = mysql_query("SELECT * FROM `advantages`", $admin_db);
        
        $advantages = array();
        
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $advantages[] = $row;
        }

        $data['advantages_mobile'] = $advantages;

         //echo '<pre>'; print_r($data); echo '</pre>';


        //Достаем инфу по сайтам нашего города	

        $q = mysql_query("SELECT s.site_url as url,t.useful_name as text,t.service_name as serviceName,t.id_tip_site  FROM `site` as s inner join `tip_site` as t ON s.id_tip_site = t.id_tip_site where   s.deleted = 0 and s.id_city=" . $data['cityId'], $admin_db);

        $menu_items = array();
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            if ($row['id_tip_site'] == 1)
                $data['santechnicUrl'] = $row['url'];
            
            if ($row['id_tip_site'] == 2)
                $data['electricUrl'] = $row['url'];

            if ($row['id_tip_site'] == 3)
                $data['muzUrl'] = $row['url'];
            
                
            if ($row['id_tip_site'] == 6)
            $data['kompUrl'] = $row['url'];
            //if ($row['id_tip_site'] == 5)
            //$data['brigadaUrl'] = $row['url'];
            //if (($row['id_tip_site'] != 5) && ($row['id_tip_site'] != 6)) 
            
            {
            $menu_items[] = $row;
            }    
           
        }

       $data['remontKvartirUrl'] = '';
        
        $data['menu.useful-info'] = $menu_items;

         //echo '<pre>'; print_r($data); echo '</pre>';

        //Достаем данные по типу сайта
        
        $q = mysql_query("SELECT headerallservices,rbanner,lbanner,cbanner,header_text,zp_count,vacancy_text,short_name,color,bgcolor,bordercolor,bghovercolor,

        service_name,tblhovercolor,name_arr,favicon,img_banner,table_header,advantages,reformal 

        FROM `tip_site` 

        where id_tip_site='" . $data['siteType'] . "'", $admin_db);
        
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['headerallservices'] = $row['headerallservices'];
            $data['lbannerType'] = $row['lbanner'];
            $data['rbannerType'] = $row['rbanner'];
            $data['cbannerType'] = $row['cbanner'];
            $data['header_text'] = $row['header_text'];
            $data['vacancy_text'] = $row['vacancy_text'];
            $data['zp_count'] = $row['zp_count'];
            $data['short_name'] = $row['short_name'];
            $data['advantages'] = $row['advantages'];
            
            $data['color'] = $row['color'];
            $data['bgcolor'] = $row['bgcolor'];
            $data['bordercolor'] = $row['bordercolor'];
            $data['bghovercolor'] = $row['bghovercolor'];
            $data['name_arr'] = $row['name_arr'];
            $data['service_name'] = $row['service_name'];
            $data['tblhovercolor'] = $row['tblhovercolor'];
            $data['current_id_tip_site'] = $data['siteType'];
            $data['favicon'] = $row['favicon'];
            $data['logo-img'] = $data['site_url'] . $row['img_banner'];
            $data['table_header'] = $row['table_header'];

        }


        $gallery_tip_site = array();
        $q = mysql_query("SELECT * FROM `tip_site_gallery` WHERE `id_tip_site` = '" . $data['siteType'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
            
        $gallery_tip_site[] = $row;
        $data['tip-site-slider'] = $gallery_tip_site;
 
        
        $q = mysql_query("SELECT id_tip_site,vacancy_text,img_banner,zp_count FROM `tip_site`", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
        
        {
            $data['vacancy']['vc_' .$row['id_tip_site']]['vacancy_text'] = $row['vacancy_text'];
            $data['vacancy']['vc_' .$row['id_tip_site']]['zp_count'] = $row['zp_count'];
            $data['vacancy']['vc_' .$row['id_tip_site']]['vacancy_banner'] = $row['img_banner'];
            $data['vacancy']['vc_' .$row['id_tip_site']]['id_tip_site'] = $row['id_tip_site'];
        }


        //Достаем кастомные поля

        $q = mysql_query("SELECT `tvs`.`name` ,`tvs_val`.`value`,`tvs`.`id`  FROM `tvs` LEFT JOIN `tvs_val` on `tvs`.`id` = `tvs_val`.`tvs_id`", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data[$row['name']] = $row['value'];
        }

        //Получаем информацию по баннеру по типу сайта для каждого баннера

        $q = mysql_query("SELECT * FROM `tip_site` where id_tip_site='" . $data['lbannerType'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['lbanneremail'] = $row['email'];
            $data['lbannerimg'] = $row['img_banner'];
            $data['lbanneralt'] = $row['banner_alt'];
            $data['lbannerunder'] = $row['under_banner'];
            $data['lbannerservice_name'] = $row['service_name'];
        }


        $q = mysql_query("SELECT * FROM `tip_site` where id_tip_site='" . $data['rbannerType'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['rbanneremail'] = $row['email'];
            $data['rbannerimg'] = $row['img_banner'];
            $data['rbanneralt'] = $row['banner_alt'];
            $data['rbannerunder'] = $row['under_banner'];
            $data['rbannerservice_name'] = $row['service_name'];
        }
        
        $q = mysql_query("SELECT * FROM `tip_site` where id_tip_site='" . $data['cbannerType'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['cbanneremail'] = $row['email'];
            $data['cbannerimg'] = $row['img_banner'];
            $data['cbanneralt'] = $row['banner_alt'];
            $data['cbannerunder'] = $row['under_banner'];
            $data['cbannerservice_name'] = $row['service_name'];
        }
//Получаем урлы дял баннеров , по типу баннера и городу

        $q = mysql_query("SELECT site_url FROM `site` where  deleted = 0 and id_tip_site='" . $data['lbannerType'] . "' AND id_city='" . $data['cityId'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['lbannerurl'] = $row['site_url'];
        }
        
            $q = mysql_query("SELECT site_url FROM `site` where deleted = 0 and id_tip_site='" . $data['rbannerType'] . "' AND id_city='" . $data['cityId'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['rbannerurl'] = $row['site_url'];
        }

            $q = mysql_query("SELECT site_url FROM `site` where deleted = 0 and id_tip_site='" . $data['cbannerType'] . "' AND id_city='" . $data['cityId'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $data['cbannerurl'] = $row['site_url'];
        }


//Получаем всю информацию по городу
        $q = mysql_query("SELECT * FROM `city` where id_city='" . $data['cityId'] . "'", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
           
            $data['phone'] = $row['phone'];
            $data['phone2'] = $row['phone2'];
            $data['phone3'] = $row['phone3'];
            $data['names_city'] = $row['names_city'];
            $data['officehoursstart'] = $row['officehours-start'];
            $data['officehoursend'] = $row['officehours-end'];
            $data['officehours'] = $row['officehours'];
            $data['salepleasebanner'] = $row['salepleasebanner'];
            $data['fineprint'] = $row['fineprint'];
            $data['flash_phone'] = $row[''];
            $data['time_zone'] = $row['time_zone'];
            $data['yandex_id'] = $row['yandex_id'];
            $data['attention'] = $row['attention'];
            $data['note'] = $row['note'];
            $data['warning'] = $row['warning'];
            $data['occasion'] = $row['occasion'];
        
             $data['icq'] = $row[''];
             $data['kompservice'] = $row[''];
             $data['gismeteoInformer'] = $row[''];
             $data ['tableHeader'] = $row['tableHeader'];
                    
        }
       
       
        $leftMenu = array();
        $q = mysql_query("SELECT * FROM `city_left_menu` WHERE `id_city`='" . $data['cityId'] . "' ORDER BY `order` DESC", $admin_db); 
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $leftMenu[] = array('url' => $row['link'], 'serviceName' => $row['name']);
        }

        $data['leftMenu'] = $leftMenu;


#region Banners 

        $banners = array();

        $banner = array('href' => $data['lbannerurl'], 'src' => $data['lbannerimg'], 'alt' => $data['lbanneralt'], 'under' => $data['lbannerunder'], 'phone' => $data['phone'], 'icq' => $data['icq'], 'email' => $data['lbanneremail'], 'service' => $data['lbannerservice_name']);
        $banners['lbanner'] = $banner;

        $banner = array('href' => $data['rbannerurl'], 'src' => $data['rbannerimg'], 'alt' => $data['rbanneralt'], 'under' => $data['rbannerunder'], 'phone' => $data['phone'], 'icq' => $data['icq'], 'email' => $data['rbanneremail'], 'service' => $data['rbannerservice_name']);
        $banners['rbanner'] = $banner;

        $banner = array('href' => $data['cbannerurl'], 'src' => $data['cbannerimg'], 'alt' => $data['cbanneralt'], 'under' => $data['cbannerunder'], 'phone' => $data['phone'], 'icq' => $data['icq'], 'email' => $data['cbanneremail'], 'service' => $data['cbannerservice_name']);
        $banners['cbanner'] = $banner;

        foreach ($banners as $bkey => $banner)
            foreach ($banner as $vkey => $v)
                $data["header.$bkey.$vkey"] = $v;

#endregion
#region Menu.Services
        
        $menu_items = array();
        
        $q = mysql_query("SELECT `url_page` as `url`, `name_page` as `text`,`index_page` as `noindex`,`id_page`, `keyword` from `pages` where home IN (0,2) and menu_page=0 and `id_site` = ".$data['mainsiteId']. "   ORDER BY `pages`.`views` DESC", $admin_db);
        while ($q && $row = mysql_fetch_assoc($q))
            $menu_items[] = $row;
        if ($q)
            mysql_free_result($q);
        
        $data['menu.services'] = $menu_items;

         //echo '<pre>'; print_r($data); echo '</pre>';

#endregion


        $reviews = array();
        $q = mysql_query("SELECT `club_members`.`fullname`,`review`.* FROM `review` INNER JOIN `club_members` on `review`.`club_member_id` = `club_members`.`id` WHERE `review`.published = 1 order by id DESC");
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $reviews[] = $row;
        }
       
        $data['reviews'] = $reviews;


        $slow = 23;
        $menu_items = array();
        $q = mysql_query("SELECT `date_news` as `date`, `text_news` as `text`, `attention_news` as `attention`, `noindex_news` as `noindex` from `news` WHERE FIND_IN_SET( `auditory_news`) and `id_site` = $siteId ORDER BY date_news DESC LIMIT 0,$slow", $admin_db);

        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            if (isset($row['date'])) 
            {
                $timestamp_now = strtotime($row['date']); //$timestamp_tomorrow = strtotime('+1 day', $timestamp_now); // или '+1 day' или 'now +1day' или 
                $date_for_me = date('d.m.Y', $timestamp_now);
                $row['date'] = $date_for_me;
            }
            $menu_items[] = $row;
        }

        if ($q)
            mysql_free_result($q);
        
        
            $data['news'] = $menu_items;


        $q = mysql_query("SELECT MAX(tag) as tag,SUM(`pages`.views) as cnt FROM `tag` 

INNER JOIN `page_tag` on `tag`.`id` = `page_tag`.`id_tag`
INNER JOIN `pages` ON `page_tag`.`id_page` = `pages`.`id_page`
where `pages`.`id_site` = " . $data['mainsiteId'] . "
GROUP BY `tag`.`id`
ORDER BY cnt DESC ", $admin_db);
        $tagsList = array();
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $tagsList[] = $row['tag'];
        }

        $data['tagsList'] = $tagsList;
        
        if( $curl = curl_init() ) 
            
        {
            curl_setopt($curl, CURLOPT_URL, 'https://api.vk.com/method/groups.getById?group_id=33947938&fields=members_count&version=5.78&access_token=9fa530a99fa530a99fa530a9b99ff002b699fa59fa530a9c485a52dc14103d833f77c20');
            curl_setopt($curl, CURLOPT_RETURNTRANSFER,true);
   
   
                //  $out = curl_exec($curl);
                //  $out = json_decode($out);
                //  var_dump($out);
                //  die();
                //  $data['vkCount'] = $out->response[0]->members_count;
                //  curl_close($curl);
        
            }


        $q = mysql_query("SELECT table_pages.text_table_home , table_pages.price_table_home 
				FROM table_pages 				
				INNER JOIN `site` 
				ON `table_pages`.`id_site` = `site`.`id_site` 
				WHERE `table_pages`.id_site IN (1,13,14,15) 
				ORDER BY TRIM(text_table_home) ");
        
        $allServices = array();
        while ($q && $row = mysql_fetch_assoc($q)) 
        
        {
            $srow = array('text_table_home' => strip_tags($row['text_table_home']), 'price_table_home' => $row['price_table_home']);
            $allServices[] = $srow;
        }
        
        $data['allServices'] = $allServices;

        
        saveCache(1, $siteId, $data);
    }

 
    $data['docxFile'] =getCopyPdf('oferta_',$siteId,$data,'oferta.html');
    $data['politicsFile'] =getCopyDoc('politics_',$siteId,$data,'politics.docx');
    $data['soglFile'] =getCopyDoc('sogl_',$siteId,$data,'sogl.docx');


    return $data;

     //echo '<pre>'; print_r($data); echo '</pre>';
    
}
<br />
<b>Warning</b>:  session_start(): Cannot send session cookie - headers already sent by (output started at /var/www/fastuser/data/www/electric-doma.ru/utils/CacheManager.php:44) in <b>/var/www/fastuser/data/www/electric-doma.ru/get-tvs.php</b> on line <b>30</b><br />
<br />
<b>Warning</b>:  session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/fastuser/data/www/electric-doma.ru/utils/CacheManager.php:44) in <b>/var/www/fastuser/data/www/electric-doma.ru/get-tvs.php</b> on line <b>30</b><br />
<br />
<b>Fatal error</b>:  Call to undefined function getTVBySiteId() in <b>/var/www/fastuser/data/www/electric-doma.ru/get-tvs.php</b> on line <b>49</b><br />