$OldTitle = trim($_POST['otitle']);
$Language = trim($_POST['language']);
$Title = trim($_POST['title']);
$Description = $_POST['description'];
$Header = trim($_POST['header']);
$Link = trim($_POST['link']);
$Level = trim($_POST['level']);
$Type = trim($_POST['type']);
$Path = trim($_POST['path']);
$id = trim($_POST['id']);
$enable = trim($_POST['enable']);
if ($Title == '')
{
print "
You must enter the title. Please go back and try again.
";
exit();
}
$trans = array("�" => "à", "�" => "á", "�" => "è", "�" => "é", "�" => "ê", "�" => "ë", "�" => "ç", "�" => "Í", "�" => "Ì", "�" => "ó", "�" => "ú", "l'"=> "l\'", "c'" => "c’", "s'" => "s’", "D'" => "D’", "d'" => "d’", "C'" => "D’", "," => ",", "u'" => "ú", "!" => "!", "�" => "¡");
$title = strtr($Title, $trans);
$title = stripslashes($title);
$description = addslashes($Description);
$header = addslashes($Header);
$link = addslashes($Link);
$level = addslashes($Level);
$type = addslashes($Type);
$path = stripslashes($Path);
//$path = $Path;
$otitle = stripslashes($OldTitle);
include("../include/dbconfig.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
mysql_select_db($db_name);
$query = 'update OM_titles set Language="'.$Language.'", Title="'.$title.'", Level="'.$level.'", Type="'.$type.'", Path="'.$path.'", enable="'.$enable.'" where id='.$id;
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
// $query = 'update OM_media set Language="'.$Language.'", Title="'.$title.'", Level="'.$level.'", media="'.$type.'", filepath="'.$path.'" where Title="'.$otitle.'"';
// $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$atitle = stripslashes($Title);
header("Location: managetitle.php?title=$atitle&id=$id");
exit();
?>