Polaretto Posted January 28, 2015 Report Share Posted January 28, 2015 I was thinking that maybe having a specific DB download page may help starting users avoid some really common errors. The page should work this way: - The page could be find at trinitycore.org/d - The user should select the Branch (3.3.5/6.x) - Then may select an older DB version from a dropdown list [DEST] - It may even select the DB version it is using now [ORIG] - And finally a Download button appears that outputs directly a zipped folder with both the basic DB and the updates merged in an "updates_from_ORIG_to_DEST.sql" file. Not sure it was clear... By the way, what do you think about that? 1 Link to comment Share on other sites More sharing options...
YaGa Posted January 28, 2015 Report Share Posted January 28, 2015 sounds really nice and would be comfortable, but is it really necessary? It is not that hard to manually sum up and apply the patches I think Link to comment Share on other sites More sharing options...
Polaretto Posted January 28, 2015 Author Report Share Posted January 28, 2015 Of course it is not, but think at db and updates, they've been distributed this way since the beginning. Are there any reason to not make simpler and faster things like these, which are done (manually) very frequently? Link to comment Share on other sites More sharing options...
hackersrage Posted November 8, 2015 Report Share Posted November 8, 2015 (edited) @Polaretto If you check the worldserver.conf file, you will see a couple of settings for automatically applying database patches. The steps are quite simple (even for those not compiling their own build, which I recommend they do since there is no official pre-compiled versions available) . * Download TrinityCore source (git pull { preferred method } / zip archive / whichever ... ) * Edit the worldserver.conf, and if you didn't compile your own, set the parameter for source folder to where TrinityCore source tree is. * Enable automatic database updates * Download (currently 6.02 from July 2015) latest build of the TDB * Import the auth and characters sql files into their respective databases from TrinityCore/sql/base * Import hotfixes and world from TDB sql files into their respective databases (inside the TDB download, not the TrinityCore source) * Start ./worldserver . Now as long as the settings / etc are all correct in worldserver, it will automatically merge new updates from that date forward from the sql patch files in the TrinityCore source that you downloaded in the first step. What I would suggest, is perhaps to include TDB in the sql path as part of the TrinityCore source tree. That would make things a bit easier than trying to load from different places, however there may be a logical reason for why the two projects remain segregated from each other. ################################################################################################### # UPDATE SETTINGS # # Updates.EnableDatabases # Description: A mask that describes which databases shall be updated. # # Following flags are available # DATABASE_LOGIN = 1, // Auth database # DATABASE_CHARACTER = 2, // Character database # DATABASE_WORLD = 4, // World database # DATABASE_HOTFIX = 8, // Hotfixes database # # Default: 0 - (All Disabled) # 4 - (Enable world only) # 15 - (All enabled) Updates.EnableDatabases = 15 # # Updates.SourcePath # Description: The path to your TrinityCore source directory. # If the path is left empty, built-in CMAKE_SOURCE_DIR is used. # Example: "../TrinityCore" # Default: "" Updates.SourcePath = "" # # Updates.MySqlCLIPath # Description: The path to your mysql cli binary. # If the path is left empty, built-in path from cmake is used. # Example: "C:/Program Files/MySQL/MySQL Server 5.6/bin/mysql.exe" # "mysql.exe" # "/usr/bin/mysql" # Default: "" Updates.MySqlCLIPath = "" # # Updates.AutoSetup # Description: Auto populate empty databases. # Default: 1 - (Enabled) # 0 - (Disabled) Updates.AutoSetup = 1 # # Updates.Redundancy # Description: Perform data redundancy checks through hashing # to detect changes on sql updates and reapply it. # Default: 1 - (Enabled) # 0 - (Disabled) Updates.Redundancy = 1 Edited November 8, 2015 by hackersrage 1 Link to comment Share on other sites More sharing options...
Carbenium Posted November 8, 2015 Report Share Posted November 8, 2015 We won't include TDB into the Git tree since it would bloat the size even more. Regards, Carbenium Link to comment Share on other sites More sharing options...
alysher Posted November 10, 2015 Report Share Posted November 10, 2015 I TOTALLY agree with hackersrage, the autoupdate function for the core is really nice! Link to comment Share on other sites More sharing options...
Recommended Posts