Extension:AbuseFilter/abuse_filter_log table

From MediaWiki.org
Jump to navigation Jump to search
Translate this page; This page contains changes which are not marked for translation.

Other languages:
Deutsch • ‎English • ‎français • ‎български • ‎မြန်မာဘာသာ • ‎日本語

Fields[edit]

afl_id[edit]

Primary key

afl_filter[edit]

Number of the filter triggered.

afl_user[edit]

User ID of the author of the action.

afl_user_text[edit]

User name of the author of the action.

afl_ip[edit]

The IP address user was using when the filter was triggered.

afl_action[edit]

The action which triggered the filter. Values can include the following values: edit, delete, createaccount, move, upload, autocreateaccount, stashupload

afl_actions[edit]

What the filter made about the action. Example:

disallow,tag

afl_var_dump[edit]

Value of the variables of the filter that matched the edit, stored as a serialized PHP array. If the content is stored-text: followed by a number, then the content is not stored here but in the text table, and the number is the old_id identifier of that table. This is the default since MediaWiki 1.19. If external storage is enabled, content will be in the default external store. Prior to MediaWiki 1.21, instead of a native PHP array, an instance of AbuseFilterVariableHolder class was being serialized. To differentiate this, the nativeDataArray flag is added to the text table on new entries.

Example:

stored-text:66019837

afl_timestamp[edit]

Typical MediaWiki timestamp of the action filtered and hence of the abuse log entry about it.

afl_namespace[edit]

Target Namespace of the filtered action.

afl_title[edit]

Target title of the filter action.

afl_wiki[edit]

?

afl_deleted[edit]

?

afl_patrolled_by[edit]

?

afl_rev_id[edit]

?

afl_log_id[edit]

?

Schema[edit]

mysql> describe abuse_filter_log;
+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| afl_id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| afl_filter       | varbinary(64)       | NO   | MUL | NULL    |                |
| afl_user         | bigint(20) unsigned | NO   | MUL | NULL    |                |
| afl_user_text    | varbinary(255)      | NO   |     | NULL    |                |
| afl_ip           | varbinary(255)      | NO   | MUL | NULL    |                |
| afl_action       | varbinary(255)      | NO   |     | NULL    |                |
| afl_actions      | varbinary(255)      | NO   |     | NULL    |                |
| afl_var_dump     | blob                | NO   |     | NULL    |                |
| afl_timestamp    | binary(14)          | NO   | MUL | NULL    |                |
| afl_namespace    | tinyint(4)          | NO   | MUL | NULL    |                |
| afl_title        | varbinary(255)      | NO   |     | NULL    |                |
| afl_wiki         | varbinary(64)       | YES  | MUL | NULL    |                |
| afl_deleted      | tinyint(1)          | NO   |     | 0       |                |
| afl_patrolled_by | int(10) unsigned    | YES  |     | NULL    |                |
| afl_rev_id       | int(10) unsigned    | YES  | MUL | NULL    |                |
| afl_log_id       | int(10) unsigned    | YES  | MUL | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)

Example[edit]

MariaDB> SELECT afl_id, afl_filter, afl_user, afl_user_text, afl_ip, afl_action, afl_actions, afl_var_dump, afl_timestamp, afl_namespace, afl_title, afl_wiki, afl_deleted, afl_patrolled_by, afl_rev_id, afl_log_id FROM abuse_filter_log ORDER BY afl_id DESC LIMIT 1;
+--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+------------+
| afl_id | afl_filter | afl_user | afl_user_text  | afl_ip | afl_action | afl_actions | afl_var_dump         | afl_timestamp  | afl_namespace | afl_title | afl_wiki | afl_deleted | afl_patrolled_by | afl_rev_id | afl_log_id |
+--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+------------+
| 358580 | 9          |        0 | 151.54.106.177 |   NULL | edit       | tag         | stored-text:66020782 | 20140601174723 |             0 | 24:61     | NULL     |           0 |                0 |       NULL |       NULL |
+--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+------------+
1 row in set (0.01 sec)


Wikimedia extension database tables AbuseFilterExtension:AbuseFilter: abuse_filterabuse_filter_actionabuse_filter_historyabuse_filter_log
EchoExtension:Echo: echo_email_batchecho_eventecho_notification