Expire Unactivated Users by Timeframe

[Dogs and things]

Nice MOD,

Very handy, comfortable and simple.

Thanks for writing it!

[screamintrucker]

I have included the two pieces of code that I can't figure out what to do with. If anyone knows please be very specific here is the first one.
NUMBER 1.)

Code: Select all

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('expire_automation_enable', '0');
CREATE TABLE phpbb_unactivated_automation (
expire_id TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
automation_timeframe INT(11) UNSIGNED NOT NULL DEFAULT '0',
last_autoexpire_time varchar(60) NOT NULL DEFAULT '0',
PRIMARY KEY (`expire_id`)
);
INSERT INTO phpbb_unactivated_automation ( expire_id, automation_timeframe, last_autoexpire_time) VALUES ('1', '0', '0');

Now here is the second one. Please be specific.
NUMBER 2.)

Code: Select all

#
#-----[ COPY ]------------------------------------------
#
copy root/admin_expire_unactivated.php to admin/admin_expire_unactivated.php
copy root/board_expire_accounts.tpl to templates/subSilver/admin/board_expire_accounts.tpl
copy root/expire_unactivated_automation.php to includes/expire_unactivated_automation.php

I am trying to install this mod and these are the only two snippets I don't know what to do with. Thanks in advance. This mod will save me so much time if I can get it installed. Thanks, Dave

[Dogs and things]

For the first part, that are SQL queries that you need to execute, read Executing SQL Queries in phpMyAdmin to find out how to do that.

The second part is very simply, do exactly what it tells you to do, copy the mentioned files from the folder you downloaded to the indicated locations in your forum's folders on your server. Be aware that the file ending in .tpl needs to be copied to all styles you have installed on your board, not only to subSilver.