VeteranX
|
Quote:
Originally Posted by Rayn
I could but I don't find it as interesting. Its probably Bad_CRC :P
|
I'm betting Kurayami or SuicideTaxi.
|
|
|
VeteranX
|
Rayn why can't this be done with a SQL query
why a script?
|
|
|
VeteranXX Contributor
|
now we need super pro jew threads so he can read them and not be able to reply.
lol at tags below
|
|
|
VeteranXV
|
pretty sure i recognize every name on there but shieldpackman
who the **** is /was that ?
|
|
|
VeteranXV
|
Quote:
Originally Posted by -raven-
Rayn why can't this be done with a SQL query
why a script?
|
maybe their db isn't designed in such a way that it can easily be done
or maybe he's better at/likes writing scripts more.
or maybe both.
|
|
|
VeteranX
|
Quote:
Originally Posted by Gil
maybe their db isn't designed in such a way that it can easily be done
or maybe he's better at/likes writing scripts more.
or maybe both.
|
1. Only if you are retarded and know nothing beyond the absolute basics of SQL syntax. Somewhere there is a table linking user IDs to ignored user IDs. And there's another table linking user ID's to usernames. So the query involves a single join (ohnoez), a count(foo) as blah, and a group by, and of course an order by blah desc
2. Query could be written in a fraction of the time and it would execute much, much faster and result in less of a hit on the DB
|
|
Last edited by -raven-; 07-26-2008 at 23:53..
|
Tribalwar Admin Contributor
|
Quote:
Originally Posted by -raven-
Rayn why can't this be done with a SQL query
why a script?
|
because ignore lists are stored in text fields that require parsing.
|
|
|
VeteranX
|
Quote:
Originally Posted by LouCypher
You should run a script to find who is ignoring the most people.
|
i've ignored everyone except myself because i only enjoy reading my own posts over and over and over
i'm doing it right now
|
|
|
VeteranX
|
Quote:
Originally Posted by prowler
i miss tehvul
|
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
because ignore lists are stored in text fields that require parsing.
|
I wonder what the logic was behind that decision
so it's something like a user ID column, and then a comma separated or XML ignored user IDs column, with a single row for every user?
If it was XML several dbms's allow you to create views that parse the XML column in various ways, so you could just make a column in the view that contains number of ignored users
|
|
|
VeteranX
|
i think this is a trick. we all ignore absent, but he doesn't ban him. everyone stops *****ing, nobody notices.
|
|
|
Tribalwar Admin Contributor
|
Quote:
Originally Posted by -raven-
I wonder what the logic was behind that decision
so it's something like a user ID column, and then a comma separated or XML ignored user IDs column, with a single row for every user?
If it was XML several dbms's allow you to create views that parse the XML column in various ways, so you could just make a column in the view that contains number of ignored users
|
i have no idea what you are talking about
every user has an 'ignorelist' column with a bunch of userids seperated by spaces. I have to pull that field and tally each entry via a script then output it.
|
|
|
VeteranX
|
ps: i ignored him anyway
|
|
|
VeteranXX Contributor
|
Quote:
Originally Posted by Rayn
1 absent 7292
2 script.kiddie 21515
3 orbital 123 17806
4 FngrBANG 7701
5 Kurayami 5009
6 BadMoFo 5305
7 mouse 32892
8 shieldpackman 34382
9 Xcursion 20482
10 naptown 21859
11 assfrags 27442
|
thats straight pathetic.
especially coming from this forum.... one of the last places on the net where one can say what they want.
amazing!
|
|
|
VeteranXX Contributor
|
that ignore list is funny
why would you ignore 90% of the comedy on this forum
internet: serious ****ing business
|
|
|
VeteranXX
|
Quote:
Originally Posted by Rayn
1 absent 7292
2 script.kiddie 21515
3 orbital 123 17806
4 FngrBANG 7701
5 Kurayami 5009
6 BadMoFo 5305
7 mouse 32892
8 shieldpackman 34382
9 Xcursion 20482
10 naptown 21859
11 assfrags 27442
|
I feel like I am viewing a wanted poster in the Post Office.
|
|
|
VeteranX
|
shieldpackman was a troll/smurf from tribes talk
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
i have no idea what you are talking about
every user has an 'ignorelist' column with a bunch of userids seperated by spaces. I have to pull that field and tally each entry via a script then output it.
|
SELECT TOP 10 UserID, (LEN(IgnoreList) - LEN(REPLACE(IgnoreList, ' ', '')) + 1) AS IgnoreCount
FROM IgnoreTable
ORDER BY IgnoreCount DESC
ta-da
|
|
|
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 11:57.
|