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

XF 1.1 SQL Query

Discussion in 'XenForo Questions and Support' started by BamaStangGuy, Jun 11, 2012.

  1. BamaStangGuy

    BamaStangGuy Well-Known Member

    Need an SQL query for the following:

    Set homepage field to empty for everyone with 0 posts.
    Set signature to empty for everyone with 0 posts.
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    UPDATE xf_user_profile AS up
    SET up.signature = '', up.homepage = ''
    WHERE 0 = (
    	SELECT u.message_count
    	FROM xf_user AS u
    	WHERE u.user_id = up.user_id

Share This Page