I searched my name a ton for various reasons, mostly deleting dumb doxxing stuff. I will not stand for this name-searching-shaming.
I’m not 100% sure i’m serious, but I feel like there is tons of data an admin can pull and I kinda rather it won’t be shared publicly? Like making fun of ins0 is whatever, but in general if it’s not publicly available, I don’t think it should be shared.
I very much agree and will never do that. I just saw something I thought the community would find funny, and since it’s at luckbox/inso’s expense, I didn’t think it was a big deal. But I see your concern and realize it may have been a little out of line. Sorry.
very honestly I just don’t care enough to look at much. I can get a lot of general site stats but the only ones I really care about are stuff like pageviews, daily active users, number of posts. Stuff that directly relates to the health of the site.
and as an aside I wouldn’t mock a regular poster for a lot of vanity searches. That’s normal behavior. What’s not normal is searching nearly once per day for your username in a forum you don’t even post in and is full of people you hate. That strikes me as weird and sad.
It probably is. My personal preference is making fun of people for being assholes and douches, which I imagine they both qualify, and not for being sad and weird, which they probably qualify for too.
I fully get that they don’t deserve any protection, just not my thing.
But again, it’s not like it’s a big deal. It’s clear that you have no intention to share more info so we’re all good.
I don’t do vanity searches here because I’m not that likely to miss something. I vanity search 2p2 a couple times a month to see if anyone is trying to talk to me (or talk about me), but that lame software doesn’t have ‘@’.
I still don’t know if it’s just me being dumb, but the search here seems to suck.
What’s an example of something you’ve tried+failed to search for?
The more shocking the better obv, but I’m just trying to imagine how specific your searches might be on a mundane level too.
I’ve never had complaints but I don’t really search much.
The Vim navigation keys and now this. You are really crushing it!
Bookmarks are the shit
You could save a lot of time by just PMing me
There’s always the possibility one of you psychos is stalking them. Own up!
Could @anon46587892 or @jmakin do this query about user likes?
WITH pairs AS (
SELECT p.user_id liked, pa.user_id liker
FROM post_actions pa
LEFT JOIN posts p ON p.id = pa.post_id
WHERE post_action_type_id = 2
)
SELECT liker liker_user_id, liked liked_user_id, count(*)
FROM pairs
GROUP BY liked, liker
ORDER BY count DESC
I know ggoreo did this before, I’m just curious on the results with updated data. It’s nothing urgent, just for fun. Thanks.
Damnit I was hoping there was an update because I’ve been raking in the likes lately. Gimme dat ratio!
This is about as many characters as I can include in a post so it’s only the top portion of the list. If you want all the data I can send you a CSV file or probably increase the character limit somewhere and post all the numbers, though I should probably ask if there’s an issue with me sharing this data. I think jmakin stopped his stats b/c some people didn’t like seeing all those numbers public
I don’t get what this table is showing?
Who has given who the most likes, e.g. King_of_NY has liked 1480 of beetlejuice’s posts, wirelessgrinder has liked 1309 of Riverman’s posts etc.
Thanks ggoreo. Is it possible to send all of the data? Last time you uploaded it to a pastebin.
I’m gonna have to deep dive to figure out what’s so compelling about @Trolly for me. Especially with those scalding hot takes. I may be a bigger fan than I realized!
Dat ratio of likes received/likes given 
Apparently I have replied to more people than anyone else on the forum 
King_of_NY
beetlejuice
wirelessgrinder
Riverman
StimAbuser
otatop
Marksman
Nicholasp27
RiskyFlush
boredsocial
oneeyedtripping
Smacc_25
microbet
commonWealth
JohnnyTruant
TrueNorth32
Trolly
ViridianDreams
jalfrezi
skydiver8
realDonaldTrump
suzzer99
MattyLice