+ <dl>

+ <dt><label for="enable_shadow_prune">{L_FORUM_PRUNE_SHADOW}{L_COLON}</label><br /><span>{L_FORUM_PRUNE_SHADOW_EXPLAIN}</span></dt>

+ <dd><label><input type="radio" class="radio" name="enable_shadow_prune" value="1"<!-- IF S_PRUNE_SHADOW_ENABLE --> id="enable_shadow_prune" checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="enable_shadow_prune" value="0"<!-- IF not S_PRUNE_SHADOW_ENABLE --> id="enable_shadow_prune" checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+ </dl>

+ <dl>

+ <dt><label for="prune_shadow_freq">{L_AUTO_PRUNE_FREQ}{L_COLON}</label><br /><span>{L_AUTO_PRUNE_FREQ_EXPLAIN}</span></dt>

+ <dd><input type="number" id="prune_shadow_freq" name="prune_shadow_freq" value="{PRUNE_FREQ}" maxlength="4" size="4" min="0" max="9999" /> {L_DAYS}</dd>

+ </dl>

+ <dl>

+ <dt><label for="prune_shadow_days">{L_AUTO_PRUNE_DAYS}{L_COLON}</label><br /><span>{L_AUTO_PRUNE_DAYS_EXPLAIN}</span></dt>

+ <dd><input type="number" id="prune_shadow_days" name="prune_shadow_days" value="{PRUNE_DAYS}" maxlength="4" size="4" min="0" max="9999" /> {L_DAYS}</dd>

+ </dl>

+ cron.task.core.prune_shadow_topics:

+ class: phpbb\cron\task\core\prune_shadow_topics

+ arguments:

+ - %core.root_path%

+ - %core.php_ext%

+ - @config

+ - @dbal.conn

+ - @log

+ calls:

+ - [set_name, [cron.task.core.prune_shadow_topics]]

+ tags:

+ - { name: cron.task }

+

+ 'S_IN_FAQ' => true,

+ 'enable_shadow_prune' => request_var('enable_shadow_prune', false),

+ 'prune_shadow_days' => request_var('prune_shadow_days', 7),

+ 'prune_shadow_freq' => request_var('prune_shadow_freq', 1),

+ 'enable_shadow_prune' => false,

+ 'prune_shadow_days' => 7,

+ 'prune_shadow_freq' => 1,

+ 'PRUNE_SHADOW_FREQ' => $forum_data['prune_shadow_freq'],

+ 'PRUNE_SHADOW_DAYS' => $forum_data['prune_shadow_days'],

+ 'S_PRUNE_SHADOW_ENABLE' => ($forum_data['enable_shadow_prune']) ? true : false,

+ $url = redirect($url, true, $disable_cd_check);

+ 'url' => $url,

+ // For XHTML compatibility we change back & to &amp;

+ if ($prune_mode == 'shadow')

+ {

+ $sql_and .= ' AND topic_status = ' . ITEM_MOVED . " AND topic_last_post_time < $prune_date";

+ }

+

+ 'S_INDEX' => true,

+ "enable_shadow_prune": [

+ "BOOL",

+ 0

+ ],

+ "prune_shadow_days": [

+ "UINT",

+ 7

+ ],

+ "prune_shadow_freq": [

+ "UINT",

+ 1

+ ],

+ "prune_shadow_next": [

+ "INT:11",

+ 0

+ ],

+ 'LOG_PRUNE_SHADOW' => '<strong>Auto-pruned shadow topics</strong><br />» %s',

+ 'FORUM_PRUNE_SHADOW' => 'Enable auto-pruning of shadow topics',

+ 'FORUM_PRUNE_SHADOW_EXPLAIN' => 'Prunes the forum of shadow topics, set the frequency/age parameters below.',

