The W
Views: 99147033
Main | FAQ | Search: Y! / G | Color chart | Log in for more!
22.9.07 2131
The 7 - the-w.com Site Feedback - Is this possible? Register and log in to post!
Pages: 1 2 Next(394 newer) Next thread | Previous thread
User
Post (26 total)
JayJayDean
Scrapple
Level: 125

Posts: 1241/4719
EXP: 22097251
For next: 356976

Since: 2.1.02
From: Seattle, WA

Since last post: 19 days
Last activity: 22 hours
AIM:  
Y!:
#1 Posted on 18.5.04 0923.05
Reposted on: 18.5.11 0925.04
I was thinking, can you make it so you can view the number of posts by forum by a W? Grimis made me think of this, because I imagine his looking like this:

Grimis:
Total posts: 3100
Wrestling: 3
Random: 105
Football: 87
Basketball: 21
Politics: 2884


Promote this thread!
Grimis
Scrapple
Level: 124

Posts: 3194/4700
EXP: 21510244
For next: 326418

Since: 11.7.02
From: MD

Since last post: 1239 days
Last activity: 1036 days
#2 Posted on 18.5.04 0927.53
Reposted on: 18.5.11 0928.04
LOL. You missed a lot of baseball there.

Incidentally, I do think it would be an interesting idea, becuase I'm sure I will not be the only one heavy in any one particular area.
ThreepMe
Morcilla
Level: 53

Posts: 586/641
EXP: 1100954
For next: 56172

Since: 15.2.02
From: Dallas

Since last post: 3671 days
Last activity: 3329 days
#3 Posted on 18.5.04 1030.29
Reposted on: 18.5.11 1030.32
    Originally posted by Grimis
    LOL. You missed a lot of baseball there.

    Incidentally, I do think it would be an interesting idea, becuase I'm sure I will not be the only one heavy in any one particular area.



Guilty here....
Guru Zim
SQL Dejection
Administrator
Level: 139

Posts: 2397/6009
EXP: 31832383
For next: 635144

Since: 9.12.01
From: Bay City, OR

Since last post: 10 days
Last activity: 20 hours
AIM:  
#4 Posted on 18.5.04 1341.52
Reposted on: 18.5.11 1341.55
We can run the numbers, but I'm not sure that I want to track this stat in a manner that would make it easy and quick to report.

For instance, I could create a table that contained each userid and a column for each forum, and then add and subtract from the totals as you post to different forums. This would slow the posting a little, but would have the least impact when generating the page with the stat. Storage-wise it wouldn't be awful. I'd just have to put a routine in for the add/delete stuff to change the counts.

Unfortunately, since MySQL doesn't support triggers, I can't do this the "right" way. That means that anything that was deleted in the database (and hence skipped any routines in the PHP) would get jacked up.

Because of that last part, I probably won't do this.
Zeruel
Thirty Millionth Hit
Moderator
Level: 130

Posts: 2116/5207
EXP: 25611351
For next: 119295

Since: 2.1.02
From: The Silver Spring in the Land of Mary.

Since last post: 9 days
Last activity: 4 hours
#5 Posted on 18.5.04 1425.56
Reposted on: 18.5.11 1426.35
Why not just run the report on the fly?

Select * from database where u_id = 99 and forum = 4

That would give you a number of posts from user #99, me, that are in forum #4, this one.

Do that for all the forums, and you've got it, unless that would be a big drag on the server...or your tables are nothing like I think they are (which wouldn't be far off).

(edited by Zeruel on 18.5.04 1526)
CRZ
Big Brother
Administrator
Level: 213

Posts: 4675/16224
EXP: 141221658
For next: 2145249

Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 13 hours
AIM:  
ICQ:  
Y!:
#6 Posted on 18.5.04 1539.50
Reposted on: 18.5.11 1541.15
    Originally posted by Guru Zim
    We can run the numbers, but I'm not sure that I want to track this stat in a manner that would make it easy and quick to report.
It's totally easy to do ('cause I just did it) but whether or not it's something we want to share with you is something we'll have to discuss amongst ourselves.
emma
Cherries > Peaches
Level: 87

Posts: 1010/2086
EXP: 6344916
For next: 47883

Since: 1.8.02
From: Phoenix-ish

Since last post: 5 days
Last activity: 2 hours
#7 Posted on 18.5.04 1620.37
Reposted on: 18.5.11 1621.07
The end-user application that occurs to me (besides idle curiosity) is in conjunction with giving ratings. In JayJayDean's example, say the hypothetical Grimis said something appallingly lame in the wrestling folder. (Just hypothetically, of course.) I'd use the feature to notice that the alleged Grimis is a huge participant in a forum that I never read, so would probably just skip bashing him with a vicious rating. I figure the people where he hangs out a lot will provide better ratings input.
Guru Zim
SQL Dejection
Administrator
Level: 139

