#include /home/hobbydomru/www/inc/dbiconnect.inc
#include /home/hobbydomru/www/inc/sub.ephtml
#include ../../inc/head2.inc
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)=localtime(time);
$time_now1=($year+1900)*10000+($mon+1)*100+$mday;
$year+=1900;
$mon+=1;
if($mon<10) {$mon="0".$mon;}
if($mday<10) { $mday="0".$mday; }
$time_now2=$year."-".$mon."-".$mday." ".$hour.":".($min+15).":".$sec;
$day="$year"."$mon"."$mday";
#print $day;
@pairs = split(/&/, $ENV{QUERY_STRING});
foreach $pair (@pairs) {
($name, $value) = split(/=/, $pair);
$input{$name} = $value;
}
%equips=&equips($input{id_turnir});
$query="SELECT name FROM turnir WHERE id=$input{id_turnir}";
$res=$DB->prepare($query) or die "Can't prepare query: $query\n";
$res->execute or die "Can't execute query: $query\n";
$res=$res->fetchrow_hashref();
$name_turnir=$res->{name};
$query="SELECT id_match, gol1, gol2 FROM prognoz WHERE id_player=".$DB->quote($ENV{REMOTE_USER});
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
while (my $hashref = $result->fetchrow_hashref) {
$voted{$hashref->{id_match}}->{gol1}=$hashref->{gol1};
$voted{$hashref->{id_match}}->{gol2}=$hashref->{gol2};
}
#print "time_now".$time_now1."
".$input{id_turnir}."
";
#$query="SELECT MAX(igra.to_show), igra.time FROM igra, tur WHERE igra.time<=$time_now1 AND igra.id_tur=tur.id AND tur.id_turnir=$input{id_turnir} GROUP BY igra.time ORDER BY igra.to_show ASC";
# print $query."
";
#$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
#$result->execute or die "Can't execute query: $query\n";
#while (my $hashref = $result->fetchrow_hashref) {
# print "to-show - ".$hashref->{'MAX(igra.to_show)'}."
";
# print "time - ".$hashref->{time}."
";
# print "time_now - ".$time_now2."
";
# print ($hashref->{time} cmp $time_now2)."
";
# if(($hashref->{time} cmp $time_now2)>0) { $prognoz=$hashref->{'MAX(igra.to_show)'};
#print "prognoz -".$prognoz."
";
# }
#}
# Если есть что прогнозировать
$query="SELECT * FROM igra, tur WHERE igra.id_tur=tur.id AND tur.id_turnir=$input{id_turnir} AND igra.time>NOW() AND igra.time< date_add(now(), interval 7 day)";
#print $query."
";
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
!>
сейчас =$year; !>-=$mon; !>-=$mday; !> =$hour; !>-=$min; !>-=$sec; !>
Отображаются матчи, которые начнутся в ближайшие 168 часов