Raised This Month: $182 Target: $400
 45% 

[ANY] Map Reporter


Post New Thread Reply   
 
Thread Tools Display Modes
Author
ecca
Sexy Santa
Join Date: Jan 2011
Plugin ID:
2818
Plugin Version:
1.5
Plugin Category:
General Purpose
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Allows users to report bugs on map to either MySQL or txt file
    Old 02-25-2012 , 15:58   [ANY] Map Reporter
    Reply With Quote #1

    Map Reporter

    A plugin that allows users to say !reportmap "reason" to report bugs on map to the server operators.

    You can switch between MySQL or use a txt file

    Installation:
    • Copy the mapreporter.smx to your plugins directory
    Screenshots:






    Cvars:
    • sm_mapreporter_advert //Allows you to change if it should advert to users on round start
    Setup:
    Quote:
    Databases.cfg:
    "mapreporter"
    {
    "driver" "mysql"
    "host" "YourHost"
    "database" "YourDatabase"
    "user" "YourUser"
    "pass" "YourPassword"
    //"timeout" "0"
    //"port" "0"
    }

    MySQL Table:

    CREATE TABLE IF NOT EXISTS `map_reports` (
    `map` varchar(100) NOT NULL,
    `player` varchar(100) NOT NULL,
    `steamid` varchar(100) NOT NULL,
    `comment` varchar(100) NOT NULL,
    `date` varchar(100) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    Webinterface:
    Just download it, edit the mysql connection and upload it into your webhost.
    ToDo:
    Quote:
    - Nothing
    Plugin Changelog:
    Quote:
    Map Reporter 1.4
    - See for changes: https://forums.alliedmods.net/showpo...5&postcount=14
    Map Reporter 1.3
    - Fixed so it checks automaticlly if you have setup a database ready to use for the plugin
    - Fixed possible mysql injection
    - Fixed GetCmdArgString instead so it pickup whole string
    - Fixed threaded query
    Map Reporter 1.2
    - Fixed the autoexec so the ConVars should be right now. Thanks Impact
    - Renamed autoexec file to small leters. Thanks Impact
    Map Reporter 1.1
    - Fixed client 0 is invalid
    - Changed to PrintToChatAll instead of printing to each client
    Map Reporter 1.0
    - Initial release
    WebbInterface Changelog:
    Quote:
    Webinterface 1.0
    - Initial release
    Attached Files
    File Type: sp Get Plugin or Get Source (mapreporter.sp - 265 views - 3.7 KB)
    File Type: sp Get Plugin or Get Source (mapreporter1.2.sp - 260 views - 3.7 KB)
    File Type: sp Get Plugin or Get Source (mapreporter1.3.sp - 235 views - 4.0 KB)
    File Type: sp Get Plugin or Get Source (mapreporter1.4.sp - 248 views - 3.7 KB)
    File Type: sp Get Plugin or Get Source (mapreporter1.5.sp - 376 views - 3.8 KB)

    Last edited by ecca; 03-24-2015 at 04:42.
    ecca is offline
    McFlurry
    Veteran Member
    Join Date: Mar 2010
    Location: RemoveEdict(0);
    Old 02-25-2012 , 17:14   Re: [ANY] Map Reporter
    Reply With Quote #2

    The heading at the top should say "Map Reporter" shouldn't it?
    __________________
    McFlurry is offline
    Send a message via Skype™ to McFlurry
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-25-2012 , 17:15   Re: [ANY] Map Reporter
    Reply With Quote #3

    Haha yes it should, i did it fast from my other plugin i submitted today, fixed thanks
    ecca is offline
    Drixevel
    AlliedModders Donor
    Join Date: Sep 2009
    Old 02-25-2012 , 17:40   Re: [ANY] Map Reporter
    Reply With Quote #4

    Why is it every plugin idea I start thinking of you do in A second. lol, no problem though.

    Good plugin though, thank you.
    __________________
    Taking private requests: http://steamcommunity.com/id/Drixevel/
    Drixevel is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-25-2012 , 20:27   Re: [ANY] Map Reporter
    Reply With Quote #5

    Updated version 1.1, Fixed error that client 0 is invalid, also using printtochatall instead of print to each client.
    ecca is offline
    Impact123
    AlliedModders Donor
    Join Date: Oct 2011
    Location: Germany
    Old 02-26-2012 , 00:19   Re: [ANY] Map Reporter
    Reply With Quote #6

    PHP Code:
    AutoExecConfig(true"sm_MapReporter"); 
    Should come before you check if some cvar is xyz.
    Also i suggest that you write configfiles in small letters.

    Yours sincerely
    Impact
    __________________

    Last edited by Impact123; 02-26-2012 at 10:14.
    Impact123 is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-26-2012 , 02:55   Re: [ANY] Map Reporter
    Reply With Quote #7

    Thanks impact, updated 1.2
    ecca is offline
    NagarD
    Junior Member
    Join Date: Jun 2011
    Old 03-01-2012 , 08:53   Re: [ANY] Map Reporter
    Reply With Quote #8

    correct url for Webinterface - http://ffac.eu/projekt/SourceMod/map_reports.zip.
    NagarD is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 03-01-2012 , 10:14   Re: [ANY] Map Reporter
    Reply With Quote #9

    Sorry forgot to update it, fixed thanks
    ecca is offline
    DarthNinja
    SourceMod Plugin Approver
    Join Date: Mar 2009
    Location: PreThinkHook()
    Old 03-01-2012 , 19:00   Re: [ANY] Map Reporter
    Reply With Quote #10

    A few things I noticed after a quick look:
    • You escape the players name, but not their input?
    • FastQuery is not threaded, you should probably use TQuery.
    • You should use SQL_CheckConfig before trying to connect.
    • Ideally you could also remove the sql/text cvar and always use SQL. Then fall back to text if SQL_CheckConfig returns false.
    • You could use GetCmdArgString to get the comment, then players would not have to use quotes.
    • It looks like you have a typo (" ms") on line 94.
    • Instead of (GetConVarInt(MySQL_Usage) == 1) you should use (GetConVarBool(MySQL_Usage))


    It might also be useful to save the players location when they use the command.
    Then it would also be possible to load the reports from the database, stick them in a menu, and allow admins to view, teleport to, and delete reports.


    __________________
    DarthNinja 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 20:52.


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