[Request] Members only

wundeR · **Author**

Hello!

I have been searching for an "Member only" plugins but no results.

How it works?
It should kick players if the steam id is not in an database.

What does it need?
* Sql connection to an database
* Kick player if the steam id are not in the database
* Kick message

(Sorry for bad english)

Thanks!

Danny_l4d · 11-21-2014 , 08:59 Re: [Request] Members only

Isn't it better to just lock you server with a password and give that to your members?

wundeR · 11-21-2014 , 09:07 Re: [Request] Members only

Quote:

Originally Posted by Danny_l4d

Isn't it better to just lock you server with a password and give that to your members?

Naa, i want a public server so everyone that are registered on the web page can play, and all can register

WildCard65 · 11-21-2014 , 11:00 Re: [Request] Members only

Quote:

Originally Posted by wundeR

Naa, i want a public server so everyone that are registered on the web page can play, and all can register

Lock server with sv_password and only have connect link with pass hidden to members only on website.

Bacardi · 11-21-2014 , 11:10 Re: [Request] Members only

I remember there is already that kind plugin (whitelist). But I found only TXT versions.

I made my own example, with temporary mysql connection inluded. (Not sure will it work 100%, in csgo timer stops when server hibernate)

- Edit databases.cfg and choose database name where you want connect.
- Plugin now query steamid results from table called members_only, change plugins source code if you have different named table already with steamid column
- Plugin not create table(s), you do it!
- Plugin skip check players first 8 char from steamid (STEAM_0:1:12345678)
so this should work accross all game mods (cs:s, csgo, etc. etc.).
example, these all steamid types in steamid column works:
STEAM_0:1:12345678
STEAM_1:1:12345678
1:12345678
- skips bots and admins
- cvar "sm_membersonly_kick_msg" you can change kick message
Tell if you have trouble.

example members only

edit ...addons/sourcemod/configs/databases.cfg

Code:

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	"members only"
	{
		"driver"			"mysql"
		"host"				"localhost"
		"database"			"sourcemod" // choose database where you want connect
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
}

PHP Code:


			
new Handle:g_hDatabase;
new Handle:g_hStatement;
new Handle:OnlineTimer;
new Handle:cvar;

public OnPluginStart()
{
    cvar = CreateConVar("sm_membersonly_kick_msg", "Members only!", "Kick message for non-members", FCVAR_PLUGIN);
}

public OnClientPostAdminCheck(client)
{
    // skip bots and admins who ahve access to admin menu
    if(IsFakeClient(client) || CheckCommandAccess(client, "sm_admin", ADMFLAG_GENERIC))
    {
        return;
    }

    // Mysql connection has closed at this moment, re-connect
    if(g_hDatabase == INVALID_HANDLE)
    {
        new String:error[512];
        g_hDatabase = SQL_Connect("members only", true, error, sizeof(error));

        // Error to connect
        if(g_hDatabase == INVALID_HANDLE)
        {
            SetFailState("SQL_Connect fail: %s", error);
        }
    }

    // Reset timer
    if(OnlineTimer != INVALID_HANDLE)
    {
        KillTimer(OnlineTimer);
        OnlineTimer = INVALID_HANDLE;
    }

    OnlineTimer = CreateTimer(20.0, OnlineTimer_callback, g_hDatabase);

    if(g_hStatement == INVALID_HANDLE)
    {
        new String:error[512];
        g_hStatement = SQL_PrepareQuery(g_hDatabase, "SELECT steamid FROM members_only WHERE steamid LIKE ?", error, sizeof(error));

        if(g_hStatement == INVALID_HANDLE)
        {
            LogError("SQL_PrepareQuery fail: %s", error);
            return;
        }
    }

    new String:auth[19];
    GetClientAuthString(client, auth, sizeof(auth));
    Format(auth, sizeof(auth), "%c%s", '%', auth[8]);

    SQL_BindParamString(g_hStatement, 0, auth, true);

    if(!SQL_Execute(g_hStatement))
    {
        LogError("SQL_Execute fail");
        return;
    }

    if(!SQL_GetRowCount(g_hStatement))
    {
        new String:msg[256];
        GetConVarString(cvar, msg, sizeof(msg));
        KickClient(client, " \n %s \n ", msg);
    }
}


