I'm running a script to see who the most ignored user is ...

hold on I'll log in a normal user account in a second but are you telling me there things don't exist for non-admins?

twi1.jpg

twi2.jpg
 
SuicideTaxi said:
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 :lol:
Click to expand...
User CP -> Settings & Options -> Edit Ignore List using "projectTriton Liquid" theme.
SuicideTaxi said:
Also, even though I'm a contributer, I can't subscribe to threads.
Click to expand...
User CP -> Subscribed Threads -> List Subscriptions shows everything I'm subscribed to, including this one that I just added.
 
Oh wait... thats the old skin

How the fuck did it reset itself, I switched to the new one a few weeks ago....

Hah, I didn't even notice it switched back...
 
Rayn said:
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.
Click to expand...

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 :p

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. My "IgnoredUserIDs" column = your "IgnoreList" column
 
-raven- said:
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 :p

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
Click to expand...
interesting but this is a script like the one I have?
 
You must log in or register to reply here.
Back
Top