Forum out of space / Uploader Folder is Full

[djensen]

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.

[MrMalachiCrunch]

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.

[djensen]

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.

[MrMalachiCrunch]

cron job?

[Panther]

Uploader is full again.

[djensen]

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

[lexgreat]

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

[djensen]

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

[UnknownSoldier]

@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-)

[UnknownSoldier]

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

[lexgreat]

@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:

[Cow]

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

[MrMalachiCrunch]

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.

[Veqryn]

well wait a sec, we definitely do not want to be able to delete posts in the “play games section”

it is “no delete, no modify” for a reason: to prevent cheating

also, i think that there should be a way to delete attachments without deleting the post

we should not need a specific position or admin just for deleting attachments (what a thankless boring job).  it should be automated.

[djensen]

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.

[Veqryn]

i don’t really know what you are saying because I don’t know anything about html or forum stuff.

so long as you are not changing anything that requires a change in TripleA then I am good.  the guy who coded the part of triplea that posts turns to your forum is no longer active, and I don’t think I know how to change the code in that part of the engine.

game files have two forms
there is a “test file”, which currently is called “Test.jpg”

and then there is the game file, which normally is called “triplea_<forum thread=”" id=“”>_<nation name=“”><round number=“”>.tsvg"

1 file per user per game id is a decent solution.  in a game with 2 people it would allow for the last 2 game saves to stay up.
maybe it could be 1 file per user per game id plus and additional 1 or 2 most recent savegame.  that would allow the last 3 or more game saves to stay up.

you could filter them using “triplea_<forum thread=”" id=“”>_**.tsvg" (where ** is any number of wildcards)</forum></round></nation></forum>

[Cow]

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

[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.

[Field marshall]

@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.

[Cow]

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