select * from category order by random
-
Can someone explain the order of categories to me?
(There's more categories in there, but because of Mafia reasons, I only screenshotted part of the list.)This is the category dropdown on the /unread page, BTW.
-
@aliceif said:
Can someone explain the order of categories to me?
I'm guessing the category list is
SELECT * FROM Categories;
(or similar) with noORDER BY
clause; as a result, the order isn't guaranteed
-
@aliceif Either no order by clause, or order by id, and that's just how the categories were created.
They should be ordered by primary category, child categories (with proper indentation), or ordered by name (no indentation)
-
@Matches said:
They should be ordered by primary category, child categories (with proper indentation), or ordered by name (no indentation)
They could reuse this category selector:
(This one's used when creating a new topic)
-
Must be some new type of sorting I've never heard of before!
-
@aliceif if you're seeing too much in mafia, doesn't @Yamikuronue have this problem too? She is playing
-
@fbmac We talked about this before the game started, and Ben got the extra info removed from our views. But thanks though
-