Where the server store information of Characters?

[EndyBH]

Good afternoon staff,

Well I'm a systems developer for the past 4 years I've worked with databases, Oracle, SQL Server, MySQL, Firebird etc ... environments and Java 2EE. NET Framework. Well I'm planning to create a system aimed at Web server administration Perfect World, Based on C #. NET with SQL Server 2005/2008 or MySQL the system can be connected to any of these platforms Database. But I need some information from people more experienced in Perfect World Servers information are the following:

-How or which table of the database it keeps track of the Char? Do you have a specific table? From what I saw the structure of the database does not have a table to store the information of the character such as items that it has in inventory, atribulto Points, Level, and so on.

By chance, he would keep this information in an XML? Or save for another type of data structure? If another data structure that type is? And how can I do to access the data contained in the structure? I think for now that's all you need to know.

[MentaL]

[Romulan]

Only things i will say to you:

cd /root/pwserver/gamedbd
# (anything you want but you must 'cd' to your gamedbd folder)

./gamedbd
# (it will show you some commands you can make on the gamedbd)

Adding note:

cd /root/pwserver/uniquenamed
# (anything you want but you must 'cd' to your uniquenamed folder)

./uniquenamed
# (it will show you some commands you can make on the uniquenamed)

Good luck if you can try somethings with this !

[rbb138]

its really simple they are stored partly in the SQL but mostly in a set of about 20 table files that the server executes to produce a .xml for each character.

the table files can be found in PWServer/gamedbd/wdbhomedb/dbdata/
you can also use "dbtool" under PWServer/gamedbd/ to edit the database and repair/rebuild it etc.

[EndyBH]

What´s in the SQL? You said that partialy is Stored in The SQL, What informations?

[rbb138]

i think, map you have logged out at.
amount of red name.
gm or not.
account bans.
cubigold.
and a few other things....
cant fully remember.

[Romulan]

i think, map you have logged out at.
amount of red name. (nope, it's on iweb...) ^^
gm or not. (yes, the authority part and gm permissions) ^^
account bans. (yes, the forbidding table...)
cubigold. (temporary cubigold before going to the user... not the cubigold amount on the account) iweb again... ^^
and a few other things.... (iplimit and the pointer... the pointer is used by uweb to know where the players are on the map)
cant fully remember.

[EndyBH]

So, this file called gameddb is a DataBase? there are way open this file and see the structure or tables or it not have tables. Becuse the iWeb is a System that access this file for manipulation of Data.

Exist a tool or middleware for .NET, JAVA or any program language that I got maniputation od data in this file? Example

in .NET I Have ADO.NET

in JAVA I Have JDBC

With ADO.NET I can in C# or VB.NET access Data in the SQL Server, Oracle, MySQL

With JDBC I can in JAVA access Data in the SQL Server.

for the file gameddb, there´re someone equals?

[rbb138]

romulan, you say this is stored on the iweb but...
iweb isnt a storage facility its a viewing and editing tool for the server process.
the process takes it infomation from both the SQl and dbf files, just becuase its on the iweb does NOT mean its in the dbf, both the .dbf and the sql work together to create each characters .xml when the server loads.
also there are 2 types of bans, character ban which is stored on the dbf (i think) and account ban which is stored on the SQL.
please go and look through your database before speak please.
and cubigold im not 100% sure about and yea iplimit aswell forgot that lol.

@endy, use dbtool to edit the database, i believe i saw some decompress button somewhere, might be wrong though.

[Romulan]

I don't know...

the gamedbd is a compiled software in C++ and i don't think if there some equals software like this...

the gamedbd have it own storage system for the chars informations...

Take a look at theses folders:
gamewdb/dbdata (i think it's the tables like as mysql tables...)
gamewdb/dbblogs (don't know exactly... i never saw a such type of file like this before PW)