The W
Views: 100255368
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
30.10.14 2328
The W - the-w.com Site Feedback - Is this possible?
This thread has 1 referral leading to it
Register and log in to post!
Thread rated: 6.97
Pages: 1 2 Next
(727 newer) Next thread | Previous thread
User
Post (26 total)
JayJayDean
Scrapple








Since: 2.1.02
From: Seattle, WA

Since last post: 57 days
Last activity: 1 day
AIM:  
Y!:
#1 Posted on | Instant Rating: 6.99
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






“To get ass, you’ve got to bring ass." -- Roy Jones Jr.

"Your input has been noted.
I hope you don't take it personally if I disregard it."
-- Guru Zim

"Speak English or face admin retribution." -- CRZ
Promote this thread!
Grimis
Scrapple








Since: 11.7.02
From: MD

Since last post: 1277 days
Last activity: 1074 days
#2 Posted on | Instant Rating: 7.29
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.



Farley and Belushi are taken away in their prime yet Moore's heart continues to pump bacon grease in and out. God has a brutal sense of humor sometimes.- Barbwire Mike
ThreepMe
Morcilla








Since: 15.2.02
From: Dallas

Since last post: 3709 days
Last activity: 3368 days
#3 Posted on | Instant Rating: 4.01
    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....



"Are you kidding me? A soda with MY name on it? Now more than ever, SODAS RULE!" - Edge to Christian Smackdown Sept 7th 2000
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 1 day
Last activity: 2 hours
AIM:  
#4 Posted on | Instant Rating: 8.81
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.



Willful ignorance of science is not commendable. Refusing to learn the difference between a credible source and a shill is criminally stupid.
Zeruel
Thirty Millionth Hit
Moderator








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

Since last post: 2 days
Last activity: 5 hours
#5 Posted on | Instant Rating: 4.05
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)



The Catastrophic Annihilation War Room

CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 13 min.
AIM:  
ICQ:  
Y!:
#6 Posted on | Instant Rating: 9.07
    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.



©CRZ™
emma
Cherries > Peaches








Since: 1.8.02
From: Phoenix-ish

Since last post: 43 days
Last activity: 5 days
#7 Posted on | Instant Rating: 8.47
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








Since: 9.12.01
From: Bay City, OR

Since last post: 1 day
Last activity: 2 hours
AIM:  
#8 Posted on | Instant Rating: 8.81
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.



Willful ignorance of science is not commendable. Refusing to learn the difference between a credible source and a shill is criminally stupid.
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 13 min.
AIM:  
ICQ:  
Y!:
#9 Posted on | Instant Rating: 9.07
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



©CRZ™
pieman
As young as
he feels








Since: 11.12.01
From: China, Maine

Since last post: 7 days
Last activity: 1 day
AIM:  
ICQ:  
Y!:
#10 Posted on | Instant Rating: 8.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.




Gabba Gabba Hey!


Torchslasher
Knackwurst








Since: 17.1.02
From: New F'n Jersey

Since last post: 7 days
Last activity: 21 hours
#11 Posted on | Instant Rating: 5.75
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.



Mr. Green: Who would want to kill the cook?
Miss Scarlett: Dinner wasn't THAT bad.
Col. Mustard: How can you make jokes at a time like this?
Scarlett: It's my defense mechanism.
Mustard: Some defense. If I was to kill her, I would kill you next. (audible gasps) I said if, IF. Hey, come on there is only one admitted killer here, and it is certainly not me, it is her!
Mrs. White: I've admitted nothing.
Mustard: Well, you paid the blackmail. How many husbands have you had?
White: Mine or other women's?
Mustard: Yours.
White: Five.
Mustard: Five?
White: Yes, just the five. Husbands should be like Kleenex.
Soft, strong, and disposable.
Mustard: You lure men to their deaths like a spider with flies!
White: Flies are where men are most vulnerable.
JayJayDean
Scrapple








Since: 2.1.02
From: Seattle, WA

