Mirror Create Player From Client and Change Scene

I’m very new to Mirror in Unity but I have a lot of experience in Network-programing.

I’m currently trying to create a Game, where the Player’s data is stored on the client, and can join different games (not concurrent) with his/her character. (Likely to Terraria)

So I can’t use the automatic Player creation of the default NetworkManager class. After clicking "Join/Host" in our Main-Menu I want to change to the scene the player has played in, Hosting/joining a server and create the player on the server with the specific position…

I have tried now multiple attempts to do this, but none of mine seemed to work. Am I the even possible to have the players in different scenes with ease? Where/When should I create the Player so isn’t null on the Server?

How can I reduce time and cost to create magic items?

According to the rules, creating magic items (like Wondrous items) takes a day per 1000gp item price and cost half the price.

In the Epic level handbook there is an epic feat called Efficient Item Creation that allows you to create 10000gp per day.

Are there other ways to reduce time taken, money cost or xp cost when creating magic items? I don’t care whether they are epic or not, and a bit of cheese can be allowed.

How to create a set (of matrices) which will be used as an finite group to minimize a function?

I’m new here so I’m a little lost.

I need to minimize a function considering that the minimizing parameter belongs to a preestablished set. It all involves matrices.It’s something like this:

enter image description here

Where G is the set I need to create and enter image description here represents an element of the set. All the other parameters are given.

Does Elemental Affinity apply to Create Bonfire?

Elemental Affinity

Starting at 6th level, when you cast a spell that deals damage of the type associated with your draconic ancestry, add your Charisma modifier to that damage. At the same time, you can spend 1 sorcery point to gain resistance to that damage type for 1 hour.

Create Bonfire:

You create a bonfire on ground that you can see within range. Until the spell ends, the magic bonfire fills a 5-foot cube. Any creature in the bonfire’s space when you cast the spell must succeed on a Dexterity saving throw or take 1d8 fire damage. A creature must also make the saving throw when it moves into the bonfire’s space for the first time on a turn or ends its turn there.

The spell does not deal damage directly, it creates a bonfire, and the bonfire can potentially deal damage. But then perhaps that’s the same as creating a fireball, the spell doesn’t deal damage, the giant burning ball of flame it creates deals damage.

However, create Bonfire is Conjuration, whereas Fireball is Evocation, so perhaps it’s different.

I suppose the difference is that it could be a few turns later that someone steps in the fire and gets burned.

Does it count?

How to create a mermaid using Spheres of Power?

Spheres of Power and its related splatbooks recently came under the valid books my RPG group is allowed to use.

The system is quite something, and far different from anything I have ever used in Pathfinder. So far, I’m liking it quite a lot, and my group is having a blast building characters with those new options in mind.

One of the players wants to RP as a mage-like character that happens to be a mermaid. Her plan is to emulate this "mermaidness" not by picking a different race, but by using the feats Transformation and Hybrid Transformation. (Check this link for details on them.)

Transformation says:

Benefit: Choose one (transformation) Alteration sphere talent that does not cost a spell point. If you choose Anthropomorphic Transformation and are humanoid or of a similar body plan, choose one other (transformation) or (body) talent to use when choosing traits to be granted by Anthropomorphic Transformation.

As a full-round action, you may assume the form of a single creature whose type corresponds to this form talent per the shapeshift ability of the Alteration sphere as a supernatural ability.

The same creature (wolf, spider, treant, etc.) is mimicked and the appearance of that creature is retained each time. The chosen form may be the same as your base size or else Medium or Small, applying size change bonuses and penalties as appropriate if this is not your usual size. When assuming your chosen form, you gain the chosen size. This transformation lasts until you choose to revert to your original form as a full-round action.

You gain all the abilities granted by this form (movement modes, natural attacks, special abilities, etc.) but do not gain any traits from the Alteration sphere as part of this transformation. Treat your Hit Dice as your caster level for the purposes of this effect. This is a polymorph effect. Possessing this feat gives you the shapechanger subtype.

So, from reading this, transformation could be used to, for example, transform her mage into a fish, dolphin or similar creature if she picked "Aquan Transformation". She couldn’t transform into a mermaid, however, since the Aquan Transformation doesn’t have limbs besides a head and a tail by default.

Hybrid Transformation grants a few new options.

Benefit: When changing into a form granted by the Transformation feat, you may instead assume a hybrid form, blending your base form and your transformation form. This cannot be used if your transformation form is already similar to your base form, such as a humanoid using Anthropomorphic Transformation.

When in hybrid form, you gain all limbs, natural attacks, special abilities, and movement modes from your transformation form, but without changing your basic shape nor melding your equipment. You may choose to retain limbs and movement speeds from your base form if your transformation form lacks them or has lesser versions, such as a humanoid keeping arms when assuming a hybrid form based on Serpentine Transformation or Vermin Transformation, adding legs to Aquan Transformation, or a winged creature retaining its wings under Animalistic Transformation.

If your transformation would grant you additional legs, you may instead gain them as arms, although they do not grant any additional attacks, are not strong enough to gain any natural attacks, and may not assist in wielding weapons, activate magic items, or wield a shield. They may hold items and as a swift action you can use them to draw a sheathed or hidden weapon, don a shield, retrieve a stored item, load a crossbow, open a door, pick up an unattended item, sheathe or store an item, or take other non-offensive actions involving manipulating objects. Items do not automatically merge with the new form if it is capable of wearing them, but the size of the items does not change if they do not resize on their own.

From our reading from it, if one can add arms to a Vermin or Serpentine transformation, or legs to an Aquan Transformation, one can deduce that it is possible to put arms on an Aquan Transformation, thus emulating the desired mermaid form as many times and as long as she wants during the adventuring day.

However, since I’m extremely unfamiliar with spheres of power, I have no idea if I’m missing something.

Is this strategy legal? Is it possible to create a mermaid-like character by picking up those two feats?

Do I need to create index for the column when using it in update statement?

I have a table in postgresql11 which has a userId as a column. And it is not primary key in the table. I need to perform below update statement on the table.

update entity set name='xxxx' where userId = 'yyy.

The userId is in the where condition but I don’t know whether I should create an index for userId. Will it improve performance? If yes, how can I specify index in the update statement?