Raised This Month: $ Target: $400
 0% 

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


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author
XiSl0w
Junior Member
Join Date: Jul 2020
Plugin ID:
7241
Plugin Version:
Plugin Category:
All
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Old 08-05-2020 , 18:37   [ANY] Report bot ( SQL + Instant Discord Notification )
    Reply With Quote #1

    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
    Attached Files
    File Type: zip report_bot.zip (26.6 KB, 353 views)

    Last edited by XiSl0w; 08-06-2020 at 05:38.
    XiSl0w is offline
     



    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off

    Forum Jump


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


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