用户:Antigng/对Bluedeck编辑摘要的研究

最近互助客栈上一直有用户怀疑User:Bluedeck账户可能被盗用,质疑者声称Bluedeck最近的编辑行为、编辑倾向和过去非常不一致,认为Bluedeck账户存在被盗的可能性。鉴于Bluedeck账户有一些防护措施,也有人质疑Bluedeck是把账户主动转交给了另一位用户。[1]

老实说,我对Bluedeck之前的编辑行为并不了解,所以我做了一个简单的测试。我从tool labs上中文维基百科的镜像数据库查找出Bluedeck喜欢使用的各种编辑摘要,再看Bluedeck做出带有这些摘要的编辑的时间范围。如果这些时间范围的并集不能覆盖Bluedeck账号活跃的时间段,那么Bluedeck账户变更使用者的可能性就比较大,反之,可能性就比较小。举个例子,如果Bluedeck在2014年1月到2014年9月只使用“AAA、BBB、CCC”作编辑摘要,但是在2014年12月至2015年12月间只使用“苹果、香蕉、李子”作编辑摘要,那么一种可能的解释就是Bluedeck账户的使用者发生了变化。

实验结果

编辑
MariaDB [zhwiki_p]>  select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='diction' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20140125001954 |    37966 | 29953425 | diction     |
|  1351755 | 20151206175457 |   104628 | 38221533 | diction     |
|  1351755 | 20141018133043 |   193815 | 33008684 | diction     |
|  1351755 | 20160214000535 |  2849559 | 39065908 | diction     |
|  1351755 | 20140701094708 |  3159765 | 31755904 | diction     |
|  1351755 | 20151016030353 |  3736446 | 37572048 | diction     |
|  1351755 | 20150108162744 |  3736447 | 33884024 | diction     |
|  1351755 | 20151008164438 |  3736601 | 37484903 | diction     |
|  1351755 | 20150914214421 |  3903191 | 37212995 | diction     |
|  1351755 | 20151008163626 |  3903191 | 37484813 | diction     |
|  1351755 | 20150208025525 |  4506433 | 34245406 | diction     |
|  1351755 | 20151008163842 |  5039810 | 37484834 | diction     |
|  1351755 | 20151008163923 |  5039810 | 37484839 | diction     |
|  1351755 | 20160216203417 |  5234992 | 39099015 | diction     |
+----------+----------------+----------+----------+-------------+
14 rows in set (22.19 sec)


MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='UI'  limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20140706030330 |  3779732 | 31800147 | UI          |
|  1351755 | 20150929154801 |  5165465 | 37393864 | UI          |
|  1351755 | 20160310021117 |  5260029 | 39330197 | UI          |
|  1351755 | 20160310022316 |  5260029 | 39330258 | UI          |
|  1351755 | 20160310022848 |  5260029 | 39330290 | UI          |
|  1351755 | 20160310023101 |  5260029 | 39330305 | UI          |
|  1351755 | 20160310023230 |  5260029 | 39330315 | UI          |
|  1351755 | 20160310023748 |  5260029 | 39330345 | UI          |
+----------+----------------+----------+----------+-------------+
8 rows in set (21.03 sec)

MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='ui' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20150825235156 |  3903191 | 36977711 | ui          |
|  1351755 | 20151002024030 |  5049964 | 37418080 | ui          |
+----------+----------------+----------+----------+-------------+
2 rows in set (21.62 sec)


从上面两个查询结果可以看出,“diction”和“UI”两个编辑摘要只有Bluedeck用过,而且从2014年1月一直用到2016年3月。

