What is the current stats in regards to paid homebrew?

Im writing a LitRPG novel on RoyalRoad and want to convert some of the spells in said novel into DND homebrew spells to put on my Patreon for my readers.

But a short while ago I heard things in regard to the creative commons license and I will behonest, I do not know what it means, what the current status is and where to look it up. I know its related to homebrew in some manner, hence the question.

Thank you in advance.