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

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

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

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

Originally posted by Exy
This might have been better sent as a private message to Russ.

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

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.

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

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

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.

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

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.