public Action:OnlineTimer_callback(Handle:timer, Handle:db)
{
    OnlineTimer = INVALID_HANDLE;

    if(!SQL_IsSameConnection(g_hDatabase, db))
    {
        LogError("Different database connections has happen!!! Note for Dev");
    }

    if(g_hStatement != INVALID_HANDLE)
    {
        CloseHandle(g_hStatement);
        g_hStatement = INVALID_HANDLE;
    }

    if(g_hDatabase != INVALID_HANDLE)
    {
        CloseHandle(g_hDatabase);
        g_hDatabase = INVALID_HANDLE;
    }

    return Plugin_Continue;
}

wundeR · 11-21-2014 , 11:34 Re: [Request] Members only

Quote:

Originally Posted by Bacardi

I remember there is already that kind plugin (whitelist). But I found only TXT versions.

I made my own example, with temporary mysql connection inluded. (Not sure will it work 100%, in csgo timer stops when server hibernate)

- Edit databases.cfg and choose database name where you want connect.
- Plugin now query steamid results from table called members_only, change plugins source code if you have different named table already with steamid column
- Plugin not create table(s), you do it!
- Plugin skip check players first 8 char from steamid (STEAM_0:1:1234567

so this should work accross all game mods (cs:s, csgo, etc. etc.).
example, these all steamid types in steamid column works:
STEAM_0:1:12345678
STEAM_1:1:12345678
1:12345678
- skips bots and admins
- cvar "sm_membersonly_kick_msg" you can change kick message
Tell if you have trouble.

example members only

edit ...addons/sourcemod/configs/databases.cfg

Code:

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	"members only"
	{
		"driver"			"mysql"
		"host"				"localhost"
		"database"			"sourcemod" // choose database where you want connect
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
}

PHP Code:


			
new Handle:g_hDatabase;

new Handle:g_hStatement;

new Handle:OnlineTimer;

new Handle:cvar;



public OnPluginStart()

{

    cvar = CreateConVar("sm_membersonly_kick_msg", "Members only!", "Kick message for non-members", FCVAR_PLUGIN);

}



public OnClientPostAdminCheck(client)

{

    // skip bots and admins who ahve access to admin menu

    if(IsFakeClient(client) || CheckCommandAccess(client, "sm_admin", ADMFLAG_GENERIC))

    {

        return;

    }



    // Mysql connection has closed at this moment, re-connect

    if(g_hDatabase == INVALID_HANDLE)

    {

        new String:error[512];

        g_hDatabase = SQL_Connect("members only", true, error, sizeof(error));



        // Error to connect

        if(g_hDatabase == INVALID_HANDLE)

        {

            SetFailState("SQL_Connect fail: %s", error);

        }

    }



    // Reset timer

    if(OnlineTimer != INVALID_HANDLE)

    {

        KillTimer(OnlineTimer);

        OnlineTimer = INVALID_HANDLE;

    }



    OnlineTimer = CreateTimer(20.0, OnlineTimer_callback, g_hDatabase);



    if(g_hStatement == INVALID_HANDLE)

    {

        new String:error[512];

        g_hStatement = SQL_PrepareQuery(g_hDatabase, "SELECT steamid FROM members_only WHERE steamid LIKE ?", error, sizeof(error));



        if(g_hStatement == INVALID_HANDLE)

        {

            LogError("SQL_PrepareQuery fail: %s", error);

            return;

        }

    }



    new String:auth[19];

    GetClientAuthString(client, auth, sizeof(auth));

    Format(auth, sizeof(auth), "%c%s", '%', auth[8]);



    SQL_BindParamString(g_hStatement, 0, auth, true);



    if(!SQL_Execute(g_hStatement))

    {

        LogError("SQL_Execute fail");

        return;

    }



    if(!SQL_GetRowCount(g_hStatement))

    {

        new String:msg[256];

        GetConVarString(cvar, msg, sizeof(msg));

        KickClient(client, " \n %s \n ", msg);

    }

}





public Action:OnlineTimer_callback(Handle:timer, Handle:db)

{

    OnlineTimer = INVALID_HANDLE;



    if(!SQL_IsSameConnection(g_hDatabase, db))

    {

        LogError("Different database connections has happen!!! Note for Dev");

    }



    if(g_hStatement != INVALID_HANDLE)

    {

        CloseHandle(g_hStatement);

        g_hStatement = INVALID_HANDLE;

    }



    if(g_hDatabase != INVALID_HANDLE)

    {

        CloseHandle(g_hDatabase);

        g_hDatabase = INVALID_HANDLE;

    }



    return Plugin_Continue;

}

Thanks!

Will try i now!

wundeR · 11-21-2014 , 11:54 Re: [Request] Members only

Works perfectly!

Just one more thing, can u make a cvar for if admin are ignored or not & an chat message that the player tryed to connect but dont was an member?

Bacardi · 11-21-2014 , 17:14 Re: [Request] Members only

Quote:

Originally Posted by wundeR

Works perfectly!

Just one more thing, can u make a cvar for if admin are ignored or not & an chat message that the player tryed to connect but dont was an member?

Well yes I can make that kind of cvar...
What if I change admin access to "sm_membersonly_immunity" and it have flag to "z" (ROOT) ?
You can override that "sm_membersonly_immunity" to another flag(s) from admin_overrides.cfg
or even add only this one immunity to admin group through admin_groups.cfg overrides.
This will work as long as you not grant anyone with admin flag "z" (not even yourself

).

chat and log added with steamid showed

Spoiler

Code:

new Handle:g_hDatabase;
new Handle:g_hStatement;
new Handle:OnlineTimer;
new Handle:cvar_kick;

public OnPluginStart()
{
	cvar_kick = CreateConVar("sm_membersonly_kick_msg", "Members only!", "Kick message for non-members", FCVAR_PLUGIN);
}

public OnClientPostAdminCheck(client)
{
	// skip bots and admins who ahve access to admin menu
	if(IsFakeClient(client) || CheckCommandAccess(client, "sm_membersonly_immunity", ADMFLAG_ROOT))
	{
		return;
	}

	// Mysql connection has closed at this moment, re-connect
	if(g_hDatabase == INVALID_HANDLE)
	{
		new String:error[512];
		g_hDatabase = SQL_Connect("members only", true, error, sizeof(error));

		// Error to connect
		if(g_hDatabase == INVALID_HANDLE)
		{
			SetFailState("SQL_Connect fail: %s", error);
		}
	}

	// Reset timer
	if(OnlineTimer != INVALID_HANDLE)
	{
		KillTimer(OnlineTimer);
		OnlineTimer = INVALID_HANDLE;
	}

	OnlineTimer = CreateTimer(20.0, OnlineTimer_callback, g_hDatabase);

	if(g_hStatement == INVALID_HANDLE)
	{
		new String:error[512];
		g_hStatement = SQL_PrepareQuery(g_hDatabase, "SELECT steamid FROM members_only WHERE steamid LIKE ?", error, sizeof(error));

		if(g_hStatement == INVALID_HANDLE)
		{
			LogError("SQL_PrepareQuery fail: %s", error);
			return;
		}
	}

	new String:auth[19];
	GetClientAuthString(client, auth, sizeof(auth));
	Format(auth, sizeof(auth), "%c%s", '%', auth[8]);

	SQL_BindParamString(g_hStatement, 0, auth, true);

	if(!SQL_Execute(g_hStatement))
	{
		LogError("SQL_Execute fail");
		return;
	}

	if(!SQL_GetRowCount(g_hStatement))
	{
		new String:msg[256];
		GetConVarString(cvar_kick, msg, sizeof(msg));
		KickClient(client, " \n %s \n ", msg);
		LogMessage("Kicked: Nonmember %L tried to join in server", client);
		PrintToChatAll("[SM] Kicked: Nonmember %N (%s) tried to join in server", client, auth);
	}
}


public Action:OnlineTimer_callback(Handle:timer, Handle:db)
{
	OnlineTimer = INVALID_HANDLE;

	if(!SQL_IsSameConnection(g_hDatabase, db))
	{
		LogError("Different database connections has happen!!! Note for Dev");
	}

	if(g_hStatement != INVALID_HANDLE)
	{
		CloseHandle(g_hStatement);
		g_hStatement = INVALID_HANDLE;
	}

	if(g_hDatabase != INVALID_HANDLE)
	{
		CloseHandle(g_hDatabase);
		g_hDatabase = INVALID_HANDLE;
	}

	return Plugin_Continue;
}

wundeR · 11-21-2014 , 17:31 Re: [Request] Members only

Quote:

Originally Posted by Bacardi

Well yes I can make that kind of cvar...
What if I change admin access to "sm_membersonly_immunity" and it have flag to "z" (ROOT) ?
You can override that "sm_membersonly_immunity" to another flag(s) from admin_overrides.cfg
or even add only this one immunity to admin group through admin_groups.cfg overrides.
This will work as long as you not grant anyone with admin flag "z" (not even yourself

).

chat and log added with steamid showed

Spoiler

Code:

new Handle:g_hDatabase;
new Handle:g_hStatement;
new Handle:OnlineTimer;
new Handle:cvar_kick;

public OnPluginStart()
{
	cvar_kick = CreateConVar("sm_membersonly_kick_msg", "Members only!", "Kick message for non-members", FCVAR_PLUGIN);
}

public OnClientPostAdminCheck(client)
{
	// skip bots and admins who ahve access to admin menu
	if(IsFakeClient(client) || CheckCommandAccess(client, "sm_membersonly_immunity", ADMFLAG_ROOT))
	{
		return;
	}

	// Mysql connection has closed at this moment, re-connect
	if(g_hDatabase == INVALID_HANDLE)
	{
		new String:error[512];
		g_hDatabase = SQL_Connect("members only", true, error, sizeof(error));

		// Error to connect
		if(g_hDatabase == INVALID_HANDLE)
		{
			SetFailState("SQL_Connect fail: %s", error);
		}
	}

	// Reset timer
	if(OnlineTimer != INVALID_HANDLE)
	{
		KillTimer(OnlineTimer);
		OnlineTimer = INVALID_HANDLE;
	}

	OnlineTimer = CreateTimer(20.0, OnlineTimer_callback, g_hDatabase);

	if(g_hStatement == INVALID_HANDLE)
	{
		new String:error[512];
		g_hStatement = SQL_PrepareQuery(g_hDatabase, "SELECT steamid FROM members_only WHERE steamid LIKE ?", error, sizeof(error));

		if(g_hStatement == INVALID_HANDLE)
		{
			LogError("SQL_PrepareQuery fail: %s", error);
			return;
		}
	}

	new String:auth[19];
	GetClientAuthString(client, auth, sizeof(auth));
	Format(auth, sizeof(auth), "%c%s", '%', auth[8]);

	SQL_BindParamString(g_hStatement, 0, auth, true);

	if(!SQL_Execute(g_hStatement))
	{
		LogError("SQL_Execute fail");
		return;
	}

	if(!SQL_GetRowCount(g_hStatement))
	{
		new String:msg[256];
		GetConVarString(cvar_kick, msg, sizeof(msg));
		KickClient(client, " \n %s \n ", msg);
		LogMessage("Kicked: Nonmember %L tried to join in server", client);
		PrintToChatAll("[SM] Kicked: Nonmember %N (%s) tried to join in server", client, auth);
	}
}


public Action:OnlineTimer_callback(Handle:timer, Handle:db)
{
	OnlineTimer = INVALID_HANDLE;

	if(!SQL_IsSameConnection(g_hDatabase, db))
	{
		LogError("Different database connections has happen!!! Note for Dev");
	}

	if(g_hStatement != INVALID_HANDLE)
	{
		CloseHandle(g_hStatement);
		g_hStatement = INVALID_HANDLE;
	}

	if(g_hDatabase != INVALID_HANDLE)
	{
		CloseHandle(g_hDatabase);
		g_hDatabase = INVALID_HANDLE;
	}

	return Plugin_Continue;
}

Yes man, that will work good!

Thank you so much!

midnight9 · 02-28-2015 , 10:16 Re: [Request] Members only

Would it be possible to modify this, so it allows non members to connect as long as there is at least one member connected? It would need to do the check X time after connection, and check only once, so if member leaves game still can be continued untill server is empty. Im need something for L4D2, to prevent non members from forcing my servers.