Sorry, I should have looked in the upload directory <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />
So, it's all clear now to me:
w3t_Posts.B_File holds either NULL or POSTNUMBER-ATTACHMENTname
w3t_Posts.B_Number holds the relevant POSTNUMBER
From Dave's script above:
UPDATE w3t_Posts
SET B_File = NULL
WHERE B_Number = xxxxxx
This will change the attribute to NULL for that posting so it doesn't think it has an attachment.
But, this still doesn't delete the associated attachment from the filesystem.
Can any script savvy person do the following:
Query the DB to retrieve the present value of B_File in w3t_Posts by asking you for the B_Number AND THEN run Dave's update above to set it to NULL, AND THEN use the $config['files'] variable to use the path and put the attachment name at the end of the path, as the file to delete in the script ? <img border="0" title="" alt="[Eek!]" src="images/icons/shocked.gif" />
OR, better yet...can INFOPOP make a button that will do that ?
Cheers, Bill
