[cristian20042]

Plugin Description :

I made a plugin that shows your played time on a server or another player's played time.

Plugin Commands :

sm_playedtime - It's showing the time you played on the server.
sm_time - Shortcut number 2.
sm_hours - Shortcut number 3.
sm_gettime - Shows you someone's played time. (ADMFLAG_SLAY)

Changelogs :

- 2.0.1 - Few changes

- Minor fixes
- Minor improvements.

- 2.0.0 - BIG UPDATE

- The plugin now uses MySQL.
- I made the script more reading frendly.
- Fixed a lot of bugs.
- Added the command !gettime
- ENJOY!

- 1.0.0 - RELEASE

- The release.

IF THERE IS ANY BUG OR YOU HAVE SOME IDEAS TO ADD LEAVE A REPLY !

Don't forget to check out my other plugin: https://forums.alliedmods.net/showth...66#post2471466

[PinHeaDi]

How can I remove(reset) someones time without "rcon exit" or restart?

[shanapu]

IIRC, KeyValues should not be used to store player data.

https://wiki.alliedmods.net/KeyValue...eMod_Scripting)

Note: While the following examples are correct code-wise, over the years they have occasionally led people to use KeyValues in cases where they really should be using a database instead.

[cristian20042]

Originally Posted by shanapu IIRC, KeyValues should not be used to store player data. https://wiki.alliedmods.net/KeyValue...eMod_Scripting)

Yes , i know, but here is a simple method that i used... If i want to make it with a database it's very hard...

[ddhoward]

On really popular servers, this is going to cause problems. Every time a player joins or leaves, you load the ENTIRE file into memory, re-saving the entire file on disconnects. This is going to cause insane lag.

If an SQL database isn't what you want to set up, then at least use Clientprefs... Even that's not intended use, but it's better than KV.

[cristian20042]

BIG UPDATE!

Check up!

[shanapu]

#define SniperH_Stock stock
#define _SniperH_In_Out_ 
#define _SniperH_In_ 
#define _SniperH_Out_

what the heck?

edit:

Spoiler

a rough clean up. there are still some things to optimize

PHP Code:

#pragma semicolon 1
#pragma newdecls required

#include <sourcemod>

#define CHAT_PREFIX "[SM]"
#define PLUGIN_VERSION "2.0.1"

Handle g_DB = INVALID_HANDLE;
char g_Error[PLATFORM_MAX_PATH];
char g_Query[PLATFORM_MAX_PATH];
char g_sUserSteamId[MAXPLAYERS+1][PLATFORM_MAX_PATH];

Handle ClientTimer[MAXPLAYERS+1];
int Minutes[MAXPLAYERS+1];

public Plugin myinfo = {
    name = "Played Time",
    author = "SniperHero / cristian20042",
    description = "It's showing the played time on the server.",
    version = PLUGIN_VERSION,
    url = "https://forums.alliedmods.net/showthread.php?p=2523586"
};

public void OnPluginStart()
{
    CreateConVar("sm_playtime_version", PLUGIN_VERSION, "Plugin version");
    RegConsoleCmd("sm_time", Command_showTime, "Shows your played time.");
    RegConsoleCmd("sm_playedtime", Command_showTime, "Shows your played time.");
    RegConsoleCmd("sm_hours", Command_showTime, "Shows your played time.");
    RegAdminCmd("sm_gettime", Command_getTime, ADMFLAG_SLAY, "Gets a player's played time.");

    if(g_DB == INVALID_HANDLE)
        g_DB = SQL_Connect ("default", false, g_Error, sizeof (g_Error));

    if(g_DB == INVALID_HANDLE)
    {
        SetFailState ("Can't reach the database.");
        return;
    }

    FormatEx (g_Query, sizeof (g_Query), "CREATE TABLE IF NOT EXISTS PlayTime (SteamID varchar(128) PRIMARY KEY, mins int(11) DEFAULT 0);");
    SQL_Query (g_DB, g_Query);

    SQL_SetCharset (g_DB, "utf8");
}