MariaDB [zhwiki_p]>  select rev_user ,  rev_timestamp, rev_page, rev_comment from revision where rev_comment='routine' limit 5000;
+----------+----------------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_comment |
+----------+----------------+----------+-------------+
|  1351755 | 20141005032950 |  3707240 | routine     |
|  1351755 | 20140905134130 |  3707260 | routine     |
|  1351755 | 20140629044743 |  3938658 | routine     |
|  1351755 | 20140630142311 |  3938663 | routine     |
|  1351755 | 20140630142355 |  3938664 | routine     |
|  1351755 | 20140705081026 |  3942503 | routine     |
|  1351755 | 20140706054136 |  3942505 | routine     |
|  1351755 | 20140707034314 |  3944262 | routine     |
|  1351755 | 20140709160516 |  3945748 | routine     |
|  1351755 | 20140804090658 |  3971854 | routine     |
|  1351755 | 20140805174557 |  3972347 | routine     |
|  1351755 | 20140807075618 |  3974932 | routine     |
|  1351755 | 20140810162216 |  3983594 | routine     |
|  1351755 | 20140812152436 |  3984905 | routine     |
|  1351755 | 20140813162132 |  3985184 | routine     |
|  1351755 | 20140816152407 |  3991390 | routine     |
|  1351755 | 20140825134537 |  4004201 | routine     |
|  1351755 | 20140831114109 |  4010042 | routine     |
|  1351755 | 20140901161303 |  4011175 | routine     |
|  1351755 | 20140902160543 |  4012081 | routine     |
|  1351755 | 20140903080504 |  4013120 | routine     |
|  1351755 | 20140904161940 |  4014966 | routine     |
|  1351755 | 20140905134125 |  4019952 | routine     |
|  1351755 | 20140907092728 |  4023298 | routine     |
|  1351755 | 20140908061105 |  4023613 | routine     |
|  1351755 | 20140909015559 |  4024707 | routine     |
|  1351755 | 20140629044749 |  4026864 | routine     |
|  1351755 | 20140912065725 |  4028197 | routine     |
|  1351755 | 20140912193820 |  4028198 | routine     |
|  1351755 | 20140630142325 |  4028472 | routine     |
|  1351755 | 20140915142643 |  4031268 | routine     |
|  1351755 | 20140916121706 |  4031861 | routine     |
|  1351755 | 20140918100401 |  4034942 | routine     |
|  1351755 | 20140705081018 |  4034951 | routine     |
|  1351755 | 20140919131201 |  4035311 | routine     |
|  1351755 | 20140706054125 |  4035621 | routine     |
|  1351755 | 20140710090429 |  4040250 | routine     |
|  1351755 | 20140922163642 |  4040768 | routine     |
|  1351755 | 20140924172959 |  4043549 | routine     |
|  1351755 | 20140925145203 |  4044324 | routine     |
|  1351755 | 20140926033632 |  4045573 | routine     |
|  1351755 | 20140927133218 |  4045578 | routine     |
|  1351755 | 20140928131524 |  4045838 | routine     |
|  1351755 | 20140930231721 |  4048535 | routine     |
|  1351755 | 20140717165737 |  4049050 | routine     |
|  1351755 | 20141001151542 |  4051094 | routine     |
|  1351755 | 20141002144042 |  4051097 | routine     |
|  1351755 | 20141004015443 |  4051144 | routine     |
|  1351755 | 20141005032927 |  4052645 | routine     |
|  1351755 | 20141005032958 |  4054769 | routine     |
|  1351755 | 20141005234911 |  4054947 | routine     |
|  1351755 | 20141007162128 |  4055479 | routine     |
|  1351755 | 20141008045019 |  4055482 | routine     |
|  1351755 | 20140723122319 |  4057486 | routine     |
|  1351755 | 20141010005925 |  4057734 | routine     |
|  1351755 | 20141014142947 |  4058029 | routine     |
|  1351755 | 20141010153228 |  4060267 | routine     |
|  1351755 | 20141011182733 |  4060557 | routine     |
|  1351755 | 20141013004538 |  4062090 | routine     |
|  1351755 | 20141013165859 |  4063659 | routine     |
|  1351755 | 20141016184830 |  4067524 | routine     |
|  1351755 | 20140910042237 |  4074859 | routine     |
|  1351755 | 20140804090703 |  4090583 | routine     |
|  1351755 | 20140804165445 |  4090595 | routine     |
|  1351755 | 20140921170936 |  4090680 | routine     |
|  1351755 | 20141018062524 |  4090699 | routine     |
|  1351755 | 20141019064041 |  4090717 | routine     |
|  1351755 | 20141020152409 |  4090724 | routine     |
|  1351755 | 20141022000515 |  4090726 | routine     |
|  1351755 | 20140805174605 |  4092097 | routine     |
|  1351755 | 20140807075546 |  4093274 | routine     |
|  1351755 | 20141022161013 |  4093292 | routine     |
|  1351755 | 20140809143634 |  4097489 | routine     |
|  1351755 | 20141023140802 |  4098979 | routine     |
|  1351755 | 20141024165942 |  4098985 | routine     |
|  1351755 | 20141024170041 |  4103128 | routine     |
|  1351755 | 20141027041942 |  4103923 | routine     |
|  1351755 | 20140810162201 |  4104431 | routine     |
|  1351755 | 20140812152447 |  4108241 | routine     |
|  1351755 | 20141027175941 |  4108802 | routine     |
|  1351755 | 20141028062143 |  4108818 | routine     |
|  1351755 | 20140813162140 |  4114542 | routine     |
|  1351755 | 20141030155019 |  4117027 | routine     |
|  1351755 | 20141031161357 |  4122300 | routine     |
|  1351755 | 20141101131948 |  4122320 | routine     |
|  1351755 | 20140816152418 |  4123110 | routine     |
|  1351755 | 20141103154730 |  4129822 | routine     |
|  1351755 | 20140820053238 |  4132032 | routine     |
|  1351755 | 20141104151746 |  4132565 | routine     |
|  1351755 | 20141106001544 |  4132578 | routine     |
|  1351755 | 20141106150604 |  4134223 | routine     |
|  1351755 | 20141108003253 |  4135560 | routine     |
|  1351755 | 20141109032137 |  4138217 | routine     |
|  1351755 | 20140825134602 |  4170559 | routine     |
|  1351755 | 20141112141206 |  4171128 | routine     |
|  1351755 | 20140831114134 |  4195100 | routine     |
|  1351755 | 20141118164517 |  4197858 | routine     |
|  1351755 | 20140901161321 |  4197924 | routine     |
|  1351755 | 20140902160536 |  4204649 | routine     |
|  1351755 | 20140903080511 |  4205424 | routine     |
|  1351755 | 20141119171913 |  4207696 | routine     |
|  1351755 | 20140904161930 |  4209108 | routine     |
|  1351755 | 20140907092749 |  4209231 | routine     |
|  1351755 | 20141121010644 |  4210937 | routine     |
|  1351755 | 20140908061114 |  4218150 | routine     |
|  1351755 | 20140909015607 |  4218707 | routine     |
|  1351755 | 20140910042243 |  4220371 | routine     |
|  1351755 | 20140912065716 |  4223149 | routine     |
|  1351755 | 20140912193829 |  4223161 | routine     |
|  1351755 | 20140915164105 |  4223171 | routine     |
|  1351755 | 20140916121729 |  4223177 | routine     |
|  1351755 | 20141208201202 |  4237647 | routine     |
|  1351755 | 20141208201247 |  4237647 | routine     |
|  1351755 | 20140918100408 |  4239374 | routine     |
|  1351755 | 20140919131154 |  4240131 | routine     |
|  1351755 | 20140921170912 |  4244688 | routine     |
|  1351755 | 20140922163655 |  4247566 | routine     |
|  1351755 | 20140924173053 |  4250806 | routine     |
|  1351755 | 20140925145209 |  4253984 | routine     |
|  1351755 | 20140926033030 |  4255989 | routine     |
|  1351755 | 20140927133229 |  4257467 | routine     |
|  1351755 | 20140928140456 |  4261882 | routine     |
|  1351755 | 20140930231728 |  4264252 | routine     |
|  1351755 | 20140930000602 |  4264328 | routine     |
|  1351755 | 20141001151512 |  4266042 | routine     |
|  1351755 | 20141002144049 |  4266051 | routine     |
|  1351755 | 20141004015411 |  4271508 | routine     |
|  1351755 | 20141005032921 |  4271765 | routine     |
|  1351755 | 20141005234857 |  4275300 | routine     |
|  1351755 | 20141007162138 |  4275303 | routine     |
|  1351755 | 20141008045029 |  4275316 | routine     |
|  1351755 | 20141010005901 |  4284644 | routine     |
|  1351755 | 20141010153313 |  4284647 | routine     |
|  1351755 | 20141011182742 |  4284649 | routine     |
|  1351755 | 20141013004553 |  4290710 | routine     |
|  1351755 | 20141014142908 |  4293526 | routine     |
|  1351755 | 20141014142927 |  4293534 | routine     |
|  1351755 | 20141016184845 |  4298229 | routine     |
|  1351755 | 20141018062529 |  4299904 | routine     |
|  1351755 | 20141019064030 |  4300183 | routine     |
|  1351755 | 20141020153022 |  4306490 | routine     |
|  1351755 | 20141022000504 |  4306494 | routine     |
|  1351755 | 20141023142305 |  4311843 | routine     |
|  1351755 | 20141027041936 |  4313990 | routine     |
|  1351755 | 20141027175934 |  4313993 | routine     |
|  1351755 | 20141028062136 |  4313995 | routine     |
|  1351755 | 20141029144321 |  4322714 | routine     |
|  1351755 | 20141030154830 |  4323255 | routine     |
|  1351755 | 20141031161405 |  4326770 | routine     |
|  1351755 | 20141103154718 |  4332759 | routine     |
|  1351755 | 20141104151804 |  4335035 | routine     |
|  1351755 | 20141106001534 |  4335043 | routine     |
|  1351755 | 20141106150617 |  4335045 | routine     |
|  1351755 | 20141108003245 |  4339929 | routine     |
|  1351755 | 20141109030247 |  4342155 | routine     |
|  1351755 | 20141112141232 |  4354262 | routine     |
|  1351755 | 20141118164444 |  4365612 | routine     |
|  1351755 | 20141119171923 |  4366179 | routine     |
|  1351755 | 20141121181412 |  4368603 | routine     |
|  1351755 | 20141122170102 |  4368607 | routine     |
|  1351755 | 20141125044929 |  4375480 | routine     |
|  1351755 | 20141127010758 |  4380903 | routine     |
|  1351755 | 20141127014440 |  4380910 | routine     |
|  1351755 | 20141127161827 |  4380915 | routine     |
|  1351755 | 20141130160843 |  4380928 | routine     |
|  1351755 | 20141202050902 |  4380933 | routine     |
|  1351755 | 20141208030858 |  4401538 | routine     |
|  1351755 | 20141208201010 |  4401700 | routine     |
|  1351755 | 20141208201103 |  4401702 | routine     |
|  1351755 | 20141211181140 |  4401711 | routine     |
|  1351755 | 20141212152259 |  4401712 | routine     |
|  1351755 | 20141213144604 |  4407950 | routine     |
|  1351755 | 20141214152818 |  4407952 | routine     |
|  1351755 | 20141215140513 |  4407958 | routine     |
|  1351755 | 20141218163506 |  4419662 | routine     |
|  1351755 | 20141219135101 |  4419671 | routine     |
|  1351755 | 20141221000905 |  4419675 | routine     |
|  1351755 | 20141221234334 |  4419682 | routine     |
|  1351755 | 20141222163859 |  4420321 | routine     |
|  1351755 | 20150114024608 |  4464405 | routine     |
|  1351755 | 20150202152225 |  4497894 | routine     |
|  1351755 | 20150224000543 |  4527943 | routine     |
+----------+----------------+----------+-------------+
182 rows in set (26.13 sec)

MariaDB [zhwiki_p]>  select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='Routine' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20140710090421 |  3945776 | 31844648 | Routine     |
|  1351755 | 20140711052819 |  3952033 | 31853124 | Routine     |
|  1351755 | 20140712054045 |  3952040 | 31864139 | Routine     |
|  1351755 | 20140719042939 |  3952487 | 31938385 | Routine     |
|  1351755 | 20140723122325 |  3959391 | 31986549 | Routine     |
|  1351755 | 20140730025849 |  3969003 | 32068379 | Routine     |
|  1351755 | 20140804165439 |  3971856 | 32142572 | Routine     |
|  1351755 | 20140808132841 |  3976343 | 32194161 | Routine     |
|  1351755 | 20140811091600 |  3984023 | 32228823 | Routine     |
|  1351755 | 20140814154037 |  3987893 | 32271453 | Routine     |
|  1351755 | 20140823001547 |  3999025 | 32367461 | Routine     |
|  1351755 | 20140830041806 |  4005731 | 32491098 | Routine     |
|  1351755 | 20140830041849 |  4009234 | 32491113 | Routine     |
|  1351755 | 20140719042953 |  4049059 | 31938386 | Routine     |
|  1351755 | 20140730025926 |  4067299 | 32068385 | Routine     |
|  1351755 | 20140914024420 |  4088155 | 32649531 | Routine     |
|  1351755 | 20140808132902 |  4097485 | 32194164 | Routine     |
|  1351755 | 20140811091942 |  4105346 | 32228862 | Routine     |
|  1351755 | 20140814154051 |  4115384 | 32271455 | Routine     |
|  1351755 | 20141102154949 |  4122323 | 33162154 | Routine     |
|  1351755 | 20140823001532 |  4135305 | 32367459 | Routine     |
|  1351755 | 20141110044618 |  4139558 | 33240816 | Routine     |
|  1351755 | 20141111224110 |  4144591 | 33258335 | Routine     |
|  1351755 | 20141114002221 |  4190134 | 33305186 | Routine     |
|  1351755 | 20140830041754 |  4192017 | 32491095 | Routine     |
|  1351755 | 20140914024411 |  4223168 | 32649530 | Routine     |
|  1351755 | 20141205172318 |  4233621 | 33517824 | Routine     |
|  1351755 | 20141101131954 |  4328786 | 33149128 | Routine     |
|  1351755 | 20141102154932 |  4332745 | 33162150 | Routine     |
|  1351755 | 20141110044633 |  4342158 | 33240819 | Routine     |
|  1351755 | 20141204083742 |  4395516 | 33503856 | Routine     |
|  1351755 | 20141205172225 |  4397011 | 33517818 | Routine     |
|  1351755 | 20141210175008 |  4401703 | 33568146 | Routine     |
|  1351755 | 20150202152220 |  4411106 | 34185025 | Routine     |
+----------+----------------+----------+----------+-------------+
34 rows in set (21.21 sec)
MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='日常' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20140430003449 |  3840527 | 31143483 | 日常        |
|  1351755 | 20140430034040 |  3878071 | 31144630 | 日常        |
|  1351755 | 20140501071058 |  3883270 | 31156448 | 日常        |
|  1351755 | 20140501071211 |  3884298 | 31156459 | 日常        |
|  1351755 | 20140504062935 |  3885400 | 31187661 | 日常        |
|  1351755 | 20140504064728 |  3885441 | 31187901 | 日常        |
|  1351755 | 20140506005929 |  3885442 | 31206330 | 日常        |
|  1351755 | 20140507011953 |  3885819 | 31215998 | 日常        |
|  1351755 | 20140507234822 |  3887251 | 31226061 | 日常        |
|  1351755 | 20140606025854 |  3909337 | 31508530 | 日常        |
|  1351755 | 20140608045937 |  3909844 | 31530027 | 日常        |
|  1351755 | 20140613054258 |  3919178 | 31579140 | 日常        |
|  1351755 | 20140616024454 |  3925814 | 31608256 | 日常        |
|  1351755 | 20140617030956 |  3926459 | 31618386 | 日常        |
|  1351755 | 20140620082141 |  3928773 | 31650181 | 日常        |
|  1351755 | 20140622024654 |  3930966 | 31665991 | 日常        |
|  1351755 | 20140623102021 |  3930967 | 31679343 | 日常        |
|  1351755 | 20140625184423 |  3932336 | 31702304 | 日常        |
|  1351755 | 20140627022903 |  3932960 | 31713333 | 日常        |
|  1351755 | 20140627023152 |  3936061 | 31713356 | 日常        |
|  1351755 | 20140628035046 |  3937205 | 31723449 | 日常        |
|  1351755 | 20140702154925 |  3939545 | 31768305 | 日常        |
|  1351755 | 20140703230546 |  3939899 | 31779173 | 日常        |
|  1351755 | 20140708162252 |  3944540 | 31828850 | 日常        |
|  1351755 | 20140602045302 |  3951193 | 31468640 | 日常        |
|  1351755 | 20140713084618 |  3952147 | 31876808 | 日常        |
|  1351755 | 20140716150931 |  3952483 | 31911884 | 日常        |
|  1351755 | 20140715041543 |  3952484 | 31895492 | 日常        |
|  1351755 | 20140713173203 |  3952485 | 31881859 | 日常        |
|  1351755 | 20140719043207 |  3952495 | 31938401 | 日常        |
|  1351755 | 20140430003745 |  3953297 | 31143495 | 日常        |
|  1351755 | 20140504063746 |  3956120 | 31187756 | 日常        |
|  1351755 | 20140719171223 |  3956612 | 31945704 | 日常        |
|  1351755 | 20140502102322 |  3956790 | 31169335 | 日常        |
|  1351755 | 20140504064224 |  3959342 | 31187822 | 日常        |
|  1351755 | 20140506010040 |  3959348 | 31206334 | 日常        |
|  1351755 | 20140721233528 |  3959389 | 31967519 | 日常        |
|  1351755 | 20140725192310 |  3962518 | 32016607 | 日常        |
|  1351755 | 20140507012152 |  3963270 | 31216020 | 日常        |
|  1351755 | 20140507234927 |  3963276 | 31226065 | 日常        |
|  1351755 | 20140508233157 |  3963946 | 31235415 | 日常        |
|  1351755 | 20140727082223 |  3965750 | 32033823 | 日常        |
|  1351755 | 20140727082329 |  3965754 | 32033839 | 日常        |
|  1351755 | 20140728104556 |  3965755 | 32047590 | 日常        |
|  1351755 | 20140729080240 |  3968913 | 32057656 | 日常        |
|  1351755 | 20140731152452 |  3971850 | 32090620 | 日常        |
|  1351755 | 20140801174526 |  3971851 | 32105549 | 日常        |
|  1351755 | 20140802170430 |  3971852 | 32117514 | 日常        |
|  1351755 | 20140816061424 |  3989166 | 32290083 | 日常        |
|  1351755 | 20140818015551 |  3991388 | 32309625 | 日常        |
|  1351755 | 20140818235957 |  3995934 | 32321578 | 日常        |
|  1351755 | 20140820053219 |  3996680 | 32335852 | 日常        |
|  1351755 | 20140820053248 |  3996681 | 32335860 | 日常        |
|  1351755 | 20140821162456 |  3996683 | 32354154 | 日常        |
|  1351755 | 20140824003120 |  3999032 | 32378723 | 日常        |
|  1351755 | 20140608050042 |  3999413 | 31530031 | 日常        |
|  1351755 | 20140825001423 |  4000438 | 32405461 | 日常        |
|  1351755 | 20140608050149 |  4002316 | 31530044 | 日常        |
|  1351755 | 20140614015114 |  4002433 | 31586568 | 日常        |
|  1351755 | 20140617030803 |  4002439 | 31618374 | 日常        |
|  1351755 | 20140617030905 |  4002442 | 31618382 | 日常        |
|  1351755 | 20140620082211 |  4002459 | 31650186 | 日常        |
|  1351755 | 20140827062443 |  4004203 | 32457314 | 日常        |
|  1351755 | 20140828052755 |  4004207 | 32468171 | 日常        |
|  1351755 | 20140828052839 |  4004751 | 32468178 | 日常        |
|  1351755 | 20140622024646 |  4017556 | 31665989 | 日常        |
|  1351755 | 20140623102103 |  4019167 | 31679349 | 日常        |
|  1351755 | 20140623102028 |  4019171 | 31679344 | 日常        |
|  1351755 | 20140625184527 |  4022436 | 31702314 | 日常        |
|  1351755 | 20140627022947 |  4022632 | 31713337 | 日常        |
|  1351755 | 20140907000525 |  4022637 | 32578104 | 日常        |
|  1351755 | 20140627023239 |  4025132 | 31713371 | 日常        |
|  1351755 | 20140628035015 |  4025462 | 31723440 | 日常        |
|  1351755 | 20140911001614 |  4028195 | 32618101 | 日常        |
|  1351755 | 20140702155027 |  4030491 | 31768313 | 日常        |
|  1351755 | 20140703234409 |  4031063 | 31779255 | 日常        |
|  1351755 | 20140917095342 |  4034346 | 32699134 | 日常        |
|  1351755 | 20140921000257 |  4036595 | 32736791 | 日常        |
|  1351755 | 20140708162328 |  4038127 | 31828858 | 日常        |
|  1351755 | 20140709160602 |  4039635 | 31838639 | 日常        |
|  1351755 | 20140711052908 |  4041601 | 31853128 | 日常        |
|  1351755 | 20140712054250 |  4041605 | 31864153 | 日常        |
|  1351755 | 20140923083958 |  4043539 | 32761187 | 日常        |
|  1351755 | 20140713084649 |  4044744 | 31876813 | 日常        |
|  1351755 | 20140713173241 |  4045013 | 31881861 | 日常        |
|  1351755 | 20140715041625 |  4046606 | 31895496 | 日常        |
|  1351755 | 20140716152241 |  4047866 | 31912002 | 日常        |
|  1351755 | 20140719043214 |  4051099 | 31938404 | 日常        |
|  1351755 | 20140719171245 |  4052417 | 31945707 | 日常        |
|  1351755 | 20140720172508 |  4052420 | 31955881 | 日常        |
|  1351755 | 20140721233954 |  4054446 | 31967532 | 日常        |
|  1351755 | 20140725035609 |  4057496 | 32006571 | 日常        |
|  1351755 | 20140725192353 |  4057503 | 32016610 | 日常        |
|  1351755 | 20140727082249 |  4057525 | 32033834 | 日常        |
|  1351755 | 20140727082352 |  4064666 | 32033844 | 日常        |
|  1351755 | 20140728104633 |  4064672 | 32047594 | 日常        |
|  1351755 | 20140729080338 |  4067296 | 32057673 | 日常        |
|  1351755 | 20140731152503 |  4075418 | 32090624 | 日常        |
|  1351755 | 20140801174550 |  4075426 | 32105553 | 日常        |
|  1351755 | 20140802170440 |  4081287 | 32117515 | 日常        |
|  1351755 | 20140803174636 |  4082019 | 32130492 | 日常        |
|  1351755 | 20140816061436 |  4116730 | 32290086 | 日常        |
|  1351755 | 20140818015559 |  4123112 | 32309626 | 日常        |
|  1351755 | 20140819000012 |  4127139 | 32321582 | 日常        |
|  1351755 | 20140820053212 |  4129694 | 32335850 | 日常        |
|  1351755 | 20140821162507 |  4134211 | 32354157 | 日常        |
|  1351755 | 20140824003127 |  4138216 | 32378724 | 日常        |
|  1351755 | 20140825001433 |  4140471 | 32405462 | 日常        |
|  1351755 | 20140827062503 |  4181253 | 32457319 | 日常        |
|  1351755 | 20140828052819 |  4181259 | 32468175 | 日常        |
|  1351755 | 20140828052857 |  4188394 | 32468179 | 日常        |
|  1351755 | 20140907000419 |  4209225 | 32578098 | 日常        |
|  1351755 | 20140911001621 |  4222747 | 32618102 | 日常        |
|  1351755 | 20140917095359 |  4233229 | 32699136 | 日常        |
|  1351755 | 20140921000317 |  4242131 | 32736793 | 日常        |
|  1351755 | 20140923083937 |  4250795 | 32761184 | 日常        |
|  1351755 | 20141204043553 |  4380935 | 33501596 | 日常        |
+----------+----------------+----------+----------+-------------+
117 rows in set (26.07 sec)

