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

Posts: 1241/4730
EXP: 22390156
For next: 64071

Since: 2.1.02
From: Seattle, WA

Since last post: 7 days
Last activity: 4 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: 21728253
For next: 108409

Since: 11.7.02
From: MD

Since last post: 1329 days
Last activity: 1126 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: 1111761
For next: 45365

Since: 15.2.02
From: Dallas

Since last post: 3762 days
Last activity: 3420 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/6035
EXP: 32349146
For next: 118381

Since: 9.12.01
From: Bay City, OR

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

Posts: 2116/5237
EXP: 26084190
For next: 340500

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

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

Posts: 4675/16402
EXP: 144940814
For next: 784606

Since: 9.12.01
From: ミネアポリス

Since last post: 12 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: 88

Posts: 1010/2091
EXP: 6432589
For next: 218101

Since: 1.8.02
From: Phoenix-ish

Since last post: 3 hours
Last activity: 3 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/6035
EXP: 32349146
For next: 118381

Since: 9.12.01
From: Bay City, OR

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

Posts: 4683/16402
EXP: 144940814
For next: 784606

Since: 9.12.01
From: ミネアポリス

Since last post: 12 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/3593
EXP: 14857469
For next: 10937

Since: 11.12.01
From: China, Maine

Since last post: 18 days
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/3277
EXP: 12890938
For next: 200415

Since: 17.1.02
From: New F'n Jersey

Since last post: 2 days
Last activity: 2 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: 125

Posts: 1250/4730
EXP: 22390156
For next: 64071

Since: 2.1.02
From: Seattle, WA

Since last post: 7 days
Last activity: 4 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: 10220344
For next: 134088

Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3650 days
Last activity: 2069 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: 21728253
For next: 108409

Since: 11.7.02
From: MD

Since last post: 1329 days
Last activity: 1126 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: 2160405
For next: 53704

Since: 17.6.02
From: Miami, Florida

Since last post: 3436 days
Last activity: 3436 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/2472
EXP: 8450142
For next: 218496

Since: 12.1.02
From: Fresno, CA

Since last post: 35 days
Last activity: 13 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: 214

Posts: 4684/16402
EXP: 144940814
For next: 784606

Since: 9.12.01
From: ミネアポリス

Since last post: 12 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/1573
EXP: 4152749
For next: 38399

Since: 4.11.02
From: Winchester, VA

Since last post: 10 days
Last activity: 9 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: 214

Posts: 4685/16402
EXP: 144940814
For next: 784606

Since: 9.12.01
From: ミネアポリス

Since last post: 12 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: 133

Posts: 1976/5387
EXP: 27185632
For next: 667108

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

Since last post: 187 days
Last activity: 25 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
(408 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.209 seconds.