Raised This Month: $12 Target: $400
 3% 

simple mysql reports CSGO


Post New Thread Reply   
 
Thread Tools Display Modes
Author
juss
Senior Member
Join Date: Jan 2016
Plugin ID:
5748
Plugin Version:
Plugin Category:
Server Management
Plugin Game:
Counter-Strike: GO
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Old 08-01-2017 , 13:26   simple mysql reports CSGO
    Reply With Quote #1

    As the title says, this plugin allows players made reports on players that behave bad, this is my first plugin ever, so mods please check the SP file..

    How it works
    Simple in game chat you type !report the menu with players will pop up, you choose the player and he's steam_id will be stored to your database in column reported, in column reporter you can find steam_id of the player who made report

    Creating table to store data

    CREATE TABLE `sm_report` (
    `id` int(64) NOT NULL AUTO_INCREMENT,
    `reported` varchar(32) DEFAULT '',
    `reporter` varchar(32) DEFAULT '',
    `reason` text,
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

    In yourSourcemod/configs/databases.cfg
    Don't forget to add your credentials
    "default"
    {
    "driver" "default"
    "host" "localhost"
    "database" "your_database"
    "user" "your_login"
    "pass" "your_password"
    //"timeout" "0"
    "port" "3306"
    }
    Attached Files
    File Type: sp Get Plugin or Get Source (mysql_reports.sp - 1151 views - 4.0 KB)
    File Type: smx mysql_reports.smx (6.0 KB, 383 views)

    Last edited by juss; 08-02-2017 at 01:45.
    juss is offline
    juss
    Senior Member
    Join Date: Jan 2016
    Old 08-01-2017 , 13:30   Re: simple mysql reports CSGO
    Reply With Quote #2

    feel free to redo this plugin , inside mysql_reports.sp you can find that i tried also add The reason menu (so in first menu you can pick the Player - when opens second menu with the reason) - i started but didn't make that due to lack of knowledge the sourcepawn
    juss is offline
    HelloBaBeS
    Junior Member
    Join Date: Dec 2018
    Old 05-13-2019 , 10:56   Re: simple mysql reports CSGO
    Reply With Quote #3

    Only the players menu is open, the reason menu does not work.
    Can u help me?
    HelloBaBeS is offline
    Kaito345
    New Member
    Join Date: Jun 2020
    Old 06-01-2020 , 16:42   Re: simple mysql reports CSGO
    Reply With Quote #4

    Hello! I installed your plugin on my server and it works, but I have a problem, when someone is using it, the menu for the "reasons" does not show up, instead the report is sent automatically. Do you know why this happens? or any solution?
    Thank you.
    Kaito345 is offline
    Notifications
    AlliedModders Donor
    Join Date: Oct 2015
    Old 06-01-2020 , 17:04   Re: simple mysql reports CSGO
    Reply With Quote #5

    Quote:
    Originally Posted by Kaito345 View Post
    Hello! I installed your plugin on my server and it works, but I have a problem, when someone is using it, the menu for the "reasons" does not show up, instead the report is sent automatically. Do you know why this happens? or any solution?
    Thank you.
    I'd recommend just using CallAdmin instead of this as the Author of this plugin hasn't been active since 2018.

    Last edited by Notifications; 06-01-2020 at 17:04.
    Notifications is offline
    Kaito345
    New Member
    Join Date: Jun 2020
    Old 06-02-2020 , 00:48   Re: simple mysql reports CSGO
    Reply With Quote #6

    Quote:
    Originally Posted by Notifications View Post
    I'd recommend just using CallAdmin instead of this as the Author of this plugin hasn't been active since 2018.
    Ok, thanks
    Kaito345 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:19.


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