web-admin/viewprogram.php

   1 <?php
   2
   3 require "config.php";
   4 require "common.php";
   5 require "mysql.php";
   6 #require "commonmysql.php";
   7 require "channels.php";
   8 require "programs.php";
   9 require "language.php";
  10
  11 $debug=false;
  12
  13 if( $debug ){
  14         dbg( "NonameTV" , $dconf );
  15 }
  16
  17 //
  18 // connect to main database
  19 //
  20 switch( $dconf['dbtype'] ){
  21         case 'mysql':
  22                 $myc = sql_doconnect();
  23                 if( ! $myc ) exit;
  24                 break;
  25 }
  26
  27 $lngstrpd = loadlanguage( 'programdetails' );
  28 if( $debug ) dbg("language strings - program details" , $lngstrpd );
  29
  30 ?>
  31 <html>
  32 <head>
  33 <title>View program</title>
  34 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  35 <link href="css/nonametv.css" rel=stylesheet>
  36 </head>
  37
  38 <body bgcolor="#FFFFFF" text="#000000">
  39
  40 <?php
  41
  42 function doexit()
  43 {
  44         global $dconf,$myc;
  45
  46         //
  47         // disconnect from main database
  48         //
  49         switch( $dconf['dbtype'] ){
  50                 case 'mysql':
  51                         sql_dodisconnect( $myc );
  52                         break;
  53         }
  54
  55         print "</body>\n";
  56         print "</html>\n";
  57
  58         exit;
  59 }
  60
  61 //
  62 // main
  63 //
  64 if( isset( $_REQUEST['channel'] ) ) $channel_id = $_REQUEST['channel'];
  65 else {
  66         print "<h2>" . $lngstrpd['nochanspecified'] . "</h2>";
  67         doexit();
  68 }
  69 if( isset( $_REQUEST['time'] ) ) $showtime = $_REQUEST['time'];
  70 else {
  71         print "<h2>" . $lngstrpd['notimespecified'] . "</h2>";
  72         doexit();
  73 }
  74
  75 $chann = sql_findChannel( $myc , 'id' , $channel_id );
  76 if( ! $chann ){
  77         print "<h2>" . $lngstrpd['invchanid'] . ": " . $channel_id . "</h2>";
  78         doexit();
  79 }
  80
  81 $prog = sql_findProgram( $myc , $channel_id , "start_time" , strftime( "%Y-%m-%d %H:%M:%S" , $showtime ) );
  82 if( ! $prog ){
  83         print "<h2>" . $lngstrpd['noprogstartingat'] . ": " . strftime( "%Y-%m-%d %H:%M:%S" , $showtime + date('Z') ) . "</h2>";
  84         doexit();
  85 }
  86 //dbg("prog",$prog);
  87
  88 if( $chann['logo'] ){
  89         print "<img src=\"" . $dconf['urllogos'] . "/" . $chann['xmltvid'] . ".png\">\n";
  90 }
  91 print "<h1>" . $lngstrpd['progdetailsfor'] . " " . $chann['display_name'] . " " . $lngstrpd['at'] . " " . strftime( "%Y-%m-%d %H:%M:%S" , $showtime + date('Z') ) . "</h1>\n";
  92
  93 print "\n<!-- program details table -->\n";
  94 print "<table width=\"75%\" border=\"0\" cellpadding=\"4\" cellspacing=\"2\" class=\"viewprogram\">\n";
  95
  96 print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
  97 print "    <td align=\"right\">" . $lngstrpd['prgtitle'] . ":</td>\n";
  98 print "    <td align=\"left\">\n";
  99 print "      <b>" . $prog[0]['title'] . "</b>\n";
 100 print "    </td>\n";
 101 print "  </tr>\n";
 102
 103 if( strlen(trim($prog[0]['subtitle'])) ){
 104         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 105         print "    <td align=\"right\">" . $lngstrpd['prgsubtitle'] . ":</td>\n";
 106         print "    <td align=\"left\">\n";
 107         print "      " . $prog[0]['subtitle'] . "\n";
 108         print "    </td>\n";
 109         print "  </tr>\n";
 110 }
 111
 112 if( strlen(trim($prog[0]['category'])) ){
 113         $cellclass = cellclass_category( $prog[0] , $chann['def_cat'] );
 114         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 115         print "    <td align=\"right\">" . $lngstrpd['prgcategory'] . ":</td>\n";
 116         print "    <td align=\"left\" class=\"" . $cellclass . "\">\n";
 117         print "      " . $prog[0]['category'] . "\n";
 118         print "    </td>\n";
 119         print "  </tr>\n";
 120 }
 121
 122 if( strlen(trim($prog[0]['description'])) ){
 123         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 124         print "    <td align=\"right\">" . $lngstrpd['prgdescription'] . ":</td>\n";
 125         print "    <td align=\"left\">\n";
 126         $predesc = ereg_replace( "\n" , "<br>" , $prog[0]['description'] );
 127         print "      " . $predesc . "\n";
 128         print "    </td>\n";
 129         print "  </tr>\n";
 130 }
 131
 132 if( strlen(trim($prog[0]['directors'])) ){
 133         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 134         print "    <td align=\"right\">" . $lngstrpd['prgdirectors'] . ":</td>\n";
 135         print "    <td align=\"left\">\n";
 136         print "      " . $prog[0]['directors'] . "\n";
 137         print "    </td>\n";
 138         print "  </tr>\n";
 139 }
 140
 141 if( strlen(trim($prog[0]['actors'])) ){
 142         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 143         print "    <td align=\"right\">" . $lngstrpd['prgactors'] . ":</td>\n";
 144         print "    <td align=\"left\">\n";
 145         print "      " . $prog[0]['actors'] . "\n";
 146         print "    </td>\n";
 147         print "  </tr>\n";
 148 }
 149
 150 if( strlen(trim($prog[0]['writers'])) ){
 151         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 152         print "    <td align=\"right\">" . $lngstrpd['prgwriters'] . ":</td>\n";
 153         print "    <td align=\"left\">\n";
 154         print "      " . $prog[0]['writers'] . "\n";
 155         print "    </td>\n";
 156         print "  </tr>\n";
 157 }
 158
 159 if( strlen(trim($prog[0]['adapters'])) ){
 160         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 161         print "    <td align=\"right\">" . $lngstrpd['prgadapters'] . ":</td>\n";
 162         print "    <td align=\"left\">\n";
 163         print "      " . $prog[0]['adapters'] . "\n";
 164         print "    </td>\n";
 165         print "  </tr>\n";
 166 }
 167
 168 if( strlen(trim($prog[0]['producers'])) ){
 169         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 170         print "    <td align=\"right\">" . $lngstrpd['prgproducers'] . ":</td>\n";
 171         print "    <td align=\"left\">\n";
 172         print "      " . $prog[0]['producers'] . "\n";
 173         print "    </td>\n";
 174         print "  </tr>\n";
 175 }
 176
 177 if( strlen(trim($prog[0]['presenters'])) ){
 178         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 179         print "    <td align=\"right\">" . $lngstrpd['prgpresenters'] . ":</td>\n";
 180         print "    <td align=\"left\">\n";
 181         print "      " . $prog[0]['presenters'] . "\n";
 182         print "    </td>\n";
 183         print "  </tr>\n";
 184 }
 185
 186 if( strlen(trim($prog[0]['commentators'])) ){
 187         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 188         print "    <td align=\"right\">" . $lngstrpd['prgpresenters'] . ":</td>\n";
 189         print "    <td align=\"left\">\n";
 190         print "      " . $prog[0]['commentators'] . "\n";
 191         print "    </td>\n";
 192         print "  </tr>\n";
 193 }
 194
 195 if( strlen(trim($prog[0]['guests'])) ){
 196         print "  <tr valign=\"top\" class=\"viewprogram_tableBody\">\n";
 197         print "    <td align=\"right\">" . $lngstrpd['prgguests'] . ":</td>\n";
 198         print "    <td align=\"left\">\n";
 199         print "      " . $prog[0]['guests'] . "\n";
 200         print "    </td>\n";
 201         print "  </tr>\n";
 202 }
 203
 204 print "</table>\n";
 205
 206 doexit();
 207
 208 ?>