Console Error and users disappearing from the ranking

Hey Mevent! Hello man, here i bring you a bought that is smelling to me that my user "broke" the scale from the clans rankings, you see, my server is a x1000, so, yesterday i got a complain from my top #1 user saying he's not on the top #1 anymore (i've a mechanic on my server that i give a reward to the top #1 on the monthly wipe) so i'm looking at the console and i see this error, also, on the DB i see the user but as he said, i see the ranking and he's not on the /clan ranking anymore, seems like got so higher values that couldn't be tracked, that's my hunch.

 

This is the console error i'm receiving:

 

 

MySql handle raised an exception (MySqlException: Incorrect string value: '\xF0\x9D\x94\xBC\xF0\x9D...' for column 'Clans' at row 313) at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0

 

 

Can you help me to solve this please? On Thursday i've to give the reward to my top 1 user  

Here are the stats of the user that i think "broke" the scale

 

{
  "Display Name": "Tincho",
  "Steam ID": "xxxxxxx",
  "Last Login": "2022-11-01T01:37:30.729248-03:00",
  "Friendly Fire": false,
  "Ally Friendly Fire": false,
  "Use Clan Skins": true,
  "Stats": {
    "gears": 494.0,
    "electric.audioalarm": 2.0,
    "sheetmetal": 219.0,
    "scrap": 104511.0,
    "flashlight.held": 3.0,
    "metal.refined": 26264.0,
    "stonehatchet": 5.0,
    "burlap.gloves.new": 3.0,
    "sulfur.ore": 2225896.0,
    "metal.fragments": 5098673.0,
    "stone.pickaxe": 5.0,
    "hatchet": 10.0,
    "tool.binoculars": 2.0,
    "gunpowder": 284857.0,
    "box.wooden": 13.0,
    "lock.code": 76.0,
    "arrow.bone": 37.0,
    "arrow.fire": 86.0,
    "lowgradefuel": 209071.0,
    "hat.miner": 6.0,
    "spear.wooden": 7.0,
    "box.wooden.large": 51.0,
    "skull.human": 1.0,
    "halloween.lootbag.small": 2.0,
    "metal.ore": 8942067.0,
    "stones": 11408471.0,
    "hq.metal.ore": 1278.0,
    "crossbow": 4.0,
    "hat.candle": 5.0,
    "door.hinged.metal": 18.0,
    "workbench1": 2.0,
    "wall.frame.shopfront.metal": 5.0,
    "salvaged.sword": 8.0,
    "cloth": 588793.0,
    "cactusflesh": 111.0,
    "kills": 27.0,
    "pistol.revolver": 5.0,
    "ammo.pistol": 11750.0,
    "rope": 789.0,
    "pickaxe": 2.0,
    "wolfmeat.raw": 5.0,
    "waterjug": 1.0,
    "wall.graveyard.fence": 2.0,
    "arrow.wooden": 37.0,
    "bone.fragments": 3714.0,
    "fat.animal": 3274.0,
    "leather": 197346.0,
    "wood": 13327188.0,
    "hammer": 24.0,
    "building.planner": 17.0,
    "cupboard.tool": 10.0,
    "door.double.hinged.metal": 6.0,
    "furnace": 20.0,
    "bbq": 1.0,
    "bandage": 186.0,
    "pumpkin": 293.0,
    "seed.pumpkin": 5.0,
    "scientistnpc_oilrig": 73.0,
    "metalspring": 424.0,
    "ammo.rifle": 10438.0,
    "metalpipe": 2250.0,
    "roadsigns": 526.0,
    "hazmatsuit_scientist": 13.0,
    "grenade.molotov": 3.0,
    "smallwaterbottle": 6.0,
    "semibody": 284.0,
    "shotgun.double": 8.0,
    "fuse": 77.0,
    "barrel": 17.0,
    "can.tuna": 2.0,
    "smgbody": 314.0,
    "ammo.shotgun": 301.0,
    "hazmatsuit": 23.0,
    "wall.frame.fence.gate": 1.0,
    "diving.mask": 5.0,
    "electrical.memorycell": 2.0,
    "fluid.switch": 1.0,
    "guntrap": 3.0,
    "hammer.salvaged": 2.0,
    "riflebody": 678.0,
    "largemedkit": 18.0,
    "target.reactive": 1.0,
    "ceilinglight": 1.0,
    "npc_underwaterdweller": 3.0,
    "sewingkit": 836.0,
    "explosive.satchel": 151.0,
    "propanetank": 147.0,
    "heavy.plate.jacket": 12.0,
    "syringe.medical": 1246.0,
    "metalblade": 488.0,
    "techparts": 3564.0,
    "cctv.camera": 43.0,
    "wall.frame.cell": 1.0,
    "planter.large": 2.0,
    "targeting.computer": 80.0,
    "searchlight": 2.0,
    "crude.oil": 7343.0,
    "tarp": 293.0,
    "pistol.m92": 12.0,
    "ghostsheet": 2.0,
    "burlap.gloves": 3.0,
    "shoes.boots": 15.0,
    "bow.hunting": 1.0,
    "mask.bandana": 1.0,
    "burlap.trousers": 3.0,
    "hat.boonie": 1.0,
    "burlap.shirt": 3.0,
    "bow.compound": 3.0,
    "diving.tank": 3.0,
    "torch.torch.skull": 1.0,
    "workbench2": 4.0,
    "sleepingbag": 3.0,
    "lantern": 1.0,
    "floor.triangle.ladder.hatch": 15.0,
    "rifle.lr300": 15.0,
    "weapon.mod.small.scope": 11.0,
    "smg.thompson": 39.0,
    "scientistnpc_cargo_turret_any": 7.0,
    "icepick.salvaged": 9.0,
    "supply.signal": 38.0,
    "floor.ladder.hatch": 7.0,
    "weapon.mod.holosight": 13.0,
    "rocket.launcher": 34.0,
    "generator.wind.scrap": 13.0,
    "smg.mp5": 31.0,
    "ammo.pistol.hv": 50.0,
    "jackhammer": 19.0,
    "pistol.python": 32.0,
    "door.double.hinged.toptier": 23.0,
    "door.hinged.toptier": 25.0,
    "jacket": 4.0,
    "metal.plate.torso": 36.0,
    "pants": 27.0,
    "burlap.shoes": 2.0,
    "rifle.ak": 38.0,
    "rifle.bolt": 35.0,
    "ammo.rifle.hv": 458.0,
    "metal.facemask": 24.0,
    "aiming.module.mlrs": 5.0,
    "torch": 1.0,
    "knife.bone": 1.0,
    "smg.2": 23.0,
    "hmlmg": 6.0,
    "meat.pork.cooked": 96.0,
    "charcoal": 1545014.0,
    "ammo.handmade.shell": 48.0,
    "wall.frame.garagedoor": 21.0,
    "chainsaw": 11.0,
    "longsword": 1.0,
    "easter.goldegg": 1.0,
    "attire.egg.suit": 2.0,
    "explosive.timed": 633.0,
    "shotgun.spas12": 6.0,
    "hoodie": 29.0,
    "ammo.shotgun.fire": 55.0,
    "ammo.pistol.fire": 130.0,
    "coffeecan.helmet": 6.0,
    "ammo.shotgun.slug": 36.0,
    "rifle.semiauto": 11.0,
    "riot.helmet": 3.0,
    "roadsign.gloves": 12.0,
    "rifle.m39": 11.0,
    "grenade.f1": 104.0,
    "sign.wooden.small": 10.0,
    "box.repair.bench": 1.0,
    "ammo.rifle.explosive": 165.0,
    "bucket.helmet": 4.0,
    "shotgun.pump": 7.0,
    "lmg.m249": 21.0,
    "roadsign.jacket": 7.0,
    "keycard_green": 7.0,
    "keycard_red": 5.0,
    "keycard_blue": 5.0,
    "sulfur": 3550902.0,
    "locker": 5.0,
    "grenade.beancan": 2.0,
    "bed": 4.0,
    "rug.bear": 2.0,
    "mushroom": 788.0,
    "barricade.wood.cover": 8.0,
    "shelves": 1.0,
    "electric.battery.rechargable.large": 8.0,
    "workbench3": 2.0,
    "dropbox": 1.0,
    "electric.button": 1.0,
    "attire.hide.pants": 1.0,
    "wall.external.high": 1.0,
    "scientistnpc_cargo_turret_lr300": 10.0,
    "ammo.rocket.mlrs": 9.0,
    "weapon.mod.extendedmags": 4.0,
    "wall.window.bars.toptier": 4.0,
    "electric.rf.receiver": 3.0,
    "heavy.plate.helmet": 4.0,
    "grenade.smoke": 2.0,
    "scientistnpc_cargo": 8.0,
    "electric.solarpanel.large": 4.0,
    "heavy.plate.pants": 5.0,
    "trap.landmine": 2.0,
    "mixingtable": 11.0,
    "autoturret": 33.0,
    "weapon.mod.lasersight": 19.0,
    "explosives": 1624.0,
    "powered.water.purifier": 2.0,
    "weapon.mod.muzzlebrake": 1.0,
    "water.catcher.large": 2.0,
    "roadsign.kilt": 21.0,
    "trap.bear": 2.0,
    "speargun": 2.0,
    "scientistnpc_heavy": 38.0,
    "flamethrower": 4.0,
    "ammo.grenadelauncher.buckshot": 6.0,
    "multiplegrenadelauncher": 5.0,
    "ammo.grenadelauncher.he": 22.0,
    "diesel_barrel": 2.0,
    "ammo.grenadelauncher.smoke": 8.0,
    "shutter.metal.embrasure.b": 3.0,
    "weapon.mod.simplesight": 1.0,
    "weapon.mod.flashlight": 7.0,
    "oretea.pure": 17.0,
    "jacket.snow": 2.0,
    "green.berry": 140.0,
    "blue.berry": 150.0,
    "red.berry": 280.0,
    "yellow.berry": 220.0,
    "research.table": 1.0,
    "wall.external.high.stone": 141.0,
    "oretea": 1335.0,
    "woodtea": 1003.0,
    "spraycan": 1.0,
    "deaths": 6.0,
    "mace": 2.0,
    "electric.counter": 1.0,
    "ladder.wooden.wall": 72.0,
    "ammo.rocket.basic": 287.0,
    "skull": 1.0,
    "cupboard.tool.deployed": 13.0,
    "axe.salvaged": 3.0,
    "machete": 1.0,
    "woodtea.pure": 63.0,
    "ammo.rocket.hv": 56.0,
    "wiretool": 1.0,
    "bearmeat.cooked": 2071.0,
    "innertube": 1876.0,
    "lock.key": 1.0,
    "rifle.ak.ice": 5.0,
    "stash.small": 5.0,
    "scarecrow": 7.0,
    "halloween.lootbag.medium": 1.0,
    "ammo.rifle.incendiary": 264.0,
    "hazmatsuit.arcticsuit": 3.0,
    "hazmatsuit.nomadsuit": 1.0,
    "furnace.large": 4.0,
    "shutter.metal.embrasure.a": 2.0,
    "grenade.flashbang": 6.0,
    "gates.external.high.stone": 1.0,
    "pistol.semiauto": 2.0,
    "storage.monitor": 1.0,
    "smart.switch": 1.0,
    "tshirt": 5.0,
    "weapon.mod.silencer": 1.0,
    "helicopter": 2.0,
    "black.raspberries": 272.0,
    "computerstation": 3.0,
    "ammo.rocket.sam": 300.0,
    "tactical.gloves": 16.0,
    "scientistnpc_patrol": 3.0,
    "scientistnpc_roam": 1.0,
    "elevator": 2.0,
    "horse.shoes.advanced": 2.0,
    "small.oil.refinery": 1.0,
    "electric.random.switch": 2.0,
    "halloween.candy": 18.0,
    "shotgun.waterpipe": 1.0,
    "snowballgun": 2.0,
    "ammo.rocket.fire": 48.0,
    "deermeat.cooked": 240.0,
    "scraptea.advanced": 1.0,
    "rifle.l96": 6.0,
    "scientistnpc_junkpile_pistol": 2.0,
    "spiderweb": 1.0,
    "seed.corn": 11.0,
    "nightvisiongoggles": 1.0
  },
  "Invites": {},
  "Last Wipe": "0001-01-01T00:00:00"
}

