[TinCow1]

Originally Posted by bananalive

Just tested it, works for me.

It prevents same player challenging each other again within the time limit, after they both submit the scores.

Hmmm... definitely not working for me. I've tried it with test player accounts, and repeat challenges go through without anything blocking them using Match Finder.

Could this be related to another issue I'm having? If I turn on the Join User Tables to User Profile Tables option, I get the following error when looking at a tournament:

Database error in vBulletin 4.1.1:

Invalid SQL:

			SELECT
				players.*, players.username AS sname,
				user.username AS username, user.userid, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, user.username AS username
				, userfield.*, usertextfield.* 
			FROM nvb3_tmnt_players AS players 
			LEFT JOIN nvb3_user AS user ON (players.userid = user.userid) LEFT JOIN nvb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN nvb3_customavatar AS customavatar ON(customavatar.userid = user.userid) 
			 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
			WHERE tid = '18'
			ORDER BY slot ASC;

MySQL Error   : Table 'totalwar.userfield' doesn't exist
Error Number  : 1146
Request Date  : Monday, April 18th 2011 @ 12:04:43 PM
Error Date    : Monday, April 18th 2011 @ 12:04:43 PM
Script        : http://forums.totalwar.org/vb/tournaments.php?do=view&id=18
Referrer      : http://forums.totalwar.org/vb/tournaments.php?c=7
IP Address    : 152.130.15.14
Username      : TinCow
Classname     : vB_Database
MySQL Version : 5.0.77

That option isn't very important to me so I haven't put much effort into trying to troubleshoot it, but perhaps it's indicative of a problem that is also impacting the re-challenge time limit.

Also, in case you missed it, I would love to have that {steamid} addition for the Ladders/Leagues displays as well. My members think it is great and it would get used for ladder play.