Update Users

[Tyluur]

I am adding members with sql only, and that being said the counter on the bottom of forum.php does not update, and neither does the newest member. I have ran a few tests and the option "Update User Names" in "General Update Tools" fixes this. How would I run a task for this every 15 minutes or so?

This is what is done to update the users:

if ($_REQUEST['do'] == 'updateusernames')
{
	if (empty($vbulletin->GPC['perpage']))
	{
		$vbulletin->GPC['perpage'] = 1000;
	}

	echo '<p>' . $vbphrase['updating_usernames'] . '</p>';
	$users = $db->query_read("
		SELECT *
		FROM " . TABLE_PREFIX . "user
		WHERE userid >= " . $vbulletin->GPC['startat'] . "
		ORDER BY userid
		LIMIT " . $vbulletin->GPC['perpage']
	);

	$finishat = $vbulletin->GPC['startat'];
	while ($user = $db->fetch_array($users))
	{
		$userman =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
		$userman->set_existing($user);
		$userman->update_username($user['userid'], $user['username']);
		unset($userman);

		echo construct_phrase($vbphrase['processing_x'], $user['userid']) . "<br />\n";
		vbflush();

		$finishat = ($user['userid'] > $finishat ? $user['userid'] : $finishat);
	}

	$finishat++; // move past the last processed user

	if ($checkmore = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid >= $finishat LIMIT 1"))
	{
		print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateusernames&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
		echo "<p><a href=\"misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateusernames&amp;startat=$finishat&amp;pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "</a></p>";
	}
	else
	{
		define('CP_REDIRECT', 'misc.php');
		print_stop_message('updated_usernames_successfully');
	}
}

[kh99]

I think you just need to call the function build_user_statistics(), which is in includes/function_databuild.php. I don't understand exactly what that update username function does, but I'm guessing that the reason it works for you is because the user dm calls build_user_statistics() at some point.

If you wanted to have it run periodically you could create a scheduled task. Look at the files in includes/cron, find a simple example, and copy it to a new file name. The code just needs to include includes/function_databuild.php and call build_user_statistics(). Then you can use the Schedule Task manager to add a new scheduled task and specify your new php file as the file to run.

If you could live with it running only once per hour you could create a plugin using hook cron_script_cleanup_hourly, which is run from the existing "Hourly Cleanup" task.