Subtle changes, bugs and feedback

I think they may also be being displayed below stickied threads? E.g., here ...

https://www.lfgss.com/microcosms/523/

... the stickied threads appear above the sub-forums.

Should stickied threads be shown below forums?

The same system currently works everywhere, and I chose to put stickies above the forums as on the home page that is how one could do site-wide notifications.

But I guess that doesn't make sense for subforums (and every forum you see is in fact a subforum).

So I think it should probably be this:

On the homepage, stickies above forums, and a clear black line or space between them. If there are non-stickied items, they go below the forums with a black line or space between them.

Within any subforum, the forums at the top and a clear space or black line before the content... the stickies would then be at the top of the content.

The latter is similar to what vBulletin does, except the former is better for the home page.

Makes perfect sense. I like notifications above (main/sub-homepage) forums and stickies under sub-forums.

Apparently conditional ORDER BY is perfectly valid in PostgreSQL, so that's what I'll do.

If you've got the code open could you check for mouse down not click on the text formatting buttons?

Pretty please?

Hey @Velocio, I think the new upgrade is great. I know zilch about development but all your hard work with "that stuff" is super appreciated. I think it's very slick. Cheers as always for this place.

I so do not have that code open.

oh well...

Thanks. The new stuff is pretty nice, and I've got to play with some awesome SQL recently... such as this beauty:

SELECT microcosm_id
     ,row_number() OVER(
          partition BY site_id
          ORDER BY count DESC, microcosm_id
      ) AS sequence
 FROM (
          SELECT m.site_id
                ,m.microcosm_id
                ,COALESCE(
                     (SELECT SUM(comment_count) + SUM(item_count)
                        FROM microcosms
                       WHERE path <@ m.path
                         AND is_deleted IS NOT TRUE
                         AND is_moderated IS NOT TRUE
                     ),
                     0
                 ) AS count
            FROM microcosms m
           GROUP BY m.site_id, m.microcosm_id
           ORDER BY site_id, count DESC
      ) AS mm

Isn't that great!

It has:

• row_number()
  
• OVER()
  
• PARTITION
  
• COALESCE
  
• An LTREE path
  
  

And what does it do?

It figures out the order in which to show all forums on all sites by rolling up the SUM of all comments and items in all forums, across the tree, and then ordering them by that total within each site, and then numbering them 1, 2, 3... within each site.

It's fun.

It's always good to have some aesthetic satisfaction as a perk of voluntary work. :)

Damn you, I forget this stuff is voluntary until people mention it. This is why I don't have a house yet! #FML

@Velocio Looks like I can't access my list of ignored threads on Android Chrome - not sure if I ever could or where to find it.

Go to your profile, in the right hand column it says "View ignored".

Or just go here:
https://www.lfgss.com/ignored/

it's magic!

Is multi-quoting on the list anywhere?

Nowhere to be found.

though just for @hippy the ability to move and merge multiple things is on the list.

It's pretty useful, although I can see how it might break the 'in reply to' bits.

Which breaks all of the notifications about when people reply to you.

.

You can already enter that using HTML. It doesn't do much more than italicise though

Is it no longer possible to create new forums/sub-forums?

It is, but I have to do it.

It got turned off because people were muppets. By which, I mean that there were a lot of empty forums which were supposed to be classifieds adverts

Not sure if it's a bug or me being a muppet but when I log in I see a little yellow notification saying I have a message - yet I have no message...

#thereisnospoon

I've sent you a PM, this should put things right.

I guessed as much.

I had been planning to start a "library/document archive" for catalogues and brochures etc, but was PAYG for my internet then.

It would need a sub-forum for each brand (Campag, Look, Raleigh etc) as and when someone had something new to add (each model year or series etc, being a separate thread) , so I think that would be too much work for you at the moment and on-going.