the database table is called chess_pieces it holds 88 records (one for each piece) each piece has, at any one time, a certain amount of legal moves available to it at start, there are 88 pieces on the board a piece that has been taken has a location of 0 and therefore will not show
1 bl_shot1 is on square 3 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 2 bl_shot2 is on square 4 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 3 bl_shot3 is on square 5 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 4 bl_shot4 is on square 6 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 5 bl_shot5 is on square 7 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 6 bl_shot6 is on square 8 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_crater.png) bl_shot.png - bl_shot.png - bl_shot.png -14-13 7 bl_rook1 is on square 12 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black rook1) ♜ - ♜ - bl_rook.png -5-12 8 bl_knight1 is on square 13 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black knight1) ♞ - ♞ - bl_knight.png -4-11 9 bl_bishop1 is on square 14 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black bishop1) ♝ - ♝ - bl_bishop.png -0-15 10 is on square 15 (colour:1) ||| 00000000000000000000000000000000000000000000000 () - - -10-11 11 bl_jester1 is on square 16 (colour:1) ||| -10 ! -8 ! -6 ! 3 ! 4 ! 5 ! 14 ! 15 ! 17 ! 18 ! 27 ! 28 ! 29 ! 38 ! 40 ! 42 ! 0000000000000000000000000000000 (black bl_jester1) bl_jester.png - bl_jester.png - bl_jester.png -2-5 12 bl_queen is on square 17 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black queen) ♛ - ♛ - bl_queen.png -5-5 13 bl_king is on square 18 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black king) ♚ - ♚ - bl_king.png -2-4 14 bl_jester2 is on square 19 (colour:1) ||| -7 ! -5 ! -3 ! 6 ! 7 ! 8 ! 17 ! 18 ! 20 ! 21 ! 30 ! 31 ! 32 ! 41 ! 43 ! 45 ! 0000000000000000000000000000000 (bl_jester2) bl_jester.png - bl_jester.png - bl_jester.png -2-5 15 is on square 20 (colour:1) ||| 00000000000000000000000000000000000000000000000 () - - -10-11 16 bl_bishop2 is on square 21 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black bishop2) ♝ - ♝ - bl_bishop.png -0-15 17 bl_knight2 is on square 22 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black knight2) ♞ - ♞ - bl_knight.png -4-11 18 bl_rook2 is on square 23 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black rook2) ♜ - ♜ - bl_rook.png -5-12 19 bl_knight3 is on square 24 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black knight3) ♞ - ♞ - bl_knight.png -4-11 20 bl_elite1 is on square 25 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black elite1) bl_elite.png - bl_elite.png - bl_elite.png -3-4 21 bl_elite2 is on square 26 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black elite2) bl_elite.png - bl_elite.png - bl_elite.png -3-4 22 bl_cannon1 is on square 27 (colour:1) ||| 15 ! 28 ! 000000000000000000000000000000000000000000000 (bl_cannon_loaded.png) bl_cannon.png - bl_cannon.png - bl_cannon.png -10-3 23 bl_bishop3 is on square 29 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black bishop3) ♝ - ♝ - bl_bishop.png -0-15 24 bl_bishop4 is on square 30 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black bishop4) ♝ - ♝ - bl_bishop.png -0-15 25 bl_cannon2 is on square 32 (colour:1) ||| 20 ! 31 ! 000000000000000000000000000000000000000000000 (bl_cannon_loaded.png) bl_cannon.png - bl_cannon.png - bl_cannon.png -10-3 26 bl_elite3 is on square 33 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black elite3) bl_elite.png - bl_elite.png - bl_elite.png -3-4 27 bl_elite4 is on square 34 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black elite4) bl_elite.png - bl_elite.png - bl_elite.png -3-4 28 bl_knight4 is on square 35 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black knight4) ♞ - ♞ - bl_knight.png -4-11 29 bl_pawn1 is on square 36 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn1) ♟ - ♟ - bl_pawn.png -6-13 30 bl_pawn2 is on square 37 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn2) ♟ - ♟ - bl_pawn.png -6-13 31 bl_pawn3 is on square 38 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn3) ♟ - ♟ - bl_pawn.png -6-13 32 bl_pawn4 is on square 39 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn4) ♟ - ♟ - bl_pawn.png -6-13 33 bl_pawn5 is on square 40 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn5) ♟ - ♟ - bl_pawn.png -6-13 34 bl_pawn6 is on square 41 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn6) ♟ - ♟ - bl_pawn.png -6-13 35 bl_pawn7 is on square 42 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn7) ♟ - ♟ - bl_pawn.png -6-13 36 bl_pawn8 is on square 43 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn8) ♟ - ♟ - bl_pawn.png -6-13 37 bl_pawn9 is on square 44 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn9) ♟ - ♟ - bl_pawn.png -6-13 38 bl_pawn10 is on square 45 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn10) ♟ - ♟ - bl_pawn.png -6-13 39 bl_pawn11 is on square 46 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn11) ♟ - ♟ - bl_pawn.png -6-13 40 bl_pawn12 is on square 47 (colour:1) ||| 00000000000000000000000000000000000000000000000 (black pawn12) ♟ - ♟ - bl_pawn.png -6-13 41 wh_pawn1 is on square 120 (colour:2) ||| 108 ! 96 ! 000000000000000000000000000000000000000000000 (white pawn1) ♙ - ♙ - wh_pawn.png -6-13 42 wh_pawn2 is on square 121 (colour:2) ||| 109 ! 97 ! 000000000000000000000000000000000000000000000 (white pawn2) ♙ - ♙ - wh_pawn.png -6-13 43 wh_pawn3 is on square 122 (colour:2) ||| 110 ! 98 ! 000000000000000000000000000000000000000000000 (white pawn3) ♙ - ♙ - wh_pawn.png -6-13 44 wh_pawn4 is on square 123 (colour:2) ||| 111 ! 99 ! 000000000000000000000000000000000000000000000 (white pawn4) ♙ - ♙ - wh_pawn.png -6-13 45 wh_pawn5 is on square 124 (colour:2) ||| 112 ! 100 ! 000000000000000000000000000000000000000000000 (white pawn5) ♙ - ♙ - wh_pawn.png -6-13 46 wh_pawn6 is on square 125 (colour:2) ||| 113 ! 101 ! 000000000000000000000000000000000000000000000 (white pawn6) ♙ - ♙ - wh_pawn.png -6-13 47 wh_pawn7 is on square 126 (colour:2) ||| 114 ! 102 ! 000000000000000000000000000000000000000000000 (white pawn7) ♙ - ♙ - wh_pawn.png -6-13 48 wh_pawn8 is on square 127 (colour:2) ||| 115 ! 103 ! 000000000000000000000000000000000000000000000 (white pawn8) ♙ - ♙ - wh_pawn.png -6-13 49 wh_pawn9 is on square 128 (colour:2) ||| 116 ! 104 ! 000000000000000000000000000000000000000000000 (white pawn9) ♙ - ♙ - wh_pawn.png -6-13 50 wh_pawn10 is on square 129 (colour:2) ||| 117 ! 105 ! 000000000000000000000000000000000000000000000 (white pawn10) ♙ - ♙ - wh_pawn.png -6-13 51 wh_pawn11 is on square 130 (colour:2) ||| 118 ! 106 ! 000000000000000000000000000000000000000000000 (white pawn11) ♙ - ♙ - wh_pawn.png -6-13 52 wh_pawn12 is on square 131 (colour:2) ||| 119 ! 107 ! 000000000000000000000000000000000000000000000 (white pawn12) ♙ - ♙ - wh_pawn.png -6-13 53 wh_knight3 is on square 132 (colour:2) ||| 109 ! 0000000000000000000000000000000000000000000000 (white knight3) ♘ - ♘ - wh_knight.png -4-11 54 wh_elite1 is on square 133 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white elite1) wh_elite.png - wh_elite.png - wh_elite.png -3-4 55 wh_elite2 is on square 134 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white elite2) wh_elite.png - wh_elite.png - wh_elite.png -3-4 56 wh_cannon1 is on square 135 (colour:2) ||| 147 ! 136 ! 000000000000000000000000000000000000000000000 (wh_cannon_loaded.png) wh_cannon.png - wh_cannon.png - wh_cannon.png -10-3 57 wh_bishop3 is on square 137 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white bishop3) ♗ - ♗ - wh_bishop.png -0-15 58 wh_bishop4 is on square 138 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white bishop4) ♗ - ♗ - wh_bishop.png -0-15 59 wh_cannon2 is on square 140 (colour:2) ||| 152 ! 139 ! 000000000000000000000000000000000000000000000 (wh_cannon_loaded.png) wh_cannon.png - wh_cannon.png - wh_cannon.png -10-3 60 wh_elite3 is on square 141 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white elite3) wh_elite.png - wh_elite.png - wh_elite.png -3-4 61 wh_elite4 is on square 142 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white elite4) wh_elite.png - wh_elite.png - wh_elite.png -3-4 62 wh_knight4 is on square 143 (colour:2) ||| 0 118 ! 000000000000000000000000000000000000000000000 (white knight4) ♘ - ♘ - wh_knight.png -4-11 63 wh_rook1 is on square 144 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white rook1) ♖ - ♖ - wh_rook.png -5-12 64 wh_knight1 is on square 145 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white knight1) ♘ - ♘ - wh_knight.png -4-11 65 wh_bishop1 is on square 146 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white bishop1) ♗ - ♗ - wh_bishop.png -0-15 66 is on square 147 (colour:1) ||| 00000000000000000000000000000000000000000000000 () - - -10-11 67 wh_jester1 is on square 148 (colour:2) ||| 122 ! 124 ! 126 ! 135 ! 136 ! 137 ! 146 ! 147 ! 149 ! 150 ! 159 ! 160 ! 161 ! 170 ! 172 ! 174 ! 0000000000000000000000000000000 (wh_jester1) wh_jester.png - wh_jester.png - wh_jester.png -2-5 68 wh_queen is on square 149 (colour:2) ||| 136 ! 0000000000000000000000000000000000000000000000 (white queen) ♕ - ♕ - wh_queen.png -5-5 69 wh_king is on square 150 (colour:2) ||| 00 139 ! 00000000000000000000000000000000000000000000 (white king) ♔ - ♔ - wh_king.png -2-4 70 wh_jester2 is on square 151 (colour:2) ||| 125 ! 127 ! 129 ! 138 ! 139 ! 140 ! 149 ! 150 ! 152 ! 153 ! 162 ! 163 ! 164 ! 173 ! 175 ! 177 ! 0000000000000000000000000000000 (wh_jester2) wh_jester.png - wh_jester.png - wh_jester.png -2-5 71 is on square 152 (colour:1) ||| 00000000000000000000000000000000000000000000000 () - - -10-11 72 wh_bishop2 is on square 153 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white bishop2) ♗ - ♗ - wh_bishop.png -0-15 73 wh_knight2 is on square 154 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white knight2) ♘ - ♘ - wh_knight.png -4-11 74 wh_rook2 is on square 155 (colour:2) ||| 00000000000000000000000000000000000000000000000 (white rook2) ♖ - ♖ - wh_rook.png -5-12 75 wh_shot1 is on square 159 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 76 wh_shot2 is on square 160 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 77 wh_shot3 is on square 161 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 78 wh_shot4 is on square 162 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 79 wh_shot5 is on square 163 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 80 wh_shot6 is on square 164 (colour:2) ||| 147 ! 152 ! 000000000000000000000000000000000000000000000 (wh_crater.png) wh_shot.png - wh_shot.png - wh_shot.png -14-13 81 bl_archer1 is on square 1 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_archer.png) bl_archer.png - bl_archer.png - bl_archer.png -5-5 82 bl_archer2 is on square 2 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_archer.png) bl_archer.png - bl_archer.png - bl_archer.png -5-5 83 bl_archer3 is on square 9 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_archer.png) bl_archer.png - bl_archer.png - bl_archer.png -5-5 84 bl_archer4 is on square 10 (colour:1) ||| 00000000000000000000000000000000000000000000000 (bl_archer.png) bl_archer.png - bl_archer.png - bl_archer.png -5-5 85 wh_archer1 is on square 157 (colour:2) ||| 00000000000000000000000000000000000000000000000 (wh_archer.png) wh_archer.png - wh_archer.png - wh_archer.png -10-10 86 wh_archer2 is on square 158 (colour:2) ||| 00000000000000000000000000000000000000000000000 (wh_archer.png) wh_archer.png - wh_archer.png - wh_archer.png -10-10 87 wh_archer3 is on square 165 (colour:2) ||| 00000000000000000000000000000000000000000000000 (wh_archer.png) wh_archer.png - wh_archer.png - wh_archer.png -10-10 88 wh_archer4 is on square 166 (colour:2) ||| 00000000000000000000000000000000000000000000000 (wh_archer.png) wh_archer.png - wh_archer.png - wh_archer.png -10-10