473,320 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Text-based MMORPG Game (DB Scheme Question)

1
Hello Experts.
This is my fourth time im starting to learn PHP/MySQL/AJAX

All the times i tried, was boring, because i was learning only the syntax commands.

Now i do another way. I decided to build up something that i would like to call "its mine!" So it will probably be simple text-based mmorpg game.

Everything goes well until this:
Database MySQL scheme. How would i build the tables?
I mean, i know how, but i also know that there will be fields that will frequently change it self (UPDATE * FROM ..), like: Hit Point bar, user_expience, skill_lvl, money_in_pack, world money etc etc etc...

Now i can do some ideal scheme, items -> 1 table, users -> 2 tables, maps -> 1 table etc...

But i guess its wrong? I cant put static and low-changing fields with frequently changing fields right? because the UPDATE command will go through the whole table right?

so i need to put the static together and frequently fields to separate each in a table? I guess so... what you say guys?
BTW, someone mentioned me about byte arrays or something? what is that? any docs for that? he said the frequently fields you can put inside the programm those fields, in cache, with bytes? 000111000111, 0011 will be - 1, and 1100 will be 24, etc... actually i dont get the whole idea of this guy(friend of mine) so can anyone direct me to some documents about that?

Now back to DB scheme, how do i connect it? using ID as i already seen somewhere?

look at my pseudo-scheme:


Expand|Select|Wrap|Line Numbers
  1. users_table {
  2.     +user_id AUTO_INCREMENT
  3.     +primary_key(user_id)
  4.     +user_continent(+nation) // by choosing your continent, user is automatically moves to speciefic server. (can be?)
  5.     +user details (
  6.     "loginname,firstname,
  7.     lastname,age,
  8.     dateofbirth,country,
  9.     email,password,icq,
  10.     referrer,textlogo
  11.     chatcolor,sexselect");
  12.     }
  13.  
  14.     usersprofiles_table {
  15.     +uprofiles_id
  16.     +user_id
  17.     +user_perks // Choise of 3 perks. 3 possibilities to change.
  18.     +user_ranks
  19.     +user_levels // Depends on user's stats -> STR * INT * END * DEX / 1000 & = level.
  20.     +displayname
  21.     }
  22.  
  23.     userstatus_table {
  24.     +status_id // Such as Administrator, SuperVisor, Moderator, Baron, VIP Player, Premium Player, Banned/Condemned
  25.     +user_id
  26.     }
  27.  
  28.     stats_table {
  29.     +stats_id
  30.     +stat_name
  31.     +stat_req
  32.     +stat_desc
  33.     }
  34.  
  35.     user_stats_table {
  36.     +ustats_id
  37.     +stats_id
  38.     +user_id
  39.     +ustats_value
  40.     +ustats_formula
  41.     }    
  42.  

this is how do i see the scheme... now every table that is connected to users, i put user_id to load the table with users right?

im just stuck and dont get how to connect it all... if anyone give me an example from mine code with 2-3 table connected as it should be ill continue by this example myself.

Sorry for the salat. :) couldnt explain it better. :)
Jan 21 '08 #1
0 1270

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: step_y | last post by:
Those who is interested in computers, games can check out a free massive online strategy scifi game at http://www.spacefederation.net This game is also looking for staff, especially those in the...
1
by: BlackHawke | last post by:
Hello! My name is Nick Soutter, I am the owner of a small game company in San Diego, CA called Aepox Games (www.aepoxgames.net). Our first product, Andromeda Online...
12
by: Fran | last post by:
I'm trying to understand a functional language code fragment so I can explain its syntax and workings to my non English-speaking background neighbour, who is doing her finals. What in heaven's...
9
by: the_philospher | last post by:
I am a beginner programmer learning c++. i have read some useful information about programming games (which is my goal) on gamedev.net, particularly "how do i program games"...
1
by: Jos | last post by:
Hello all. I have a working server, using the asyncore/chat module, which enables logging in, rooms and private messaging. I've used this framework to make some simple games that only required...
73
by: JoeC | last post by:
I am writing a game and I am having a challenge with my combat function. All I want to do is find out how to group pieces that are in the same space. There are two sides and all the units that...
5
by: Kraken | last post by:
Hi, i have a bit of a problem here. I have an assignment to do an animal guessing game using an original database and updating it as the user enters new animals in it. The program enters the file...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.