 |
View Old Forum Thread
Old Forum Index » Baseball Beta Testing » Beta News » Trade Restrictions in Free Leagues
Admin
Please execute some trades in the trial leagues to make sure I haven't broken anything. If you want to test the restriction, log in as betauser then try to make a trade between your team and betauser's team.
Tyson
Trade Restrictions in Free Leagues
March 10, 2009 at 09:32PM View BBCode
Due to all the recent problems with collusion, we have put in a restriction that trades can't be executed between people who have accessed the team from the same IP address in the last 90 days.Please execute some trades in the trial leagues to make sure I haven't broken anything. If you want to test the restriction, log in as betauser then try to make a trade between your team and betauser's team.
Tyson
tjfla2
I signed in as betauser and tried to make a trade with my team and got this message
*** SQLException caught *** ERROR: There was an error processing your trade. Please report the message below on the Message Boards so the trade can be fixed.
query: select ownerlogin_id from ownerlogin, teamowner where ownerlogin_owner_id = teamowner_owner_id and teamowner_team_id = 36351 and ownerlogin_timestamp > now() - interval 90 DAYS and teamowner_active = 1 and ownerlogin_ip in (select ownerlogin_ip from ownerlogin, teamowner where ownerlogin_owner_id = teamowner_owner_id and teamowner_active = 1 and teamowner_team_id = 36352 and ownerlogin_timestamp > now() - interval 90 DAYS) Syntax error or access violation message from server: "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 'DAYS and teamowner_active = 1 and ownerlogin_ip in (select ownerlogin_ip from ow' at line 1" query2: debuginfo
[Edited on 3-10-2009 by tjfla2]
March 10, 2009 at 09:48PM View BBCode
Looks good I tried it (Gonna have some angry cheaters)I signed in as betauser and tried to make a trade with my team and got this message
*** SQLException caught *** ERROR: There was an error processing your trade. Please report the message below on the Message Boards so the trade can be fixed.
query: select ownerlogin_id from ownerlogin, teamowner where ownerlogin_owner_id = teamowner_owner_id and teamowner_team_id = 36351 and ownerlogin_timestamp > now() - interval 90 DAYS and teamowner_active = 1 and ownerlogin_ip in (select ownerlogin_ip from ownerlogin, teamowner where ownerlogin_owner_id = teamowner_owner_id and teamowner_active = 1 and teamowner_team_id = 36352 and ownerlogin_timestamp > now() - interval 90 DAYS) Syntax error or access violation message from server: "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 'DAYS and teamowner_active = 1 and ownerlogin_ip in (select ownerlogin_ip from ow' at line 1" query2: debuginfo
[Edited on 3-10-2009 by tjfla2]
jetpac
March 10, 2009 at 10:15PM View BBCode
that doesn't exactly look like a user-friendly error message, but I like the idea.
tjfla2
March 10, 2009 at 10:18PM View BBCode
Ya not user friendly but I got the point FAST. All it means is you are gonna have a ton of guys at the beginning of every season asking why they got the message and then u also will know who is cheating.
Admin
ERROR: Sorry, we do not allow trades in free leagues between people who have accessed their accounts from the same ip address.
We apologize if this logic has falsely identified you as the same person, but we have to be strict on this because of all the cheating that has gone on in the past. Sorry, there are no exceptions. We do not have this restriction in our pay leagues.
Tyson
March 11, 2009 at 03:11PM View BBCode
There was a bug in the code that gave that error message everytime. I've fixed it and tested it, it looks good. Here's the proper error message:ERROR: Sorry, we do not allow trades in free leagues between people who have accessed their accounts from the same ip address.
We apologize if this logic has falsely identified you as the same person, but we have to be strict on this because of all the cheating that has gone on in the past. Sorry, there are no exceptions. We do not have this restriction in our pay leagues.
Tyson
tjfla2
Can get the cheaters red handed when they say they tried to make a trade and got this:lol:
March 11, 2009 at 03:18PM View BBCode
Looks good and works good. I still like the first message that said report this message on the message board.Can get the cheaters red handed when they say they tried to make a trade and got this:lol:
Pages: 1