A topic for demonstrating VALUES

General
1

A topic for demonstrating approval

Yes this is good

1 Like
4
5
6

@users

7
8

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

9

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
ORDER BY total DESC
10

They all died in the final scene

11

That’s something amazing +1 stuff

12

That’s somethisomting ng amazing +1 stuff

13

Awesome amazing +1 great

14

Awesome amazing :+1: great

15

awesome +1 great I agree

16

Thiis is great +1 I super agree

1 Like
17

You posted +1 you dick

18

First reply for testing

1 Like
19

Second reply for testing

1 Like
20

Third reply for testing

1 Like
21

Fourth reply for testing

1 Like
22

Fifth reply for testing

1 Like