Since last post: 57 days
Last activity: 1 day
AIM:  
Y!:
#12 Posted on | Instant Rating: 6.99
    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

:)



“To get ass, you’ve got to bring ass." -- Roy Jones Jr.

"Your input has been noted.
I hope you don't take it personally if I disregard it."
-- Guru Zim

"Speak English or face admin retribution." -- CRZ
Net Hack Slasher
Banger








Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3597 days
Last activity: 2017 days
#13 Posted on | Instant Rating: 6.30
    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.





smark/net attack wienerville advisory stays at BLUE alert - Guarded (With Benoit & Eddie being World & WWE champions you'd expect all's be right but couldn't do it due to Trish/Y2J character switches & whats the deal with JBL PPV main event)- 5/6
Grimis
Scrapple








Since: 11.7.02
From: MD

Since last post: 1277 days
Last activity: 1074 days
#14 Posted on | Instant Rating: 7.29
    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%)




Farley and Belushi are taken away in their prime yet Moore's heart continues to pump bacon grease in and out. God has a brutal sense of humor sometimes.- Barbwire Mike
The Great Thomas
Sujuk








Since: 17.6.02
From: Miami, Florida

Since last post: 3384 days
Last activity: 3384 days
#15 Posted on | Instant Rating: 5.32
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?!



FIRST EVER "W of the Day"! (4/12/04)

Please Support The Neo-Geo Pocket Color!

Whitebacon
Boudin blanc








Since: 12.1.02
From: Fresno, CA

Since last post: 75 days
Last activity: 2 hours
AIM:  
ICQ:  
#16 Posted on | Instant Rating: 6.45
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.




(Not Bob Kohm)


In the context of baseball, the use of drugs hurts only the player. In the context of baseball, the use of alcohol hurts only the player. In the context of baseball, womanizing hurts whom? Maybe the wife of the player? In the context of baseball, felonies are crimes against society, not against baseball. In the context of baseball, gambling is the only crime against baseball.

Gambling, in the context of baseball, is a capital offense and Rose has richly earned-- hell, he agreed to-- his death sentence. Let him hang.

Bob Kohm, co-owner of Rotojunkies.com (rotojunkies.com) , and a large market kind of guy.
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 13 min.
AIM:  
ICQ:  
Y!:
#17 Posted on | Instant Rating: 9.07
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.



©CRZ™
The King of Keith
Lap cheong








Since: 4.11.02
From: Winchester, VA

Since last post: 321 days
Last activity: 281 days
AIM:  
#18 Posted on | Instant Rating: 5.66
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...






"Oh, I'm a sad little man? I've thrown a bloody kettle over a pub...what have you done?"
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 8 hours
Last activity: 13 min.
AIM:  
ICQ:  
Y!:
#19 Posted on | Instant Rating: 9.07
    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)


©CRZ™
ekedolphin
Scrapple








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

Since last post: 134 days
Last activity: 7 days
#20 Posted on | Instant Rating: 4.52
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.



“Finally, finally, my God finally, Chris Benoit is the Heavyweight Champion of this world!”
--Jim Ross, WrestleMania XX

Wiener of the Day Title History:

Won the title on 5/27/02 from Lunacy in a hardcore match; lost the belt the following day to wheresitat42 via offbeat shenanigans

Regained the title on 7/3/02 by pinning SKLOKAZOID in a triple-threat match; lost the belt the next day to NickBockwinkelFan via heel chicanery

Certified RFMC Member-- Ask To See My Credentials!

Pages: 1 2 Next
Thread rated: 6.97
Pages: 1 2 Next
Thread ahead: What happened
Next thread: old forums
Previous thread: The "W" icon
(727 newer) Next thread | Previous thread
I see the NFL logo in the first column beside the column with the custom thread icons in all threads/forum screens, it's kind of cool but annoying at the same time. Anyone else see it?
- thefraserman, NFL logo (2008)
The W - the-w.com Site Feedback - Is this possible?Register and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.114 seconds.