[CamerDisco]

Description:
This plugin is saving player headshots in database. You can use it for making some events on your community.Plugin is in the new syntax and with translations. I can add some other cvars if you need.

Required:
-MySQL connection

Commands:
sm_myhs - it shows your count of headshots

Cvars:
sm_hsevent_on 1 - on/off the plugin
sm_hsevent_info_after_kill 1 - display info to client about new headshot after kill
sm_hsevent_savetime 300.0 - as much time save headshots in database
sm_hsevent_minplayers 2 - Amount of players who must be in the server to count headshots
sm_hsevent_advert 1 - on/off advert about event
sm_hsevent_time_advert 360.0 -time in float between adverts

Installing:
Put the files on the server and add to /addons/sourcemod/configs/databases.cfg new config:

PHP Code:

    "hsevent"
    {
        "driver"            "mysql"
        "host"                "address"
        "database"            "name of database"
        "user"                "login"
        "pass"                "password"
    } 


Additionally I'm sharing a website with statistics, you can see example on: http://sklep.max-play.pl/event

Changes:
- Fixed online statistics.

[leetgamer]

have some problems cant get this working i get only 500 error

[CamerDisco]

Plugin is working correctly? Database is connected? On website files you must put database connection too (dbconnect.php)

[leetgamer]

i put my MySQL server info into dbconnect.php havnt loaded plugin on server but i was thinking teh webend wuild still load without error tough ? https://recess.no/stats/

[CamerDisco]

Try load plugin, plugin is creating tables in the database. You don't have created tables and site won't work.

[leetgamer]

loaded plugin and have created table on MySQL and stats are gatehring there but website part still 500 error i think you got a code error there me personaly have newer seen this in code

if ($ile>=1)
{
echo<<<END
END;
}

[CamerDisco]

Oh yes, my mistake, I uploaded a good version in first post.

[leetgamer]

btw you have forgot to put style.css in webfolder but i just colected style from Your event demo site so i got everything runing just wanted to tel you

[CamerDisco]

Someone asked me about add a counting zeus kills!
It's possible, only you have to change:

PHP Code:

    if(GetPlayerCount() >= minplayers.IntValue)
    {
        bool headshot = GetEventBool(event, "headshot");

        if(headshot) 
        {
            if(loaded[client])
            {
                count[client]++;
                
                if(turn_info_after_kill.IntValue>0)
                {
                    CPrintToChat(client, "%T", "new headshot info", LANG_SERVER, count[client]);
                }
            }
            else PrintToChat(client, "error: 5");
        }
    } 


for:

PHP Code:

    if(GetPlayerCount() >= minplayers.IntValue)
    {
        char weaponname[128];
        GetEventString(event, weapon, weaponname, sizeof(weaponname));
        
        if(StrContains(weaponname, "weapon_taser" != -1) 
        {
            if(loaded[client])
            {
                count[client]++;
                
                if(turn_info_after_kill.IntValue>0)
                {
                    CPrintToChat(client, "%T", "new headshot info", LANG_SERVER, count[client]);
                }
            }
        }
    }