Файл: users/cabinet/components/03_music.php
Строк: 21
<?php
$sql = "SELECT `MUSIC`.`ID`,`MUSIC`.`ID_DIR` FROM `MUSIC` LEFT JOIN `MUSIC_DIR` ON (`MUSIC_DIR`.`ID` = `MUSIC`.`ID_DIR` OR `MUSIC_DIR`.`ID_DIR` = `MUSIC`.`ID_DIR`) AND `MUSIC`.`USER_ID` = '".$user['ID']."' WHERE `PRIVATE` = '0' GROUP BY `MUSIC`.`ID`";
$count = DB::GET_STRING_ALL($sql);
$music = 0;
WHILE ($count->FETCH()){ $music++; }
IF ($music > 5000){
$music_count = "5000+";
}ELSE{
$music_count = $music;
}
$background = "#FF665B";
$shadow = "#D14A41";
ECHO "<a href='/modules/?path=music§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('music', 12, 'fa-fw')."";
ECHO "</span> ";
ECHO "<span class='menu-icons-optimize'>".LG('Музыка')." <span class='count'>".$music."</span></span>";
ECHO "</div></a>";
?>