phpBB Suomi

Koodi: Valitse kaikki

#-----[ SQL ]------------------------------------------

#

CREATE TABLE `phpbb_spam_words` (

`word_id` SMALLINT( 4 ) NOT NULL AUTO_INCREMENT ,

`spam_word` CHAR( 100 ) NOT NULL ,

PRIMARY KEY ( `word_id` )

);



CREATE TABLE `phpbb_spam_words_config` (

`config_name` VARCHAR( 255 ) NOT NULL ,

`config_value` VARCHAR( 255 ) NOT NULL

);



CREATE TABLE `phpbb_spam_words_log` (

  `log_id` mediumint(8) NOT NULL auto_increment,

  `log_user_id` mediumint(8) NOT NULL default '0',

  `log_username` varchar(25) NOT NULL default '',

  `log_ip` varchar(15) NOT NULL default '',

  `log_timestamp` int(11) NOT NULL default '0',

  `log_browser` varchar(255) NOT NULL default '',

  `log_message` text NOT NULL,

  `log_subject` varchar(255) NOT NULL default '',

  `log_flagged` tinyint(1) NOT NULL default '0',

  `log_post_id` mediumint(8) NOT NULL default '0',

  PRIMARY KEY  (`log_id`)

);



INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('enable_spam_words', '1');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('allow_admin', '1');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('allow_moderator', '0');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('allow_reg', '0');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('allow_user_posts', '50');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('user_warnings', '3');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('flag_posts', '1');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('error_message', 'You have tried to post a word that is on our spam words list');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('error_message_sig', 'You have a word in your signature that is on our spam words list. Please change your signature');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('warn_user_pm', '1');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('warn_user_pm_message', 'This is a warning. You have tried to post a word that is defined as spam on this website. Please refrain from do so again.');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('warn_user_pm_subject', 'Warning.');

INSERT INTO phpbb_spam_words_config (config_name, config_value) VALUES ('ban_ip', '0');



ALTER TABLE `phpbb_forums` ADD `allow_spam_words` TINYINT( 1 ) DEFAULT '0' NOT NULL;

ALTER TABLE `phpbb_posts` ADD `post_flagged` TINYINT( 1 ) NOT NULL;

ALTER TABLE `phpbb_users` ADD `user_spam_warnings` TINYINT( 1 ) NOT NULL;