Java Version: 1.8.0_91
Up-time: 5h 38m
CraftBukkit Version: git-Spigot-90f61bc-5e5cf84 (MC: 1.10.2)
Denizen Version: Core: 1.15 (Build 86), CraftBukkit: 1.0.1-SNAPSHOT (build 135)
Active Plugins (23): MinecraftMarket: 2.1.2, CustomParticleEffects: 2.2.1, Platforms: 1.0, WorldEdit: 6.1.3;7a097ca,
MVdWPlaceholderAPI: 1.0.0, SuperTrails: 9.5.5, FeatherBoard: 3.11.1, SQLPerms: 2.3.2,
SimpleAPI: 1.7, Vault: 1.5.6-b49, Votifier: 2.3.1, ProtocolSupport: 4.24.dev,
WorldGuard: 6.1.2;e38d98d, ProtocolLib: 4.1.0-SNAPSHOT-b317, TitleAdvanced: 5.10.1,
Denizen: 1.0.1-SNAPSHOT (build 135), XCore: 1.0, SuperbVote: 0.2, EzChat: 1.1.0,
HolographicDisplays: 2.2, ServerListPlus: 3.4.6, Depenizen: 1.0.0 (build 380),
TouchscreenHolograms: 1.3.1
Loaded Worlds (1): MainLobby
Online Players (0): No Online Players
Offline Players: 661
Mode: offline
10:39:34 [INFO] Starting InstantQueue 'EXCOMMAND_DisorderExcellentRealty'...
10:39:34 [INFO] Queue 'EXCOMMAND_DisorderExcellentRealty' Executing: RUN
"s@XPCoreEvents" "p:start"
10:39:34 [INFO] +- Executing dCommand: RUN ---------+
10:39:34 [INFO] +> Executing 'RUN': script='XPCOREEVENTS(WORLD)' path='start'
10:39:34 [INFO] Starting TimedQueue
'XPCOREEVENTS_CommandsThailandOccupations'...
10:39:34 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "yamlName" "XPCore"
10:39:34 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:34 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='yamlname' value='XPCore'
10:39:34 [INFO] Completing queue 'EXCOMMAND_DisorderExcellentRealty' in 1ms.
10:39:34 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "scriptName" "<script.name>"
10:39:34 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:34 [INFO] Filled tag <script.name> with 'XPCOREEVENTS'.
10:39:34 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='scriptname' value='XPCOREEVENTS'
10:39:35 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<yaml.list.contains[%yamlName%_config]>" "{" "-" "yaml"
"unload" "id:%yamlName%_config" "}"
10:39:35 [INFO] +- Executing dCommand: IF ---------+
10:39:35 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:35 [INFO] +> Executing 'IF': use_braces='true'
10:39:35 [INFO] Filled tag <yaml.list.contains[XPCore_config]> with 'false'.
10:39:35 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
YAML "load:scripts/%yamlName%.yml" "id:%yamlName%_config"
10:39:35 [INFO] +- Executing dCommand: YAML ---------+
10:39:35 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:35 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:35 [INFO] +> Executing 'YAML': id='XPCore_config' action='LOAD'
filename='scripts/XPCore.yml' value=''
fix_formatting='false'
10:39:36 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<yaml.list.contains[%yamlName%_config]>" "{" "-"
"announce" "<&c>XPCore<&co><&b> An error occurred while
loading %yamlName%!" "to_console" "-" "announce"
"<&b>XPCore<&co><&3> Aborting..." "to_console" "-" "inject"
"s@%scriptName%" "p:unload" "}"
10:39:36 [INFO] +- Executing dCommand: IF ---------+
10:39:36 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:36 [INFO] +> Executing 'IF': use_braces='true'
10:39:36 [INFO] Filled tag <yaml.list.contains[XPCore_config]> with 'true'.
10:39:36 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "config" "s@XPCore_Configurations"
10:39:36 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:36 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='config' value='s@XPCore_Configurations'
10:39:37 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "structure" "s@XPCoreSQL"
10:39:37 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:37 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='structure' value='s@XPCoreSQL'
10:39:37 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "db"
"<s@XPCore_Configurations.yaml_key[config.MySQL.database]||false>"
10:39:37 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:37 [INFO] Filled tag
<s@XPCore_Configurations.yaml_key[config.MySQL.database]||false>
with 'Server'.
10:39:37 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='db' value='Server'
10:39:38 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "5"
10:39:38 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:38 [INFO] +> Executing 'REPEAT': qty='5'
10:39:38 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<yaml.list.contains[SQLManager_Offline].not>" "{" "-"
"announce" "to_console" "XPCore<&co> Waiting for SQLManager to
come online..." "-" "wait" "1s" "}" "else" "{" "-" "repeat"
"stop" "}"
10:39:38 [INFO] +- Executing dCommand: IF ---------+
10:39:38 [INFO] +> Executing 'IF': use_braces='true'
10:39:38 [INFO] Filled tag <yaml.list.contains[SQLManager_Offline].not> with
'false'.
10:39:38 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "stop"
10:39:38 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:38 [INFO] +> Executing 'REPEAT': stop='true'
10:39:38 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<yaml.list.contains[SQLManager_Offline].not>" "{" "-"
"announce" "to_console" "XPCore<&co> SQLManager FAILED!" "-"
"announce" "to_console" "XPCore<&co> Aborting startup!" "-"
"queue" "clear" "}"
10:39:38 [INFO] +- Executing dCommand: IF ---------+
10:39:38 [INFO] +> Executing 'IF': use_braces='true'
10:39:38 [INFO] Filled tag <yaml.list.contains[SQLManager_Offline].not> with
'false'.
10:39:39 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "status"
"<yaml[SQLManager_Offline].read[Offline_Cache.databases.%db%.status]||null>"
10:39:39 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:39 [INFO] Filled definition %db% with 'Server'.
10:39:39 [INFO] Filled tag
<yaml[SQLManager_Offline].read[Offline_Cache.databases.Server.status]||null>
with 'offline'.
10:39:39 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='status' value='offline'
10:39:39 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[status].is[==].to[connecting]>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> Already attempting to reconnect to
%db% database!" "to_console" "}" "else" "{" "-" "yaml" "set"
"id:SQLManager_Offline"
"Offline_Cache.databases.%db%.status:connecting" "-" "yaml"
"savefile:SQLManager/cache.yml" "id:SQLManager_Offline" "-"
"inject" "s@SQLManager" "}"
10:39:39 [INFO] +- Executing dCommand: IF ---------+
10:39:39 [INFO] +> Executing 'IF': use_braces='true'
10:39:39 [INFO] Filled tag <def[status].is[==].to[connecting]> with 'false'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
YAML "set" "id:SQLManager_Offline"
"Offline_Cache.databases.%db%.status:connecting"
10:39:40 [INFO] +- Executing dCommand: YAML ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'YAML': id='SQLManager_Offline' action='SET'
yaml_action='SET_VALUE'
key='Offline_Cache.databases.Server.status'
value='connecting' fix_formatting='false'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
YAML "savefile:SQLManager/cache.yml" "id:SQLManager_Offline"
10:39:40 [INFO] +- Executing dCommand: YAML ---------+
10:39:40 [INFO] +> Executing 'YAML': id='SQLManager_Offline' action='SAVE'
filename='SQLManager/cache.yml' value=''
fix_formatting='false'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "s@SQLManager"
10:39:40 [INFO] +- Executing dCommand: INJECT ---------+
10:39:40 [INFO] +> Executing 'INJECT': script='SQLMANAGER(TASK)'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "requisiteDataCheck" "instantly"
10:39:40 [INFO] +- Executing dCommand: INJECT ---------+
10:39:40 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
instant='true' path='requisiteDataCheck' local='true'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<def[yamlName].exists>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> You must define a yamlName before we
proceed!" "to_console" "-" "define" "fail" "true" "}" "else"
"if" "!<yaml.list.contains[%yamlName%_config]>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> %yamlName% config.yml not
loaded!" "to_console" "-" "define" "fail" "true" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag <def[yamlName].exists> with 'true'.
10:39:40 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:40 [INFO] Filled tag <yaml.list.contains[XPCore_config]> with 'true'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<def[scriptName].exists>" "||"
"<def[scriptName].as_script.is[==].to[null]||true>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> You must define a valid
scriptName before we proceed!" "to_console" "-" "define"
"fail" "true" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag <def[scriptName].exists> with 'true'.
10:39:40 [INFO] Filled tag <def[scriptName].as_script.is[==].to[null]||true>
with 'false'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[fail].exists>" "{" "-" "announce"
"<&b>SQLManager<&co> <&4>Please fix the errors listed above
before continuing!" "to_console" "-" "announce"
"<&b>SQLManager<&co><&c> Aborting!" "to_console" "-" "inject"
"locally" "unload" "-" "queue" "stop" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag <def[fail].exists> with 'false'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&a> Requisite data found!"
"to_console"
10:39:40 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:40 [INFO] Filled tag <&b> with ''.
10:39:40 [INFO] Filled tag <&co> with ':'.
10:39:40 [INFO] Filled tag <&a> with ''.
10:39:40 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Requisite data
found!' Type='TO_CONSOLE'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> Loading connection data..."
"to_console"
10:39:40 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:40 [INFO] Filled tag <&b> with ''.
10:39:40 [INFO] Filled tag <&co> with ':'.
10:39:40 [INFO] Filled tag <&3> with ''.
10:39:40 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Loading
connection data...' Type='TO_CONSOLE'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "loadConnectionData" "instantly"
10:39:40 [INFO] +- Executing dCommand: INJECT ---------+
10:39:40 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
instant='true' path='loadConnectionData' local='true'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "db"
"<def[config].yaml_key[config.MySQL.database]||DenizenSQLManagerTest>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.database]||DenizenSQLManagerTest>
with 'Server'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='db' value='Server'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "retry"
"<def[config].yaml_key[config.MySQL.connection.retry]||3>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.retry]||3> with
'3'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='retry' value='3'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "retryDelay"
"<def[config].yaml_key[config.MySQL.connection.retryDelay]||10s>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.retryDelay]||10s>
with '10s'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='retrydelay' value='10s'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "keepAlive"
"<def[config].yaml_key[config.MySQL.connection.keepAlive]||5m>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.keepAlive]||5m>
with '5m'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='keepalive' value='5m'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "host"
"<def[config].yaml_key[config.MySQL.connection.host]||localhost>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.host]||localhost>
with 'localhost'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='host' value='localhost'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "port"
"<def[config].yaml_key[config.MySQL.connection.port]||3306>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.port]||3306>
with '3306'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='port' value='3306'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "username"
"<def[config].yaml_key[config.MySQL.connection.username]||root>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.username]||root>
with 'root'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='username' value='root'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "password"
"<def[config].yaml_key[config.MySQL.connection.password]||password>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.password]||password>
with 'ThisPWsucks123'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='password' value='ThisPWsucks123'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "initDatabase"
10:39:40 [INFO] +- Executing dCommand: INJECT ---------+
10:39:40 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
path='initDatabase' local='true'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<server.list_sql_connections.contains[%db%_query]>" "{"
"-" "announce" "<&b>SQLManager<&co><&c> Closing existing
%db%_query database connection..." "to_console" "-" "~sql"
"disconnect" "id:%db%_query" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag
<server.list_sql_connections.contains[Server_query]> with
'false'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> Attempting to connect to
server..." "to_console"
10:39:40 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:40 [INFO] Filled tag <&b> with ''.
10:39:40 [INFO] Filled tag <&co> with ':'.
10:39:40 [INFO] Filled tag <&3> with ''.
10:39:40 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Attempting to
connect to server...' Type='TO_CONSOLE'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
SQL "id:%db%_query" "connect:%host%:%port%"
"username:%username%" "password:%password%"
10:39:40 [INFO] +- Executing dCommand: SQL ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] Filled definition %host% with 'localhost'.
10:39:40 [INFO] Filled definition %port% with '3306'.
10:39:40 [INFO] Filled definition %username% with 'root'.
10:39:40 [INFO] Filled definition %password% with 'ThisPWsucks123'.
10:39:40 [INFO] +> Executing 'SQL': sqlid='Server_query' action='CONNECT'
server='localhost:3306' username='root' password='NotLogged'
10:39:40 [INFO] Successfully connected to localhost:3306
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "%retry%" "{" "-" "if"
"!<server.list_sql_connections.contains[%db%_query]>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> Failed to connect to
server!" "to_console" "-" "wait"
"<def[retryDelay].as_duration>" "-" "if"
"<yaml.list.contains[%yamlName%_config]>" "{" "-" "announce"
"<&b>SQLManager<&co><&d> Reloading %yamlName% config.yml..."
"to_console" "-" "yaml" "unload" "id:%yamlName%_config" "-"
"yaml" "load:scripts/%yamlName%.yml" "id:%yaml... * snip! *
10:39:40 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:40 [INFO] Filled definition %retry% with '3'.
10:39:40 [INFO] +> Executing 'REPEAT': qty='3'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<server.list_sql_connections.contains[%db%_query]>" "{"
"-" "announce" "<&b>SQLManager<&co><&c> Failed to connect to
server!" "to_console" "-" "wait"
"<def[retryDelay].as_duration>" "-" "if"
"<yaml.list.contains[%yamlName%_config]>" "{" "-" "announce"
"<&b>SQLManager<&co><&d> Reloading %yamlName% config.yml..."
"to_console" "-" "yaml" "unload" "id:%yamlName%_config" "-"
"yaml" "load:scripts/%yamlName%.yml" "id:%yamlName%_config"
"}" "-" "anno... * snip! *
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag
<server.list_sql_connections.contains[Server_query]> with
'true'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "stop"
10:39:40 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:40 [INFO] +> Executing 'REPEAT': stop='true'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<server.list_sql_connections.contains[%db%_query]>" "{"
"-" "announce" "<&b>SQLManager<&co><&c> Failed to connect to
server!" "to_console" "-" "announce" "<&b>SQLManager<&co><&3>
Please verify that you have configured all the MySQL
connections info in the %yamlName% config.yml file!"
"to_console" "-" "inject" "locally" "unload" "-" "queue"
"stop" "}" "else" "{" "-" "announce" "<&b>SQLManager<&co><&a>
Successfully connected to server!" "to_con... * snip! *
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag
<server.list_sql_connections.contains[Server_query]> with
'true'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&a> Successfully connected to
server!" "to_console"
10:39:40 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:40 [INFO] Filled tag <&b> with ''.
10:39:40 [INFO] Filled tag <&co> with ':'.
10:39:40 [INFO] Filled tag <&a> with ''.
10:39:40 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Successfully
connected to server!' Type='TO_CONSOLE'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
SQL "id:%db%_query" "query:SELECT SCHEMA_NAME FROM
INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME ='%db%'"
"save:dbExists"
10:39:40 [INFO] +- Executing dCommand: SQL ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] ...remembering this script entry as 'dbExists'!
10:39:40 [INFO] +> Executing 'SQL': sqlid='Server_query' action='QUERY'
query='SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME ='Server''
10:39:40 [INFO] Running query SELECT SCHEMA_NAME FROM
INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME ='Server'
10:39:40 [INFO] Got a query result of 1 columns
10:39:40 [INFO] Got a query result of 1 rows
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "dbExists"
"<entry[dbExists].result.get[1].split[/].get[1]||null>"
10:39:40 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:40 [INFO] Filled tag
<entry[dbExists].result.get[1].split[/].get[1]||null> with
'Server'.
10:39:40 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='dbexists' value='Server'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[dbExists].is[==].to[null]>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> %db% database does not exist!"
"to_console" "-" "announce" "<&b>SQLManager<&co><&e> You must
create an empty database before we continue!" "to_console" "-"
"inject" "locally" "unload" "-" "queue" "stop" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag <def[dbExists].is[==].to[null]> with 'false'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[dbExists].is[==].to[%db%]>" "{" "-" "announce"
"<&b>SQLManager<&co><&3> %db% database found..." "to_console"
"}" "else" "{" "-" "announce" "<&b>SQLManager<&co><&c>
Something went wrong testing the %db% database!" "to_console"
"-" "announce" "<&b>SQLManager<&co><&c> The %db% database
check returned %dbExists%" "to_console" "-" "inject" "locally"
"unload" "-" "queue" "stop" "}"
10:39:40 [INFO] +- Executing dCommand: IF ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'IF': use_braces='true'
10:39:40 [INFO] Filled tag <def[dbExists].is[==].to[Server]> with 'true'.
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> %db% database found..."
"to_console"
10:39:40 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] Filled tag <&b> with ''.
10:39:40 [INFO] Filled tag <&co> with ':'.
10:39:40 [INFO] Filled tag <&3> with ''.
10:39:40 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Server database
found...' Type='TO_CONSOLE'
10:39:40 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
SQL "id:%db%_query" "disconnect"
10:39:40 [INFO] +- Executing dCommand: SQL ---------+
10:39:40 [INFO] Filled definition %db% with 'Server'.
10:39:40 [INFO] +> Executing 'SQL': sqlid='Server_query' action='DISCONNECT'
10:39:40 [INFO] Disconnected from 'Server_query'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "sqlConnection"
10:39:41 [INFO] +- Executing dCommand: INJECT ---------+
10:39:41 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
path='sqlConnection' local='true'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "loadConnectionData" "instantly"
10:39:41 [INFO] +- Executing dCommand: INJECT ---------+
10:39:41 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
instant='true' path='loadConnectionData' local='true'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "db"
"<def[config].yaml_key[config.MySQL.database]||DenizenSQLManagerTest>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.database]||DenizenSQLManagerTest>
with 'Server'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='db' value='Server'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "retry"
"<def[config].yaml_key[config.MySQL.connection.retry]||3>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.retry]||3> with
'3'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='retry' value='3'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "retryDelay"
"<def[config].yaml_key[config.MySQL.connection.retryDelay]||10s>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.retryDelay]||10s>
with '10s'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='retrydelay' value='10s'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "keepAlive"
"<def[config].yaml_key[config.MySQL.connection.keepAlive]||5m>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.keepAlive]||5m>
with '5m'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='keepalive' value='5m'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "host"
"<def[config].yaml_key[config.MySQL.connection.host]||localhost>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.host]||localhost>
with 'localhost'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='host' value='localhost'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "port"
"<def[config].yaml_key[config.MySQL.connection.port]||3306>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.port]||3306>
with '3306'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='port' value='3306'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "username"
"<def[config].yaml_key[config.MySQL.connection.username]||root>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.username]||root>
with 'root'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='username' value='root'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "password"
"<def[config].yaml_key[config.MySQL.connection.password]||password>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.connection.password]||password>
with 'ThisPWsucks123'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='password' value='ThisPWsucks123'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<proc[SQLManager_ConnectionCheck].context[%db%]>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> Closing existing %db%
database connection..." "to_console" "-" "~sql" "disconnect"
"id:%db%" "}"
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Adding definition %db% as Server
10:39:41 [INFO] ERROR in script 'SQLMANAGER_CONNECTIONCHECK'! Not connected
to server with ID 'Server'!
10:39:41 [INFO] Filled tag <proc[SQLManager_ConnectionCheck].context[Server]>
with 'false'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> Attempting to connect to the
%db% database..." "to_console"
10:39:41 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled tag <&b> with ''.
10:39:41 [INFO] Filled tag <&co> with ':'.
10:39:41 [INFO] Filled tag <&3> with ''.
10:39:41 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Attempting to
connect to the Server database...' Type='TO_CONSOLE'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
SQL "id:%db%" "connect:%host%:%port%/%db%"
"username:%username%" "password:%password%"
10:39:41 [INFO] +- Executing dCommand: SQL ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled definition %host% with 'localhost'.
10:39:41 [INFO] Filled definition %port% with '3306'.
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled definition %username% with 'root'.
10:39:41 [INFO] Filled definition %password% with 'ThisPWsucks123'.
10:39:41 [INFO] +> Executing 'SQL': sqlid='Server' action='CONNECT'
server='localhost:3306/Server' username='root'
password='NotLogged'
10:39:41 [INFO] Successfully connected to localhost:3306/Server
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "%retry%" "{" "-" "if"
"!<proc[SQLManager_ConnectionCheck].context[%db%]>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> Failed to connect to
database!" "to_console" "-" "wait"
"<def[retryDelay].as_duration>" "-" "if"
"<yaml.list.contains[%yamlName%_config]>" "{" "-" "announce"
"<&b>SQLManager<&co><&d> Reloading %yamlName% config.yml..."
"to_console" "-" "yaml" "unload" "id:%yamlName%_config" "-"
"yaml" "load:%yamlName%/config.yml" "id:%yamlN... * snip! *
10:39:41 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:41 [INFO] Filled definition %retry% with '3'.
10:39:41 [INFO] +> Executing 'REPEAT': qty='3'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "!<proc[SQLManager_ConnectionCheck].context[%db%]>" "{" "-"
"announce" "<&b>SQLManager<&co><&c> Failed to connect to
database!" "to_console" "-" "wait"
"<def[retryDelay].as_duration>" "-" "if"
"<yaml.list.contains[%yamlName%_config]>" "{" "-" "announce"
"<&b>SQLManager<&co><&d> Reloading %yamlName% config.yml..."
"to_console" "-" "yaml" "unload" "id:%yamlName%_config" "-"
"yaml" "load:%yamlName%/config.yml" "id:%yamlName%_config" "}"
"-" "annou... * snip! *
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Adding definition %db% as Server
10:39:41 [INFO] Filled tag <proc[SQLManager_ConnectionCheck].context[Server]>
with 'true'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
REPEAT "stop"
10:39:41 [INFO] +- Executing dCommand: REPEAT ---------+
10:39:41 [INFO] +> Executing 'REPEAT': stop='true'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<proc[SQLManager_ConnectionCheck].context[%db%]>" "{" "-"
"announce" "<&b>SQLManager<&co><&a> Connected to the %db%
database!" "to_console" "}" "else" "{" "-" "announce"
"<&b>SQLManager<&co><&c> Failed to connect to the %db%
database!" "to_console" "-" "announce"
"<&b>SQLManager<&co><&3> Please verify that you have created
the <&b>%db%<&3> database and have configured all the MySQL
connections info in the %yamlName% config.yml file!"
"to_conso... * snip! *
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Adding definition %db% as Server
10:39:41 [INFO] Filled tag <proc[SQLManager_ConnectionCheck].context[Server]>
with 'true'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&a> Connected to the %db%
database!" "to_console"
10:39:41 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled tag <&b> with ''.
10:39:41 [INFO] Filled tag <&co> with ':'.
10:39:41 [INFO] Filled tag <&a> with ''.
10:39:41 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Connected to the
Server database!' Type='TO_CONSOLE'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "initTables"
10:39:41 [INFO] +- Executing dCommand: INJECT ---------+
10:39:41 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
path='initTables' local='true'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> Initializing tables..."
"to_console"
10:39:41 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:41 [INFO] Filled tag <&b> with ''.
10:39:41 [INFO] Filled tag <&co> with ':'.
10:39:41 [INFO] Filled tag <&3> with ''.
10:39:41 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Initializing
tables...' Type='TO_CONSOLE'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "tables"
"<def[config].list_keys[config.MySQL.tables]||li@>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled tag <def[config].list_keys[config.MySQL.tables]||li@>
with 'li@XPCoreValues'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='tables' value='li@XPCoreValues'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[tables].is_empty||true>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> No Tables Exist!" "to_console" "-"
"announce" "<&b>SQLManager<&co><&3> Please verify that you
have created your table declarations for the <&b>%db%<&3>
database as described in the Usage comments in
<&b><script.relative_filename><&3>!" "to_console" "-" "inject"
"locally" "unload" "-" "queue" "stop" "}"
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Filled tag <def[tables].is_empty||true> with 'false'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
FOREACH "%tables%" "{" "-" "define" "table" "%value%" "-"
"define" "tableName"
"<def[config].yaml_key[config.MySQL.tables.%table%]||null>"
"-" "if" "<def[tableName].is[==].to[null]>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> Table <&b>%table%<&c> Not Named!"
"to_console" "-" "announce" "<&b>SQLManager<&co><&3> Please
verify that you have created your config.yml file for the
<&b>%db%<&3> database as described in the Usage comments in
<&b><script.... * snip! *
10:39:41 [INFO] +- Executing dCommand: FOREACH ---------+
10:39:41 [INFO] Filled definition %tables% with 'li@XPCoreValues'.
10:39:41 [INFO] +> Executing 'FOREACH': list='li@XPCoreValues'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "table" "%value%"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled definition %value% with 'XPCoreValues'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='table' value='XPCoreValues'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "tableName"
"<def[config].yaml_key[config.MySQL.tables.%table%]||null>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled definition %table% with 'XPCoreValues'.
10:39:41 [INFO] Filled tag
<def[config].yaml_key[config.MySQL.tables.XPCoreValues]||null>
with 'XPCore'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='tablename' value='XPCore'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[tableName].is[==].to[null]>" "{" "-" "announce"
"<&b>SQLManager<&co><&c> Table <&b>%table%<&c> Not Named!"
"to_console" "-" "announce" "<&b>SQLManager<&co><&3> Please
verify that you have created your config.yml file for the
<&b>%db%<&3> database as described in the Usage comments in
<&b><script.relative_filename><&3>!" "to_console" "-" "inject"
"locally" "unload" "-" "queue" "stop" "}"
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Filled tag <def[tableName].is[==].to[null]> with 'false'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "locally" "testTable" "instantly"
10:39:41 [INFO] +- Executing dCommand: INJECT ---------+
10:39:41 [INFO] +> Executing 'INJECT': Container='SQLMANAGER(TASK)'
instant='true' path='testTable' local='true'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
SQL "id:%db%" "query:SELECT COUNT(*) FROM
information_schema.tables WHERE table_schema='%db%' AND
table_name='%tableName%';" "save:%tableName%_tableExists"
10:39:41 [INFO] +- Executing dCommand: SQL ---------+
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled definition %db% with 'Server'.
10:39:41 [INFO] Filled definition %tableName% with 'XPCore'.
10:39:41 [INFO] Filled definition %tableName% with 'XPCore'.
10:39:41 [INFO] ...remembering this script entry as 'XPCore_tableExists'!
10:39:41 [INFO] +> Executing 'SQL': sqlid='Server' action='QUERY'
query='SELECT COUNT(*) FROM information_schema.tables WHERE
table_schema='Server' AND table_name='XPCore';'
10:39:41 [INFO] Running query SELECT COUNT(*) FROM information_schema.tables
WHERE table_schema='Server' AND table_name='XPCore';
10:39:41 [INFO] Got a query result of 1 columns
10:39:41 [INFO] Got a query result of 1 rows
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
DEFINE "tableExists"
"<entry[%tableName%_tableExists].result.get[1].split[/].get[1]||null>"
10:39:41 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:41 [INFO] Filled definition %tableName% with 'XPCore'.
10:39:41 [INFO] Filled tag
<entry[XPCore_tableExists].result.get[1].split[/].get[1]||null>
with '1'.
10:39:41 [INFO] +> Executing 'DEFINE':
queue='XPCOREEVENTS_CommandsThailandOccupations'
definition='tableexists' value='1'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<def[tableExists].is[==].to[0]>" "{" "-" "announce"
"<&b>SQLManager<&co><&3> Creating %tableName%..." "to_console"
"-" "inject" "locally" "createTable" "instantly" "}" "else"
"if" "<def[tableExists].is[==].to[1]>" "{" "-" "announce"
"<&b>SQLManager<&co><&3> %tableName% table found..."
"to_console" "}" "else" "{" "-" "announce"
"<&b>SQLManager<&co><&c> Something went wrong testing the
%tableName% table!" "to_console" "-" "announce"
"<&b>SQLMana... * snip! *
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] +> Executing 'IF': use_braces='true'
10:39:41 [INFO] Filled tag <def[tableExists].is[==].to[0]> with 'false'.
10:39:41 [INFO] Filled tag <def[tableExists].is[==].to[1]> with 'true'.
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> %tableName% table found..."
"to_console"
10:39:41 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:41 [INFO] Filled definition %tableName% with 'XPCore'.
10:39:41 [INFO] Filled tag <&b> with ''.
10:39:41 [INFO] Filled tag <&co> with ':'.
10:39:41 [INFO] Filled tag <&3> with ''.
10:39:41 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: XPCore table
found...' Type='TO_CONSOLE'
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
FOREACH " CALLBACK"
10:39:41 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<yaml.list.contains[%yamlName%]>" "yaml" "unload"
"id:%yamlName%"
10:39:41 [INFO] +- Executing dCommand: IF ---------+
10:39:41 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:41 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:41 [INFO] +> Executing 'IF': use_braces='false'
10:39:41 [INFO] Filled tag <yaml.list.contains[XPCore]> with 'false'.
10:39:42 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&a> %db% database loaded!"
"to_console"
10:39:42 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:42 [INFO] Filled definition %db% with 'Server'.
10:39:42 [INFO] Filled tag <&b> with ''.
10:39:42 [INFO] Filled tag <&co> with ':'.
10:39:42 [INFO] Filled tag <&a> with ''.
10:39:42 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Server database
loaded!' Type='TO_CONSOLE'
10:39:42 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
IF "<queue.exists[%db%_HeartBeat]||false>" "{" "-" "announce"
"<&b>SQLManager<&co><&3> Stopping %db% Connection
Heartbeat..." "to_console" "-" "queue" "queue:%db%_HeartBeat"
"stop" "}"
10:39:42 [INFO] +- Executing dCommand: IF ---------+
10:39:42 [INFO] Filled definition %db% with 'Server'.
10:39:42 [INFO] +> Executing 'IF': use_braces='true'
10:39:42 [INFO] Filled tag <queue.exists[Server_HeartBeat]||false> with
'false'.
10:39:42 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
ANNOUNCE "<&b>SQLManager<&co><&3> Starting %db% Connection
Heartbeat..." "to_console"
10:39:42 [INFO] +- Executing dCommand: ANNOUNCE ---------+
10:39:42 [INFO] Filled definition %db% with 'Server'.
10:39:42 [INFO] Filled tag <&b> with ''.
10:39:42 [INFO] Filled tag <&co> with ':'.
10:39:42 [INFO] Filled tag <&3> with ''.
10:39:42 [INFO] +> Executing 'ANNOUNCE': Message='SQLManager: Starting Server
Connection Heartbeat...' Type='TO_CONSOLE'
10:39:42 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
RUN "locally" "keepAlive"
"def:%yamlName%|%scriptName%|%keepAlive%" "id:%db%_HeartBeat"
10:39:42 [INFO] +- Executing dCommand: RUN ---------+
10:39:42 [INFO] Filled definition %yamlName% with 'XPCore'.
10:39:42 [INFO] Filled definition %scriptName% with 'XPCOREEVENTS'.
10:39:42 [INFO] Filled definition %keepAlive% with '5m'.
10:39:42 [INFO] Filled definition %db% with 'Server'.
10:39:42 [INFO] +> Executing 'RUN': script='SQLMANAGER(TASK)'
path='keepAlive' local='true' id='Server_HeartBeat'
definitions='XPCore|XPCOREEVENTS|5m'
10:39:42 [INFO] Adding definition %1% as XPCore
10:39:42 [INFO] Adding definition %2% as XPCOREEVENTS
10:39:42 [INFO] Adding definition %3% as 5m
10:39:42 [INFO] Starting TimedQueue 'Server_HeartBeat'...
10:39:42 [INFO] Queue 'Server_HeartBeat' Executing: DEFINE "yamlName"
"<def[yamlName]||<def[1]||null>>"
10:39:42 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:42 [INFO] Filled tag <def[1]||null> with 'XPCore'.
10:39:42 [INFO] Filled tag <def[yamlName]||XPCore> with 'XPCore'.
10:39:42 [INFO] +> Executing 'DEFINE': queue='Server_HeartBeat'
definition='yamlname' value='XPCore'
10:39:42 [INFO] Queue 'Server_HeartBeat' Executing: DEFINE "scriptName"
"<def[scriptName]||<def[2]||null>>"
10:39:42 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:42 [INFO] Filled tag <def[2]||null> with 'XPCOREEVENTS'.
10:39:42 [INFO] Filled tag <def[scriptName]||XPCOREEVENTS> with
'XPCOREEVENTS'.
10:39:42 [INFO] +> Executing 'DEFINE': queue='Server_HeartBeat'
definition='scriptname' value='XPCOREEVENTS'
10:39:42 [INFO] Queue 'Server_HeartBeat' Executing: DEFINE "keepAlive"
"<def[keepAlive]||<def[3]||5m>>"
10:39:42 [INFO] +- Executing dCommand: DEFINE ---------+
10:39:42 [INFO] Filled tag <def[3]||5m> with '5m'.
10:39:42 [INFO] Filled tag <def[keepAlive]||5m> with '5m'.
10:39:42 [INFO] +> Executing 'DEFINE': queue='Server_HeartBeat'
definition='keepalive' value='5m'
10:39:42 [INFO] Queue 'Server_HeartBeat' Executing: WAIT
"<def[keepAlive].as_duration>"
10:39:42 [INFO] +- Executing dCommand: WAIT ---------+
10:39:42 [INFO] Filled tag <def[keepAlive].as_duration> with 'd@300.0s'.
10:39:42 [INFO] +> Executing 'WAIT': queue='Server_HeartBeat'
delay='d@300.0s'
10:39:42 [INFO] Queue 'XPCOREEVENTS_CommandsThailandOccupations' Executing:
INJECT "s@SQLManager_Offline" "p:processOfflineQueue"
10:39:42 [INFO] +- Executing dCommand: INJECT ---------+
10:39:42 [INFO] +> Executing 'INJECT': script='SQLMANAGER_OFFLINE(WORLD)'
path='processOfflineQueue'