SQLStats [Unmaintained]

Discussion in 'Plugin Support' started by Visagalis, Dec 20, 2015.

  1. Ionstorm

    Ionstorm

    I think its a conflict with another plugin.

    I tried it on a duplicate server and it connected fine etc.

    Put it back on live and spam error.

    The connection is made, everything is working fine until I use it on the live server.

    I'm kinda surprised Death notes doesn't just have an option to log to mysql.

    I remember the legacy plugin had that option by default
     
    Ionstorm, Apr 21, 2016
    #61
  2. maxaki

    maxaki

    Works very well for me too. The issues you're having I've had, it always ends up with the MySQL server something something...
     
    maxaki, Apr 21, 2016
    #62
  3. Ionstorm

    Ionstorm

    You can't have read the previous post.
     
    Ionstorm, Apr 21, 2016
    #63
  4. Bentech

    Bentech

    20:09 [Error] SQLStats plugin failed to compile!
    20:09 [Error] SQLStats.cs(19,27): error CS0234: The type or namespace name `Connection' does not exist in the namespace `Oxide.Ext.MySql'. Are you missing an assembly reference?
     
    Bentech, Apr 22, 2016
    #64
  5. Kim Jong-un 2

    Kim Jong-un 2

    If you read the prev posts its fixed
     
    Kim Jong-un 2, Apr 22, 2016
    #65
  6. Mo45

    Mo45

    sorry, but HOW? it fixed?
     
    Mo45, Apr 23, 2016
    #66
  7. Kim Jong-un 2

    Kim Jong-un 2

    It you try that file you will see it working just fine or you are doing some weird stuff.
     
    Kim Jong-un 2, Apr 23, 2016
    #67
  8. Mo45

    Mo45

    Ty for answer!
     
    Mo45, Apr 23, 2016
    #68
  9. Bentech

    Bentech

    I think SQL for linux isnt working
     
    Bentech, Apr 23, 2016
    #69
  10. Ionstorm

    Ionstorm

    Yes I'm using MySQL on a remote Linux server too.
     
    Ionstorm, Apr 23, 2016
    #70
  11. Bentech

    Bentech

    Is your Rust server on Linux and Are you having problems with it?
     
    Bentech, Apr 23, 2016
    #71
  12. Mo45

    Mo45

    I'm using Linux, MySQL and Rust servers on same server (Ubuntu 12.04)
    after downloading fixed plugin (GitHub - Limmek/SQLStats-for-Rust: upload) and configuring plugin and upload tables are works fine.
     

    Attached Files:

    • asd.jpg
      asd.jpg
      File size:
      62.8 KB
      Views:
      32
    Mo45, Apr 23, 2016
    #72
  13. Ionstorm

    Ionstorm

    Nope my Rust server is Windows 2012 R2, and the Web Server is Linux
     
    Ionstorm, Apr 23, 2016
    #73
  14. Bentech

    Bentech

    Well mysql on the webserver makes no difference
    [DOUBLEPOST=1461423579][/DOUBLEPOST]
    Do you have the mysql so in your x64 folder?
     
    Bentech, Apr 23, 2016
    #74
  15. Cheeze

    Cheeze

    Anyone got the query commands to set the database up?
     
    Cheeze, May 2, 2016
    #75
  16. Wulf

    Wulf Community Admin

    Code:
    CREATE TABLE `stats_player` (
  `id` bigint(20) NOT NULL,
  `name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `online_seconds` bigint(20) NOT NULL DEFAULT '0',
  `ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `online` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `stats_player_death` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `cause` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerCauseDate` (`player`,`cause`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `stats_player_destroy_building` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `building` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `tier` varchar(20) DEFAULT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `stats_player_kill` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
     
    Wulf, May 2, 2016
    #76
  17. Cheeze

    Cheeze

    I want to kiss you wulfy!
     
    Cheeze, May 2, 2016
    #77
  18. Crushed

    Crushed

    i dont get it :s ... i dont get the Live Sql tables to work....
    i dont found any query for those tables... maybe i could get a bit help there?
    Code:
    timer.Repeat(60, 0, () => {
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('player_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", BasePlayer.activePlayerList.Count, BasePlayer.activePlayerList.Count);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('max_players', ?) ON DUPLICATE KEY UPDATE `value` = ?", ConVar.Server.maxplayers, ConVar.Server.maxplayers);                EntityCount entities = new EntityCount();
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('bear_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.bears, entities.bears);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('boar_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.boars, entities.boars);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('chicken_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.chickens, entities.chickens);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('horse_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.horses, entities.horses);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('stag_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.stags, entities.stags);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('wolf_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.wolves, entities.wolves);                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('stone_ore_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.stone_ore, entities.stone_ore);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('sulfur_ore_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.sulfur_ore, entities.sulfur_ore);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('metal_ore_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.metal_ore, entities.metal_ore);                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('tree_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.trees, entities.trees);                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('pumpkin_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.pumpkins, entities.pumpkins);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('corn_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.corn, entities.corn);                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_hemp_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundHemp, entities.groundHemp);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_metal_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundMetal, entities.groundMetal);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_mushroom_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundMushroom, entities.groundMushroom);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_stone_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundStone, entities.groundStone);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_sulfur_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundSulfur, entities.groundSulfur);
                executeQuery("INSERT INTO live_data (`key`, `value`) VALUES ('ground_wood_count', ?) ON DUPLICATE KEY UPDATE `value` = ?", entities.groundWood, entities.groundWood);
            });
     
    Crushed, Jun 29, 2016
    #78
  19. Asgota

    Asgota

    Guys you have any working web stats plugin??
     
    Asgota, Aug 20, 2016
    #79
  20. Reynostrum

    Reynostrum

    SiberianGaming

    Working on it.
     
    Reynostrum, Aug 20, 2016
    #80