Check out Symmetric Chess, our featured variant for March, 2024.


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

Comments/Ratings for a Single Item

Later Reverse Order EarlierEarliest
New Submissions for Review. A listing of all submissions still awaiting editorial approval.[All Comments] [Add Comment or Rating]
🕸Fergus Duniho wrote on Mon, Jan 8 11:13 PM UTC in reply to Ben Reiniger from 10:49 PM:

Okay, I have omitted Notifications.


Ben Reiniger wrote on Mon, Jan 8 10:49 PM UTC:

Fergus, please change the font color for last actions being Notification comments to green (or omit them in favor of the last action being the edit itself).


🕸Fergus Duniho wrote on Mon, Nov 13, 2023 05:01 PM UTC:

Because this page loads slowly thanks to including extra information about the progress of the submissions, I have modified it to open all links in a new tab. This will make it easier to go through the submissions listed here without waiting for it to reload each time.


Bob Greenwade wrote on Fri, Jun 30, 2023 06:05 PM UTC:Excellent ★★★★★

Clearly, there's a bit of a backlog. :)


🕸Fergus Duniho wrote on Sat, Apr 22, 2023 04:42 PM UTC in reply to Ben Reiniger from 03:50 PM:

I now have it working correctly. In the assignment of default values, I had to change 0 to false for each of the categories, because there is code further on that will convert a value to a numeric value if the default is numeric, and it ends up converting strings to 0. But the categories should be Booleans, not numbers, and string values for them should be treated as true, not as false.


🕸Fergus Duniho wrote on Sat, Apr 22, 2023 04:13 PM UTC in reply to Ben Reiniger from 03:50 PM:

was there a change in the initial submission scripts that didn't save categories properly, or is there something wrong with the edit form's fetching of them?...

They're not being saved properly, as the Categories column in the database is empty for these pages, including for one I recently created, and the edititem.php script accurately reads the categories for pages that have them.


Ben Reiniger wrote on Sat, Apr 22, 2023 03:50 PM UTC:

The last several pages I've reviewed (starting with submissions from somewhere Jan/Feb 2023?), when I go to the edit (index information) form, the categories are all unchecked. I'm not sure why that would be, and I haven't had time to debug: was there a change in the initial submission scripts that didn't save categories properly, or is there something wrong with the edit form's fetching of them?...


🕸Fergus Duniho wrote on Fri, Feb 17, 2023 07:15 PM UTC:

I modified the script to count comments and revisions with a single query for each table at the beginning, but it was still going slowly, because it also does queries for each item to find out the last action. To address that, I modified the one-time queries to also include information on the latest commentdate or revisiontime. But I'm not sure how to modify it to also include who wrote the comment or made the revision. So, it is still doing additional queries while listing the output. But instead of doing two queries for each item, is is now doing only one. Also, I was able to simplify each of those queries by including the commentdate or revisiontime from the one-time queries. So, altogether, it was previously doing four additional queries per item, and now it is doing only one additional query, and each of those should take less time now, which should speed it up, but it's still listing items in spurts.

Additionally, it is also checking whether there is an entry in MemberSubmissions, which takes another query. So, it's actually doing two additional queries per item. For items created after the Revisions tables, I might be able to use the revisions count to tell whether the page has been created yet, which would save the need to query MemberSubmissions. Certainly, if there are any revisions, the page has already been created, and I could query MemberSubmissions only for items with no revisions. So, it will now query the MemberSubmissions table only when the revision count is zero, which should shave off some more time.


🕸Fergus Duniho wrote on Thu, Feb 16, 2023 06:10 PM UTC:

This page has been getting very slow of late. I think it's because it counts the number of revisions for each entry, and the Revisions table has been growing in size. So, when we make lots of small revisions to a page, let's make sure to delete most of the past ones.


A. M. DeWitt wrote on Fri, Jan 27, 2023 01:44 AM UTC in reply to Fergus Duniho from Sat Apr 16 2022 09:36 PM:

What if you sorted based on the timestamp of the last action taken for each article? That way you don't have to worry about unset modification dates, and you can see which articles have changes ready for review.


A. M. DeWitt wrote on Mon, Oct 24, 2022 03:10 PM UTC:

Suzumu Shogi and Mitsugumi Shogi (Rules pages and GC preset pages) are ready.

The Heavy Shako GC preset page is also ready.

Mitsugumi-Shogi (Note the hyphen!!!) can be deleted.


Daniel Lee wrote on Wed, May 25, 2022 09:37 PM UTC:

Hi, still waiting for Chennis (submitted January) to be published


🕸Fergus Duniho wrote on Sat, Apr 16, 2022 09:36 PM UTC:

I changed this page to be sorted by CreationDate, because ModifiedDate has sometimes not been set.


Daniel Lee wrote on Sat, Mar 5, 2022 07:57 PM UTC in reply to Ben Reiniger from Wed Jan 19 03:22 PM:

Thanks -- and would you be able to do Chennis as well? That's my last one.


Ben Reiniger wrote on Wed, Jan 19, 2022 03:22 PM UTC in reply to Daniel Lee from Sun Jan 16 05:54 PM:

Hi Daniel, sorry, those had slipped beyond my radar. I'll make another pass through the list when I can.


Daniel Lee wrote on Sun, Jan 16, 2022 05:54 PM UTC:

Hi, I have some unprocessessed submissions dating back to August (Empire Chess and Shinobi Chess)... Is there any reason why they're stuck in limbo still?


