Unedited GunZDB?

[wesman2232]

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.

[MentaL]

[Solaire]

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.

[wesman2232]

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.

[Solaire]

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.

[wesman2232]

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.

[DoomReaper]

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