UBB.Dev
Posted By: JoshPet Remove Attachment - 06/22/2002 3:05 AM
I think it was Dave_L who posted this MySQL command at the info pop board:

UPDATE w3t_Posts
SET B_File = NULL
WHERE B_Number = xxxxxx

You simply insert the post number and it removes the attachment in that post.

It would be cool to have a "remove attachment" button in "editpost.php" that ran this code... inserting the post number of course.

Beyond my ability right now. But should be part of the main release.
Posted By: Dave_L_dup1 Re: Remove Attachment - 06/22/2002 4:31 AM
Keep in mind that that MySQL query only updates the database. The actual attachment file also needs to be deleted from the server.
Posted By: JoshPet Re: Remove Attachment - 06/22/2002 5:43 AM
Thanks -

Easy enough... but good to know.
© UBB.Developers