🕸Fergus Duniho wrote on Fri, Oct 29, 2021 03:01 PM UTC in reply to A. M. DeWitt from 02:07 AM:

Okay.


A. M. DeWitt wrote on Fri, Oct 29, 2021 02:07 AM UTC:

When I reverted the Futashikana Shogi pages back to their original form, they also reverted to pending editorial approval. This game has already been approved before. If an editor could fix this that would be great.


🕸Fergus Duniho wrote on Thu, Feb 25, 2021 10:36 PM UTC:

I added information on the last action to each submission listing. This will be either the latest comment or the latest revision, and it will give us an indication of which submissions require attention. When the last action was by the author, the last action text will appear green, and this will indicate that some attention is required from the editors. When the last action was not by the author, the last action text will appear red, and this will either mean that someone is working on it, or that we're waiting for some action by the author.


🕸Fergus Duniho wrote on Tue, Oct 27, 2020 05:24 PM UTC in reply to Kevin Pacey from 02:33 AM:

https://www.chessvariants.com/link/4bughouse

It had entries in other tables of the database. I have now deleted them.


Kevin Pacey wrote on Tue, Oct 27, 2020 02:33 AM UTC:

I went back and deleted some old submissions of mine from years ago. In one last case, however, I'm unable to edit or delete a particular submission, because when I click on it it says the page cannot be found. I'm not sure if the system still thinks it has not been deleted. In any case, could an editor please try to delete the following old submission of mine, if possible (it could matter since I believe nowadays there is a limit of having 9[?] unprocessed submissions at any one time for a contributor, especially if the submissions are counted by the database, rather than by an editor):

https://www.chessvariants.com/link/4bughouse


Ben Reiniger wrote on Tue, Jun 30, 2020 03:19 AM UTC:

I fixed a bug on this page: the query ordered by CreationDate but tried to group for display based on ModifiedDate; I think here having the query order by ModifiedDate makes more sense.  However, there are a handful of pages here with ModifiedDate=0000-00-00, which get tacked on at the end.

@Fergus, I'm not sure what causes a page will have this degenerate ModifiedDate?  Even your test page that has revisions in the table suffers that affliction.


🕸Fergus Duniho wrote on Tue, Jun 23, 2020 05:15 PM UTC:

Very nice!  I was considering attempting this, but using diffs instead of saving the entire revision (but with the final, and perhaps various intermediate versions, saved in full so that lots of diffs wouldn't need to be processed to display a page).  That might be something to still try, if the size of the revisions table is a concern.

It occurred to me that I could do this after I set it up for doing comparisons between revisions, but this would also make it more complicated. Hopefully, the ability to delete old revisions will keep it from growing too large. If needed, I can also add automatic garbage collection that keeps the size of the Revisions table down.

I can't see revision counts from any of the Edit links that I know about (but can in this New Submissions list), nor a link to the revisions.php script. 

You're going to see revision counts only for pages that actually have revisions. Most submissions do not have any, because they were submitted before revisions started being saved. When I just checked one of the latest submissions, it had a couple revisions listed in the Edit menu. Remember that you have to be signed in to see the Edit menu.

The editor-use Edit page has text concerning revisions, but the link doesn't work, and the author-use Edit page hasn't been changed recently.

Okay, I have now fixed that.

And a separate issue (for editors): does loading the Edit Index Information (for editors) page take a long time to load the inventor/author dropdowns for anyone else?  If so, I'd like to move those into a new script, so that categorization, primary/secondary links, etc. and approval can be done more quickly.

We have had a quick edit script for several years now, which dispenses with the long list of possible author and inventor ids. I used to use it back when I used a 2400 baud modem to get on the internet. Just use the link that says "quick edit" instead of the one that says "edit".


Ben Reiniger wrote on Tue, Jun 23, 2020 02:30 AM UTC:

Very nice!  I was considering attempting this, but using diffs instead of saving the entire revision (but with the final, and perhaps various intermediate versions, saved in full so that lots of diffs wouldn't need to be processed to display a page).  That might be something to still try, if the size of the revisions table is a concern.

I can't see revision counts from any of the Edit links that I know about (but can in this New Submissions list), nor a link to the revisions.php script.  The editor-use Edit page has text concerning revisions, but the link doesn't work, and the author-use Edit page hasn't been changed recently.

 

And a separate issue (for editors): does loading the Edit Index Information (for editors) page take a long time to load the inventor/author dropdowns for anyone else?  If so, I'd like to move those into a new script, so that categorization, primary/secondary links, etc. and approval can be done more quickly.


🕸Fergus Duniho wrote on Sat, Jun 20, 2020 01:55 AM UTC:

When a submission is updated, it will be saved to a new row in the Revisions table. This is in addition to updating its row in the MemberSubmissions table. This will preserve a copy of it in case it is deleted or it is changed by subsequent revisions. Pairs of revisions may be compared together. This is useful for letting editors quickly see what changes someone has made without rereading the whole submission. To keep the Revisions table from growing too large, it is also possible to delete revisions. Currently, the only option is for a revisor to delete all of his own revisions except for the very latest one. So, no one may delete all of his revisions, no one may delete someone else's revisions, and no one may delete the revision matching the current version of the submission.

To see how many revisions a submission has, an editor or author may check the Edit menu for the page. Anyone who views this page may also see the number of revisions given with the listing.


25 comments displayed

Later Reverse Order EarlierEarliest

Permalink to the exact comments currently displayed.