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 |
Skica | sxg-cvgameroom-2024-199-666 | 59" ago |
wdtr2 | Oisín D. |
Berolina Chess vs. FIDE C... | makov333-cvgameroom-2024-205-926 | 1 hour 31' ago |
Oisín D. | Vitya Makov |
Anemic Chess | sxg-cvgameroom-2024-203-031 | 1 hour 31' ago |
Oisín D. | Vitya Makov |
Royal Rumble | makov333-cvgameroom-2024-198-439 | 1 hour 44' ago |
Oisín D. | Vitya Makov |
Fou Chess | makov333-cvgameroom-2024-188-832 | 1 hour 49' ago |
Oisín D. | Vitya Makov |
Atlantean Coffee House Sh... | arx-cvgameroom-2024-185-745 | 1 hour 50' ago |
Oisín D. | Daniel Zacharias |
Sissa Style Chess | arx-cvgameroom-2024-193-875 | 1 hour 51' ago |
Oisín D. | Daniel Zacharias |
Overboard | sxg-cvgameroom-2024-186-943 | 2 hours 5' ago |
Oisín D. | Daniel Zacharias |
Greater Tiger Chess | sxg-cvgameroom-2024-208-048 | 2 hours 11' ago |
Oisín D. | Anyone |
Gigachess | sxg-cvgameroom-2024-187-498 | 2 hours 43' ago |
Oisín D. | Daniel Zacharias |
Overboard | arx-cvgameroom-2024-132-944 | 3 hours 26' ago |
wdtr2 | Daniel Zacharias |
Little Rider Reef | degenschess66-cvgameroom-2024-198-585 | 3 hours 31' ago |
wdtr2 | Gerd Degens |
Secret Intelligence Chess | fergus-cvgameroom-2024-193-006 | 3 hours 33' ago |
wdtr2 | Fergus Duniho |
Gross Chess | fergus-cvgameroom-2024-147-960 | 4 hours 13' ago |
Daniel Zacharias | Fergus Duniho |
Chinese Chess with Sparrow | makov333-cvgameroom-2024-145-593 | 4 hours 14' ago |
Daniel Zacharias | Vitya Makov |
Secret Intelligence Chess | fergus-cvgameroom-2024-182-845 | 4 hours 16' ago |
Daniel Zacharias | Fergus Duniho |
Chinese Chess | arx-cvgameroom-2024-167-251 | 4 hours 17' ago |
Daniel Zacharias | Vitya Makov |
Opulent Lemurian Shatranj | arx-bobgreenwade-2024-170-796 | 4 hours 20' ago |
Daniel Zacharias | Bob Greenwade |
Waffle Chess with Gryphon... | catugo-arx-2024-153-403 | 4 hours 21' ago |
Daniel Zacharias | Aurelian Florea |
Bigorra | arx-cvgameroom-2024-107-033 | 4 hours 23' ago |
Daniel Zacharias | Aurelian Florea |
Millennial Chess | arx-cvgameroom-2024-87-835 | 4 hours 25' ago |
Daniel Zacharias | Vitya Makov |
FOOD FIGHT!!! | bobgreenwade-cvgameroom-2024-154-808 | 4 hours 26' ago |
Daniel Zacharias | Bob Greenwade |
Great Rider Reef | degenschess66-cvgameroom-2024-149-392 | 4 hours 27' ago |
Daniel Zacharias | Gerd Degens |
Hannibal Chess with Gryph... | catugo-arx-2024-153-403 | 4 hours 29' ago |
Daniel Zacharias | Aurelian Florea |
Megalomachy | catugo-arx-2024-113-672 | 4 hours 30' ago |
Daniel Zacharias | Aurelian Florea |
Hannibal Chess with Manti... | catugo-arx-2024-153-403 | 4 hours 31' ago |
Daniel Zacharias | Aurelian Florea |
Waffle Chess with Mantico... | catugo-arx-2024-153-403 | 4 hours 32' ago |
Daniel Zacharias | Aurelian Florea |
Sac Chess | sxg-cvgameroom-2024-186-943 | 6 hours 55' ago |
Oisín D. | Vitya Makov |
Chess with Different Armies | sxg-cvgameroom-2024-190-518 | 12 hours 0' ago |
Oisín D. | Vitya Makov |
Thunderstruck Server Chess | cryinto-cvgameroom-2024-183-210 | 12 hours 30' ago |
Oisín D. | Diceroller Fire |
Homo Scacco | cryinto-cvgameroom-2024-197-903 | 14 hours 42' ago |
Vitya Makov | Diceroller Fire |
Frog Chess with Manticore... | catugo-arx-2024-153-403 | 2 days, 6 hours ago |
Daniel Zacharias | Aurelian Florea |
Grand Apothecary Chess 3 | arx-catugo-2024-128-951 | 2 days, 6 hours ago |
Daniel Zacharias | Aurelian Florea |
Tamerlane Chess | ecclesiae33-cvgameroom-2024-205-787 | 2 days, 8 hours ago |
Ros'Alice Bellús | Ecclesiae Ecclesiae |
War of the Roses | makov333-cvgameroom-2024-204-894 | 3 days, 5 hours ago |
Vitya Makov | Anyone |
War of the Roses | makov333-cvgameroom-2024-204-892 | 3 days, 5 hours ago |
Vitya Makov | Anyone |
Fugue | sxg-cvgameroom-2024-204-597 | 3 days, 12 hours ago |
Oisín D. | Richard milner |
Fugue Rococo with Edgehogs | sxg-cvgameroom-2024-204-597 | 3 days, 12 hours ago |
Oisín D. | Richard milner |
Fugue | sxg-cvgameroom-2024-204-590 | 3 days, 13 hours ago |
Oisín D. | Anyone |
Chaturanga - Davidson Var... | bahram-cvgameroom-2023-338-380 | 3 days, 21 hours ago |
Aurelian Florea | Митя Митя |
Wide SOHO Chess | panther-cvgameroom-2023-350-831 | 4 days, 0 hours ago |
Kevin Pacey | Митя Митя |
WAD Chess | panther-cvgameroom-2023-350-827 | 4 days, 0 hours ago |
Kevin Pacey | Митя Митя |
Gross Chess | panther-cvgameroom-2024-80-238 | 4 days, 1 hour ago |
Kevin Pacey | Митя Митя |
Morphing Chess III | degenschess66-cvgameroom-2024-72-788 | 4 days, 12 hours ago |
Gerd Degens | Richard milner |
Morphing Chess IV | degenschess66-cvgameroom-2024-75-694 | 4 days, 12 hours ago |
Gerd Degens | Richard milner |
R-Chess (Rombus Chess) | degenschess66-cvgameroom-2024-98-462 | 4 days, 12 hours ago |
Gerd Degens | Richard milner |
Spider Chess | degenschess66-cvgameroom-2024-101-776 | 4 days, 12 hours ago |
Gerd Degens | Richard milner |
Pattern Chess | degenschess66-cvgameroom-2024-172-343 | 4 days, 13 hours ago |
Gerd Degens | Митя Митя |
Giant Chess | bahram-cvgameroom-2023-350-349 | 4 days, 13 hours ago |
Митя Митя | Richard milner |
Gigachess | bahram-cvgameroom-2023-332-636 | 4 days, 13 hours ago |
Митя Митя | Richard milner |
Elephant Chess | bahram-cvgameroom-2023-340-653 | 4 days, 13 hours ago |
Митя Митя | Richard milner |
Tamerlane Chess | insarissajev-cvgameroom-2024-203-452 | 4 days, 16 hours ago |
Insar Issajev | Anyone |
Morphomania | degenschess66-cvgameroom-2024-79-833 | 4 days, 18 hours ago |
Gerd Degens | Richard milner |
Snappy Chess | degenschess66-cvgameroom-2024-90-255 | 4 days, 19 hours ago |
Gerd Degens | Richard milner |
Morphing Chess | degenschess66-cvgameroom-2024-67-711 | 4 days, 19 hours ago |
Gerd Degens | Richard milner |
Queens | degenschess66-cvgameroom-2024-46-355 | 4 days, 20 hours ago |
Gerd Degens | Richard milner |
TCB (Traffic Calmed Borde... | degenschess66-cvgameroom-2024-97-243 | 4 days, 20 hours ago |
Gerd Degens | Richard milner |
NIHISCI | degenschess66-cvgameroom-2024-91-741 | 4 days, 20 hours ago |
Gerd Degens | Richard milner |
Wide Tiger Chess | sxg-cvgameroom-2024-201-907 | 5 days, 12 hours ago |
Oisín D. | Richard milner |
Maasai Chess | sxg-cvgameroom-2024-200-016 | 5 days, 12 hours ago |
Oisín D. | Richard milner |
ChessBreakTimes Chess | cryinto-cvgameroom-2024-63-858 | 5 days, 13 hours ago |
Diceroller Fire | Richard milner |
Stone Garden Full Contact | cryinto-cvgameroom-2024-61-391 | 5 days, 13 hours ago |
Diceroller Fire | Richard milner |
Radioactive Queen Chess | cryinto-cvgameroom-2024-48-879 | 5 days, 13 hours ago |
Diceroller Fire | Richard milner |
Timurid | sesquipedalian-cvgameroom-2024-44-957 | 5 days, 21 hours ago |
Daniel Zacharias | Richard milner |
Mammoth Tiger Chess | sesquipedalian-cvgameroom-2024-73-927 | 5 days, 21 hours ago |
Daniel Zacharias | Richard milner |
Cetran Chess 2 | panther-cvgameroom-2024-80-233 | 5 days, 23 hours ago |
Kevin Pacey | Richard milner |
Cetran Chess 3 | panther-cvgameroom-2024-80-233 | 5 days, 23 hours ago |
Kevin Pacey | Richard milner |
Secret Intelligence Chess | fergus-cvgameroom-2024-193-009 | 6 days, 0 hours ago |
Fergus Duniho | Richard milner |
Shatar | bahram-cvgameroom-2023-326-534 | 6 days, 1 hour ago |
Richard milner | Митя Митя |
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 > 1721442016 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