Zero2Cool
12 years ago
Feel free to check out the Top 10 page - link . You can also click the link on the horizontal bar below that neat logo.

[list]
  • Received Applause - This shows the top 10 members who have received the most applause.
  • Gave Applause - This shows the top 10 members who have given the most applause.
  • Most Posts - This shows
  • Post with Most Applause - This looks for the top 10 posts with the most applause.
  • Characters per Post - This sums all of messages by characters typed and averages with how many posts have been submitted.
  • Least Active - This checks for everyone who has posted more than 500 times and hasn't logged into the site through the duration you've selected. So, if you set Quantity to 2 and Duration to Months ... you'll see the top 10 members who have over 500 posts and haven't logged into PackersHome.com in 2 months.
    • [/list]

    NOTE: If you set Quantity to 3, and Duration to Weeks. You'll be checking the values for three weeks prior to today's date. If you set Duration to All, that will query the entire database.
    UserPostedImage
    +1
    Pack93z
    12 years ago
    Characters per post with all selected timed out.. That might be too big of a query for an all statement.

    That might be a not doable request.
    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Zero2Cool
    12 years ago

    Characters per post with all selected timed out.. That might be too big of a query for an all statement.

    That might be a not doable request.

    Originally Posted by: Pack93z 



    Hmm, I'll have to make that a stored procedure. It took about 10 seconds for me too. You may have been trying when I was updating the core site DLL?

    I ran it just now and after about 10 seconds this was returned.
    [list=1]
  • 5882 Arrigo
  • 4923 The_Turtle
  • 3399 August
  • 3349 bt_impaler
  • 3278 macbob
  • 3270 RashaanSalaami
  • 3118 Guest
  • 3092 INDUCEDCOMA
  • 3069 CalifPacker
  • 2468 pmanning[/list]

    • That pesky Guest!!
    UserPostedImage
    Pack93z
    12 years ago

    Hmm, I'll have to make that a stored procedure. It took about 10 seconds for me too. You may have been trying when I was updating the core site DLL?

    I ran it just now and after about 10 seconds this was returned.
    [list=1]

  • 5882 Arrigo
  • 4923 The_Turtle
  • 3399 August
  • 3349 bt_impaler
  • 3278 macbob
  • 3270 RashaanSalaami
  • 3118 Guest
  • 3092 INDUCEDCOMA
  • 3069 CalifPacker
  • 2468 pmanning[/list]

    • That pesky Guest!!

    Originally Posted by: Zero2Cool 



    Are characters within quotes parsed out? Curious.
    "The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
    Zero2Cool
    12 years ago

    Are characters within quotes parsed out? Curious.

    Originally Posted by: Pack93z 



    They include quotes. I can't figure out how to eliminate the information between the quotes without writing a stored procedure and even that's going to be tricky as we have a plethora of posts with multiple quote boxes in it. So, for the time being, it's all characters.
    UserPostedImage
    Zero2Cool
    12 years ago
    I'm finding this feature pretty interesting and I check it every other day.
    UserPostedImage
    Porforis
    12 years ago
    I love looking at statistics, thanks!
    wpr
    • wpr
    • Preferred Member
    12 years ago
    me likey. đź‘Ť it is kind of fun.

    edit- something else you can add is who uses the most icon/smilies. [grin1]

    or perhaps who uses this one [vikes] the most.
    UserPostedImage
    wpr
    • wpr
    • Preferred Member
    12 years ago
    what about most links for youtube or pictures or news stories?
    UserPostedImage
    zombieslayer
    12 years ago
    Wade doesn't have the most characters per post?
    Hmm...:-k
    My man Donald Driver
    UserPostedImage
    (thanks to Pack93z for the pic)
    2010 will be seen as the beginning of the new Packers dynasty. 🇹🇹 🇲🇲 🇦🇷
    Similar Topics
    Users browsing this topic
      Fan Shout
      Zero2Cool (6h) : Well, not crazy, it makes sense. Crazy I didn't notice/find it earlier
      Zero2Cool (6h) : it's crazy how one stored procedure to get data bogged everything down for speed here
      dfosterf (6h) : to herd cats or goldfish without a bowl. They reminded me of the annual assembly of our fantasy league
      dfosterf (6h) : out on a field trip, outfitting them with little yellow smocks. Most of the little folk were well behaved, but several were like trying
      dfosterf (6h) : Yesterday my wife and I spent the afternoon on the waterfront here in Alexandria, Va. A daycare company took about 15 three/four year olds
      wpr (6h) : seems faster. yay
      dfosterf (6h) : Wife of reason posted on the in/out thread on fleaflicker that both she and vor are in
      Zero2Cool (17h) : This page was generated in 0.135 seconds.
      Mucky Tundra (18h) : Tbh, I can never tell the difference in speed unless it's completely shitting the bed
      Zero2Cool (18h) : Sure does feel like site is more snappy
      Zero2Cool (22h) : I thought that was the Lions OL
      Mucky Tundra (22h) : Travis Glover placed on IR; seasons over for him
      Zero2Cool (6-Aug) : found bad sql in database, maybe site faster now?
      dfosterf (5-Aug) : I'm going to call that a good move.
      Zero2Cool (4-Aug) : Packers sign CB Corey Ballentine
      Zero2Cool (4-Aug) : I'm not sure how to kill the draft order just yet so it's not so confusing.
      Mucky Tundra (4-Aug) : *to be able
      Mucky Tundra (4-Aug) : and because it's not a dynasty league (which makes a lot more sense to be ability to trade picks)
      Mucky Tundra (4-Aug) : Oh I know; I was just exploring and it blew my mind that you could trade picks because of the whole reordering thing
      Mucky Tundra (4-Aug) : Zero, I think I preferred my offer: your 1st for my 15th rounder
      Zero2Cool (4-Aug) : Keep in mind, we do a draft reorder once all members locked in
      Zero2Cool (4-Aug) : You can have my 12th Rd for your 2nd round
      Mucky Tundra (4-Aug) : Hey i didn't know we could trade picks in fantasy
      Mucky Tundra (3-Aug) : Update: Rock has tried a cheese curd, promises it's not his last
      Zero2Cool (3-Aug) : watch it!! lol
      Mucky Tundra (3-Aug) : you're right, we never did leave, the site just went down :P
      Mucky Tundra (3-Aug) : Rock claims to have never eaten a cheese curd
      Zero2Cool (3-Aug) : We did not leave.
      Mucky Tundra (3-Aug) : Family Night! WE ARE SO BACK!
      Mucky Tundra (2-Aug) : To this day, I'm still miffed about his 4 TD game against Dallas on Thanksgiving going to waste
      Martha Careful (2-Aug) : Congratulations Sterling Sharpe. He was terrific and I loved watching him play.
      beast (2-Aug) : I believe it's technically against the CBA rules, but Jerry just calls it a simple unofficial chat... and somehow gets away with it.
      beast (2-Aug) : Jerry Jones is infamous for ̶n̶e̶g̶o̶t̶i̶a̶t̶i̶n̶g̶ chatting with players one on one... and going around the agent.
      Mucky Tundra (1-Aug) : Oo just saw a blurb saying that Dallas negotiated directly with Parsons and not through his agent
      Mucky Tundra (1-Aug) : I assumed that both guys will get paid, just a matter of when or how we get there
      Zero2Cool (1-Aug) : McLaurin nor Micah going anywhere. They will get money
      Mucky Tundra (1-Aug) : the Synder years or do they take care of one of their own?
      Mucky Tundra (1-Aug) : Do the Commanders risk losing a top WR with an emerging QB just because he's turning 30 and potentially risk damaging the rebuild from
      Mucky Tundra (1-Aug) : Turns 30 this September, plays at a high level and Washington has some cap space I believe
      Mucky Tundra (1-Aug) : More interesting is Washington with Terry McLaurin
      Mucky Tundra (1-Aug) : I would imagine Dallas will resolve this issue with a truckload of money
      Zero2Cool (1-Aug) : Micah pulling a Myles with trade request
      beast (1-Aug) : Packers should make some cheese forks
      Mucky Tundra (31-Jul) : GRAB THE PITCHFORKS~
      Zero2Cool (31-Jul) : CUT HIM
      Mucky Tundra (31-Jul) : Socieltal collapse imminent
      Mucky Tundra (31-Jul) : The West has fallen
      Mucky Tundra (31-Jul) : After starting off camp with 25 straight made field goals, Brandon McManus has missed one
      Zero2Cool (31-Jul) : But it should be stable
      Zero2Cool (31-Jul) : It's probably gonna be slower.
      Please sign in to use Fan Shout
      2025 Packers Schedule
      Sunday, Sep 7 @ 3:25 PM
      LIONS
      Thursday, Sep 11 @ 7:15 PM
      COMMANDERS
      Sunday, Sep 21 @ 12:00 PM
      Browns
      Sunday, Sep 28 @ 7:20 PM
      Cowboys
      Sunday, Oct 12 @ 3:25 PM
      BENGALS
      Sunday, Oct 19 @ 3:25 PM
      Cardinals
      Sunday, Oct 26 @ 7:20 PM
      Steelers
      Sunday, Nov 2 @ 12:00 PM
      PANTHERS
      Monday, Nov 10 @ 7:15 PM
      EAGLES
      Sunday, Nov 16 @ 12:00 PM
      Giants
      Sunday, Nov 23 @ 12:00 PM
      VIKINGS
      Thursday, Nov 27 @ 12:00 PM
      Lions
      Sunday, Dec 7 @ 12:00 PM
      BEARS
      Sunday, Dec 14 @ 3:25 PM
      Broncos
      Friday, Dec 19 @ 11:00 PM
      Bears
      Friday, Dec 26 @ 11:00 PM
      RAVENS
      Saturday, Jan 3 @ 11:00 PM
      Vikings
      Recent Topics
      55m / Green Bay Packers Talk / Mucky Tundra

      21h / Fantasy Sports Talk / dfosterf

      6-Aug / Around The NFL / wpr

      5-Aug / Green Bay Packers Talk / beast

      5-Aug / Green Bay Packers Talk / wpr

      4-Aug / Green Bay Packers Talk / bboystyle

      3-Aug / Green Bay Packers Talk / Mucky Tundra

      3-Aug / Green Bay Packers Talk / beast

      3-Aug / Feedback, Suggestions and Issues / Zero2Cool

      2-Aug / Green Bay Packers Talk / Mucky Tundra

      2-Aug / Green Bay Packers Talk / wpr

      28-Jul / Random Babble / Zero2Cool

      28-Jul / Green Bay Packers Talk / Mucky Tundra

      28-Jul / Green Bay Packers Talk / Mucky Tundra

      27-Jul / Green Bay Packers Talk / Mucky Tundra

      Headlines
      Copyright © 2006 - 2025 PackersHome.com™. All Rights Reserved.