Skip to content

Instantly share code, notes, and snippets.

@Phrancis

Phrancis/Chutes & Ladder results.txt

Last active June 15, 2016 16:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Phrancis/484a7af19f89eae331961b532ab3cc04 to your computer and use it in GitHub Desktop.
Save Phrancis/484a7af19f89eae331961b532ab3cc04 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Chutes & Ladder results
Raw
Chutes & Ladder results.txt
Title
----------------
Chutes & Ladders
Table Id PropertyType Property Value
------------- ----------- -------------------- -------------------- --------------------
Game Settings 1 Game Start Timestamp Jun 15 2016 12:36PM
Game Settings 2 Game Setup Dice faces 6
Game Settings 3 Game Setup Number of players 2
Game Settings 4 Board Setup Board size 100
Game Settings 5 Board Setup Number of chutes 5
Game Settings 6 Board Setup Number of ladders 5
Table CellId CellType GoToCell Delta
----- ----------- ---------- ----------- -----------
Board 1 Normal NULL 0
Board 2 Normal NULL 0
Board 3 Normal NULL 0
Board 4 Normal NULL 0
Board 5 Normal NULL 0
Board 6 Normal NULL 0
Board 7 Normal NULL 0
Board 8 Normal NULL 0
Board 9 Normal NULL 0
Board 10 Normal NULL 0
Board 11 Normal NULL 0
Board 12 Normal NULL 0
Board 13 Normal NULL 0
Board 14 Normal NULL 0
Board 15 Normal NULL 0
Board 16 Normal NULL 0
Board 17 Normal NULL 0
Board 18 Normal NULL 0
Board 19 Normal NULL 0
Board 20 Ladder 36 16
Board 21 Normal NULL 0
Board 22 Normal NULL 0
Board 23 Normal NULL 0
Board 24 Normal NULL 0
Board 25 Normal NULL 0
Board 26 Normal NULL 0
Board 27 Normal NULL 0
Board 28 Normal NULL 0
Board 29 Normal NULL 0
Board 30 Normal NULL 0
Board 31 Normal NULL 0
Board 32 Normal NULL 0
Board 33 Normal NULL 0
Board 34 Chute 27 -7
Board 35 Normal NULL 0
Board 36 Normal NULL 0
Board 37 Normal NULL 0
Board 38 Normal NULL 0
Board 39 Normal NULL 0
Board 40 Normal NULL 0
Board 41 Normal NULL 0
Board 42 Normal NULL 0
Board 43 Normal NULL 0
Board 44 Normal NULL 0
Board 45 Normal NULL 0
Board 46 Normal NULL 0
Board 47 Normal NULL 0
Board 48 Normal NULL 0
Board 49 Normal NULL 0
Board 50 Normal NULL 0
Board 51 Normal NULL 0
Board 52 Normal NULL 0
Board 53 Normal NULL 0
Board 54 Normal NULL 0
Board 55 Normal NULL 0
Board 56 Normal NULL 0
Board 57 Ladder 98 41
Board 58 Normal NULL 0
Board 59 Normal NULL 0
Board 60 Normal NULL 0
Board 61 Chute 3 -58
Board 62 Chute 27 -35
Board 63 Normal NULL 0
Board 64 Ladder 91 27
Board 65 Normal NULL 0
Board 66 Normal NULL 0
Board 67 Normal NULL 0
Board 68 Normal NULL 0
Board 69 Normal NULL 0
Board 70 Normal NULL 0
Board 71 Normal NULL 0
Board 72 Normal NULL 0
Board 73 Normal NULL 0
Board 74 Normal NULL 0
Board 75 Normal NULL 0
Board 76 Normal NULL 0
Board 77 Normal NULL 0
Board 78 Chute 27 -51
Board 79 Normal NULL 0
Board 80 Normal NULL 0
Board 81 Normal NULL 0
Board 82 Normal NULL 0
Board 83 Normal NULL 0
Board 84 Normal NULL 0
Board 85 Normal NULL 0
Board 86 Normal NULL 0
Board 87 Normal NULL 0
Board 88 Normal NULL 0
Board 89 Ladder 91 2
Board 90 Normal NULL 0
Board 91 Normal NULL 0
Board 92 Normal NULL 0
Board 93 Normal NULL 0
Board 94 Normal NULL 0
Board 95 Ladder 96 1
Board 96 Normal NULL 0
Board 97 Chute 88 -9
Board 98 Normal NULL 0
Board 99 Normal NULL 0
Board 100 Normal NULL 0
Table RowId PlayerId TurnId CurrentCell Roll LandingCell Delta EventDescription
----- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Game 1 1 1 1 1 2 1 Turn 1: Player 1 rolled 1 and moved from cell 1 to cell 2 with a delta of 1
Game 2 2 1 1 4 5 4 Turn 1: Player 2 rolled 4 and moved from cell 1 to cell 5 with a delta of 4
Game 3 1 2 2 5 7 5 Turn 2: Player 1 rolled 5 and moved from cell 2 to cell 7 with a delta of 5
Game 4 2 2 5 2 7 2 Turn 2: Player 2 rolled 2 and moved from cell 5 to cell 7 with a delta of 2
Game 5 1 3 7 4 11 4 Turn 3: Player 1 rolled 4 and moved from cell 7 to cell 11 with a delta of 4
Game 6 2 3 7 1 8 1 Turn 3: Player 2 rolled 1 and moved from cell 7 to cell 8 with a delta of 1
Game 7 1 4 11 1 12 1 Turn 4: Player 1 rolled 1 and moved from cell 11 to cell 12 with a delta of 1
Game 8 2 4 8 4 12 4 Turn 4: Player 2 rolled 4 and moved from cell 8 to cell 12 with a delta of 4
Game 9 1 5 12 5 17 5 Turn 5: Player 1 rolled 5 and moved from cell 12 to cell 17 with a delta of 5
Game 10 2 5 12 5 17 5 Turn 5: Player 2 rolled 5 and moved from cell 12 to cell 17 with a delta of 5
Game 11 1 6 17 2 19 2 Turn 6: Player 1 rolled 2 and moved from cell 17 to cell 19 with a delta of 2
Game 12 2 6 17 1 18 1 Turn 6: Player 2 rolled 1 and moved from cell 17 to cell 18 with a delta of 1
Game 13 1 7 19 5 24 5 Turn 7: Player 1 rolled 5 and moved from cell 19 to cell 24 with a delta of 5
Game 14 2 7 18 2 36 18 Turn 7: Player 2 rolled 2 and moved from cell 18 to cell 36 with a delta of 18
Game 15 1 8 24 3 27 3 Turn 8: Player 1 rolled 3 and moved from cell 24 to cell 27 with a delta of 3
Game 16 2 8 36 6 42 6 Turn 8: Player 2 rolled 6 and moved from cell 36 to cell 42 with a delta of 6
Game 17 1 9 27 4 31 4 Turn 9: Player 1 rolled 4 and moved from cell 27 to cell 31 with a delta of 4
Game 18 2 9 42 2 44 2 Turn 9: Player 2 rolled 2 and moved from cell 42 to cell 44 with a delta of 2
Game 19 1 10 31 6 37 6 Turn 10: Player 1 rolled 6 and moved from cell 31 to cell 37 with a delta of 6
Game 20 2 10 44 4 48 4 Turn 10: Player 2 rolled 4 and moved from cell 44 to cell 48 with a delta of 4
Game 21 1 11 37 3 40 3 Turn 11: Player 1 rolled 3 and moved from cell 37 to cell 40 with a delta of 3
Game 22 2 11 48 6 54 6 Turn 11: Player 2 rolled 6 and moved from cell 48 to cell 54 with a delta of 6
Game 23 1 12 40 4 44 4 Turn 12: Player 1 rolled 4 and moved from cell 40 to cell 44 with a delta of 4
Game 24 2 12 54 1 55 1 Turn 12: Player 2 rolled 1 and moved from cell 54 to cell 55 with a delta of 1
Game 25 1 13 44 5 49 5 Turn 13: Player 1 rolled 5 and moved from cell 44 to cell 49 with a delta of 5
Game 26 2 13 55 2 98 43 Turn 13: Player 2 rolled 2 and moved from cell 55 to cell 98 with a delta of 43
Game 27 1 14 49 1 50 1 Turn 14: Player 1 rolled 1 and moved from cell 49 to cell 50 with a delta of 1
Game 28 2 14 98 6 50 -48 Turn 14: Player 2 rolled 6 and moved from cell 98 to cell 50 with a delta of -48
Game 29 1 15 50 4 54 4 Turn 15: Player 1 rolled 4 and moved from cell 50 to cell 54 with a delta of 4
Game 30 2 15 50 3 53 3 Turn 15: Player 2 rolled 3 and moved from cell 50 to cell 53 with a delta of 3
Game 31 1 16 54 4 58 4 Turn 16: Player 1 rolled 4 and moved from cell 54 to cell 58 with a delta of 4
Game 32 2 16 53 6 59 6 Turn 16: Player 2 rolled 6 and moved from cell 53 to cell 59 with a delta of 6
Game 33 1 17 58 4 27 -31 Turn 17: Player 1 rolled 4 and moved from cell 58 to cell 27 with a delta of -31
Game 34 2 17 59 5 91 32 Turn 17: Player 2 rolled 5 and moved from cell 59 to cell 91 with a delta of 32
Game 35 1 18 27 5 32 5 Turn 18: Player 1 rolled 5 and moved from cell 27 to cell 32 with a delta of 5
Game 36 2 18 91 1 92 1 Turn 18: Player 2 rolled 1 and moved from cell 91 to cell 92 with a delta of 1
Game 37 1 19 32 2 27 -5 Turn 19: Player 1 rolled 2 and moved from cell 32 to cell 27 with a delta of -5
Game 38 2 19 92 5 88 -4 Turn 19: Player 2 rolled 5 and moved from cell 92 to cell 88 with a delta of -4
Game 39 1 20 27 4 31 4 Turn 20: Player 1 rolled 4 and moved from cell 27 to cell 31 with a delta of 4
Game 40 2 20 88 2 90 2 Turn 20: Player 2 rolled 2 and moved from cell 88 to cell 90 with a delta of 2
Game 41 1 21 31 1 32 1 Turn 21: Player 1 rolled 1 and moved from cell 31 to cell 32 with a delta of 1
Game 42 2 21 90 2 92 2 Turn 21: Player 2 rolled 2 and moved from cell 90 to cell 92 with a delta of 2
Game 43 1 22 32 3 35 3 Turn 22: Player 1 rolled 3 and moved from cell 32 to cell 35 with a delta of 3
Game 44 2 22 92 4 96 4 Turn 22: Player 2 rolled 4 and moved from cell 92 to cell 96 with a delta of 4
Game 45 1 23 35 1 36 1 Turn 23: Player 1 rolled 1 and moved from cell 35 to cell 36 with a delta of 1
Game 46 2 23 96 6 36 -60 Turn 23: Player 2 rolled 6 and moved from cell 96 to cell 36 with a delta of -60
Game 47 1 24 36 2 38 2 Turn 24: Player 1 rolled 2 and moved from cell 36 to cell 38 with a delta of 2
Game 48 2 24 36 6 42 6 Turn 24: Player 2 rolled 6 and moved from cell 36 to cell 42 with a delta of 6
Game 49 1 25 38 6 44 6 Turn 25: Player 1 rolled 6 and moved from cell 38 to cell 44 with a delta of 6
Game 50 2 25 42 4 46 4 Turn 25: Player 2 rolled 4 and moved from cell 42 to cell 46 with a delta of 4
Game 51 1 26 44 4 48 4 Turn 26: Player 1 rolled 4 and moved from cell 44 to cell 48 with a delta of 4
Game 52 2 26 46 6 52 6 Turn 26: Player 2 rolled 6 and moved from cell 46 to cell 52 with a delta of 6
Game 53 1 27 48 4 52 4 Turn 27: Player 1 rolled 4 and moved from cell 48 to cell 52 with a delta of 4
Game 54 2 27 52 2 54 2 Turn 27: Player 2 rolled 2 and moved from cell 52 to cell 54 with a delta of 2
Game 55 1 28 52 4 56 4 Turn 28: Player 1 rolled 4 and moved from cell 52 to cell 56 with a delta of 4
Game 56 2 28 54 1 55 1 Turn 28: Player 2 rolled 1 and moved from cell 54 to cell 55 with a delta of 1
Game 57 1 29 56 2 58 2 Turn 29: Player 1 rolled 2 and moved from cell 56 to cell 58 with a delta of 2
Game 58 2 29 55 2 98 43 Turn 29: Player 2 rolled 2 and moved from cell 55 to cell 98 with a delta of 43
Game 59 1 30 58 3 3 -55 Turn 30: Player 1 rolled 3 and moved from cell 58 to cell 3 with a delta of -55
Game 60 2 30 98 2 100 2 Turn 30: Player 2 rolled 2 and moved from cell 98 to cell 100 with a delta of 2
Game 61 1 30 98 2 100 2 Turn 30: Player 1 has won the game! Game duration: 0 second(s)
@Phrancis
Copy link
Author

Related to this question on Code Review: Flexible Chutes & Ladders using SQL stored procedure

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment