Author: tille
Date: Thu Jan 5 16:42:57 2012
New Revision: 3100
URL: http://svn.debian.org/wsvn/blends/?sc=1&rev=3100
Log:
Add some spam subjects; handle some names
Modified:
blends/trunk/team_analysis_tools/get-archive-pages
blends/trunk/team_analysis_tools/replace_names.sql
Modified: blends/trunk/team_analysis_tools/get-archive-pages
URL:
http://svn.debian.org/wsvn/blends/blends/trunk/team_analysis_tools/get-archive-pages?rev=3100&op=diff
==============================================================================
--- blends/trunk/team_analysis_tools/get-archive-pages (original)
+++ blends/trunk/team_analysis_tools/get-archive-pages Thu Jan 5 16:42:57 2012
@@ -134,6 +134,10 @@
## This has to be implemented in the code below
my @SPAMAUTHORS = ('Pls check this new site', 'Tim.com.br');
my @SPAMSUBJECTS = ('File blocked - ScanMail for Lotus Notes',
+ 'FINAL NOTIFICATION',
+ 'WINNINGS.*live.com',
+ '^GOOD NEWS!+$',
+ '^Dear Email User (Important Notification)$',
'^u?n?subscribe\s+.?$');
# if != 0 then extract of mailing list archives is stored in files in dirs
Modified: blends/trunk/team_analysis_tools/replace_names.sql
URL:
http://svn.debian.org/wsvn/blends/blends/trunk/team_analysis_tools/replace_names.sql?rev=3100&op=diff
==============================================================================
--- blends/trunk/team_analysis_tools/replace_names.sql (original)
+++ blends/trunk/team_analysis_tools/replace_names.sql Thu Jan 5 16:42:57 2012
@@ -46,7 +46,6 @@
UPDATE listarchive SET author = 'Ahmed El-Mahmoudy' WHERE author like
'%Ahmed El-Mahmoudy%' OR author = 'aelmahmoudy-guest';
UPDATE listarchive SET author = 'Branden Robinson' WHERE author like
'Branden Robinson%' ;
UPDATE listarchive SET author = 'LI Daobing' WHERE author =
'lidaobing-guest' ;
-UPDATE listarchive SET author = 'Nicholas Breen' WHERE author =
'nbreen-guest' ;
UPDATE listarchive SET author = 'Egon Willighagen' WHERE author =
'egonw-guest' ;
UPDATE listarchive SET author = 'Jordan Mantha' WHERE author =
'laserjock-guest' ;
UPDATE listarchive SET author = 'Eric Sharkey' WHERE author =
'sharkey' ;
@@ -86,6 +85,17 @@
UPDATE listarchive SET author = 'Michael Hanke' WHERE author =
'mhanke-guest' OR author = 'mih' ;
UPDATE listarchive SET author = 'Mechtilde Stehmann' WHERE author =
'Mechtilde' AND project = 'lex' ;
UPDATE listarchive SET author = 'Gonéri Le Bouder' WHERE author like
'Gon%ri Le Bouder' ;
+
+-- updated at 5.1.2012
+UPDATE listarchive SET author = 'Johannes Ring' WHERE author like
'johannr-guest' ;
+UPDATE listarchive SET author = 'Christophe Trophime' WHERE author LIKE
'trophime%' OR author LIKE 'christophe.trophime' ;
+UPDATE listarchive SET author = 'Frédéric-Emmanuel PICCA' WHERE author ILIKE
'Picca Fr%d%ric%' OR author ILIKE 'Fr%d%ric% PICCA' OR author like 'picca';
+UPDATE listarchive SET author = 'Pierre Saramito' WHERE author ILIKE
'saramito-guest' ;
+UPDATE listarchive SET author = 'Gudjon I. Gudjonsson' WHERE author ILIKE
'gudjon-guest' ;
+UPDATE listarchive SET author = 'Ko van der Sloot' WHERE author ILIKE
'sloot-guest' ;
+UPDATE listarchive SET author = 'Sargis Dallakyan' WHERE author ILIKE
'sargis' OR author ILIKE 'sargis-guest' ;
+UPDATE listarchive SET author = 'Nicholas Breen' WHERE author ILIKE
'nbreen%';
+UPDATE listarchive SET author = 'Karol M. Langner' WHERE author ILIKE
'kml-guest' OR author ILIKE 'Karol Langner';
-- </new>
-- stupid spammers at project = 'pkg-grass-devel'.
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
