Unedited GunZDB?

Results 1 to 6 of 6
  1. #1
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Unedited GunZDB?

    Is there any way I could get a copy of a GunZ DB that hasn't been wiped, and still has an official servers data inside it?
    I don't care about passwords, but I'm wanting to go through one if I can and learn how all the tables are in relations to others and how they affect the game. I know there are dependencies, but im also wanting to know their relation to the game.

    If there is no such DB available, then ill learn them myself once our server gets going and starts filling the DB with data.

    Thanks.

    EDIT: Just now realized that this is in the wrong section. I'm posting from my mobile. Please move this to the general GunZ section.
    Last edited by wesman2232; 22-12-12 at 10:03 AM.


  2. #2
    Praise the Sun! Solaire is offline
    MemberRank
    Dec 2007 Join Date
    Undead BurgLocation
    2,862Posts

    Re: Unedited GunZDB?

    Nope, your best bet is to list the foreign keys (MSSQL Management should have a function to display them) or draw a Physical Data Model yourself and then learn from that.

    Also, stored procedures such as spInsertChar will give you a view on how characters are created and thus how the database works accordingly.

  3. #3
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Unedited GunZDB?

    Quote Originally Posted by Wizkidje View Post
    Nope, your best bet is to list the foreign keys (MSSQL Management should have a function to display them) or draw a Physical Data Model yourself and then learn from that.

    Also, stored procedures such as spInsertChar will give you a view on how characters are created and thus how the database works accordingly.
    There's many unused tables in the DB. But they were created for some reason, wether they were used for the website or for the game. The Event tables are an example. NHN's tables, tmp events, account penaltys. We have all these tables, but we don't even use them all. Which is why I'm trying to find their relations between them all and how some might affect the game.

    I'll take your suggestion and try that out. Thanks.

  4. #4
    Praise the Sun! Solaire is offline
    MemberRank
    Dec 2007 Join Date
    Undead BurgLocation
    2,862Posts

    Re: Unedited GunZDB?

    Quote Originally Posted by wesman2232 View Post
    There's many unused tables in the DB. But they were created for some reason, wether they were used for the website or for the game. The Event tables are an example. NHN's tables, tmp events, account penaltys. We have all these tables, but we don't even use them all. Which is why I'm trying to find their relations between them all and how some might affect the game.

    I'll take your suggestion and try that out. Thanks.
    I have no idea, since I never really looked at the GunZ source, but I'm sure you can find a lot of related information in the MMatchDBMGr class, which most likely still has all that tables in it, commented out.

  5. #5
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Unedited GunZDB?

    Quote Originally Posted by Wizkidje View Post
    I have no idea, since I never really looked at the GunZ source, but I'm sure you can find a lot of related information in the MMatchDBMGr class, which most likely still has all that tables in it, commented out.
    Alright. I don't even know how to load the GunZ source, let alone read it though. I don't touch it, leave it to the people who know how to mess with it.

  6. #6
    Member DoomReaper is offline
    MemberRank
    Nov 2012 Join Date
    78Posts

    Re: Unedited GunZDB?

    wesman you should learn to be a very good gunz dev and after that try to make a server any way i agree with Wizkidje



Advertisement