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

Posts: 1241/4750
EXP: 24025550
For next: 356216

Since: 2.1.02
From: Seattle, WA

Since last post: 250 days
Last activity: 16 days
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: 127

Posts: 3194/4700
EXP: 23226415
For next: 500216

Since: 11.7.02
From: MD

Since last post: 1978 days
Last activity: 433 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: 54

Posts: 586/641
EXP: 1186112
For next: 47765

Since: 15.2.02
From: Dallas

Since last post: 4410 days
Last activity: 4069 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: 143

Posts: 2397/6112
EXP: 35144669
For next: 687226

Since: 9.12.01
From: Bay City, OR

Since last post: 18 days
Last activity: 5 days
AIM:  
ICQ:  
Y!:
#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: 134

Posts: 2116/5279
EXP: 28148155
For next: 438893

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

Since last post: 12 days
Last activity: 1 day
#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: 221

Posts: 4675/16959
EXP: 162436472
For next: 581728

Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 7 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: 90

Posts: 1010/2103
EXP: 6937437
For next: 251199

Since: 1.8.02
From: Phoenix-ish

Since last post: 190 days
Last activity: 1 day
#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: 143

Posts: 2398/6112
EXP: 35144669
For next: 687226

Since: 9.12.01
From: Bay City, OR

Since last post: 18 days
Last activity: 5 days
AIM:  
ICQ:  
Y!:
#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: 221

Posts: 4683/16959
EXP: 162436472
For next: 581728

Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 7 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: 115

Posts: 1447/3704
EXP: 16577290
For next: 234125

Since: 11.12.01
From: China, Maine

Since last post: 1 day
Last activity: 20 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: 110

Posts: 1325/3321
EXP: 14025700
For next: 383232

Since: 17.1.02
From: New F'n Jersey

Since last post: 3 days
Last activity: 3 days
#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: 128

Posts: 1250/4750
EXP: 24025550
For next: 356216

Since: 2.1.02
From: Seattle, WA

Since last post: 250 days
Last activity: 16 days
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: 102

Posts: 2219/2805
EXP: 10898257
For next: 191748

Since: 6.1.02
From: Outer reaches of your mind

Since last post: 4298 days
Last activity: 2718 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: 127

Posts: 3206/4700
EXP: 23226415
For next: 500216

Since: 11.7.02
From: MD

Since last post: 1978 days
Last activity: 433 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: 65

Posts: 922/1007
EXP: 2308627
For next: 27013

Since: 17.6.02
From: Miami, Florida

Since last post: 4085 days
Last activity: 4085 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
Banger
Level: 97

Posts: 1202/2515
EXP: 9247471
For next: 69887

Since: 12.1.02
From: Fresno, CA

Since last post: 1 day
Last activity: 1 day
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: 221

Posts: 4684/16959
EXP: 162436472
For next: 581728

Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 7 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: 79

Posts: 874/1573
EXP: 4446360
For next: 133127

Since: 4.11.02
From: Winchester, VA

Since last post: 659 days
Last activity: 658 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: 221

Posts: 4685/16959
EXP: 162436472
For next: 581728

Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 7 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: 137

Posts: 1976/5525
EXP: 30111939
For next: 760994

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

Since last post: 3 days
Last activity: 12 hours
#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
(511 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-2015 Brothers Zim
This old hunk of junk rendered your page in 0.21 seconds.