A topic for demonstrating VALUES

A topic for demonstrating approval

Yes this is good

1 Like


I currently know how to do the following things:

@discoball start {name-of-tutorial}

Starts an interactive tutorial just for you, in a personal message. {name-of-tutorial} can be one of: tutorial, advanced tutorial.

@discoball roll 2d6

:game_die: 3, 6

@discoball quote

:left_speech_bubble: If you don’t go after what you want, you’ll never have it. If you don’t ask, the answer is always no. If you don’t step forward, you’re always in the same place. — Nora Roberts

@discoball fortune

:crystal_ball: You may rely on it

Data Explorer Queries

To list each individual “solved” event:

SELECT acting_user_id, target_topic_id, target_post_id, created_at FROM user_actions
WHERE action_type=15
ORDER BY created_at DESC

To produce a list with stats per-user: (with variable for time interval, defaults to 1 year):

-- [params]
-- string :interval = 1 year
SELECT  ua.acting_user_id, 
        count(case t.user_id when ua.acting_user_id then 1 else null end) as is_op, 
        count(case t.user_id when ua.acting_user_id then null else 1 end) as not_op,
        count(*) as total
FROM user_actions ua
LEFT JOIN topics t ON target_topic_id = t.id
WHERE action_type=15
AND ua.created_at >= CURRENT_DATE - INTERVAL :interval
GROUP BY ua.acting_user_id

They all died in the final scene

That’s something amazing +1 stuff

That’s somethisomting ng amazing +1 stuff

Awesome amazing +1 great

Awesome amazing :+1: great

awesome +1 great I agree

Thiis is great +1 I super agree

1 Like

You posted +1 you dick

First reply for testing

1 Like

Second reply for testing

1 Like

Third reply for testing

1 Like

Fourth reply for testing

1 Like

Fifth reply for testing

1 Like