Hi !
Featured games (85)
games approved by the League of Dukes
Games in Showcase (636)
Games in Android Showcase (178)
games submitted by our members
Games in WIP (687)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  Database Questions  (Read 1181 times)
0 Members and 1 Guest are viewing this topic.
Offline dayrinni

Junior Devvie

« Posted 2006-05-28 20:29:55 »


I am creating an online game that requires networking (obviously). This is my first time doing something like this so I would like some opinions and suggestions on my initial plan.

There will be a central server that will be running the game. Then the clients will log into their server and play. The clients will have to download the graphics before hand, ie: installing.

So the server will have to keep track of where everyone is on the screen, known as player location. So that is good.

My question lies in the fact of this (I will provide an example for you!):

We will have content, say, a database of items on the server. When a player say, opens a chest...the client asks the server what is in it. The server says, let me check the DB. So he goes and looks at the DB and gets the contents of the chest and sends it back to the client.

Another example is: Say the player talks to a NPC. The NPC will have some sort of text. So the client talks to the server and says I want the text for NPC #. The server says, let me check the DB. So he goes and looks at the DB and gets the contents of the text the NPC has and sends it back to the client.

Is that feasible? Is the server requesting the information in the DB and then sending it over the internet (along with the data to draw X graphics) not too bandwidth consuming? Or should I do things like this...

Put a lot of the content on the client side. In our above exampels this would consist of the text the NPC's have and chest contents. This would make updating the game difficult as everyone would have to download new things. Another problem is that people could change the contents of the files so they could get anything they want. But it would save on bandwidth.

Thank you for your time and answers. These questions prolly have simple answers, but, I just want to make sure I am somewhat correct.
Offline SluX

Junior Devvie

« Reply #1 - Posted 2006-05-29 08:29:05 »

Since npc chat scritps are bound to be changed(different quests, etc...) and drops are also bound to change, you should keep track of those things on server. It wont consume your bandwith-couple of strings for chat, some coordinates....

So the server will have to keep track of where everyone is on the screen, known as player location. So that is good.
Cheesy Cheesy Grin Grin

"Intelligence is the most beautiful gift and the greatest temptation which one life can receive from the gods."Me Cheesy
Play strategic football
Offline Kova

Senior Devvie

« Reply #2 - Posted 2006-05-29 10:06:28 »

it seems your only concirn is bandwith... well try it like this with everything on server (obviusly better) and if you see that in the end it will take much bandwith go for other solution.  ... in the end text and such small data won't take much bandwith I guess since they are small and, additionally, can compress really well.

... btw. this isn't really a database question, move to online game development?
Pages: [1]
  ignore  |  Print  
You cannot reply to this message, because it is very, very old.

Dwinin (72 views)
2015-11-07 13:29:08

Rems19 (81 views)
2015-10-31 01:36:56

Rems19 (77 views)
2015-10-31 01:32:37

williamwoles (107 views)
2015-10-23 10:42:59

williamwoles (93 views)
2015-10-23 10:42:45

Jervac_ (110 views)
2015-10-18 23:29:12

DarkCart (135 views)
2015-10-16 00:58:11

KaiHH (117 views)
2015-10-11 14:10:14

KaiHH (156 views)
2015-10-11 13:26:18

BurntPizza (172 views)
2015-10-08 03:11:46
Rendering resources
by Roquen
2015-11-13 14:37:59

Rendering resources
by Roquen
2015-11-13 14:36:58

Math: Resources
by Roquen
2015-10-22 07:46:10

Networking Resources
by Roquen
2015-10-16 07:12:30

Rendering resources
by Roquen
2015-10-15 07:40:48

Math: Inequality properties
by Roquen
2015-10-01 13:30:46

Math: Inequality properties
by Roquen
2015-09-30 16:06:05

HotSpot Options
by Roquen
2015-08-29 11:33:11 is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!