Record for most games undefeated
Moderator: TFF Mods
- Bakunin
- Star Player
- Posts: 516
- Joined: Fri Sep 02, 2011 3:39 am
- Location: Norsca
Record for most games undefeated
Does anyone know who holds the record for most naf games undefeated? (did not lose)
Reason: ''
Galak 3:16 says "There is a point in time that a player really should read the rulebook."
- lunchmoney
- Legend
- Posts: 8859
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Record for most games undefeated
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.
Are you talking a streak of wins (and draws)? Or overall? If the latter that is really easy, the former probably not so.
Reason: ''
Hired Goon for the NAF (rep for South West England)
![Image](https://member.thenaf.net/nafsig/?uid=12145)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
-
- Legend
- Posts: 2730
- Joined: Tue Nov 10, 2009 8:31 am
- Location: Somerset
- Bakunin
- Star Player
- Posts: 516
- Joined: Fri Sep 02, 2011 3:39 am
- Location: Norsca
Re: Record for most games undefeated
Yeah im talking about streak of wins and draws.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.
Reason: ''
Galak 3:16 says "There is a point in time that a player really should read the rulebook."
- Twelfman
- Star Player
- Posts: 749
- Joined: Mon Jan 26, 2015 9:29 pm
Re: Record for most games undefeated
It counts until proven otherwise! Long live Nazgob!nazgob wrote:I'm currently on 4 i think. Does that count?
I got 6 wins or draws at Gert V, does that make me king now?
Reason: ''
- lunchmoney
- Legend
- Posts: 8859
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Record for most games undefeated
Then I think it will just need brute force. Look at each coach and look at the tourney records.Bakunin wrote: Yeah im talking about streak of wins and draws.
Rather you than me
![;)](./images/smilies/icon_wink.gif)
Reason: ''
Hired Goon for the NAF (rep for South West England)
![Image](https://member.thenaf.net/nafsig/?uid=12145)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
- Don__Vito
- Legend
- Posts: 1907
- Joined: Sun Jul 16, 2006 7:43 pm
- Location: Getting to the chopper!
Re: Record for most games undefeated
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.
Reason: ''
-
- Emerging Star
- Posts: 364
- Joined: Fri Mar 28, 2014 9:21 am
- lunchmoney
- Legend
- Posts: 8859
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Record for most games undefeated
I find the best way to beat pipey is with a stick. And a step ladder.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.
![;)](./images/smilies/icon_wink.gif)
Reason: ''
Hired Goon for the NAF (rep for South West England)
![Image](https://member.thenaf.net/nafsig/?uid=12145)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
- lunchmoney
- Legend
- Posts: 8859
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Record for most games undefeated
I think my biggest unbeaten streak is 4....
Reason: ''
Hired Goon for the NAF (rep for South West England)
![Image](https://member.thenaf.net/nafsig/?uid=12145)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
Re: Record for most games undefeated
1... And that's not oftenlunchmoney wrote:I think my biggest unbeaten streak is 4....
![:D](./images/smilies/icon_biggrin.gif)
Reason: ''
- Vanguard
- Super Star
- Posts: 922
- Joined: Sun Jun 08, 2008 8:27 am
- Location: Glasgow
- Contact:
Re: Record for most games undefeated
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: Select all
-- 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
Reason: ''
- Don__Vito
- Legend
- Posts: 1907
- Joined: Sun Jul 16, 2006 7:43 pm
- Location: Getting to the chopper!
Re: Record for most games undefeated
I've found an 18 game streak for myself. Quite chuffed with that!
Reason: ''
- Darkson
- Da Spammer
- Posts: 24047
- Joined: Mon Aug 12, 2002 9:04 pm
- Location: The frozen ruins of Felstad
- Contact:
Re: Record for most games undefeated
5-win streak, 8-undefeated streak.
Shocked it's that high!![:o](./images/smilies/icon_eek.gif)
Shocked it's that high!
![:o](./images/smilies/icon_eek.gif)
Reason: ''
Currently an ex-Blood Bowl coach, most likely to be found dying to Armoured Skeletons in the frozen ruins of Felstad, or bleeding into the arena sands of Rome or burning rubber for Mars' entertainment.
-
- Ex-Mega Star, now just a Super Star
- Posts: 1278
- Joined: Fri Nov 07, 2008 6:18 pm
- Location: VA
Re: Record for most games undefeated
I'm currently at 41 games. And that includes 5 games with halflings. ![:smoking:](./images/smilies/smoking.gif)
EDIT: Should anyone ever revisit this thread, it ended at 54.
![:smoking:](./images/smilies/smoking.gif)
EDIT: Should anyone ever revisit this thread, it ended at 54.
Reason: ''