Файл: users/cabinet/components/04_videos.php
Строк: 19
<?php
$sql = "SELECT `VIDEOS`.`ID`,`VIDEOS`.`ID_DIR` FROM `VIDEOS` LEFT JOIN `VIDEOS_DIR` ON (`VIDEOS_DIR`.`ID` = `VIDEOS`.`ID_DIR` OR `VIDEOS_DIR`.`ID_DIR` = `VIDEOS`.`ID_DIR`) AND `VIDEOS`.`USER_ID` = '".$user['ID']."' WHERE `PRIVATE` = '0' GROUP BY `VIDEOS`.`ID`";
$count = DB::GET_STRING_ALL($sql);
$video_i = 0;
WHILE ($count->FETCH()){ $video_i++; }
$background = "#63BAFF";
$shadow = "#4181B4";
ECHO "<a href='/modules/?path=videos§ion=users&id=".$user['ID']."'><div class='list-menu hover'>";
ECHO "<span class='menu-icons-small' style='background-color: ".$background.";
text-shadow: 1px 1px ".$shadow.",
2px 2px ".$shadow.",
3px 3px ".$shadow.",
4px 4px ".$shadow.",
5px 5px ".$shadow.",
6px 6px ".$shadow.",
7px 7px ".$shadow.",
8px 8px ".$shadow.",
9px 9px ".$shadow.",
10px 10px ".$shadow.",
11px 11px ".$shadow.",
12px 12px ".$shadow.",
13px 13px ".$shadow.",
14px 14px ".$shadow.",
15px 15px ".$shadow.",
16px 16px ".$shadow.",
17px 17px ".$shadow.",
18px 18px ".$shadow.",
19px 19px ".$shadow.",
20px 20px ".$shadow.",
21px 21px ".$shadow.",
22px 22px ".$shadow.",
23px 23px ".$shadow.",
24px 24px ".$shadow.",
25px 25px ".$shadow.",
26px 26px ".$shadow.",
27px 27px ".$shadow.",
28px 28px ".$shadow.",
29px 29px ".$shadow.",
30px 30px ".$shadow.";
'>";
ECHO "".ICONS('film', 10, 'fa-fw')."";
ECHO "</span> ";
ECHO "<span class='menu-icons-optimize'>".LG('Видео')." <span class='count'>".$video_i."</span></span>";
ECHO "</div></a>";
?>