Females Per Team
Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 0
[12] => 0
[13] => 0
[14] => 0
[15] => 0
[16] => 0
[17] => 0
[18] => 0
[19] => 0
[20] => 0
[21] => 0
[22] => 0
[23] => 0
[24] => 0
[25] => 0
[26] => 0
[27] => 0
[28] => 0
[29] => 0
[30] => 0
[31] => 0
[32] => 0
[33] => 0
[34] => 0
[35] => 0
[36] => 0
[37] => 0
[38] => 0
[39] => 0
[40] => 0
[41] => 0
[42] => 0
[43] => 0
[44] => 0
[45] => 0
[46] => 0
[47] => 0
[48] => 0
[49] => 0
[50] => 0
[51] => 0
[52] => 0
[53] => 0
[54] => 0
[55] => 0
[56] => 0
[57] => 0
[58] => 0
[59] => 0
[60] => 0
[61] => 0
[62] => 0
[63] => 0
[64] => 0
[65] => 0
[66] => 0
[67] => 0
[68] => 0
[69] => 0
[70] => 0
[71] => 0
[72] => 0
[73] => 0
[74] => 0
[75] => 0
[76] => 0
[77] => 0
[78] => 0
[79] => 0
[80] => 0
[81] => 0
[82] => 0
[83] => 0
[84] => 0
[85] => 0
[86] => 0
[87] => 0
[88] => 0
[89] => 0
[90] => 0
[91] => 0
[92] => 0
[93] => 0
[94] => 0
[95] => 0
[96] => 0
[97] => 0
[98] => 0
[99] => 0
[100] => 0
[101] => 0
[102] => 0
[103] => 0
[104] => 0
[105] => 0
[106] => 0
[107] => 0
[108] => 0
[109] => 0
[110] => 0
)
Connected successfully
Max females this round 2
Team Order
Array
(
[0] => 86
[1] => 17
[2] => 79
[3] => 39
[4] => 64
[5] => 94
[6] => 3
[7] => 52
[8] => 29
[9] => 22
[10] => 69
[11] => 16
[12] => 90
[13] => 28
[14] => 44
[15] => 50
[16] => 27
[17] => 30
[18] => 40
[19] => 49
[20] => 91
[21] => 70
[22] => 73
[23] => 20
[24] => 110
[25] => 60
[26] => 21
[27] => 55
[28] => 83
[29] => 76
[30] => 63
[31] => 81
[32] => 80
[33] => 93
[34] => 84
[35] => 96
[36] => 23
[37] => 32
[38] => 68
[39] => 6
[40] => 100
[41] => 19
[42] => 26
[43] => 36
[44] => 75
[45] => 92
[46] => 35
[47] => 12
[48] => 48
[49] => 13
[50] => 59
[51] => 54
[52] => 85
[53] => 89
[54] => 105
[55] => 37
[56] => 51
[57] => 87
[58] => 31
[59] => 11
[60] => 9
[61] => 14
[62] => 42
[63] => 45
[64] => 5
[65] => 82
[66] => 71
[67] => 78
[68] => 56
[69] => 88
[70] => 18
[71] => 61
[72] => 53
[73] => 4
[74] => 104
[75] => 72
[76] => 24
[77] => 98
[78] => 10
[79] => 95
[80] => 33
[81] => 7
[82] => 101
[83] => 58
[84] => 67
[85] => 107
[86] => 66
[87] => 74
[88] => 109
[89] => 111
[90] => 62
[91] => 25
[92] => 77
[93] => 46
[94] => 15
[95] => 57
[96] => 2
[97] => 106
[98] => 108
[99] => 103
[100] => 34
[101] => 97
[102] => 43
[103] => 38
[104] => 99
[105] => 102
[106] => 65
[107] => 1
[108] => 47
[109] => 8
[110] => 41
)
SELECT * FROM players WHERE primaryPosition = 'P' AND assignedTeam = false ORDER BY RAND() LIMIT 111
Selected 111 players for position P
Shawna Cavender | Sex: Female
Hannah Daly | Sex: Female
Minerva Gamez | Sex: Female
Season McClelland | Sex: Female
Carly Anderson | Sex: Female
Arlet Okimoto | Sex: Female
Mandy Dantuono | Sex: Female
Jennifer Eberhard | Sex: Female
Jamie Priest | Sex: Female
Justine Kinsman | Sex: Female
Casady Marlnee | Sex: Female
Lashawn Lashawn Haywood | Sex: Female
Tammy Dettman | Sex: Female
Tammy Mcdougall | Sex: Female
Jessica Dorn | Sex: Female
Tracy Byers | Sex: Male
CJ RHODES | Sex: Male
Dave Holland | Sex: Male
Randy Labbato | Sex: Male
Shaun Tabon | Sex: Male
David Quintana | Sex: Male
Joel Salazar | Sex: Male
bill schmidt | Sex: Male
Matthew MELENDEZ | Sex: Male
Spencer Greer | Sex: Male
Cole Patterson | Sex: Male
Elbert Stewart | Sex: Male
Andrew Andrade | Sex: Male
Paul Harder II | Sex: Male
Logan Boyd | Sex: Male
Jeff Paul | Sex: Male
Hunter Kent | Sex: Male
Irving Macias | Sex: Male
Brian Hough | Sex: Male
Randle Atkinson | Sex: Male
Chris Licurse | Sex: Male
Jeffrey Yeakel | Sex: Male
Thomas Arnold | Sex: Male
Charles Peña | Sex: Male
Steve Needles | Sex: Male
Ramon Halsell | Sex: Male
Chris Farros | Sex: Male
Dylan Marshall | Sex: Male
Jesse Grindstaff | Sex: Male
Felipe Zepeda | Sex: Male
Hunter Kent | Sex: Male
Austin Hoxsie | Sex: Male
Scott Stone | Sex: Male
bill schmidt | Sex: Male
Ereck Rufus | Sex: Male
Michael Martin | Sex: Male
Edgar Corralejo | Sex: Male
Danny Gullett | Sex: Male
Brian Fletcher | Sex: Male
scott kinrade | Sex: Male
Ricky SHADOWENS | Sex: Male
Joshua Orton | Sex: Male
Randy Hodges | Sex: Male
Zac Polk | Sex: Male
Erick Carranza | Sex: Male
Mark Hall | Sex: Male
cody weber | Sex: Male
Garrett Dixon | Sex: Male
Dj Wenger | Sex: Male
John Privitera | Sex: Male
Lance Chmielewski | Sex: Male
Garrett Dixon | Sex: Male
Zachary Halferty | Sex: Male
Justin Mackiewicz | Sex: Male
Jack Kuhnast | Sex: Male
Terrance Russell | Sex: Male
Jesus Alvalle | Sex: Male
Matthew Houghton | Sex: Male
Eddie Hernandez | Sex: Male
Thai Huynh | Sex: Male
Lee Davidson | Sex: Male
Miguel Vargas | Sex: Male
Stephen Lentsch | Sex: Male
Caleb askew | Sex: Male
Brandon Plumb | Sex: Male
Eric Cuneo | Sex: Male
Tracy Harris | Sex: Male
Zach Whitman | Sex: Male
Prabhjot Narula | Sex: Male
Dale Ballejos | Sex: Male
Bryce Davis | Sex: Male
Burl Shealy | Sex: Male
James Ellis | Sex: Male
SHAWN KRANTZ | Sex: Male
Kevin Birner | Sex: Male
Kurt Schomaker | Sex: Male
Paul Mitchell | Sex: Male
Kevin Solis | Sex: Male
Rogelio Salinas | Sex: Male
Stryder Lindsey | Sex: Male
TJ Miller | Sex: Male
Quillan Ogle | Sex: Male
Mark Miller | Sex: Male
Martinez Jernigan | Sex: Male
William Paul | Sex: Male
Carlos Mayoral | Sex: Male
Kyle Maurer | Sex: Male
Michael Halvorson | Sex: Male
Jt Ortiz | Sex: Male
Kevin Burton | Sex: Male
Antonio Thompson | Sex: Male
Patrick Goedecke | Sex: Male
Chris Perez | Sex: Male
Matthew Nave | Sex: Male
Joshua Lang | Sex: Male
Larry Best | Sex: Male
Checking if female can be assigned to team (86)
OK to add female.
INSERT INTO team_rosters (teamID, tournamentID, playerID, firstName, lastName, primaryPosition, secondaryPosition, sex)
VALUES ('86', '1', '3935', 'Shawna', 'Cavender', 'P', '1B', 'Female')