“routine”这个编辑摘要也只有Bludeck用过,从2014年6月用到2015年2月。

MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='test finished' limit 5000;
+----------+----------------+----------+----------+---------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment   |
+----------+----------------+----------+----------+---------------+
|  1351755 | 20151015014002 |  3813089 | 37563017 | test finished |
|  1351755 | 20151020162956 |  3813089 | 37616211 | test finished |
|  1351755 | 20151020163728 |  3813089 | 37616288 | test finished |
|  1351755 | 20140621152702 |  5165465 | 31663290 | test finished |
|  1351755 | 20140621153748 |  5165465 | 31663409 | test finished |
|  1351755 | 20140623144110 |  5165465 | 31681486 | test finished |
|  1351755 | 20140624054644 |  5165465 | 31686532 | test finished |
|  1351755 | 20140624055726 |  5165465 | 31686637 | test finished |
|  1351755 | 20151003001650 |  5165465 | 37427153 | test finished |
|  1351755 | 20151005162132 |  5165465 | 37457652 | test finished |
|  1351755 | 20151025214750 |  5165465 | 37664188 | test finished |
+----------+----------------+----------+----------+---------------+
11 rows in set (25.81 sec)

从2014年6月到2015年10月。

MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_comment from revision where rev_comment='收工' limit 5000;
+----------+----------------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_comment |
+----------+----------------+----------+-------------+
|    15539 | 20070110214402 |   470899 | 收工        |
|    82128 | 20070724005936 |   556570 | 收工        |
|  1351755 | 20141213152228 |  4226999 | 收工        |
|  1351755 | 20141222162311 |  4285106 | 收工        |
|  1351755 | 20141222163445 |  4297566 | 收工        |
|  1351755 | 20141213145524 |  4398193 | 收工        |
|  1351755 | 20141214155800 |  4400113 | 收工        |
|  1351755 | 20150904233111 |  4919207 | 收工        |
|  1351755 | 20150916034627 |  4929797 | 收工        |
|  1351755 | 20150912040131 |  4954187 | 收工        |
|  1351755 | 20150915023258 |  4985213 | 收工        |
|  1351755 | 20151022012723 |  5014077 | 收工        |
|  1351755 | 20151019013030 |  5021024 | 收工        |
|  1351755 | 20151019145339 |  5031803 | 收工        |
|  1351755 | 20151019144748 |  5043560 | 收工        |
|  1351755 | 20151105213209 |  5048291 | 收工        |
|  1351755 | 20151028052411 |  5050589 | 收工        |
|  1351755 | 20151115011051 |  5054381 | 收工        |
|  1351755 | 20151113131821 |  5063890 | 收工        |
|  1351755 | 20151114145030 |  5067253 | 收工        |
|  1351755 | 20151116032851 |  5067910 | 收工        |
|  1351755 | 20151114150932 |  5072560 | 收工        |
|  1960229 | 20160413114422 |  5234277 | 收工        |
+----------+----------------+----------+-------------+

