-
Apprentice
Perfect World Mysql Database Layout
Hello I am working on creating a custom System for my private perfect world server which is smoothly running 1.5.3. Thing is and I can't find anything through search (tried that already) the MySQL database has a bunch of tables that I'm wondering if anyone knows what they are for. Like for example in the users table I removed *everything* except for ID, name, passwd, email, createtime (after creating a database backup) and the server still runs flawlessly. So does anyone have info on what these tables (ex mw_bankdonate, mw_payments, etc) are for and if they are really needed ? pretty much except for point, users, cashlog, usecashnow and auth, all the rest of the tables on my server are totally empty.
-
-
Re: Perfect World Mysql Database Layout
many structs comes from official servers, the authd we run is based on official MSSQL authd.
few are disabled, but could be enable for some purpose.
-
Apprentice
Re: Perfect World Mysql Database Layout
is there a way to get the source to any of the server daemons like authd ? and personally I think the mw_ tables were added for either iweb or pwAdmin (neither of wich I'm using) because the pw_roles table has fields for all the details of the role sync function I saw in the 1.5.1 pwAdmin before dumping it and now that I think of it a lot of them are probly based on something PWI does if its based off of MS SQL server because the main arc website appears to run ASP.NET (same system I'm using) and probly not even used with the private ones