New: Occasional new 'crossed-arrows' icon in topic list
-
So, are you going to shed some light on the top "most changed titles" topics?
Filed Under: can you even query that per SQL?
-
So, are you going to shed some light on the top "most changed titles" topics?
Not sure what you're asking?
-
SELECT HowManyTimesWasTheTopicChange, TopicTitle, WhateverElse FROM DiscourseDatabase ORDER BY HowManyTimesWasTheTopicChange LIMIT/RANGE/WHATEVER 20
Filed Under: Perfect SQL!
-
Ah, right. May take a while - can't quite remember how/where topic title changes are...
-
If it's too much work, don't bother. It's more of a fun-thing.
Filed Under: Wait until the next boring meeting!
-
I kind of like new users stumbling into it and looking around, mouth agape, wondering WTF is this shithole I just fell in....
It's the perfect introduction to Discourse.
-
I like the current style :thumb_up:
-
If it's too much work, don't bother. It's more of a fun-thing.
while i agree i'll join my vote to the it would be cool if we could see that!
-
don't bother. It's more of a fun-thing.
But...that's the whole point of bothering. Because it's fun.
-
Will you take every Query @PJH puts up here and add it to the Statsbot, btw?
Filed Under: Statsbot needs to be a blue robot that steals every Query of the posts Dr.PJH sends at him!
-
SELECT HowManyTimesWasTheTopicChange, TopicTitle, WhateverElse FROM DiscourseDatabase ORDER BY HowManyTimesWasTheTopicChange LIMIT/RANGE/WHATEVER 20
[postgres@sofa ~]$ psql -d discourse -c " SELECT count(*) c, p.id, p.topic_id, p.post_number, t.title FROM post_revisions pr JOIN posts p ON p.id=pr.post_id JOIN topics t ON t.id=p.topic_id WHERE pr.modifications LIKE E'%HashWithIndifferentAccess\ntitle:\n%' GROUP BY p.id, p.topic_id, p.post_number, t.title ORDER BY c DESC LIMIT 30" c | id | topic_id | post_number | title -------+--------+----------+-------------+------------------------------------ 45253 | 81410 | 3218 | 1 | A million billion edits of the order of the editude (1) 492 | 12788 | 1000 | 1 | ⤨⤨⤨⤨ 49 | 86256 | 3297 | 1 | Poll: sexy 37 | 32113 | 1605 | 1 | Closed Poll: vote in this poll 23 | 79598 | 3158 | 1 | R͖̻̻̻̪̗̱̜̦̫͔̥̺̝̳E̪̖͕͙̥̰̬̯̱͉͙̥̤̱̖G̜̟͓̞͓̜̙̘̖̫̞̖̱̟̪R͙̪̣͉̞̩͙̘̝̮̙̦̫͔̯E͉̘̰̱̜͍̹̜̭̺̣̥͎͖͕S͔̻͇͔̰͉͖̱̩̺̟͖̰̰ͅS ZALGO GENERATOR ALL CAPS OHNOES!̭͍̖̺͕̻̜͍͎͔̜͓̯̘̲ 22 | 87637 | 3324 | 1 | Poll: is creating a poll really that difficult? 20 | 78207 | 3110 | 1 | <1000 17 | 60477 | 2589 | 1 | fiddler, topic leader, edit war (This is fiddle lock) 17 | 76116 | 3050 | 1 | Hah, nice look at all the hyphens on the URL 14 | 57293 | 2236 | 1 | Trainwrecks. Watch them? Prevent them? 14 | 8708 | 760 | 1 | Topic tracking breaks on split topics 13 | 63499 | 2640 | 1 | Abusing noscript 13 | 129584 | 4247 | 1 | ⛓ This is an inocent topic. Nothing to see here. 12 | 32812 | 1631 | 1 | Poll: Yet another poll test 12 | 69227 | 2815 | 1 | Poll: THREAD IS CLOSED AND IRRELEVANTlowercasetext 12 | 119362 | 3986 | 1 | Court reporter fined for courting reporting in court reporting. 11 | 62166 | 2628 | 1 | The Funny Stuff Thread 11 | 158563 | 5115 | 1 | Setting Fire To Sleeping Strawmen (now with extra Toniiiiiiiiiight, you're right, you're right, you're right) 10 | 79195 | 3142 | 1 | <script>alert("Rawr");</script> 10 | 78581 | 3125 | 1 | Poll: The Official Question, Bewitched by the Discosorceress! 9 | 187361 | 6857 | 1 | Cæn you mke a title edit stick? 9 | 187379 | 6859 | 1 | Cæn you mækœ a titlœ edit stick?? 9 | 43668 | 1887 | 1 | The Totally Legit Likes Thread - Trust me, I'm a Nigerian prince 9 | 79616 | 3161 | 1 | Reply & Edit … Race Conditions 8 | 78797 | 3131 | 1 | Borris: So, just HOW awesome is Discourse? 8 | 108173 | 3691 | 1 | Terribly Sexy Terrible Keith's Terrible Joke Thread of Terrible Okayishness Terrible 8 | 46261 | 1949 | 1 | meta.d 7 | 136007 | 4446 | 1 | Test your company's content filtering today! 7 | 38475 | 1823 | 1 | Closed Poll: "Likes" Thread - Since it's been asked (again)... 7 | 69484 | 2832 | 1 | blue bar test more (30 rows) [postgres@sofa ~]$
-
Will you take every Query @PJH puts up here and add it to the Statsbot, btw?
not every one, no. but most of the interesting ones.
i'm working on docs for sockbot now and the statsporn module is one of the ones i plan on documenting first.
of course since the queries are in source control if you want to contribute i welcome pull requests. ;-)
-
```sql
[postgres@sofa ~]$ psql -d discourse -c "
SELECT count(*) c, p.id, p.topic_id, p.post_number, t.title
FROM post_revisions pr
JOIN posts p ON p.id=pr.post_id
JOIN topics t ON t.id=p.topic_id
WHERE pr.modifications LIKE E'%HashWithIndifferentAccess\ntitle:\n%'
GROUP BY p.id, p.topic_id, p.post_number, t.title
ORDER BY c DESC
LIMIT 30"
c | id | topic_id | post_number | title
-------+--------+----------+-------------+------------------------------------
45253 | 81410 | 3218 | 1 | A million billion edits of the order of the editude (1)
492 | 12788 | 1000 | 1 | ⤨⤨⤨⤨
49 | 86256 | 3297 | 1 | Poll: sexy
37 | 32113 | 1605 | 1 | Closed Poll: vote in this poll
23 | 79598 | 3158 | 1 | R͖̻̻̻̪̗̱̜̦̫͔̥̺̝̳E̪̖͕͙̥̰̬̯̱͉͙̥̤̱̖G̜̟͓̞͓̜̙̘̖̫̞̖̱̟̪R͙̪̣͉̞̩͙̘̝̮̙̦̫͔̯E͉̘̰̱̜͍̹̜̭̺̣̥͎͖͕S͔̻͇͔̰͉͖̱̩̺̟͖̰̰ͅS ZALGO GENERATOR ALL CAPS OHNOES!̭͍̖̺͕̻̜͍͎͔̜͓̯̘̲
22 | 87637 | 3324 | 1 | Poll: is creating a poll really that difficult?
20 | 78207 | 3110 | 1 | <1000
17 | 60477 | 2589 | 1 | fiddler, topic leader, edit war (This is fiddle lock)
17 | 76116 | 3050 | 1 | Hah, nice look at all the hyphens on the URL
14 | 57293 | 2236 | 1 | Trainwrecks. Watch them? Prevent them?
14 | 8708 | 760 | 1 | Topic tracking breaks on split topics
13 | 63499 | 2640 | 1 | Abusing noscript
13 | 129584 | 4247 | 1 | ⛓ This is an inocent topic. Nothing to see here.
12 | 32812 | 1631 | 1 | Poll: Yet another poll test
12 | 69227 | 2815 | 1 | Poll: THREAD IS CLOSED AND IRRELEVANTlowercasetext
12 | 119362 | 3986 | 1 | Court reporter fined for courting reporting in court reporting.
11 | 62166 | 2628 | 1 | The Funny Stuff Thread
11 | 158563 | 5115 | 1 | Setting Fire To Sleeping Strawmen (now with extra Toniiiiiiiiiight, you're right, you're right, you're right)
10 | 79195 | 3142 | 1 | <script>alert("Rawr");</script>
10 | 78581 | 3125 | 1 | Poll: The Official Question, Bewitched by the Discosorceress!
9 | 187361 | 6857 | 1 | Cæn you mke a title edit stick?
9 | 187379 | 6859 | 1 | Cæn you mækœ a titlœ edit stick??
9 | 43668 | 1887 | 1 | The Totally Legit Likes Thread - Trust me, I'm a Nigerian prince
9 | 79616 | 3161 | 1 | Reply & Edit … Race Conditions
8 | 78797 | 3131 | 1 | Borris: So, just HOW awesome is Discourse?
8 | 108173 | 3691 | 1 | Terribly Sexy Terrible Keith's Terrible Joke Thread of Terrible Okayishness Terrible
8 | 46261 | 1949 | 1 | meta.d
7 | 136007 | 4446 | 1 | Test your company's content filtering today!
7 | 38475 | 1823 | 1 | Closed Poll: "Likes" Thread - Since it's been asked (again)...
7 | 69484 | 2832 | 1 | blue bar test more
(30 rows)[postgres@sofa ~]$
huh..... i don't remember that topic with the #1 slot.......
-
WHERE pr.modifications LIKE E'%HashWithIndifferentAccess\ntitle:\n%'
The hell does this do?of course since the queries are in source control if you want to contribute i welcome pull requests
You have seen my amazing SQL-skills uptopic. I will leave that stuff to you professionals
Filed Under: Needs an SQL that shows all the SQL in the forum!
-
-
```sql
c | id | topic_id | post_number | title
-------+--------+----------+-------------+------------------------------------
45253 | 81410 | 3218 | 1 | A million billion edits of the order of the editude (1)
492 | 12788 | 1000 | 1 | ⤨⤨⤨⤨What is that first record supposed to be?
-
i don't remember that topic with the #1 slot.......
Shame
-
Woah, Hanzo jam!
-
-
Yeah - I forgot the URL wouldn't Onebox for that category.
I missed it because I have One Post muted.
-
WHERE pr.modifications LIKE E'%HashWithIndifferentAccess\ntitle:\n%'
The hell does this do?Looks for the following part of the modification. The
E
indicates that there are escape codes in there (the newlines):
[postgres@sofa ~]$ psql -d discourse -c "
SELECT * FROM post_revisions WHERE modifications LIKE E'%HashWithIndifferentAccess\ntitle:\n%' LIMIT 1"
id | user_id | post_id | modifications | number | created_at | updated_at | hidden
-------+---------+---------+--------------------------------------------------------------+--------+----------------------------+----------------------------+--------
57555 | 606 | 78581 | --- !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| 11 | 2014-10-18 22:53:04.084382 | 2014-10-18 22:53:04.084382 | f
| | | title: +| | | |
| | | - 'Poll: The Official Question, now with 150% more Arantor!'+| | | |
| | | - 'Poll: The Official Question, now with 150% more Arantor?'+| | | |
| | | | | | |
(1 row)[postgres@sofa ~]$
-
This post is deleted!
-
http://i.imgur.com/UALXvG2.png
I appreciate the choice, but the styling on the menu is a little ugly.
-
The crossed-arrows indication is well-done now. It's obvious enough that you won't pass it by, but not garish like the full-row highlighting was. (Sorry. :-))
-
Discournstant
-
-
Funny. We use the FontAwesome crossed arrows doohickey in our app to mean "Disconcerting shit going on here" as well.
-
I can see that Widescreen+minimal is up to something, but I'm not perceptive enough to detect any differences between Discourse Default and TFWTF Default.
Are they actually different already, or are we expecting Discourse's defaults to start diverging from ours as they go full minimal and delete their entire UI but by bit?
Filed under: f**k the UI in it's little UI holes.
-
The button looks different in Discourse Default.
And the new/unread counter bubbles are smaller.
-
So the stuff that @pjh changed
-
Dammit....
I fell for it again.
-
- My admin icon
- post footers don't fade
- non standard badge colors
- right gutter visible all the time
- increased nested DOM elements
And a few other bits and pieces that I don't recall ATM.
I may post the current version if I remember when at a keyboard.
-
Are we still doing that colo[spoiler]u[/spoiler]r thing?
What’s wrong with a little internationali[spoiler]s[/spoiler][spoiler]z[/spoiler]ation?
-
I meant the [spoiler]spoiler[/spoiler]
-
nobody [spoiler]has[/spoiler] any [spoiler]intentions[/spoiler] to [spoiler]spoiler[/spoiler] anything!
Filed Under: German Jokes (thats international for most of you)!
-
I am a [spoiler]<img src=http://www.der-baecker-eifler.de/sites/default/files/styles/product_thumbnail/public/Kreppel.png?itok=Yb6kzJiT>[/spoiler]
-
I sexually identify as a toaster
-
What kind of Toaster are you?
- The one that tells you that you revived a topic
- The one that tells you that you participated more than 25% in a topic
- The one that everybody hates
- The one that went away after a while?
Filed Under: "The many different types of toasters" sounds like book-title
-
The one that tells you that you revived a topic
The one that tells you that you participated more than 25% in a topic
The one that everybody hatesThe top two are the same as the third.
-
I thought they were all like "TOASTER_RATHER_NOT_BE_FOUND" hence I thought splitting them up was fine.
Filed Under: catch(revived eww){}catch(participated eww){}catch(toaster eww){}catch(/Toaster went away/){}catch(){}
Addendum: I am aware that the last two catches in that are the same due to the comment.... but this is Discourse so meh :D
-
Germany has a political party that identifies itself as food:
http://cdn4.spiegel.de/images/image-340827-galleryV9-nnmy.jpg
-
According to ~2 seconds of research they got the idea for that from the internet.
Addendum: To make matters worse this is one of the biggest and oldest German political parties...
-
another eddie izzard fan!
woot!!
-
-
You could at least have used a link to the forum:
http://what.thedailywtf.com/t/toaster-based-input/2207
Filed Under: Stay inside known boundaries!
-
I love how someone came up with a feature-length article from a StackExchange question.
-
I am a
You're סופגניות?
Filed under: יו, The סופגניות are all גנ. I ate them., phonetic recombination
-
One with keys?
Are you sure you're not a waffle iron?
-