You are on the backup site for Chessvariants.com. Any posts, moves, or other changes you make here will not be permanent, because the pages and database from the main site will be backed up here every midnight EST. Additionally, things may not be working right, because this site is also a testbed for newer system software. So, if you are not here to test, develop, or merely read this site, you may want to change .org to .com in the navigation bar and go to the main site.



The Chess Variant Pages



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
Bear Chesstim_olena-panther-2021-294-62913 hours 26' ago Kevin PaceyTim O'Lena
Maasai Chessarx-cvgameroom-2021-281-12813 hours 52' ago Daniel ZachariasPaul Rapoport
4-Handed Chatarungapanther-zcherryz-2021-66-05015 hours 30' ago Kevin PaceyChristine Bagley-Jones
Sac Chessjoejoyce-panther-2021-233-90916 hours 39' ago Kevin PaceyJoe Joyce
Sac Chessjoejoyce-panther-2021-241-81416 hours 40' ago Kevin PaceyJoe Joyce
Chessneph-cvgameroom-2021-215-04416 hours 49' ago Kevin PaceyStephen Williams
UC-170-17arx-sissa-2021-270-01716 hours 55' ago Daniel ZachariasCarlos Cetina
shako_balbomageofmaple-cvgameroom-2021-281-05819 hours 19' ago Greg Strongwdtr2
Expanded Chessarx-sissa-2021-295-92921 hours 56' ago Daniel ZachariasCarlos Cetina
Pembatimurthelenk-arx-2021-287-38922 hours 0' ago Daniel ZachariasJean-Louis Cazaux
Bear Chesstim_olena-whitetiger-2021-279-60423 hours 42' ago Tim O'LenaNatalia Dolindo
Janggiarx-cvgameroom-2021-297-1261 day, 15 hours ago Daniel ZachariasDoge Master
Chu Shogitorcuso-cvgameroom-2021-239-3762 days, 6 hours ago Milton HaddockTorsten Schilling
Eurasian Chessper31-cvgameroom-2021-292-5522 days, 16 hours ago Greg Strongper hommerberg
Eurasian Chessper31-cvgameroom-2021-268-8672 days, 20 hours ago Daniel Zachariasper hommerberg
Alice Chessstrings808017424-wotton-2021-285-9523 days, 3 hours ago Lorrewl Wottonstrings 808017424
Suzumu Shogichessshogi-sesquipedalian-2021-295-0943 days, 16 hours ago Adam DeWittRichard milner
Expanded Chesssesquipedalian-cvgameroom-2021-286-8475 days, 17 hours ago Daniel ZachariasRichard milner
Opulent Chessmageofmaple-cvgameroom-2021-263-8246 days, 20 hours ago Greg StrongRichard milner
TenCubed Chessmageofmaple-cvgameroom-2021-263-8306 days, 20 hours ago Greg StrongRichard milner
Suzumu Shogiarx-cvgameroom-2021-276-1636 days, 23 hours ago Daniel ZachariasNatalia Dolindo

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