/**
* getDeleteStatements
*
* prepares delete statements to be executed to delete a
* customformsentry record
*
* @param int $id
* object id
*
* @return array
* the array of statements
*/
function getDeleteStatements($id)
{
$query = "SELECT id FROM #wp__easycontactforms_customformentryfiles WHERE CustomFormsEntries='{$id}';";
EasyContactFormsDB::cDelete($query, 'CustomFormEntryFiles');
$stmts[] = "DELETE FROM #wp__easycontactforms_customformsentries WHERE id='{$id}';";
return $stmts;
}
/**
* getDeleteStatements
*
* prepares delete statements to be executed to delete a customform
* record
*
* @param int $id
* object id
*
* @return array
* the array of statements
*/
function getDeleteStatements($id)
{
$stmts[] = "DELETE FROM #wp__easycontactforms_customforms_mailinglists WHERE CustomForms='{$id}';";
$query = "SELECT id FROM #wp__easycontactforms_customformfields WHERE CustomForms='{$id}';";
EasyContactFormsDB::cDelete($query, 'CustomFormFields');
$query = "SELECT id FROM #wp__easycontactforms_customformsentries WHERE CustomForms='{$id}';";
EasyContactFormsDB::cDelete($query, 'CustomFormsEntries');
$query = "SELECT id FROM #wp__easycontactforms_customformentrystatistics WHERE CustomForms='{$id}';";
EasyContactFormsDB::cDelete($query, 'CustomFormEntryStatistics');
$stmts[] = "DELETE FROM #wp__easycontactforms_customforms WHERE id='{$id}';";
return $stmts;
}