“收工”这个编辑摘要Bluedeck从2014年12月用到2015年11月。


MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_id, rev_comment from revision where rev_comment='Archive' limit 5000;
+----------+----------------+----------+-------------+
| rev_user | rev_timestamp  | rev_id   | rev_comment |
+----------+----------------+----------+-------------+
|    90660 | 20090914152248 | 11150115 | Archive     |
|     1676 | 20051108072005 |  1165163 | Archive     |
|    10070 | 20150426072029 | 35501079 | Archive     |
|    13769 | 20070202161858 |  3441096 | Archive     |
|    59964 | 20080114223635 |  6025059 | Archive     |
|     1676 | 20051108072014 |  1165165 | Archive     |
|  1911556 | 20150207101954 | 34238958 | Archive     |
|  1401447 | 20140330133833 | 30851627 | Archive     |
|   476067 | 20091012142351 | 11378729 | Archive     |
|   476067 | 20091012142706 | 11378762 | Archive     |
|   834818 | 20121018042006 | 23334476 | Archive     |
|   476067 | 20090521133934 | 10111426 | Archive     |
|   235906 | 20090117124342 |  9074280 | Archive     |
|  1634825 | 20140627132458 | 31718861 | Archive     |
|    41486 | 20070523170143 |  4244940 | Archive     |
|   235906 | 20120312024040 | 19534201 | Archive     |
|   226510 | 20121225155451 | 24236903 | Archive     |
|    59964 | 20080117221947 |  6044423 | Archive     |
|    59964 | 20080123193436 |  6088619 | Archive     |
|    59964 | 20080128202709 |  6122400 | Archive     |
|   418960 | 20091214094417 | 11837042 | Archive     |
|   476067 | 20090401132341 |  9698839 | Archive     |
|   476067 | 20090419081813 |  9845650 | Archive     |
|   476067 | 20090419143255 |  9848197 | Archive     |
|   476067 | 20090423064014 |  9875829 | Archive     |
|   476067 | 20090501074320 |  9939225 | Archive     |
|   476067 | 20090512130318 | 10036443 | Archive     |
|   476067 | 20090520141710 | 10103534 | Archive     |
|   476067 | 20090524092935 | 10136345 | Archive     |
|   476067 | 20090530141019 | 10194228 | Archive     |
|   476067 | 20090605145234 | 10243829 | Archive     |
|   476067 | 20090708014511 | 10536051 | Archive     |
|   476067 | 20090709104542 | 10549585 | Archive     |
|   476067 | 20090806154228 | 10806526 | Archive     |
|   511509 | 20090928093025 | 11265184 | Archive     |
|   511509 | 20110319110329 | 16033182 | Archive     |
|   235906 | 20090117124330 |  9074278 | Archive     |
|   476067 | 20090818131551 | 10915863 | Archive     |
|   476067 | 20090818131653 | 10915874 | Archive     |
|    90660 | 20090914152418 | 11150124 | Archive     |
|   476067 | 20090818131544 | 10915860 | Archive     |
|   476067 | 20090818131648 | 10915872 | Archive     |
|   757371 | 20140803144205 | 32128594 | Archive     |
|   476067 | 20090818131725 | 10915883 | Archive     |
|   476067 | 20090818131718 | 10915880 | Archive     |
|    12259 | 20090911141421 | 11122585 | Archive     |
|   511509 | 20090928093037 | 11265188 | Archive     |
|   757371 | 20130816040137 | 28242503 | Archive     |
|   235906 | 20101029180934 | 14782034 | Archive     |
|   943713 | 20110624172336 | 16886835 | Archive     |
|   511509 | 20110319110327 | 16033180 | Archive     |
|   379101 | 20140524084444 | 31382204 | Archive     |
|   235906 | 20120312024021 | 19534197 | Archive     |
|   943713 | 20110624172210 | 16886826 | Archive     |
|    46136 | 20110618175425 | 16828114 | Archive     |
|    46136 | 20110618175700 | 16828131 | Archive     |
|   379101 | 20140907001027 | 32578136 | Archive     |
|   999313 | 20120131091805 | 19100536 | Archive     |
|   379101 | 20150511065541 | 35682254 | Archive     |
|  1520631 | 20140508075943 | 31229480 | Archive     |
|  1351755 | 20140329150505 | 30842352 | Archive     |
|  1351755 | 20140401031754 | 30864896 | Archive     |
|  1351755 | 20140428122936 | 31129812 | Archive     |
|  1351755 | 20140507055850 | 31217970 | Archive     |
|  1351755 | 20140519074851 | 31333594 | Archive     |
|  1351755 | 20140527052107 | 31408754 | Archive     |
|  1351755 | 20140602044003 | 31468466 | Archive     |
|  1351755 | 20140616091140 | 31611970 | Archive     |
|  1351755 | 20140618062933 | 31629601 | Archive     |
|  1351755 | 20140622025510 | 31666029 | Archive     |
|  1351755 | 20140623145947 | 31681773 | Archive     |
|  1351755 | 20140705081829 | 31792523 | Archive     |
|  1351755 | 20140707033157 | 31811041 | Archive     |
|  1351755 | 20140713132748 | 31879643 | Archive     |
|  1351755 | 20140731125919 | 32088534 | Archive     |
|  1351755 | 20140815083922 | 32279029 | Archive     |
|  1351755 | 20140819080234 | 32326061 | Archive     |
|  1351755 | 20140908093736 | 32593615 | Archive     |
|  1351755 | 20141011001533 | 32932753 | Archive     |
|  1351755 | 20141015015309 | 32974618 | Archive     |
|  1351755 | 20141021143033 | 33039801 | Archive     |
|  1351755 | 20141027181819 | 33099803 | Archive     |
|  1351755 | 20141108150255 | 33220151 | Archive     |
|  1351755 | 20141129163406 | 33459287 | Archive     |
|  1351755 | 20150206020253 | 34221819 | Archive     |
|  1351755 | 20150206020333 | 34221825 | Archive     |
|  1351755 | 20150810203654 | 36786861 | Archive     |
|   757371 | 20140803144208 | 32128595 | Archive     |
|  1351755 | 20140420120954 | 31054605 | Archive     |
|   379101 | 20150121200354 | 34045825 | Archive     |
|  1351755 | 20140329150342 | 30842343 | Archive     |
|  1351755 | 20140401031726 | 30864889 | Archive     |
|  1351755 | 20140507055629 | 31217958 | Archive     |
|  1351755 | 20140519074816 | 31333589 | Archive     |
|  1351755 | 20140527052030 | 31408742 | Archive     |
|  1351755 | 20140602043923 | 31468460 | Archive     |
|  1351755 | 20140616091135 | 31611969 | Archive     |
|  1351755 | 20140618062905 | 31629598 | Archive     |
|  1351755 | 20140622025448 | 31666026 | Archive     |
|  1351755 | 20140623145930 | 31681766 | Archive     |
|  1351755 | 20140705081803 | 31792518 | Archive     |
|  1351755 | 20140707033121 | 31811034 | Archive     |
|  1351755 | 20140713132644 | 31879627 | Archive     |
|  1351755 | 20140813165344 | 32258625 | Archive     |
|  1351755 | 20140815083841 | 32279026 | Archive     |
|  1351755 | 20140819080108 | 32326050 | Archive     |
|  1351755 | 20140908093617 | 32593600 | Archive     |
|  1351755 | 20140929092527 | 32815315 | Archive     |
|  1351755 | 20141011001511 | 32932751 | Archive     |
|  1351755 | 20141013070608 | 32957296 | Archive     |
|  1351755 | 20141015015305 | 32974615 | Archive     |
|  1351755 | 20141027181754 | 33099797 | Archive     |
|  1351755 | 20141108150215 | 33220141 | Archive     |
|  1351755 | 20141129163303 | 33459275 | Archive     |
|  1351755 | 20141223053552 | 33694163 | Archive     |
|  1351755 | 20141230002228 | 33772981 | Archive     |
|  1351755 | 20150206020237 | 34221816 | Archive     |
|  1351755 | 20150206020506 | 34221847 | Archive     |
|  1351755 | 20150810203404 | 36786857 | Archive     |
+----------+----------------+----------+-------------+
119 rows in set (22.35 sec)
MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='ARC' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20150824153532 |  5165465 | 36962874 | ARC         |
+----------+----------------+----------+----------+-------------+
1 row in set (29.12 sec)

