sharky_design
Registered
Как да сложа емотикони в коментарите ? Ако искате ще ви дам и кода за коментари 
Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
<?php
$query = mysql_query("SELECT * FROM `comment` WHERE `article`='$id'") or die(mysql_error());
while($raw = mysql_fetch_array($query)){
$rep=str_replace(' Shocked','<img src="images/icon_eek.gif">',$raw['comment']);
$rep=str_replace(' оoops','<img src="images/icon_redface.gif">',$rep);
echo "
<tr>
<td class=\"comment\" style=\"border-bottom: 1px solid #000000\">От $raw[date] | <span class=\"style2\">$raw[author]</span><br>
$rep</td>
</tr>";
}
?>
<?php
include "functions.php";
ob_start();
capital();
$id = (int)$_GET['id'];
$runq = mysql_query("SELECT * FROM `songs` WHERE id='$id'");
$row = mysql_fetch_assoc($runq);
if($id != $row[id]) {
header("Location: index.php");
}
?>
<div id="menus_c">
<?
$runq = mysql_query("SELECT * FROM `songs` WHERE id='$id'");
$row = mysql_fetch_assoc($runq);
$pregled = $row[visited]+1;
$rq = mysql_query("UPDATE `songs` SET visited='$pregled' WHERE id='$id'")
?>
<div class="cc_header"> Преглед на песен</div>
<div class="cc_body" style="padding-left: 15px;">
<?php
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; text-align: center;
color: purple; width: 78px; font-weight: bold; font-size: 12px; margin-top: 5px; float: left;'> Песен </div>";
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; color: purple; width: 390px;
font-weight: bold; font-size: 12px; margin: 5px 0 0 15px; float: left;'> $row[thumb]";
if($_SESSION['userinfo']['rank']==3) {
echo "<a href='del_song_direct.php?id=$row[id]'> - DEL</a>";
}
echo "</div>";
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; text-align: center;
color: purple; width: 78px; font-weight: bold; font-size: 12px; margin-top: 5px; float: left;'> Качил </div>";
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; color: purple; width: 390px;
font-weight: bold; font-size: 12px; margin: 5px 0 0 15px; float: left;'> $row[add_by] </div>";
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; text-align: center;
color: purple; width: 78px; font-weight: bold; font-size: 12px; margin-top: 5px; float: left;'> Прегледан </div>";
echo "<div style='font-family: ".'Verdana'."; border: 1px solid #AAA; padding: 4px; color: purple; width: 390px;
font-weight: bold; font-size: 12px; margin: 5px 0 0 15px; float: left;'> $row[visited] пъти. </div>";
?>
<div style='font-family: "Verdana"; border: 1px solid #AAA; padding: 4px; text-align: center; height: 23px; line-height: 23px;
color: purple; width: 78px; font-weight: bold; font-size: 12px; margin-top: 5px; float: left;'> Прослушай </div>
<div style='font-family: "Verdana"; border: 1px solid #AAA; padding: 4px; color: purple; width: 390px;
font-weight: bold; font-size: 12px; margin: 5px 0 0 15px; float: left;'> <object type="application/x-shockwave-flash" data="player/player.swf" id="audioplayer2" height="24" width="290" style="margin-left: 1px;">
<param name="movie" value="player/player.swf">
<param name="FlashVars" value="playerID=audioplayer2&soundFile=<?=$row['url'];?>">
<param name="quality" value="high">
<param name="menu" value="true">
<param name="wmode" value="transparent">
</object> </div>
<div style="clear: both;"> </div>
<a href="<?=$row[url];?>"> <img src="icons/download.png" alt="" border="0" style="margin-left: 200px;"/> </a>
<div style="background: #e7cdff; width: 490px; border: 1px dashed #7500df; padding: 5px; text-align: center;"> Коментари ...</div> <br />
<?
if($_SESSION['logged']!=true) {
echo "
Трябва да се регистриран в сайта за да пишете ! <br />";
}
else {
?>
<form method="post" action="">
<textarea name="comment" style="width: 497px; height: 60px;"> </textarea>
<input type="submit" name="post" class="submit" value="Коментирай" />
</form>
<?
}
if($_POST['post']) {
$comment = htmlspecialchars($_POST['comment']);
$avtor = $_SESSION['userinfo']['username'];
if(strlen($comment)<5) {
echo "<span> Прекалено кратък коментар!</span>";
}
else {
$runq = mysql_query("INSERT INTO `comments` (song_id, `desc`, avtor) VALUES ('$id', '$comment', '$avtor')");
echo '<meta http-equiv="refresh" content="0;url=preview.php?id='.$id.'">';
}
}
?>
<br />
<?
$rq = mysql_query("SELECT * FROM comments WHERE song_id='$id'");
$broi = mysql_num_rows($rq);
$limit = 5;
if((int)$_GET['page']>0) {
$page = (int)$_GET['page'];
}
else {
$page = 0;
}
$maxpage = ceil($broi/$limit);
$runq = mysql_query("SELECT * FROM comments WHERE song_id='$id' ORDER BY id DESC LIMIT ".$limit*$page.", ".$limit."");
while($row = mysql_fetch_array($runq)) {
echo '<div style="background: #f2b8ff; width: 490px; border: 1px solid #CCC; padding: 5px; margin-top: 5px;"> '.$row[avtor].' каза:';
if($_SESSION['userinfo']['rank']==3) {
echo " - <a href='del_comment.php?id=$row[id]'> DEL </a>";
}
echo '<br /> '.$row[desc].' </div>';
}
echo "<hr />";
$run_q = mysql_query("SELECT * FROM `comments` WHERE song_id='$id'");
$data = mysql_fetch_assoc($run_q);
if($data['song_id']==$id) {
for($i=0;$i<$maxpage;$i++) {
echo "[<a href='preview.php?id=$id&page=$i'> ".($i+1)." </a>] ";
}
}
?>
<br />
</div>
<div class="cc_footer"> </div>
</div>
<?
include "right_menus.php";
footer();
?>