[maks]

MySQL Stats for Left 4 Dead 2 (Co-op)

Requirements
• MySQL: External connections required if your MySQL server is not on the same system ! This is not enabled by default, you may need to contact your host!
• Metamod: Source/SourceMM (Latest Version)
• SourceMod: 1.10 - 1.12 Latest Build


Installation
• Edit your databases.cfg file and add a section with the following information:

PHP Code:

"l4d2_stats"
{ 
    "driver"              "mysql"
    "host"                "your_host"
    "database"            "your_db"
    "user"                "your_user"
    "pass"                "your_pass"
} 


• In the game console: sm_addsqlcreate


Chat Commands
• !rank - Display your current rank information.
• !top - Show Top 15 players.
-

[maks]

stats_web https://github.com/TyUser/l4d2_hx_stats

[mrtach]

while i am using your plugin i cant use votemenu. for example i cant change difficulty, when i press expert or whatever nothings happends.

nevermind i found the "problem"

public Action CMD_callvote(int client, int args)
{
	if (ig_real[client][HX_POINTS] > 500)
	{
		return Plugin_Continue;
	}

	return Plugin_Handled;
}

you should to add an cvar to enable or disable this or use flags, so admins don't need to reach 500 points to call vote

[maks]

public Action CMD_callvote(int client, int args)
{
	if (client)
	{
		if (ig_real[client][HX_POINTS] < 500)
		{
			int flags = GetAdminFlags(GetUserAdmin(client), Access_Effective);
			if (flags & ADMFLAG_VOTE || flags & ADMFLAG_CHANGEMAP || flags & ADMFLAG_ROOT)
			{
				return Plugin_Continue;
			}
			return Plugin_Handled;
		}
	}

	return Plugin_Continue;
}

[SherlockHolmes9]

Figure i should post this. When player reach 500 Points, they auto become blue. How do i disable this ? The blue is not annoying, i perfer red more to be honest but can we add like an option to either activate colour on/off via chat command or permanently disable this via plugin code ?

[Psyk0tik]

Originally Posted by SherlockHolmes9 Figure i should post this. When player reach 500 Points, they auto become blue. How do i disable this ? The blue is not annoying, i perfer red more to be honest but can we add like an option to either activate colour on/off via chat command or permanently disable this via plugin code ?

From lines 287 to 331:

PHP Code:

public int HxColorC(int &client, int iPoints)
{
    if (iPoints > 80000)
    {
        SetEntityRenderColor(client, 0, 0, 0, 252);
        return 8;
    }

    if (iPoints > 50000)
    {
        SetEntityRenderColor(client, 255, 51, 204, 255);
        return 7;
    }

    if (iPoints > 20000)
    {
        SetEntityRenderColor(client, 164, 79, 25, 255);
        return 6;
    }

    if (iPoints > 7000)
    {
        SetEntityRenderColor(client, 0, 153, 51, 255);
        return 5;
    }

    if (iPoints > 2000)
    {
        SetEntityRenderColor(client, 0, 51, 255, 255);
        return 4;
    }

    if (iPoints > 500)
    {
        SetEntityRenderColor(client, 0, 204, 255, 255);
        return 3;
    }

    if (iPoints > 20)
    {
        return 2;
    }

    return 1;
} 


[SherlockHolmes9]

Thank you for telling me that. I set the colour off now.

[L4D2Noob]

What could be the problem?
Php versions tried both 5 and 7.
I keep getting error 2.

[maks]

Change setting

[L4D2Noob]

The data from the database is registered correctly. And still I get "Error 2".