robinp7720/Blue-Stats-Minecraft

View on GitHub
plugins/Statz/Statz.php

Summary

Maintainability
F
1 wk
Test Coverage
<?php

namespace BlueStats\Plugin;

use BlueStats\API\plugin;


class Statz extends plugin {

    public static $isMySQLplugin = TRUE;
    public        $name          = 'Statz';
    public        $database      = [
        "prefix"     => "statz_",
        "identifier" => "uuid", // Can be id, uuid or name. Used to get stats based on id. name or uuid
        "index"      => [ // Define the table which contains used data
                          "table"   => "players",
                          "columns" => [
                              "uuid" => "uuid",
                              "name" => "playerName",
                              "id"   => "id",
                          ],
        ],
        "stats"      => [
            "arrows_shot"     => [
                "database"        => "arrows_shot",
                "name"            => "Arrows shot",
                "user_identifier" => "uuid",
                "text" => [
                  "en_US" => [
                      "single" => "Shot {VALUE} arrow",
                      "plural" => "Shot {VALUE} arrows"
                  ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Arrows shot"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "forceShot",
                        "dataType"  => "int",
                        "aggregate" => FALSE,
                        "name"      => "Force",
                    ],
                ],
            ],
            "blocks_broken"   => [
                "database"        => "blocks_broken",
                "name"            => "Blocks broken",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Broke {VALUE} block",
                        "plural" => "Broke {VALUE} blocks"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "typeid",
                        "dataType"  => "item_id",
                        "aggregate" => FALSE,
                        "name"      => "Item ID",
                    ],
                    [
                        "column"    => "datavalue",
                        "dataType"  => "item_type",
                        "aggregate" => FALSE,
                        "name"      => "Item value",
                    ],
                ],
            ],
            "blocks_placed"   => [
                "database"        => "blocks_placed",
                "name"            => "Blocks placed",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Placed {VALUE} block",
                        "plural" => "Placed {VALUE} blocks"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "typeid",
                        "dataType"  => "item_id",
                        "aggregate" => FALSE,
                        "name"      => "Item ID",
                    ],
                    [
                        "column"    => "datavalue",
                        "dataType"  => "item_type",
                        "aggregate" => FALSE,
                        "name"      => "Item value",
                    ],
                ],
            ],
            "buckets_emptied" => [
                "database"        => "buckets_emptied",
                "name"            => "Buckets emptied",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Emptied {VALUE} bucket",
                        "plural" => "Emptied {VALUE} buckets"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "buckets_filled"  => [
                "database"        => "buckets_filled",
                "name"            => "Buckets filled",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Filled {VALUE} bucket",
                        "plural" => "Filled {VALUE} buckets"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "damage_taken"    => [
                "database"        => "damage_taken",
                "name"            => "Damage taken",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Took {VALUE} damage",
                        "plural" => "Took {VALUE} damage"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Damage"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "cause",
                        "dataType"  => "damage_type",
                        "aggregate" => FALSE,
                        "name"      => "Cause",
                    ],
                ],
            ],
            "deaths"          => [
                "database"        => "deaths",
                "name"            => "Deaths",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Died {VALUE} time",
                        "plural" => "Died {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "distance_travelled"          => [
                "database"        => "distance_travelled",
                "name"            => "Distance traversed",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Traveled {VALUE} block",
                        "plural" => "Traveled {VALUE} blocks"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Distance"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "moveType",
                        "dataType"  => "move_type",
                        "aggregate" => FALSE,
                        "name"      => "Movement Type",
                    ],
                ],
            ],
            "eggs_thrown"     => [
                "database"        => "eggs_thrown",
                "name"            => "Eggs thrown",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Threw {VALUE} egg",
                        "plural" => "Threw {VALUE} eggs"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "entered_beds"    => [
                "database"        => "entered_beds",
                "name"            => "Beds entered",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Entered {VALUE} bed",
                        "plural" => "Entered {VALUE} beds"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "food_eaten"      => [
                "database"        => "food_eaten",
                "name"            => "Food eaten",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Ate {VALUE} food",
                        "plural" => "Ate {VALUE} foods"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "foodEaten",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Food",
                    ],
                ],
            ],
            "items_caught"    => [
                "database"        => "items_caught",
                "name"            => "Items caught",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Caught {VALUE} fish",
                        "plural" => "Caught {VALUE} fish"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "caught",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Item",
                    ],
                ],
            ],
            "items_crafted"   => [
                "database"        => "items_crafted",
                "name"            => "Items crafted",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Crafted {VALUE} item",
                        "plural" => "Crafted {VALUE} items"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "item",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Item",
                    ],
                ],
            ],
            "items_dropped"   => [
                "database"        => "items_dropped",
                "name"            => "Items dropped",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Dropped {VALUE} item",
                        "plural" => "Dropped {VALUE} items"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "item",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Item",
                    ],
                ],
            ],
            "items_picked_up" => [
                "database"        => "items_picked_up",
                "name"            => "Items picked up",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Picked up {VALUE} item",
                        "plural" => "Picked up {VALUE} items"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "item",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Item",
                    ],
                ],
            ],
            "joins"           => [
                "database"        => "joins",
                "name"            => "Joins",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Joined {VALUE} time",
                        "plural" => "Joined {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                ],
            ],
            "kills_mobs"      => [
                "database"        => "kills_mobs",
                "name"            => "Mobs killed",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Killed {VALUE} mob",
                        "plural" => "Killed {VALUE} mobs"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "mob",
                        "dataType"  => "mob_name",
                        "aggregate" => FALSE,
                        "name"      => "Mob",
                    ],
                ],
            ],
            "kills_players"   => [
                "database"        => "kills_players",
                "name"            => "Players killed",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Killed {VALUE} player",
                        "plural" => "Killed {VALUE} players"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "playerKilled",
                        "dataType"  => "player_name",
                        "aggregate" => FALSE,
                        "name"      => "Player",
                    ],
                ],
            ],
            "teleports"       => [
                "database"        => "teleports",
                "name"            => "Teleports",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Teleported {VALUE} time",
                        "plural" => "Teleported {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "destWorld",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "Destination world",
                    ],
                ],
            ],
            "times_kicked"    => [
                "database"        => "times_kicked",
                "name"            => "Kicks",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Was kicked {VALUE} time",
                        "plural" => "Was kicked {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "reason",
                        "dataType"  => "string",
                        "aggregate" => FALSE,
                        "name"      => "Reason",
                    ],
                ],
            ],
            "times_shorn"     => [
                "database"        => "times_shorn",
                "name"            => "Sheep stripped",
                "text" => [
                    "en_US" => [
                        "single" => "Striped {VALUE} sheep",
                        "plural" => "Striped {VALUE} sheep"
                    ]
                ],
                "user_identifier" => "uuid",
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "time_played"     => [
                "database"        => "time_played",
                "name"            => "Play time",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Played for {VALUE}",
                        "plural" => "Played for {VALUE}"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "time", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Time"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
            "tools_broken"    => [
                "database"        => "tools_broken",
                "name"            => "Tools broken",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Broke {VALUE} tool",
                        "plural" => "Broke {VALUE} tools"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "item",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "Tool",
                    ],
                ],
            ],
            "villager_trades" => [
                "database"        => "villager_trades",
                "name"            => "Villager trades",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Traded {VALUE} time",
                        "plural" => "Traded {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "trade",
                        "dataType"  => "item_name",
                        "aggregate" => FALSE,
                        "name"      => "item",
                    ],
                ],
            ],
            "votes"           => [
                "database"        => "votes",
                "name"            => "Votes",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Voted for the server {VALUE} time",
                        "plural" => "Voted for the server {VALUE} times"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                ],
            ],
            "worlds_changed"  => [
                "database"        => "worlds_changed",
                "name"            => "Worlds changed",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Traveled through {VALUE} realm",
                        "plural" => "Traveled through {VALUE} realms"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "Count"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                    [
                        "column"    => "destWorld",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "Destination world",
                    ],
                ],
            ],
            "xp_gained"       => [
                "database"        => "xp_gained",
                "name"            => "XP gained",
                "user_identifier" => "uuid",
                "text" => [
                    "en_US" => [
                        "single" => "Gained {VALUE} XP",
                        "plural" => "Gained {VALUE} XP"
                    ]
                ],
                "values"          => [
                    [
                        "column"    => "value", // column in which the data is stored in the table
                        "dataType"  => "int", // The type of data stored in the column. This can be: time, date, mob, player, world, item_id, item_type, item_name, int
                        "aggregate" => TRUE, // If true this column is used as a stat summary
                        "name"      => "XP"    // Human readable name of the stat
                    ],
                    [
                        "column"    => "world",
                        "dataType"  => "world",
                        "aggregate" => FALSE,
                        "name"      => "World",
                    ],
                ],
            ],
        ],
    ];
}