Delete files not deleting files on delete record action
Hello ...,
Using universal email 4 - feature: delete files in combination with delete record (data-assist).
On inserting and updating records and files all works well but when it gets time to delete record and associated files only the record gets deleted the associated files remain on server...
<?php
// WA Application Builder Delete
if (isset($_POST["Delete_x"])) // Trigger
{
$WA_connection = $xxx;
$WA_table = "xxx";
$WA_redirectURL = "xxx.php";
$WA_keepQueryString = false;
$WA_fieldNamesStr = "Cat_Id";
$WA_columnTypesStr = "none,none,NULL";
$WA_fieldValuesStr = "".((isset($_POST["WADADeleteRecordID"]))?$_POST["WADADeleteRecordID"]:"") ."";
$WA_comparisonStr = "=";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_comparisions = explode("|", $WA_comparisonStr);
$WA_connectionDB = $database_site;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$deleteParamsObj = WA_AB_generateWhereClause($WA_fieldNames, $WA_columns, $WA_fieldValues, $WA_comparisions);
$WA_Sql = "DELETE FROM `" . $WA_table . "` WHERE " . $deleteParamsObj->sqlWhereClause;
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>
?>
<?php
$WA_DeleteFileResult1 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult1 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Omslag"]))?$_POST["Cat_Omslag"]:"") ."");
}
?>
<?php
$WA_DeleteFileResult2 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult2 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Pdf"]))?$_POST["Cat_Pdf"]:"") ."");
}
?>
<?php
$WA_DeleteFileResult3 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult3 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Zip"]))?$_POST["Cat_Zip"]:"") ."");
}
?>
<?php
$WA_DeleteFileResult4 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult4 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Omslag2"]))?$_POST["Cat_Omslag2"]:"") ."");
}
?>
<?php
$WA_DeleteFileResult5 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult5 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Omslag3"]))?$_POST["Cat_Omslag3"]:"") ."");
}
?>
<?php
$WA_DeleteFileResult6 = false;
if(isset($_POST["Delete_x"])){
$WA_DeleteFileResult6 = WA_FileAssist_DeleteFile("../Uploads/Catalogi/", "".((isset($_POST["Cat_Omslag4"]))?$_POST["Cat_Omslag4"]:"") ."");
}
?>
I hope this is enough code to see what is going wrong or what I am doing wrong...
WKR
RV