Register    Login    Forum    FAQ

Board index » Community Discussion » The NAF




Post new topic Reply to topic  [ 31 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: Record for most games undefeated
 Post Posted: Wed Oct 19, 2016 1:02 pm 
Emerging Star
Emerging Star
User avatar

Joined: Fri Sep 02, 2011 4:39 am
Posts: 452
Location: Norsca
Does anyone know who holds the record for most naf games undefeated? (did not lose)

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Wed Oct 19, 2016 1:20 pm 
Legend
Legend
User avatar

Joined: Wed Dec 10, 2008 3:59 pm
Posts: 5818
Location: The Fast Lane
Cant look at NAF site whilst at work, but will look later.

Are you talking a streak of wins (and draws)? Or overall? If the latter that is really easy, the former probably not so.

_________________
Image

The Exiles Blood Bowl League and Tournaments use the Icepelt rulebook, for complete BB rules and fluff. Download here.
SW England Regional Co-ordinator for the NAF lunchmoney@thenaf.net
@Lunchmoney_Al for me @ExilesBBLeague for #TeamExiles news


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Wed Oct 19, 2016 2:32 pm 
Legend
Legend
User avatar

Joined: Tue Nov 10, 2009 9:31 am
Posts: 2507
Location: Somerset
I'm currently on 4 i think. Does that count?

_________________
My painting blog
TEAM CHAOS - The 69ers

King of the Flings

Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 9:13 am 
Emerging Star
Emerging Star
User avatar

Joined: Fri Sep 02, 2011 4:39 am
Posts: 452
Location: Norsca
lunchmoney wrote:
Cant look at NAF site whilst at work, but will look later.

Are you talking a streak of wins (and draws)? Or overall? If the latter that is really easy, the former probably not so.


Yeah im talking about streak of wins and draws.

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:10 am 
Star Player
Star Player
User avatar

Joined: Mon Jan 26, 2015 10:29 pm
Posts: 569
nazgob wrote:
I'm currently on 4 i think. Does that count?

It counts until proven otherwise! Long live Nazgob!

I got 6 wins or draws at Gert V, does that make me king now?

_________________
Image
-=The Elflympic Games=-
1st x1 3rd x1 Stunty Chamption x3
Anything But A One! Podcast - Updated Weekly
Support us on Patreon


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:17 am 
Legend
Legend
User avatar

Joined: Wed Dec 10, 2008 3:59 pm
Posts: 5818
Location: The Fast Lane
Bakunin wrote:
Yeah im talking about streak of wins and draws.

Then I think it will just need brute force. Look at each coach and look at the tourney records.
Rather you than me ;)

_________________
Image

The Exiles Blood Bowl League and Tournaments use the Icepelt rulebook, for complete BB rules and fluff. Download here.
SW England Regional Co-ordinator for the NAF lunchmoney@thenaf.net
@Lunchmoney_Al for me @ExilesBBLeague for #TeamExiles news


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:28 am 
Legend
Legend
User avatar

Joined: Sun Jul 16, 2006 8:43 pm
Posts: 1790
Location: Getting to the chopper!
Just to set the ball rolling I've found a streak of 15 games unbeaten for Pipey last year. He's currently on a 13 game streak now too.

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:30 am 
Veteran
Veteran

Joined: Fri Mar 28, 2014 10:21 am
Posts: 229
I had 24 matches in a streak in 2015/2016


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:37 am 
Legend
Legend
User avatar

Joined: Wed Dec 10, 2008 3:59 pm
Posts: 5818
Location: The Fast Lane
Don__Vito wrote:
Just to set the ball rolling I've found a streak of 15 games unbeaten for Pipey last year. He's currently on a 13 game streak now too.

I find the best way to beat pipey is with a stick. And a step ladder.


;)

_________________
Image

The Exiles Blood Bowl League and Tournaments use the Icepelt rulebook, for complete BB rules and fluff. Download here.
SW England Regional Co-ordinator for the NAF lunchmoney@thenaf.net
@Lunchmoney_Al for me @ExilesBBLeague for #TeamExiles news


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 10:42 am 
Legend
Legend
User avatar

Joined: Wed Dec 10, 2008 3:59 pm
Posts: 5818
Location: The Fast Lane
I think my biggest unbeaten streak is 4....

_________________
Image

The Exiles Blood Bowl League and Tournaments use the Icepelt rulebook, for complete BB rules and fluff. Download here.
SW England Regional Co-ordinator for the NAF lunchmoney@thenaf.net
@Lunchmoney_Al for me @ExilesBBLeague for #TeamExiles news


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 11:19 am 
The Glow-Father
User avatar

Joined: Thu Jul 12, 2007 11:44 am
Posts: 3693
Location: Not in your half.....
lunchmoney wrote:
I think my biggest unbeaten streak is 4....

1... And that's not often :D

_________________
Image
NEVER reroll a push ( but you can Pro roll it!!)
Fouling with the stars (stuff the 24)
Morg, Glart, Skitter, Puggy, Deeproot, Zug,


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 11:58 am 
Super Star
Super Star
User avatar

