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 | Log | Last Modified | Last Move by | Next Move for |
Alice Chess | timurthelenk-numerist-2023-90-774 | 19' 10" ago |
Jean-Louis Cazaux | Paul Rapoport |
Shuka | chessshogi-cvgameroom-2023-69-735 | 42' 45" ago |
wdtr2 | Adam DeWitt |
Colossus | playtester-cvgameroom-2023-84-639 | 3 hours 31' ago |
Play Tester | Oisín D. |
Devingt Chess | jezzat-cvgameroom-2023-54-471 | 4 hours 42' ago |
Oisín D. | Jeremy Thompson |
Promotion Chess | makov333-cvgameroom-2023-76-729 | 4 hours 43' ago |
Oisín D. | Vitya Makov |
Shatranj | david_64-panther-2023-68-626 | 5 hours 13' ago |
David Paulowich | Kevin Pacey |
Berolina Chess | playtester-cvgameroom-2023-84-639 | 6 hours 56' ago |
Play Tester | Vitya Makov |
Zanzibar-XL | arx-timurthelenk-2022-283-047 | 7 hours 9' ago |
Jean-Louis Cazaux | Daniel Zacharias |
Courier Chess | panther-cvgameroom-2023-62-263 | 7 hours 17' ago |
Jeremy Thompson | Kevin Pacey |
Courier Chess | panther-cvgameroom-2023-62-262 | 7 hours 23' ago |
Jeremy Thompson | Kevin Pacey |
Shako | panther-cvgameroom-2023-62-266 | 7 hours 28' ago |
Jeremy Thompson | Kevin Pacey |
Euchess | panther-cvgameroom-2023-62-270 | 7 hours 31' ago |
Jeremy Thompson | Kevin Pacey |
Ultima | pokshtya-cvgameroom-2023-77-339 | 12 hours 50' ago |
Вадря Покштя | Daniel Zacharias |
Cetran Chess 3 | sissa-cvgameroom-2023-90-245 | 13 hours 0' ago |
Carlos Cetina | Anyone |
Cetran Chess 2 | sissa-cvgameroom-2023-90-245 | 13 hours 0' ago |
Carlos Cetina | Anyone |
Cetran Chess 1 | sissa-cvgameroom-2023-90-245 | 13 hours 0' ago |
Carlos Cetina | Anyone |
UC-40 | sissa-cvgameroom-2023-90-245 | 13 hours 0' ago |
Carlos Cetina | Anyone |
Symmetric Chess | alienum-cvgameroom-2023-77-220 | 13 hours 18' ago |
Homo Simia | per hommerberg |
Grand Apothecary Chess 3 | arx-catugo-2022-307-116 | 15 hours 34' ago |
Aurelian Florea | Daniel Zacharias |
Suzumu Shogi | chessshogi-cvgameroom-2023-20-201 | 16 hours 12' ago |
Adam DeWitt | Daniel Zacharias |
4-Handed Chatarunga | panther-zcherryz-2022-123-934 | 16 hours 33' ago |
Christine Bagley-Jones | Kevin Pacey |
UC-40 | sissa-arx-2023-72-059 | 17 hours 37' ago |
Carlos Cetina | Daniel Zacharias |
Skica | sissa-arx-2023-8-021 | 17 hours 37' ago |
Carlos Cetina | Daniel Zacharias |
Expanded Chess | sissa-arx-2023-57-072 | 17 hours 37' ago |
Carlos Cetina | Daniel Zacharias |
Sac Chess | sissa-panther-2023-76-018 | 17 hours 37' ago |
Carlos Cetina | Kevin Pacey |
Cetran Chess 2 | sissa-cvgameroom-2023-87-184 | 17 hours 37' ago |
Carlos Cetina | per hommerberg |
Cetran Chess 1 | sissa-cvgameroom-2023-83-510 | 17 hours 37' ago |
Carlos Cetina | per hommerberg |
Apothecary Chess-Modern | arx-cvgameroom-2023-48-038 | 18 hours 3' ago |
wdtr2 | Daniel Zacharias |
Cylindrical Chess | playtester-cvgameroom-2023-84-639 | 18 hours 32' ago |
Play Tester | per hommerberg |
Alice Chess | playtester-cvgameroom-2023-84-639 | 18 hours 32' ago |
Play Tester | per hommerberg |
Opulent Chess | playtester-cvgameroom-2023-84-639 | 19 hours 10' ago |
Play Tester | Daniel Zacharias |
Chess with Different Armies | playtester-cvgameroom-2023-84-639 | 19 hours 10' ago |
Play Tester | Vitya Makov |
Glinski's Hexagonal Chess | panther-cvgameroom-2023-62-278 | 19 hours 42' ago |
Kevin Pacey | Daniel Zacharias |
Ultima | fergus-cvgameroom-2023-71-924 | 19 hours 42' ago |
Fergus Duniho | Daniel Zacharias |
Bomberman Chess | arx-cvgameroom-2023-20-319 | 19 hours 53' ago |
Vitya Makov | Daniel Zacharias |
Atlantean Coffee House Sh... | arx-cvgameroom-2023-39-793 | 19 hours 53' ago |
Oisín D. | Daniel Zacharias |
Napoleonic Chess | makov333-arx-2022-324-382 | 20 hours 5' ago |
Daniel Zacharias | Vitya Makov |
Enhanced Courier Chess | makov333-cvgameroom-2023-16-607 | 20 hours 5' ago |
Daniel Zacharias | Vitya Makov |
Gorgona Chess | arx-cvgameroom-2023-45-048 | 20 hours 16' ago |
Daniel Zacharias | Vitya Makov |
Lemurian Shatranj | joejoyce-panther-2023-15-192 | 1 day, 0 hours ago |
Kevin Pacey | Joe Joyce |
Shako | panther-cvgameroom-2023-62-265 | 1 day, 0 hours ago |
Kevin Pacey | Richard milner |
Thuria Jetan | twrecks-cvgameroom-2023-68-980 | 1 day, 0 hours ago |
Tom West | Richard milner |
Enhanced Courier Chess | sxg-cvgameroom-2023-65-107 | 1 day, 3 hours ago |
Oisín D. | Richard milner |
UC-40 | sissa-cvgameroom-2023-83-510 | 1 day, 6 hours ago |
Carlos Cetina | Richard milner |
Cetran Chess 3 | sissa-cvgameroom-2023-83-511 | 1 day, 6 hours ago |
Carlos Cetina | Richard milner |
Cetran Chess 2 | sissa-cvgameroom-2023-83-511 | 1 day, 6 hours ago |
Carlos Cetina | Richard milner |
Symmetric Chess | alienum-cvgameroom-2022-48-638 | 1 day, 15 hours ago |
Homo Simia | Play Tester |
Symmetric Chess | alienum-cvgameroom-2022-48-637 | 1 day, 15 hours ago |
Homo Simia | Play Tester |
Grand Apothecary Chess 3 | sxg-cvgameroom-2023-56-893 | 1 day, 23 hours ago |
Oisín D. | Daniel Zacharias |
Mitsugumi Shogi | sxg-cvgameroom-2023-68-652 | 1 day, 23 hours ago |
Oisín D. | Daniel Zacharias |
Circular Chess | makov333-cvgameroom-2023-15-981 | 2 days, 8 hours ago |
Jeremy Thompson | Vitya Makov |
Alekhine Chess | makov333-cvgameroom-2023-9-834 | 2 days, 12 hours ago |
Daniel Zacharias | Vitya Makov |
Modern Shatranj | sacredchao-cvgameroom-2023-74-965 | 3 days, 5 hours ago |
Oisín D. | Omnia Nihilo |
Cetran Chess 3 | sissa-cvgameroom-2023-87-184 | 3 days, 14 hours ago |
Carlos Cetina | Anyone |
Circular Chess | panther-cvgameroom-2023-62-277 | 3 days, 23 hours ago |
Kevin Pacey | Vitya Makov |
Circular Chess | panther-cvgameroom-2023-62-659 | 3 days, 23 hours ago |
Kevin Pacey | Vitya Makov |
Insane Ninja Chess | israelgaming1203-dilloniseasyfr-2023-85-794 | 4 days, 23 hours ago |
Israel IRSARREL | Dillon Dilloon |
Royal Rumble | sesquipedalian-cvgameroom-2021-201-816 | 6 days, 23 hours ago |
Richard milner | Sandra#Paul BRANDLYARD |
Wild Kingdom | sesquipedalian-cvgameroom-2023-83-787 | 6 days, 23 hours ago |
Richard milner | Anyone |
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 > 1679766832 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