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
Ultimapanther-tamandua-2019-44-39352' 14" ago Francis FahysKevin Pacey
Shogipanther-tamandua-2019-44-39159' 7" ago Francis FahysKevin Pacey
Gross Chesssissa-ChessShogi-2019-61-8942 hours 27' ago Carlos CetinaAdam DeWitt
Gross Chesschappy-sacredchao-2019-61-8957 hours 17' ago John DavisJarid Carlson
Colossuscatugo-chappy-2019-61-9097 hours 20' ago John DavisAurelian Florea
Opulent Chessmageofmaple-cvgameroom-2019-81-5699 hours 6' ago Greg StrongJarid Carlson
Symmetric Chesssissa-cvgameroom-2019-33-66912 hours 22' ago Carlos CetinaKevin Pacey
Colossuswdtr2-panther-2019-61-90814 hours 12' ago wdtr2Kevin Pacey
Shakopanther-catugo-2019-44-40116 hours 31' ago Aurelian FloreaKevin Pacey
shako_balbopanther-catugo-2019-44-39816 hours 33' ago Aurelian FloreaKevin Pacey
Courier Chesspanther-catugo-2019-44-40216 hours 34' ago Aurelian FloreaKevin Pacey
Glinski's Hexagonal Chesspanther-catugo-2019-44-39516 hours 34' ago Aurelian FloreaKevin Pacey
Chess with Different Armiespanther-catugo-2019-44-39916 hours 37' ago Aurelian FloreaKevin Pacey
Tamerlane Chessliberty-cvgameroom-2019-19-10116 hours 38' ago Aurelian FloreaErin Pangborn
Tamerlane Chessliberty-cvgameroom-2019-8-96216 hours 42' ago Aurelian FloreaErin Pangborn
Chu Shogidax00-cvgameroom-2019-83-22720 hours 30' ago dax00Anyone
Capablanca Chesssacredchao-cvgameroom-2019-83-15522 hours 12' ago Jarid CarlsonAnyone
Makruk (Thai chess)tamandua-ramalam-2018-328-9561 day, 0 hours ago Francis Fahysdarren paull
Shogitamandua-ramalam-2019-63-1021 day, 0 hours ago Francis Fahysdarren paull
Chinese Chessarx-cvgameroom-2019-60-2321 day, 1 hour ago Jarid Carlsonarx
Yáng Qíper31-cvgameroom-2019-56-8741 day, 2 hours ago arxper hommerberg
Shakobigjohn-cvgameroom-2019-47-8381 day, 2 hours ago arxJohn Gallant
Tamerlane Chessliberty-cvgameroom-2019-22-0901 day, 6 hours ago Erin PangbornСергей Бугаевский
Capablanca Chesstrtztrtz-cvgameroom-2019-82-7231 day, 8 hours ago trtztrtz gfghAnyone
TenCubed Chessmageofmaple-cvgameroom-2019-81-8461 day, 10 hours ago Greg StrongСергей Бугаевский
Dragon Chesschessshogi-cvgameroom-2019-78-6091 day, 11 hours ago Adam DeWittСергей Бугаевский
Yangsichessshogi-cvgameroom-2019-12-0281 day, 11 hours ago Adam DeWittСергей Бугаевский
Chesssacredchao-cvgameroom-2019-82-4051 day, 16 hours ago Jarid CarlsonAnyone
Chesssacredchao-cvgameroom-2019-81-4251 day, 16 hours ago Jarid CarlsonСергей Бугаевский
Capablanca Chessper31-cvgameroom-2019-45-1981 day, 16 hours ago Сергей Бугаевскийper hommerberg
Capablanca Chessper31-cvgameroom-2018-348-8681 day, 16 hours ago Сергей Бугаевскийper hommerberg
Grand Chessper31-cvgameroom-2019-46-8441 day, 16 hours ago Сергей Бугаевскийper hommerberg
Glinski's Hexagonal Chesspanther-bigjohn-2019-49-0681 day, 21 hours ago Kevin PaceyJohn Gallant
Latrunculi XXIper31-cvgameroom-2019-68-8772 days, 9 hours ago Jose Carrilloper hommerberg
Symmetric Chessper31-cvgameroom-2019-56-8732 days, 11 hours ago Carlos Cetinaper hommerberg
Symmetric Chessper31-cvgameroom-2019-46-4162 days, 11 hours ago Carlos Cetinaper hommerberg
Embassy Chessper31-cvgameroom-2019-45-1982 days, 11 hours ago Adam DeWittper hommerberg
Chinese Chessper31-cvgameroom-2019-68-8792 days, 12 hours ago Aurelian Floreaper hommerberg
McCooey's Hexagonal Chesstim_olena-cvgameroom-2019-80-9923 days, 2 hours ago Tim O'LenaAnyone
Musketeer Chessphilippusr-cvgameroom-2019-59-5273 days, 18 hours ago Jarid Carlsonphilippusr
Gross Chessfergus-panther-2019-61-8923 days, 22 hours ago Kevin PaceyFergus Duniho
Musketeer Chessphilippusr-cvgameroom-2019-20-9953 days, 22 hours ago wdtr2philippusr
Colossusfergus-sissa-2019-61-9105 days, 15 hours ago Carlos CetinaFergus Duniho
Shogicyanide91-cvgameroom-2019-27-6356 days, 23 hours ago Aurelian FloreaToretto Toretto

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 > 1552957052 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