None

cracker foids: ❌

American Citizens: ❌

non-autists: ❌

they/thems: ❌

Elon won

None

Spammers are just creating accounts on instances that have no registration verification and creating thousands of posts that ping random people with images. The spam seems to originate from a group of Japanese script kiddies that just wanted to vandalise Misskey and now every instance is getting false-flag spam messages from thousands of accounts over thousands of instances.

https://i.rdrama.net/images/17083094243351407.webp

The details are actually a bit fuzzy since it's all speculation outside of some discord screenshots and the spam that is actually sent, but it doesn't matter in the grand scheme of things. Since there's like thousands of tiny instances and nothing stops spammers from just making their own, the only guaranteed solution right now is to make a whitelist of servers that moderate account registration. I made one post on an irrelevant instance earlier and got three of these spam messages from different accounts on different instances.

https://mastodon.social/@Gargron/111953045633249137

There is an ongoing spam attack on the fediverse for the last couple of days. It's more widespread than before, as attackers are targeting smaller servers to create accounts. Before, usually only https://mastodon.social was targeted and our team could take care of it. For server administrators out there: If you don't need open registrations, switch over to approval mode. If you do, blocking disposable e-mail providers is a massive stopgap to the problem. Mastodon also supports hCaptcha.

I just have to point out that all of this is being done by a community of 12-15 year olds because ActivityPub is shit actually :marseylaugh:. The script to test for open registration nodes is literally this:

export async function isNoCapNoMail(host: string, softwareType: string) {
 if (softwareType !== "misskey") {
   return false;
 }

 const endpoint = `https://${host}/api/meta`;
 try {
   const res = await fetch(endpoint, {
     method: "GET",
     headers: {
       "Content-Type": "application/json",
     },
   });

   const json = await res.json();

   if (json["emailRequiredForSignup"]) {
     return false;
   }

   if (
     json["enableHcaptcha"] ||
     json["enableMcaptcha"] ||
     json["enableRecaptcha"]
   ) {
     return false;
   }

   return true;
 } catch {
   return false;
 }
}

Someone's definitely improved this by now since it does more than just misskey, but you get the point. Just imagine the damage someone could do with an integrated captcha solver. Most ActivityPub software doesn't have any kind of middleware for handling incoming messages and maybe drop them based on filters, but that'll probably change soon.

More rumours elsewhere

I have found some more information on this CPTK, the japbros probably already knew but uhh:

  1. They're just skids :marseyhacker:

  2. Most of them are like kids (literal 11-14 year olds) :carpemo:

  3. They have done many raids in the past, they DDoS'd 2chan back in 2022 and they've taken legal action against them :marseygrouns:

  4. Their old group imploded due to infighting :marseymushroomcloud:

  5. According to the Karasawa Wiki (yeah that lawyer who got doxxed like 100 times for being a 2chan troll), their leaders have been doxxed, MULTIPLE times. And they're all kids. :marseypedobear:

Anyway good luck to Bluesky on their fediverse integration lol

None

:#marseyhesright:

![](/images/16578164433688195.webp)

None

Something something SJWs

Edit: This actually has nothing to do with git but I was in a hurry to post so enjoy your fake news

Orange Site discussion

None
Reported by:

Prepare for the enshittification and bedbathandbeyonding of Magic the gathering.

If I had to make a guess as to why, given the fact that the people they laid off were all senior leaders and the numbers are good, it would be preparing for a pump and dump.

if you want to be able to pump and dump a really strong brand then you need to be able to have leaders who don't mind burning the brands equity in order to make money. My guess is that specifically what intending to do here.

Change the leadership, make new “sticky” products, pump revenue numbers, then spin out a public offering of the magic brand that looks like a great new reboot and refresh.

However the brand is only there to smuggle in the subscription model around new products that have strong margin. Everyone* gets rich cause they slaughtered their fattest pig and yet another cultural staple is killed.

>However the brand is only there to smuggle in the subscription model around new products that have strong margin

you know like selling pieces of paper for over a $100 a box for the last few decades?

