+ $license = 'http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2';

+ <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;

+ }

+}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+<?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',

+ ),

+ ),

+ );

+ }

+}

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

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

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

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

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

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

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

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

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

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

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

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

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

+ /** @var array */

+ protected $dependencies = array();

+

+ $check_dependencies = true;

+

+ else if ($check_dependencies)

+ {

+ $this->dependencies = array_merge($this->dependencies, $open_dependencies);

+ }

+ }

+

+ // Only run this check after the first run

+ if ($check_dependencies)

+ {

+ $this->check_dependencies();

+ $check_dependencies = false;

+

+ /**

+ * Check if one of the migrations files' dependencies can't be resolved

+ * by the supplied list of migrations

+ *

+ * @throws UnexpectedValueException If a dependency can't be resolved

+ */

+ protected function check_dependencies()

+ {

+ // Strip duplicate values from array

+ $this->dependencies = array_unique($this->dependencies);

+

+ foreach ($this->dependencies as $dependency)

+ {

+ if (!in_array($dependency, $this->class_names))

+ {

+ throw new \UnexpectedValueException("Unable to resolve the dependency '$dependency'");

+ }

+ }

+ }

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

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

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

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

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

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

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

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

+ '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,

+));

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

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

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

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

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

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

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

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

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

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

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

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

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_prune_shadow_topic_test extends phpbb_functional_test_case

+{

+ protected $data = array();

+ protected $post;

+

+ public function test_setup_forums()

+ {

+ $this->login();

+ $this->admin_login();

+

+ $crawler = self::request('GET', "adm/index.php?i=acp_forums&mode=manage&sid={$this->sid}");

+ $form = $crawler->selectButton('addforum')->form(array(

+ 'forum_name' => 'Prune Shadow',

+ ));

+ $crawler = self::submit($form);

+ $form = $crawler->selectButton('update')->form(array(

+ 'forum_perm_from' => 2,

+ 'enable_shadow_prune' => true,

+ 'prune_shadow_freq' => 1,

+ 'prune_shadow_days' => 1,

+ ));

+ $crawler = self::submit($form);

+ }

+

+ public function test_create_post()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Prune Shadow',

+ ),

+ ));

+

+ $this->assert_forum_details($this->data['forums']['Prune Shadow'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => 0,

+ ), 'initial comparison');

+

+ // Test creating topic

+ $this->post = $this->create_topic($this->data['forums']['Prune Shadow'], 'Prune Shadow #1', 'This is a test topic posted by the testing framework.');

+ $crawler = self::request('GET', "viewtopic.php?t={$this->post['topic_id']}&sid={$this->sid}");

+

+ $this->assertContains('Prune Shadow #1', $crawler->filter('html')->text());

+ $this->data['topics']['Prune Shadow #1'] = (int) $post['topic_id'];

+ $this->data['posts']['Prune Shadow #1'] = (int) $this->get_parameter_from_link($crawler->filter('.post')->selectLink($this->lang('POST', '', ''))->link()->getUri(), 'p');

+

+ $this->assert_forum_details($this->data['forums']['Prune Shadow'], array(

+ 'forum_posts_approved' => 1,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Prune Shadow #1'],

+ ), 'after creating topic #1');

+

+ // Test creating a reply

+ $post2 = $this->create_post($this->data['forums']['Prune Shadow'], $this->post['topic_id'], 'Re: Prune Shadow #1-#2', 'This is a test post posted by the testing framework.');

+ $crawler = self::request('GET', "viewtopic.php?t={$post2['topic_id']}&sid={$this->sid}");

+

+ $this->assertContains('Re: Prune Shadow #1-#2', $crawler->filter('html')->text());

+ $this->data['posts']['Re: Prune Shadow #1-#2'] = (int) $this->get_parameter_from_link($crawler->filter('.post')->eq(1)->selectLink($this->lang('POST', '', ''))->link()->getUri(), 'p');

+

+ $this->assert_forum_details($this->data['forums']['Prune Shadow'], array(

+ 'forum_posts_approved' => 2,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ 'forum_last_post_id' => $this->data['posts']['Re: Prune Shadow #1-#2'],

+ ), 'after replying');

+ }

+

+ public function test_move_topic()

