[geeklog-cvs] geeklog-1.3/plugins/spamx/sql blacklist.sql,NONE,1.1 data.sql,NONE,1.1 table.sql,NONE,1.1

[tony at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/plugins/spamx/sql
In directory www:/tmp/cvs-serv3542/plugins/spamx/sql

Added Files:
	blacklist.sql data.sql table.sql 
Log Message:
Spamx is officially part of Geeklog.  All should work fine minus the upgrade file...I'm still missing some key data that I will add yet this weekend


--- NEW FILE: data.sql ---
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','([w-_.]+.)?(l(so|os)tr).[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(blow)[w-_.]*job[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(buy)[w-_.]*online[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(diet|penis)[w-_.]*(pills|enlargement)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(i|la)-sonneries?[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(levitra|lolita|phentermine|viagra|vig-?rx|zyban|valtex|xenical|adipex|meridia\b)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(magazine)[w-_.]*(finder|netfirms)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(mike)[w-_.]*apartment[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(milf)[w-_.]*(hunter|moms|fucking)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(online)[w-_.]*casino[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(prozac|zoloft|xanax|valium|hydrocodone|vicodin|paxil|vioxx)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(ragazze)-?w+.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(ultram\b|\btenuate|tramadol|pheromones|phendimetrazine|ionamin|ortho.?tricyclen|retin.?a)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','(valtrex|zyrtec|\bhgh\b|ambien\b|flonase|allegra|didrex|renova\b|bontril|nexium)[w-_.]*.[a-z]{2,}')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','01-beltonen.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','01-klingeltoene.at')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','01-klingeltoene.de')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','01-loghi.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','01-logo.com')";
[...1837 lines suppressed...]
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.us')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.info')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.biz')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.info')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.us')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.biz')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.us')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Action','DeleteComment')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Examine','BlackList')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Examine','MTBlackList')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','healz.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','x-stories.org')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','finance.resik.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','mature-bitch.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','maturefucked.com')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','geocities.com/mac_user1979')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','sexgirlz.org')";
$_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','bcure.com')";


--- NEW FILE: blacklist.sql ---
INSERT INTO gl_spamx VALUES ('MTBlacklist','([w-_.]+.)?(l(so|os)tr).[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(blow)[w-_.]*job[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(buy)[w-_.]*online[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(diet|penis)[w-_.]*(pills|enlargement)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(i|la)-sonneries?[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(levitra|lolita|phentermine|viagra|vig-?rx|zyban|valtex|xenical|adipex|meridia)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(magazine)[w-_.]*(finder|netfirms)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(mike)[w-_.]*apartment[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(milf)[w-_.]*(hunter|moms|fucking)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(online)[w-_.]*casino[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(prozac|zoloft|xanax|valium|hydrocodone|vicodin|paxil|vioxx)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(ragazze)-?w+.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(ultram|tenuate|tramadol|pheromones|phendimetrazine|ionamin|ortho.?tricyclen|retin.?a)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','(valtrex|zyrtec|hgh|ambien|flonase|allegra|didrex|renova|bontril|nexium)[w-_.]*.[a-z]{2,}');
INSERT INTO gl_spamx VALUES ('MTBlacklist','01-beltonen.com');
INSERT INTO gl_spamx VALUES ('MTBlacklist','01-klingeltoene.at');
INSERT INTO gl_spamx VALUES ('MTBlacklist','01-klingeltoene.de');
INSERT INTO gl_spamx VALUES ('MTBlacklist','01-loghi.com');
INSERT INTO gl_spamx VALUES ('MTBlacklist','01-logo.com');
[...1834 lines suppressed...]
INSERT INTO gl_spamx VALUES ('MTBlacklist','free-texas-holdem-poker.us');
INSERT INTO gl_spamx VALUES ('MTBlacklist','free-texas-hold-em.biz');
INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.biz');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.us');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.com');
INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.info');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.biz');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.info');
INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.us');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.biz');
INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.us');
INSERT INTO gl_spamx VALUES ('Personal','sexgirlz.org');
INSERT INTO gl_spamx VALUES ('Personal','bcure.com');
INSERT INTO gl_spamx VALUES ('Personal','healz.com');
INSERT INTO gl_spamx VALUES ('Personal','x-stories.org');
INSERT INTO gl_spamx VALUES ('Personal','finance.resik.com');
INSERT INTO gl_spamx VALUES ('Personal','mature-bitch.com');
INSERT INTO gl_spamx VALUES ('Personal','maturefucked.com');
INSERT INTO gl_spamx VALUES ('Personal','geocities.com/mac_user1979');
INSERT INTO gl_spamx VALUES ('Personal','brutal-rape.biz');

--- NEW FILE: table.sql ---
CREATE TABLE {$_TABLES['spamx']} (
  name varchar(20) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  INDEX blocks_type(type)
) TYPE=MyISAM;