I'm running a script to see who the most ignored user is ... by Rayn - Page 6 - TribalWar Forums
Click Here to find great hosting deals from Branzone.com


Go Back   TribalWar Forums > TribalWar Community > General Discussion
Reload this Page I'm running a script to see who the most ignored user is ...
Page 6 of 13
Thread Tools
GreyGhost
VeteranXX
Old
101 - 07-27-2008, 00:20
Reply With Quote
yes

subscribe is fine also
 
GreyGhost is offline
 
Sponsored Links
SuicideTaxi
VeteranXX
Contributor
Old
102 - 07-27-2008, 00:21
Reply With Quote
Quote:
Originally Posted by Stilgar View Post
ST - Setting & Options/Edit Ignore List
HEY GENIUS

THERE'S NO ****ING LINK THERE



What do I have to do, rent a ****ing billboard?
 
SuicideTaxi is offline
 
Rayn
Tribalwar Admin
Contributor
Old
103 - 07-27-2008, 00:22
Reply With Quote
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?


 
Rayn is offline
 
nada
VeteranX
Old
104 - 07-27-2008, 00:22
Reply With Quote
so wait, is he banned??
 
nada is offline
 
GreyGhost
VeteranXX
Old
105 - 07-27-2008, 00:22
Reply With Quote
Quote:
Originally Posted by SuicideTaxi View Post
HEY GENIUS

I SUCK AT TW



What do I have to do, rent a ****ing billboard?
 
GreyGhost is offline
 
LouCypher
VeteranX
Old
106 - 07-27-2008, 00:22
Reply With Quote
Quote:
Originally Posted by SuicideTaxi View Post
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 View Post
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.
 
LouCypher is offline
 
Rayn
Tribalwar Admin
Contributor
Old
107 - 07-27-2008, 00:23
Reply With Quote
ok logged in as a normal account I am seeing these options can you show me a screenshot or something?
 
Rayn is offline
 
LouCypher
VeteranX
Old
108 - 07-27-2008, 00:23
Reply With Quote
:sticky:
 
LouCypher is offline
 
SuicideTaxi
VeteranXX
Contributor
Old
109 - 07-27-2008, 00:23
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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
 
SuicideTaxi is offline
 
-raven-
VeteranX
Old
110 - 07-27-2008, 00:24
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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
 
-raven- is offline
 
KnightMare
VeteranX
Old
111 - 07-27-2008, 00:24
Reply With Quote
ss
Attached Images
File Type: png ignore.PNG (80.4 KB, 22 views)
 
KnightMare is offline
 
Stilgar
VeteranXX
Old
112 - 07-27-2008, 00:25
Reply With Quote
Quote:
Originally Posted by SuicideTaxi View Post
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.
 
Stilgar is offline
 
Gil
VeteranXV
Old
113 - 07-27-2008, 00:27
Reply With Quote
Quote:
Originally Posted by SuicideTaxi View Post
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.
 
Gil is offline
 
SuicideTaxi
VeteranXX
Contributor
Old
114 - 07-27-2008, 00:29
Reply With Quote
[IMG]http://www.reyvision.com/images/rey/****edtw1.jpg[/IMG]
 
SuicideTaxi is offline
 
Rayn
Tribalwar Admin
Contributor
Old
115 - 07-27-2008, 00:30
Reply With Quote
well I can't see that screenshot but do you have ANY of the settings * options links visible???
 
Rayn is offline
 
Rayn
Tribalwar Admin
Contributor
Old
116 - 07-27-2008, 00:30
Reply With Quote
whoa what the ****?
 
Rayn is offline
 
SuicideTaxi
VeteranXX
Contributor
Old
117 - 07-27-2008, 00:30
Reply With Quote
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...
 
SuicideTaxi is offline
 
-raven-
VeteranX
Old
118 - 07-27-2008, 00:31
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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
 
-raven- is offline
 
Rayn
Tribalwar Admin
Contributor
Old
119 - 07-27-2008, 00:32
Reply With Quote
oh ... dude that isn't the new skin.

hold on.
 
Rayn is offline
 
Rayn
Tribalwar Admin
Contributor
Old
120 - 07-27-2008, 00:32
Reply With Quote
Quote:
Originally Posted by -raven- View Post
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?
 
Rayn is offline
 
Page 6 of 13
Reply


Go Back   TribalWar Forums > TribalWar Community > General Discussion
Reload this Page I'm running a script to see who the most ignored user is ...

Social Website Bullshit

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)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


AGENT: claudebot / Y
All times are GMT -4. The time now is 12:55.