* [gentoo-commits] gentoo-projects commit in forums/sql: release_2-0-23-gentoo-p5.sql
@ 2011-02-08 15:13 Tom Knight (tomk)
0 siblings, 0 replies; only message in thread
From: Tom Knight (tomk) @ 2011-02-08 15:13 UTC (permalink / raw
To: gentoo-commits
tomk 11/02/08 15:13:51
Added: release_2-0-23-gentoo-p5.sql
Log:
- Added stopforumspam.com functionality (tomk)
- Send daily profile spammer summary email (tomk)
Revision Changes Path
1.1 forums/sql/release_2-0-23-gentoo-p5.sql
file : http://sources.gentoo.org/viewvc.cgi/gentoo-projects/forums/sql/release_2-0-23-gentoo-p5.sql?rev=1.1&view=markup
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-projects/forums/sql/release_2-0-23-gentoo-p5.sql?rev=1.1&content-type=text/plain
Index: release_2-0-23-gentoo-p5.sql
===================================================================
UPDATE phpbb_config SET config_value = '.0.23-gentoo-p5' WHERE config_name = 'version';
# We don't want the API key in CVS so we will update it manually later
INSERT INTO phpbb_config (config_name, config_value)
VALUES ('stopforumspam_api_key', ''), ('stopforumspam_enable', '0'),
('stopforumspam_frequency_threshold', ''), ('stopforumspam_days_threshold', ''),
('last_spammer_email', UNIX_TIMESTAMP());
# add spammer reason to spammers table
ALTER TABLE phpbb_spammers ADD COLUMN user_spammer_reason varchar(255) default NULL;
^ permalink raw reply [flat|nested] only message in thread
only message in thread, other threads:[~2011-02-08 15:14 UTC | newest]
Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2011-02-08 15:13 [gentoo-commits] gentoo-projects commit in forums/sql: release_2-0-23-gentoo-p5.sql Tom Knight (tomk)
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox