Aloe and relatives had a re- classification recently. New genera are Aloe" aristaloe gonialoe aloedendron kumara aloiampelos and from haworthia haworthiopsis tulista Gasteria and astoloba are intact...

Green ground cover with yellow flowers could be Sedum rupestre/Petrosedum rupestre 'Blue Spruce'. Blom stalks of Sempervivums are quite similar, but thicker and blooms more colorful.

Thanks Westes & Windberry (for the ID), cool looking plant. Probably not as far gone as one might think; it's still recognizable. Euphorbias are incredibly tough plants, I bet it'll recover. I am sorry I don't know it well enough to suggest remedy, other than correct the soil to much more porous & faster draining as suggested. At minimum try 50/50 Cactus & Succulent mix & Perlite (or Pumice). Also, the pot MUST have a drainage hole at the bottom, can't tell from your pix if your pot does or not.

I don't know why it doesn't give me the option to post a picture in the original post from my phone ...... :(Thank you in advance for any help :D