some threads are in my watchlist that i did not put there??? wtf
Theymos converted some of the generic "Sub" posts to watchlist entries.
The automatic transfer of "sub" posts to watchlist entries is finished. About 1000 posts were transferred. If your "sub" posts were not automatically transfered, make sure you manually transfer them soon. Moderators will eventually start deleting these posts.
This is the SQL query I used:
This is the SQL query I used:
Code:
insert ignore into smf_watchlist(ID_MEMBER,ID_TOPIC) select distinct
ID_MEMBER,ID_TOPIC from smf_messages where length(body)<40 and
lower(body) regexp '[[:<:]]sub.*' and lower(body) not like
'%subforum%' and lower(body) not like '%subdomain%' and lower(body)
not like '%subscriber%' and lower(body) not like '%subscript%' and
lower(body) not like '%subject%' and lower(body) not like
'%subsidy%' and lower(body) not like '%subsist%' and lower(body) not
like '%sub-%'and lower(body) not like '%submit%' and lower(body) not
like '%submers%' and lower(body) not like '%substance%' and
lower(body) not like '%substit%' and ID_MSG<>594521 and
ID_MSG<>442378 and ID_MSG<>345513 and ID_MSG>300000;
ID_MEMBER,ID_TOPIC from smf_messages where length(body)<40 and
lower(body) regexp '[[:<:]]sub.*' and lower(body) not like
'%subforum%' and lower(body) not like '%subdomain%' and lower(body)
not like '%subscriber%' and lower(body) not like '%subscript%' and
lower(body) not like '%subject%' and lower(body) not like
'%subsidy%' and lower(body) not like '%subsist%' and lower(body) not
like '%sub-%'and lower(body) not like '%submit%' and lower(body) not
like '%submers%' and lower(body) not like '%substance%' and
lower(body) not like '%substit%' and ID_MSG<>594521 and
ID_MSG<>442378 and ID_MSG<>345513 and ID_MSG>300000;
