XF 1.2 Added some Trophy User Titles but not showing.

[darren]

I've added 2 new Trophy user titles based on user count and they're there saved on the menu but not showing on the forum?

I have rerun some of the cron tasks and rebuilt the user cache and they're still not active.

What am I missing?

 

[Jake Bunce]

The cron only processes users who have been active in the last 24 hours (86400 seconds). You can change it:

library/XenForo/CronEntry/Trophy.php

		$users = $userModel->getUsers(array(
			'user_state' => 'valid',
			'is_banned' => 0,
			'last_activity' => array('>', XenForo_Application::$time - 86400)
		), array(
			'join' => XenForo_Model_User::FETCH_USER_FULL
		));

 

[Jake Bunce]

Probably not needed but can be useful in some situations:

http://xenforo.com/community/threads/recalculate-trophy-points.30800/#post-351948

 

[darren]

Thanks Jake

How would I manually run the below query, is there a way of doing it from within the admincp like on the other forum sw I came from?

TRUNCATE TABLE xf_user_trophy; UPDATE xf_user AS u SET u.trophy_points = ( SELECT SUM(t.trophy_points) FROM xf_user_trophy AS ut LEFT JOIN xf_trophy AS t ON (t.trophy_id = ut.trophy_id) WHERE ut.user_id = u.user_id );

 

[Paul B]

You need to use phpMyAdmin.