public void OnClientPutInServer(int client)
{
    if (IsValidClient(client))
    {
        if(!GetClientAuthId(client, AuthId_Engine, g_sUserSteamId[client], sizeof(g_sUserSteamId), true)) //always check for valid return
            return;

        FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);
        SQL_TQuery (g_DB, LoadPlayerData, g_Query, client);
    }

    ClientTimer[client] = (CreateTimer(60.0, TimerAdd, client, TIMER_REPEAT));
}

void LoadPlayerData (Handle pDb, Handle pQuery, char[] Error, any Data)
{
    static int Id, RowsCount;

    RowsCount = 0;
    Id = view_as<int>(Data);

    if (strlen(Error) > 0)
        LogError("SQL_TQuery() @ LoadPlayerData() reported: %s", Error);

    else if (IsValidClient(Id))
    {
        
        if (SQL_HasResultSet(pQuery))
            RowsCount = SQL_HasResultSet(pQuery) ? SQL_GetRowCount(pQuery) : 0;

        switch (RowsCount)
        {
            case 0:
            {
                FormatEx (g_Query, sizeof (g_Query), "INSERT INTO `PlayTime`(`SteamID`) VALUES ('%s')", g_sUserSteamId [ Id ]);
                SQL_Query (g_DB, g_Query);
            }

            default:
            {
                SQL_FetchRow (pQuery);

                Minutes[Id] = SQL_FetchInt (pQuery, 0);
            }
        }
        CloseHandle (pDb);
    }
}

public void OnClientDisconnect(int client)
{
    CloseHandle(ClientTimer[client]);
    SaveTime(client);
}

public Action TimerAdd(Handle timer, int client)
{
    if(IsClientConnected(client) && IsClientInGame(client))
    {
        Minutes[client]++;
        SaveTime(client);
    }
}

public Action Command_showTime(int client, int args)
{
    static char totalTime[PLATFORM_MAX_PATH];

    FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);
    SQL_TQuery (g_DB, LoadPlayerData, g_Query, client);

    SniperH_GetTimeStringMinutes(Minutes[client], totalTime, sizeof(totalTime));
    PrintToChat(client, "\x04%s \x01Played Time: \x04%s\x01.", CHAT_PREFIX, totalTime);
    return Plugin_Handled; 
}

public Action Command_getTime(int client, int args)
{
    if (args < 1)
    {
        PrintToChat(client, "%s Usage: \x04!gettime \x02<target>", CHAT_PREFIX);
        return Plugin_Handled;
    }

    char szTarget[64];
    GetCmdArg(1, szTarget, sizeof(szTarget));

    int target = FindTarget(client, szTarget, true, false);

    static char totalTime[PLATFORM_MAX_PATH];

    FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);
    SQL_TQuery (g_DB, LoadPlayerData, g_Query, target);

    SniperH_GetTimeStringMinutes(Minutes[target], totalTime, sizeof(totalTime));
    PrintToChat(client, "\x04%s \x01This player played: \x04%s\x01.", CHAT_PREFIX, totalTime);
    return Plugin_Handled; 
}

void SaveTime(int client)
{
    FormatEx (g_Query, sizeof (g_Query), "UPDATE `PlayTime` SET `mins` = '%d' WHERE `SteamID` = '%s'", Minutes[client], g_sUserSteamId [ client ]);
    SQL_Query (g_DB, g_Query);
}

/* Fancy Stuff * Do NOT touch unless you know what you are doing! */

int SniperH_GetTimeStringMinutes(int Mins, char[] Output, int Size)
{
    static int m_Hours, m_Mins;

    m_Hours = 0;
    m_Mins = SniperH_AbsInt(Mins);

    if (m_Mins == 0)
        return FormatEx(Output, Size, "0 minutes");

    while (m_Mins >= 60)
    {
        m_Hours++;

        m_Mins -= 60;
    }

    if (m_Hours > 0)
    {
        if (m_Mins > 0)
            return FormatEx(Output, Size, "%d hours %d minutes", m_Hours, m_Mins);

        return FormatEx(Output, Size, "%d hours", m_Hours);
    }

    return FormatEx(Output, Size, "%d minutes", m_Mins);
}

int SniperH_AbsInt(int Value = 0)
{
    return Value >= 0 ? Value : -Value;
}

