39 lines
1.5 KiB
PHP
Executable File
39 lines
1.5 KiB
PHP
Executable File
<?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(*)']);
|
|
|
|
?>
|