User:Tony Sidaway/Dubya vandalism
From Wikipedia, the free encyclopedia
Program to analyse vandalism on George W. Bush over time. This is written in Guile Scheme and requires access to the tools database, and the guile-dbi and guile-dbd-mysql modules written by Maurizio Boriani of the Free Software Foundation. The program is extremely simple and could be translated into Perl or C without any problems. If you understand SQL and the basic list operators of lisp, car and cdr, then you should be able to understand the program.
Contents |
[edit] Methodology
It isn't easy to recognise vandalism electronically, but we can recognise reverts of vandalism from the edit summaries. The current version of the program assumes that an edit is a vandalism revert if it has an edit summary containing "reverted edits by...to last version by", "rvv", "rvc" or "rv v".
The numbers tabulated below are an estimate of the number of vandalism reverts in each calendar month, a count of the number of edits in the same months, and the proportion of edits that are vandalism reverts.
For each vandalism revert there will be at least one edit by a vandal, so the actual proportion of vandalism-related edits will be close to double the proportion of vandalism reverts. Thus, if the proportion of vandalism reverts is 30%, the number of vandalism-related edits will be close to 60%.
[edit] The results
Superseded by this page.
[edit] The program
Superseded by this page.
[edit] Configuration library
This is a small library I wrote to hide the messy stuff of grabbing the username and password from the user's mysql configuration file (~/.my.cnf) and logging in to the database. It's listed at the same link above for the source.
