select * from category order by random


  • area_deu

    0_1458974742245_categorychaos.PNG
    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.


  • sockdevs

    @aliceif said:

    Can someone explain the order of categories to me?

    I'm guessing the category list is SELECT * FROM Categories; (or similar) with no ORDER 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)


  • area_deu

    @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:
    0_1459025370899_catselector_howitcouldbedone.PNG

    (This one's used when creating a new topic)



  • 0_1459026982349_upload-712ff31f-6d6f-43fc-b6bc-20459d50af35

    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


  • mod

    @fbmac We talked about this before the game started, and Ben got the extra info removed from our views. But thanks though :smile_cat:



  • @fbmac @aliceif can only see those categories because she's in club ded.



Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.