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

SQL Feedback


Post New Thread Reply   
 
Thread Tools Display Modes
Author
bl4nk
SourceMod Developer
Join Date: Jul 2007
Plugin ID:
277
Plugin Version:
1.2.0
Plugin Category:
Server Management
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
    5 
    Plugin Description:
    Take client feedback and store it in a SQL database.
    Old 02-08-2008 , 06:25   SQL Feedback
    Reply With Quote #1

    SQL Feedback
    Take client feedback on the server/current map and store it in a SQL database.

    Commands:
    feedback <text> - Logs feedback info into the SQL database.

    Installation:
    • Download sqlfeedback.smx file to your ~/addons/sourcemod/plugins folder.
    • Make sure you have an active SQL server running, and have configured the "default" connection properly.
    Notes:
    • A client can only use the 'feedback' command once per 5 seconds (to avoid spamming).
    • The command must be issued via console.
    • When a client sends feedback to the server, their name, steamid, the current map (if applicable), the time, and their feedback are all stored on the appropriate table.
    • There is one MySQL table that records the client's feedback, their steamid, the current map, the date, the game's folder name, and the server ip/port that they're connected to.
    Changelog:
    • 1.0.0
      • Initial Release
    • 1.0.1
      • Quotes in client's names and in feedback are now properly handled.
      • If the query fails, the plugin will no longer try to close that query's handle.
    • 1.1.0
      • Changed the command's usage to just "feedback <text>" instead of having to specify "server" or "map" as the first param.
      • Removed usage of the 'feedback_server' table.
      • Renamed the 'feedback_map' table to just 'feedback'.
      • The table is automatically created by the plugin now (if it doesn't already exist).
      • Fixed a bug where users couldn't send feedback on the next map if they sent feedback within 5 seconds of a map change.
      • Removed unnecessary coding and optimized the plugin a bit.
    • 1.2.0
      • Added logging of the server ip and port, and the game's name.
      • If you're updating from v1.1.0, check out this post for proper update instructions.
    Attached Files
    File Type: sp Get Plugin or Get Source (sqlfeedback.sp - 2867 views - 3.9 KB)

    Last edited by bl4nk; 10-26-2010 at 14:59.
    bl4nk is offline
    bl4nk
    SourceMod Developer
    Join Date: Jul 2007
    Old 02-08-2008 , 08:54   Re: SQL Feedback
    Reply With Quote #2

    Here's an example page written in PHP that will grab all of the rows for the tables and print them out for you.
    Attached Files
    File Type: txt sqlfeedback.php.txt (1.1 KB, 1163 views)

    Last edited by bl4nk; 11-27-2009 at 03:16.
    bl4nk is offline
    hazard
    Member
    Join Date: Jun 2007
    Old 02-08-2008 , 15:41   Re: SQL Feedback
    Reply With Quote #3

    most impressive
    hazard is offline
    ottobohn
    Senior Member
    Join Date: Sep 2007
    Old 02-08-2008 , 16:37   Re: SQL Feedback
    Reply With Quote #4

    This will be great for my deathmatch server!

    Could you have a version that saves it locally? We wouldn't need a DB for it, but rather just a vote_results file or something?

    Otto
    n00bsalad.net
    ottobohn is offline
    bl4nk
    SourceMod Developer
    Join Date: Jul 2007
    Old 02-08-2008 , 18:17   Re: SQL Feedback
    Reply With Quote #5

    I'm not sure what you mean by a "vote_results file".
    bl4nk is offline
    ottobohn
    Senior Member
    Join Date: Sep 2007
    Old 02-09-2008 , 09:26   Re: SQL Feedback
    Reply With Quote #6

    Instead of the vote results being put to mysql, could you put it to one file locally?

    thanks!
    ottobohn is offline
    bl4nk
    SourceMod Developer
    Join Date: Jul 2007
    Old 02-09-2008 , 09:45   Re: SQL Feedback
    Reply With Quote #7

    This doesn't have anything to do with vote results. But I guess I could add a feature in to store it to a local file rather than a database.
    bl4nk is offline
    MoggieX
    Veteran Member
    Join Date: Aug 2007
    Location: n00bville
    Old 02-09-2008 , 20:57   Re: SQL Feedback
    Reply With Quote #8

    Hi bl4nk,

    NICE WORK!!!

    May I suggest a copy of what UKCS have on thier servers, which is a vote menu enabling the player to pass a vote on that map [on players 1st spawn], but with the addition on this, to not only take that vote, BUT to also take thier comments too.

    This would be ace for our comminity.

    Matt
    __________________
    MoggieX is offline
    Send a message via Skype™ to MoggieX
    bl4nk
    SourceMod Developer
    Join Date: Jul 2007
    Old 02-10-2008 , 00:24   Re: SQL Feedback
    Reply With Quote #9

    Updated to Version 1.0.1

    I'll look into doing voting on quality of maps as an additional part of this plugin.
    bl4nk is offline
    pRED*
    Join Date: Dec 2006
    Old 02-20-2008 , 14:56   Re: SQL Feedback
    Reply With Quote #10

    Very nice, like always bl4nk. Approved.
    pRED* 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:08.


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