how can i create mysql table?
edit: i created one but have a problem
[KalsCrossChat][critical] Failed to open connection!
my discord config:
{
"ServerName": "ARK SkyLine",
"HideServerName": false,
"ShowServerStatusChannels": true,
"Token": "NzM3NjkzOTQ3NTE3NzMwODg3.XyBFBg.qIl7fypxwj-------------",
"HostServerDiscordId": "73702527------",
"GlobalChatChannelId": "737029------",
"Database": {
"host": "localhost",
"user": "root",
"password": "----",
"database": "ark---e"
},
"ShowSteamName": false,
"PollRate": 250,
"StatusPollRateSec": 5,
"ResponsePollRate": 250
}
my config:
{
"ShowSteamName": false,
"HideServerTagOnLocal": false,
"GlobalChatSpamDelaySec": 2.0,
"UseWordBlacklist": true,
"IgnoredLettersForBadWords": " .*_-",
"AdminImmuneToMuteAndSpamDelay": true,
"ChatMuteSecForBadWord": 5.0,
"Tags": [
{
"Tag": "Admin",
"ForAdmin": true,
"Color": "1, 0, 0, .8",
"PermissionGroups": [],
"TribeIds": []
},
{
"Tag": "Mod",
"ForAdmin": false,
"Color": "1, 0.2, 0.2, .8",
"PermissionGroups": [ "Moderator" ],
"TribeIds": []
},
{
"Tag": "Donor",
"ForAdmin": false,
"Color": "1, 0.2, 0.2, .8",
"PermissionGroups": [ "Donator" ],
"TribeIds": []
},
{
"Tag": "Alpha",
"ForAdmin": false,
"Color": "1, 0.2, 0.2, .8",
"PermissionGroups": [],
"TribeIds": [ 1431914772 ]
}
],
"Icons": [
{
"Icon": "/Game/ScorchedEarth/Icons/Weapons/Whip_Icon.Whip_Icon",
"ForAdmin": true,
"PermissionGroups": [],
"TribeIds": []
},
{
"Icon": "/Game/PrimalEarth/CoreBlueprints/Items/Artifacts/Icons/Implant_Icon_Alpha.Implant_Icon_Alpha",
"ForAdmin": false,
"PermissionGroups": [ "Donator" ],
"TribeIds": []
},
{
"Icon": "/Game/PrimalEarth/CoreBlueprints/Items/Consumables/Icons/DinoPoop_Icon.DinoPoop_Icon",
"ForAdmin": false,
"PermissionGroups": [ "ShittyPlayer" ],
"TribeIds": []
},
{
"Icon": "/Game/PrimalEarth/UI/Inventory/Textures/IconDossiers.IconDossiers",
"ForAdmin": false,
"PermissionGroups": [],
"TribeIds": [ 1431914772 ]
}
],
"ChatColors": [
{
"ForAdmin": true,
"ForEveryone": false,
"HideTribeName": true,
"TribeNameColor": "",
"MessageColor": ".8, .5, .5, .9",
"NameColor": "0, .9, 0.9, .9",
"OverrideGraySelfNameColor": true,
"PermissionGroups": [],
"TribeIds": []
}
],
"Maps": {
"Ragnarok": {
"MasterServerRunDiscordBot_OnlySetOnOneServer": true,
"Label": "Ragnarok",
"DefaultIcon": "/Game/Genesis/UI/Icons/IconBiomeVolcanic.IconBiomeVolcanic",
"Color": "0.95, 0.62, 0.10, .8"
},
"Aberration_P": {
"Label": "Aberration",
"DefaultIcon": "/Game/Genesis/UI/Icons/IconBiomeLunar.IconBiomeLunar",
"Color": "0.66, 0, 0.66, .8"
},
"CrystalIsles": {
"Label": "Crystal",
"DefaultIcon": "/Game/Genesis/UI/Icons/IconBiomeOcean.IconBiomeOcean",
"Color": "0, 1, 1, .8"
},
"Discord": {
"Label": "Discord",
"DefaultIcon": "/Game/Aberration/Icons/Buffs/Radiation_Icon.Radiation_Icon",
"Color": "0, 1, 1, .8"
}
},
"Messages": {
"MutedTitle": "Muted",
"MutedMessage": "You have<RichColor Color=\"1, 0, 0, 1\">{:.2f}s</> until you can chat next.",
"AnitSpamTitle": "AntiSpam",
"AnitSpamMessage": "You have<RichColor Color=\"1, 0, 0, 1\">{:.2f}s</> until you can chat next.",
"CensorTitle": "Censor",
"CensorMessage": "You cannot say phrases including<RichColor Color=\"1, 0, 0, 1\">{}</>.",
"CensorMute": "You have been muted for<RichColor Color=\"1, 0, 0, 1\">{:.1f}</> seconds.",
"MustBeTribeAdmin": "You must be a tribe admin to use this command.",
"InvalidCode": "Invite code '{}' not found.",
"LinkDiscordSyntax": "Incorrect Syntax: <RichColor Color=\"1, 0, 0, 1\">/linkDiscord</> <RichColor Color=\"0, 1, 0, 1\">inviteCode</>",
"LinkDiscordInvite": "To get an invite code go to discord and use <RichColor Color=\"1, 0, 0, 1\">/linkDiscord</>",
"LinkDiscordSuccess": "Your steam and discord user and now linked. You can use <RichColor Color=\"1, 0, 0, 1\">/kickme</> in discord if needed.",
"LinkTribeLogSyntax": "Incorrect Syntax, try <RichColor Color=\"1, 0, 0, 1\">/linkTribeLog</> <RichColor Color=\"0, 1, 0, 1\">inviteCode</>",
"LinkTribeLogInvite": "To get an invite code: invite chat bot to your own discord, then in the channel you want linked use <RichColor Color=\"1, 0, 0, 1\">/linkTribeLog</>",
"LinkTribeLogSuccess": "Tribe logs is now linked to your discord.",
"UnlinkTribeLogs": "Tribe logs are no longer linked to your discord.",
"TribeChatAlreadyLinked": "Your tribe chat is already linked to a discord channel. Use /unlinkTribe to change.",
"LinkTribeSyntax": "Incorrect Syntax, try <RichColor Color=\"1, 0, 0, 1\">/linkTribe</> <RichColor Color=\"0, 1, 0, 1\">inviteCode</>",
"LinkTribeInvite": "To get an invite code: invite chat bot to your own discord, then in the channel you want linked use <RichColor Color=\"1, 0, 0, 1\">/linkTribe</>",
"LinkTribeSuccess": "Tribe chat is now linked to your discord.",
"LinkTribeAlreadyLinked": "Your tribe chat is already linked to a discord channel. Use <RichColor Color=\"1, 0, 0, 1\">/unlinkTribe</> to change.",
"UnlinkTribeNotLinked": "Your tribe chat is not linked to a discord channel.",
"UnlinkTribeSuccess": "Tribe chat is no longer linked to your discord.",
"TribeChatTag": "(TRIBE)",
"LocalChatTag": "(LOCAL)",
"AllyChatTag": "(ALLY)"
},
"Mysql": {
"MysqlHost": "localhost",
"MysqlUser": "root",
"MysqlPass": "-----",
"MysqlDB": "ark---e"
}
}
PLZ HELP ME