Perfect World Mysql Database Layout

Results 1 to 3 of 3
  1. #1
    Apprentice briermay is offline
    MemberRank
    Mar 2017 Join Date
    10Posts

    idea 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.


  2. #2
    I Might Piss Somebody Off Bola is offline
    DeveloperRank
    Dec 2011 Join Date
    BrazilLocation
    1,766Posts

    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.

  3. #3
    Apprentice briermay is offline
    MemberRank
    Mar 2017 Join Date
    10Posts

    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



Advertisement