• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Added some Trophy User Titles but not showing.

#1
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

XenForo moderator
Staff member
#2
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

Code:
		$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
		));
 
#4
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?

Code:
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 );