Delete file

Submitted by henk on Sun, 2012-12-23 12:07 in Price Tapestry

Hi David,

Is it possible when in automation tool a job is deleted also delete the file in feeds? Maybe also delete in database?

Thx
Henk

Hi Henk, Sure - in

Submitted by support on Sun, 2012-12-23 12:30

Hi Henk,

Sure - in admin/automation_tool_delete.php look for the following code at line 12:

  $sql = "DELETE FROM `".$config_databaseTablePrefix."jobs` WHERE id='".database_safe($id)."'";

...and REPLACE with:

  $sql = "SELECT filename FROM `".$config_databaseTablePrefix."jobs` WHERE id='".database_safe($id)."'";

  if (database_querySelect($sql,$jobs))

  {

    $job = $jobs[0];

    unlink($config_feedDirectory.$job["filename"]);

    admin_deregister($job["filename"]);

  }

  $sql = "DELETE FROM `".$config_databaseTablePrefix."jobs` WHERE id='".database_safe($id)."'";

Cheers,
David.
--
PriceTapestry.com

Hi David, Thx And the delete

Submitted by henk on Sun, 2012-12-23 12:43

Hi David,

Thx

And the delete file from the feed map? Is that possible?

Thx
Henk

Sorry Henk -

Submitted by support on Sun, 2012-12-23 14:31

Sorry Henk - $config_feedDirectory prefix required - corrected above...

Cheers,
David.
--
PriceTapestry.com