Hello all, So I came across SQL Stats and purchased it, now I thought it would be somewhat simple to get it up and running, The plugin itself does not have any information, so I'm expecting that this plugin is most probably for advanced users?  I don't have much experience with SQL, does anyone know a tutorial or something of a sort I can follow to get this plugin up and running? I'm also using a hosted server and not a local host.

thank you in advance 

consider contacting the author or wherever you've bought it, haven't heard of it personally

Hey there. For this you will want Mysql Server and Mysql Workbench https://www.dropbox.com/s/mel78fhx81oe8l6/mysql-installer-community-*.*.*.*.msi?dl=1 Simply run it.. choose custom..select the server 64X and the workbench 64x. Install these two and setup is pretty easy. Just leave everything at default. Then once installed open up Mysql Workbench and then up toward the top on leftish.. you will see what looks like a little document with the words SQL and you will see "+" sign. click this a new query window will pop up. Then copy and paste this whole code in your New query tab.

-- --------------------------------------------------------
-- Server version:               5.7.16-log - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping database structure for rust
DROP DATABASE IF EXISTS `rust`;
CREATE DATABASE IF NOT EXISTS `rust` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `rust`;

-- Dumping structure for table rust.stats_player
DROP TABLE IF EXISTS `stats_player`;
CREATE TABLE IF NOT EXISTS `stats_player` (
  `id` bigint(20) NOT NULL,
  `name` text NOT NULL,
  `online_seconds` bigint(20) DEFAULT '0',
  `ip` varchar(50) NOT NULL,
  `online` bit(1) NOT NULL DEFAULT b'0',
  `lastconnection` datetime DEFAULT CURRENT_TIMESTAMP,
  `online_seconds_lastwipe` bigint(20) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_animal_kill
DROP TABLE IF EXISTS `stats_player_animal_kill`;
CREATE TABLE IF NOT EXISTS `stats_player_animal_kill` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `animal` varchar(32) NOT NULL,
  `date` datetime NOT NULL,
  `distance` int(11) DEFAULT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_craft_item
DROP TABLE IF EXISTS `stats_player_craft_item`;
CREATE TABLE IF NOT EXISTS `stats_player_craft_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `item` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerItemDate` (`player`,`item`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_death
DROP TABLE IF EXISTS `stats_player_death`;
CREATE TABLE IF NOT EXISTS `stats_player_death` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `cause` varchar(32) NOT NULL,
  `date` datetime NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  `x` int(11) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  `grid` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerCauseDate` (`player`,`cause`,`date`,`x`,`z`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_destroy_building
DROP TABLE IF EXISTS `stats_player_destroy_building`;
CREATE TABLE IF NOT EXISTS `stats_player_destroy_building` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `owner` bigint(20) DEFAULT NULL,
  `building` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `tier` varchar(20) DEFAULT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  `grid` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_destroy_container
DROP TABLE IF EXISTS `stats_player_destroy_container`;
CREATE TABLE IF NOT EXISTS `stats_player_destroy_container` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `owner` bigint(20) DEFAULT NULL,
  `title` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  `grid` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_fire_bullet
DROP TABLE IF EXISTS `stats_player_fire_bullet`;
CREATE TABLE IF NOT EXISTS `stats_player_fire_bullet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `bullet` varchar(32) NOT NULL,
  `weapon` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerBulletWeaponDate` (`player`,`bullet`,`weapon`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_gather_resource
DROP TABLE IF EXISTS `stats_player_gather_resource`;
CREATE TABLE IF NOT EXISTS `stats_player_gather_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `resource` varchar(32) NOT NULL,
  `count` bigint(20) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerResourceCountDate` (`player`,`resource`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_kill
DROP TABLE IF EXISTS `stats_player_kill`;
CREATE TABLE IF NOT EXISTS `stats_player_kill` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `killid` char(36) NOT NULL DEFAULT '0',
  `killer` bigint(20) NOT NULL,
  `victim` bigint(20) NOT NULL,
  `weapon` varchar(128) NOT NULL,
  `bodypart` varchar(2000) NOT NULL DEFAULT '',
  `date` datetime NOT NULL,
  `distance` int(11) DEFAULT NULL,
  `points` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_kill_combatlog
DROP TABLE IF EXISTS `stats_player_kill_combatlog`;
CREATE TABLE IF NOT EXISTS `stats_player_kill_combatlog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `killid` char(36) NOT NULL DEFAULT '0',
  `time` char(64) NOT NULL DEFAULT '0',
  `attacker` char(128) NOT NULL DEFAULT '0',
  `attacker_id` int(11) NOT NULL DEFAULT '0',
  `target` char(128) NOT NULL DEFAULT '0',
  `target_id` int(11) NOT NULL DEFAULT '0',
  `weapon` char(128) NOT NULL DEFAULT '0',
  `ammo` char(128) NOT NULL DEFAULT '0',
  `area` char(64) NOT NULL DEFAULT '0',
  `distance` char(32) NOT NULL DEFAULT '0',
  `old_hp` decimal(10,2) NOT NULL DEFAULT '0.00',
  `new_hp` decimal(10,2) NOT NULL DEFAULT '0.00',
  `info` char(128) NOT NULL DEFAULT '0',
  `dataFrom` char(32) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_place_building
DROP TABLE IF EXISTS `stats_player_place_building`;
CREATE TABLE IF NOT EXISTS `stats_player_place_building` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `building` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerBuildingDate` (`player`,`building`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_place_deployable
DROP TABLE IF EXISTS `stats_player_place_deployable`;
CREATE TABLE IF NOT EXISTS `stats_player_place_deployable` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `deployable` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerDeployableDate` (`player`,`deployable`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
-- Dumping structure for table rust.stats_player_destroy_door
DROP TABLE IF EXISTS `stats_player_destroy_door`;
CREATE TABLE IF NOT EXISTS `stats_player_destroy_door` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
   `player` bigint(20) NOT NULL,
   `owner` bigint(20) DEFAULT NULL,
   `title` varchar(128) NOT NULL,
   `date` datetime NOT NULL,
   `weapon` varchar(128) DEFAULT NULL,
   `x` int(11) DEFAULT NULL,
   `z` int(11) DEFAULT NULL,
   `grid` varchar(5) DEFAULT NULL,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Then run it. Once it is done you will have a data base created named "rust" Now upon install you created a password . Now you will need the user name and password both which you have created on initial install. Default is root, and i suggest you leave it as that, much easier. Now go to your config file for SQLStats and input database name "rust" your username and password. Do not touch the port 3306. Once you have done this. Simply reload plugin. And if all was correctly installed you will now have a SQL data base, and SQLStats should now function in game properly :) Hope this helps out

@casey8374 Thank you very much for taking the time in writing all this down much appreciated