The Chess Variant Pages
Custom Search



Your Active Game Logs + Open Invitations

Listed below are your Game Courier logs plus open invitations. The open invitations were not directed specifically to you, but you are free to accept any of them while they last. To accept an invitation, whether open or personal, click on the link in the Next Move For column, fill out the form with your userid and password, and submit it.

Game:
Age:
Status:
Log:
Tournament:
Sort by:
Userid:

GameLogLast ModifiedLast Move byNext Move for
Chu Shogicatugo-dax00-2019-110-40328' 51" ago dax00Aurelian Florea
Chu Shogicatugo-dax00-2019-110-40529' 23" ago dax00Aurelian Florea
Chu Shogicatugo-dax00-2019-110-40129' 43" ago dax00Aurelian Florea
Gocatugo-dax00-2019-110-28831' 25" ago dax00Aurelian Florea
Gocatugo-dax00-2019-110-28932' 29" ago dax00Aurelian Florea
Gocatugo-dax00-2019-110-29033' 19" ago dax00Aurelian Florea
Capablanca Chesstrtztrtz-cvgameroom-2019-82-7233 hours 8' ago trtztrtz gfghKevin Pacey
Shakosxg-cvgameroom-2019-99-3306 hours 12' ago Aurelian Floreasxg
Marseillais Chessper31-cvgameroom-2019-102-6158 hours 23' ago wdtr2per hommerberg
Embassy Chessper31-cvgameroom-2019-98-8189 hours 17' ago per hommerbergKevin Pacey
Crazyhouseper31-cvgameroom-2019-103-3129 hours 18' ago per hommerbergKevin Pacey
Shogipanther-tamandua-2019-109-2009 hours 58' ago Kevin PaceyFrancis Fahys
Colossuscatugo-chappy-2019-61-90911 hours 9' ago Aurelian FloreaJohn Davis
Shogitamandua-ramalam-2019-63-10219 hours 47' ago Francis Fahysdarren paull
Cataclysmmageofmaple-cvgameroom-2019-96-9521 day, 2 hours ago Greg Strongsxg
Grand Betzasxg-cvgameroom-2019-98-4231 day, 2 hours ago Greg Strongsxg
Tamerlane Chessneuropyramidal-liberty-2019-87-6591 day, 2 hours ago Greg MyersErin Pangborn
Tamerlane Chessliberty-cvgameroom-2019-19-1011 day, 2 hours ago Aurelian FloreaErin Pangborn
Tamerlane Chessliberty-cvgameroom-2019-8-9621 day, 2 hours ago Aurelian FloreaErin Pangborn
Grand Tamerlanesxg-cvgameroom-2019-98-4241 day, 2 hours ago Aurelian Floreasxg
Symmetric Chessper31-cvgameroom-2019-98-8181 day, 8 hours ago per hommerbergCarlos Cetina
Grand Chessper31-cvgameroom-2019-98-8171 day, 8 hours ago per hommerbergsxg
Embassy Chessper31-cvgameroom-2018-348-8681 day, 8 hours ago per hommerbergsxg
Capablanca Chessper31-cvgameroom-2019-98-8171 day, 8 hours ago per hommerbergsxg
Symmetric Chesssissa-cvgameroom-2019-85-7321 day, 8 hours ago per hommerbergCarlos Cetina
Gigachesssxg-cvgameroom-2019-98-4161 day, 11 hours ago Aurelian Floreasxg
Maximapanther-tamandua-2019-109-2071 day, 12 hours ago Kevin PaceyFrancis Fahys
Ultimapanther-tamandua-2019-109-2051 day, 12 hours ago Kevin PaceyFrancis Fahys
Janggipanther-tamandua-2019-109-2041 day, 12 hours ago Kevin PaceyFrancis Fahys
Chinese Chesspanther-tamandua-2019-109-2021 day, 12 hours ago Kevin PaceyFrancis Fahys
Shakobigjohn-cvgameroom-2019-47-8381 day, 12 hours ago arxJohn Gallant
Crazyhousepanther-dax00-2019-109-1981 day, 12 hours ago Kevin Paceydax00
Chinese Chesspanther-dax00-2019-109-1971 day, 12 hours ago Kevin Paceydax00
Courier Chesspanther-dax00-2019-109-1951 day, 12 hours ago Kevin Paceydax00
Pocket Shogi Copperpanther-dax00-2019-109-1931 day, 12 hours ago Kevin Paceydax00
Shogipanther-dax00-2019-109-1911 day, 12 hours ago Kevin Paceydax00
Shogisxg-cvgameroom-2019-101-3551 day, 13 hours ago wdtr2sxg
Symmetric Chesssissa-cvgameroom-2019-99-6191 day, 15 hours ago Kevin PaceyCarlos Cetina
Symmetric Chesssissa-cvgameroom-2019-99-6201 day, 15 hours ago Kevin PaceyCarlos Cetina
Symmetric Chesssissa-cvgameroom-2019-76-7461 day, 15 hours ago Kevin PaceyCarlos Cetina
Opulent Chesssxg-cvgameroom-2019-100-6371 day, 15 hours ago Kevin Paceysxg
Sac Chesssxg-cvgameroom-2019-97-4541 day, 15 hours ago Kevin Paceysxg
Tamerlane Chessneuropyramidal-cvgameroom-2019-87-6601 day, 20 hours ago Greg Myerssxg
Simple Ecumenical Chesssxg-cvgameroom-2019-100-6391 day, 21 hours ago Jarid Carlsonsxg
Reinforcement Ecumenical ...sxg-cvgameroom-2019-100-6851 day, 21 hours ago Jarid Carlsonsxg
Shogisxg-cvgameroom-2019-101-3561 day, 21 hours ago Jarid Carlsonsxg
Almost Chesssxg-cvgameroom-2019-100-6541 day, 21 hours ago Jarid Carlsonsxg
Grand Combination Couriersxg-cvgameroom-2019-100-6801 day, 21 hours ago Jarid Carlsonsxg
Cardinal Chesssxg-cvgameroom-2019-100-6511 day, 21 hours ago Jarid Carlsonsxg
Gilded Grand Shatranjsxg-cvgameroom-2019-98-4231 day, 21 hours ago Jarid Carlsonsxg
Colossussxg-cvgameroom-2019-97-4551 day, 21 hours ago Jarid Carlsonsxg
Grand Shatranjsxg-cvgameroom-2019-98-4221 day, 21 hours ago Jarid Carlsonsxg
Symmetric Chesssissa-cvgameroom-2019-108-7771 day, 22 hours ago Carlos CetinaAnyone
Symmetric Chesssissa-cvgameroom-2019-108-7761 day, 22 hours ago Carlos CetinaAnyone
Symmetric Chesssissa-cvgameroom-2019-85-7331 day, 22 hours ago Carlos Cetinasxg
Chu Shogisxg-cvgameroom-2019-98-8812 days, 4 hours ago Aurelian Floreasxg
Chu Shogisxg-cvgameroom-2019-98-8802 days, 4 hours ago Aurelian Floreasxg
Colossusfergus-sissa-2019-61-9102 days, 14 hours ago Carlos CetinaFergus Duniho
Gross Chessfergus-panther-2019-61-8922 days, 14 hours ago Kevin PaceyFergus Duniho
Chu Shogidax00-cvgameroom-2019-97-5726 days, 3 hours ago dax00sxg
Gross Chesssxg-cvgameroom-2019-97-4446 days, 11 hours ago Aurelian Floreasxg

