SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2004
    Location
    dddddddddddd
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking Massive Project for me Item's Database for a online mmorpg...

    Hey Planing on making a db's for a online game called http://endlessagesportal.com
    It's good game but not pop. I wanted make more fun for current players and maybe even get some futureplayers for making this site.

    Heres the Idea.

    I need to do sections like weapons and even more sub like melee/weapontech/mindcontrol/magic and such...

    The best way I think is just make a database table with section name ie magic and id number...

    Next I would need a table store info in.

    First off id table auto made when inputing data anyways.. next be the items name then the items section like 3 for melee using the table above that I talked about... Next would need a picture of the item. Then Str/Dex/Wis/skilllvl needed to use the items. This should work for everything heals ammo armor weapons....

    Main 4 requirments to using item is Dex/Str/Wis and Skill lvl... More you kill with melee higher melee lvl goes.. example I got 8 and 27% melee...

    This sounds bad cuz my english is poor. But I hope somone able help me.. Also maybe small discription table aswell and even better comments players can input....

    I need all advice I can get thanks..

  2. #2
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not quite sure what you are after, but you definitley want tables for everyting you can think of

    e.g. a charater table for character names, level, xp, strentght etc
    another table for equipment, e.g sword, shield, backpack , modifiers (e.g +1 for a sword etc) etc, another table for the names of equipment and pictures e.g broad sword, long sword, and their minium usage characteristics ad attack / defence characteristics

    Hope this is a start for you.

    My suggestion is to start small and keep on building up, ad before long you will have a complete system.

  3. #3
    SitePoint Enthusiast
    Join Date
    Dec 2004
    Location
    dddddddddddd
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok only thing is I'm bad at outputting things... I know how make db's but outputting is tricky.

  4. #4
    SitePoint Enthusiast
    Join Date
    Dec 2004
    Location
    dddddddddddd
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Heres an update maybe someone can correct and maybe add to this...


  5. #5
    SitePoint Enthusiast
    Join Date
    Dec 2004
    Location
    dddddddddddd
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  6. #6
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's definitley getting there

    Section #. Depends on whether this text will be used anywhere else in the game. I would think it will be, so create a table

    'SectionNames'
    id integer autoincrement
    name varchar(??) not null
    primary key(id)

    then in your items table you just need section_id rather than section #

    Skill Needed and Skill Level
    Replace these with a skills_required_id

    Then create another table
    'SkillsRequired'
    id integer autoincrement
    item_id integer // link to items table
    skill_id integer // link to a skills name table
    min_str_required integer // minimum strength required
    min_wisdon_required integer // minimum wisdom required
    min_dex_required integer // minimum dexterity required
    min_armour_class integer // minimum armour class required
    promary key (id)
    and so on

    The 'Skills' table woule be similar to the layout for the SectionNames table.

    You mention that you hav data in files. I would strongly suggest that this data in put into tables in the database.

    If the site gets very busy, you can probably de-normailse the tables, so that , for example, rather than have skills_id in the SkilsRequired table, you can replace this with the Skill name itself.

    Hope this helps


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •