Appropriate database schema for heroes’ skills in a Tower Defense game?

In a Tower Defense game, each hero (or character) has some skills. Each skill has some "chance of appearance" (CoA for short) when attacking enemies and if appeared it has some "hit accuracy" (i.e. hit on enemies) (HA for short) and has effects on the enemies (if hit by the skill) (EoH for short).

Examples:

Skill #1: Frost 1, CoA: 50%, HA: 100%, EoH: (1) slow enemy down for 4s and (2) yield 200 damage points.

Skill #2: Frost 2, CoA: 100%, HA: 50%, EoH: (1) make enemy frozen for 8s.

I first tried to breakdown skills into "atomic" effects and come up with tables as below:

enter image description here

All looks good?

But now we want to update Skill #1 a bit to make it more complicated:

Skill #1: Frost 1, CoA: 50%, HA: 100%, EoH: (1) slow enemy down by 40% for 4s and (2) yield 200 damage points. (Please pay attention to the 40% here!)

Or even coming up with more complicated skills:

Skill #3: Frost 3, CoA: 20%, HA: 100%, EoH: (1) frozen enemy for the first 4s then slow enemy down by 50% for next 4s and (2) yield 200 more damage points.

Skill #4: Frost 4, CoA: 10%, attack enemy 3 times continuously, each time: HA: 50%, EoH: (1) frozen enemy for the first 2s then slow enemy down by 50% for next 2s and (2) yield 400 more damage points.

Each effect now has more parameters to be specified — which makes my current schema not fit anymore. Please help deal with this!

Unity 2d…Bullet Intantiate on left….but instantiate on right but not showing in game mode

I am using unity 2d engine…I instantiate a bullet from a weapon…and put speed of bullet in start method as…. rb.velocity =transform.right * _speed;…..but the problem is bullet when fire in left then it shows the bullet in game mode but when firing right the bullet intantiate and shows the bullet in hierarcy but it is not showing in scene mode nor in game mode

How to make your players hate your villain, but not your game

How does one build the character of a villain such that the players (playing heroic characters) hate the villain as much as possible without detracting too much from the quality of the game?

What motivations, habits, etc should the villain have to make them particularly despicable? Should the villain be based off of the PCs in some way or is it more effective to base the villain off of some objective standard of villainy? If the former, in what way should the villain be based off of the PCs?

In order to back up your answers, please either a) provide examples of published works making use of the technique/method you recommend, b) cite real-world RPG experience evidencing the success of your technique/method, or c) cite published material on the subject supporting your position (DMGs, Academic papers, Dragon articles, blog posts, etc)

The best answer will provide unique insight into the causes behind player responses within the character-driven framework, provide critically successful example works exemplifying the particular method advocated, and provide a source where for information on the method/subject, if desired, can be acquired.

What would be a good sport game for a beginner/intermediate game dev to make for practice?

I’m interested in making a sport game for practice, but giving it some fun twists sort of like nintendo does, (super strikers charged, mario golf.) I’m planning on using unity, but since I am by no means an expert I’m trying to figure out a sport that will be reasonably easy to create. I’m aware that its not going to be easy, but, for instance I’m not going to make a game like madden, which would have a ton of difficult stuff like play calls which involve predetermined paths and intelligence on both sides, in general way to difficult. What would be a good sport to try a stylized version of?

I’m aware that this is a subjective question, but it isn’t a question where any answer is as good as another, so I think it’s allowed according to the guideline, but correct me if I’m wrong I guess.

If an AI is sure it is going to lose, what can it do to make the game fun for the player?

For context i am contributing to a sequential turn based strategy game. I have an idea how to improve it but i feel i need some input to help me evaluate and improve it. We currently have a really dumb AI that just follows a rough set of rules each turn. I’m considering to upgrade it to a basic search based AI to not be guaranteed to win every time i play it.

