web-admin/listtses.php

   1 <?php
   2
   3 require "config.php";
   4 require "common.php";
   5 require "mysql.php";
   6 require "language.php";
   7 require "epgservers.php";
   8 require "networks.php";
   9
  10 $debug=false;
  11
  12 if( $debug ){
  13         dbg( "NonameTV" , $dconf );
  14 }
  15
  16 //
  17 // connect to main database
  18 //
  19 switch( $dconf['dbtype'] ){
  20         case 'mysql':
  21                 $myc = sql_doconnect();
  22                 if( !$myc ) exit;
  23                 break;
  24 }
  25
  26 $lngstr = loadlanguage( 'listtses' );
  27 if( $debug ) dbg("language strings" , $lngstr );
  28
  29 ?>
  30 <html>
  31 <head>
  32 <title>List EPG servers</title>
  33 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  34 <link href="css/nonametv.css" rel=stylesheet>
  35 </head>
  36
  37 <body bgcolor="#FFFFFF" text="#000000">
  38
  39 <?php
  40
  41 function picksrvidform()
  42 {
  43         global $myc;
  44
  45         print "<h1>Pick EPG server</h1>\n";
  46         print "<form name=epgserver action=\"listtses.php\" method=post>\n";
  47
  48         $srvdb = sql_loadEPGservers( $myc , '' , '' );
  49
  50         print "  <table>\n";
  51
  52         print "    <tr>\n";
  53         print "      <td class=\"tableBody\">\n";
  54         print "        <div align=\"right\">Name</div>\n";
  55         print "      </td>\n";
  56         print "      <td class=\"tableBody\">\n";
  57         print "        <select name=\"srvid\">\n";
  58         reset($srvdb);
  59         while( list( $sk , $sv ) = each($srvdb) ){
  60                 print "          <option value=\"" . $sv['id'] . "\">" . $sv['name'] . "</option>\n";
  61         }
  62         print "        </select>\n";
  63         print "      </td>\n";
  64         print "    </tr>\n";
  65
  66         print "  </table>\n";
  67
  68         print "  <input name=\"Action\" value=\"Continue\" type=\"submit\" class=\"gumb\">\n";
  69
  70         print "</form>\n";
  71 }
  72
  73 function picknetidform( $srvid )
  74 {
  75         global $myc;
  76
  77         print "<h1>Pick network on EPG server " . $srvid . "</h1>\n";
  78         print "<form name=network action=\"listtses.php\" method=post>\n";
  79         print "  <input type=\"hidden\" name=\"srvid\" value=\"" . $srvid . "\">\n";
  80
  81         $netdb = sql_loadNetworks( $myc , 'epgserver' , $srvid );
  82
  83         print "  <table>\n";
  84
  85         print "    <tr>\n";
  86         print "      <td class=\"tableBody\">\n";
  87         print "        <div align=\"right\">Name</div>\n";
  88         print "      </td>\n";
  89         print "      <td class=\"tableBody\">\n";
  90         print "        <select name=\"netid\">\n";
  91         reset($netdb);
  92         while( list( $nk , $nv ) = each($netdb) ){
  93                 print "          <option value=\"" . $nv['id'] . "\">" . $nv['name'] . "</option>\n";
  94         }
  95         print "        </select>\n";
  96         print "      </td>\n";
  97         print "    </tr>\n";
  98
  99         print "  </table>\n";
 100
 101         print "  <input name=\"Action\" value=\"Continue\" type=\"submit\" class=\"gumb\">\n";
 102
 103         print "</form>\n";
 104 }
 105
 106 //
 107 // main
 108 //
 109
 110 $srvid = false;
 111 $netid = false;
 112
 113 if( $debug ) dbg( "REQUEST" , $_REQUEST );
 114 if( isset($_REQUEST['srvid']) ) $srvid = $_REQUEST['srvid'];
 115 if( isset($_REQUEST['netid']) ) $netid = $_REQUEST['netid'];
 116
 117 if( $debug ) dbg( "POST" , $_POST );
 118 if( isset($_POST['srvid']) ) $srvid = $_POST['srvid'];
 119 if( isset($_POST['netid']) ) $netid = $_POST['netid'];
 120
 121 if( ! $srvid ){
 122         picksrvidform();
 123         sql_dodisconnect( $myc );
 124         exit;
 125 }
 126
 127 if( $srvid and ! $netid ){
 128         picknetidform( $srvid );
 129         sql_dodisconnect( $myc );
 130         exit;
 131 }
 132
 133 print "<h1>" . $lngstr['title'] . " " . $srvid . "</h1>\n";
 134
 135 print "<form name=\"new\">\n";
 136 print "  <input type=\"button\" value=\"Add new network\" class=\"gumb\" onClick=\"javascript:window.location.href='editnetwork.php?action=new&srvid=" . $srvid . "'\">\n";
 137 print "</form>\n";
 138
 139 $ndb = sql_loadNetworks( $myc , 'epgserver' , $srvid );
 140 if( $debug ) dbg( "networks" , $ndb );
 141
 142 if( $ndb ){
 143         print "<table width=\"80%\" border=\"0\" cellpadding=\"4\" cellspacing=\"0\">\n";
 144         print "<tr class=\"tableTitle\">\n";
 145         print "  <td>" . $lngstr['name'] . "</td>\n";
 146         print "  <td>" . $lngstr['active'] . "</td>\n";
 147         print "  <td>" . $lngstr['description'] . "</td>\n";
 148         print "</tr>\n";
 149
 150         $rowstyle = 0;
 151
 152         reset( $ndb );
 153         while( list( $sk , $sv ) = each( $ndb ) ){
 154
 155                 print "<tr class=\"tableBody\">\n";
 156                 print "  <td><a href=\"editnetwork.php?id=" . $sv['id'] . "\">" .  $sv['name'] . "</a></td>\n";
 157                 print "  <td>" .  $sv['active'] . "</td>\n";
 158                 print "  <td>" .  $sv['description'] . "</td>\n";
 159                 print "</tr>\n";
 160
 161                 $rowstyle = 1 - $rowstyle;
 162         }
 163
 164         print "</table>\n";
 165 }
 166
 167 //
 168 // disconnect from main database
 169 //
 170 switch( $dconf['dbtype'] ){
 171         case 'mysql':
 172                 sql_dodisconnect( $myc );
 173                 break;
 174 }
 175
 176 ?>
 177
 178 </body>
 179 </html>