database help

Blitz3D Forums/Blitz3D Beginners Area/database help

DCI(Posted 2007) [#1]
Ok, im working on a game.. the basic premise of the game: players start out, pick a quadrent of space (which will consist of well over 5k planets) they find one they like, and begin setting up a colony. building buildings, infrastructure, mining for minerals. etc. building combat units. researching stuff.. this game will have multiple people playing at once, but only if their in combat with one another, .

When a player gathers resources enough to build say, an apartment building.. based on the amount of workers they have, and the conditions of the planet, and the size of the building, i was thinking of having the system do the math, and then, set a date for completion. for the purpose of my explaination, lets say, it will be complete on june 2nd at 3:01 am.. its june 1st now, real time..

These buildings under construction by all of the various players, on various planets, i was thinking, could reside on a single database.. the server program, would watch this database.. and when the time rolls around. it would place the building where it should be, on that planet, and zone's map (and data base) and then clear it, from the under construction database.

what i need, are tutorials on how to work with databases with blitz, how to organize the data, how to read and write entries from the database, and how to search the database. im a relitive newbie to programming.. i used to be an ace with Basica back when i was in highschool.. lol been almost 14 years now. please help! too many tutorals talk about "player entities" when im making more of an empire building/ real time strategy game dealing with ALOT of player controlled pieces.. as well as AI.

i REALLY need help.. please!


Abrexxes(Posted 2007) [#2]
http://www.blitzbasic.com/Community/posts.php?topic=73327

Please stop with your cross postings.


Jasu(Posted 2007) [#3]
Sounds very ambitious. Especially if it'll be your first (big) game.

If you want to use a true database (I don't understand why), then use Visual Basic instead. Easiest method for VB is using Jet with MS Access database.

But I guess you want to use Blitz. For database-like operation, most important thing you need to master is Types with hierarchy. Here's some related info
http://www.blitzbasic.com/Community/posts.php?topic=73096

If you are going to have a huge amount of stuff in memory, I suggest you use memory banks. You might save 10-20% in memory usage.