+ 1 => 'phpBB BBCode supports a number of ways of creating URIs (Uniform Resource Indicators) better known as URLs.<ul><li>The first of these uses the <strong>[url=][/url]</strong> tag, whatever you type after the = sign will cause the contents of that tag to act as a URL. For example to link to phpBB.com you could use:<br /><br /><strong>[url=http://www.phpbb.com/]</strong>Visit phpBB!<strong>[/url]</strong><br /><br />This would generate the following link, <a href="http://www.phpbb.com/">Visit phpBB!</a> Please notice that the link opens in the same window or a new window depending on the users browser preferences.</li><li>If you want the URL itself displayed as the link you can do this by simply using:<br /><br /><strong>[url]</strong>http://www.phpbb.com/<strong>[/url]</strong><br /><br />This would generate the following link, <a href="http://www.phpbb.com/">http://www.phpbb.com/</a></li><li>Additionally, phpBB features something called <i>Magic Links</i>, this will turn any syntactically correct URL into a link without you needing to specify any tags or even the leading http://. For example typing www.phpbb.com into your message will automatically lead to <a href="http://www.phpbb.com/">www.phpbb.com</a> being output when you view the message.</li><li>The same thing applies equally to email addresses, you can either specify an address explicitly for example:<br /><br /><strong>[email]</strong>no.one@domain.adr<strong>[/email]</strong><br /><br />which will output <a href="mailto:no.one@domain.adr">no.one@domain.adr</a> or you can just type no.one@domain.adr into your message and it will be automatically converted when you view.</li></ul>As with all the BBCode tags you can wrap URLs around any of the other tags such as <strong>[img][/img]</strong> (see next entry), <strong>[b][/b]</strong>, etc. As with the formatting tags it is up to you to ensure the correct open and close order is following, for example:<br /><br /><strong>[url=http://www.phpbb.com/][img]</strong>http://www.phpbb.com/theme/images/logos/blue/160x52.png<strong>[/url][/img]</strong><br /><br />is <span style="text-decoration: underline">not</span> correct which may lead to your post being deleted so take care.'

+ 1 => 'phpBB BBCode incorporates a tag for including images in your posts. Two very important things to remember when using this tag are: many users do not appreciate lots of images being shown in posts and secondly the image you display must already be available on the internet (it cannot exist only on your computer for example, unless you run a webserver!). To display an image you must surround the URL pointing to the image with <strong>[img][/img]</strong> tags. For example:<br /><br /><strong>[img]</strong>http://www.phpbb.com/theme/images/logos/blue/160x52.png<strong>[/img]</strong><br /><br />As noted in the URL section above you can wrap an image in a <strong>[url][/url]</strong> tag if you wish, e.g.<br /><br /><strong>[url=http://www.phpbb.com/][img]</strong>http://www.phpbb.com/theme/images/logos/blue/160x52.png<strong>[/img][/url]</strong><br /><br />would generate:<br /><br /><a href="http://www.phpbb.com/"><img src="http://www.phpbb.com/theme/images/logos/blue/160x52.png" alt="" /></a>'

+// Setting a variable to let the style designer know where he is...

+$template->assign_var('S_IN_MEMBERLIST', true);

+

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\cron\task\core;

+

+/**

+* Prune one forum of its shadow topics cron task.

+*

+* It is intended to be used when cron is invoked via web.

+* This task can decide whether it should be run using data obtained by viewforum

+* code, without making additional database queries.

+*

+* @package phpBB3

+*/

+class prune_shadow_topics extends \phpbb\cron\task\base implements \phpbb\cron\task\parametrized

+{

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+ protected $log;

+

+ /**

+ * If $forum_data is given, it is assumed to contain necessary information

+ * about a single forum that is to be pruned.

+ *

+ * If $forum_data is not given, forum id will be retrieved via request_var

+ * and a database query will be performed to load the necessary information

+ * about the forum.

+ */

+ protected $forum_data;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param \phpbb\config\config $config The config

+ * @param \phpbb\db\driver\driver $db The db connection

+ * @param \phpbb\log\log $log The phpBB log system

+ */

+ public function __construct($phpbb_root_path, $php_ext, \phpbb\config\config $config, \phpbb\db\driver\driver $db, \phpbb\log\log $log)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ $this->db = $db;

+ $this->log = $log;

+ }

+

+ /**

+ * Manually set forum data.

+ *

+ * @param array $forum_data Information about a forum to be pruned.

+ */

+ public function set_forum_data($forum_data)

+ {

+ $this->forum_data = $forum_data;

+ }

+

+ /**

+ * Runs this cron task.

+ *

+ * @return null

+ */

+ public function run()

