if ($res['msg'] == 'OK') {
$user = $_SESSION['userid'];
}
}
$postdata = file_get_contents("php://input");
if (!empty($postdata)) {
$_POST = json_decode($postdata, TRUE);
}
if (!empty($_GET['search'])) {
$res = search(urldecode($_GET['search']));
} elseif (!empty($_GET['show'])) {
$res = getShow($_GET['show'], isset($_GET['force']), isset($_GET['q']));
} elseif (isset($_GET['usershows'])) {
$res = getUserShows();
} elseif (!empty($_POST['addshow'])) {
$res = addShow($_POST['addshow']);
} elseif (!empty($_POST['delshow'])) {
$res = delShow($_POST['delshow']);
} elseif (!empty($_POST['updateshow'])) {
$res = updateShow($_POST['updateshow']);
} elseif (!empty($_POST['username']) && !empty($_POST['password'])) {
$res = login($_POST['username'], $_POST['password'], isset($_POST['stay']) && $_POST['stay']);
} elseif (!empty($_POST['token'])) {
$res = login2($_POST['password']);
} elseif (isset($_POST['logout'])) {
$res = logout();
} elseif (!empty($_POST['registername']) && !empty($_POST['password'])) {
$res = register($_POST['registername'], $_POST['password']);
} else {
$res = array('msg' => 'Command not set', 'post' => $_POST, 'get' => $_GET);
}
return $appid;
}
function cleanString($text)
{
$utf8 = array('/[áàâãªä]/u' => 'a', '/[ÁÀÂÃÄ]/u' => 'A', '/[ÍÌÎÏ]/u' => 'I', '/[íìîï]/u' => 'i', '/[éèêë]/u' => 'e', '/[ÉÈÊË]/u' => 'E', '/[óòôõºö]/u' => 'o', '/[ÓÒÔÕÖ]/u' => 'O', '/[úùûü]/u' => 'u', '/[ÚÙÛÜ]/u' => 'U', '/ç/' => 'c', '/Ç/' => 'C', '/ñ/' => 'n', '/Ñ/' => 'N', '/–/' => '-', '/[’‘‹›‚]/u' => ' ', '/[“”«»„]/u' => ' ', '/ /' => ' ');
return preg_replace(array_keys($utf8), array_values($utf8), $text);
}
foreach ($lines as $lnum => $l) {
echo "<hr>processing {$lnum} ...<br>";
$p = explode("|", $l);
$person = addPerson(addslashes($p[0]));
echo "person is {$person} <br>";
if (!$person) {
continue;
}
$show = addShow(addslashes($p[5]));
echo "show is {$show} <br>";
if (!$show) {
continue;
}
$date = $p[2];
$dateformat = "%m/%d/%Y";
$appearance = addAppearance($show, $person, $date, $dateformat);
echo "appearance is {$appearance} <br>";
if (!$appearance) {
continue;
}
$video = formatVideo($p[3]);
$videotitle = trim(cleanString($p[4]));
$q = sprintf("INSERT INTO media (appearfk,medtype,medid,medtitle) VALUES (%d,%d,'%s','%s')\n\t\tON DUPLICATE KEY UPDATE medtype=%d, medid='%s', medtitle='%s'\n\t\t", $appearance, $video[0], $video[1], addslashes($videotitle), $video[0], $video[1], addslashes($videotitle));
echo $q . "<br>";
<?php
//require_once ('Edit.php');
//if (isset($_POST['submit'])) {
// php();
//header("Refresh:0");
//}
//
require_once '/var/www/html/app/model/connect.php';
require_once 'addShow.php';
if (isset($_POST['submit'])) {
addShow();
//header("Location:Add.php");
}
?>
<html lang="en"><head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=1024, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Edit</title>
<style type="text/css">
.container .form-horizontal .form-group .col-sm-10 {
font-family: Consolas, Andale Mono, Lucida Console, Lucida Sans Typewriter, Monaco, Courier New, monospace;
}
</style>
header("location:show-page.php?page=" . $_GET['page']);
} else {
$_SESSION['edit-show'] = 'failed';
header("location:show-page.php?page=" . $_GET['page']);
}
}
if (isset($_POST['delete'])) {
removeShow($_POST['showid']);
$_SESSION['delete-show'] = 'success';
header("location:show-page.php?page=" . $_GET['page']);
}
if (isset($_POST['add'])) {
$idTrain = getIdTrainByNameClass($_POST['train'], $_POST['class']);
$show = checkShow($_POST['from_venue'], $_POST['to_venue'], $_POST['departure'], $idTrain, $_POST['seat']);
if ($show == 0) {
addShow($_POST['from_venue'], $_POST['to_venue'], $_POST['departure'], $idTrain, $_POST['seat']);
$_SESSION['add-show'] = 'success';
header("location:show-page.php?page=" . $_GET['page']);
} else {
$_SESSION['add-show'] = 'failed';
header("location:show-page.php?page=" . $_GET['page']);
}
}
?>
<script src="../js/jquery-2.1.1.min.js"></script>
<script src="../js/show-page.js"></script>
<script>
var length = $('#class-edit > option').length;
if (length == 1){
$('#class-edit').removeAttr('disabled');
