Record for most games undefeated

News and announcements from the worldwide Blood Bowl players' association

Moderator: TFF Mods

User avatar
Bakunin
Star Player
Star Player
Posts: 516
Joined: Fri Sep 02, 2011 3:39 am
Location: Norsca

Record for most games undefeated

Post by Bakunin »

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."
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Record for most games undefeated

Post by lunchmoney »

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: ''
Hired Goon for the NAF (rep for South West England)
Image
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
nazgob
Legend
Legend
Posts: 2730
Joined: Tue Nov 10, 2009 8:31 am
Location: Somerset

Re: Record for most games undefeated

Post by nazgob »

I'm currently on 4 i think. Does that count?

Reason: ''
User avatar
Bakunin
Star Player
Star Player
Posts: 516
Joined: Fri Sep 02, 2011 3:39 am
Location: Norsca

Re: Record for most games undefeated

Post by Bakunin »

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.

Reason: ''
Galak 3:16 says "There is a point in time that a player really should read the rulebook."
User avatar
Twelfman
Star Player
Star Player
Posts: 749
Joined: Mon Jan 26, 2015 9:29 pm

Re: Record for most games undefeated

Post by Twelfman »

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?

Reason: ''
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Record for most games undefeated

Post by lunchmoney »

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 ;)

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
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
User avatar
Don__Vito
Legend
Legend
Posts: 1907
Joined: Sun Jul 16, 2006 7:43 pm
Location: Getting to the chopper!

Re: Record for most games undefeated

Post by Don__Vito »

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: ''
Image
straume
Emerging Star
Emerging Star
Posts: 364
Joined: Fri Mar 28, 2014 9:21 am

Re: Record for most games undefeated

Post by straume »

I had 24 matches in a streak in 2015/2016

Reason: ''
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Record for most games undefeated

Post by lunchmoney »

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.


;)

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
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
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Record for most games undefeated

Post by lunchmoney »

I think my biggest unbeaten streak is 4....

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
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
Glowworm

Re: Record for most games undefeated

Post by Glowworm »

lunchmoney wrote:I think my biggest unbeaten streak is 4....
1... And that's not often :D

Reason: ''
User avatar
Vanguard
Super Star
Super Star
Posts: 922
Joined: Sun Jun 08, 2008 8:27 am
Location: Glasgow
Contact:

Re: Record for most games undefeated

Post by Vanguard »

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: ''
Image
Image
User avatar
Don__Vito
Legend
Legend
Posts: 1907
Joined: Sun Jul 16, 2006 7:43 pm
Location: Getting to the chopper!

Re: Record for most games undefeated

Post by Don__Vito »

I've found an 18 game streak for myself. Quite chuffed with that!

Reason: ''
Image
User avatar
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

Post by Darkson »

5-win streak, 8-undefeated streak.

Shocked it's that high! :o

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.
Gaixo
Ex-Mega Star, now just a Super Star
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

Post by Gaixo »

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.

Reason: ''
Image
Post Reply