I've seen people say that it would be nice to regulate loot boxes in video games, but they can't figure out how to do it without banning Magic's business model. I never understood why that would be a problem.

The genius thing about Magic is that it doesn't place individual value on a card... Video games don't have such safeguards. It's all on the studios servers and they can adjust value on the fly... I feel that's an intrinsic difference that places a video game closer to a casino ("the house always wins") than a TCG (throw out what you think is worth and let the community sort it out).

>online loot boxes

:marseyrage:

>physical loot boxes

:marseyyes:

https://i.imgur.com/lTHBaOW.jpeg

:marseylaughpoundfist:

None

orange site sneeds: https://news.ycombinator.com/item?id=37804493

https://i.rdrama.net/images/16967106131122804.webp :#marseyxd:

None
172
:marseyitsover::marseychingchongitsover::marseyitsaover::marseyitsoveryall: YouTube tests blocking videos unless you disable ad blockers | Hacker News

BeepingComputer

PoorphonePolice

IGN

Asked for comment, a Google spokesperson told IGN that it was a "small experiment."

"We're running a small experiment globally that urges viewers with ad blockers enabled to allow ads on YouTube or try YouTube Premium," they said via email. "Ad blocker detection is not new, and other publishers regularly ask viewers to disable ad blockers."

https://i.rdrama.net/images/16837629631989625.webp

reddit discus

https://old.reddit.com/r/technology/comments/13e2cay/youtube_has_started_blocking_ad_blockers/?sort=controversial

https://old.reddit.com/r/technology/comments/13e30b6/youtube_tests_blocking_videos_unless_you_disable/?sort=controversial

https://old.reddit.com/r/youtube/comments/13cfdbi/apparently_ad_blockers_are_not_allowed_on_youtube/?sort=controversial <- This is where it was originally first posted (1k Updoots and 1k cumments)

poster note: I tried adding all the 'its over' to capture the diversity that this decision will affect and was met with this

https://i.rdrama.net/images/16837639136406388.webp

i do not feel bad at all :marseyindignant:

None
231
>valued at 850 billion dollars
None
62
4chan to shut down permanently on September 22

Discuss

@JoeBiden @Soren

None

https://twitter.com/8teapi/status/1706520893621784780

Vicious Self-Degradation

you Google

Quora spots query and id's as frequent

Quora uses ChatGPT to generate answer

ChatGPT hallucinates

Google picks up Quora answer as highest probability correct answer

ChatGPT hallucination is now canonical Google answer

https://i.rdrama.net/images/1695737309821527.webp

https://i.rdrama.net/images/1695737309941685.webp https://i.rdrama.net/images/16957373102218459.webp

None

Someone should post this to /r/antiwork or any other leftoid sub on reddit. Maybe as a screenshot with a juicy title.

None

So fresh orange site is just addressing it: https://news.ycombinator.com/item?id=38309611

None
Reported by:
115
need help with "simps" and "simps for"

so yesterday I restored "simps" and "simps for" but made them only count post votes

the reason is because the queries that would include comment votes take way too long when they run on powerusers which causes timeouts that slow down the whole site

here's 2 examples that use my user id


QUERY 1 (for my simps): 25 seconds

explain analyze SELECT commentvotes.user_id AS commentvotes_user_id, count(commentvotes.user_id) AS count_1
        FROM commentvotes JOIN comments ON comments.id = commentvotes.comment_id
        WHERE comments.ghost = false AND comments.is_banned = false AND comments.deleted_utc = 0 AND commentvotes.vote_type = 1 AND comments.author_id = 1 GROUP BY commentvotes.user_id ORDER BY count(commentvotes.user_id) DESC;
                                                                                 QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=101326.43..101331.71 rows=2111 width=12) (actual time=25292.671..25371.754 rows=1844 loops=1)
   Sort Key: (count(commentvotes.user_id)) DESC
   Sort Method: quicksort  Memory: 135kB
   ->  Finalize GroupAggregate  (cost=100675.05..101209.87 rows=2111 width=12) (actual time=25266.703..25370.338 rows=1844 loops=1)
         Group Key: commentvotes.user_id
         ->  Gather Merge  (cost=100675.05..101167.65 rows=4222 width=12) (actual time=25266.210..25368.234 rows=4089 loops=1)
               Workers Planned: 2
               Workers Launched: 2
               ->  Sort  (cost=99675.02..99680.30 rows=2111 width=12) (actual time=25174.301..25174.732 rows=1363 loops=3)
                     Sort Key: commentvotes.user_id
                     Sort Method: quicksort  Memory: 113kB
                     Worker 0:  Sort Method: quicksort  Memory: 113kB
                     Worker 1:  Sort Method: quicksort  Memory: 111kB
                     ->  Partial HashAggregate  (cost=99537.35..99558.46 rows=2111 width=12) (actual time=25172.482..25173.130 rows=1363 loops=3)
                           Group Key: commentvotes.user_id
                           Batches: 1  Memory Usage: 241kB
                           Worker 0:  Batches: 1  Memory Usage: 241kB
                           Worker 1:  Batches: 1  Memory Usage: 241kB
                           ->  Nested Loop  (cost=119.48..99291.83 rows=49104 width=4) (actual time=70.552..25064.475 rows=25093 loops=3)
                                 ->  Parallel Bitmap Heap Scan on comments  (cost=119.04..12311.25 rows=4943 width=4) (actual time=57.412..246.591 rows=4380 loops=3)
                                       Recheck Cond: (author_id = 1)
                                       Filter: ((NOT ghost) AND (NOT is_banned) AND (deleted_utc = 0))
                                       Rows Removed by Filter: 263
                                       Heap Blocks: exact=3882
                                       ->  Bitmap Index Scan on comments_user_index  (cost=0.00..116.08 rows=12353 width=0) (actual time=36.276..36.277 rows=14518 loops=1)
                                             Index Cond: (author_id = 1)
                                 ->  Index Scan using commentvotes_pkey on commentvotes  (cost=0.44..17.28 rows=32 width=8) (actual time=1.447..5.654 rows=6 loops=13141)
                                       Index Cond: (comment_id = comments.id)
                                       Filter: (vote_type = 1)
                                       Rows Removed by Filter: 0
 Planning Time: 0.764 ms
 JIT:
   Functions: 60
   Options: Inlining false, Optimization false, Expressions true, Deforming true
   Timing: Generation 19.575 ms, Inlining 0.000 ms, Optimization 6.942 ms, Emission 122.562 ms, Total 149.079 ms
 Execution Time: 25453.921 ms
(36 rows)






QUERY 2 (for the ppl i simp for): 13 seconds

