Save online time per player.

#include <a_samp>
#include <a_mysql> // R38+
#include <zcmd>
#include <foreach>

enum Players
{
    Name,
    Time1, // Ore
    Time2, // Minute
    Time3 // Secunde
}
new Player[MAX_PLAYERS][Players]; new cH;
forward OnPlayerLevel();

stock CheckOnlineTime(playerid)
{
    new query[128], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, 32);
    format(query, sizeof(query), "SELECT * FROM `levels`");
    mysql_query(cH, query);
    Player[playerid][Time1] = cache_get_field_content_int(0, "Ore");
    Player[playerid][Time2] = cache_get_field_content_int(0, "Minute");
    Player[playerid][Time3] = cache_get_field_content_int(0, "Secunde");
    printf("%s has recivied a %i ore, %i minute, %i secounde time.", pName, Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3]);
    return 1;
}

public OnPlayerLevel()
{
    foreach(Player, i)
    {
        if(IsPlayerConnected(i))
        {
            Player[i][Time3] += 1; // Update Time in secounds.

            if(Player[i][Time3] == 60)
            {
                Player[i][Time3] = 0;
                Player[i][Time2] += 1;
            }

            if(Player[i][Time2] == 60)
            {
                Player[i][Time3] = 0;
                Player[i][Time2] = 0;
                Player[i][Time1] += 1;
            }
        }
    }
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query[128], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, 32);
    format(query, sizeof(query), "SELECT * FROM `levels`");
    mysql_query(cH, query);
    CheckOnlineTime(playerid);
    SetTimer("OnPlayerLevel", 1000, true);
    return 1;
}

public OnPlayerDisconnect(playerid)
{
    new query[256], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, 32);
    format(query, sizeof(query), "UPDATE `levels` SET `Ore`='%i',`Minute`='%i',`Secunde`='%i' WHERE `Name`='%s'", Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3], pName);
    mysql_query(cH, query); // 1 = conectionHandle
    return 1;
}

public OnFilterScriptInit()
{
    print("\n--------------------------------------");
    print("Load mysql level time system by sRk7.");
    print("-------------------------------------\n");
    cH = mysql_connect("127.0.0.1", "root", "tutorial", "", 3306, true, 2);
    return 1;
}

CMD:mytime(playerid, params[])
{
    new time[128];
    format(time, 128, "Ai: %i ore %i minute %i secunde", Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3]);
    SendClientMessage(playerid, -1, time);
    return 1;
}