Quote :

"more will fade into bolivian. "

or at least take a vacation to Paraguay.

7/30/2009 11:15:23 AM

[Edited on July 30, 2009 at 11:19 AM. Reason : DAMNATION SCOOPED]

7/30/2009 11:19:31 AM

so, since we've hit 1000 pages of threads in chit chat...

get us a list of the users who have the highest percentages of those threads w/ at least 1 post in them

does that make sense?

7/30/2009 9:16:47 PM

top 100 chit chat thread creators

evan 1378
jackleg 782
Str8BacardiL 701
drunknloaded 698
EMCE 683
BigMan157 649
ambrosia1231 624
ReceiveDeath 597
NC86 552
XSMP 548
baonest 479
cddweller 459
Walls1441 450
dweedle 438
Amsterdam718 417
JCASHFAN 404
aaronburro 403
parsonsb 396
ThePeter 389
TreeTwista10 388
terpball 357
gunzz 357
BubbleBobble 354
seedless 349
Walter 348
bbehe 345
BigEgo 332
Kiwi 331
IMStoned420 327
wolfpackgrrr 326
sumfoo1 319
qntmfred 315
Spontaneous 311
Jaybee1200 307
chembob 306
Lionheart 301
Big Business 295
amac884 294
Snewf 289
BigHitSunday 288
GroundBeef 278
blasphemour 275
lafta 274
God 264
FykalJpn 260
nastoute 260
wdprice3 259
joe17669 258
GraniteBalls 249
arcgreek 248
mytwocents 238
Ragged 229
DiamondAce 227
punchmonk 226
Mr Scrumples 219
BadPokerPlyr 217
JayMCnasty 214
Slave Famous 214
TenaciousC 209
Jen 204
Oeuvre 202
saps852 200
quagmire02 198
Mr. Joshua 196
ZomBCraw 189
Yoshiemaster 186
parentcanpay 178
ncsuapex 177
Fermat 176
vinylbandit 174
sawahash 166
BEU 163
paerabol 163
WillemJoel 160
Apocalypse 155
Airbag 154
0EPII1 151
datman 151
ncstatetke 151
LimpyNuts 151
tsavla 144
slingblade 143
fleetwud 143
AndyMac 141
pwrstrkdf250 141
69 138
GoldenGirl 138
djeternal 138
thegoodlife3 137
wwwebsurfer 137
Tiberius 136
Aficionado 135
colter 135
Novicane 132
Mr Grace 131
lmnop 131
catalyst 131
joe_schmoe 130
damosyangsta 129
Joie 127

[Edited on July 30, 2009 at 9:57 PM. Reason : i don't get the at least 1 post part. i'll take a look at it though]

[Edited on July 30, 2009 at 10:00 PM. Reason : nobody had enough ntlb threads to make any significant changes in the stats]

7/30/2009 9:55:58 PM

<-- pullin up the rear at #98

woot woot

7/31/2009 1:18:54 AM

[Edited on July 31, 2009 at 2:59 AM. Reason : df]

7/31/2009 2:59:37 AM

ATTN: qntmfred

Tiberius: can you ask for the post density data to be graphed, as a line chart of each percentile group over time, cumulatively from either: 1) the beginning of the data set, and the latest date which would border an interval in which no threads were affected by a purge; for comparison, if post densities could be affected by the purging algorithm 2) from beginning to end, if purged data is still available for analysis

7/31/2009 3:00:29 AM

yay I ranked... but how??

7/31/2009 3:02:01 AM

^^ not following...you might have to draw me a picture, as they say

[Edited on July 31, 2009 at 1:14 PM. Reason : V i thought y'all weren't friends anymore? i guess that's cool y'all are or whatever]

7/31/2009 1:10:26 PM

I didn't really either, that's why I copy/pasted

I don't think he's on right now

7/31/2009 1:12:05 PM

what i'm asking you to find is who has posted in the most number of unique threads in chit chat

i think that's clearer...

7/31/2009 1:13:04 PM

oic. lemme see what i can do

7/31/2009 1:15:55 PM

we've got like 50,000 threads now, right?

7/31/2009 1:16:47 PM

in chit chat? almost (see topic count on message.aspx)

