AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)
-   -   [ANY] Report bot ( SQL + Instant Discord Notification ) (https://forums.alliedmods.net/showthread.php?t=326558)

XiSl0w 08-05-2020 18:37

[ANY] Report bot ( SQL + Instant Discord Notification )
 
1 Attachment(s)
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

Trum 08-05-2020 18:50

Re: [ANY] Report bot ( SQL + Instant Discord Notification )
 
8)

Fearts 08-06-2020 16:50

Re: [ANY] Report bot ( SQL + Instant Discord Notification )
 
Would be cool if you added a ingame menu with a list of reasons and being able to chose players on the server via menu. This way people can't input stupid reasons and limits mistakes of reporting the wrong person.

Benito 08-07-2020 21:42

Re: [ANY] Report bot ( SQL + Instant Discord Notification )
 
:D

awyx 04-14-2021 07:44

Re: [ANY] Report bot ( SQL + Instant Discord Notification )
 
this plugins also requires smjansson and a discord api plugin, would be nice to add to your post since people are having problems using it

Code:

[SM] Unable to load plugin "report_bot.smx": Required extension "SMJansson" file("smjansson.ext") not running
Code:

[SM] Unable to load plugin "report_bot.smx": Native "DiscordWebHook.Send" was not found

laspi94 06-16-2021 17:55

Re: [ANY] Report bot ( SQL + Instant Discord Notification )
 
Quote:

Originally Posted by awyx (Post 2744048)
this plugins also requires smjansson and a discord api plugin, would be nice to add to your post since people are having problems using it

Code:

[SM] Unable to load plugin "report_bot.smx": Required extension "SMJansson" file("smjansson.ext") not running
Code:

[SM] Unable to load plugin "report_bot.smx": Native "DiscordWebHook.Send" was not found

I have the same problem


All times are GMT -4. The time now is 11:39.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.