Closed tuminoid closed 8 years ago
ie. in addcompetitor page when search is empty you call _$players = GetPlayerUsers($query, '', $has_pdganumber); and that function makes queries to User table.
User and Player are in way too close symbiosis, and part of the data is duplicated, wrong place etc. They have to be rethought at some point. Being very central to everything, migration to any other scheme is going to be super hard.
Closing this for now.
Related to competitions, a Player table entry should be used instead of User. Check all usage cases, especially AJAX autocompletes.