Browser MMO Video #17

[OldRod]

"level", "exper", "gold" and "pclass" are all fields that were added to the database tables after their initial creation. Have you put those fields in your tables?

[hallsofvallhalla]

import the .sql file into your database. In my next video I will show how its done...i don't think I already have.

[vertabrate]

Hey halls great tutorials!

There is just one thing bugging me though. In the creatures table when you attack say the orc then it changes the value on the database so if one person attacks it down to 10hp then another person will only have to attack it from 10hp. Is there anyway to fix this? I thought about asigning each user with their own creatures by adding a username colum on the creatures.

Thanks m8

[hallsofvallhalla]

its all preference. You still get the exp for attacking and a bonus exp for killing it so basically it's like raiding right now. $ or five players could essentially attack one big boss to destroy it together.

You could setup a table that holds all the creatures that players fight or a faster way is to hold the name and hpoints of the creature in the players table with the player

just add crhpoints and use that as the HP for the creatures

if isset creature then get the HP of it. ect..

[vertabrate]

yeah i could but if you have like 50+ creautres then the players table will get really big in no time



Anyway can someone give me an opinion on which is better for my login/register:

http://www.myrpg.site50.net/log.php

or

http://www.myrpg.site50.net/tester.php

Thanks again

[ZeroComp]

I have to say bottom one becaus the top one has no taste

[hallsofvallhalla]

yeah i could but if you have like 50+ creautres then the players table will get really big in no time

??? 50+, you wouldn't have to worry about it affecting your database till it reached around 10,000+, that means you would have 10,000+ players!

ALso just add crhpoints field to player table and save it there

[vertabrate]

Hey halls is there any way where you can make it choose which creature you fight?

Cheers mate

[hallsofvallhalla]

what do you mean by it? What chooses which creature? The player?

[vertabrate]

Well im expiramenting with a map system which i am making at the moment and i was wondering when the player clicks a picture of a goblin they fight the goblin but when they click a picture of an orc they fight the orc???

Is there any way to do this mate?

Cheers