HUGE - StatsPoster

Simple script for post server count from database to diferent discord list websites.

Requirements

• A postgresql database.
• A schema called discord.
• A table called discord.shard_guilds.
• A credentials.conf file with all your credentials

Database schema ans table

CREATE SCHEMA discord AUTHORIZATION your_database_user;

CREATE TABLE shard_stats (
	id int4 NOT NULL,
	guild_count int4 NOT NULL,
	CONSTRAINT shard_stats_pkey PRIMARY KEY (id)
);

How to build and execute the script

With Golang

go run main

Windows

go build
./stats-poster.exe

Linux

go build
chmod +x stats-poster
./stats-poster

Schedule with cronjob on Linux

crontab -e

@hourly cd /path/to/binary && stats-poster

or

0 * * * * cd /path/to/binary && stats-poster