Joined: Sun Jun 08, 2008 9:27 am
Posts: 796
Location: Glasgow
I don't know what the structure of the NAF database is like, but assume it's on a MySQL platform. I've tested the following query on my OBBLM database and it seems to work. You'll need to alter the sub-query marked *** RESULTS QUERY *** to suit the NAF database. Alternatively, if you can give me some schema info for the NAF site, I'm happy to tailor the query for you.

Code:
-- Set User Variables
SET @c:=0;
SET @w:=0;
SET @d:=0;
SET @l:=0;
SET @u:=0;
-- Get highest streaks
SELECT   coach_id
      ,coach
      ,max(win_streak)                                 HIGHEST_WIN_STREAK
      ,max(draw_streak)                              HIGHEST_DRAW_STREAK
      ,max(loss_streak)                              HIGHEST_LOSS_STREAK
      ,max(undefeated_streak)                           HIGHEST_UNDEFEATED_STREAK
FROM
   -- *** STREAKS QUERY ***
   (
   -- Get results and streak counters
   SELECT   coach_id
         ,coach
         ,CASE WHEN coach_id = @c AND match_result = 'W'
               THEN @w:=@w+1
             WHEN coach_id != @c AND match_result = 'W'
               THEN @w:=1
             ELSE @w:=0   END                           WIN_STREAK
         ,CASE WHEN coach_id = @c AND match_result = 'D'
               THEN @d:=@d+1
             WHEN coach_id != @c AND match_result = 'D'
               THEN @d:=1
             ELSE @d:=0   END                           DRAW_STREAK
         ,CASE WHEN coach_id = @c AND match_result = 'L'
               THEN @l:=@l+1
             WHEN coach_id != @c AND match_result = 'L'
               THEN @l:=1
             ELSE @l:=0   END                           LOSS_STREAK
         ,CASE WHEN coach_id = @c AND match_result != 'L'
               THEN @u:=@u+1
             WHEN coach_id != @c AND match_result != 'L'
               THEN @u:=1
             ELSE @u:=0   END                           UNDEFEATED_STREAK
         ,@c:=coach_id
   FROM
      -- *** RESULTS QUERY ***
      (
      -- Team One
      SELECT   c.coach_id                              COACH_ID
            ,c.name                                 COACH
            ,t.name                                 TEAM
            ,m.match_id                              MATCH_ID
            ,m.date_played                           MATCH_DATE
            ,CASE WHEN team1_score > team2_score THEN 'W'
                WHEN team1_score < team2_score THEN 'L'
                ELSE 'D' END                         MATCH_RESULT
      FROM matches m
         JOIN teams t
            ON m.team1_id = t.team_id
         JOIN coaches c
            ON t.owned_by_coach_id = c.coach_id
      WHERE date_played IS NOT NULL

      UNION ALL
      -- Team Two
      SELECT   c.coach_id                              COACH_ID
            ,c.name                                 COACH
            ,t.name                                 TEAM
            ,m.match_id                              MATCH_ID
            ,m.date_played                           MATCH_DATE
            ,CASE WHEN team2_score > team1_score THEN 'W'
                WHEN team2_score < team1_score THEN 'L'
                ELSE 'D' END                         MATCH_RESULT
      FROM matches m
         JOIN teams t
            ON m.team2_id = t.team_id
         JOIN coaches c
            ON t.owned_by_coach_id = c.coach_id
      WHERE m.date_played IS NOT NULL
      ORDER BY coach_id ASC, match_date ASC
      ) r
   ) s
GROUP BY coach_id, coach
ORDER BY highest_win_streak DESC
      ,highest_undefeated_streak DESC
      ,highest_draw_streak DESC
      ,highest_win_streak DESC

_________________
Image
Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 1:20 pm 
Legend
Legend
User avatar

Joined: Sun Jul 16, 2006 8:43 pm
Posts: 1790
Location: Getting to the chopper!
I've found an 18 game streak for myself. Quite chuffed with that!

_________________
Image


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 1:58 pm 
Da Spammer
User avatar

Joined: Mon Aug 12, 2002 10:04 pm
Posts: 23522
Location: Fundamentaling for the BB Illuminati
5-win streak, 8-undefeated streak.

Shocked it's that high! :o

_________________
SWTC 2017 Stunty Cup winner - never again (until next time!)


Top 
 Profile  
 
 Post subject: Re: Record for most games undefeated
 Post Posted: Thu Oct 20, 2016 5:28 pm 
Super Star
Super Star
User avatar

Joined: Fri Nov 07, 2008 7:18 pm
Posts: 1204
Location: VA
I'm currently at 41 games. And that includes 5 games with halflings. :smoking:

EDIT: Should anyone ever revisit this thread, it ended at 54.

_________________
NAF Tournament Director

Image


Last edited by Gaixo on Tue Apr 25, 2017 12:10 am, edited 1 time in total.

Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 31 posts ]  Go to page 1, 2, 3  Next

Board index » Community Discussion » The NAF


Who is online

Users browsing this forum: No registered users

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: