Jump to content

Better Statistics 1.2.1

$49.99
   (4 reviews)
Billy Joe

4 Screenshots

  • 51.6k
  • 345
  • 2.91 MB
 Share

Recommended Comments



NexusGaming

NexusGaming 0

Posted

Will this ever add gathering statistics? 

NexusGaming

NexusGaming 0

Posted

26 minutes ago, NexusGaming said:

Will this ever add gathering statistics? 

Adding onto this, it could be nice if there was also leaderboards ingame.

Billy Joe

Billy Joe 108

Posted

  • File Author
On 2/12/2023 at 2:14 PM, NexusGaming said:

Adding onto this, it could be nice if there was also leaderboards ingame.

This has been done, although was commissioned so I am unable to do for public as of now. You can reach out for big additional features, which I commission out.

bradh79

bradh79 14

Posted

can i host the server on my rust server pc

bradh79

bradh79 14

Posted

On 1/20/2023 at 6:34 PM, AhigaO said:

 

is there a setup video for this just paid 70aud for it would like to be able to use it

  • Haha 1
bradh79

bradh79 14

Posted (edited)

still cant get this to work it says the stats.sql file is runing in mysql so i dont know submitted an error log

Edited by bradh79
Billy Joe

Billy Joe 108

Posted

  • File Author

You should not have purchased if you do not know how to setup a MySQL Database. It was mentioned it was required.

  • Haha 1
humboldt.scott420

humboldt.scott420 23

Posted

50$ lol Dude thats the price of a game we had chat gpt make us one just like this

  • Like 1
Billy Joe

Billy Joe 108

Posted

  • File Author
On 3/10/2023 at 5:43 PM, humboldt.scott420 said:

50$ lol Dude thats the price of a game we had chat gpt make us one just like this

Glad you appreciate a developers work 👍

Jorjeh

Jorjeh 2

Posted

$50 for something that XDStatistics can do for $20 and showing off with that demo website just to get an extra commission. Oddly expensive for nothing close to "advanced".

  • Like 2
Billy Joe

Billy Joe 108

Posted

  • File Author
5 hours ago, Jorjeh said:

$50 for something that XDStatistics can do for $20 and showing off with that demo website just to get an extra commission. Oddly expensive for nothing close to "advanced".

Its not for everyone, and very far off from XDStats. But chose what you want!

Markiii

Markiii 78

Posted (edited)

On 3/11/2023 at 12:43 AM, humboldt.scott420 said:

50$ lol Dude thats the price of a game we had chat gpt make us one just like this

How did chat gpt do that? since it doesnt code etc..

"As an AI language model, I do not have the ability to create plugins from scratch. However, I can provide some guidance on how to create your own plugin."

Edited by Markiii
CaptainNebulous

CaptainNebulous 25

Posted

I'm new to messing around with mySQL (I've been using SQL Lite for years) and was wondering.... does this need more than 1 SQL database? I get a free one with my host. But I was thinking by the looks of the config it might need 3? 

Billy Joe

Billy Joe 108

Posted

  • File Author
15 hours ago, CaptainNebulous said:

I'm new to messing around with mySQL (I've been using SQL Lite for years) and was wondering.... does this need more than 1 SQL database? I get a free one with my host. But I was thinking by the looks of the config it might need 3? 

Nope you only need 1 database 🙂

  • Like 1
FandangoChristmas

FandangoChristmas 40

Posted (edited)

Is there a better tutorial on how to set this up? I added a MYSQL server on my GTXGaming Rust server, I have now written down the login info and database name from there and added it to the plugin config, but It doesnt load up. Do I need to place the included files "StatsWebsite" folder, and "stats.sql" file anywhere as well? If anyone can help steer me in the proper direction, I would be greatly appreciated for it.

 

Edited by FandangoChristmas
CaptainNebulous

CaptainNebulous 25

Posted

On 4/14/2023 at 2:32 PM, Billy Joe said:

Nope you only need 1 database 🙂

Just picked this up but now I'm having a problem. Posted in the support section.

Billy Joe

Billy Joe 108

Posted

  • File Author
On 4/30/2023 at 5:14 AM, FandangoChristmas said:

Is there a better tutorial on how to set this up? I added a MYSQL server on my GTXGaming Rust server, I have now written down the login info and database name from there and added it to the plugin config, but It doesnt load up. Do I need to place the included files "StatsWebsite" folder, and "stats.sql" file anywhere as well? If anyone can help steer me in the proper direction, I would be greatly appreciated for it.

 