explain analyze SELECT comments.author_id AS comments_author_id, count(comments.author_id) AS count_1 
        FROM comments JOIN commentvotes ON comments.id = commentvotes.comment_id 
        WHERE comments.ghost = false AND comments.is_banned = false AND comments.deleted_utc = 0 AND commentvotes.vote_type = 1 AND commentvotes.user_id = 1 GROUP BY comments.author_id ORDER BY count(comments.author_id) DESC;

                                                                                         QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=234059.08..234064.81 rows=2293 width=12) (actual time=13511.566..13632.448 rows=3074 loops=1)
   Sort Key: (count(comments.author_id)) DESC
   Sort Method: quicksort  Memory: 241kB
   ->  Finalize GroupAggregate  (cost=233350.16..233931.10 rows=2293 width=12) (actual time=13502.703..13630.725 rows=3074 loops=1)
         Group Key: comments.author_id
         ->  Gather Merge  (cost=233350.16..233885.24 rows=4586 width=12) (actual time=13502.611..13628.135 rows=6597 loops=1)
               Workers Planned: 2
               Workers Launched: 2
               ->  Sort  (cost=232350.14..232355.87 rows=2293 width=12) (actual time=13404.805..13405.287 rows=2199 loops=3)
                     Sort Key: comments.author_id
                     Sort Method: quicksort  Memory: 203kB
                     Worker 0:  Sort Method: quicksort  Memory: 199kB
                     Worker 1:  Sort Method: quicksort  Memory: 197kB
                     ->  Partial HashAggregate  (cost=232199.23..232222.16 rows=2293 width=12) (actual time=13398.724..13399.556 rows=2199 loops=3)
                           Group Key: comments.author_id
                           Batches: 1  Memory Usage: 369kB
                           Worker 0:  Batches: 1  Memory Usage: 369kB
                           Worker 1:  Batches: 1  Memory Usage: 369kB
                           ->  Nested Loop  (cost=0.87..231821.34 rows=75577 width=4) (actual time=81.541..13275.534 rows=52615 loops=3)
                                 ->  Parallel Index Scan using cvote_user_index on commentvotes  (cost=0.44..129890.24 rows=78687 width=4) (actual time=64.216..9154.821 rows=55000 loops=3)
                                       Index Cond: (user_id = 1)
                                       Filter: (vote_type = 1)
                                       Rows Removed by Filter: 90
                                 ->  Index Scan using comments_pkey on comments  (cost=0.43..1.30 rows=1 width=8) (actual time=0.072..0.072 rows=1 loops=165000)
                                       Index Cond: (id = commentvotes.comment_id)
                                       Filter: ((NOT ghost) AND (NOT is_banned) AND (deleted_utc = 0))
                                       Rows Removed by Filter: 0
 Planning Time: 0.721 ms
 JIT:
   Functions: 60
   Options: Inlining false, Optimization false, Expressions true, Deforming true
   Timing: Generation 8.837 ms, Inlining 0.000 ms, Optimization 11.450 ms, Emission 167.933 ms, Total 188.220 ms
 Execution Time: 13635.714 ms
(33 rows)

so i need help, how do I make them run faster or what indexes do I make, i didnt actually read the explain analyze outputs I posted here cuz im too lazy and need to take a shower rn so the answer might be pretty obvious (correct answer gets 50k marseybuckerinos and a code contributer badge)

None
None
Reported by:
  • PolPotEnjoyer : It's only bad because he didn't talk about banning all AI

Some wrongthink in the dead comments:

how do these assclowns never learn to not trust the government?

by "somecompanyguy", who has an important message in his bio


I mean seriously? guy takes a massive lead - steals data, and then proposes a license moat? come on. Fu*k this guy.

by "3327", who doesn't know he's shadowbanned


Sam Altman CEO of OpenAI cries Wolf to Senate panel, decides to play on the fear narrative (which politicians take hook, line and sinker) - - to call for licensing and regulation - - which only benefits major players, of course which huge pockets to bribe politicians even more.

Classic play to elbow out upstart small competitors . . . .

by "stevespang", who doesn't know he's shadowbanned


If safety standards is the r-slurred political correctness filter of chatGPT this will only lead to bad consequences

by "davidguetta", who doesn't know he's shadowbanned


I'm starting to think that OpenAI is a new Facebook, and their CEO is a dangerous butthole

by "ConanRus", who...

None

![](/images/16734611469408143.webp)

None

Re-uploaded for my rate-limited bros

Notice how the rock does the same thing irrespective of which way the magnet is oriented? Notice the absolute lack of refrigeration equipment? This is the real deal. I feel like we can finally relax. Everything's going to be just fine.

None

https://news.ycombinator.com/item?id=32925580

CENSOR-RESISTANT PAYMENT PROCESSING

Sign up today to take advantage of seamless and low-cost payment processing from Parallel Economy.

Simplified Pricing

Flat-rate pricing keeps it simple with no monthly surcharges. 2.98% + 15¢ for in-app, eComm, keyed, and non-qualified.

Streamlined

A single merchant account means signup, setup, and account management is easier than ever.

Next-Day Funding

Fast Funding gives you next-day funding at no extra cost.

White-Glove Service

Providing fast, friendly, and helpful merchant support is our top priority.

https://i.rdrama.net/images/16841350292775776.webp

:#soyjaktalking:

Link copied to clipboard
Action successful!
Error, please refresh the page and try again.