Tribalwar Admin Contributor
|
there I fixed the old skin for the new options.
|
|
|
Tribalwar Admin Contributor
|
see this is the kind of **** I need to know.
|
|
|
VeteranXV
|
Quote:
Originally Posted by SuicideTaxi
[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.
|
|
|
Tribalwar Admin Contributor
|
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 **** .......
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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
|
|
|
VeteranXV
|
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.
|
|
|
VeteranXX Contributor
|
Let's play Post Your Ignore List now
|
|
|
VeteranXV
|
Bwhahahahahaa. Now thats a ingenious way of banning absent. Shame its a temp ban.
|
|
|
VeteranX
|
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
|
|
|
VeteranXX Contributor
|
I tried using the "attachment" feature for that screenshot but I got:
Upload Errors
twignore.jpg:
Upload of file failed.
|
|
|
VeteranXV Contributor
|
wth it's a temp ban? =(
|
|
|
VeteranXV
|
Quote:
Originally Posted by WeRe-|WoLf|-
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.
|
|
|
VeteranX
|
I don't have anyone on ignore, so I guess I don't get to vote.
|
|
|
Tribalwar Admin Contributor
|
Quote:
Originally Posted by -raven-
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
|
|
|
VeteranX
|
haha suicidetaxi is so pathetic
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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.
|
|
|
Tribalwar Admin Contributor
|
with the comma in there it just says 'unknown table, tally.'
this is mysql
|
|
|
VeteranXV
|
Quote:
Originally Posted by Rayn
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.
|
|
|
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 04:54.
|