bool IsValidClient(int client)
{
    if (!(1 <= client <= MaxClients) || !IsClientInGame (client) || IsFakeClient(client))
        return false;

    return true;
} 


[cristian20042]

Originally Posted by shanapu #define SniperH_Stock stock #define _SniperH_In_Out_ #define _SniperH_In_ #define _SniperH_Out_ what the heck? edit: Spoiler a rough clean up. there are still some things to optimize PHP Code: #pragma semicolon 1 #pragma newdecls required #include <sourcemod> #define CHAT_PREFIX "[SM]" #define PLUGIN_VERSION "2.0.1" Handle g_DB = INVALID_HANDLE; char g_Error[PLATFORM_MAX_PATH]; char g_Query[PLATFORM_MAX_PATH]; char g_sUserSteamId[MAXPLAYERS+1][PLATFORM_MAX_PATH]; Handle ClientTimer[MAXPLAYERS+1]; int Minutes[MAXPLAYERS+1]; public Plugin myinfo = {     name = "Played Time",     author = "SniperHero / cristian20042",     description = "It's showing the played time on the server.",     version = PLUGIN_VERSION,     url = "https://forums.alliedmods.net/showthread.php?p=2523586" }; public void OnPluginStart() {     CreateConVar("sm_playtime_version", PLUGIN_VERSION, "Plugin version");     RegConsoleCmd("sm_time", Command_showTime, "Shows your played time.");     RegConsoleCmd("sm_playedtime", Command_showTime, "Shows your played time.");     RegConsoleCmd("sm_hours", Command_showTime, "Shows your played time.");     RegAdminCmd("sm_gettime", Command_getTime, ADMFLAG_SLAY, "Gets a player's played time.");     if(g_DB == INVALID_HANDLE)         g_DB = SQL_Connect ("default", false, g_Error, sizeof (g_Error));     if(g_DB == INVALID_HANDLE)     {         SetFailState ("Can't reach the database.");         return;     }     FormatEx (g_Query, sizeof (g_Query), "CREATE TABLE IF NOT EXISTS PlayTime (SteamID varchar(128) PRIMARY KEY, mins int(11) DEFAULT 0);");     SQL_Query (g_DB, g_Query);     SQL_SetCharset (g_DB, "utf8"); } public void OnClientPutInServer(int client) {     if (IsValidClient(client))     {         if(!GetClientAuthId(client, AuthId_Engine, g_sUserSteamId[client], sizeof(g_sUserSteamId), true)) //always check for valid return             return;         FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);         SQL_TQuery (g_DB, LoadPlayerData, g_Query, client);     }     ClientTimer[client] = (CreateTimer(60.0, TimerAdd, client, TIMER_REPEAT)); } void LoadPlayerData (Handle pDb, Handle pQuery, char[] Error, any Data) {     static int Id, RowsCount;     RowsCount = 0;     Id = view_as<int>(Data);     if (strlen(Error) > 0)         LogError("SQL_TQuery() @ LoadPlayerData() reported: %s", Error);     else if (IsValidClient(Id))     {                  if (SQL_HasResultSet(pQuery))             RowsCount = SQL_HasResultSet(pQuery) ? SQL_GetRowCount(pQuery) : 0;         switch (RowsCount)         {             case 0:             {                 FormatEx (g_Query, sizeof (g_Query), "INSERT INTO `PlayTime`(`SteamID`) VALUES ('%s')", g_sUserSteamId [ Id ]);                 SQL_Query (g_DB, g_Query);             }             default:             {                 SQL_FetchRow (pQuery);                 Minutes[Id] = SQL_FetchInt (pQuery, 0);             }         }         CloseHandle (pDb);     } } public void OnClientDisconnect(int client) {     CloseHandle(ClientTimer[client]);     SaveTime(client); } public Action TimerAdd(Handle timer, int client) {     if(IsClientConnected(client) && IsClientInGame(client))     {         Minutes[client]++;         SaveTime(client);     } } public Action Command_showTime(int client, int args) {     static char totalTime[PLATFORM_MAX_PATH];     FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);     SQL_TQuery (g_DB, LoadPlayerData, g_Query, client);     SniperH_GetTimeStringMinutes(Minutes[client], totalTime, sizeof(totalTime));     PrintToChat(client, "\x04%s \x01Played Time: \x04%s\x01.", CHAT_PREFIX, totalTime);     return Plugin_Handled;  } public Action Command_getTime(int client, int args) {     if (args < 1)     {         PrintToChat(client, "%s Usage: \x04!gettime \x02<target>", CHAT_PREFIX);         return Plugin_Handled;     }     char szTarget[64];     GetCmdArg(1, szTarget, sizeof(szTarget));     int target = FindTarget(client, szTarget, true, false);     static char totalTime[PLATFORM_MAX_PATH];     FormatEx (g_Query, sizeof (g_Query), "SELECT mins FROM PlayTime WHERE SteamID = '%s' LIMIT 1;", g_sUserSteamId [ client ]);     SQL_TQuery (g_DB, LoadPlayerData, g_Query, target);     SniperH_GetTimeStringMinutes(Minutes[target], totalTime, sizeof(totalTime));     PrintToChat(client, "\x04%s \x01This player played: \x04%s\x01.", CHAT_PREFIX, totalTime);     return Plugin_Handled;  } void SaveTime(int client) {     FormatEx (g_Query, sizeof (g_Query), "UPDATE `PlayTime` SET `mins` = '%d' WHERE `SteamID` = '%s'", Minutes[client], g_sUserSteamId [ client ]);     SQL_Query (g_DB, g_Query); } /* Fancy Stuff * Do NOT touch unless you know what you are doing! */ int SniperH_GetTimeStringMinutes(int Mins, char[] Output, int Size) {     static int m_Hours, m_Mins;     m_Hours = 0;     m_Mins = SniperH_AbsInt(Mins);     if (m_Mins == 0)         return FormatEx(Output, Size, "0 minutes");     while (m_Mins >= 60)     {         m_Hours++;         m_Mins -= 60;     }     if (m_Hours > 0)     {         if (m_Mins > 0)             return FormatEx(Output, Size, "%d hours %d minutes", m_Hours, m_Mins);         return FormatEx(Output, Size, "%d hours", m_Hours);     }     return FormatEx(Output, Size, "%d minutes", m_Mins); } int SniperH_AbsInt(int Value = 0) {     return Value >= 0 ? Value : -Value; } bool IsValidClient(int client) {     if (!(1 <= client <= MaxClients) || !IsClientInGame (client) || IsFakeClient(client))         return false;     return true; }

