function choose() { while (list($k, $v) = each($GLOBALS)) { global ${$k}; } $collectorid = getcollectorid("advalvas"); $query = "DELETE FROM station " . "WHERE collectorid='" . addslashes($collectorid) . "'"; $sql->query($query); $query = "DELETE FROM program"; $sql->query($query); print_header_open(); print_title("Choose Stations for " . $this->MODULE_NAME); print_header_close(); print "\n <FORM ACTION=\"" . page_name() . "\" METHOD=POST>\n <INPUT TYPE=HIDDEN NAME=\"module\" VALUE=\"" . prepare($module) . "\">\n <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>\n <TR BGCOLOR=\"#ccccff\">\n <TD><B>Original Name</B></TD>\n <TD><B>xawtv Name</B></TD>\n <TD><B>Channel</B></TD>\n </TR>\n "; while (list($name, $value) = each($HTTP_POST_VARS)) { if ($value == 1) { $suburl = "?NL&" . $name; $channel_name = preg_replace("/_/", " ", $name); $channel_name = preg_replace("/\\|/", "+", $channel_name); $query = $sql->insert_query("station", array("sname" => $this->transformName($channel_name), "collectorid" => $collectorid, "suburl" => $suburl, "rname" => $this->transformName($channel_name), "channel" => "0")); $result = $sql->query($query); $sid = $sql->last_record($result); print "\n\t\t\t\t<TR>\n\t\t\t\t\t\t<TD>" . prepare($channel_name) . "</TD>\n\t\t\t\t\t\t<TD>\n\t\t\t\t\t\t\t\t<INPUT TYPE=TEXT NAME=\"T" . htmlentities($sid) . "\"\n\t\t\t\t\t\t\t\tVALUE=\"" . prepare($channel_name) . "\">\n\t\t\t\t\t\t</TD>\n\t\t\t\t\t\t<TD>" . html_form::text_widget("C" . htmlentities($sid)) . "</TD>\n\t\t\t\t</TR>\n\t\t\t\t"; } } print "</TABLE>\n"; print "<P><INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Update\"></P>\n"; print "</FORM>\n"; print_page_close(); exit; }
function choose() { while (list($k, $v) = each($GLOBALS)) { global ${$k}; } $collectorid = getcollectorid("advalvas"); $query = "DELETE FROM station " . "WHERE collectorid='" . addslashes($collectorid) . "'"; $sql->query($query); $query = "DELETE FROM program"; $sql->query($query); print_header_open(); print_title("Choose Stations for " . $this->MODULE_NAME); print_header_close(); print "\n\t\t\t<FORM ACTION=\"" . page_name() . "\" METHOD=POST>\n\t\t\t<INPUT TYPE=HIDDEN NAME=\"module\" VALUE=\"" . prepare($module) . "\">\n\t\t\t<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>\n\t\t\t<TR BGCOLOR=\"#ccccff\">\n\t\t\t\t<TD><B>Original Name</B></TD>\n\t\t\t\t<TD><B>xawtv Name</B></TD>\n\t\t\t\t<TD><B>Channel</B></TD>\n\t\t\t</TR>\n\t\t"; while (list($name, $value) = each($HTTP_POST_VARS)) { if (preg_match("/^T/", $name)) { // derive sid from this... $sid = preg_replace("/^T/", "", $name); // grab all sid-related variables $channel_name = ${"N" . $sid}; $channel_number = ${"C" . $sid}; // create actual insert query $query = $sql->insert_query("station", array("sname" => $this->transformName($channel_name), "collectorid" => "1", "suburl" => $this->transformURL($channel_name), "rname" => $this->transformName($channel_name), "channel" => $channel_number)); $result = $sql->query($query); $old_sid = $sid; $sid = $sql->last_record($result); ${"C" . $sid} = ${"C" . $old_sid}; global ${"C" . $sid}; print "\n\t\t\t\t<TR>\n\t\t\t\t\t<TD>" . prepare($channel_name) . "</TD>\n\t\t\t\t\t<TD>\n\t\t\t\t\t\t<INPUT TYPE=TEXT NAME=\"T" . htmlentities($sid) . "\"\n\t\t\t\t\t\t VALUE=\"" . prepare($channel_name) . "\">\n\t\t\t\t\t</TD>\n\t\t\t\t\t<TD>" . html_form::text_widget("C" . htmlentities($sid)) . "</TD>\n\t\t\t\t</TR>\n\t\t\t\t"; } // end if value = 1 } print "</TABLE>\n"; print "<P><INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Update\"></P>\n"; print "</FORM>\n"; print_page_close(); exit; }
<?php include 'mdsite.php5'; ?> <!DOCTYPE html> <html> <head> <meta content="text/html; charset=UTF-8" http-equiv="content-type" /> <meta name="author" content="Author" /> <title>MDSITE | <?php echo page_name(); ?> </title> <link href="css/style.css" rel="stylesheet" type="text/css" media="screen" /> <link rel="stylesheet" href="css/font-awesome.min.css" /> <link href='http://fonts.googleapis.com/css?family=Cantarell' rel='stylesheet' type='text/css'> <link rel="icon" href="favicon.ico" type="image/x-icon"/> </head> <body > <main> <header> <h1> <img src="img/logo.png" alt="Logo" /> <a href="index.php5">mdsite</a> </h1> </header> <nav> <?php menu(); ?>
print_header_close(); print "<p>Updated.</p>\n"; print_page_close(); exit; } // end SUBMIT = "Update" if ($SUBMIT == "Choose") { $collectorid = getcollectorid("advalvas"); $query = "DELETE FROM station WHERE collectorid={$collectorid}"; $sql->query($query); $query = "delete from program"; $sql->query($query); print_header_open(); print_title("Advalvas"); print_header_close(); print "<FORM ACTION=\"" . page_name() . "\" METHOD=POST>\n\t\t<table border=0 cellspacing=0 cellpadding=2>\n\t\t<tr bgcolor=\"#ccccff\">\n\t\t\t<td><B>Name</B></td>\n\t\t\t<td><B>Your Name in xawtv</B></td>\n\t\t</tr>\n\t"; while (list($name, $value) = each($HTTP_GET_VARS)) { if ($value == 1) { $orgname = "?NL&" . $name; $name = preg_replace("/_/", " ", $name); $name = preg_replace("/\\|/", "+", $name); $query = $sql->insert_query("station", array("sid" => NULL, "sname" => $name, "collectorid" => "1", "suburl" => $orgname, "rname" => $name)); $result = $sql->query($query); $sid = $sql->last_record($result); print "<tr><td>{$name}</td><td><input type=text name=T{$sid} value=\"{$name}\"></td></tr>\n"; } // end if value = 1 } print "</table>"; print "<p><INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Update\"></p>"; print "</form>";