Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Placing the file names from the directory and from the posts into arrays and comparing them keeps the queries down to only 2 per deletion run. Otherwise it's 1 query per file in the directory. I have a limit of 50 file unlinks (configurable) per updating to limit the steady stream of unlinks. (one disk seek/access per unlink so if he has 2000 files to delete I don't think we want to send 2000 unlinks to the system) LoL

It's a simple script. I have it almost finished.

If you want to check user status then that will take an aditional query per run making it 3 total.

I hadn't really planned on making it look nice but perhaps this may be another utility that could be placed into the admin section?

Sponsored Links
Entire Thread
Subject Posted By Posted
Remove Orphan Attachments JoshPet 09/16/2002 8:37 PM
Re: Remove Orphan Attachments Aglavalin 09/16/2002 11:00 PM
Re: Remove Orphan Attachments JustDave 09/16/2002 11:31 PM
Re: Remove Orphan Attachments Dave_L_dup1 09/16/2002 11:35 PM
Re: Remove Orphan Attachments JustDave 09/17/2002 12:04 AM
Re: Remove Orphan Attachments JustDave 09/17/2002 12:25 AM
Re: Remove Orphan Attachments JustDave 09/17/2002 12:29 AM
Re: Remove Orphan Attachments JoshPet 09/17/2002 1:51 AM
Re: Remove Orphan Attachments JustDave 09/17/2002 1:55 AM
Re: Remove Orphan Attachments JoshPet 09/17/2002 1:58 AM
Re: Remove Orphan Attachments JustDave 09/17/2002 4:11 AM
Re: Remove Orphan Attachments JoshPet 09/17/2002 5:40 AM
Re: Remove Orphan Attachments JustDave 09/17/2002 1:08 PM
Re: Remove Orphan Attachments JoshPet 09/17/2002 4:02 PM
Re: Remove Orphan Attachments AKD96 04/11/2003 5:30 AM
Re: Remove Orphan Attachments JoshPet 04/11/2003 5:33 AM
Re: Remove Orphan Attachments AKD96 04/11/2003 5:40 AM
Re: Remove Orphan Attachments ExcelsiorDDZ 04/11/2003 6:14 AM
Re: Remove Orphan Attachments Joe Siegler 03/30/2004 6:48 PM
Re: Remove Orphan Attachments Jonny_Bravo 03/30/2004 9:08 PM
Re: Remove Orphan Attachments Joe Siegler 10/04/2004 10:07 PM
Re: Remove Orphan Attachments Zarzal 10/05/2004 1:02 AM
Re: Remove Orphan Attachments JoshPet 10/06/2004 5:14 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Zarzal
Zarzal
Berlin, Germany
Posts: 808
Joined: July 2001
Forum Statistics
Forums63
Topics37,575
Posts293,932
Members13,824
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,835
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)