Well, thanks

[axelnieves2012]

L 06/23/2020 - 00:55:41: SourceMod error session started
L 06/23/2020 - 00:55:41: Info (map "l4d_hospital01_apartment") (file "D:\Steam\steamapps\common\Left 4 Dead Dedicated Server\left4dead\addons\sourcemod\logs\errors _20200623.log")
L 06/23/2020 - 00:55:41: [SM] Exception reported: Can't reach the database.
L 06/23/2020 - 00:55:41: [SM] Blaming: testing\timeplayed.smx
L 06/23/2020 - 00:55:41: [SM] Call stack trace:
L 06/23/2020 - 00:55:41: [SM] [0] SetFailState
L 06/23/2020 - 00:55:41: [SM] [1] Line 38, /home/forums/content/files/2/7/1/0/3/5/170741.attach::OnPluginStart

[fkr]

Originally Posted by cristian20042 Plugin Description : I made a plugin that shows your played time on a server or another player's played time. Plugin Commands : sm_playedtime - It's showing the time you played on the server. sm_time - Shortcut number 2. sm_hours - Shortcut number 3. sm_gettime - Shows you someone's played time. (ADMFLAG_SLAY) Changelogs : - 2.0.1 - Few changes - Minor fixes - Minor improvements. - 2.0.0 - BIG UPDATE - The plugin now uses MySQL. - I made the script more reading frendly. - Fixed a lot of bugs. - Added the command !gettime - ENJOY! - 1.0.0 - RELEASE - The release. IF THERE IS ANY BUG OR YOU HAVE SOME IDEAS TO ADD LEAVE A REPLY ! Don't forget to check out my other plugin: https://forums.alliedmods.net/showth...66#post2471466

Hello cristian20042,

Is the database connection added to: /addons/sourcemod/configs/databases.cfg ?

Thank you,
Cristian