x


Database useage for RPG Game

Hey Guys,

I have a more general question about using a database for a RPG game.

First questions I have about it, is the best way to go about storing your items and such in a database?

Once you have the database made how do you actually get the items from the database into the game?

Also any advice on the matter would be of great help, Im having some trouble figuring out how exactly to go about the item system for my rpg, in particular the question about how to get it from database and into the game as a gameobject with a model and its stats..

Thanks for your time in advanced and sorry for the question being so general but I am just unsure where to start...

more ▼

asked May 26 '11 at 07:49 PM

UnityDev0008 gravatar image

UnityDev0008
46 5 5 8

Is this an MMORPG? Do you mean a SQL database?

May 26 '11 at 08:31 PM GesterX

No this is not an rpg and im talking generally for any database, not wanting the code to do it jus a general explanation of the process of gettin info from a database and placing it in game...

May 26 '11 at 10:23 PM UnityDev0008

also sorry to double post here but for now i am looking into using sqlite, if that helps at all..but again im not wantin the code just the general process outlined...thanks

May 26 '11 at 10:29 PM UnityDev0008
(comments are locked)
10|3000 characters needed characters left

2 answers: sort voted first

Use the WWW class to make GET requests to a web server that talks to your database. Typically your webserver would return an XML file. User the WWWForm class to post data back to the database.

more ▼

answered May 26 '11 at 09:15 PM

Graham Dunnett gravatar image

Graham Dunnett ♦♦
11.9k 11 20 65

Im wanting it to not require internet connection, its not an MMORPG and also im just wanting to kno the process of going from database to in game....for instance how would you cause a mob when killed to populate its loot table from the database and then when the player loots that item be able to see its model and all its stats on their character,

Again im not wanting the code for how to do this just a basic outline of the process needed to do so

also thanks for your answer

May 26 '11 at 10:27 PM UnityDev0008
(comments are locked)
10|3000 characters needed characters left

The bitwise operators are & and | for AND and OR. The double operators && and || are the logic ones.

more ▼

answered May 26 '11 at 09:17 PM

aldonaletto gravatar image

aldonaletto
41.5k 16 42 197

i have no clue what you are talking about, could u please explain the relevance to the question?

thanks for your answer anyways

May 26 '11 at 10:27 PM UnityDev0008

Sorry, this damned new Unity Answers put my answer in the wrong question (yours). I tried to delete it then, but now I know it failed.

Jun 06 '11 at 05:42 AM aldonaletto
(comments are locked)
10|3000 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Topics:

x232
x206

asked: May 26 '11 at 07:49 PM

Seen: 1361 times

Last Updated: Jun 06 '11 at 05:42 AM