How to configure MySQL for crafting data
Navigate to lua/wos/advswl/config/crafting/sv_craftwos.lua
First the value "wOS.ALCS.Config.Crafting.ShouldCraftingUseMySQL" and set it to true
Then should see the following:
wOS.ALCS.Config.Crafting.CraftingDatabase = wOS.ALCS.Config.Crafting.CraftingDatabase or {}
wOS.ALCS.Config.Crafting.CraftingDatabase.Host = "localhost"
wOS.ALCS.Config.Crafting.CraftingDatabase.Port = 3306
wOS.ALCS.Config.Crafting.CraftingDatabase.Username = "root"
wOS.ALCS.Config.Crafting.CraftingDatabase.Password = ""
wOS.ALCS.Config.Crafting.CraftingDatabase.Database = "wos-crafting"
wOS.ALCS.Config.Crafting.CraftingDatabase.Socket = ""
- "wOS.ALCS.Config.Crafting.CraftingDatabase.Host" determines the domain (IP address, or web address of the website)
- "wOS.ALCS.Config.Crafting.CraftingDatabase.Port" determines the port of the host (Leave it as 3306, which is the default for most web hosts)
- "wOS.ALCS.Config.Crafting.CraftingDatabase.Username" determines the username of the database your trying to access it through
- "wOS.ALCS.Config.Crafting.CraftingDatabase.Password" determines the password of the user you are using
- "wOS.ALCS.Config.Crafting.CraftingDatabase.Database" determines the database attempting to be used
Example
wOS.ALCS.Config.Crafting.CraftingDatabase = wOS.ALCS.Config.Crafting.CraftingDatabase or {}
wOS.ALCS.Config.Crafting.CraftingDatabase.Host = "testwebsite.org"
wOS.ALCS.Config.Crafting.CraftingDatabase.Port = 3306
wOS.ALCS.Config.Crafting.CraftingDatabase.Username = "testwebsite_wos"
wOS.ALCS.Config.Crafting.CraftingDatabase.Password = "wostestingpass"
wOS.ALCS.Config.Crafting.CraftingDatabase.Database = "testwebsite_woscrafting"
wOS.ALCS.Config.Crafting.CraftingDatabase.Socket = ""