Another related issue, i'm playing around meanwhile you see my post, and i changed my statics like this:

 

  "Statistics Settings": {

    "Kills": true,

    "Gather": false,

    "Loot": false,

    "Entities": false,

    "Craft": false

  },

 

 

 

And when i reloaded the plugin, now it shows wrong data, like for example, a user that in my databse says that has 27 kills, now in the UI says that has only 6 kills.

 

What i could be doing wrong?

Oh i found why is displaying the wrong data! Is reading the data from /data folder instead the data from the database! I certainly don't know why.

now i have the following error  all i did was to reload the plugin

 

 

MySql handle raised an exception (MySqlException: Duplicate column name 'clans') at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0

MySql handle raised an exception (MySqlException: Duplicate column name 'clans') at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0

 

 

Perhaps is trying to recreate the table instead of using the existing table?

This are my configs:

 

PlayerDatabase (censored)

 

{

  "Data Type : 0 (Files) or 1 (SQLite) or 2 (MySQL)": 2,

  "MySQL - Database Name": "xxx",

  "MySQL - Host": "xxx",

  "MySQL - Password": "xxx",

  "MySQL - Port": xxx,

  "MySQL - Username": "xxx",

  "MySQL/SQLite - Database Table Name": "clans",

  "SQLite - Database Name": "playerdatabase.db"

}

 

