The forum only has one passable poster
-
Just think about it: if you see a username that you don't recognize, and it's not an Article topic, are you surprised?
-
if you see a username that you don't recognize, and it's not an Article topic, are you surprised?
no because right now it's just a new bot someone created.
-
True
-
-
there has been a lot of attrition.
Yeah the likes/dave is a traitor thread also seems to have slowed down. Then again maybe that is not really a bad thing.
-
Yeah, with posters that are currently active, it would have to be a coordinated effort to get a passable poster badge.
And then one is going to be the asshole we doesn't play ...
-
I find this tends to be true on most forums, partly (I'm guessing) due to the fact that once a circle of insiders is established, it's hard for newcomers to crash the party (if only due to psychological inhibitions).
In our case it is also because they might feel slightly intimidated by certain members and the way opinions are expressed.
-
You can also tell because we're suspended.
Oh. Was he unappreciative of new visitors then?
-
@chubertdev Is Doing It Wrongâ„¢<t3241p103>
-
but there seems to be a pretty small core that actually bother to "like" posts.
And some of us are hard core against clicking heart buttons.
-
Yeah the likes/dave is a traitor thread also seems to have slowed down. Then again maybe that is not really a bad thing.
It's in endurance mode. You can only sprint for so long.
-
Oh. Was he unappreciative of new visitors then?
He hasn't said exactly why. He did come here and we had some exchanges in the Likes thread (now named for him). Suspensions have since been revoked.
-
He hasn't said exactly why. He did come here and we had some exchanges in the Likes thread (now named for him). Suspensions have since been revoked.
I was more thinking about @johnsnick being flamed in the civilized discussion of the ms office file format.
-
He did come here and we had some exchanges in the Likes thread (now named for him).
Saw that after I'd posted.
-
Saw that after I'd posted.
Sleeping is a barrier to catching up with threads in the right order.
-
Up to 16 likes on the OP.
-
I'm holding out.
-
It's gotten to the point where people like @error don't post outside of Coding Help
@PJH, can you tell what has the most likes after Lorne's post? Maybe we can get this badge for another user.
-
@morbiuswilters will be back to crapflood us in a few months.
-
I don't even know who that is.
-
You will. Soon enough he'll join the conversation, and he'll get these damned toasters instead of me.
-
Maybe we'll get passable posters. If he can find the like button
-
And pitch a fit if anyone changed their icon ever as he apparently doesn't read usernames and only ids by avatar.
-
And pitch a fit if anyone changed their icon ever as he apparently doesn't read usernames and only ids by avatar.
Fantastic, I will completely fly under his radar!
-
Let's all piss him off, then change avatars.
-
@PJH, can you tell what has the most likes after Lorne's post? Maybe we can get this badge for another user.
SELECT count(post_id), post_id FROM post_actions WHERE post_action_type_id = '2' GROUP BY post_id ORDER BY count(post_id) DESC
Produces, from an old backup I had lying around:
"count","post_id" "70","12788" "64","12796" "61","12791" "59","12803" "53","12804" "52","12805" "51","12808" "49","12807" "48","12806" "47","12812" <snip>
Stick
post_id
on the end ofÂhttp://what.thedailywtf.com/p/
to get to the post.12788
's currently up to 79 likes now. Last entry in that backup was 2014-08-11 02:58:42. Getting last night's backup now, but they're over a GB now...
-
-
Can you please exclude /t/1000?
Heh. Found a better table/query:
SELECT "topic_id","post_number","like_count" FROM "restore"."badge_posts" ORDER BY like_count DESC LIMIT 25
"topic_id" "post_number" "like_count" "1000" "1" "69" "1000" "3" "61" "1000" "2" "59" "1000" "4" "57" "1000" "5" "51" "1000" "6" "51" "1000" "9" "50" "1000" "8" "48" "1000" "11" "47" "1000" "7" "47" "1000" "17" "46" "1000" "15" "46" "1000" "14" "46" "1000" "21" "45" "1000" "10" "45" "1000" "12" "45" "1000" "16" "45" "1000" "18" "45" "1000" "23" "45" "1000" "13" "44" "1000" "26" "44" "1000" "28" "43" "1000" "19" "43" "1000" "20" "43" "1000" "25" "42"
Not what you wanted?
SELECT badge_posts.topic_id, badge_posts.post_number, badge_posts.like_count, users.username FROM badge_posts, users WHERE topic_id != 1000 AND badge_posts.user_id = users.id ORDER BY like_count DESC LIMIT 25 "topic_id" "post_number" "like_count" "username" "407" "1" "24" "Lorne_Kates" "893" "1" "22" "Lorne_Kates" "1964" "1" "20" "DoctorJones" "1025" "8" "19" "ender" "1557" "1" "18" "Onyx" "953" "10" "17" "dhromed" "1161" "15" "17" "sam" "1025" "11" "17" "mott555" "1158" "52" "17" "Luhmann" "1504" "13" "17" "cartman82" "1590" "1" "16" "chubertdev" "407" "5" "16" "error" "1373" "1" "16" "GoatboyCH" "893" "6" "15" "Onyx" "270" "500" "15" "mott555" "1607" "1" "15" "Intercourse" "1481" "24" "15" "LoremIpsum" "1970" "1" "15" "Kuro" "1055" "1" "15" "Arantor" "1368" "17" "15" "Onyx" "238" "302" "15" "oesor" "254" "695" "15" "Zecc" "1048" "27" "14" "mott555" "1269" "10" "14" "ender" "1609" "78" "14" "Onyx"
-
Peaking at 15 likes. Must try harder.
-
Consider yerself lucky I'm not even in that list!
-
-
Up to 16 likes on the OP.
I'm not chipping in on this one. It doesn't feel right making @Keith a "Passable Poster".
-
And some of us are hard core against clicking heart buttons.
That's ok, you can L instead.
-
And pitch a fit if anyone changed their icon ever as he apparently doesn't read usernames and only ids by avatar.
Which is exactly why I started my avatar changing. Speaking of which, time to look for a new one.
-
-
-
-
Weird, the first record is wrong. That says 24 likes, he has over 25, that's his passable poster comment.
-
Remember it's an old backup - and the badge_posts 'table' is actually a view...
-
Oh, I'm surprised that it had that many likes in the past month.
-
GoatboyCH creates an account, makes one post, and disappears never to be seen again, but gets "Nice Topic" and "Mediocre Poster" for it.
-
From last night's backup:
SELECT row_number() OVER (ORDER BY like_count DESC) as n, badge_posts.topic_id, badge_posts.post_number, badge_posts.like_count, users.username FROM badge_posts, users WHERE topic_id != 1000 AND badge_posts.user_id = users.id ORDER BY like_count DESC LIMIT 50 "n" "topic_id" "post_number" "like_count" "username" "1" "407" "1" "27" "Lorne_Kates" "2" "1964" "1" "24" "DoctorJones" "3" "893" "1" "22" "Lorne_Kates" "4" "1025" "8" "21" "ender" "5" "254" "1396" "20" "DoctorJones" "6" "1025" "11" "20" "mott555" "7" "254" "1605" "20" "aliceif" "8" "3042" "1" "20" "Matches" "9" "2263" "34" "20" "Cursorkeys" "10" "1025" "315" "19" "DoctorJones" "11" "2263" "38" "19" "jaloopa" "12" "3103" "60" "19" "Matches" "13" "2275" "1" "19" "WTF" "14" "1557" "1" "18" "Onyx" "15" "2128" "52" "18" "LoremIpsum" "16" "2229" "8" "18" "redwizard" "17" "2767" "1" "17" "codinghorror" "18" "953" "10" "17" "dhromed" "19" "2674" "57" "17" "Maciejasjmj" "20" "2594" "7" "17" "chubertdev" "21" "407" "5" "17" "error" "22" "1158" "52" "17" "Luhmann" "23" "1504" "13" "17" "cartman82" "24" "1161" "15" "17" "sam" "25" "2914" "341" "17" "boomzilla" "26" "3103" "20" "16" "cartman82" "27" "1373" "1" "16" "GoatboyCH" "28" "254" "695" "16" "Zecc" "29" "1999" "98" "16" "HardwareGeek" "30" "2860" "19" "16" "cartman82" "31" "2662" "1" "16" "blakeyrat" "32" "1368" "17" "16" "Onyx" "33" "2662" "81" "16" "blakeyrat" "34" "1607" "1" "16" "Intercourse" "35" "3096" "68" "16" "ben_lubar" "36" "1590" "1" "16" "chubertdev" "37" "1055" "1" "15" "Arantor" "38" "3096" "22" "15" "blakeyrat" "39" "2925" "39" "15" "Yamikuronue" "40" "270" "500" "15" "mott555" "41" "1025" "239" "15" "algorythmics" "42" "893" "6" "15" "Onyx" "43" "1025" "404" "15" "PJH" "44" "238" "302" "15" "oesor" "45" "2642" "2" "15" "VinDuv" "46" "3103" "1" "15" "Matches" "47" "1556" "2" "15" "DoctorJones" "48" "1353" "135" "15" "Zecc" "49" "1970" "1" "15" "Kuro" "50" "2628" "56" "15" "chubertdev"
-
Nuts, my peak is still 15.
-
Now @DoctorJones should also get the badge when the job runs as he was really close (EDIT: before I pushed him over).
-
@DoctorJones won't get his badge from me. I already liked his post that's at 24.
-
-
My highest ranking one:
"43" "1025" "404" "15" "PJH"
Should I be at all concerned that this one is about midget porn?
-
-
And I just put the 25th like on the post. BINGO!
-
Total number of likes anyone?
Edit - excluding /t/1000 of course...