void vegadb::SetPairingNumbers(int n, int arr_N[], Vector<int> ids)
{ 	int i, id, idp, np=1;
	Sql sqlteam(sqliteVT);
	Sql sqlplayer(sqliteVT);
	Sql sqlp(sqliteVT);

 	for(i=0; i<n; i++) {
 	    id = arr_N[i];
	    sqlteam.Execute("update TEAMS set N=? where ID=?", i+1, ids[i]); 
            sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", id); //retrieve players of team id by boards
	    while (sqlplayer.Fetch()) {
			idp = (int) (sqlplayer[0]);
		        sqlp.Execute("update PLAYERS set N=? where ID=?", np++, idp); //set pairing number to the player idp
	    }      
	}
}