MariaDB [zhwiki_p]>  select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='arc' limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|    28258 | 20140123073529 |   140048 | 29936714 | arc         |
|    28258 | 20150407081309 |   140048 | 35036067 | arc         |
|    28258 | 20140123073419 |  1847919 | 29936700 | arc         |
|  1351755 | 20140129044541 |  3779732 | 29997673 | arc         |
|  1351755 | 20140126020118 |  5165465 | 29964096 | arc         |
|  1351755 | 20140129044527 |  5165465 | 29997665 | arc         |
|  1351755 | 20140406070745 |  5165465 | 30919578 | arc         |
+----------+----------------+----------+----------+-------------+

近期使用Archive、arc、ARC这样的编辑摘要存档讨论页的基本上都是Bluedeck。(最近还有一位User:Kp2729使用arc,不过看上去和Bluedeck并无关连)从2014年1月用到2015年9月。之后Bluedeck开始使用自动化的工具存档,摘要为ARC+、ARC-。

MariaDB [zhwiki_p]> select rev_user ,  rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='VAN'  limit 5000;
+----------+----------------+----------+----------+-------------+
| rev_user | rev_timestamp  | rev_page | rev_id   | rev_comment |
+----------+----------------+----------+----------+-------------+
|  1351755 | 20151020173712 |      623 | 37616748 | VAN         |
|  1351755 | 20141015155822 |   160864 | 32982289 | VAN         |
|  1351755 | 20140928150317 |   215310 | 32809102 | VAN         |
|  1890236 | 20160103051226 |  1346634 | 38641293 | VAN         |
|  1890236 | 20160107102630 |  1556662 | 38682987 | VAN         |
|  1351755 | 20151120231342 |  4236199 | 37950991 | VAN         |
|  1351755 | 20151021002709 |  4459622 | 37617904 | VAN         |
+----------+----------------+----------+----------+-------------+
7 rows in set (22.39 sec)

只有Bluedeck和Black9869184在编辑摘要里用过VAN代表破坏,前者从2014年9月用到2015年11月。两位用户看上去无关联。

结论

编辑

综合以上结果,从编辑摘要的角度来看,Bluedeck账户的使用者不像是发生了变化。

参考文献

编辑
  1. ^ VPO,另外,即使账户被他人使用,未必等于就是“盗号”这种您所认定的涉嫌犯罪的行为,也许是自己主动的呢,这个都说不准。