Raised This Month: $ Target: $400
 0% 

[ANY] Simple Mysql Whitelist


Post New Thread Reply   
 
Thread Tools Display Modes
Author
xines
Veteran Member
Join Date: Aug 2013
Location: Denmark
Plugin ID:
5331
Plugin Version:
1.5
Plugin Category:
Server Management
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Mysql database whitelister to control player access to server[s].
    Old 09-02-2016 , 07:19   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #1

    Quote:
    Originally Posted by Potato Uno View Post
    Asherkin uses it himself in his connect extension's plugin.

    You can still bolt a second check in postadmin to be super safe.

    I use that code to prevent non-admins from getting into a server and it never failed me.
    Okay, in that case, i've changed the code to use OnClientAuthorized function and updated the function to check for flags since you did not include that in the example, but thanks!
    Quote:
    Updated to 1.3!
    __________________
    xines is offline
    xines
    Veteran Member
    Join Date: Aug 2013
    Location: Denmark
    Old 09-03-2016 , 10:22   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #2

    look changelog.
    Quote:
    Updated to 1.4!
    __________________
    xines is offline
    g00gl3
    Member
    Join Date: Feb 2016
    Location: bulgaria
    Old 09-03-2016 , 17:33   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #3

    its can be awesome if you will make a simple website to control the whitelist

    to add a steamid and remove and see all steamid's in the whitelist

    Last edited by g00gl3; 09-03-2016 at 17:39.
    g00gl3 is offline
    xines
    Veteran Member
    Join Date: Aug 2013
    Location: Denmark
    Old 09-04-2016 , 16:56   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #4

    Quote:
    Originally Posted by g00gl3 View Post
    its can be awesome if you will make a simple website to control the whitelist

    to add a steamid and remove and see all steamid's in the whitelist
    I'll see what i can do!

    If anyone is familiar with PHP and wants to help me, then feel free to pm me!
    __________________
    xines is offline
    Addicted.
    AlliedModders Donor
    Join Date: Dec 2013
    Location: 0xA9D0DC
    Old 09-05-2016 , 13:49   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #5

    Quote:
    Originally Posted by xines View Post
    I'll see what i can do!

    If anyone is familiar with PHP and wants to help me, then feel free to pm me!
    You know where I'm at
    Addicted. is offline
    sneaK
    SourceMod Moderator
    Join Date: Feb 2015
    Location: USA
    Old 01-02-2017 , 20:18   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #6

    Hey xines, I was working with this plugin today and had some issues.

    First issue, STEAM ID's are all saved as STEAM_0, and on CS:GO without being entered as STEAM_1, then those clients are booted. I changed line 260 and 322 to STEAM_1 and that part worked fine.

    Second issue, sm_whitelist_adminflag is extremely finicky. When set in console, players with said flag can join, however on map change they are booted and unable to join if their steam id is not in the whitelist. Also, when a flag specified, a user with z flag is still booted.

    Third issue, within 10 minutes of testing the plugin, after a map change, a random person was able to join. How? No idea. No error logs in that respect.

    Fourth issue, if I attempt to add or remove a steam id through rcon, this error occurs:

    Code:
    L 01/02/2017 - 19:01:56: [SM] Exception reported: Client index 0 is invalid
    L 01/02/2017 - 19:01:56: [SM] Blaming: simple_mysql_whitelister.smx
    L 01/02/2017 - 19:01:56: [SM] Call stack trace:
    L 01/02/2017 - 19:01:56: [SM]   [0] GetClientUserId
    L 01/02/2017 - 19:01:56: [SM]   [1] Line 267, G:\csgo\plugin zips\sourcemod 1.8\scripting\simple_mysql_whitelister.sp::Command_Add
    __________________
    sneaK is offline
    Addicted.
    AlliedModders Donor
    Join Date: Dec 2013
    Location: 0xA9D0DC
    Old 01-02-2017 , 22:20   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #7

    Quote:
    Originally Posted by blackhawk74 View Post
    First issue, STEAM ID's are all saved as STEAM_0, and on CS:GO without being entered as STEAM_1, then those clients are booted. I changed line 260 and 322 to STEAM_1 and that part worked fine.
    From experience I have seen them go either way.

    I'd say make the plugin accept both
    Addicted. is offline
    sneaK
    SourceMod Moderator
    Join Date: Feb 2015
    Location: USA
    Old 01-03-2017 , 00:51   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #8

    Quote:
    Originally Posted by oaaron99 View Post
    From experience I have seen them go either way.

    I'd say make the plugin accept both
    Agreed, however after a lot of testing, it wasn't allowing players in unless their steam ID's started with STEAM_1. STEAM_0 disallowed everyone.
    __________________
    sneaK is offline
    Addicted.
    AlliedModders Donor
    Join Date: Dec 2013
    Location: 0xA9D0DC
    Old 01-04-2017 , 17:09   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #9

    Quote:
    Originally Posted by blackhawk74 View Post
    Agreed, however after a lot of testing, it wasn't allowing players in unless their steam ID's started with STEAM_1. STEAM_0 disallowed everyone.
    Yeah no argument against that, just saying it should work for both instead of just changing it.
    Addicted. is offline
    xines
    Veteran Member
    Join Date: Aug 2013
    Location: Denmark
    Old 02-20-2017 , 22:57   Re: [ANY] Simple Mysql Whitelist
    Reply With Quote #10

    Quote:
    Originally Posted by blackhawk74 View Post
    Hey xines, I was working with this plugin today and had some issues.
    Hello and thanks for the feedback, i'm sorry been so busy irl, that i totally missed this.
    I'll be updating this soon, and re-test, prob aswell gonna add faster/better mysql support!

    But yeah, if want you are welcome to add me on steam, and i'll push updates for you untill things are solved, as i mainly test on CS:S and not CS:GO.
    __________________
    xines is offline
    Reply



    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 13:28.


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