Fighting game let's start big :P

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Fighting game let's start big :P

Post by Draco_03 »

Hey i have no clue what i am doiing right now
but humm i do it anyways, that how youlkearn i heard :)

i m trying to make a fighting game 1vs1

So basically i just exploring the possibility of how i shoud design my DB
So I guess here.. i m a noob cuz i only do php like once a week for about 20 min ..for multiple reason..
but whatever

now
Having a Table Player1 and player2
BOTH conating thes value :

Code: Select all

-id
-name
-avatar
i would also have a Table Avatars
containing :

Code: Select all

-url of avatar (or path)
Then comes the MOVES

Code: Select all

-Punch
-kick
-block
for now i won t put any score..
But i don't know about the health... like should it be a table alone or...
nyways i'm not asking for anyone to write my code..just validate the way i'm designing my tables..:)

thank you in advanced
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

i think you should have one only one maybe two tables::

Code: Select all

PLAYERS:
 -id
 -name
 -avatar(url to avatar)
 -level
 -health
 -strength
 -punch
 -kick
 -block
Then let the players level up, and increase their health and strength, and then for punch/kick you could ahve a field that tells the average damage done by that attack, and then block is the percentage of block.... But tis really up to you how you design your game!! so whatever would be easiest for you to do!! g'luck!
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

:)
thank you
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post by Steveo31 »

A game based around a db?

*confused*
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

it s 1vs 1
or at least i m trying.. so let s say you do your serie of moves , the another player does his serie of moves, when both lpayer had done there moves you compoare move 1 of P1 with move 1 of P2 and so on.. until someone health reach 0, or the winner is the one with greater health.. same health = draw

:)
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

Steveo31 wrote:A game based around a db?

*confused*
no, he is jsut storing all of the player's information in the database.
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

this is a very interesting concept

this line made me think.........
Then let the players level up, and increase their health and strength,
ive been pondering the idea of an 'online' RPG in the vein of breath of fire / final fantasy / golden sun, this quote did not bring any fresh to my head but further reinforce my idea

i might actually start on it now

thank you
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

the thging is.. not to make a game boring there must be advance...and mhh the only way in a game with you punch kick and even bitch slap someone.. after a nujmber of win you could "upgrade" your stats..
and mhhh i think bitch slapping someone would be a finish him..

mhhh yeah
PS : i m an RPG lover :)
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

i could possibly need help on this idea

so if anyones up 4 a joint venture (no paid obviously, its all fun)

then PM me
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

i wish i could but i m the one needing help.. i barely now how to code php.. i'm all doiing that for fun with a guy that used to programm c++ a long time ago.. :P

I'll try..and the worst that can happen is that i'm not able to do it at all.. but whatever i'll do i'll learn new things :)
that all bout learning and having fun
8)
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

Draco_03 wrote:I'll try..and the worst that can happen is that i'm not able to do it at all.. but whatever i'll do i'll learn new things :)
that all bout learning and having fun
8)
my way of thinking exactly :D
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Post by Roja »

Legend of the green dragon is a fighting/rpg web-based game. Its also open-source, community developed, and can be fun for a while.

After ~ 2 months, it gets a little dull, but its not bad!

http://lotgd.net/ / http://sourceforge.net/projects/lotgd

Should give you a good start.

There are many other web-based RPG's.. search on freshmeat or sourceforge. :)
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

thx :)
Post Reply