Expired account upgrades

[Blue]

I have an account upgrade where the user can have a custom title and a sig. I noticed an account that the upgrade had expired and the custom title reverted but the account still was showing a sig in the postbit. Is this normal? I thought that once the secondary usergroup was removed all the secondary permissions would be removed as well.

 

[ragtek]

I have an account upgrade where the user can have a custom title and a sig. I noticed an account that the upgrade had expired and the custom title reverted but the account still was showing a sig in the postbit. Is this normal? I thought that once the secondary usergroup was removed all the secondary permissions would be removed as well.

The permissions are only checked, while you save the new signature.
So you would need an cronjob or extend the userupgrade cron to check and remove the signatures or you could send a conversation that the user needs to change the signature ...

 

[Blue]

I believe a cronjob would be the best solution, but I have no idea how to do it. If there is a query I could run that would only clear sigs for those that did not have the secondary usergroup that might work too.

 

[Jake Bunce]

I believe a cronjob would be the best solution, but I have no idea how to do it. If there is a query I could run that would only clear sigs for those that did not have the secondary usergroup that might work too.

I like queries.

UPDATE xf_user_profile AS user_profile
SET user_profile.signature = ''
WHERE (
	SELECT user.user_id
	FROM xf_user AS user
	WHERE user.user_id = user_profile.user_id
	AND NOT FIND_IN_SET(23, user.secondary_group_ids)
);

Change the red piece to specify the group id that grants signature permissions.

Backup first. And please understand that this clears signatures for all users who do not belong to the specified group. For example, if an admin is not also in that group then their signature will get cleared. You may wish to exclude admins and mods, like this:

UPDATE xf_user_profile AS user_profile
SET user_profile.signature = ''
WHERE (
	SELECT user.user_id
	FROM xf_user AS user
	WHERE user.user_id = user_profile.user_id
	AND NOT FIND_IN_SET(23, user.secondary_group_ids)
	AND NOT FIND_IN_SET(3, user.secondary_group_ids)
	AND NOT FIND_IN_SET(4, user.secondary_group_ids)
);

Basically you are specifying all secondary groups that are allowed to have signatures.

 

[MGSteve]

Is there anyway this could be built into the XF core as I need a similar feature due to the fact we give extra features to those who subscribe, which then need to be removed should their subscription lapse.

I'd have thought anyone who did similar (probably most people who use account upgrades) will need this.

 

[Blue]

I like queries.

Change the red piece to specify the group id that grants signature permissions.

Backup first. And please understand that this clears signatures for all users who do not belong to the specified group. For example, if an admin is not also in that group then their signature will get cleared. You may wish to exclude admins and mods, like this:

Basically you are specifying all secondary groups that are allowed to have signatures.

This should do the job just fine. I have to wait until the 21st to run it, that's when the next user with a sigs upgrade expires.

Thanks Jake.

 

[Blue]

Is there anyway this could be built into the XF core as I need a similar feature due to the fact we give extra features to those who subscribe, which then need to be removed should their subscription lapse.

I'd have thought anyone who did similar (probably most people who use account upgrades) will need this.

I would like to see it built in as well.

 

[Blue]

Custom titles are not reverting after an upgrade expires in some cases. Is there a query I could run similar to this one to revert custom titles after an upgrade expires?

I like queries.

Change the red piece to specify the group id that grants signature permissions.

Backup first. And please understand that this clears signatures for all users who do not belong to the specified group. For example, if an admin is not also in that group then their signature will get cleared. You may wish to exclude admins and mods, like this:

UPDATE xf_user_profile AS user_profile
SET user_profile.signature = ''
WHERE (
SELECT user.user_id
FROM xf_user AS user
WHERE user.user_id = user_profile.user_id
AND NOT FIND_IN_SET(23, user.secondary_group_ids)
AND NOT FIND_IN_SET(3, user.secondary_group_ids)
AND NOT FIND_IN_SET(4, user.secondary_group_ids)
);

Basically you are specifying all secondary groups that are allowed to have signatures.

 

[Jake Bunce]

Try this:

Admin CP -> Tools -> Rebuild Caches -> Rebuild User Caches

 

[Blue]

Thanks Jake

 

[Blue]

Try this:

Admin CP -> Tools -> Rebuild Caches -> Rebuild User Caches

Hey Jake, this doesn't seem to be working. Do you know of a query like this one that would clear custom titles?

UPDATE xf_user_profile AS user_profile
SET user_profile.signature = ''
WHERE (
    SELECT user.user_id
    FROM xf_user AS user
    WHERE user.user_id = user_profile.user_id
    AND NOT FIND_IN_SET(23, user.secondary_group_ids)
    AND NOT FIND_IN_SET(3, user.secondary_group_ids)
    AND NOT FIND_IN_SET(4, user.secondary_group_ids)
);

 

[Jake Bunce]

http://xenforo.com/community/threads/remove-custom-usertitles.35153/#post-399218

 

[Blue]

http://xenforo.com/community/threads/remove-custom-usertitles.35153/#post-399218

I don't want to clear all of them I need to keep them for 2 usergroups. Something like this.


UPDATE xf_user
SET custom_title = '';
WHERE (
SELECT user.user_id
FROM xf_user AS user
WHERE user.user_id = user_profile.user_id
AND NOT FIND_IN_SET(3, user.secondary_group_ids)
AND NOT FIND_IN_SET(4, user.secondary_group_ids)
);

 

[Jake Bunce]

UPDATE xf_user
SET custom_title = ''
WHERE NOT FIND_IN_SET(3, secondary_group_ids)
AND NOT FIND_IN_SET(4, secondary_group_ids);

 

[Blue]

UPDATE xf_user
SET custom_title = ''
WHERE NOT FIND_IN_SET(3, secondary_group_ids)
AND NOT FIND_IN_SET(4, secondary_group_ids);

Great. Thank you.

 

[Blue]

UPDATE xf_user
SET custom_title = ''
WHERE NOT FIND_IN_SET(3, secondary_group_ids)
AND NOT FIND_IN_SET(4, secondary_group_ids);

Sorry I thought I was covered with just 2 usergroups but I need to exclude 3 different usergroups. I tried adding another line but it doesn't work and I get an error.

UPDATE xf_user
SET custom_title = ''
WHERE NOT FIND_IN_SET(3, secondary_group_ids)
AND NOT FIND_IN_SET(4, secondary_group_ids)
AND NOT FIND_IN_SET(5, secondary_group_ids);

 

[Jake Bunce]

@Blue

What error?

 

[Blue]

I must have not taken my meds today. I just ran it again and it was fine. Sorry to bother you Jake.