+ {

+ $this->login();

+ $this->load_ids(array(

+ 'forums' => array(

+ 'Prune Shadow',

+ ),

+ 'topics' => array(

+ 'Prune Shadow #1',

+ ),

+ ));

+

+ $crawler = self::request('GET', "mcp.php?f={$this->data['forums']['Prune Shadow']}&i=main&action=move&mode=forum_view&start=0&topic_id_list[]={$this->data['topics']['Prune Shadow #1']}&sid={$this->sid}");

+ $form = $crawler->selectButton('confirm')->form(array(

+ 'to_forum_id' => 2,

+ 'move_leave_shadow' => true,

+ ));

+ $crawler = self::submit($form);

+

+ $this->assert_forum_details($this->data['forums']['Prune Shadow'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 1,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ ), 'after moving');

+

+ $this->db = $this->get_db();

+ // Date topic 3 days back

+ $sql = 'UPDATE phpbb_topics

+ SET topic_last_post_time = ' . (time() - 60*60*24*3) . '

+ WHERE topic_id = ' . ($this->data['topics']['Prune Shadow #1'] + 1);

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

+

+ $crawler = self::request('GET', "viewforum.php?f={$this->data['forums']['Prune Shadow']}&sid={$this->sid}");

+ $cron_link = $crawler->filter('img')->last()->attr('src');

+ $crawler = self::request('GET', $cron_link . "&sid={$this->sid}", array(), false);

+

+ $this->assert_forum_details($this->data['forums']['Prune Shadow'], array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_posts_softdeleted' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ 'forum_topics_softdeleted' => 0,

+ ), 'after the cron job');

+ }

+

+ public function assert_forum_details($forum_id, $details, $additional_error_message = '')

+ {

+ $this->db = $this->get_db();

+

+ $sql = 'SELECT ' . implode(', ', array_keys($details)) . '

+ FROM phpbb_forums

+ WHERE forum_id = ' . (int) $forum_id;

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

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

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

+

+ $this->assertEquals($details, $data, "Forum {$forum_id} does not match expected {$additional_error_message}");

+ }

+

+ public function load_ids($data)

+ {

+ $this->db = $this->get_db();

+

+ if (!empty($data['forums']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_forums

+ WHERE ' . $this->db->sql_in_set('forum_name', $data['forums']);

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

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

+ {

+ if (in_array($row['forum_name'], $data['forums']))

+ {

+ $this->data['forums'][$row['forum_name']] = (int) $row['forum_id'];

+ }

+ }

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

+ }

+

+ if (!empty($data['topics']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_topics

+ WHERE ' . $this->db->sql_in_set('topic_title', $data['topics']);

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

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

+ {

+ if (in_array($row['topic_title'], $data['topics']))

+ {

+ $this->data['topics'][$row['topic_title']] = (int) $row['topic_id'];

+ }

+ }

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

+ }

+

+ if (!empty($data['posts']))

+ {

+ $sql = 'SELECT *

+ FROM phpbb_posts

+ WHERE ' . $this->db->sql_in_set('post_subject', $data['posts']);

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

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

+ {

+ if (in_array($row['post_subject'], $data['posts']))

+ {

+ $this->data['posts'][$row['post_subject']] = (int) $row['post_id'];

+ }

+ }

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

+ }

+ }

+}

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+class schmema_generator_test extends phpbb_test_case

+{

+ public function setUp()

+ {

+ parent::setUp();

+

+ $this->config = new \phpbb\config\config(array());

+ $this->db = new \phpbb\db\driver\sqlite();

+ $this->db_tools = new \phpbb\db\tools($this->db);

+ $this->table_prefix = 'phpbb_';

+ }

+

+ protected function get_schema_generator(array $class_names)

+ {

+ $this->generator = new \phpbb\db\migration\schema_generator($class_names, $this->config, $this->db, $this->db_tools, $this->phpbb_root_path, $this->php_ext, $this->table_prefix);

+

+ return $this->generator;

+ }

+

+ /**

+ * @expectedException \UnexpectedValueException

+ */

+ public function test_check_dependencies_fail()

+ {

+ $this->get_schema_generator(array('\phpbb\db\migration\data\v310\forgot_password'));

+

+ $this->generator->get_schema();

+ }

+

+ public function test_get_schema_success()

+ {

+ $this->get_schema_generator(array(

+ '\phpbb\db\migration\data\v30x\release_3_0_1_rc1',

+ '\phpbb\db\migration\data\v30x\release_3_0_0',

+ '\phpbb\db\migration\data\v310\boardindex'

+ ));

+

+ $this->assertArrayHasKey('phpbb_users', $this->generator->get_schema());

+ }

+}

+ $this->assertSame($output, $return);

+ $this->assertSame($length, strlen($urandom_string));

+ $this->assertNotSame($rand_string, $urandom_string);

+ $this->assertNotSame($first_id, $this->driver_helper->unique_id());