Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.
0
votes
1answer
29 views
What are the top voted comments on closed questions, and who made the comments?
Following this linked question and the feedback it generated, I put together a new query which utilizes a JOIN.
...
4
votes
1answer
45 views
What percentage of down votes are users responsible for?
I put together this simple query to calculate the percentage of downvotes each user is responsible for and displaying them in order of downvote percentage. It's generating the desired results, but I ...
7
votes
1answer
30 views
SEDE Query to Find… Weird Question/Protect Combinations
I was interested in finding some of the weirdest question/protection combinations, basically out of curiosity.
I heuristically defined this as:
Low view counts
Not a moderator/SE employee
From ...
4
votes
2answers
49 views
Top Python badged users from NYC
I forked this StackExchange Data Explorer (SEDE) query from another one, and made it a bit more complex. I'm looking for feedback on my style, as well as answers to other questions (see below).
...
2
votes
0answers
18 views
UserScript that tracks Views Since Last Visit
I try keep an eye on any questions or answers that I have posted here within the StackExchange network and I like to prioritize my updates and improvements based on ones that get frequent visits.
I ...
8
votes
0answers
35 views
Badge Oneboxer for Chat.SE
This script makes it possible for badges to onebox in Chat.
The install requires Tamper/GreaseMonkey. Click here to install,
and it's on GitHub and StackApps!
...
5
votes
1answer
33 views
Chat.SE in Websockets
This is a script that accesses the SE impromptu APIs to receive the fkey, a variable need for connection to chatrooms, and uses it to build a websockets connection ...
4
votes
2answers
73 views
UserScript that summarizes Stack Exchange flag counts
I am working on a UserScript that displays total flag counts and other information on the Flag Summary page.
Example:
Everything is working correctly but this bit of code seems rather repetitive ...
4
votes
2answers
40 views
Stack Exchange userscript for showing spoilers on questions with particular tags
Stack Exchange sites support hiding text as a spoiler with >!; for example:
This gets a lot of use on the Sci-Fi & Fantasy stack, usually to cover up ...
5
votes
1answer
28 views
Helper functions to extract SEDE query results into more user-friendly format
This Python module contains helper functions to download the result page of SEDE queries and extract columns from it, most prominently:
...
13
votes
2answers
240 views
BigBrother - A chat room watcher
Originally, this script stemmed from a small script that watched stars and who made them, but a few days after launching, SE patched it so the people behind the stars aren't sent.
Regardless, ...
16
votes
2answers
110 views
Stack Exchange Post Reminder
I've created a UserScript for adding follow-up reminders to any post (question or answer) here on the Stack Exchange network. I did this in response to a stackoverflow meta post feature request which ...
9
votes
2answers
56 views
Hot Post-ato Guessing Game
On almost every page in the Stack Exchange Network, there lives a list of some the current "hot" questions across the network (sometimes abbreviated HNQs). Some of these posts have very exotic titles ...
18
votes
1answer
51 views
Cross-posts from Stack Overflow to CR
What this code does it explained in detail in the top portion of the query.
I have left out part of the list of language tags as I felt it was just noise. You can see the full collection here.
You ...
18
votes
2answers
107 views
Simon, Mat's Mug, what's the (rating) difference?
This is a part of the code for the almighty bot @Duga (That's me!).
Every evening, 15 minutes before "RELOAD" (00:00 UTC), I post the reputation differences for some Code Review users.
Example ...
10
votes
1answer
60 views
Vote Count Viewer
I've written a small script to enable the vote count viewing functionality that comes for users at 1k reputation:
...
6
votes
1answer
29 views
Scraping SEDE query results with caching
I use this script to scrape the results of a SEDE page and return as a BeautifulSoup object.
A small twist is that if I don't use a SEDE query manually in the browser for a few days, then ...
6
votes
2answers
38 views
Scraping columns from SEDE results
I use the following script to download the result of a SEDE query and scrape a specific column from it using BeautifulSoup:
...
12
votes
2answers
65 views
Stack Exchange moderation-action auto-comments
I've written a userscript that pops up a dialog before you take a moderation action (closing, deleting) with some pro-forma comments, so that you can add one of those before you cast your vote.
I'm ...
10
votes
1answer
68 views
The Handy-Dandy Apocalypse Assistant
Code Review is running rampant with an infection. A zombie infection.
Everywhere posts are becoming rapidly mutated into slobbering, green
freaks of nature. But the citizens of Code Review are ...
16
votes
2answers
1k views
Searching for bad Minecraft questions on Gaming.SE
To preface this post a little bit, I'll explain a little bit of the "backstory" here. The Stack Exchange site, Gaming.SE, also known as Arqade, often has a large influx of bad questions about the ...
7
votes
2answers
134 views
Sum-based sliding rate limiting with Redis and Lua
As I'm new to Redis, I would like to get a review / improvement suggestions from Redis / Lua experts on the following problem and the solution I have found so far.
Problem
The context is: an ...
6
votes
1answer
52 views
Desktop Notifications for Queue Items - Updated Code
A while ago I took one of @Simon's scripts and updated it to make it more geared towards normal users (no offense mods) and this Question was created. But the link to the Github is no longer correct ...
4
votes
2answers
85 views
The Badge Bot 9000
Because I'm both lazy and wanting to mess around more with time management and Ruby, I thought it would be fun to create a simple script that opens Code Review once every day to go towards the daily ...
7
votes
1answer
50 views
Retrieving StackExchange sites and tags
I have setup agenda tasks to periodically retrieve and possibly insert new SE sites and tags in my MongoDB database.
Some things that bother me in particular:
Lots of code duplication
No string ...
30
votes
1answer
363 views
Beta-Blue B. Gone
I've written a Code Review design using Userscripts and CSS.
It works by fetching the CSS from my GitHub repo, and using the built in gm_addStyle function to add ...
17
votes
3answers
3k views
Oh my goodness: How many selfies have I taken?
The title is a joke on how some people take a lot of selfies pictures
Recently, in The 2nd Monitor, there was a brief discussion on selfie answers, starting with this post.
At one point, a user said ...
7
votes
1answer
79 views
First SO chat message in Haskell followup
I have wrote an application which asks for the user id, and returns a link to the first available chat message:
Output
Enter user id:
322395
Fetching data...
...
4
votes
0answers
52 views
Find first SO chat message in Haskell
I have made some simple functions to find the first SO chat message. How can I improve my code?
Even if there is a stackoverflow link that will get the job done (I'd be glad to know), I'd like to ...
14
votes
3answers
142 views
GitHub link oneboxer for chat
I've made a userscript that oneboxes links to GitHub repos, issues or pull requests in Chat after seeing the request One-box repositories, issue tickets and such on GitHub in the chat on Meta.
It ...
7
votes
2answers
154 views
Desktop notifications for queue items
I wasn't satisfied with Simon's alert on the orange alert. I wanted to know if even 1 review item was available, so I made some modifications to the userscript so that it runs on the Review page, and ...
26
votes
3answers
2k views
Excuse me, how many of you are new here? Mind if I JOIN you?
I had perceived an uptick in new reviewers around here, and I wanted to see if the data backed that observation up. It's been a while since I've written any SQL, so this was a nice little exercise in ...
4
votes
0answers
24 views
Tag wikis under a certain length
I wrote a SEDE query to list all tag wikis with a body or an excerpt under a given number of characters. I've used this to find empty wikis or wikis with very little information. The tags can be ...
20
votes
2answers
346 views
Desktop Notifications for flags and queue items
After our recent election, I got elected as a moderator here on Code Review (Thank you, community members!). One of the first things I missed among the moderator tools was desktop notifications for ...
5
votes
1answer
55 views
Searching posts/comments by keywords
I've put together another simple query that allows you to search post/comments with specific keywords. At the moment, only post bodies are checked.
...
9
votes
3answers
387 views
Popular questions by view count
I made this query to create a graph of a user's popular questions and the view count on that question. It allows for a minimum of 500 views, and a score of ...
6
votes
1answer
65 views
Finding which users have the most questions with unaccepted answers
I was looking at a few profiles this afternoon and noticed a few users had plenty of open questions. This led me to wonder which users actually had the highest amount of questions with unaccepted ...
3
votes
2answers
35 views
Percentage of questions that are unanswered or answered - Part 2
I've refactored my previous query and added better checks when selecting the data. The query link can be found here. The formulas used to calculate the two percentages are the same, and can be seen ...
11
votes
1answer
1k views
Soup of the day: best served during election season
Community moderator elections on the Stack Exchange network are really exciting.
Alas, on the page of the primaries, I find it mildly annoying that candidates are randomly reordered on every page ...
10
votes
2answers
310 views
Percentage of questions that are unanswered or answered
I put together this simple query which calculates the total percentage of answered questions and unanswered questions. The formulas used to calculate these are shown below:
$$
\text{Answered ...
6
votes
2answers
269 views
Another JavaScript Stack Exchange chat bot
I've been inspired by @SirPython's SirAlfred JavaScript chat bot, so I went and made my own. This one is slightly different though, in the fact that it can accept input in a more lenient way. For ...
16
votes
2answers
223 views
Election vote-counting, result-posting chatbot
In preparation for the end of Code Review's 2015 election, I've built a simple bot to get the election votes, run OpenSTV on them, and post the result to a chatroom. I'm using this Python ...
14
votes
4answers
224 views
The chatbot for The Community Post Pimping Board
I recently wrote a chat bot for a chat room here at Code Review. The chatroom is meant to be a place where people can come and pimp a post.
That chat bot is meant to handle a list of subscribed ...
58
votes
3answers
3k views
Shielding your CodeReview on GitHub
In response to a feature-request on meta, I spent a few hours today creating the feature in php.
This application adds a review shield to your GitHub repository (or wherever else you want it).
It ...
5
votes
2answers
131 views
Finding questions to answer - Part 2
I've refactored my previous question finder, and added multi-tag support, and support for searching for keywords in the question titles. Essentially, what it does is find questions that could be ...
8
votes
2answers
135 views
Finding questions to answer
In light of the recent "SQL frenzy" of sorts in The 2nd Monitor, I decided to take a stab at writing my own SEDE query. Essentially, what it does is find questions that could be answered based on the ...
17
votes
2answers
275 views
“How can I make this SEDE query better?” (bad title finder)
It was suggested on Meta for July 2015 Community Challenge to make a bot that can find questions with bad titles. I wrote this query to help others find examples to help them make write their code.
...
19
votes
4answers
2k views
Top users under age 30, sorted by age, with rank
In the pursuit of SQL enlightenment, I wrote a quick SEDE query to display Rep, Age and Overall ...
8
votes
1answer
66 views
The opposite of CodeLess Questions query
What's the opposite of CodeLess Questions?
Perhaps CodeOnly Answers? (Also known as code dumps.)
Inspired by the opposite question, here's the opposite query:
...
11
votes
1answer
297 views
CodeLess Questions query
As part of an exercise by Jamal to clean up old questions on Code Review that have no code in them, I helped by writing this query on Stack Exchange Data Explorer: CodeLess Questions
...
