Short Description:
A plugin that allows players to report, basically a player on the server types !report <reason> or !report <username/id> <reason> and it'll add it to the specified database and send a notification to your discord channel using webhooks.
Requires:
SteamWorks
Installation:
1- Download the file and extract it in your sourcemod file.
2- Navigate to your csgo folder/cfg/sourcemod/report_bot.cfg and insert your webhook
3- go to your database config and insert the following at the end:
Code:
"reports"
{
"driver" "default"
"host" "yourhost"
"database" "yourdatabasename"
"user" "yourusername"
"pass" "yourpassword"
}
4- Copy the following text and replace the "<Your DataBase Name Here>" with your database name then save it as an sql file and import it to your database.
Code:
CREATE DATABASE IF NOT EXISTS `<Your DataBase Name Here>` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `<Your DataBase Name Here>`;
DROP TABLE IF EXISTS `blocked`;
CREATE TABLE `blocked` (
`id` int(11) NOT NULL,
`steam_id` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
`id` int(11) NOT NULL,
`server_name` varchar(128) NOT NULL,
`reporter` varchar(64) NOT NULL,
`reporter_id` varchar(32) NOT NULL,
`suspect` varchar(64) DEFAULT NULL,
`suspect_id` varchar(32) DEFAULT NULL,
`reason` varchar(256) NOT NULL,
`dateOf` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`sent` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `blocked`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `steam_id` (`steam_id`);
ALTER TABLE `reports`
ADD PRIMARY KEY (`id`);
ALTER TABLE `blocked`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `reports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;COMMIT;
Preview:
1-
First
2-
Second
Credits:
Me
drew73197
Benito