What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

The 2013 Poser of the Year Tournament...it's Coming....

Re: The 2013 Poser of the Year Tournament...it's Coming....

Jimjamesak said:
I also doubt the existence of this memo considering all the pony stuff I get away with...
Click to expand...
Ponies don't set off the AdSense alarms.

JF_Gophers said:
I bet spammers feel like their fun is being limited. :D
Click to expand...
That's by design.

St. Clown said:
Unofficial hobby then?
Click to expand...
No. I think we've taken a very liberal tack on what has been allowed here. Unless it seriously violates posting guidelines to the point someone complains or it sets off the Adsense alarms, people have been given a lot of leeway.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

As a poster on hfboards (when I can stand it) and having to deal with the heavy handed mods, let me tell you that "fun" is far from limited around here.
 
Gurtholfin said:
As a poster on hfboards (when I can stand it) and having to deal with the heavy handed mods, let me tell you that "fun" is far from limited around here.
Click to expand...
Yeah, I've been on few boards that are pretty heavy handed as well. USCHO is nowhere near the "no fun".
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

Gurtholfin said:
As a poster on hfboards (when I can stand it) and having to deal with the heavy handed mods, let me tell you that "fun" is far from limited around here.
Click to expand...

I'm just remembering the good ol' days around here, I guess. Things were a lot different, much freer once upon a time.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

Or when we could post pics of pancakes on MEg's head. :D

I agree this board is pretty lax on the heavy-handedness compared to other boards I'm on.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

board said:
I don't recall seeing a memo reminding us to limit fun on the boards. I'll have to check again.
Click to expand...

Does this friendly message mean you might give the post count for the year to the election board to set up the slate of candidates? I think they need the top 40 post totals during 2013 or something like that.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

St. Clown said:
There's no way to get a data dump of user information from the site, it's just not going to happen.
Click to expand...
For purposes of POtY all the information needed can be obtained from the Member List (sorted by the Posts column).
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

MarkEagleUSA said:
For purposes of POtY all the information needed can be obtained from the Member List (sorted by the Posts column).
Click to expand...
Yes, it can be taken from there, but it's just not a quick process. It's a lot of copy/paste activity. Or when Brent was doing it, reading/writing/pencil sharpening. ;)
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

St. Clown said:
Yes, it can be taken from there, but it's just not a quick process. It's a lot of copy/paste activity. Or when Brent was doing it, reading/writing/pencil sharpening. ;)
Click to expand...

Indeed. Even with copy/pasting, it's quite a bit of work.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

FreshFish said:
Does this friendly message mean you might give the post count for the year to the election board to set up the slate of candidates? I think they need the top 40 post totals during 2013 or something like that.
Click to expand...

Sadly that is not data I have readily accessible.
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

I feel like the Enterprise or the Maker is speaking to us.

:D
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

But where can I watch the Poser of the Year tournament online for free?
 
Re: The 2013 Poser of the Year Tournament...it's Coming....

board said:
Sadly that is not data I have readily accessible.
Click to expand...

Here's all we need, adjust for variables:

SELECT username,postcount
FROM userdatabase
ORDER BY postcount DESC
LIMIT 0,150;

I say 150 because last year's organizer has the list of 100 posters in last year's event, along with the post counts, and he/she can do the comparison accordingly. In addition, he/she will remove administrators from the list, as well as inactive members, as they are not eligible for PotY.

I'm sure I could probably come up with a more complex pseudo-SQL statement that would iterate through the list to check the date and time of the last time the user posted (as well as if they are an admin), and add them to the list until we get 100. In fact, how about this:

SELECT username,postcount
FROM userdatabase
WHERE
datelastpost BETWEEN current_date() and ADDDATE(current_date(), INTERVAL -365 DAY) AND
userisadmin IS FALSE
ORDER BY postcount DESC
LIMIT 0,100;

Maybe a nested SELECT is need to get that datelastpost?
 
Last edited:
Re: The 2013 Poser of the Year Tournament...it's Coming....

FreshFish said:
Wouldn't you merely need to take a snapshot of post totals on, say, 12-31-12, and then another on 12-31-13, and then just calculate the difference? Or is that information not readily available?

Is there any way to ask the Board to provide that as a courtesy? after all, these kinds of contests increase traffice to the website which increases their hit count which increases what they can charge advertisers, no?
Click to expand...
You could do it that way I guess. Just remember that sooner or later you're going to have to do some math there to figure out who exactly had the most posts for the year.

St. Clown said:
I'm just remembering the good ol' days around here, I guess. Things were a lot different, much freer once upon a time.
Click to expand...
Back in my day Sonny, you could post all the pictures you wanted to post on here. You wanted to post a photoshop job of a pancake on somebody's head, then dang-gum-it! you could post a picture of that head with a pancake as a hat. You could even put youtube videos in the posts as well. And we had to walk uphill to our hockey arenas as well, in blizzards! You kids are far too soft!!! Now where is my prune juice??
 
You must log in or register to reply here.
Back
Top