<div style='width: 600px; margin: 0 auto;'>
<?php
if(isSet($_GET['mode'])) {
$mode = (int)$_GET['mode'];
$mode = str_replace ("-", "", $mode);
} else {
$mode = "";
}
if(in_array($mode, array('1'))) {
$mode = $mode;
} else {
$mode = '';
}
switch($mode){
case "1";
if(isSet($_GET['id'])) {
$id = (int)$_GET['id'];
$id = str_replace ("-", "", $id);
} else {
$id = "";
}
$query = mysql_query("SELECT * FROM `music` WHERE id='{$id}';") or die(mysql_error());
if ((mysql_num_rows($query) > 0)&& ($id != NULL)) {
while($row = mysql_fetch_array($query)) {
mysql_query ("UPDATE `music` SET views=views+1 WHERE id='{$id}';") or die(mysql_error());
$id = $row['id'];
$author = $System->user($row['uid']);
$title = $row['title'];
$etiketi= $System->tags($row['tags']);
$date = date("Y-m-d / h:m", $row['date']);
if($row['locked'] == 0) {
$lock = "oтключена";
} else {
$lock = "заключена";
}
if($row['image'] == NULL) {
$picture = "pictures/default.jpg";
} else {
$picture = $row['image']."";
}
echo "Име: {$title} <br />Добавена на: {$date}<br />Добавена от: {$author}<br />
<a href=\"../Music\">Върнете се назад за още Хип-Хоп звук от България</a><br />
<img src=\"{$picture}\" alt=\"\" height=\"300px\" width=\"535px\" /> <br />
<embed src=\"player.swf\" bgcolor=\"undefined\" allowscriptaccess=\"always\" allowfullscreen=\"false\" flashvars=\"file={$row['url']}&autostart=false&showeq=true&showstop=true\" height=\"19\" width=\"535\"><br />
Етикети: {$etiketi}<br /><br /><br /><br />";
if($row['locked'] == 0) {
echo "
<script>
function emoticon(text) {
var txtarea = document.form1.message;
text = ' ' + text;
if (txtarea.createTextRange && txtarea.caretPos) {
var caretPos = txtarea.caretPos;
caretPos.text = caretPos.text.charAt(caretPos.text.length - 1) == ' ' ? caretPos.text + text + ' ' : caretPos.text + text;
txtarea.focus();
} else {
txtarea.value += text;
txtarea.focus();
}
}
</script>
<form method=\"post\" name=\"form1\">
<a href=\"javascript:emoticon(':beer:');\"><img src=\"smilies/68.gif\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':alien:');\"><img src=\"smilies/alien.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':angry:');\"><img src=\"smilies/angry.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':blink:');\"><img src=\"smilies/blink.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':blush:');\"><img src=\"smilies/blush.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':cheerful:');\"><img src=\"smilies/cheerful.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':cool:');\"><img src=\"smilies/cool.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':cwy:');\"><img src=\"smilies/cwy.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':devil:');\"><img src=\"smilies/devil.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':dizzy:');\"><img src=\"smilies/dizzy.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':ermm:');\"><img src=\"smilies/ermm.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':getlost:');\"><img src=\"smilies/getlost.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':grin:');\"><img src=\"smilies/grin.png\" border=\"0\" ></a><br />
<a href=\"javascript:emoticon(':happy:');\"><img src=\"smilies/happy.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':heart:');\"><img src=\"smilies/heart.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':kissing:');\"><img src=\"smilies/kissing.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':laughing:');\"><img src=\"smilies/laughing.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':ninja:');\"><img src=\"smilies/ninja.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':pinch:');\"><img src=\"smilies/pinch.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':pouty:');\"><img src=\"smilies/pouty.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':sad:');\"><img src=\"smilies/sad.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':shocked:');\"><img src=\"smilies/shocked.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':sick:');\"><img src=\"smilies/sick.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':sideways:');\"><img src=\"smilies/sideways.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':silly:');\"><img src=\"smilies/silly.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':sleeping:');\"><img src=\"smilies/sleeping.png\" border=\"0\" ></a><br />
<a href=\"javascript:emoticon(':smile:');\"><img src=\"smilies/smile.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':tongue:');\"><img src=\"smilies/tongue.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':unsure:');\"><img src=\"smilies/unsure.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':w00t:');\"><img src=\"smilies/w00t.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':wassat:');\"><img src=\"smilies/wassat.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':whistling:');\"><img src=\"smilies/whistling.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':wink:');\"><img src=\"smilies/wink.png\" border=\"0\" ></a>
<a href=\"javascript:emoticon(':wub:');\"><img src=\"smilies/wub.png\" border=\"0\" ></a>
<br />
<label for=\"username\">Потребител *</label> <input type=\"text\" name=\"username\" id=\"username\" /><br />
<textarea name=\"comment\" id=\"message\" cols=\"85\" rows=\"7\"></textarea><br>
<p>Писането на КИРИЛИЦА е задължително. Коментар на ЛАТИНИЦА ще бъде коригирван!</p><br />
<p>Обидите към друг потребител са ЗАБРАНЕНИ, както и обидите към конкретен изпълнител.</p><br />
<input type='submit' name='comment_submit' value='Коментирай'>
</form>
";
if (isSet($_POST['comment_submit'])) {
$username = (empty($_POST['username'])) ? '' : $_POST['username'];
$comment = (empty($_POST['comment'])) ? '' : $_POST['comment'];
$time = time();
if ($comment!=NULL) {
if ($username!=NULL) {
mysql_query("INSERT INTO `comments` SET item='{$id}', comment='{$comment}', avtor='{$username}', time='{$time}'") or die (mysql_error());
echo "Коментара е добавен успешно.";
} else {
echo "Не сте въвели потребител.";
}
} else {
echo "Не сте написали коментар.";
}
}
} else {
echo "Тази песен не може да бъде коментирана.";
}
$query_com = mysql_query("SELECT * FROM `comments` WHERE item='{$id}';")or die(mysql_error());
$num = mysql_num_rows($query_com);
echo "<br />Коментари: {$num}<br /><table>";
while($row_com = mysql_fetch_array($query_com)) {
$date_com = date("Y-m-d / h:m:s", $row_com['time']);
$comment = $System->emot($row_com['comment']);
echo "
<tr>
<td width=\"150px\" style=\"border: 1px solid #f5f5f5;\"><b>{$row_com['avtor']}</b><br />({$date_com})</td>
<td style=\"border: 1px solid #f5f5f5;\">{$comment}</td>
</tr>";
}
echo "</table>";
}
} else {
echo "Песента не съществува..";
}
echo '
';
break;
default;
$query = mysql_query("SELECT title, id, uid, views, date, image FROM `music` ORDER BY id DESC;")or die(mysql_error());
if(mysql_num_rows($query) > 0) {
echo "<table style='border: 1px solid #f5f5f5;'>
<tr>
<td style='border: 1px solid #f5f5f5;'>#</td>
<td width=\"120px\" style='border: 1px solid #f5f5f5;'>Снимка</td>
<td width=\"250px\" style='border: 1px solid #f5f5f5;'>Заглавие</td>
<td width=\"60px\" style='border: 1px solid #f5f5f5;'>Коментари</td>
<td width=\"60px\" style='border: 1px solid #f5f5f5;'>Слушана</td>
</td>";
$i='0';
while($row = mysql_fetch_array($query)) {
$title = $row['title'];
$title_url = $System->ctol__($title);
$num_com = $System->numcom($row['id']);
$i++;
if($row['image'] == NULL) {
$picture = "pictures/default.jpg";
} else {
$picture = $row['image']."";
}
echo "
<tr>
<td>{$i}</td>
<td style='border: 1px solid #f5f5f5;'><img src=\"{$picture}\" width=\"120px\" height=\"90px\" alt=\"\" /></td>
<td><a href=\"index.php?mode=1&id={$row['id']}\" title=\"{$title}\">{$title}</a></td>
<td style='text-align: center;'>{$num_com}</td>
<td style='text-align: center;'>{$row['views']}</td>
</tr>";
}
$i='0';
echo "</table>";
} else {
echo "Все още няма добавени песни.";
}
break;
}
?>