I'm running a script to see who the most ignored user is ... by Rayn - Page 4 - 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 4 of 13
Thread Tools
LouCypher
VeteranX
Old
61 - 07-26-2008, 23:29
Reply With Quote
Quote:
Originally Posted by Rayn View Post
I could but I don't find it as interesting. Its probably Bad_CRC :P
I'm betting Kurayami or SuicideTaxi.
 
LouCypher is offline
 
Sponsored Links
prowler
VeteranX
Old
62 - 07-26-2008, 23:30
Reply With Quote
i miss tehvul
 
prowler is offline
 
-raven-
VeteranX
Old
63 - 07-26-2008, 23:31
Reply With Quote
Rayn why can't this be done with a SQL query

why a script?
 
-raven- is offline
 
Mr Jimmy Pop
VeteranXX
Contributor
Old
64 - 07-26-2008, 23:45
Reply With Quote
now we need super pro jew threads so he can read them and not be able to reply.


lol at tags below
 
Mr Jimmy Pop is offline
 
Travace
VeteranXV
Old
65 - 07-26-2008, 23:45
Reply With Quote
pretty sure i recognize every name on there but shieldpackman

who the **** is /was that ?
 
Travace is offline
 
Gil
VeteranXV
Old
66 - 07-26-2008, 23:47
Reply With Quote
Quote:
Originally Posted by -raven- View Post
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.
 
Gil is offline
 
-raven-
VeteranX
Old
67 - 07-26-2008, 23:51
Reply With Quote
Quote:
Originally Posted by Gil View Post
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
 
-raven- is offline
 
Last edited by -raven-; 07-26-2008 at 23:53..
Rayn
Tribalwar Admin
Contributor
Old
68 - 07-26-2008, 23:51
Reply With Quote
Quote:
Originally Posted by -raven- View Post
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.
 
Rayn is offline
 
SpicyMcHaggis
VeteranX
Old
69 - 07-26-2008, 23:52
Reply With Quote
Quote:
Originally Posted by LouCypher View Post
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 
 
SpicyMcHaggis is offline
 
LeafNinja
VeteranX
Old
70 - 07-26-2008, 23:52
Reply With Quote
Quote:
Originally Posted by prowler View Post
i miss tehvul
 
LeafNinja is offline
 
-raven-
VeteranX
Old
71 - 07-26-2008, 23:55
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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
 
-raven- is offline
 
nada
VeteranX
Old
72 - 07-26-2008, 23:56
Reply With Quote
i think this is a trick. we all ignore absent, but he doesn't ban him. everyone stops *****ing, nobody notices.
 
nada is offline
 
Rayn
Tribalwar Admin
Contributor
Old
73 - 07-27-2008, 00:01
Reply With Quote
Quote:
Originally Posted by -raven- View Post
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.
 
Rayn is offline
 
nada
VeteranX
Old
74 - 07-27-2008, 00:02
Reply With Quote
ps: i ignored him anyway
 
nada is offline
 
samUwell
VeteranXV
Contributor
Old
75 - 07-27-2008, 00:04
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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!
 
samUwell is offline
 
GreyGhost
VeteranXX
Old
76 - 07-27-2008, 00:04
Reply With Quote
 
GreyGhost is offline
 
Reverend Zero
VeteranXV
Contributor
Old
77 - 07-27-2008, 00:08
Reply With Quote
that ignore list is funny

why would you ignore 90% of the comedy on this forum

internet: serious ****ing business
 
Reverend Zero is offline
 
Stilgar
VeteranXV
Old
78 - 07-27-2008, 00:08
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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.
 
Stilgar is offline
 
KnightMare
VeteranX
Old
79 - 07-27-2008, 00:09
Reply With Quote
shieldpackman was a troll/smurf from tribes talk
 
KnightMare is offline
 
-raven-
VeteranX
Old
80 - 07-27-2008, 00:09
Reply With Quote
Quote:
Originally Posted by Rayn View Post
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
 
-raven- is offline
 
Page 4 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: CCBot/2.0 (https://commoncrawl.org/faq/) / Y
All times are GMT -4. The time now is 02:42.