#qa | Logs for 2021-03-30
  « return
[19:43:46] <Bytram> .op
[19:43:46] -!- mode/#qa [+o Bytram] by wheatley
[19:45:06] <Bytram> PASTE-BEGIN
[19:45:16] <Bytram> mysql> SELECT * FROM content_filters WHERE form = 'submissions' AND err_message = 'No Spam Please!' ORDER BY filter_id ;
[19:45:16] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:45:16] <Bytram> | filter_id | form        | regex                            | modifier | field | ratio  | minimum_match | minimum_length | err_message     |
[19:45:16] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:45:18] <Bytram> |        32 | submissions | \bviagra\b                       | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:21] <Bytram> |        33 | submissions | \bviagra\b                       | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:24] <Bytram> |        34 | submissions | viagra                           | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:27] <Bytram> |        35 | submissions | \bcialis\b                       | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:30] <Bytram> |        36 | submissions | \bcialis\b                       | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:33] <Bytram> |        37 | submissions | cialis                           | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:36] <Bytram> |        38 | submissions | tadalafil                        | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:41] <Bytram> |        39 | submissions | tadalafil                        | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:44] <Bytram> |        40 | submissions | tadalafil                        | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:47] <Bytram> |        41 | submissions | sildenafil                       | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:50] <Bytram> |        42 | submissions | sildenafil                       | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:53] <Bytram> |        43 | submissions | sildenafil                       | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:56] <Bytram> |        44 | submissions | \blevitra\b                      | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:45:59] <Bytram> |        45 | submissions | \blevitra\b                      | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:02] <Bytram> |        46 | submissions | levitra                          | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:05] <Bytram> |        49 | submissions | vardenafil                       | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:10] <Bytram> |        50 | submissions | vardenafil                       | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:13] <Bytram> |        51 | submissions | vardenafil                       | gi       | email | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:16] <Bytram> |        58 | submissions | fylitcl7pf7kjqdduolqouaxtxbj5ing | gi       | subj  | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:19] <Bytram> |        59 | submissions | fylitcl7pf7kjqdduolqouaxtxbj5ing | gi       | story | 0.0000 |             0 |              0 | No Spam Please! |
[19:46:22] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:46:25] <Bytram> 20 rows in set (0.01 sec)
[19:46:27] <Bytram> mysql> 
[19:50:19] <Bytram> mysql> UPDATE content_filters SET minimum_match = 999 WHERE filter_id IN (32,33,34,35,36,37,38,39,40,41,42,43,44,45,46, 49,50,51, 58,59) ;
[19:50:19] <Bytram> Query OK, 20 rows affected (0.01 sec)
[19:50:19] <Bytram> Rows matched: 20  Changed: 20  Warnings: 0
[19:50:19] <Bytram> mysql> 
[19:50:53] <Bytram> mysql> SELECT * FROM content_filters WHERE form = 'submissions' AND err_message = 'No Spam Please!' ORDER BY filter_id ;
[19:50:53] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:50:53] <Bytram> | filter_id | form        | regex                            | modifier | field | ratio  | minimum_match | minimum_length | err_message     |
[19:50:53] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:50:56] <Bytram> |        32 | submissions | \bviagra\b                       | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:50:59] <Bytram> |        33 | submissions | \bviagra\b                       | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:02] <Bytram> |        34 | submissions | viagra                           | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:05] <Bytram> |        35 | submissions | \bcialis\b                       | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:10] <Bytram> |        36 | submissions | \bcialis\b                       | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:13] <Bytram> |        37 | submissions | cialis                           | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:16] <Bytram> |        38 | submissions | tadalafil                        | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:19] <Bytram> |        39 | submissions | tadalafil                        | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:22] <Bytram> |        40 | submissions | tadalafil                        | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:25] <Bytram> |        41 | submissions | sildenafil                       | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:28] <Bytram> |        42 | submissions | sildenafil                       | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:31] <Bytram> |        43 | submissions | sildenafil                       | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:34] <Bytram> |        44 | submissions | \blevitra\b                      | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:39] <Bytram> |        45 | submissions | \blevitra\b                      | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:42] <Bytram> |        46 | submissions | levitra                          | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:45] <Bytram> |        49 | submissions | vardenafil                       | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:48] <Bytram> |        50 | submissions | vardenafil                       | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:51] <Bytram> |        51 | submissions | vardenafil                       | gi       | email | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:54] <Bytram> |        58 | submissions | fylitcl7pf7kjqdduolqouaxtxbj5ing | gi       | subj  | 0.0000 |           999 |              0 | No Spam Please! |
[19:51:57] <Bytram> |        59 | submissions | fylitcl7pf7kjqdduolqouaxtxbj5ing | gi       | story | 0.0000 |           999 |              0 | No Spam Please! |
[19:52:00] <Bytram> +-----------+-------------+----------------------------------+----------+-------+--------+---------------+----------------+-----------------+
[19:52:03] <Bytram> 20 rows in set (0.01 sec)
[19:52:05] <Bytram> mysql> 
[19:52:09] <Bytram> .deop
[19:52:09] -!- mode/#qa [-o Bytram] by wheatley
[19:55:41] -!- TheMightyBuzzard [TheMightyBuzzard!~TheMighty@Soylent/Staff/Developer/TMB] has joined #qa
[19:56:56] <TheMightyBuzzard> Bytram, looks good
[19:57:04] <Bytram> =)
[19:57:06] <Bytram> hth
[19:57:12] <Bytram> teamwork++
[19:57:12] <Bender> karma - teamwork: 1
[20:41:05] -!- systemd has quit [Remote host closed the connection]
[20:41:16] -!- systemd [systemd!~systemd@973-462-098-954.res.spectrum.com] has joined #qa
[20:41:16] -!- systemd has quit [Changing host]
[20:41:16] -!- systemd [systemd!~systemd@pid1] has joined #qa