MySQL

This script queried the GameLogs table with the following prepared query:

SELECT * FROM GameLogs WHERE Lastmod > :earliest AND Priority > 0 AND Privacy = :privacy ORDER BY Lastmod DESC

To avoid SQL injection, most of the values are passed separately. The values in the query are determined by the values in your URL's query string or by what is entered into the form at top. When you leave a field blank, it normally means that it will leave that field out of the query, not that it will search for an empty value. Here is a recreation of what the SQL query would look like with the placeholders replaced by the values:

SELECT * FROM GameLogs WHERE Lastmod > 1555259621 AND Priority > 0 AND Privacy = 0 ORDER BY Lastmod DESC

The underlying MySQL is handled by MariaDB. A few fields give you multiple options for how to use them. You can search for an exact string match, an exact non-match, a LIKE match, which allows the use of a few wildcards, and a REGEXP match, which allows for very complicated pattern matching. Since these may slow down the search, they should be avoided unless you have a special need for them.

Filtering by Userid

If you enter a userid, it will list only those games in which that id identifies one of the players. Under the Next Move for column, for each game in which it is that user's turn to move, it will include a link for him to go to the PBM and make his next move. If a given user is playing any games that are not open to public view, he will need to enter his password to view these games on this page. If all your games are publicly viewable, then you don't need to include your password on this page.

How to Delete a Log

To get links for deleting logs, you must first enter a userid. To delete a log, you must be one of the players listed in the log. When you click on the link to delete a log, you will be asked for your password. Enter it and click on the Delete button. If your userid matches one of the players, and if your password is correct, the log will be deleted.


Written by Fergus Duniho
WWW Page Created: 21 July 2017