<?
error_reporting(E_ALL);
$dblocation = "localhost";
$dbuser = "root";
$dbpasswd = "";
//$dbuser = "www";
//$dbpasswd = "nhzvlbz";
$dbname="www";
$dbcnx = @mysql_connect($dblocation,$dbuser,$dbpasswd);
if (!$dbcnx) die('Database error');
if (!@mysql_select_db($dbname, $dbcnx)) die('Database error');
mysql_set_charset('utf8');

$dt=date("d.m.y");
//$dt="01.11.10";
$date=explode(".",$dt);
$tm=date("H:i");
//$tm="23:00";
$time=explode(":",$tm);
$d1=$date[0];
$m1=$date[1];
$y1=$date[2];
$hr1=$time[0];
$mn1=$time[1];

if ($hr1<6) 
	{
	$hr1+=24;
	$dt=date("d.m.y",mktime(0,0,0,$m1,$d1-1,$y1));
	}
$min1=60*$hr1+$mn1;

$current=0;
$nxt=0;
$first=1;
$strnext="";
$strcurr="";
$chancurr=0;
$channext=0;

$query = "SELECT id,date_format(dtime,'%H:%i') tm,name,programm_id,channel_id,minutes min,dur FROM stv_tvefir WHERE date_format(dtime,'%d.%m.%y')='".$dt."' ORDER BY id";
$resource = mysql_query($query);
while($row = mysql_fetch_assoc($resource))
{
if ($first==1)
	{
	$first=0;
        $nxt=1;
	}
if (($row['min']<=$min1)&&($row['min']+$row['dur']>$min1))
	{
	$current=1;
	$strcurr=$row['tm']." ".$row['name'];
	$chancurr=$row['channel_id'];
	}
if ($nxt==1)
	{
	$strnext=$row['tm']." ".$row['name'];
	$channext=$row['channel_id'];
	$nxt=0;
	}
if ($current==1)
	{
	$current=0;
	$nxt=1;
	}
if (($current==0)&&($row['min']<=$min1))
	{
	$nxt=1;
	$strnext="";
	}
}

mysql_close();

$pic='efirbk169.jpg';
$fontname=$_SERVER['DOCUMENT_ROOT'].'/flashplayer/pic/pragm1.ttf';

header('Content-type: image/jpeg');
$size = getimagesize($pic) or die('Cannot load background');
$picwidth=$size[0];
$picheight=$size[1];
$image=imagecreatefromjpeg($pic) or die('Cannot load background');

$text='Прямой эфир';
$fontsize=26;
$X=120;
$Y=49;
imagettftext($image,$fontsize,0,$X,$Y,0x990000,$fontname,$text);

$fontname=$_SERVER['DOCUMENT_ROOT'].'/flashplayer/pic/pragm2.ttf';
$text='';
if ($strcurr!="") 
	$text='Сейчас в эфире С1:';
	else
	if ($strnext!="") $text='Скоро в эфире СТВ'.$channext.':';
$fontsize=20;
$X=70;
$Y=240;
imagettftext($image,$fontsize,0,$X,$Y,0x990000,$fontname,$text);

$fontname=$_SERVER['DOCUMENT_ROOT'].'/flashplayer/pic/pragm3.ttf';
$text='';
if ($strcurr!="") 
	$text=$strcurr;
	else
	if ($strnext!="") $text=$strnext;
$fontsize=16;
$X=10;
$Y=263;
imagettftext($image,$fontsize,0,$X,$Y,0x990000,$fontname,$text);

$coord = imagettfbbox($fontsize,0,$fontname,$text);
$width = $coord[2] - $coord[0];
$height = $coord[1] - $coord[7];
$X=($picwidth-$width)/2;
$Y=($picheight+$height)/2;

imagejpeg($image,'',80);
imagedestroy($image);
?>