I'm running a script to see who the most ignored user is ... by Rayn - Page 7 - 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 7 of 13
Thread Tools
LogRoller
VeteranXX
Old
121 - 07-27-2008, 00:33
Reply With Quote
haha, awesome
 
LogRoller is offline
 
Sponsored Links
Rayn
Tribalwar Admin
Contributor
Old
122 - 07-27-2008, 00:33
Reply With Quote
there I fixed the old skin for the new options.
 
Rayn is offline
 
Rayn
Tribalwar Admin
Contributor
Old
123 - 07-27-2008, 00:34
Reply With Quote
see this is the kind of **** I need to know.
 
Rayn is offline
 
Oktane
VeteranXV
Old
124 - 07-27-2008, 00:34
Reply With Quote
Quote:
Originally Posted by SuicideTaxi View Post
[IMG]http://www.reyvision.com/images/rey/****edtw1.jpg[/IMG]
that's what mine looks like but if you go into "edit options" there's an "edit ignore list" in there.
 
Oktane is offline
 
Rayn
Tribalwar Admin
Contributor
Old
125 - 07-27-2008, 00:35
Reply With Quote
it was the old skin and it was missing new 'phrases' so I just made some quick adjustments and it should be up to date now with the new vbulletin

i swear they changed some of the stupidest **** .......
 
Rayn is offline
 
-raven-
VeteranX
Old
126 - 07-27-2008, 00:36
Reply With Quote
Quote:
Originally Posted by Rayn View Post
interesting but this is a script like the one I have?
It's all SQL... you made it sound like you wrote something in another language

It could be put in a single query if you use a nested query instead of using the table variable
 
-raven- is offline
 
Gil
VeteranXV
Old
127 - 07-27-2008, 00:38
Reply With Quote
Hey, I've got a minor bug. I'll post this in the bug thread too.

Firefox 3.0.1 (whatever the most recent official release is)
Vista
Triton Liquid

Alt+s works perfectly on quick reply. It doesn't work at all for edit post. For new thread and reply (on their own page), alt+s selects the submit button but doesn't engage it -- I still have to press space bar or enter to make the post.
 
Gil is offline
 
SuicideTaxi
VeteranXX
Contributor
Old
128 - 07-27-2008, 00:40
Reply With Quote
Let's play Post Your Ignore List now


 
SuicideTaxi is offline
 
Tahnit
VeteranXV
Old
129 - 07-27-2008, 00:41
Reply With Quote
Bwhahahahahaa. Now thats a ingenious way of banning absent. Shame its a temp ban.
 
Tahnit is offline
 
-raven-
VeteranX
Old
130 - 07-27-2008, 00:42
Reply With Quote
PS:

Code:
select IgnoredUserID, COUNT(*) AS IgnoreCount
from (SELECT UserID, 
	  NullIf(SubString(' ' + IgnoredUserIDs + ' ' , ID , CharIndex(' ' , ' ' + IgnoredUserIDs + ' ' , ID) - ID) , '') AS IgnoredUserID
	  FROM IgnoreTable, Tally
	  WHERE ID <= Len(' ' + IgnoredUserIDs + ' ') AND SubString(' ' + IgnoredUserIDs + ' ' , ID - 1, 1) = ' ') subq
group by IgnoredUserID
order by IgnoreCount desc
Like I said originally, single SQL query rather than writing a script
 
-raven- is offline
 
SuicideTaxi
VeteranXX
Contributor
Old
131 - 07-27-2008, 00:42
Reply With Quote
I tried using the "attachment" feature for that screenshot but I got:

Upload Errors
twignore.jpg:
Upload of file failed.
 
SuicideTaxi is offline
 
assfrags
VeteranX
Old
132 - 07-27-2008, 00:43
Reply With Quote
Hay guyz.
 
assfrags is offline
 
WeRe-|WoLf|-
VeteranXV
Contributor
Old
133 - 07-27-2008, 00:47
Reply With Quote
wth it's a temp ban? =(
 
WeRe-|WoLf|- is offline
 