7/31/2009 1:18:57 PM

oh, word

7/31/2009 1:19:38 PM

u gonna switch me to miley qntmfred? LOL!!!

7/31/2009 1:35:44 PM

Tiberius: can you ask for the post density data to be graphed, as a line chart of each percentile group over time, cumulatively from either: 1) the beginning of the data set, and the latest date which would border an interval in which no threads were affected by a purge; for comparison, if post densities could be affected by the purging algorithm 2) from beginning to end, if purged data is still available for analysis


What is being asked here is for a series percentile groups of users responsible for number of posts (e.g. 10/25/50/66/75/90/100 % of posts are attributed to x number of posters) and he wants the date range for that to be either from immediately following the purge (or some other further available date) or from the inception of the site if those statistics are still available regardless of threads missing from the purge.

7/31/2009 1:52:49 PM

^i think he wants that data as it changed over time

ie in 2005 10% of posts came from X% of users.......and in 2009 10% of posts come from X% of users.....etc.

7/31/2009 1:55:53 PM

you're right. i forgot to add that part in there.

7/31/2009 1:58:05 PM

bttt

8/1/2009 5:57:31 PM

Any way to make these queries a webpage or something so they can be pulled on-demand?

8/1/2009 6:05:42 PM

that'd be nice, but a lot of these queries take a while. the db isn't necessarily tailored for these kinds of queries. might be able to do like daily updates or something

of course, this is all contingent on whether or not the new owners let me do some real upgrades at some point

8/1/2009 11:28:40 PM

Quote :

"what i'm asking you to find is who has posted in the most number of unique threads in chit chat"

you think you can do this one?

8/1/2009 11:29:56 PM

I say remake the site in PHP and unleash it's true power.

8/1/2009 11:30:35 PM

when i looked at it the other day, it became more complicated than my 60 second attention span will support

i'll give it another shot tomorrow

8/1/2009 11:31:10 PM

haha

8/1/2009 11:31:45 PM

I'd like to know who quotes the most

8/2/2009 1:30:15 AM

Quote :

"that'd be nice, but a lot of these queries take a while. the db isn't necessarily tailored for these kinds of queries. might be able to do like daily updates or something"

cron jobs/scheduled tasks + make the static pages available?



I could see rewriting all this in PHP being a bitch. A REAL bitch.

[Edited on August 2, 2009 at 12:53 PM. Reason : !]

8/2/2009 12:52:30 PM

8/2/2009 5:04:07 PM

i didn't realize I made that many threads

8/2/2009 5:43:35 PM

Quote :

"I'd like to know who quotes the most "

0EPI1 /trapezius

8/2/2009 5:53:15 PM

I'll be damned, I'm 16th on the Chit Chat creation list.

8/3/2009 8:36:44 AM

Quote :

"who has posted in the most number of unique threads in chit chat"

ok, in all of chitchatdom (archives and all) here are the top 250 unique thread participants

