|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
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.
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Keep in mind that that MySQL query only updates the database. The actual attachment file also needs to be deleted from the server.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Thanks -
Easy enough... but good to know.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 21,079
Joined: March 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|