technically many truths have been hidden in form of fiction.
And even if the spirits dont really exist, then if u have people strongly beliving in their existence, then eventually that may create a tulpa, so...
You don't need magic to get people to like you. You just need a little psychology and a little altruism.
principles
1. people develop friendships with people they are physically close with. The closer you are in location to each other on a regular basis, the closer you will be. Studies of college friendships find that students develop friendships most often with either their neighbors or people they spend a lot of time with.
2. To have a sexual relationship with someone they either need to be desperate for release or they need to be attracted to you. With internet porn so readily availible, it's near impossible to seduce someone unless you help them develop feelings for you.
3. the best emotions to develop that lead to sexual relationships come from Oxytocin and serotonin.
With all this in mind here's what you do.
You need time to spend together. Do things like go to eat, cook, do projects, go on adventures, try new things, and clean each other's apartments/ rooms. Expect to spend about 15 hours a week.
When you're comfortable talking and spending time together (if he came out to you as bi, then you should be at this point already), start talking about something sexual you saw that was funny or interesting to start a discussion about sex. Talk about your sexual experiences and ask him about his sexual experiences. Talk about what you like to do for your partners and ask what he likes to do for his partners. If you match in what you like to receive and what you like to give, then ask permission to give him something. If you like to give kisses, ask permission.
Sex is more fun with enthusiastic consent, and making someone want to have sex with you hurts them. If you're frustrated, watch porn. That's what it's there for. Also, drink water and go for a run. That helps me.
If you use magic to get sex, it's more to attract the right person rather than make a particular person like you. You can use it, but it will probably back fire. The output of most spells is 3x the amount of emotion that goes into it. If you put frustration into a spell you'll get 3x the frustration. So if you decide to use magic, think of the kind of person you'd like to have sex with, think of the kind of relationship you want (friends with benefits is fine if it's what you want), and all you have to do is talk to people about what they like to give and receive and what you like to give and receive. You'll find the right person.
I've just recently started working with the Old Ones. Highly recommended. Get a copy of The Book of the Old Ones by Scorpio. Similar in style of New Avatar Power but with different entities. You may be able to find a free PDF on the internet. Also the Scribd website has many old manuscripts.