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




[ Help | Earliest Comments | Latest Comments ]
[ List All Subjects of Discussion | Create New Subject of Discussion ]
[ List Earliest Comments Only For Pages | Games | Rated Pages | Rated Games | Subjects of Discussion ]

Single Comment

General Comments Page. Page for making general comments.[All Comments] [Add Comment or Rating]
Fergus Duniho wrote on 2017-08-20 UTC

I have replaced the listcomments.php script with a new script. This new script uses PDO methods instead of mysql functions, and it changes how it pages through the comments. The old script used the offset method, which grew more expensive with each page of links further away from the origin. The new script uses the first and last keywords to indicate a specific starting point from which to count ahead or count down additional comments. This works just as quickly for any point in the Comment table, and it provides links that will identify the same set of comments even when additional comments are added.

The default is now to list comments in ascending order instead of descending order, and order=DESC must be set to list comments in descending order. This is to make it explicit when comments are being listed in descending order. The new script uses the sort keyword instead of the sortbydate keyword, and it can take different column names for values. It defaults to CommentID. But until I change the links, it will change the order value to DESC, so that old links can still function as they used to. The link on the home page has already been corrected, since it did not include any parameters. For further details on parameters, click on the Help link, or add the help parameter to the URL.