Jaxel
Well-known member
I noticed that XenForo's built in queries dont have anything along the lines of:
The idea is, if the user exist, use their username... otherwise use the username they submitted the item with (this happens if a user submitted an item when they had an account, but then their account gets deleted). Since I haven't seen anything like the above, I have to assume that XenForo has something automated for this?
Code:
IF(NOT ISNULL(xf_user.user_id), xf_user.username, EWRmedio_media.username) AS username
The idea is, if the user exist, use their username... otherwise use the username they submitted the item with (this happens if a user submitted an item when they had an account, but then their account gets deleted). Since I haven't seen anything like the above, I have to assume that XenForo has something automated for this?