+ {

+ if (!function_exists('auto_prune'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ }

+

+ if ($this->forum_data['prune_shadow_days'])

+ {

+ $this->auto_prune_shadow_topics($this->forum_data['forum_id'], 'shadow', $this->forum_data['forum_flags'], $this->forum_data['prune_shadow_days'], $this->forum_data['prune_shadow_freq']);

+ }

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * This cron task will not run when system cron is utilised, as in

+ * such cases prune_all_forums task would run instead.

+ *

+ * Additionally, this task must be given the forum data, either via

+ * the constructor or parse_parameters method.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ return !$this->config['use_system_cron'] && $this->forum_data;

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * Forum pruning interval is specified in the forum data.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ return $this->forum_data['enable_shadow_prune'] && $this->forum_data['prune_shadow_next'] < time();

+ }

+

+ /**

+ * Returns parameters of this cron task as an array.

+ * The array has one key, f, whose value is id of the forum to be pruned.

+ *

+ * @return array

+ */

+ public function get_parameters()

+ {

+ return array('f' => $this->forum_data['forum_id']);

+ }

+

+ /**

+ * Parses parameters found in $request, which is an instance of

+ * \phpbb\request\request_interface.

+ *

+ * It is expected to have a key f whose value is id of the forum to be pruned.

+ *

+ * @param \phpbb\request\request_interface $request Request object.

+ *

+ * @return null

+ */

+ public function parse_parameters(\phpbb\request\request_interface $request)

+ {

+ $this->forum_data = null;

+ if ($request->is_set('f'))

+ {

+ $forum_id = $request->variable('f', 0);

+

+ $sql = 'SELECT forum_id, prune_shadow_next, enable_shadow_prune, prune_shadow_days, forum_flags, prune_shadow_freq

+ FROM ' . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

+ $result = $this->db->sql_query($sql);

+ $row = $this->db->sql_fetchrow($result);

+ $this->db->sql_freeresult($result);

+

+ if ($row)

+ {

+ $this->forum_data = $row;

+ }

+ }

+ }

+

+ /**

+ * Automatically prune shadow topics

+ * Based on fuunction auto_prune()

+ * @param int $forum_id Forum ID of forum that should be pruned

+ * @param string $prune_mode Prune mode

+ * @param int $prune_flags Prune flags

+ * @param int $prune_freq Prune frequency

+ * @return null

+ */

+ protected function auto_prune_shadow_topics($forum_id, $prune_mode, $prune_flags, $prune_days, $prune_freq)

+ {

+ $sql = 'SELECT forum_name

+ FROM ' . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

+ $result = $this->db->sql_query($sql, 3600);

+ $row = $this->db->sql_fetchrow($result);

+ $this->db->sql_freeresult($result);

+

+ if ($row)

+ {

+ $prune_date = time() - ($prune_days * 86400);

+ $next_prune = time() + ($prune_freq * 86400);

+

+ prune($forum_id, $prune_mode, $prune_date, $prune_flags, true);

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET prune_shadow_next = $next_prune

+ WHERE forum_id = $forum_id";

+ $this->db->sql_query($sql);

+

+ $this->log->add('admin', 'LOG_PRUNE_SHADOW', $row['forum_name']);

+ }

+

+ return;

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class prune_shadow_topics extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'enable_shadow_prune' => array('BOOL', 0),

+ 'prune_shadow_days' => array('UINT', 7),

+ 'prune_shadow_freq' => array('UINT', 1),

+ 'prune_shadow_next' => array('INT:11', 0),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'enable_shadow_prune',

+ 'prune_shadow_days',

+ 'prune_shadow_freq',

+ 'prune_shadow_next',

+ ),

+ ),

+ );

+ }

+}

+ 'S_IN_POSTING' => true,

+ 'S_CAN_NOTIFY' => ($user->data['is_registered']) ? true : false,

+ 'S_IN_REPORT' => true,

+));

+ <label for="bday_day">{L_DAY}{L_COLON} <select name="bday_day" id="bday_day">{S_BIRTHDAY_DAY_OPTIONS}</select></label>

+ <label for="bday_month">{L_MONTH}{L_COLON} <select name="bday_month" id="bday_month">{S_BIRTHDAY_MONTH_OPTIONS}</select></label>

+ <label for="bday_year">{L_YEAR}{L_COLON} <select name="bday_year" id="bday_year">{S_BIRTHDAY_YEAR_OPTIONS}</select></label>

+ else

+ {

+ // See if we should prune the shadow topics instead

+ $task = $cron->find_task('cron.task.core.prune_shadow_topics');

+ $task->set_forum_data($forum_data);

+

+ if ($task->is_ready())

+ {

+ $url = $task->get_url();

+ $template->assign_var('RUN_CRON_TASK', '<img src="' . $url . '" width="1" height="1" alt="cron" />');

+ }

+ }

+ 'S_SWITCH_GUEST_DISPLAY' => ($config['load_online_guests']) ? true : false,

+ 'S_VIEWONLINE' => true,

+));