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

[ANY] Simple Mysql Whitelist


Post New Thread Reply   
 
Thread Tools Display Modes
xines
Veteran Member
Join Date: Aug 2013
Location: Denmark
Old 09-02-2016 , 07:19   Re: [ANY] Simple Mysql Whitelist
Reply With Quote #11

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 #12

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 #13

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 #14

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 #15

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 #16

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 #17

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 #18

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 #19

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 #20

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 08:00.


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