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
Shosu Shogimakov333-cvgameroom-2024-122-48446' 38" ago Vitya MakovA. DeWitt
Pocket Shogi Coppermakov333-cvgameroom-2024-122-48446' 54" ago Vitya Makovwdtr2
Seireigichessshogi-cvgameroom-2024-120-6681 hour 24' ago A. DeWittwdtr2
Timuridtimurthelenk-numerist-2024-116-4752 hours 46' ago Paul RapoportJean-Louis Cazaux
Obento Chessarx-timurthelenk-2024-103-8542 hours 59' ago Jean-Louis CazauxDaniel Zacharias
Grant Acedrexmakov333-cvgameroom-2024-134-4853 hours 47' ago Vitya MakovDaniel Zacharias
Kamikaze Mortal Shogimakov333-cvgameroom-2024-122-4813 hours 48' ago Vitya Makovwdtr2
Dai Seireigichessshogi-bobgreenwade-2024-103-63811 hours 14' ago A. DeWittBob Greenwade
Chu Seireigichessshogi-cvgameroom-2024-103-76211 hours 19' ago A. DeWittDaniel Zacharias
Champagne Chesspanther-joejoyce-2024-29-95717 hours 58' ago Kevin PaceyJoe Joyce
Wildebeest Chesspokshtya-cvgameroom-2024-129-31719 hours 11' ago Вадря ПокштяDaniel Zacharias
Courier Spielunspeakablegamer-cvgameroom-2024-111-71919 hours 16' ago Simon RDaniel Zacharias
Great Shatranjarx-cvgameroom-2024-121-09219 hours 25' ago Omnia NihiloDaniel Zacharias
Modern Chinese Chessmakov333-cvgameroom-2024-128-00120 hours 10' ago Vitya MakovDaniel Zacharias
Shatranjimakov333-cvgameroom-2024-122-48320 hours 11' ago Vitya MakovDaniel Zacharias
Reche’s Super Faceoff M...cryinto-cvgameroom-2024-111-37320 hours 20' ago Daniel ZachariasDiceroller Fire
Throne Chesscryinto-cvgameroom-2024-111-42420 hours 21' ago Daniel ZachariasDiceroller Fire
InSteæd (Third Knight) C...cryinto-cvgameroom-2024-132-53820 hours 21' ago Daniel ZachariasDiceroller Fire
Grand Apothecary Chess 3arx-catugo-2024-128-95120 hours 24' ago Daniel ZachariasAurelian Florea
Bigorraarx-cvgameroom-2024-107-03320 hours 27' ago Daniel ZachariasAurelian Florea
CC Topdegenschess66-cvgameroom-2024-107-44420 hours 48' ago Gerd DegensDiceroller Fire
Petteia XXIunspeakablegamer-cvgameroom-2024-130-83621 hours 17' ago Simon RDiceroller Fire
Equal Modern Republican C...cryinto-cvgameroom-2024-111-39421 hours 26' ago Bob GreenwadeDiceroller Fire
Grant Acedrexmakov333-cvgameroom-2024-58-0071 day, 3 hours ago Diceroller FireVitya Makov
Chinese Chess with Sparrowmakov333-cvgameroom-2024-116-9341 day, 6 hours ago Diceroller FireVitya Makov
Millennial Chessarx-cvgameroom-2024-87-8351 day, 15 hours ago Daniel ZachariasVitya Makov
Jungles and Mountains Che...makov333-cvgameroom-2024-59-4872 days, 9 hours ago Diceroller FireVitya Makov
Megalomachycatugo-arx-2024-113-6723 days, 1 hour ago Daniel ZachariasAurelian Florea
Overboardarx-cvgameroom-2024-132-9443 days, 16 hours ago Daniel ZachariasAnyone
Glinski's Hexagonal Chessduniho-fergus-2018-137-6713 days, 18 hours ago Fergus DunihoGus Duniho
Ambitious Amphibies VS Fa...cryinto-cvgameroom-2024-130-7365 days, 21 hours ago Diceroller FireAnyone
Chess 9x9bahram-cvgameroom-2024-127-6196 days, 0 hours ago per hommerbergМитя Митя
Shatranjbahram-cvgameroom-2023-326-5316 days, 3 hours ago Diceroller FireМитя Митя
Modern Chaturangabahram-cvgameroom-2024-73-4616 days, 3 hours ago Diceroller 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 > 1715265476 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