MyBB Community Forums

Anyone know of a query to delete signatures of members who have not logged in for x number of days? Or another way to accomplish this?

You need to calculate the unix timestamp for the milestone date you want to take in effect.
You may better suspend the sig instead of remove so that it can be accessed if required later.

UPDATE  `mybb_users` SET  `suspendsignature` =  '1' WHERE  `lastvisit` <= 1370079061;