<?
session_start();
ob_start();
include "config.php";
$username = $_SESSION['username'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
<title>Music Archiv - Музикалния Архив на България! - Вход</title>
<link rel="stylesheet" href="css/style.css" type="text/css" />
<meta name='description' content='Български Архив за музика!' />
<link rel='shortcut icon' href='style/images/cd.png' />
<script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js'></script>
<script type='text/javascript' src='jqueryslidemenu.js'></script>
<script type="text/javascript" src="vote.js"></script>
<script language="javascript">
function clock(){
var now = new Date()
var Hours = now.getHours()
var Min = now.getMinutes()
var Sec = now.getSeconds()
A = " *am"
if(Hours>12){
A=" *pm"
Hours=Hours-12
}
if(Hours==0)
Hours=-12
if(Min<=9){
Min="0"+Min
}
if(Sec<=9){
Sec="0"+Sec
}
var theTime=Hours + ":" + Min + ":" + Sec + " " + A
window.status=theTime
setTimeout("clock()",1000)
}
window.onload=clock
$(document).ready(function(){
$("#pole").hide();
});
function pokaji(){
$("#pole").toggle("slow");
}
function addemo(newemo){
var emoid = document.getElementById('message').value;
emoid = document.getElementById('message').value+= newemo;
document.getElementById('message').focus();
}
function winopen(url,ad,wid,hei) {
window.open(''+url, 'share','toolbar=0,scrollbars=yes,location=0,statusbar=0,menubar=0,resizable=no,width=500,height=500,left=100,top=50');
}
function movepic(img_name,img_src) {
document[img_name].src=img_src;
}
</script>
<style type='text/css'>
html .jqueryslidemenu{height: 1%;}
</style>
<?php $id = (is_numeric($_GET['id']) && $_GET['id'] > 0) ? $_GET['id'] : 0; ?>
<script LANGUAGE="JavaScript">
</script>
</head>
<body>
<div class="content">
<div id="info">
<div class="header">
<img src="images/logo.png" />
</div>
<?php
if ($username) {
?>
<table align="center"><tr><td id="menu" align="center">
<a id="nav" href="index.php">MP3</a>
<a id="nav" href="add.php">Добави песен</a>
<a id="nav" href="editprofile.php">Профил</a>
<a id="nav" href="users.php">Потребители</a>
<a id="nav" href="logout.php">Изход</a>
</td></tr></table>
<?php
}
else {
?>
<table align="center"><tr><td id="menu" align="center">
<a id="nav" href="index.php">MP3</a>
<a id="nav" href="login.php">Вход</a>
<a id="nav" href="register.php">Регистрация</a>
<a id="nav" href="users.php">Потребители</a>
</td></tr></table>
<?php
}
?>
<br style="clear:both;" />
<div id="center">
<div id="table">
<?php
if($username)
{
echo "<center><span style='color:red;'><h4>Грешка</span>!</h4><br />
Вече сте влязъл в системата.</center>";
}
else{
if($_POST['log'])
{
$username2 = $_POST['username'];
$password = md5($_POST['password']);
$sql = "SELECT * FROM users WHERE username='$username2'";
$result = mysql_query($sql) or die ('Не мога да се свържа с таблица USERS');
$broi = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);
$dLogin = time();
if (($broi) == 0) {
echo "<br /><br /><center>Няма такъв потребител</center>";
}
else {
if ($password == $row[password])
{
$_SESSION['username'] = $row[username];
echo "<center><span style='color:green;'><h4>Успешна операция</span>!</h4><br /><center><i>Добре дошъл </i> <b>".$_SESSION['username'];
echo ". До <strong>3</strong> сек. ще бъдете прехвърлени в началната страница страница.</center>";
header("REFRESH: 3; url=index.php");
}
else{
echo "<br /><br /><center>Грешна парола</center>";
}
}
}
else{
?>
<center>
<span style="color:black;"><h4>Ако нямате Акаунт в системата, може да си направите от <a href="register.php">тук</a></h4></span>
<form action="" method="post">
Потребител:<br /><input type="text" style="background:lightblue;" name="username" size="10"><br>
Парола:<br /><input type="password" style="background:lightblue;" name="password" size="10"><br>
<input type="submit" name="log" value="Вход" /></form>
</center>
<?php
}
}
?>
</div>
<?php include "ssdiv.php"; ?>
<div id="novini"><table align="left" style="margin: -29px 8px;"><tr><td class="buttonnovini">    <b>Последно качени</b>
<?php
$pp = "10";
//колко резултата на страница
$page=(int)$_GET['page']; //присвояваме стойността на page
if(!$_GET['page']) //ако не е взета page да върне 1-ца
{
$page="1";
}
$limit = ($pp*$page)-$pp; //определяме лимитирането
$redove=mysql_query("SELECT * FROM music");
$max=mysql_numrows($redove); //преброяваме редовете
$total=ceil($max/$pp); //пресмятаме броя на страниците
$query="SELECT id,ispylnitel,pesen,link,slushana,download FROM music ORDER by id DESC LIMIT $limit,$pp";
$result=mysql_query($query);
echo "<center><table class='middle_prazno' style='font:14px Tahoma;width:300px;'><br><tr><td id='polebaner567'>#</td><td id='polebaner'>Изпълнител и песен</td><td id='polebaner56789'>Прегледана</td><td id='polebaner56789'>Сваляна</td></tr>";
// print-ваме посочените редове в таблица.
function utf8_substr($str,$from,$len)
{
return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$from.'}'.
'((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$len.'}).*#s',
'$1',$str);
}
while($row = mysql_fetch_array($result))
{
$row['ispylnitel'] = strlen($row['ispylnitel']) > 5 ? utf8_substr($row['ispylnitel'],0,5) . "..." :$row['ispylnitel'];
$row['pesen'] = strlen($row['pesen']) > 5 ? utf8_substr($row['pesen'],0,5) . "..." :$row['pesen'];
echo '<td id="polebaner567"><img src="style/images/cd.png"></td> <td id="polebaner56678" ><a href="music.php?id='.$row['id'].'" style="color: #5ca64f;text-decoration:none;"><span style="color:gray;">'.$row['ispylnitel'].' - '.$row['pesen'].'</span></a><br></td><td id="polebaner5678" title="Брой слушана"><center>'.$row['slushana'].'</center></td><td id="polebaner5678" title="Брой теглена"><center>'.$row['download'].'</center></td></tr>';
}
echo"</table></center><br /><br>";
//от тук започва кода за показването на страниците
if ($page > 1)
{
$prev = ($page - 1);
echo "<a href=\"?page=$prev\"><span style='color:lightgreen;' face=\"Trebuchet MS\">Предишна страница</span></a> ";
}
else echo "<span style='color:lightgreen;' face=\"Trebuchet MS\">Предишна страница</span> ";
if (!$page or ($page > $total))
{
$page="1";
}
if ($total < 10)
{
for($i=1 ; $i<=$total ; $i++)
{
if ( ($page)==$i )
{
echo "<span style='color:white;'><b>$i</b></span> ";
}
else
{
echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
}
}
else
{
for($i=1 ; $i<=3 ; $i++)
{
if ( ($page)==$i )
{
echo "<span style='color:white;'><b>$i</b></span> ";
}
else
{
echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
}
if ($page <= 3)
{
if ($page == 3) echo "<span style='color:white;'><a href=\"?page=4\">4</a></span> ";
echo "<span style='color:white;'>...</span> ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
if ($page == 5) $parva.= "<a href=\"?page=4\"><span style='color:orange;'>4</span></a> ";
if ( ($page == 4) or ($page == 5) )
{
for ($i=$page; $i<=$page+1; $i++)
{
if ($page == $i) echo "<span style='color:orange;'><b>$i</b> ";
else echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
echo "<span style='color:white;'>...</span> ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
if ( ($page > 5) and ($page < ($total - 4)) )
{
echo "<span style='color:white;'>...</span> ";
for ($i=$page-1; $i<=$page+1; $i++)
{
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
echo "<span style='color:white;'>...</span> ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) )
{
echo "<span style='color:white;'>...</span> ";
for ($i=$total-5; $i<=$total; $i++)
{
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\"><span style='color:orange;'>".$i."</span></a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"?page=$next\"><span style='color:red;' face=\"Trebuchet MS\">Следваща страница</span></a> ";
}
else echo "<span style='color:red;' face=\"Trebuchet MS\">Следваща страница</span>";
?>
</td></tr></table></div>
</div>
</div>
</div>
<br style="clear:both;" /><br /><br><table align="center"><script type="text/javascript">
</script>
<noscript><a href="http://www.tyxo.bg/?71338" title="Tyxo.bg counter" target="_blank"><img src="http://cnt.tyxo.bg/71338" width="80" height="15" border="0" alt="Tyxo.bg counter" /></a></noscript><tr><td id="footer" align="center"><b>©<a href="http://bg-d3sign.net/" style="text-decoration:none">BG-DESIGN</a> 2009 All rights reserved!</b></td></tr></table>
</body>
</html>