<?php


ini_set('display_errors', 0);
ini_set('memory_limit', "2048M");
if ($_SESSION['dostup'] != 'a' && $_SESSION['dostup'] != 'e' && $_SESSION['dostup'] != 'c')
    header('Location: /login/'); // && $dostup!='m'
/*  ----------------------------------------------------------------------
    14.12.2022
    Читаем заметки
----------------------------------------------------------------------  */



$massiv = \DB::getAll("SELECT * FROM `s2` WHERE `status`=1 ORDER BY RAND() LIMIT 100");


for ($i = 0; $i < count($massiv); $i++) {
    $tovarinfo = \DB::getRow("SELECT `title`, `linkimg`, `donor` FROM `tovar` WHERE `id`=? LIMIT 1", $massiv[$i]['tovar_id']);
    $massiv[$i]['txt'] = $tovarinfo['title'];
    $massiv[$i]['donor'] = $tovarinfo['donor'];
    $massiv[$i]['img2'] = $tovarinfo['linkimg'];
    $massiv[$i]['img'] = \DB::getValue("SELECT `filename` FROM `tovar_img` WHERE `tovar_id`=? LIMIT 1", $massiv[$i]['tovar_id']);
    if ($massiv[$i]['img'])
        $massiv[$i]['img'] = "/img/tk-ligat.ru/tovar/" . \DB::getValue("SELECT `filename` FROM `tovar_img` WHERE `tovar_id`=? LIMIT 1", $massiv[$i]['tovar_id']) . '.jpg';
    else
        $massiv[$i]['img'] = $massiv[$i]['img2'];
}

//print_r($massiv);
$smarty->assign('massiv', $massiv);

$cats = \DB::getAll("SELECT * FROM `tovar_category` WHERE `status`=1 ORDER BY `title`");
$smarty->assign('cats', $cats);


$smarty->assign('kolvo', \DB::getAll("SELECT COUNT(*) FROM `s2` WHERE `status`=1")[0]['COUNT(*)']);

?>