Adapted brackets.php, register.php and controlpanel.php for the new members and teams tables, using a mix of UID and TID instead of a unique PID (Participant ID).
Quickly tested, should work. The files are already live.
Changed in the DB:
table battles
field player1 is now BIGINT (to store a UID)
field player2 is now BIGINT (to store a UID)
field winner is now TINYINT (as it should always have been, since it can only be 0, 1 or 2)
Replaced the PIDs for TID 14 with the corresponding UIDs.
Adapted brackets.php, register.php and controlpanel.php for the new members and teams tables, using a mix of UID and TID instead of a unique PID (Participant ID).
Quickly tested, should work. The files are already live.
Changed in the DB: table battles