I'm running a script to see who the most ignored user is ...
- Thread starter Rayn
- Start date
that's what mine looks like but if you go into "edit options" there's an "edit ignore list" in there.
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
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.
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.
Let's play Post Your Ignore List now
PS:
Like I said originally, single SQL query rather than writing a script
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 descLike I said originally, single SQL query rather than writing a script
I tried using the "attachment" feature for that screenshot but I got:
Upload Errors
twignore.jpg:
Upload of file failed.
Upload Errors
twignore.jpg:
Upload of file failed.
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.
SirBatesAlot
Veteran X
I don't have anyone on ignore, so I guess I don't get to vote. 
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 shit I had in there back in and replace it with the column name.
A tally table is useful though for many other tricks.
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.