1. jackleg 48390
2. BigMan157 35941
3. drunknloaded 35599
4. Snewf 23471
5. EMCE 20630
6. gunzz 20386
7. ambrosia1231 20373
8. fleetwud 19942
9. esgargs 19384
10. marko 19122
11. pilgrimshoes 18934
12. Smath74 18757
13. ShawnaC123 17662
14. saps852 16909
15. Fermat 16879
16. dweedle 16355
17. H8R 16113
18. pwrstrkdf250 15995
19. Woodfoot 15974
20. Nerdchick 15944
21. chickenhead 15654
22. TreeTwista10 14651
23. blasphemour 13662
24. Mr Scrumples 13645
25. ReceiveDeath 13509
26. AxlBonBach 13468
27. Ronny 13256
28. Arab13 12623
29. sober46an3 12401
30. skankinande 12165
31. baonest 12030
32. djeternal 11806
33. J_Hova 11800
34. TrjnMan007 11329
35. NCSUGimp 11001
36. FroshKiller 10935
37. harbdog 10498
38. kiljadn 10381
39. BigHitSunday 10324
40. chembob 10183
41. 30thAnnZ 10163
42. joe17669 9885
43. Str8BacardiL 9754
44. nastoute 9616
45. karencb82 9586
46. poopface 9511
47. nothing22 9495
48. vinylbandit 9376
49. MrUniverse 9341
50. sumfoo1 9335
51. Jaybee1200 9322
52. Aficionado 9151
53. dakota_man 8968
54. elkaybie 8901
55. JonHGuth 8884
56. arcgreek 8866
57. iphotou 8816
58. quagmire02 8769
59. Weeeees 8766
60. PrufrockNCSU 8748
61. Wraith 8726
62. glassssssss 8718
63. miska 8530
64. DZAndrea 8505
65. ThePeter 8480
66. MetalRed 8283
67. roddy 8266
68. kbbrown3 8206
69. BunkerBuster 8155
70. nutsmackr 8138
71. qntmfred 8099
72. Kiwi 8080
73. humandrive 8039
74. Mr. Joshua 7955
75. grimx 7943
76. Lewizzle 7934
77. eahanhan 7927
78. DivaBaby19 7876
79. evan 7863
80. terpball 7853
81. Grapehead 7794
82. ssjamind 7685
83. Biofreak70 7660
84. fin 7660
85. packguy381 7637
86. ShinAntonio 7548
87. NCSUStinger 7527
88. cddweller 7496
89. cyrion 7473
90. BobbyDigital 7333
91. Ernie 7294
92. Kev4Pack 7247
93. theDuke866 7224
94. ZiP 7196
95. sk8k8lover 7174
96. wolfpackgrrr 7135
97. OmarBadu 7121
98. Kitty B 7063
99. chocolatervh 7013
100. rjrgrl 7007
101. wdprice3 6997
102. EnderJRD 6869
103. AlexRebbel 6857
104. Skack 6852
105. rjrumfel 6798
106. 9one9 6783
107. BoobsR_gr8 6781
108. bassman803 6737
109. ncsuapex 6694
110. raven928 6641
111. keefus 6622
112. eleusis 6610
113. spookyjon 6521
114. waffleninja 6440
115. LivinProof78 6428
116. Lutra 6423
117. aaronburro 6421
118. bethaleigh 6386
119. simonn 6371
120. tartsquid 6320
121. quietly 6282
122. Crawdaddy65 6274
123. pryderi 6203
124. AndyMac 6179
125. DJ Lauren 6091
126. skewfield 6069
127. JohnnyTHM 6068
128. Mindstorm 6010
129. ncstatetke 5998
130. DeeDee21 5978
131. fjjackso 5963
132. FykalJpn 5952
133. Syrinx 5933
134. Pi Master 5928
135. firmbuttgntl 5924
136. Amsterdam718 5918
137. Kris 5854
138. mawle427 5832
139. 0EPII1 5798
140. Shadowrunner 5750
141. apkaufma 5742
142. amac884 5720
143. wilso 5704
144. IsntTiberius 5666
145. mytwocents 5633
146. parsonsb 5610
147. ScHpEnXeL 5595
148. SymeGuy69 5593
149. CassTheSass 5546
150. BridgetSPK 5513
151. LiusClues 5498
152. NyM410 5495
153. YanTheManV 5463
154. LimpyNuts 5395
155. seedless 5388
156. zxappeal 5360
157. punchmonk 5339
158. El Borracho 5304
159. UJustWait84 5289
160. TKE-Teg 5240
161. Jeepin4x4 5221
162. Fhqwhgads 5167
163. StillFuchsia 5144
164. JayMCnasty 5129
165. dustm 5114
166. superchevy 5097
167. SaabTurbo 5087
168. twoozles 5068
169. DROD900 5063
170. Seotaji 5046
171. Wadhead1 5015
172. Sugarush4u 5007
173. CodeRed4791 4962
174. Sonia 4936
175. Byrn Stuff 4835
176. Stimwalt 4800
177. DamnStraight 4740
178. Queti 4729
179. SoggyBiscuit 4723
180. DiamondAce 4719
181. mrredemption 4696
182. God 4682
183. Restricted 4680
184. Apocalypse 4667
185. Novicane 4631
186. Førte 4600
187. pttyndal 4577
188. TroopofEchos 4574
189. sawahash 4571
190. Cansnuts 4480
191. Spontaneous 4479
192. NeuseRvrRat 4459
193. optmusprimer 4458
194. zorthage 4452
195. playababy 4409
196. bottombaby 4363
197. One 4339
198. SpeedLimit 4325
199. jnpaul 4298
200. XSMP 4258
201. jlancas03 4250
202. Slave Famous 4211
203. TragicNature 4209
204. ALkatraz 4200
205. jprince11 4199
206. Beardawg61 4163
207. PvtJoker 4098
208. tchenku 4061
209. State409c 4050
210. paerabol 4049
211. timswar 4027
212. udorawala 4026
213. Mr Grace 3985
214. GraniteBalls 3970
215. SandSanta 3968
216. hunterb2003 3935
217. jaydee 3929
218. Dem0nm0nky 3924
219. Dammit100 3908
220. Locutus Zero 3903
221. JP 3888
222. seapunky 3859
223. McDanger 3842
224. Bakunin 3827
225. puppy 3816
226. Minkagrl01 3756
227. legatic 3749
228. Walls1441 3732
229. Joie 3702
230. NCJockGirl 3689
231. blackeyepee 3675
232. spöokyjon 3652
233. Republican18 3634
234. jtdenny 3631
235. Kurtis636 3625
236. Josh8315 3622
237. JeffreyBSG 3613
238. alibaby 3559
239. billytalent 3551
240. ThisIsntTJ 3550
241. puck_it 3513
242. E-Dawg 3504
243. Nuoq 3502
244. rwoody 3488
245. crazywill722 3475
246. Ragged 3443
247. BigEgo 3404
248. omganafrican 3394
249. iceplaya 3368
250. yuri82 3363


