Go back
email mygames: how to I get them all in one file?

email mygames: how to I get them all in one file?

Help

Vote Up
Vote Down

Russ, is it right that the emailed games are sorted by the GameId?
So it is not so easy for me to get all my games into one pgn-file (as I have more than 200 finished games):
In the first email (100 games finished in the last 10000 days) the last GameId is 198532, but in the next mail (last 400 days or so, 100 games, there may be a a game with a lower Id before game 198532 that finished after this game.
so everything gets a bit wired...

easier: what happens here?

game 1 finished 10.5.2004
game 2 finished 13.5.2004
game 3 finished 12.5.2004
game 4 finished 10.5.2004
game 5 finished 15.5.2004

I want all games in the last 6 days, I get (limited to 3 games):
1,2,3 (and sorted that way!!!)

I want all games in the last 3 days, I get (limited to 3 games):
2,3,5

what I did (and does NOT work) is the following:
a) what is the id of the last game in the frist email? (answer: 3)
b) find gameid 3 in the 2nd mail (next game: 5) and copy all games after this in the final file.
the result will be: 1,2,3,5 (not good 🙁 )

Do you understand what I mean?
Can you propose me any solution?
th

1 edit
Vote Up
Vote Down

I haven't got a clue what you mean. 😳

This might have been better sent as a private message to Russ.

Vote Up
Vote Down

Originally posted by Exy
This might have been better sent as a private message to Russ.
how do you now? 😉

I have 201 finished games. I want them all (and none of them two times) in a single pgn-file. What do i have to do?

(please don't tell me "just go to myGames->Email MyGames" . this will work but not exactly. try to answer my questions like: how are the games sorted? what do you do to solve my (which meight be as well your) problem?), thanks,
th

Vote Up
Vote Down

basicly the problem is, that games are sorted by gameId but selected by date. this makes everything a bit complicated... 🙄
th

Vote Up
Vote Down

My problem is that I have been slack and have not emailed my earlier games to myself. Now I can't get any of my games prior to 100. So, what would be nice would be a bound that allows me to select games that had a last move between X and Y days ago.

Vote Up
Vote Down

no problem for RHP 😀
the solution: just enter that you want all games in the last 10000 days and he will send you the frist 100 games you played at RHP - okay?
th

Vote Up
Vote Down

has anyone an idea that helps me? :'(
games are sorted by id but the selection criterion is the last move's date. this causes problems...
thanks,
th

2 edits
Vote Up
Vote Down

Well, I don't know the structure of the database, but I'm sure an SQL statement can fit your needs.

I am guessing there is a table full of game IDs, players, and game status, and another table containing all of the FENs.

SELECT Games.GameID, Games.Player1, Games.Player2, FENs.FENValue, FENs.TimeStamp FROM Games, FENs WHERE ((Games.GameID = FENs.GameID) AND (Player1 = "thire" ) OR (Player2 = "thire" )) SORT BY


Bah, actually I give up... I don't know if it's possible with one SQL statement.

Vote Up
Vote Down

okay, I guess it's anything with SQL, but I am talking about the mailed pgn-files of all my games...
th

Vote Up
Vote Down

Yeah, but all the games are stored in a database, then, using an SQL statement (I hope) the required games are selected from the database and put in a PGN and e-mailed to you. So, if you are getting the e-mails OK, and the PGNs are OK, and the database is OK, all that leaves is the SQL statement that needs to change.