I have now added the ability for the user to cast magic for battle. Instead of attacking they can click on their equipped magic they wish to cast and it will be executed. If they player does not have enough mana to cast it will display a message to the player of “Not enough mana to cast” and they will need to chose a different spell.

There are many different elements that will affect the magic. First of which is a condition. If they character is under any condition which pertains to magic such as “Render Magic” which disables all you magics, you will not be able to cast.

If the player does cast a spell then the proper mana is subtracted and the spell is cast. Depending on the type of magic it is and the element of the creature depends on how much damage it will do. If you cast fire against a fire element, it will deal less damage. If you cast water against a fire element the damage dealt is increased.

Up next I need to program the ability for the player to set conditions on an enemy.

I added the ability for random fights to take place while transversing the map. Currently the is a 50% chance that you will get in a fight as you move across the map each time. In the future I will have items that affect this percentage.

 I can never find these values when I need them so I am going to post them here.

TINYINT = -128 to 127
SMALLINT = -32768 to 32767
MEDIUMINT = -8388608 to 8388607
INT = -2147483648 to 2147483647

I created the ability for people to create characters. This obviously is all important if you want people to play the game. Currently all there is for the character is the User chooses their Hero’s Name and Password. I added a captcha to prevent spam cause god knows it happens EVERYWHERE!

After the person creates a character they will receive 12 Attribute Points to put in any field they choose for their character. This can be changed at any point during the game.