Raised This Month: $535 Target: $400
 133% 

[ANY] Simple Reports v2 (MySQL, Discord) + Addons


Post New Thread Reply   
 
Thread Tools Display Modes
Author
Mesharsky How2Kill
AlliedModders Donor
Join Date: May 2017
Location: Ireland
Plugin ID:
8150
Plugin Version:
2.0.3
Plugin Category:
All
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    A simple player reporting plugin that stores reports in a MySQL database, with Discord integration to help server admins to react faster to the reports.
    Old 08-10-2022 , 23:59   [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #1

    [ANY] Simple Reports Plugin 2.0.3

    A simple player reporting plugin that stores reports in a MySQL database, with Discord integration to help server admins to react faster to the reports.

    It's a rewrite of this plugin: Older version of Reports

    SUPPORTED GAMES
    • CS:GO
    • CS:Source
    • Team Fortress 2
    • Left 4 Dead 2 (Sound does not work)

    Other games should still work, but their gametype will be marked as unknown in the database.
    If you test other games and they work properly, let me know so I can add official support for it!


    FEATURES
    • An extensive and eye-catching configuration file.
    • MySQL database support to store reports.
    • Sourcebans integration - Sends report to sourcebans database (sb_submissions).
    • SourceMod translations support.
    • In-game admin notification (with optional sound).
    • Block unicode/UTF8 characters from Custom Reason (Customize through configuration file).
    • Full Discord Integration (Embed + Normal Messages). Fully configurable through configuration file, with completely customiseable message text.

    COMMANDS
    • !report OR !zglos - Main Report Menu.
    • !reloadreports - Reload Configuration File (requires root flag).

    HOW TO CONFIGURE

    Read the documentation inside the config file.

    INSTALLATION

    Download the latest release from here.
    You can also download thread files provided in .zip file but they could be out of date in the future.

    All the extensions and required plugins are in the zip file provided.
    1. Upload all files to root directory of your server (How to install plugins)
      Make sure discord_api plugin and smjansson extension are also uploaded (both are required).
    2. This plugin requires a MySQL Database. You will need to add the connection into
      addons/sourcemod/configs/databases.cfg like below:

      PHP Code:
      "reports"
          
      {
              
      "driver"            "default"
              "host"                "database host (example: 152.325.654.245)"
              "database"            "database name"
              "user"                "database username"
              "pass"                "database password"
          

    3. Configure plugin settings in the configuration file: addons/sourcemod/configs/reports.cfg

      "How do I get the discord channel webhook?"
      Please follow the official discord guide on how to get your WebHook for discord channel.

      DISCORD PREVIEW


    WEB ADDONS

    My friend made plugin integration with Invision Community CMS Forum Software.
    The plugin can be found in the web_addons folder in the repository along with installation instructions.

    EXTENSIONS/LIBRARIES/INCLUDES USED

    SMJansson
    Discord API
    MultiColors (included in the repository)

    LANGUAGE SUPPORT
    • English
    • Polish
    • Russian
    If you make translations for other languages let me know. I will include it in next release!

    DISCORD INTEGRATION FEATURES
    • message modes - embed/normal messages.
    • bot_picture_url - Bots profile picture (url)
    • bot_name - Set your own bot name on the server
    • embed_title - Set title for the message
    • embed_field_name - Message title text (sub-header).
    • embed_color - Embed colour (in hex).
    • embed_footer - Footer message text.
    • embed_thumbnail_url - Thumbnail picture URL for the embed message.
    • Mention Roles Supported.
    • Discord message text with special values supported (List of them and guide in the configuration file)
      PHP Code:
      "Message Text"
              
      {
                  
      "line" "Server: {server_name} (IP: {server_ip})"
                  "line" "Player: [{client_name}]({client_profile})"
                  "line" "Reported: [{reported_name}]({reported_profile})"
                  "line" ""
                  "line" "Reason: {report_reason}"
                  "line" ""
                  "line" ""
                  "line" "{mentions_list}"
              


    CREDITS

    Me - I made this lmao
    Thrawn2 - Extension used in the plugin.
    Deathknife - Discord Api Plugin.
    Bara - Multicolors Include.
    Digby - Huge help and tips how to write better code + Annoying

    Thank you and enjoy!
    Attached Files
    File Type: zip Simple-Reports-main.zip (120.6 KB, 100 views)
    File Type: zip Simple-Reports-2.0.3-stable.zip (124.4 KB, 57 views)
    __________________
    If you appreciate my work you can send me a Donation

    Thanks everyone for using my work!

    Any requests or question please contact me on discord: Mesharsky#6565

    Last edited by Mesharsky How2Kill; 10-10-2022 at 22:17.
    Mesharsky How2Kill is offline
    EZR
    Junior Member
    Join Date: Apr 2018
    Location: Turkey
    Old 08-11-2022 , 13:23   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #2

    good work but can I suggest a feature? can you add a processing feature to the generated reports for example "x admin processed the report"
    EZR is offline
    Mesharsky How2Kill
    AlliedModders Donor
    Join Date: May 2017
    Location: Ireland
    Old 08-11-2022 , 13:40   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #3

    Quote:
    Originally Posted by EZR View Post
    good work but can I suggest a feature? can you add a processing feature to the generated reports for example "x admin processed the report"
    Tell me a little bit more about it. Any idea how could it work?
    Mesharsky How2Kill is offline
    EZR
    Junior Member
    Join Date: Apr 2018
    Location: Turkey
    Old 08-11-2022 , 14:46   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #4

    I'm not sure if I can tell you how it will work Each report must have its own report number, and admins can process these reports from the number example https://github.com/Impact123/CallAdm...C%20int%20argc

    Last edited by EZR; 08-11-2022 at 14:48.
    EZR is offline
    Mesharsky How2Kill
    AlliedModders Donor
    Join Date: May 2017
    Location: Ireland
    Old 08-16-2022 , 13:29   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #5

    Quote:
    Originally Posted by EZR View Post
    I'm not sure if I can tell you how it will work Each report must have its own report number, and admins can process these reports from the number example https://github.com/Impact123/CallAdm...C%20int%20argc
    I think i know what you mean and process of implementing this will take some time. And i would like to see more feedback about it if anyone else would like that implemented.

    My idea:
    1. You have admin menu with all recent / not assigned reports (With their unique id).
    2. You can assign as an admin to the report.
    3. You have menu option will your assigned reports.
    4. Resolve report with a reason. (Send's a seperate discord notification that report has been resolved with a reason).

    That will of course require to rebuild or add another database table or incease the fields in the current one.

    As im on holidays at the moment i could start working on it at the end of this month.
    Tell me if that would satisfy you.

    Thank you!
    Mesharsky How2Kill is offline
    Mesharsky How2Kill
    AlliedModders Donor
    Join Date: May 2017
    Location: Ireland
    Old 10-04-2022 , 15:32   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #6

    New Version is out - 2.0.3

    NEW FEATURES:
    • Sourcebans integration (Plugin will sent report to sourcebans database and move sbpp_report.smx to disabled folder).
    • Added "Russian" translations
    • Code improved (optimized)
    PLANS FOR NEXT RELEASE:
    • Fix mentions in embed (It wasn't fixed in this release as i didin't decide on the approach that will work well with config).
    • Steam Message Bot integration (https://github.com/dordnung/MessageBot)
    PLANS FOR FUTURE RELEASES:
    • Better Discord Api with more features.
    • Fix Discord Profile Picture on normal message mode.
    • Add Natives to the plugin.
    • More Web Addons integrations!

    Download latest release here: CLICK HERE
    Package also updated in the topic.

    Mesharsky How2Kill is offline
    whiteskypony
    Member
    Join Date: Jun 2015
    Location: vsh_crevice_b5
    Old 10-05-2022 , 17:42   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #7

    Just made a pull request for spanish translation, i also like to report a bug?

    At least for me when i tested the plugin this part:

    Quote:
    "en" "{yellow}--- {lightred}REPORT NOTIFICATION {yellow}---"
    The "{lightred}" shows ingame as text and not changing the color of the text after it.
    __________________
    Steam | Vidya Servers | Discord: Maximo#5396


    whiteskypony is offline
    Mesharsky How2Kill
    AlliedModders Donor
    Join Date: May 2017
    Location: Ireland
    Old 10-05-2022 , 21:13   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #8

    Quote:
    Originally Posted by whiteskypony View Post
    Just made a pull request for spanish translation, i also like to report a bug?

    At least for me when i tested the plugin this part:



    The "{lightred}" shows ingame as text and not changing the color of the text after it.
    Hello, your translations has been added to the repo and it's gonna be available in next release.

    What game are you using plugin on?
    In TF2 {lightred} might not work, did you try using other color instead?

    https://forums.alliedmods.net/showthread.php?t=185016
    Aparently for TF2 it does not exist

    You might want to try using this list: https://www.doctormckay.com/morecolors.php

    Last edited by Mesharsky How2Kill; 10-05-2022 at 21:31. Reason: typo
    Mesharsky How2Kill is offline
    whiteskypony
    Member
    Join Date: Jun 2015
    Location: vsh_crevice_b5
    Old 10-05-2022 , 22:00   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #9

    Quote:
    Originally Posted by Mesharsky How2Kill View Post
    Hello, your translations has been added to the repo and it's gonna be available in next release.

    What game are you using plugin on?
    In TF2 {lightred} might not work, did you try using other color instead?

    https://forums.alliedmods.net/showthread.php?t=185016
    Aparently for TF2 it does not exist

    You might want to try using this list: https://www.doctormckay.com/morecolors.php
    Yes it was TF2, for my server i adjusted the color to just red.

    Also i noticed this, is not showing the IP of our server any idea why it may be?
    It shows just 0 on the IP and it happens on both servers that we have the plugin.
    __________________
    Steam | Vidya Servers | Discord: Maximo#5396



    Last edited by whiteskypony; 10-05-2022 at 22:05.
    whiteskypony is offline
    Mesharsky How2Kill
    AlliedModders Donor
    Join Date: May 2017
    Location: Ireland
    Old 10-06-2022 , 06:26   Re: [ANY] Simple Reports v2 (MySQL, Discord) + Addons
    Reply With Quote #10

    Quote:
    Originally Posted by whiteskypony View Post
    Yes it was TF2, for my server i adjusted the color to just red.

    Also i noticed this, is not showing the IP of our server any idea why it may be?
    It shows just 0 on the IP and it happens on both servers that we have the plugin.

    That might be correct. Probably cvars used in the plugin to get Server's IP does not exist in TF2.
    I'm going to work on that so it's going to be fixed for next release (if possible).

    At this point you can manually insert servers ip inside the configuration file, i hope that will be enough untill now.

    Thank you for the report
    Mesharsky How2Kill is offline
    Reply


    Thread Tools
    Display Modes

    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 08:40.


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