Forum out of space / Uploader Folder is Full

I have a semi-automatic script that cleans things up. The problem is with the way that SMF stores files. I must query the DB to get the file list and then delete all of these oddly named files.

It’s a pain.

Could you create a trigger in the DB that counts how many new oddly named files have been inserted then every X inserts do a delete based on the query?  Dynamic SQL generation was my thing using cough cough VB.

It can be done, it just needs to be done carefully. I’ve been meaning to put this in a cron job for quite some time.

cron job?

Uploader is full again.

Can a bunch of people go an delete old attachments? I don’t have time to address this until later tonight.

sure, but how would I do that? Only for admins I guess.

You can’t delete your own posts? I think you should be able to.

@djensen:

You can’t delete your own posts? I think you should be able to.

Would be happy to do so if someone knows how to  8-)

There is no “modify” button available on game posts in order to remove files in the game threads

@djensen:

You can’t delete your own posts? I think you should be able to.

I dont see how, djensen. I’d gladly remove all traces of my worst defeats  :wink:

Promote new admins specifically to clean up old threads. There are a bunch of active contributors on this site.

There is a position called Liaison.  From what I understand two whole users have this special position.  Perhaps this position should be responsible for tasks like this since their primary responsibility is getting rid of spam (and/or new users and donors) from what I understand.

I increased space by 2GB but that’s probably only going to last 2 weeks.

Veqryn, we need to work out a new solution. These files need to go to AWS S3 instead of the forums.

1. I’ll create a new upload form:
username
password?
game id
file

2. The upload will return a JSON object with the URL of the file uploaded.

3. The upload will check the file type and only allow game files.

Question: is there some other way I can verify that only game giles are being uploaded?

4. On the backend I will maintain only 1 file per user per game id. Having multiple copies floating around is overkill, especially when the file itself has the history of the game and everybody keeps copies on their own computers.

Please just have admins delete old games. Promote new admins if necessary. Solution so simple.

No, it’s not. You guys are creating more games than a large team of people can keep up with. I want something more permanent. The admin solution is a band-aid.

@djensen:

No, it’s not. You guys are creating more games than a large team of people can keep up with. I want something more permanent. The admin solution is a band-aid.

Just set the online game section to auto-prune after a certain time lapse, say ‘x’ many days or months.

All games eventually end. Having admins around to just remove them seems fine.