ST - Setting & Options/Edit Ignore List
HEY GENIUS
I SUCK AT TW
What do I have to do, rent a fucking billboard?
User CP -> Settings & Options -> Edit Ignore List using "projectTriton Liquid" theme.By the way Rayn.... I can't find the ignore list in my control panel in the new skin... I had to go find an absent post and then unignore him to see my list
User CP -> Subscribed Threads -> List Subscriptions shows everything I'm subscribed to, including this one that I just added.Also, even though I'm a contributer, I can't subscribe to threads.
anyone can subscribe to threads, its right in thread tools?
honestly I know some pretty cool SQL tricks but I don't think you can find a way to take a list like
6 7702 13052 9393
etc for 20,000 users and turn that into a list of the most ignored userids without using a cursor.
HEY GENIUS
THERE'S NO FUCKING LINK THERE
What do I have to do, rent a fucking billboard?
does in mineYeah nevermind... I was clicking the "Subscriptions" link not thread subscriptions
The ignore list thing tho... the link doesnt exist in the control panel
honestly I know some pretty cool SQL tricks but I don't think you can find a way to take a list like
6 7702 13052 9393
etc for 20,000 users and turn that into a list of the most ignored userids without using a cursor.
declare @ignore_user_links table (UserID int, IgnoredUserID int)
declare @tally table (ID int)
insert into @tally (ID) values (1)
insert into @tally (ID) values (2)
insert into @tally (ID) values (3)
insert into @tally (ID) values (4)
insert into @tally (ID) values (5)
insert into @tally (ID) values (6)
insert into @tally (ID) values (7)
insert into @tally (ID) values (8)
insert into @tally (ID) values (9)
insert into @tally (ID) values (10)
INSERT INTO @ignore_user_links
SELECT UserID,
NullIf(SubString(' ' + IgnoredUserIDs + ' ' , ID , CharIndex(' ' , ' ' + IgnoredUserIDs + ' ' , ID) - ID) , '') AS Word
FROM IgnoreTable, @tally
WHERE ID <= Len(' ' + IgnoredUserIDs + ' ') AND SubString(' ' + IgnoredUserIDs + ' ' , ID - 1, 1) = ' '
select IgnoredUserID, COUNT(*) AS IgnoreCount
from @ignore_user_links
group by IgnoredUserID
order by IgnoreCount desc
interesting but this is a script like the one I have?OK this does it. You'd want a better way to initialize your tally table, though. We know now that it needs over 300 rows thanks to absent
Code:declare @ignore_user_links table (UserID int, IgnoredUserID int) declare @tally table (ID int) insert into @tally (ID) values (1) insert into @tally (ID) values (2) insert into @tally (ID) values (3) insert into @tally (ID) values (4) insert into @tally (ID) values (5) insert into @tally (ID) values (6) insert into @tally (ID) values (7) insert into @tally (ID) values (8) insert into @tally (ID) values (9) insert into @tally (ID) values (10) INSERT INTO @ignore_user_links SELECT UserID, NullIf(SubString(' ' + IgnoredUserIDs + ' ' , ID , CharIndex(' ' , ' ' + IgnoredUserIDs + ' ' , ID) - ID) , '') AS Word FROM IgnoreTable, @tally WHERE ID <= Len(' ' + IgnoredUserIDs + ' ') AND SubString(' ' + IgnoredUserIDs + ' ' , ID - 1, 1) = ' ' select IgnoredUserID, COUNT(*) AS IgnoreCount from @ignore_user_links group by IgnoredUserID order by IgnoreCount desc
Probably not very useful now, but maybe in the future. It was fun to play with SQL anyway