Check out Glinski's Hexagonal Chess, our featured variant for May, 2024.

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 Shogichessshogi-cvgameroom-2024-143-0266' 42" ago A. DeWittDaniel Zacharias
Great Shatranjarx-cvgameroom-2024-121-09228' 4" ago Omnia NihiloDaniel Zacharias
Kamikaze Mortal Shogimakov333-cvgameroom-2024-122-48147' 2" ago Vitya Makovwdtr2
Modern Chinese Chessmakov333-cvgameroom-2024-138-93553' 45" ago Vitya MakovDaniel Zacharias
Obento Chessarx-timurthelenk-2024-103-8541 hour 33' ago Daniel ZachariasJean-Louis Cazaux
Xhessarx-cvgameroom-2024-137-8781 hour 50' ago Daniel Zachariaswdtr2
Courier Spielunspeakablegamer-cvgameroom-2024-111-7191 hour 54' ago Daniel ZachariasSimon R
Overboardarx-cvgameroom-2024-132-9441 hour 55' ago Daniel Zachariaswdtr2
Timuridtimurthelenk-numerist-2024-116-4752 hours 7' ago Jean-Louis CazauxPaul Rapoport
Pocket Shogi Coppermakov333-cvgameroom-2024-122-4844 hours 37' ago Vitya Makovwdtr2
Millennial Chessarx-cvgameroom-2024-87-8359 hours 53' ago Daniel ZachariasVitya Makov
Opulent Lemurian Shatranjarx-cvgameroom-2024-126-7209 hours 56' ago Daniel ZachariasBob Greenwade
Dai Seireigichessshogi-bobgreenwade-2024-103-63811 hours 39' ago A. DeWittBob Greenwade
Modern Chinese Chessmakov333-cvgameroom-2024-88-86216 hours 35' ago Daniel ZachariasVitya Makov
Grant Acedrexmakov333-cvgameroom-2024-134-48516 hours 38' ago Daniel ZachariasVitya Makov
Kamikaze Mortal Shogimakov333-cvgameroom-2024-143-89717 hours 39' ago Vitya MakovAnyone
Grand Apothecary Chess 3arx-catugo-2024-128-95121 hours 21' ago Daniel ZachariasAurelian Florea
Bigorraarx-cvgameroom-2024-107-03321 hours 30' ago Daniel ZachariasAurelian Florea
Megalomachycatugo-arx-2024-113-67221 hours 36' ago Daniel ZachariasAurelian Florea
Grant Acedrexmakov333-cvgameroom-2024-58-0071 day, 18 hours ago Vitya MakovDiceroller Fire
Chinese Chess with Sparrowmakov333-cvgameroom-2024-116-9342 days, 16 hours ago Vitya MakovDiceroller Fire
Jungles and Mountains Che...makov333-cvgameroom-2024-59-4872 days, 20 hours ago Vitya MakovDiceroller Fire
Reche’s Super Faceoff M...cryinto-cvgameroom-2024-111-3732 days, 21 hours ago Daniel ZachariasDiceroller Fire
Throne Chesscryinto-cvgameroom-2024-111-4242 days, 21 hours ago Daniel ZachariasDiceroller Fire
InSteæd (Third Knight) C...cryinto-cvgameroom-2024-132-5382 days, 21 hours ago Daniel ZachariasDiceroller Fire
Glinski's Hexagonal Chessarx-cvgameroom-2024-140-5682 days, 21 hours ago Daniel ZachariasDiceroller Fire
Equal Modern Republican C...cryinto-cvgameroom-2024-111-3942 days, 22 hours ago Bob GreenwadeDiceroller Fire
CC Topdegenschess66-cvgameroom-2024-107-4443 days, 0 hours ago Gerd DegensDiceroller Fire
Petteia XXIunspeakablegamer-cvgameroom-2024-130-8363 days, 6 hours ago Simon RDiceroller Fire

MySQL

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

SELECT * FROM GameLogs WHERE Lastmod > :earliest AND Priority > 0 AND (Privacy = :privacy OR Opponent = '' OR Opponent IS NULL) 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 > 1715955088 AND Priority > 0 AND (Privacy = 0 OR Opponent = '' OR Opponent IS NULL) 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