The stats website is for the website portion if you want to use it, the stats sql is supposed to be ran on your MysSQL database. The plugin is the only thing that goes on your server.

McGee007

McGee007 1

Posted

Updated sql procedures was missing prototype17, nailgun also get https://cdn.mysql.com//Downloads/Connector-Net/mysql-connector-net-8.0.33-noinstall.zip and use the v4.8 folder in it to update the MySql.Data.dll and xml that will go to this location in rust RustDedicated_Data\Managed and save the files cause after the update of rust it needs to be replace each time if you get  a mysql error for unsupported type.

  

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `createTable`(IN `tableName` VARCHAR(200))
BEGIN
	SET @name = tableName;
	SET @st = CONCAT('
	   CREATE TABLE IF NOT EXISTS `' , @name, '` (
	      `id` INT(4) NOT NULL AUTO_INCREMENT,
	      `name` VARCHAR(50) NULL DEFAULT NULL,
	      `steamid` VARCHAR(18) NULL DEFAULT NULL,
	      `connections` INT(11) NOT NULL DEFAULT 0,
	      `playtime` INT(11) NOT NULL DEFAULT 0,
	      `kills` INT(11) NOT NULL DEFAULT 0,
	      `deaths` INT(11) NOT NULL DEFAULT 0,
	      `bfired` INT(11) NOT NULL DEFAULT 0,
	      `suicides` INT(11) NOT NULL DEFAULT 0,
	      `wounded` INT(11) NOT NULL DEFAULT 0,
	      `c4thrown` INT(11) NOT NULL DEFAULT 0,
	      `satchelsthrown` INT(11) NOT NULL DEFAULT 0,
	      `rocketsfired` INT(11) NOT NULL DEFAULT 0,
	      `tcsdestroyed` INT(11) NOT NULL DEFAULT 0,
	      `chickens` INT(11) NOT NULL DEFAULT 0,
	      `boars` INT(11) NOT NULL DEFAULT 0,
	      `deers` INT(11) NOT NULL DEFAULT 0,
	      `horses` INT(11) NOT NULL DEFAULT 0,
	      `wolves` INT(11) NOT NULL DEFAULT 0,
	      `bears` INT(11) NOT NULL DEFAULT 0,
	      `scientists` INT(11) NOT NULL DEFAULT 0,
	      `helicopters` INT(11) NOT NULL DEFAULT 0,
	      `bradleys` INT(11) NOT NULL DEFAULT 0,
		   `ak47` INT(11) NOT NULL DEFAULT 0,
			`lr300` INT(11) NOT NULL DEFAULT 0,
			`m39` INT(11) NOT NULL DEFAULT 0,
			`sar` INT(11) NOT NULL DEFAULT 0,
			`m249` INT(11) NOT NULL DEFAULT 0,
			`hmlmg` INT(11) NOT NULL DEFAULT 0,
			`l96` INT(11) NOT NULL DEFAULT 0,
			`bolt` INT(11) NOT NULL DEFAULT 0,
			`mp5` INT(11) NOT NULL DEFAULT 0,
			`thompson` INT(11) NOT NULL DEFAULT 0,
			`custom` INT(11) NOT NULL DEFAULT 0,
			`pump` INT(11) NOT NULL DEFAULT 0,
			`doublebarrel` INT(11) NOT NULL DEFAULT 0,
			`spaz12` INT(11) NOT NULL DEFAULT 0,
			`m92` INT(11) NOT NULL DEFAULT 0,
			`python` INT(11) NOT NULL DEFAULT 0,
			`semipistol` INT(11) NOT NULL DEFAULT 0,
			`revolver` INT(11) NOT NULL DEFAULT 0,
			`waterpipe` INT(11) NOT NULL DEFAULT 0,
			`eoka` INT(11) NOT NULL DEFAULT 0,
			`compound` INT(11) NOT NULL DEFAULT 0,
			`crossbow` INT(11) NOT NULL DEFAULT 0,
			`bow` INT(11) NOT NULL DEFAULT 0,
			`head_hits` INT(11) NOT NULL DEFAULT 0,
			`torso_hits` INT(11) NOT NULL DEFAULT 0,
			`leftarm_hits` INT(11) NOT NULL DEFAULT 0,
			`rightarm_hits` INT(11) NOT NULL DEFAULT 0,
			`leftleg_hits` INT(11) NOT NULL DEFAULT 0,
			`rightleg_hits` INT(11) NOT NULL DEFAULT 0,
			`leftfoot_hits` INT(11) NOT NULL DEFAULT 0,
			`rightfoot_hits` INT(11) NOT NULL DEFAULT 0,
            `prototype17` INT(11) NOT NULL DEFAULT 0,
            `nailgun` INT(11) NOT NULL DEFAULT 0,
	      PRIMARY KEY (`id`) USING BTREE,
	      INDEX `steamid` (`steamid`) USING BTREE
	   )
	 ');
	 PREPARE myStatement FROM @st;
	 EXECUTE myStatement;
	 DEALLOCATE PREPARE myStatement;
 END$$
DELIMITER ;

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertStats`(IN `serverPrefix` VARCHAR(50))
BEGIN
	SET @name = serverPrefix;
	SET @st = CONCAT('
		INSERT INTO `' , @name, '_stats_overall` (name, steamid, playtime, connections, kills, deaths, bfired, suicides, wounded, rocketsfired, c4thrown, satchelsthrown, tcsdestroyed, chickens, boars, deers, horses, wolves, bears, scientists, helicopters, bradleys, ak47, lr300, m39, sar, hmlmg, m249, bolt, l96, mp5, thompson, custom, pump, doublebarrel, spaz12, m92, python, semipistol, revolver, waterpipe, eoka, compound, crossbow, bow, head_hits, torso_hits, leftarm_hits, rightarm_hits, leftleg_hits, rightleg_hits, leftfoot_hits, rightfoot_hits, prototype17, nailgun)
		SELECT name, steamid, playtime, connections, kills, deaths, bfired, suicides, wounded, rocketsfired, c4thrown, satchelsthrown, tcsdestroyed, chickens, boars, deers, horses, wolves, bears, scientists, helicopters, bradleys, ak47, lr300, m39, sar, hmlmg, m249, bolt, l96, mp5, thompson, custom, pump, doublebarrel, spaz12, m92, python, semipistol, revolver, waterpipe, eoka, compound, crossbow, bow, head_hits, torso_hits, leftarm_hits, rightarm_hits, leftleg_hits, rightleg_hits, leftfoot_hits, rightfoot_hits, prototype17, nailgun
		FROM `' , @name, '_stats_wipe`
		WHERE NOT EXISTS (SELECT * FROM ' , @name, '_stats_overall WHERE steamid = ' , @name, '_stats_wipe.steamid)
	');
	PREPARE myStatement FROM @st;
	EXECUTE myStatement;
	DEALLOCATE PREPARE myStatement;
END$$
DELIMITER ;

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `updateData`(IN `serverPrefix` VARCHAR(50))
BEGIN
	SET @name = serverPrefix;
	SET @st = CONCAT('
		UPDATE
		    ' , @name, '_stats_wipe wipe,
		    ' , @name, '_stats_overall overall
		SET
			 overall.name = wipe.name,
		    overall.connections = overall.connections + wipe.connections,
		    overall.playtime = overall.playtime + wipe.playtime,
		    overall.kills = overall.kills + wipe.kills,
		    overall.deaths = overall.deaths + wipe.deaths,
		    overall.bfired = overall.bfired + wipe.bfired,
		    overall.suicides = overall.suicides + wipe.suicides,
		    overall.wounded = overall.wounded + wipe.wounded,
		    overall.rocketsfired = overall.rocketsfired + wipe.rocketsfired,
		    overall.c4thrown = overall.c4thrown + wipe.c4thrown,
		    overall.satchelsthrown = overall.satchelsthrown + wipe.satchelsthrown,
		    overall.tcsdestroyed = overall.tcsdestroyed + wipe.tcsdestroyed,
		    overall.chickens = overall.chickens + wipe.chickens,
		    overall.boars = overall.boars + wipe.boars,
		    overall.deers = overall.deers + wipe.deers,
		    overall.horses = overall.horses + wipe.horses,
		    overall.wolves = overall.wolves + wipe.wolves,
		    overall.bears = overall.bears + wipe.bears,
		    overall.scientists = overall.scientists + wipe.scientists,
		    overall.helicopters = overall.helicopters + wipe.helicopters,
		    overall.bradleys = overall.bradleys + wipe.bradleys,
		    overall.ak47 = overall.ak47 + wipe.ak47,
		    overall.lr300 = overall.lr300 + wipe.lr300,
		    overall.m39 = overall.m39 + wipe.m39,
		    overall.sar = overall.sar + wipe.sar,
		    overall.hmlmg = overall.hmlmg + wipe.hmlmg,
		    overall.m249 = overall.m249 + wipe.m249,
		    overall.bolt = overall.bolt + wipe.bolt,
		    overall.l96 = overall.l96 + wipe.l96,
		    overall.mp5 = overall.mp5 + wipe.mp5,
		    overall.thompson = overall.thompson + wipe.thompson,
		    overall.custom = overall.custom + wipe.custom,
		    overall.pump = overall.pump + wipe.pump,
		    overall.doublebarrel = overall.doublebarrel + wipe.doublebarrel,
		    overall.spaz12 = overall.spaz12 + wipe.spaz12,
		    overall.m92 = overall.m92 + wipe.m92,
		    overall.python = overall.python + wipe.python,
		    overall.semipistol = overall.semipistol + wipe.semipistol,
		    overall.revolver = overall.revolver + wipe.revolver,
		    overall.waterpipe = overall.waterpipe + wipe.waterpipe,
		    overall.eoka = overall.eoka + wipe.eoka,
		    overall.compound = overall.compound + wipe.compound,
		    overall.crossbow = overall.crossbow + wipe.crossbow,
		    overall.bow = overall.bow + wipe.bow,
		    overall.head_hits = overall.head_hits + wipe.head_hits,
		    overall.torso_hits = overall.torso_hits + wipe.torso_hits,
		    overall.leftarm_hits = overall.leftarm_hits + wipe.leftarm_hits,
		    overall.rightarm_hits = overall.rightarm_hits + wipe.rightarm_hits,
		    overall.leftleg_hits = overall.leftleg_hits + wipe.leftleg_hits,
		    overall.rightleg_hits = overall.rightleg_hits + wipe.rightleg_hits,
		    overall.leftfoot_hits = overall.leftfoot_hits + wipe.leftfoot_hits,
		    overall.rightfoot_hits = overall.rightfoot_hits + wipe.rightfoot_hits,
            overall.prototype17 = overall.prototype17 + wipe.prototype17,
            overall.nailgun = overall.nailgun + wipe.nailgun
   
		WHERE
		    overall.steamid = wipe.steamid;
	');
	PREPARE myStatement FROM @st;
	EXECUTE myStatement;
	DEALLOCATE PREPARE myStatement;
END$$
DELIMITER ;

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `wipeTime`(IN `serverPrefix` VARCHAR(50))
BEGIN
	SET @serverPrefix = serverPrefix;
	CALL updateData(@serverPrefix);
	CALL insertStats(@serverPrefix);
	
	SET @st = CONCAT('TRUNCATE TABLE ', @serverPrefix, '_stats_wipe');
	PREPARE myStatement FROM @st;
	EXECUTE myStatement;
	DEALLOCATE PREPARE myStatement;
END$$
DELIMITER ;

 

bushcake

bushcake 12

Posted (edited)

delete 

Edited by bushcake
bushcake

bushcake 12

Posted (edited)

deletr

Edited by bushcake
bushcake

bushcake 12

Posted

Can the UI be disabled in game to stay in the community section?  

Horse

Horse 22

Posted (edited)

hearing a lot of stuff from other server owners about this leaderboard having security vulnerabilities including the ability to damage servers with sql injection and players with special characters in their names causing error flooding. Has this all been fixed since? Thanks

Edited by ezplugin
  • Like 1
Miho

Miho 12

Posted

It seems like it doesn't recognize names written in languages other than English and numbers. Has this issue been resolved, or is there a plan to resolve it in the future?

Billy Joe

Billy Joe 108

Posted

  • File Author
6 hours ago, Miho said:

It seems like it doesn't recognize names written in languages other than English and numbers. Has this issue been resolved, or is there a plan to resolve it in the future?

What do you mean?

Billy Joe

Billy Joe 108

Posted

  • File Author
On 10/18/2023 at 4:00 PM, ezplugin said:

hearing a lot of stuff from other server owners about this leaderboard having security vulnerabilities including the ability to damage servers with sql injection and players with special characters in their names causing error flooding. Has this all been fixed since? Thanks

This was fixed.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Like 1
  • Love 2
 Share
Previous File PopUp API
Next File CustomDrop

Billy Joe's Collection

User Feedback

1.4m

Downloads

Total number of downloads.

6.9k

Customers

Total customers served.

102.3k

Files Sold

Total number of files sold.

2m

Payments Processed

Total payments processed.

Customers

Providers

Resources

About Us

Codefling is the largest marketplace to buy and sell plugins, maps, tools, and more! Our modern platform makes it easy to find exciting new content while providing a feature-rich environment for creators to monetize their work!

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.