'1') and ShortURLText ='{$folder}' ";
$_mssql_result = sqlsrv_query( $sqlConnection,$_mssql_select_query );
$_mssql_data = sqlsrv_fetch_array( $_mssql_result );
sqlsrv_cancel( $_mssql_result );
if (strlen(trim($_mssql_data['CompleteURL']))>0){
ini_set('display_errors', '1');
error_reporting(E_ALL);
echo "Before redirect
";
$goto = trim($_mssql_data['CompleteURL'] ?? '');
var_dump($goto);
if ($goto !== '') {
echo "Redirect target found
";
if (headers_sent($file, $line)) {
die("Headers already sent in $file on line $line");
}
header('Location: ' . $goto, true, 302);
exit;
}
}else{
$goto = trim($_mssql_data['FolderName'])."/".trim($_mssql_data['PageName']).".php";
$folderName=trim($_mssql_data['FolderName']);
$pageName = trim($_mssql_data['PageName']);
}
if (strlen(trim($_mssql_data['Parameter1Text']))>0){
$id= trim($_mssql_data['Parameter1Text']);
}
if (strlen(trim($_mssql_data['Parameter2Text']))>0){
$id2= trim($_mssql_data['Parameter2Text']);
}
}
}else{
$goto ='';
$idSelect='';
$_mssql_select_query = "SELECT *
FROM ParishWeb.dbo.tblWebShortURL
where (inactive is null or inactive <> '1') and ShortURLText ='{$folder}' ";
$_mssql_result = sqlsrv_query( $sqlConnection,$_mssql_select_query );
if ($_mssql_data = sqlsrv_fetch_array( $_mssql_result ))
{
if (strlen(trim($_mssql_data['CompleteURL']))>0){
//$goto = trim($_mssql_data['CompleteURL']);
$goto = trim($_mssql_data['CompleteURL'] ?? '');
if ($goto !== '') {
header('Location: ' . $goto, true, 302);
exit;
}
}else{
$goto = trim($_mssql_data['FolderName'])."/".trim($_mssql_data['PageName']).".php";
$folderName=trim($_mssql_data['FolderName']);
$pageName = trim($_mssql_data['PageName']);
}
if (strlen(trim($_mssql_data['Parameter1Text']))>0){
$id= trim($_mssql_data['Parameter1Text']);
}
if (strlen(trim($_mssql_data['Parameter2Text']))>0){
$id2= trim($_mssql_data['Parameter2Text']);
}
}
sqlsrv_cancel( $_mssql_result );
}
}
}
}else{
if (trim(strtolower($folder))=='news'){
if (str_contains($page, 'p')) {
$goto = "news/index.php";
}else{
$newsId = $page;
$goto = "news/article.php";
}
}else{
$goto = $folder."/".$page.".php";
if ( !file_exists( $goto ) ) {
$goto ='';
$idSelect='';
if (strlen(trim($page))!=0):
$id=$page;
endif;
$_mssql_select_query = "SELECT *
FROM TPCG_org.dbo.tblWebShortURL
where (inactive is null or inactive <> '1') and ShortURLText ='{$folder}' ";
$_mssql_result = sqlsrv_query( $sqlConnection,$_mssql_select_query );
if ( $_mssql_data = sqlsrv_fetch_array( $_mssql_result ))
{
if (strlen(trim($_mssql_data['CompleteURL']))>0){
$goto = trim($_mssql_data['CompleteURL']);
header("Location: $goto");
exit;
}else{
$goto = trim($_mssql_data['FolderName'])."/".trim($_mssql_data['PageName']).".php";
$folderName=trim($_mssql_data['FolderName']);
$pageName = trim($_mssql_data['PageName']);
}
if (strlen(trim($_mssql_data['Parameter1Text']))>0){
$id= trim($_mssql_data['Parameter1Text']);
}
if (strlen(trim($_mssql_data['Parameter2Text']))>0){
$id2= trim($_mssql_data['Parameter2Text']);
}
}
if (isset($_mssql_result)):
sqlsrv_cancel( $_mssql_result );
endif;
}
}
}
}
if (strlen(trim($goto))==0){
$goto = "404.php";
}
// echo "herex".$goto; die;
?>
Index -Terrebonne Parish