Thread: Best Database Stratagey?

  1. #1

    Best Database Stratagey?

    I'm making a MMORPG in C, and I would like to know what the BEST way is to build and organize my databases (monsters, skills, weapons, characters, ect.) Any help would be greatly appreciated. I'm building the DB's and Map's before the game itself (right now it's just a MessageBox saying it's incomplete.)

    Oh, and I'm using Dev-Cpp 4.9.9.2 (I love it!)

    [EDIT]
    Don't make fun of me! You guys are jealous because my MMORPG is going to own all (name will not be released so that no ones steals it)!
    Last edited by Dark~Cloud; 01-03-2006 at 08:00 PM. Reason: ...

  2. #2
    Registered User VirtualAce's Avatar
    Join Date
    Aug 2001
    Posts
    9,607
    Hi, I think this is my first post and I'm making a MMORPG in C (it never gets as many errors as C++!),
    Ok?

  3. #3
    That wasn't a useful strategy...

  4. #4
    Slave MadCow257's Avatar
    Join Date
    Jan 2005
    Posts
    735
    I don't know about best strategy, but structs for monsters, weapons, skills, etc. would work. That method pushes alot of code into the world load function, and leaves the main loop nice and simple.

  5. #5
    Do you have an example of this? It would be very useful.

  6. #6
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,659
    > I'm making a MMORPG in C (it never gets as many errors as C++!),
    The first, last and only problem you have then is the dude in the mirror.

    Do you seriously believe that if the compiler doesn't say anything that everything you write is instantly bug free?

    > and I would like to know what the BEST way is to build and organize my databases
    Experience gained from writing lots of programs.

  7. #7
    Registered User VirtualAce's Avatar
    Join Date
    Aug 2001
    Posts
    9,607
    Yours wasn't a useful post...

    Where do you people come from? Mars.

    What kind of statement is that ? Using C because it gets less errors than C++.

    And you wonder why we are so rude sometimes. Don't come here and make assinine, inexperienced, and downright stupid comments and we might actually help you.

    Just do a search and I'm sure you will find plenty of posts here like yours that contribute nothing to programming.

    First of all you want us to tell you a good database design when you don't even understand C++? Secondly you want to code your entire MMORPG in C. Third I can count at least a hundred people here that are making an MMORPG so stand in line.

    C'mon guys. Learn to code before you take on some huge game project. Hell most of us here know how to code and I'm sure they will tell you as I will that game programming is not easy and the more tools you have under your belt, the better. So learn everything you can.

    With your approach I doubt you will get past managing memory.
    Last edited by VirtualAce; 01-03-2006 at 03:40 AM.

  8. #8
    Supermassive black hole cboard_member's Avatar
    Join Date
    Jul 2005
    Posts
    1,709
    Quote Originally Posted by Bubba
    Yours wasn't a useful post...

    Where do you people come from? Mars.

    What kind of statement is that ? Using C because it gets less errors than C++.

    And you wonder why we are so rude sometimes. Don't come here and make assinine, inexperienced, and downright stupid comments and we might actually help you.

    Just do a search and I'm sure you will find plenty of posts here like yours that contribute nothing to programming.

    First of all you want us to tell you a good database design when you don't even understand C++? Secondly you want to code your entire MMORPG in C. Third I can count at least a hundred people here that are making an MMORPG so stand in line.

    C'mon guys. Learn to code before you take on some huge game project. Hell most of us here know how to code and I'm sure they will tell you as I will that game programming is not easy and the more tools you have under your belt, the better. So learn everything you can.

    With your approach I doubt you will get past managing memory.
    I second that. Even having little actual experience in the game development field (mainly just reading and fiddling with OpenGL) I can advise you to thoroughly learn a language; become comfortable with it. Not just the language though, you need a "solid" and well practiced (by you) method of getting ideas into algorithms onto paper - if you spend time designing the structure of your application you'll find it easy (easier) to implement.

    When you're more experienced with this and you want to try something a little more adventureous, you've got hours of reading / typing / compiling / fixing / re-compiling while you get to grips with your graphical API of choice (assuming you intend to do so).
    Good class architecture is not like a Swiss Army Knife; it should be more like a well balanced throwing knife.

    - Mike McShaffry

  9. #9
    I have been practicing. But so far my database is just a ton of INT's.
    This place is just like all the other vB forums I've been on, the members are ***es because the board owner BOUGHT the forum, instead of doing the most money efficient way and get a InvisionFREE forum and forward a subdomains IP to the IP of IF and set up the free domain...

  10. #10
    Registered User
    Join Date
    Aug 2003
    Posts
    1,218
    To your last reply about buying the board and stuff I just have to say this: HAHAHAHAHAHAHAHAHAHAHAHAHAHAHAHAHAHA ROFLMAO!!!!!

    Now to answer the other part: You are not the first person to attempt something way over your head, and to and say something like "I like C better because I get less errors with C than I would with C++" gives you a clue to how good you are. You are simply not ready to create a database, more less an MMORPG (geeez why is everybody so damn in to making MMORPGs, I mean why try among the hardest things you can do in gameprogramming without ALOT of experience first).
    STL Util a small headers-only library with various utility functions. Mainly for fun but feedback is welcome.

  11. #11
    .............................

  12. #12
    aoeuhtns
    Join Date
    Jul 2005
    Posts
    581
    Quote Originally Posted by Dark~Cloud
    I'm making a MMORPG in C, and I would like to know what the BEST way is to build and organize my databases (monsters, skills, weapons, characters, ect.)
    IMHO, you should build and organize your database so that the maximum amount of accumulated time spent querying the database over any given second is minimized. The previous sentence doesn't really say anything about the structure of the database, because you haven't said anything about the structure of your information.

  13. #13
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,659
    dark-cloud uttered in some other thread...
    http://cboard.cprogramming.com/showt...862#post525862
    "A month or two"

    You're just another wet behind the ears weenie to some of us, whose experience is measured in decades, not months.

    Sure, you think you can see the top of the mountain where your completed project lies, but you've NO BLOODY IDEA about all the ravines you're going to have to cross to get there. Your bridges made of match sticks will be quite comical to some of us.

  14. #14
    the hat of redundancy hat nvoigt's Avatar
    Join Date
    Aug 2001
    Location
    Hannover, Germany
    Posts
    3,130
    I have been practicing.
    That's great. Keep doing that. We all started at zero, it's not like those people who posted here magically acquired their knowledge from nowhere. BUT: You want to start at 1000%. An MMORPG is the racing car of all automobiles. You don't start your career as a car mechanic by fine tuning formula 1 cars. You will fail, the car will crash and you will lose interest or simply be fired. Start at a level that can give you successes while learning. Most people here like to help others who are learning. We don't like helping people to fail, because that's wasted time on both accounts.

    This place is just like all the other vB forums I've been on, the members are ***es because the board owner BOUGHT the forum, instead of doing the most money efficient way and get a InvisionFREE forum and forward a subdomains IP to the IP of IF and set up the free domain...
    This part makes no sense at all. I suggest getting some logic skills before working with any programming language.


    If you really want do do an MMORPG in C on your skill level, I would suggest you look into SQL. It's not suited for MMORPGs because it's most likely too slow for the dimensions of a MMORPG unless you have a multi-million dollar database server that can store it's table's in RAM. But the project will fail either way, you could as well learn something useful in the meantime.
    hth
    -nv

    She was so Blonde, she spent 20 minutes looking at the orange juice can because it said "Concentrate."

    When in doubt, read the FAQ.
    Then ask a smart question.

  15. #15
    At last, two useful posts.
    How on earth do you make a game out of SQL? I've been working with it for years and all I've made with it are blog, forum, and tagboards services.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. literature database: help with planning
    By officedog in forum C++ Programming
    Replies: 1
    Last Post: 01-23-2009, 12:34 PM
  2. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  3. Replies: 10
    Last Post: 05-18-2006, 11:23 PM
  4. Developing database management software
    By jdm in forum C++ Programming
    Replies: 4
    Last Post: 06-15-2004, 04:06 PM
  5. Making a Simple Database System
    By Speedy5 in forum C++ Programming
    Replies: 1
    Last Post: 03-14-2003, 10:17 PM