[Bacardi]

This have been mention before... I mention it again.
SQL or clientprefs - Store Times

Originally Posted by asherkin Don't use clientprefs for things that are not client preferences.

So note to new plugin developers, this is bad example.

Originally Posted by Arkarr Not tested, but should work ;) ! PHP Code: #include <sourcemod> #include <sdktools> #include <clientprefs> #include <multicolors> #define PLUGIN_AUTHOR "Arkarr" #define PLUGIN_VERSION "1.00" Handle COOKIE_playtime = INVALID_HANDLE; int seconds[MAXPLAYERS+1]; public Plugin myinfo =  {     name = "[ANY] Playtime",     author = PLUGIN_AUTHOR,     description = "Show how much time a player spent time on the server.",     version = PLUGIN_VERSION,     url = "http://www.sourcemod.net" }; public void OnPluginStart() {     COOKIE_playtime = RegClientCookie("sm_playetime_seconds", "Store the number of seconds spent on the server.", CookieAccess_Private);     CreateTimer(1.0, TMR_IncreaseSeconds, _, TIMER_REPEAT|TIMER_FLAG_NO_MAPCHANGE);          RegConsoleCmd("sm_playtime", CMD_PlayeTime, "Display the time played in the server.");          for(new i = MaxClients; i > 0; --i)     {         if(!AreClientCookiesCached(i))             continue;                      OnClientCookiesCached(i);     } } public void OnClientCookiesCached(int client) {     char cookieValue[10];     GetClientCookie(client, COOKIE_playtime, cookieValue, sizeof(cookieValue));     seconds[client] = StringToInt(cookieValue); } public Action CMD_PlayeTime(int client, int args) {     if(client == 0)         return Plugin_Handled;          int houres = 0;     int minutes = seconds[client] / 60;          while(minutes > 60)     {         houres++;         minutes -= 60;             }          CPrintToChatAll("{green}%N{default} played %i houres and %i minutes in this server !", client, houres, minutes);              return Plugin_Handled; } public void OnClientDisconnect(client) {     char cookieValue[10];     IntToString(seconds[client], cookieValue, sizeof(cookieValue));     SetClientCookie(client, COOKIE_playtime, cookieValue);     } public Action TMR_IncreaseSeconds(Handle timer) {     for(new i = MaxClients; i > 0; --i)     {         if(IsValidClient(i))         {             seconds[i]++;         }     } }      stock bool IsValidClient(client) {     if(client <= 0 ) return false;     if(client > MaxClients) return false;     if(!IsClientConnected(client)) return false;     return IsClientInGame(client); }  Donate if you enjoy my work !

[Arkarr]

Oh. Well... Thanks for pointing this out. I didn't know it. Although it doesn't sounds bad to me. Why would you setup a database just for this kind of things ? Should I have used text file instead ? This sounds even worse. Somebody could help me ?

[Bacardi]

...you can also use already exist database. Just create new table.

Originally Posted by Arkarr Oh. Well... Thanks for pointing this out. I didn't know it. Although it doesn't sounds bad to me. Why would you setup a database just for this kind of things ? Should I have used text file instead ? This sounds even worse. Somebody could help me ?

[Advanced Deal]

So I get this when trying to compile.

[Arkarr]

Originally Posted by Bacardi ...you can also use already exist database. Just create new table.

I don't think hijacking database is a good practice either. I will search for a better solution... But right now, it looks like we have to create a 'general' database to store some values from different plugins ? Doesn't looks good to me.

Originally Posted by Advanced Deal So I get this when trying to compile.

Don't use my plugin, it's considered as bad.

[Bacardi]

...it's not hijacking if database locate in your server files or is your "property" in mysql host. And as long as you create unique table name then it's allright.


Here example, I tried make it work so it use temporary connections to local database (Sourcemod SQLite only).
Maybe either not perfect example but works somehow.

...dam, can't post source code. Cloud system give block

here *.sp

updated
added server command to clear database table
sm_playtime_empty_table