Posts: 2398/6009
EXP: 31832383
For next: 635144

Since: 9.12.01
From: Bay City, OR

Since last post: 10 days
Last activity: 20 hours
AIM:  
#8 Posted on 18.5.04 1701.56
Reposted on: 18.5.11 1702.56
I keep thinking that this is an Enterprise level application.

We can do a simple group by with no problem, and it's probably fast enough.

I guess I'm a little TOO conservative with my estimates.
CRZ
Big Brother
Administrator
Level: 213

Posts: 4683/16224
EXP: 141221658
For next: 2145249

Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 13 hours
AIM:  
ICQ:  
Y!:
#9 Posted on 19.5.04 0445.40
Reposted on: 19.5.11 0446.37
Okay so I wrote some code and he wrote some code and I wrote some code and there's another link available on the profile pages now. HOORAY
pieman
As young as
he feels
Level: 111

Posts: 1447/3571
EXP: 14580117
For next: 288289

Since: 11.12.01
From: China, Maine

Since last post: 7 hours
Last activity: 7 hours
AIM:  
ICQ:  
Y!:
#10 Posted on 19.5.04 0454.30
Reposted on: 19.5.11 0456.41
It's very slick. The screen gives a nice visual effect. I actually have one post in Video Games. I don't remember ever doing that. Also found it interesting that this started out as a wrestling message board and I have less than 9% of my posts in the wrestling folder.
Torchslasher
Knackwurst
Level: 107

Posts: 1325/3267
EXP: 12708017
For next: 383336

Since: 17.1.02
From: New F'n Jersey

Since last post: 3 days
Last activity: 4 hours
#11 Posted on 19.5.04 0617.42
Reposted on: 19.5.11 0617.58
I must also say a hearty nice job to the Z's for this. I knew that the Wrestling folder would dominate my time (54%), but I also knew that the number was much higher before the botched Invasion of 01. I gotta think that the number will continue to go down and Random will keep hiking up.

Oh, and I'm also glad that I just have 3 posts in the Banished folder. I was wondering what that number would be.
JayJayDean
Scrapple
Level: 125

Posts: 1250/4719
EXP: 22097251
For next: 356976

Since: 2.1.02
From: Seattle, WA

Since last post: 19 days
Last activity: 22 hours
AIM:  
Y!:
#12 Posted on 19.5.04 1009.48
Reposted on: 19.5.11 1012.11
    Originally posted by CRZ
    Okay so I wrote some code and he wrote some code and I wrote some code and there's another link available on the profile pages now. HOORAY


THAT IS SO COOL.

Btw, here's Grimis' list. I was pretty close.

Politics: 1847
Random: 318
Football: 285
Baseball: 248
Wrestling: 171
Basketball: 108
KZim: 71
Test: 49
CRZ's World: 26
Hockey: 26
Video Games: 25
Site Bashing: 9
Site Feedback: 8
Guest Columns: 1
Banished: 1

:)
Net Hack Slasher
Banger
Level: 100

Posts: 2219/2805
EXP: 10121841
For next: 232591

Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3559 days
Last activity: 1979 days
#13 Posted on 19.5.04 1009.58
Reposted on: 19.5.11 1013.11
    Originally posted by JayJayDean
    I was thinking, can you make it so you can view the number of posts by forum by a W? Grimis made me think of this, because I imagine his looking like this:

    Grimis:
    Total posts: 3100
    Wrestling: 3
    Random: 105
    Football: 87
    Basketball: 21
    Politics: 2884





And I'm guessing those 3 wrestling posts has something to do with the Steiner/Nowinski debate where Grimis might say the words that should never be spoken "You know what, Scott Steiner does make some sense"