[Edited on August 4, 2009 at 2:56 PM. Reason : add ranking#]

8/4/2009 2:54:23 PM

thanks ken!

8/4/2009 3:03:19 PM

hell yeah mofo top 250 in chit chat history!!

8/5/2009 9:13:15 AM

woo #75

8/5/2009 9:15:56 AM

always the bridesmaid, never the bride

8/5/2009 9:33:34 AM

oh come on, it's only another twelve thousand, four hundred and forty-nine more threads to post in!

8/5/2009 9:35:17 AM

I need to step up my posting game

8/5/2009 10:03:15 AM

in the last 12 months we've had 1950 new registered users.
875 didn't bother to activate the account
another 664 activated, but haven't posted
of the 411 left, only 148 have more than 10 posts

DO BETTER PEOPLE.

8/19/2009 11:12:39 PM

Is there any way you can calculate how many times that bigsementampon guy has told the story about how he accidentally left the d off his name when he registered?

I mean, I doubt computers have the ability to count that high, but I just thought I'd ask.

8/19/2009 11:14:53 PM

why don't you just search how many times he's posted "d" idk if theres a string minimum.

oh thats right you wanted to be a little bitch about something.

I'm AstralAdvent and i approved this message.

8/19/2009 11:15:58 PM

speaking of things you can't count high enough for

Quote :

"oh thats right you wanted to be a little bitch about something."

8/19/2009 11:16:56 PM

MOST POSTS IN SPORTS TALK HISTORY

8/19/2009 11:17:03 PM

Quote :

"Is there any way you can calculate how many times that bigsementampon guy has told the story about how he accidentally left the d off his name when he registered?"

Does it bother you?

I'm still curious. Just how many times have I said that?

8/19/2009 11:24:57 PM

It doesn't really bother me. I was mainly joking around. It does seem like you've told that story quite a lot.

8/19/2009 11:25:55 PM

I've told the story quite a few times...

Quote :

"I mean, I doubt computers have the ability to count that high"

Even if the 'd' was there, I don't think it would stop things like bigsementampon to stop getting posted. Not that I want it to, it cracks me up.

8/19/2009 11:29:45 PM

That really does have to be the best bastardization of a username in TWW history.

8/19/2009 11:34:02 PM

haha better than receivedicks?

I'm AstralAdvent and i approved this message.

8/20/2009 1:38:39 AM

Quote :

"DO BETTER PEOPLE."

8/20/2009 9:38:04 AM