Login   Register  
PHP Classes
elePHPant
Icontem

File: dummy.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Benjamin Falk  >  Flood Assassin  >  dummy.sql  >  Download  
File: dummy.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL-Dummy (for basic rules)
Class: Flood Assassin
Check whether a message can be spam
Author: By
Last change: Updated dummy and fixed errors
Date: 5 years ago
Size: 2,052 bytes
 

Contents

Class file image Download
-- FloodAssassin SQL-Dummy
-- For help visit http://projects.citrosaft.com/floodassassin
-- Tutorial under http://projects.citrosaft.com/floodassassin/tutorial.php
-- updated 20-01-2008 (mm-dd-yyyy)

-- create `floodrules`
CREATE TABLE `floodrules` (
  `rule_id` int(11) NOT NULL auto_increment,
  `rule_content` text NOT NULL,
  `rule_contentcount` float NOT NULL,
  `rule_name` varchar(64) NOT NULL,
  `rule_mail` varchar(128) NOT NULL,
  `rule_ip` varchar(16) NOT NULL,
  `rule_modifier` varchar(8) NOT NULL COMMENT '(i, s, ...)',
  `rule_contentlevel` float NOT NULL default '0',
  `rule_namelevel` float NOT NULL default '0',
  `rule_maillevel` float NOT NULL default '0',
  `rule_iplevel` float NOT NULL default '0',
  `rule_description` varchar(32) NOT NULL,
  PRIMARY KEY  (`rule_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- Data
INSERT INTO `floodrules` (`rule_id`, `rule_content`, `rule_contentcount`, `rule_name`, `rule_mail`, `rule_ip`, `rule_modifier`, `rule_contentlevel`, `rule_namelevel`, `rule_maillevel`, `rule_iplevel`, `rule_description`) VALUES
(1, 'Best search %link[\\s\\w\\d]*', 0, '', '', '', '', 0, 0, 0, 0, 'BEST SEARCH LINK'),
(2, '', 0, 'google', 'google@google\\.com', '', '', 0, 0, 0, 0, 'GOOGLE'),
(3, 'Hello\\.[\\s]*\\:\\) The natural photo of the new arrival\\, taken by Emma Tallulah\\''s dad\\,[\\s]*Bye\\.', 0, 'Alalgeage', 'ontokweddyepe@gmail\\.com', '', 'i', 8, 0, 0, 0, 'THE NATURAL PHOTO'),
(4, 'hallo', 0, '', '', '', 'i', -0.1, 0, 0, 0, 'HALLO'),
(5, 'hello', 0, '', '', '', 'i', -0.1, 0, 0, 0, 'HELLO'),
(6, '%neglook([[fjkdsh]/4])', 0, '', '', '', '', 3.5, 0, 0, 0, 'FJKDSH'),
(7, '%neglook([[ygabodfe]/5])', 0, '', '', '', '', 3, 0, 0, 0, 'YGABODFE'),
(8, '', 0, '', '@mail\\.com$', '', '', 0, 0, 2.5, 0, 'MAIL.COM'),
(9, '%neglook([[vmkj]/3])', 0, '', '', '', '', 3.5, 0, 0, 0, 'VWKJ'),
(10, '%link[\\s]*[\\w\\d]{20,}', 0, '', '', '', '', 0, 0, 0, 0, 'LINK FOO'),
(11, '', 0, '', '', '60.190.240.73', '', 0, 0, 0, 2.9, 'FLOODIP [60.190.240.73]');