There have been multiple accounts created with the sole purpose of posting advertisement posts or replies containing unsolicited advertising.
Accounts which solely post advertisements, or persistently post them may be terminated.
rs5th , 1 year ago I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything. <span style="font-weight:bold;color:#a71d5d;">DELETE FROM</span><span style="color:#323232;"> activity </span><span style="font-weight:bold;color:#a71d5d;">WHERE</span><span style="color:#323232;"> published < NOW() </span><span style="font-weight:bold;color:#a71d5d;">-</span><span style="color:#323232;"> INTERVAL </span><span style="color:#183691;">'1 day'</span><span style="color:#323232;">; </span>
I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.
<span style="font-weight:bold;color:#a71d5d;">DELETE FROM</span><span style="color:#323232;"> activity </span><span style="font-weight:bold;color:#a71d5d;">WHERE</span><span style="color:#323232;"> published < NOW() </span><span style="font-weight:bold;color:#a71d5d;">-</span><span style="color:#323232;"> INTERVAL </span><span style="color:#183691;">'1 day'</span><span style="color:#323232;">; </span>