No surprise wrestling dominates mine. I don't have a single post in Banished, see kids I'm a role model for not feeding the trolls Or maybe CRZ has such respect for my posts that I save a bunch of threads that were destined to Banished (yeah I didn't think so either LoL)... My video game section is slight.y higher then Piemen with an impressive six.

Grimis
Scrapple
Level: 124

Posts: 3206/4700
EXP: 21510244
For next: 326418

Since: 11.7.02
From: MD

Since last post: 1239 days
Last activity: 1036 days
#14 Posted on 19.5.04 1044.30
Reposted on: 19.5.11 1046.19
    Originally posted by Net Hack Slasher
    And I'm guessing those 3 wrestling posts has something to do with the Steiner/Nowinski debate where Grimis might say the words that should never be spoken "You know what, Scott Steiner does make some sense"


Hey now..

Incidentally, mine does read:

Politics 1847 (57.63%)
Random 318 (9.92%)
Football 285 (8.89%)
Baseball 249 (7.77%)
Wrestling 171 (5.34%)
Basketball 108 (3.37%)
From the KZiM Tower 71 (2.22%)
Test Forum 49 (1.53%)
CRZ's World 26 (0.81%)
Hockey 26 (0.81%)
Video Games 25 (0.78%)
Site Bashing 9 (0.28%)
Site Feedback 8 (0.25%)
Guest Columns 1 (0.03%)
Banished 1 (0.03%)
The Great Thomas
Sujuk
Level: 64

Posts: 922/1007
EXP: 2138840
For next: 75269

Since: 17.6.02
From: Miami, Florida

Since last post: 3345 days
Last activity: 3345 days
#15 Posted on 19.5.04 1054.13
Reposted on: 19.5.11 1054.20
This one's mine. And take a look at THIS:

Wrestling: 588
Test Forum: 72
Random: 68
Video Games: 53
Guest Columns: 29
Site Feedback: 28
Site Bashing: 28
Politics: 15
CRZ's World: 9
Banished: 6
Recap Feedback: 5
Baseball: 3
From the KZiM Tower: 3
Basketball: 2
Football: 1


Now isn't this something. Aside from the Wrestling forum, I've posted in Test Forum more than any other! And when did I post in FOOTBALL?!
Whitebacon
Boudin blanc
Level: 94

Posts: 1202/2468
EXP: 8348292
For next: 8396

Since: 12.1.02
From: Fresno, CA

Since last post: 37 days
Last activity: 8 hours
AIM:  
ICQ:  
#16 Posted on 19.5.04 1352.03
Reposted on: 19.5.11 1352.07
I'm not surprised to see that by an overwhelming margin, I've posted in the Baseball forum more than any other. What I am surprised to see is that I've posted in the Wrestling forum the second-most amount of times, barely.
CRZ
Big Brother
Administrator
Level: 213

Posts: 4684/16224
EXP: 141221658
For next: 2145249

Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 13 hours
AIM:  
ICQ:  
Y!:
#17 Posted on 19.5.04 1408.11
Reposted on: 19.5.11 1408.43
Guys, if people REALLY want to see your LIST!, they'll click on your profile. Don't post it here or I'll take your new page away.
The King of Keith
Lap cheong
Level: 77

Posts: 874/1572
EXP: 4106063
For next: 85085

Since: 4.11.02
From: Winchester, VA

Since last post: 283 days
Last activity: 242 days
AIM:  
#18 Posted on 19.5.04 1412.22
Reposted on: 19.5.11 1412.44
Would it be possible to add a feature to be able to view your posts in each forum? Looking at my list, I was wondering whatever possessed me to post in the politics...
CRZ
Big Brother
Administrator
Level: 213

Posts: 4685/16224
EXP: 141221658
For next: 2145249

Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 13 hours
AIM:  
ICQ:  
Y!:
#19 Posted on 19.5.04 1416.59
Reposted on: 19.5.11 1417.31
    Originally posted by VanillaSky
    Would it be possible to add a feature to be able to view your posts in each forum? Looking at my list, I was wondering whatever possessed me to post in the politics...
Possible, yes. Will we do it? Probably not, but maybe later I'll retool the old "postsbyuser" page to include forums and make it sortable.

EDIT: Okay, I did. I also optimized it so it should take right around .1s to generate the page now. :)

(edited by CRZ on 19.5.04 1241)
ekedolphin
Scrapple
Level: 132

Posts: 1976/5387
EXP: 26923317
For next: 208687

Since: 12.1.02
From: Indianapolis, IN; now residing in Suffolk, VA

Since last post: 96 days
Last activity: 6 days
#20 Posted on 20.5.04 0828.01
Reposted on: 20.5.11 0829.01
SLICK!

Here's how I turned out, in case anyone particularly cares:

ekedolphin Total Posts: 1975

Wrestling-- 1290 (65.32%)
Basketball-- 235 (11.90%)
Random-- 197 (9.97%)
Video Games-- 101 (5.11%)
Politics-- 24 (1.22%)
Football-- 21 (1.06%)
Test Forum-- 21 (1.06%)
CRZ's World-- 19 (0.96%)
Baseball-- 13 (0.66%)
Recap Feedback-- 10 (0.51%)
From the KZiM Tower-- 8 (0.41%)
Site Feedback-- 8 (0.41%)
Guest Columns-- 6 (0.30%)
Site Bashing-- 5 (0.25%)
Hockey-- 2 (0.10%)
Banished-- 2 (0.10%)

It worked out kinda the way I expected, really. I was surprised by the number of times I've posted in CRZ's World, though. You'd also expect me to comment on other people's Guest Columns, too, but to be honest I very rarely visit that area.
Pages: 1 2 NextThread ahead: What happened
Next thread: old forums
Previous thread: The "W" icon
(394 newer) Next thread | Previous thread
The 7 - the-w.com Site Feedback - Is this possible?Register and log in to post!

The W™ message board - 7 year recycle

ZimBoard
©2001-2014 Brothers Zim
This old hunk of junk rendered your page in 0.217 seconds.