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

Posts: 1241/4718
EXP: 22041195
For next: 413032

Since: 2.1.02
From: Seattle, WA

Since last post: 19 days
Last activity: 8 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: 21460461
For next: 376201

Since: 11.7.02
From: MD

Since last post: 1218 days
Last activity: 1015 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: 1098487
For next: 58639

Since: 15.2.02
From: Dallas

Since last post: 3650 days
Last activity: 3309 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/6002
EXP: 31706601
For next: 760926

Since: 9.12.01
From: Bay City, OR

Since last post: 9 hours
Last activity: 8 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/5205
EXP: 25539778
For next: 190868

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

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

Posts: 4675/16176
EXP: 140284908
For next: 750878

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 3 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/2084
EXP: 6321059
For next: 71740

Since: 1.8.02
From: Phoenix-ish

Since last post: 160 days
Last activity: 4 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/6002
EXP: 31706601
For next: 760926

Since: 9.12.01
From: Bay City, OR

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

Posts: 4683/16176
EXP: 140284908
For next: 750878

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 3 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/3563
EXP: 14499046
For next: 369360

Since: 11.12.01
From: China, Maine

Since last post: 13 hours
Last activity: 13 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: 106

Posts: 1325/3263
EXP: 12656438
For next: 15546

Since: 17.1.02
From: New F'n Jersey

Since last post: 10 hours
Last activity: 8 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/4718
EXP: 22041195
For next: 413032

Since: 2.1.02
From: Seattle, WA

Since last post: 19 days
Last activity: 8 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: 10099353
For next: 255079

Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3538 days
Last activity: 1958 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: 21460461
For next: 376201

Since: 11.7.02
From: MD

Since last post: 1218 days
Last activity: 1015 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: 2133916
For next: 80193

Since: 17.6.02
From: Miami, Florida

Since last post: 3325 days
Last activity: 3325 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: 8329721
For next: 26967

Since: 12.1.02
From: Fresno, CA

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

Posts: 4684/16176
EXP: 140284908
For next: 750878

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 3 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: 4096304
For next: 94844

Since: 4.11.02
From: Winchester, VA

Since last post: 263 days
Last activity: 222 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: 212

Posts: 4685/16176
EXP: 140284908
For next: 750878

Since: 9.12.01
From: ミネアポリス

Since last post: 3 hours
Last activity: 3 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: 26863432
For next: 268572

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

Since last post: 75 days
Last activity: 20 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
(391 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.23 seconds.