Star Trek
r/startrek: The Next Generation
Star Trek news and discussion. No slash fic...
Maybe a little slash fic.
New to Star Trek and wondering where to start?
Rules
1 Be constructive
All posts/comments must be thoughtful and balanced.
2 Be welcoming
It is important that everyone from newbies to OG Trekkers feel welcome, no matter their gender, sexual orientation, religion or race.
3 Be truthful
All posts/comments must be factually accurate and verifiable. We are not a place for gossip, rumors, or manipulative or misleading content.
4 Be nice
If a polite way cannot be found to phrase what it is you want to say, don't say anything at all. Insulting or disparaging remarks about any human being are expressly not allowed.
5 Spoilers
Utilize the spoiler system for any and all spoilers relating to the most recently-aired episodes, as well as previews for upcoming episodes. There is no formal spoiler protection for episodes/films after they have been available for approximately one week.
6 Keep on-topic
All submissions must be directly about the Star Trek franchise (the shows, movies, books etc.). Off-topic discussions are welcome at c/quarks.
7 Meta
Questions and concerns about moderator actions should be brought forward via DM.
Upcoming Episodes
| Date | Episode | Title |
|---|---|---|
| 11-07 | LD 5x04 | "A Farewell to Farms" |
| 11-14 | LD 5x05 | "Starbase 80?!" |
| 11-21 | LD 5x06 | "Of Gods and Angels" |
| 11-28 | LD 5x07 | "Fully Dilated" |
| 12-05 | LD 5x08 | "Upper Decks" |
In Production
Strange New Worlds (2025)
Section 31 (2025-01-24)
Starfleet Academy (TBA)
In Development
Untitled comedy series
Wondering where to stream a series? Check here.
view the rest of the comments
I had this issue as well on my instance. Here's how I fixed it with SQL commands included. TL;DR Turn on CAPTCHAs, don't use email verification (as they will spam the shit out of it), and use SQL commands to ban all of them in one fell swoop.
Yo thanks for this. I'm not rlly good with dbs and was trying to figure out how to mass get ride of some boy accounts. Luckily I noticed B4 it got super bad
Yeah, I heavily modified and expanded upon someone else's query to seek out and destroy more of the accounts. Theirs is basically pattern-matching some of the Gmail-with-numbers spam, but there's a subset using junk@junk with no actual .TLD to try and get people's email verification to bounce. Someone else said that ended up in people getting their email relay account suspended, hence why email verification (at least without CAPTCHAs) is a fairly bad idea. I added a table join and some extra matching to find some of those extra bogus "emails," which typically results in quite a few more accounts being banned. There are two major caveats with my method: 1) it doesn't delete the accounts, which is really just a simple modification to the query to "fix," and 2) it doesn't deal with spam accounts that have no email attached, although those seem to be a fairly small subset of the account spam. I'll see if there is an easier way to deal with those, but getting most banned or deleted is still pretty easy.