There are many reason why an AI could be behind the curve. These include that is wasn’t able to grow it’s economy well due to bad luck with map generation, that it’s economy was disrupted early by an enemy raid while the defending army was out of reach, that the starter army was defeated early and resources had to be invested to replace it instead of economic upgrades or more importantly there being a big awesome deciding battle with all units involved and it lost. A search based AI will be able to know when it is obvious that it is growing slower than it should, can’t recover and it is now impossible to win due to runaway success. Such a runaway success is often boring to play especially if it happened 3 times in a row.

Assume there is no meta game where multiple players can gang up on the strongest one. I am open to nudge the game rules in the AIs favor if this happens. However rubber banding can give the player the impression that they are punished for playing well, the AI drags out a game into an almost stalemate or even wins unfairly.

The problem i’m trying to solve is not that the AI is loosing but that the AI rolling over and dying is not fun or interesting.

It is even worse. If the player is sufficiently good he will experience that every time.

In some theories of literature after the conclusion seems forgone and the tension is falling a new small conflict that is relevant enough or something else that justifies further elaboration and excitement. enter image description here

My idea is to have a library of endgame scenarios, a handful of which end up with player loosing unless he plays really well, most pose a small challenge that the player is entirely able to deal with and some are a "i role over, just kill me already, please".

Are you aware of anyone trying something like this before? If someone tried this in a strategy game or even outside of strategy games before i would like to learn from them.

Can you spot some obvious problems with this idea? I already considered the AI misjudging the impossibility of wining. However i might be to enamored with my idea to spot different problems.

How can i make sure that this still feels fair? It is easy for the AI to get some extra resources however if a player is loosing i am afraid that he would feel cheapened if he got some extra money and units.

How i help the player having fun or at-least variety when they are losing? I really have no ideas for this.

I want to make a video game based off of Dungeons and Dragons. How much am I legally permitted to use? [closed]

I want to make a video game based off of Dungeons and Dragons. It’ll be a top-down RPG with similar battle and class mechanics. But I’ve been planning out more, and seeing how much I’m copying. How much am I legally permitted to use? I am awayer of the SRD, but don’t understand it fully. Is it like a book of what I’m allowed to use?

Good house rules for 1-on-1 game

I’m DMing a game for my son so this is his solo game, and first D&D game. For any dads or anyone else with 1 on 1 gaming experience, what are some good house rules to add? I was thinking of bonuses like doubling his proficiency, giving him an extra HD per level, extra actions, etc to make his character more survivable. Especially at low levels, as a single unlucky critical hit can end his game. But I don’t want to break the game.

Something I’d rather not do is just throw 1 enemy at him at a time. We had 2 encounters so far. The 1st encounter with 2 goblins was successful but he almost died. The 2nd encounter with 3 goblins had him drop to 0 HP, but I wrote it off by saying they captured him instead of killing him outright. For his next session he’ll have to find a way to escape.

So rather than just giving him 1 thing to fight every time, what are some other ways I can make his character more survivable while giving him exciting fights?

If it matters, he’s a 1st level fighter.

recommendation for a programable FPS game for training forces [closed]

I wish to develop a training simulator for army ground forces.

Basic concept is that they can save lots of training time and budget by going through a simulator phase before the physical war-training, explicitly, learning:

  • How to cooperate with one another and improve team work
  • Learn the basics of their weapons capabilities
  • Learn the territory of interest
  • Develop and practice different tactics

All this at a low cost relative to only physical training.

Where should I start? what platforms are available that can be used for effective war-training and can be easily adapted to new maps/fighting territories and warfare equipment?

Thanks!

Is it possible to clone a game, and make modifiactions to it?

I basically want to know whether or not it is possible to copy a mobile game and make it into a new game by modifying it . I want to be able to access , moderation tools and basically alter, things like charcters, events, in ap purchases etc. Alter it to make it different enough from the original and make it available to other users. The game I want to copy is no longer in the play stores and I want to change that.