Raised This Month: $32 Target: $400
 8% 

simple mysql reports CSGO


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
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 - 1155 views - 4.0 KB)
    File Type: smx mysql_reports.smx (6.0 KB, 385 views)

    Last edited by juss; 08-02-2017 at 01:45.
    juss is offline
     


    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 07:14.


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