You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and `tour` = 1' at line 1
А что разве в update() не предусмотрено использование and?
mysql_query('update `league_tours` set `points_1` = `points_1`+$point where `player_id1` = '.$res['player'].' and `tour` = '.$res['tour_id'].';') or die(mysql_error());