VeteranXX
|
yes
subscribe is fine also
|
|
|
VeteranXX Contributor
|
Quote:
Originally Posted by Stilgar
ST - Setting & Options/Edit Ignore List
|
HEY GENIUS
THERE'S NO ****ING LINK THERE
What do I have to do, rent a ****ing billboard?
|
|
|
Tribalwar Admin Contributor
|
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?
|
|
|
VeteranX
|
so wait, is he banned??
|
|
|
VeteranXX
|
Quote:
Originally Posted by SuicideTaxi
HEY GENIUS
I SUCK AT TW
What do I have to do, rent a ****ing billboard?
|
|
|
|
VeteranX
|
Quote:
Originally Posted by SuicideTaxi
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 -> Settings & Options -> Edit Ignore List using "projectTriton Liquid" theme.
Quote:
Originally Posted by SuicideTaxi
Also, even though I'm a contributer, I can't subscribe to threads.
|
User CP -> Subscribed Threads -> List Subscriptions shows everything I'm subscribed to, including this one that I just added.
|
|
|
Tribalwar Admin Contributor
|
ok logged in as a normal account I am seeing these options can you show me a screenshot or something?
|
|
|
VeteranXX Contributor
|
Quote:
Originally Posted by Rayn
anyone can subscribe to threads, its right in thread tools?
|
Yeah nevermind... I was clicking the "Subscriptions" link not thread subscriptions
The ignore list thing tho... the link doesnt exist in the control panel
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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.
|
It's possible and here's how to do it:
Parsing CSV Values Into Multiple Rows - SQLTeam.com
Pretty nifty, I'm going to try it on a table I made
|
|
|
VeteranXX
|
Quote:
Originally Posted by SuicideTaxi
HEY GENIUS
THERE'S NO ****ING LINK THERE
What do I have to do, rent a ****ing billboard?
|
WELL THERE IS ON MY PANEL.
Yell some more-it helps to get your lack of a point across.
|
|
|
VeteranXV
|
Quote:
Originally Posted by SuicideTaxi
Yeah nevermind... I was clicking the "Subscriptions" link not thread subscriptions
The ignore list thing tho... the link doesnt exist in the control panel
|
does in mine
TrImp I was gonna ask my DB prof tomorrow at class.
|
|
|
VeteranXX Contributor
|
[IMG]http://www.reyvision.com/images/rey/****edtw1.jpg[/IMG]
|
|
|
Tribalwar Admin Contributor
|
well I can't see that screenshot but do you have ANY of the settings * options links visible???
|
|
|
Tribalwar Admin Contributor
|
whoa what the ****?
|
|
|
VeteranXX Contributor
|
Oh wait... thats the old skin
How the **** did it reset itself, I switched to the new one a few weeks ago....
Hah, I didn't even notice it switched back...
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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.
|
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
|
|
|
Tribalwar Admin Contributor
|
oh ... dude that isn't the new skin.
hold on.
|
|
|
Tribalwar Admin Contributor
|
Quote:
Originally Posted by -raven-
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
|
interesting but this is a script like the one I have?
|
|
|
Tags
|
absent banned!
,
absent is jew
,
absent loves the jew dick
,
badmofo has a huge penis
,
ban absent
,
byebye absent
,
finland = jewland
,
for great justice
,
fuck tags
,
fuck yeah
,
fuck yeah tags
,
hey tags
,
jews > absent
,
keep tags permaban absent
,
motherfuckin tags
,
niggers jews bad news
,
shoot cops in face
,
suicide taxi is worthless
,
suicidetaxi is god
,
tags
,
tags > absent
,
tags are awesome
,
tags r back yo
,
tags!
,
turtles
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
AGENT: claudebot / Y
All times are GMT -4. The time now is 08:47.
|