Author |
Topic: Duplicate game (Read 1404 times) |
|
Fritzlein
Forum Guru
Arimaa player #706
Gender: 
Posts: 5928
|
 |
Duplicate game
« on: Aug 16th, 2005, 8:07pm » |
 Quote  Modify
|
Omar, the server appears to have recorded the same game as both 18024 and 18025. The duplicate should be removed so as not to skew the statistics, particularly since it counts for determining the defenders of the Challenge.
|
|
 IP Logged |
|
|
|
omar
Forum Guru
Arimaa player #2
Gender:
Posts: 1003
|
|
Re: Duplicate game
« Reply #1 on: Aug 16th, 2005, 11:34pm » |
Quote Modify
|
Thanks for pointing that out. I've deleted 18025.
|
|
IP Logged |
|
|
|
aaaa
Forum Guru
Arimaa player #958
Posts: 768
|
|
Re: Duplicate game
« Reply #2 on: Jul 14th, 2008, 11:42am » |
Quote Modify
|
Here's another pair: 79727 and 79728.
Please don't accidentally delete both of them, as I would like to keep the record that I successfully beat four blitz bots in a simul. 
|
|
IP Logged |
|
|
|
Fritzlein
Forum Guru
Arimaa player #706
Gender:
Posts: 5928
|
|
Re: Duplicate game
« Reply #3 on: Jul 14th, 2008, 6:48pm » |
Quote Modify
|
Congratulations, masked man. This exploit definitely deserves a place somewhere in the botbashing Hall of Fame.
|
|
IP Logged |
|
|
|
Arimabuff
Forum Guru
Arimaa player #2764
Gender:
Posts: 589
|
|
Re: Duplicate game
« Reply #4 on: Jul 15th, 2008, 6:11am » |
Quote Modify
|
on Jul 14th, 2008, 6:48pm, Fritzlein wrote:| Congratulations, masked man. This exploit definitely deserves a place somewhere in the botbashing Hall of Fame. |
|
I already said that. 
|
|
IP Logged |
|
|
|
Fritzlein
Forum Guru
Arimaa player #706
Gender:
Posts: 5928
|
|
Re: Duplicate game
« Reply #5 on: Jul 15th, 2008, 6:19am » |
Quote Modify
|
on Jul 15th, 2008, 6:11am, Arimabuff wrote:
I already said that. |
|
Imitation is the sincerest form of flattery.
|
|
IP Logged |
|
|
|
omar
Forum Guru
Arimaa player #2
Gender:
Posts: 1003
|
|
Re: Duplicate game
« Reply #6 on: Jul 22nd, 2008, 8:03am » |
Quote Modify
|
on Jul 14th, 2008, 11:42am, aaaa wrote:Here's another pair: 79727 and 79728.
Please don't accidentally delete both of them, as I would like to keep the record that I successfully beat four blitz bots in a simul. |
|
Thanks, I've deleted game 79728.
|
|
IP Logged |
|
|
|
Fritzlein
Forum Guru
Arimaa player #706
Gender:
Posts: 5928
|
|
Re: Duplicate game
« Reply #7 on: Jul 22nd, 2008, 12:40pm » |
Quote Modify
|
Thanks, Omar. This inspired me to go clean the duplicates out of my database, which I apparently haven't done for about 50,000 games. The redundant records I found were:
31099 = 31100
31947 = 31948
35973 = 35974
38976 = 38977
40094 = 40095
41092 = 41093
67404 = 67405
75760 = 75761
76007 = 76008
78288 = 78289
79365 = 79366
Whatever you did to fix the duplicate records these many years ago apparently still doesn't work in times of stress, as evidenced by the high density of duplicates when aaaa was playing his blitz simuls.
|
|
IP Logged |
|
|
|
aaaa
Forum Guru
Arimaa player #958
Posts: 768
|
|
Re: Duplicate game
« Reply #8 on: Jul 22nd, 2008, 3:34pm » |
Quote Modify
|
There actually was another anomaly during that successful blitz of mine. When I made the winning move against one of the bots (I believe it was in a different game than the one that got duplicated), it seemed it didn't get through; but when I tried to resend it, the game was no longer in session, i.e. the move did came through and had closed it.
|
|
IP Logged |
|
|
|
omar
Forum Guru
Arimaa player #2
Gender:
Posts: 1003
|
|
Re: Duplicate game
« Reply #9 on: Jul 22nd, 2008, 9:09pm » |
Quote Modify
|
Thanks Karl you save me some work. I was thinking of writing a script to find duplicate games. How did you find them so quickly?
I've deleted the higher numbered game in each duplicate.
|
|
IP Logged |
|
|
|
Fritzlein
Forum Guru
Arimaa player #706
Gender:
Posts: 5928
|
|
Re: Duplicate game
« Reply #10 on: Jul 23rd, 2008, 5:29am » |
Quote Modify
|
on Jul 22nd, 2008, 9:09pm, omar wrote:| How did you find them so quickly? |
|
MS Access query grouped by all fields
Quote:| I've deleted the higher numbered game in each duplicate. |
|
Thank you!
|
|
IP Logged |
|
|
|
The_Jeh
Forum Guru
Arimaa player #634
Gender:
Posts: 460
|
|
Re: Duplicate game
« Reply #11 on: Jul 24th, 2008, 10:34pm » |
Quote Modify
|
I'm afraid I just created a duplicate game somehow. Game 80411 is the same as 80410 and should be deleted. Interestingly, game 80410 is shown as being played after game 80411 in the recent games list, while it appears in the correct order on OpFor's recent games list.
|
| « Last Edit: Jul 24th, 2008, 10:37pm by The_Jeh » |
IP Logged |
|
|
|
omar
Forum Guru
Arimaa player #2
Gender:
Posts: 1003
|
|
Re: Duplicate game
« Reply #12 on: Jul 27th, 2008, 6:03am » |
Quote Modify
|
Thanks. I've removed it. I've put in some logging to trace what might be causing this. If anyone notices another duplicate please let me know.
|
|
IP Logged |
|
|
|
camelback
Forum Guru
Arimaa perl monger
Gender:
Posts: 144
|
|
Re: Duplicate game
« Reply #13 on: Jul 27th, 2008, 11:03am » |
Quote Modify
|
Here is another duplicate entry (old game not new).
45800 and 45801
|
|
IP Logged |
|
|
|
Fritzlein
Forum Guru
Arimaa player #706
Gender:
Posts: 5928
|
|
Re: Duplicate game
« Reply #14 on: Jul 27th, 2008, 2:34pm » |
Quote Modify
|
Thanks, camelback. I was wondering how my query could have missed that duplicate you gave. It turns out that I was requiring the ratings to be identical on the two records, which won't happen for rated games. The ratings got adjusted between game 45800 and game 45801.
I have fixed my query and found 19 more duplicates:
37084 37085
44612 44613
46896 46897
47969 47970
57755 57756
58004 58005
59914 59915
61794 61795
62847 62848
68192 68193
68376 68377
68494 68495
68672 68673
69426 69427
69768 69769
69835 69836
72058 72059
78086 78087
78163 78164
|
| « Last Edit: Jul 27th, 2008, 3:05pm by Fritzlein » |
IP Logged |
|
|
|
|
Home
Help
Search
Members
Login
Register
Reply
Notify of replies
Send Topic
Print