clans:

 

{

  "Default Avatar": "https://i.imgur.com/nn7Lcm2.png",

  "Commands": ["clan", "clans"],

  "Clan Info Commands": ["cinfo"],

  "Maximum clan description characters": 256,

  "Clan tag in player name": true,

  "Automatic team creation": true,

  "Allow players to leave their clan by using Rust's leave team button": true,

  "Allow players to kick members from their clan using Rust's kick member button": true,

  "Allow players to invite other players to their clan via Rust's team invite system": true,

  "Allow players to promote other clan members via Rust's team promote button": true,

  "Allow players to accept a clan invite using the Rust invite accept button": true,

  "Show clan creation interface when creating a team?": false,

  "Force to create a clan when creating a team?": false,

  "Use Friendly Fire?": true,

  "Use Friendly Fire for Turrets?": false,

  "General friendly fire (only the leader of the clan can enable/disable it)": false,

  "Can moderators toggle general friendly fire?": false,

  "Can players toggle general friendly fire?": false,

  "Friendly Fire Default Value": false,

  "Top refresh rate": 15,

  "Default value for the resource standarts": 100000,

  "Chat Settings": {

    "Enable clan tags in chat?": true,

    "Tag format": "<color=#{color}>[{tag}]</color>"

  },

  "Permission Settings": {

    "Use permission to create a clan": false,

    "Permission to create a clan": "clans.cancreate",

    "Use permission to join a clan": false,

    "Permission to join a clan": "clans.canjoin",

    "Use permission to kick a clan member": false,

    "Clan kick permission": "clans.cankick",

    "Use permission to leave a clan": false,

    "Clan leave permission": "clans.canleave",

    "Use permission to disband a clan": false,

    "Clan disband permission": "clans.candisband",

    "Use permission to clan skins": false,

    "Use clan skins permission": "clans.canskins",

    "Minimum auth level required to view clan info (0 = player, 1 = moderator, 2 = owner)": 0

  },

  "Alliance Settings": {

    "Enable clan alliances": false,

    "Enable friendly fire (allied clans)": true,

    "Default friendly fire value": false,

    "General friendly fire (only the leader of the clan can enable/disable it)": false,

    "Can moderators toggle general friendly fire?": false,

    "Can players toggle general friendly fire?": false

  },

  "Purge Settings": {

    "Enable clan purging": true,

    "Purge clans that havent been online for x amount of day": 14,

    "List purged clans in console when purging": true,

    "Wipe clans on new map save": false

  },

  "Limit Settings": {

    "Member Limit": 4,

    "Moderator Limit": 1,

    "Alliances Limit": 0

  },

  "Resources": ["stones", "sulfur.ore", "metal.ore", "hq.metal.ore", "wood"],

  "Score Table (shortname - score)": {

    "kills": 1,

    "deaths": -1,

    "stone-ore": 0.1,

    "supply_drop": 3,

    "crate_normal": 0.3,

    "crate_elite": 0.5,

    "bradley_crate": 5,

    "heli_crate": 5,

    "bradley": 10,

    "helicopter": 15,

    "barrel": 0.1,

    "scientistnpc": 0.5,

    "heavyscientist": 2,

    "sulfur.ore": 0.5,

    "metal.ore": 0.5,

    "hq.metal.ore": 0.5,

    "stones": 0.5,

    "cupboard.tool.deployed": 1

  },

  "Available items for resource standarts": [

    "gears",

    "metalblade",

    "metalpipe",

    "propanetank",

    "roadsigns",

    "rope",

    "sewingkit",

    "sheetmetal",

    "metalspring",

    "tarp",

    "techparts",

    "riflebody",

    "semibody",

    "smgbody",

    "fat.animal",

    "cctv.camera",

    "charcoal",

    "cloth",

    "crude.oil",

    "diesel_barrel",

    "gunpowder",

    "hq.metal.ore",

    "leather",

    "lowgradefuel",

    "metal.fragments",

    "metal.ore",

    "scrap",

    "stones",

    "sulfur.ore",

    "sulfur",

    "targeting.computer",

    "wood"

  ],

  "Pages": [

    {

      "ID (DON'T CHANGE)": 0,

      "Key (DON'T CHANGE)": "aboutclan",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 1,

      "Key (DON'T CHANGE)": "memberslist",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 2,

      "Key (DON'T CHANGE)": "clanstop",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 3,

      "Key (DON'T CHANGE)": "playerstop",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 4,

      "Key (DON'T CHANGE)": "resources",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 6,

      "Key (DON'T CHANGE)": "skins",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 5,

      "Key (DON'T CHANGE)": "playerslist",

      "Enabled?": true,

      "Permission": ""

    },

    {

      "ID (DON'T CHANGE)": 7,

      "Key (DON'T CHANGE)": "alianceslist",

      "Enabled?": true,

      "Permission": ""

    }

  ],

  "Interface": {

    "Color 1": "#0E0E10",

    "Color 2": "#4B68FF",

    "Color 3": "#161617",

    "Color 4": "#324192",

    "Color 5": "#303030",

    "Color 6": "#FF4B4B",

    "Use value abbreviation?": true,

    "Top Clans Columns": [

      {

        "Width": 75,

        "Lang Key": "TopTitle",

        "Key": "top",

        "Text Format": "#{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 10,

        "Font Size": 12

      },

      {

        "Width": 165,

        "Lang Key": "NameTitle",

        "Key": "name",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 70,

        "Lang Key": "LeaderTitle",

        "Key": "leader",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 90,

        "Lang Key": "MembersTitle",

        "Key": "members",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 80,

        "Lang Key": "ScoreTitle",

        "Key": "score",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      }

    ],

    "Top Players Columns": [

      {

        "Width": 75,

        "Lang Key": "TopTitle",

        "Key": "top",

        "Text Format": "#{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 10,

        "Font Size": 12

      },

      {

        "Width": 185,

        "Lang Key": "NameTitle",

        "Key": "name",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 70,

        "Lang Key": "KillsTitle",

        "Key": "kills",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 70,

        "Lang Key": "ResourcesTitle",

        "Key": "resources",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      },

      {

        "Width": 80,

        "Lang Key": "ScoreTitle",

        "Key": "score",

        "Text Format": "{0}",

        "Text Align": "MiddleCenter",

        "Title Font Size": 12,

        "Font Size": 12

      }

    ],

    "Profile Buttons": [

      {

        "Enabled": false,

        "Close Menu?": true,

        "Command": "tpr {target}",

        "Color": {

          "HEX": "#324192",

          "Opacity (0 - 100)": 100

        },

        "Title": "TP",

        "Font Size": 10,

        "Font": "robotocondensed-regular.ttf",

        "Align": "MiddleCenter",

        "Text Color": {

          "HEX": "#FFFFFF",

          "Opacity (0 - 100)": 100

        },

        "AnchorMin": "0 1",

        "AnchorMax": "0 1",

        "OffsetMin": "270 -55",

        "OffsetMax": "360 -30"

      },

      {

        "Enabled": false,

        "Close Menu?": true,

        "Command": "trade {target}",

        "Color": {

          "HEX": "#324192",

          "Opacity (0 - 100)": 100

        },

        "Title": "TRADE",

        "Font Size": 10,

        "Font": "robotocondensed-regular.ttf",

        "Align": "MiddleCenter",

        "Text Color": {

          "HEX": "#FFFFFF",

          "Opacity (0 - 100)": 100

        },

        "AnchorMin": "0 1",

        "AnchorMax": "0 1",

        "OffsetMin": "370 -55",

        "OffsetMax": "460 -30"

      }

    ]

  },

  "Skins Settings": {

    "Item Skins": {

      "metal.facemask": [

        0, 2361481469, 2390085136, 2363112910, 2356007863, 2527032902,

        2362833229, 2779049132, 2778829027, 784316334, 794837198, 792827436,

        792079554, 792649975, 792905158, 799044333, 803894027, 800980236,

        807821375, 816530945, 812933296, 828888629, 824898622, 821441043,

        832021670, 832934294, 841012325, 835026584, 831923884, 881687672,

        896211631, 895067146, 899001394, 901668040, 900645045, 907176719,

        915572534, 924019464, 915693648, 943128194, 903628875, 971433920,

        939788004, 932233099, 1092671728, 962694769, 1084823878, 1113983678,

        1083628316, 1130407273, 1135160079, 1137533438, 1172409741, 1121237616,

        1203888714, 1270065112, 1313529548, 1335769610, 1349988105, 1353724450,

        1421829383, 1522955755, 1547874663, 1575391468, 1587225942, 1586135331,

        1581351961, 1680454451, 1693643930, 1711049678, 1753711761, 1771714129,

        1777973800, 1787201365, 1845950558, 1886184322, 1886920683, 1894591519,

        1900843064, 1805321162, 1932619423, 1934943101, 1969741836, 1993775723,

        2001712636, 2005707226, 2012095496, 2059935666, 2092488951, 2100738972,

        2105454370, 2131549928, 2143679757, 2178447488, 2193149013, 2215908400,

        2229280260, 2226597543, 2242198470, 2252919011, 2296503845, 2304448562,

        2377199365, 2397195171, 2432948498, 2462341795, 2475428991, 2497313980,

        2510419774, 2551475709, 1731680660, 2624301869, 2643606116, 2655891819,

        2674860731, 2738065427, 2403998864, 2761235705, 2785970057, 2779311985,

        2789556899, 2810942233, 2815006919, 2823682276, 2830487151, 2833389755

      ],

      "hoodie": [

        0, 10052, 10086, 10129, 10132, 10133, 10142, 14072, 14178, 14179,

        492800372, 519147220, 539943199, 612956053, 619935833, 626133126,

        2351687115, 2349484905, 2349487658, 2339346268, 2352961242, 2365510260,

        2532379184, 2532378234, 2708804858, 2775148109, 2789375252, 661319427,

        797128321, 803249256, 677636990, 889718910, 835836079, 895065994,

        897890977, 914621940, 919353761, 926162531, 939604165, 904963081,

        941172099, 954392337, 954947279, 961066582, 971807764, 959900137,

        975500312, 959641236, 1100931254, 1106582025, 1111669350, 1150818496,

        1150760640, 1170989053, 1209453497, 1234693807, 1274163900, 1282111884,

        1296608954, 1305321596, 1317554978, 1328751626, 1356748246, 1368417352,

        1356328924, 1373714814, 1371314541, 1408832378, 1432964453, 1448343881,

        1385322661, 1552703337, 1564974974, 1581817010, 1587744366, 1623185000,

        1292091712, 1638742127, 1660290744, 1700935391, 1703216433, 1740503746,

        1740562395, 1766644324, 1768733505, 1787216403, 1810592176, 1784482745,

        1196751864, 1858310941, 1883624383, 1894585931, 1911980598, 1927124747,

        1936131747, 1950853975, 1968538819, 1993891915, 2000507925, 1997532879,

        2022463110, 2067569919, 2076428294, 2080975449, 2099705103, 2131784896,

        2138199381, 2147365537, 2176988889, 2182271278, 2192919905, 2200988844,

        2215209664, 1961464025, 2124528682, 2207288699, 2256109331, 2282178792,

        2289427434, 2293185782, 2295666190, 2329780962, 2366661340, 2373481556,

        2387700898, 2413092008, 2416648557, 2428818427, 2462377903, 2476343229,

        2476889442, 2503910428, 2563940111, 2613401647, 2630170972, 2656534993,

        2668684404, 2649552973, 2678873660, 2738725723, 2775449630, 2779000932,

        2786096426, 2792962002, 2811533300, 2817898316, 2814838951, 2826817236

      ],

      "metal.plate.torso": [

        0, 2352188221, 2360969707, 2541702877, 2709558827, 2778832976,

        794169855, 799657859, 796728308, 797410767, 817022417, 823132085,

        828888000, 832233112, 842577956, 798736321, 819160334, 895066686,

        900807753, 924019814, 934627208, 944835223, 970700662, 1113984430,

        1094522474, 1135168998, 1270065959, 1335770974, 1349989767, 1353723648,

        1421841596, 1522963149, 1575392727, 1587225313, 1586132318, 1581353262,

        1578628782, 1680452167, 1693641239, 1711048020, 1753699785, 1771804406,

        1777967326, 1787198707, 1845931269, 1886179838, 1886922099, 1900842357,

        1805322456, 1932615190, 1934946028, 1969743263, 1993774875, 2001706617,

        2005709642, 2013723517, 2059931054, 2092488087, 2100740608, 2105505757,

        2131557341, 2144720791, 2178449205, 2193157606, 2215911873, 2229279338,

        2226598382, 2242200040, 2252998412, 2296501936, 2304445825, 2377223360,

        2397196563, 2432947351, 2462350544, 2475407123, 2497312780, 2510424165,

        2551474093, 1732003216, 2624303483, 2643605269, 2655892748, 2674862484,

        2738066370, 2403997654, 2761233303, 2785971861, 2779311902, 2789558780,

        2796595171, 2810941554, 2815007173, 2823681183, 2830495377, 2833391256

      ],

      "pants": [

        0, 10001, 10019, 10020, 10021, 10048, 10049, 10078, 494003754,

        490773561, 504687841, 2339348970, 2352962213, 2408536195, 2626032678,

        2709707942, 798690647, 823154911, 889714798, 888360095, 909888619,

        930559188, 939586076, 955615160, 961084105, 969289969, 975498827,

        960252273, 1100930207, 1106596145, 1111673876, 1125254090, 1150816693,

        1150763210, 1170988006, 1229552157, 1234956405, 1274163146, 1287193745,

        1296612316, 1305364315, 1317553480, 1328753424, 1356749671, 1368418893,

        1356324187, 1371313777, 1406835139, 1432965178, 1441311938, 1448346336,

        1385326314, 1552705077, 1581822078, 1587846022, 1623181884, 1292094174,

        1638743634, 1660293384, 1700938224, 1703218418, 1740505052, 1740563572,

        1766646393, 1768737448, 1787243248, 1810590744, 1784474755, 1196747617,

        1858308973, 1883629284, 1894589800, 1911973450, 1927127023, 1936132863,

        1950854989, 1968533197, 1993902344, 1987863036, 1997534121, 2022464363,

        2067568367, 2076980911, 2080977144, 2099701364, 2131787171, 2138201022,

        2147367433, 2176989787, 2192914821, 2200988235, 2215211982, 1961465777,

        2124531088, 2207291626, 2256110716, 2282181821, 2289433771, 2293180981,

        2295664263, 2329782748, 2366658636, 2373483517, 2387704141, 2413094171,

        2416647256, 2429020487, 2462383364, 2476360448, 2476892801, 2503903214,

        2563935722, 2613403154, 2630171764, 2668683023, 2649555568, 2678874051,

        2738724398, 2775450131, 2779283723, 2786098088, 2792962665, 2811533832,

        2817949508, 2814837980, 2826813273

      ],

      "roadsign.kilt": [

        0, 784577443, 794291485, 801837047, 818612271, 828173323, 865679836,

        879861153, 892414125, 934742835, 944586866, 953123363, 934937654,

        947949717, 950176525, 953112839, 1084396407, 1102986622, 1103687152,

        1121447954, 1130405286, 1130610212, 1106569231, 1159599284, 1154469089,

        1151205503, 1202976443, 974345761, 1251419748, 1248433379, 1269612137,

        1342123902, 1332333384, 1349158079, 1353722661, 1349943069, 1380028657,

        1400837602, 1388416860, 1441848470, 1442167045, 1442346890, 1438090382,

        1539652650, 1539570583, 1558579257, 1737733590, 1759482713, 1797483140,

        1779983158, 1740068457, 1723851847, 1865210905, 1894376712, 1906531526,

        1915398061, 1944165903, 1974809731, 1986050287, 2120628865, 2147209635,

        2142383374, 2199787450, 2076261294, 2296714510, 2320203004, 2350090284,

        2411684424, 2415101453, 2462648733, 2469019097, 2491402270, 2496523983,

        2537677227, 2543087270, 2570237224, 2601514523, 2646379791, 2649381460,

        2678181949, 2706580165, 2782674037, 2722823552, 2789425692, 2792863176,

        2803024300, 2814760651, 2823738497

      ],

      "shoes.boots": [

        0, 10022, 10023, 10034, 10044, 10080, 10088, 493534620, 493064563,

        507940691, 513629119, 613481881, 784559403, 809586899, 838205144,

        869090082, 882570089, 899942107, 919261524, 826587881, 944997041,

        961096730, 920390242, 1084392788, 962503020, 1100926907, 1106548545,

        1111680681, 1406796292, 1432967312, 1441308562, 1395755190, 1839313604,

        1864539854, 1915955573, 1915397286, 1196740980, 1960694026, 1995685684,

        2009426933, 2075527039, 2090776132, 2199934989, 2304198263, 2410871443,

        2510093391, 2496064553, 2537679237, 2581371666, 2575506021, 2618817211,

        2688629448, 2799638251

      ],

      "rifle.ak": [

        0, 10135, 10137, 10138, 13070, 615766181, 618543834, 566540646,

        2352506845, 2375327201, 2391107262, 2437435853, 2546031510, 2532586221,

        2544999440, 2412486082, 2585539626, 2710319805, 2779278780, 2784262808,

        2609375450, 809190373, 654502185, 840477492, 849047662, 859845460,

        875130056, 885146172, 887494035, 895307805, 889710179, 908297014,

        920472848, 911726740, 924020531, 928950425, 903882218, 940035827,

        937864743, 925720043, 939180121, 934891737, 1076214414, 1092674304,

        1088459232, 1102750231, 1124932043, 1112904406, 1129886223, 1137915903,

        1118706219, 1140366289, 1161844853, 1167207039, 1175238674, 1159593268,

        1174389582, 1120500163, 1196676446, 1213092632, 1230963555, 1245563496,

        1259716979, 1265322092, 1277707212, 1202410378, 1272989639, 1288866247,

        1306351416, 1324932956, 1309470544, 1338305091, 1349512142, 1349324364,

        1359893925, 1372945520, 1385673487, 1372566409, 1396630285, 809212871,

        1364985829, 1352844155, 1428980348, 1434027951, 1448221547, 1457951707,

        1467269924, 1402320927, 1362212220, 1435827815, 1476966011, 1522034435,

        1539318940, 1539409946, 1539007965, 1549426268, 1575397458, 1583542371,

        1588206436, 1599157678, 1659781652, 1679665505, 1685375084, 1746886322,

        1750654242, 1760078043, 1804885723, 1252554814, 1826520371, 1850236015,

        1870705926, 1882821847, 1886272847, 1907342157, 1915393587, 1929819581,

        1983066869, 1993279809, 2006878490, 2012334520, 2017002938, 2059352465,

        2075372682, 2085083014, 2101560738, 2108685486, 2109182691, 2128372674,

        2179386526, 2041629387, 2172715245, 2242791041, 2249370680, 2248879512,

        2245084157, 2268418002, 2240088463, 2304993742, 2319710097, 2323019876,

        2358898935, 2388299872, 2402597354, 2411156317, 2426264628, 2440147760,

        2433058633, 2462290529, 2468934608, 2489783136, 2510062939, 2518385133,

        2536316473, 2546271708, 2557819273, 2566739934, 2576448799, 2582891462,

        2373070608, 2613364430, 2618861882, 2624177228, 2620919847, 2661741295,

        2289255115, 2677450807, 2704916388, 2728936078, 2738248719, 2760685263,

        2768295664, 2789549531, 2792591083, 2803187102, 2806012034, 2768828157,

        2817939150, 2823738091, 2830039237, 2833821724, 2840035812

      ],

      "rifle.bolt": [

        0, 10115, 10116, 10117, 526539536, 518199212, 516383225, 2361194244,

        2585146864, 819149392, 818403150, 840105253, 875259050, 897023403,

        943036098, 947954942, 933509449, 972020573, 1119629516, 1161165984,

        1517933342, 1535660827, 1587273896, 1592946955, 1795984246, 1581664321,

        1852284996, 2024514125, 2363806432, 2412215351, 2510556864, 2516829420

      ]

    },

    "Use skins from SkinBox?": false,

    "Use skins from PlayerSkins?": false,

    "Can players install custom skins?": true,

    "Permission to install custom skin": "",

    "Option to disable clan skins?": false,

    "Default value to disable skins": true

  },

  "Statistics Settings": {

    "Kills": true,

    "Gather": true,

    "Loot": true,

    "Entities": true,

    "Craft": true

  },

  "Colos Settings": {

    "Clan owner color (hex)": "#a1ff46",

    "Clan moderator color (hex)": "#74c6ff",

    "Clan member color (hex)": "#fcf5cb"

  },

  "PlayerDatabase": {

    "Enabled": true,

    "Table": "clans"

  },

  "ZoneManager Settings": {

    "Enabled": true,

    "Zones with allowed Friendly Fire": ["2310115"]

  },

  "Clan Tag Settings": {

    "Blocked Words": ["admin", "mod", "owner"],

    "Minimum clan tag characters": 2,

    "Maximum clan tag characters": 6,

    "Enable character checking in tags?": true,

    "Special characters allowed in tags": "!²³",

    "Tag Color Settings": {

      "Enabled": true,

      "DefaultColor": "AAFF55",

      "Can the owner change the color?": true,

      "Can the moderators change the color?": false,

      "Can the players change the color?": false

    }

  },

  "Version": {

    "Major": 1,

    "Minor": 1,

    "Patch": 6

  }

}

 

 

 

And even if i have activated the playerdatabase pointing to clans table, it's reading from the /data folder

 

 

Researching this problem 

Changed Status from Pending to Closed