phpBB 3.2.x - Restores default BOTs and deletes any BOT you added to it. (Make a Backup first)

default_bots_32.php

<?php
/***
* Usage:
* Download and unzip the file, upload it to your Board's root (i.e.: www.mydomain.com/phpBB3/)
* Point your browser to (i.e.: www.mydomain.com/phpBB3/default_bots_32.php)
*
* @package default phpBB's BOTS v2.0.0-b1 (06 03 2017)
* @copyright (c) 2016 3Di (Marco T.)
* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
*
*/
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);

/* If ANONYMOUS = login box */
if ((int) $user->data['user_id'] == ANONYMOUS)
{
	login_box(request_var('redirect', ''));
}

/* Is the User correctly Authed? */
if ((int) $user->data['user_type'] == USER_FOUNDER || $auth->acl_get('a_'))
{
	/* Add search robots to the database */
	global $db, $lang, $config, $table_prefix, $cache;

	$tools_factory = new \phpbb\db\tools\factory();
	$db_tools = $tools_factory->get($db);

	/* Obtains BOTS' group ID */
	echo 'Obtaining BOTS\' group ID.... ';
	$sql = 'SELECT group_id
		FROM ' . GROUPS_TABLE . "
		WHERE group_name = 'BOTS'";
	$result = $db->sql_query($sql);
	$group_id = (int) $db->sql_fetchfield('group_id');
	$db->sql_freeresult($result);

	if (!$group_id)
	{
		/**
		** If we reach this point then something has gone very wrong.
		** Tell the user what's up and self-destroy
		*/
		remove_me();
		trigger_error('No group ID found for BOTS!<br />....I am self destroying, hasta la vista!</font><br />');
	}
	echo '<font color="green">Done!</font><br />';

	/**
	** Let's make sure there aren't BOTS, deleting all
	** of those belonging to the BOTS's group_id
	** We are doing the dirty job here, to restore defaults
	*/
	echo 'Deleting all entries for BOTS group from USERS_TABLE.... ';
	$sql = 'DELETE
		FROM ' . USERS_TABLE . "
		WHERE group_id = $group_id";
	$db->sql_query($sql);
	echo '<font color="green">Done!</font><br />';

	/**
	** At this very point we are emptying the BOTS_TABLE to prevent errors
	** and to effectively restore the BOTS as per default
	*/
	$bots_table = $db_tools->sql_table_exists($table_prefix . 'bots');
	/* If table exists */
	if ($bots_table)
	{
		echo 'Emptying BOT_TABLE.... ';
		$table = BOTS_TABLE;
		switch ($db->get_sql_layer())
		{
			case 'sqlite':
			case 'sqlite3':
				$db->sql_query("DELETE FROM $table");
			break;

			default:
				$db->sql_query("TRUNCATE TABLE $table");
			break;
		}
		echo '<font color="green">Done!</font><br />';
	}
	else
	{
		/* Tell the user what's up and self-destroy */
		remove_me();
		trigger_error('BOTs table does NOT exists!<br />....I am self destroying, hasta la vista!</font><br />');
	}

	/**
	** Let's start restoring phpBB's default BOTS
	** Calling user_add on purpose.
	*/
	if (!function_exists('user_add'))
	{
		include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
	}

	$bot_list = array(
		'AdsBot [Google]'			=> array('AdsBot-Google', ''),
		'Alexa [Bot]'				=> array('ia_archiver', ''),
		'Alta Vista [Bot]'			=> array('Scooter/', ''),
		'Ask Jeeves [Bot]'			=> array('Ask Jeeves', ''),
		'Baidu [Spider]'			=> array('Baiduspider', ''),
		'Bing [Bot]'				=> array('bingbot/', ''),
		'Exabot [Bot]'				=> array('Exabot', ''),
		'FAST Enterprise [Crawler]'	=> array('FAST Enterprise Crawler', ''),
		'FAST WebCrawler [Crawler]'	=> array('FAST-WebCrawler/', ''),
		'Francis [Bot]'				=> array('http://www.neomo.de/', ''),
		'Gigabot [Bot]'				=> array('Gigabot/', ''),
		'Google Adsense [Bot]'		=> array('Mediapartners-Google', ''),
		'Google Desktop'			=> array('Google Desktop', ''),
		'Google Feedfetcher'		=> array('Feedfetcher-Google', ''),
		'Google [Bot]'				=> array('Googlebot', ''),
		'Heise IT-Markt [Crawler]'	=> array('heise-IT-Markt-Crawler', ''),
		'Heritrix [Crawler]'		=> array('heritrix/1.', ''),
		'IBM Research [Bot]'		=> array('ibm.com/cs/crawler', ''),
		'ICCrawler - ICjobs'		=> array('ICCrawler - ICjobs', ''),
		'ichiro [Crawler]'			=> array('ichiro/', ''),
		'Majestic-12 [Bot]'			=> array('MJ12bot/', ''),
		'Metager [Bot]'				=> array('MetagerBot/', ''),
		'MSN NewsBlogs'				=> array('msnbot-NewsBlogs/', ''),
		'MSN [Bot]'					=> array('msnbot/', ''),
		'MSNbot Media'				=> array('msnbot-media/', ''),
		'Nutch [Bot]'				=> array('http://lucene.apache.org/nutch/', ''),
		'Online link [Validator]'	=> array('online link validator', ''),
		'psbot [Picsearch]'			=> array('psbot/0', ''),
		'Sensis [Crawler]'			=> array('Sensis Web Crawler', ''),
		'SEO Crawler'				=> array('SEO search Crawler/', ''),
		'Seoma [Crawler]'			=> array('Seoma [SEO Crawler]', ''),
		'SEOSearch [Crawler]'		=> array('SEOsearch/', ''),
		'Snappy [Bot]'				=> array('Snappy/1.1 ( http://www.urltrends.com/ )', ''),
		'Steeler [Crawler]'			=> array('http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),
		'Telekom [Bot]'				=> array('crawleradmin.t-info@telekom.de', ''),
		'TurnitinBot [Bot]'			=> array('TurnitinBot/', ''),
		'Voyager [Bot]'				=> array('voyager/', ''),
		'W3 [Sitesearch]'			=> array('W3 SiteSearch Crawler', ''),
		'W3C [Linkcheck]'			=> array('W3C-checklink/', ''),
		'W3C [Validator]'			=> array('W3C_Validator', ''),
		'YaCy [Bot]'				=> array('yacybot', ''),
		'Yahoo MMCrawler [Bot]'		=> array('Yahoo-MMCrawler/', ''),
		'Yahoo Slurp [Bot]'			=> array('Yahoo! DE Slurp', ''),
		'Yahoo [Bot]'				=> array('Yahoo! Slurp', ''),
		'YahooSeeker [Bot]'			=> array('YahooSeeker/', ''),
	);

	foreach ($bot_list as $bot_name => $bot_ary)
	{
		$user_row = array(
			'user_type'				=> USER_IGNORE,
			'group_id'				=> (int) $group_id,
			'username'				=> (string) $bot_name,
			'user_regdate'			=> time(),
			'user_password'			=> '',
			'user_colour'			=> '9E8DA7',
			'user_email'			=> '',
			'user_lang'				=> (string) $config['default_lang'],
			'user_style'			=> 1,
			'user_timezone'			=> 'UTC',
			'user_dateformat'		=> $lang['default_dateformat'],
			'user_allow_massemail'	=> 0,
			'user_allow_pm'			=> 0,
		);
		echo 'Restoring default BOTs into USERS_TABLE.... ';
		$user_id = user_add($user_row);
		if (!$user_id)
		{
			/**
			** If we can't insert this user we need to delete the first one
			** already created to avoid inconsistent data
			*/
			$sql = 'DELETE
				FROM ' . USERS_TABLE . "
				WHERE group_id = $group_id";
			$db->sql_query($sql);

			remove_me();
			trigger_error('Unable to insert bot into users table<br />....I am self destroying, hasta la vista!</font><br />');
		}
		echo '<font color="green">Done!</font><br />';

		echo 'Restoring default BOTs into BOT_TABLE.... ';
		$sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(
			'bot_active'	=> 1,
			'bot_name'		=> (string) $bot_name,
			'user_id'		=> (int) $user_id,
			'bot_agent'		=> (string) $bot_ary[0],
			'bot_ip'		=> (string) $bot_ary[1],
		));
		$db->sql_query($sql);
		echo '<font color="green">Done!</font><br />';
	}

	/* Final step and thanks for all the fish */
	echo 'Purging cached BOTs .... ';
	$cache->destroy('_bots');
	echo '<font color="green">Done!</font><br />';

	echo '<br /><font color="blue">BOTs restore exited succesfully!... </font>';

	/* Hasta la vista! */
	echo '<br /><font color="blue"> ...I am self destroying, hasta la vista!</font><br /><br />';

	echo '<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top"><input type="hidden" name="cmd" value="_s-xclick"><input type="hidden" name="hosted_button_id" value="ZLN6KTV2WQSRN"><input type="image" src="https://www.paypal.com/en_GB/i/btn/btn_donate_LG.gif" border="0" name="submit" alt="PayPal – The safer, easier way to pay online."><img alt="" border="0" src="https://www.paypalobjects.com/en_GB/i/scr/pixel.gif" width="1" height="1"><font color="darkred"> Help the development of this Tool by a donation of your choice.</font></form>';

	/* comment out the following line to turn off the self-destroyer. */
	remove_me();
}
else
{
	/* If logged in without the right permissions, stop everything and self-destroy */
	remove_me();
	trigger_error('You don\'t have permission to access the database and files. You need to be logged in as a founder or administrator<br />....I am self destroying, hasta la vista!</font><br />');
}

/* Attempting to delete this file */
function remove_me()
{
	@unlink(__FILE__);

	/** Windows IIS servers may have a problem with unlinking recently created files.
	* * So check if file exists and give a message
	*/
	if (file_exists(__FILE__))
	{
		echo 'File could not be deleted. You will need to manually delete the ' . basename(__FILE__) . ' file from the server.';
	}
}