Login   Register  
PHP Classes
elePHPant
Icontem

File: update-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  >  update-dummy.sql  >  Download  
File: update-dummy.sql
Role: Auxiliary data
Content type: text/plain
Description: For updating the old version
Class: Flood Assassin
Check whether a message can be spam
Author: By
Last change: Updated update-dummy.sql and fixed mistakes
Date: 5 years ago
Size: 748 bytes
 

Contents

Class file image Download
-- FloodAssassin UPDATED SQL-Dummy
-- For help visit http://projects.citrosaft.com/floodassassin
-- Tutorial under http://projects.citrosaft.com/floodassassin/tutorial.php

-- change current table and add a new column
ALTER TABLE `floodrules` ADD `rule_contentcount` FLOAT NOT NULL AFTER `rule_content`;

-- insert new rule
INSERT INTO `floodrules` 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 (NULL, '%link[\\s]*[\\w\\d]{20,}', '', '', '', '', '', 0, 0, 0, 0, 'LINK FOO'),
(11, '', 0, '', '', '60.190.240.73', '', 0, 0, 0, 2.9, 'FLOODIP [60.190.240.73]');