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

Posts: 1241/4719
EXP: 22187114
For next: 267113

Since: 2.1.02
From: Seattle, WA

Since last post: 57 days
Last activity: 1 day
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: 21601441
For next: 235221

Since: 11.7.02
From: MD

Since last post: 1276 days
Last activity: 1073 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: 1105474
For next: 51652

Since: 15.2.02
From: Dallas

Since last post: 3709 days
Last activity: 3367 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/6018
EXP: 32033014
For next: 434513

Since: 9.12.01
From: Bay City, OR

Since last post: 23 hours
Last activity: 7 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: 131

Posts: 2116/5218
EXP: 25797041
For next: 627649

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

Since last post: 2 days
Last activity: 1 hour
#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/16321
EXP: 143066593
For next: 300314

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 1 hour
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: 6371946
For next: 20853

Since: 1.8.02
From: Phoenix-ish

Since last post: 43 days
Last activity: 4 days
#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/6018
EXP: 32033014
For next: 434513

Since: 9.12.01
From: Bay City, OR

Since last post: 23 hours
Last activity: 7 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/16321
EXP: 143066593
For next: 300314

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 1 hour
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/3585
EXP: 14725307
For next: 143099

Since: 11.12.01
From: China, Maine

Since last post: 7 days
Last activity: 1 day
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/3275
EXP: 12806763
For next: 284590

Since: 17.1.02
From: New F'n Jersey

Since last post: 7 days
Last activity: 16 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: 22187114
For next: 267113

Since: 2.1.02
From: Seattle, WA

Since last post: 57 days
Last activity: 1 day
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: 10163042
For next: 191390

Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3597 days
Last activity: 2017 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: 21601441
For next: 235221

Since: 11.7.02
From: MD

Since last post: 1276 days
Last activity: 1073 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: 2147861
For next: 66248

Since: 17.6.02
From: Miami, Florida

Since last post: 3383 days
Last activity: 3383 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: 95

Posts: 1202/2468
EXP: 8382318
For next: 286320

Since: 12.1.02
From: Fresno, CA

Since last post: 74 days
Last activity: 12 sec.
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/16321
EXP: 143066593
For next: 300314

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 1 hour
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: 4123937
For next: 67211

Since: 4.11.02
From: Winchester, VA

Since last post: 321 days
Last activity: 280 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/16321
EXP: 143066593
For next: 300314

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 1 hour
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: 27033036
For next: 98968

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

Since last post: 134 days
Last activity: 7 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
(400 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.236 seconds.