Tahnit
VeteranXV
Old
134 - 07-27-2008, 00:48
Reply With Quote
Quote:
Originally Posted by WeRe-|WoLf|- View Post
wth it's a temp ban? =(
Well maybe he will calm his ass down when he gets back. If not well then im sure he can be banned again.
 
Tahnit is offline
 
SirBatesAlot
VeteranX
Old
135 - 07-27-2008, 00:50
Reply With Quote
I don't have anyone on ignore, so I guess I don't get to vote.
 
SirBatesAlot is offline
 
Rayn
Tribalwar Admin
Contributor
Old
136 - 07-27-2008, 00:58
Reply With Quote
Quote:
Originally Posted by -raven- View Post
PS:

Code:
select IgnoredUserID, COUNT(*) AS IgnoreCount
from (SELECT UserID, 
	  NullIf(SubString(' ' + IgnoredUserIDs + ' ' , ID , CharIndex(' ' , ' ' + IgnoredUserIDs + ' ' , ID) - ID) , '') AS IgnoredUserID
	  FROM IgnoreTable, Tally
	  WHERE ID <= Len(' ' + IgnoredUserIDs + ' ') AND SubString(' ' + IgnoredUserIDs + ' ' , ID - 1, 1) = ' ') subq
group by IgnoredUserID
order by IgnoreCount desc
Like I said originally, single SQL query rather than writing a script
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0278 sec)
SQL query:
SELECT IgnoredUserID, COUNT( * ) AS IgnoreCount
FROM (

SELECT UserID, NullIf( SubString( ' ' + ignorelist + ' ', userid, substring_index( ' ', ' ' + ignorelist + ' ', userid ) - userID ) , '' ) AS IgnoredUserID
FROM usertextfield Tally
WHERE userid <= Length( ' ' + ignorelist + ' ' )
AND SubString( ' ' + ignorelist + ' ', userid -1, 1 ) = ' '
)subq
GROUP BY IgnoredUserID
ORDER BY IgnoreCount DESC
 
Rayn is offline
 
prowler
VeteranX
Old
137 - 07-27-2008, 01:01
Reply With Quote
haha suicidetaxi is so pathetic
 
prowler is offline
 
-raven-
VeteranX
Old
138 - 07-27-2008, 01:02
Reply With Quote
Quote:
Originally Posted by Rayn View Post
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0278 sec)
SQL query:
SELECT IgnoredUserID, COUNT( * ) AS IgnoreCount
FROM (

SELECT UserID, NullIf( SubString( ' ' + ignorelist + ' ', userid, substring_index( ' ', ' ' + ignorelist + ' ', userid ) - userID ) , '' ) AS IgnoredUserID
FROM usertextfield Tally
WHERE userid <= Length( ' ' + ignorelist + ' ' )
AND SubString( ' ' + ignorelist + ' ', userid -1, 1 ) = ' '
)subq
GROUP BY IgnoredUserID
ORDER BY IgnoreCount DESC
Tally is a separate table in this case. It's just a table with a single identity column, and it's used to "iterate" through the list of ignored users on each row. So it's not an alias for the usertextfield table. You need a comma.

Instead of Tally, you could just use any table that has a column with a value starting at 1, increments by 1 for each row, has no missing numbers, and a sufficient number of rows (400), and not a ton of rows past that. Then put the ID **** I had in there back in and replace it with the column name.

A tally table is useful though for many other tricks.
 
-raven- is offline
 
Rayn
Tribalwar Admin
Contributor
Old
139 - 07-27-2008, 01:05
Reply With Quote
with the comma in there it just says 'unknown table, tally.'
this is mysql
 
Rayn is offline
 
Gil
VeteranXV
Old
140 - 07-27-2008, 01:07
Reply With Quote
Quote:
Originally Posted by Rayn View Post
with the comma in there it just says 'unknown table, tally.'
this is mysql
basically you take and make a new table called "tally"

Tally has 1 column, and the rows are just incrimental numbers from 1 to n

it's a quick and dirty way of doing a loop.
 
Gil is offline
 
Page 7 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 16:26.