The forum only has one passable poster
-
-
SELECT category_id, count(*), name FROM category_users cu JOIN categories c ON c.id = cu.category_id WHERE notification_level = '0' GROUP BY category_id, name ORDER BY count(*) DESC "category_id" "count" "name" "26" "30" "One Post" "16" "8" "Bug" "8" "5" "Article" "3" "3" "Meta" "19" "2" "FAQs" "14" "2" "Coding Help" "13" "1" "General" "10" "1" "Side Bar WTF" "20" "1" "Funny stuff" "28" "1" "Programmers' Testing" "21" "1" "Coder Challenge" "17" "1" "The I-Hate-Oracle Club"
-
"17" "1" "The I-Hate-Oracle Club"
Who is that retard that loves Oracle? Larry is that you?
-
The same person, I suspect, who's ignored most of the other cat's with
"1"
's. I'm not going to go digging for whoever t is.
-
It's Alex, isn't it?
-
Smart money is on @codinghorror who continues to lurk around here for reasons unknown.
-
Smart money is on @codinghorror who continues to lurk around here for reasons unknown.
Since he doesn't post, how does he retain his Regular status? Does he just use his admin powers to promote himself? Or maybe he PMs other admins, which counts as "posting" according to Dicsores.
-
I dunno... I don't see the shields on @codinghorror, @sam or @eviltrout that I do on @PJH's profile... (then again I don't see that on Alex's either) so I don't know what's up with that.
-
Only moderators get shields, admins no longer get them.
-
Only moderators get shields, admins no longer get them.
Please help me understand the leap of logic behind this decision.
-
I pushed for this change.
If an admin wants a "glyph" they can push the "make me moderator button", the glyph is communicating that a user is actively moderating a forum something admins do not necessarily do.
For example I do not actively moderate the 50 sites we host.
-
Hmm. I get that, but I don't quite understand the need to be admins on those sites at this stage.
-
Does @PJH have the power to resolve that defect?
-
@PJH, any way I can get a posts read re-count on me now?
I have no way to tell if there's still anything old that I haven't read because dicsourse doesn't seem to have a way for me to explicitly list unread posts or topics with unread contents in the middle of them, just the "it's 100% new, or it's got X posts since you last saw it". But no display for "you skipped 80 posts in the middle, you might want to go back and re-read!"
All I know is I currently have nothing new, nothing unread, and nothing muted. As of midnight Central Time.
-
@PJH, any way I can get a posts read re-count on me now?
[postgres@lenovo ~]$ #Date of backup [postgres@lenovo ~]$ psql -c ' SELECT MAX(created_at) FROM post_actions; ' max ---------------------------- 2014-09-24 06:37:21.280732 (1 row) [postgres@lenovo ~]$ # Posts read and days visited_at [postgres@lenovo ~]$ psql -c ' SELECT row_number() OVER (ORDER BY sum(posts_read) DESC) as n, sum(posts_read) as "Posts read", count(*) as "Days visited", u.username as "User id" FROM user_visits v JOIN users u on u.id = v.user_id GROUP BY u.username ORDER BY sum(posts_read) DESC LIMIT 25 ' n | Posts read | Days visited | User id ----+------------+--------------+----------------- 1 | 88175 | 97 | VinDuv 2 | 85689 | 126 | ChaosTheEternal 3 | 85582 | 128 | PJH 4 | 85496 | 125 | Keith 5 | 84682 | 126 | dkf 6 | 82694 | 129 | blakeyrat 7 | 82183 | 129 | ben_lubar 8 | 79282 | 116 | darkmatter 9 | 79281 | 88 | Yamikuronue 10 | 78474 | 85 | M_Adams 11 | 77732 | 104 | Arantor 12 | 77417 | 120 | Maciejasjmj 13 | 76783 | 113 | antiquarian 14 | 74125 | 120 | Luhmann 15 | 72356 | 100 | cartman82 16 | 71235 | 106 | HardwareGeek 17 | 70099 | 109 | mott555 18 | 69338 | 120 | boomzilla 19 | 66759 | 91 | chubertdev 20 | 65767 | 85 | aliceif 21 | 63413 | 93 | locallunatic 22 | 62733 | 102 | Kuro 23 | 59895 | 115 | loopback0 24 | 58595 | 106 | jaloopa 25 | 58491 | 90 | ookami (25 rows) [postgres@lenovo ~]$
-
damn... 9,000 unread posts that dicsourse has hidden from me.
-
I suspect there are lacunae in that thread that never got marked read for me. I got really behind during vacation and went through liking pretty fast. Still...~20K unread posts‽ At least my attendance is pretty good.
-
I suspect there are lacunae in that thread that never got marked read for me. I got really behind during vacation and went through liking pretty fast.
yea, i had my readerbot do that thread specifically.
I probably accidentally skipped a lot of posts while testing & debugging readerbot. i also found that occasionally dicsourse gets too bogged down to send/accept the "read" status transmissions, so it's possible I got no credit for some things. But I'm surprised it's 9,000 posts missed.
-
Discobug?
-
Why are you guys using PJH as a fucking database administration app? Leave him alone. Nobody gives a shit about your various internetpointzzzzzzz in the Discourse database.
-
Feature request: Commentable Likes.
-
Why are you guys using PJH as a fucking database administration app? Leave him alone.
I get the impression that he's quite enjoying wrapping his head around Discourse's database structure and running custom queries on it. I may be wrong, but I'm sure he'll make it clear to people if and when he's had enough.
-
How about a poll inside of a PM?
-
The bigger problem is, why does anybody give a shit? "What's my Discourse number! Oh I'm a number 46.3! I have more forumpointzzz than you wheeeeeee!!! This makes me happy because I am an idiot!"
-
But ... when TDWTF annexes the country I live in, I want to have influence there and not be some unimportant loser!
-
The Law of Inevitable Statistic Abuse:
Any kind of numerical statistic displayed for users and/or
submissions (such as post/edit count, average score vote, or "karma"
points/"tokens" for users who contribute and/or are active), will
inevitably cause some people to go to insane lengths to try and drive up
their statistic(s) and/or lower those of others they dislike, usually
through attempts to cheat the system, even if the stat is never taken
the least bit seriously by the community. This represents a classic
example of Goodhart's Law.
First Corollary: Any kind of numerical
statistic based on users' votes will inevitably cause some people to
create ludicrous numbers of sockpuppet accounts for the sole purpose of
such abuse on that statistic.
Second Corollary: Nobody will care about any
numerical statistic. Despite this, people may end up citing such
statistics during a protracted flamewar, especially in the absence of
another argument or when it has been reduced to arguing semantics.
Third Corollary: Any system which rewards
members for any such statistic will inevitably prove counterproductive
as the people who actually get rewarded the most are those gaming the
system, which will irritate those who actually contribute honestly.
-
Yay Discourse. I tried to bold a part for emphasis, but Discourse.
-
Days Since Last Bug: 0<t3241p327>
-
yea, i had my readerbot do that thread specifically.
I found some from the beginning of my vacation earlier this summer. I went through a bit of it, but I don't want to run out of likes early in the day, so I'll probably go back later.
-
Only moderators get shields, admins no longer get them.
What? Why? How do you plan to denote admins then? The system should identify admins.
-
Why are you guys using PJH as a fucking database administration app? Leave him alone. Nobody gives a shit about your various internetpointzzzzzzz in the Discourse database.
You're much more amusing when you're offended about yourself. As usual, people getting offended for other people are just being dicks.
-
The bigger problem is, why does anybody give a shit? "What's my Discourse number! Oh I'm a number 46.3! I have more forumpointzzz than you wheeeeeee!!! This makes me happy because I am an idiot!"
Whatever the reasons were, we all now have one more!
-
"What's my Discourse number! Oh I'm a number 46.3! I have more forumpointzzz than you wheeeeeee!!! This makes me happy because I am an idiot!"
Considering that I openly admitted that 33% of my reading WAS DONE BY A BOT, I hardly think "forumpointzzz" for reading coverage are what I am seeking.
More like, I wonder if my bot has missed something, or if there really are 9000 PMs between @Vinduv and the others that have managed to read more posts.
-
I find it interesting that one of the two people tied for most days visited in that list, with one day more than even @PJH, is Mister Ragequit, aka @blakeyrat.
-
More like, I wonder if my bot has missed something, or if there really are 9000 PMs between @Vinduv and the others that have managed to read more posts.
I really don’t know. I have a grand total of 9 PMs (most of them were used to debug @SignatureGuy). and don’t use a bot for reading, only for liking in that thread.
-
I agree with whatever @VinDuv posted just above.<t3241p335>
-
hmm.. i wonder if i set every single topic in the forum to "watching", then it might show how many missing things I haven't read.
The notification spam would be hell though.
-
whadya know, another lunchtime = another wtdwtf forum death.
-
confirmed that setting a topic to "WATCHING" doesn't make it show you how many posts you haven't read if you have hit end and skipped a bunch.
what uselessness.
-
BUG:
Watching: You will be notified of every new post in this topic. A count of unread and new posts will also appear next to the topic. Tracking: A count of unread and new posts will also appear next to the topic.
expected: count of unread posts shows in topic list
actual: unread posts are not displayed unless they happen to be after the last post you actually did read.
-
This post is deleted!
-
Don't businesses usually listen to their customers when considering business decisions?
-
WHOA, Sam's post just disappeared itself.
-
I hate to say it, but if anyone else has a chance at getting Passable Poster it's @MottBott.
-
I finish the submit a couple weeks.<t3241p344>
-
My point was, administrators are unique users, with special privileges. That should be indicated to the other users. Also, as @arantor said:
Don't businesses usually listen to their customers when considering business decisions [which affect their customers]?
Edit: And your post was deleted while I was composing my reply. What's up with that?
-
And on topic, I think admins should have some kind of symbol. While it's true admins will not necessarily perform as moderators, there are a class of issues they can take care of which moderators cannot and so it's useful to know who they are.
-
Exactly!
-
WHOA, Sam's post just disappeared itself.
I clicked Sam's avatar to look at his profile, and this whole page went blank, except the click-on-avatar pop-up.
-
I clicked Sam's avatar to look at his profile, and this whole page went blank, except the click-on-avatar pop-up.
By the power of your bug, I summon: @DiscourseBot!