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

Discussion in 'Troubleshooting and Problems' started by darren, Aug 2, 2013.

  1. darren

    darren Member

    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?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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


    		$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
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  4. darren

    darren Member

    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 );
  5. Brogan

    Brogan XenForo Moderator Staff Member

    You need to use phpMyAdmin.

Share This Page