[sneaK]

I'm aware there are already a couple "time played" plugins, but I was looking to consolidate and use my existing player analytics databases.

Basically I'm requesting a plugin that when a player types !timeplayed they get their total time played in hours and minutes. The plugin would only read from the current databases, not write, dr mckay's plugin would still do all that work.

Dr McKay's Player Analytics plugin

If necessary I can provide a sample database as well. Game specifically I'm looking for is CS:GO, but can be for any I'm sure

[Arkarr]

I bet I can do that. Gimme a few houres, no PC acces right now.

[sneaK]

Originally Posted by Arkarr I bet I can do that. Gimme a few houres, no PC acces right now.

Thanks, that'd be great!

[OSWO]

Mind providing the column name of time played? Or how is it arranged? Does every new connection from the player create a new entry, or does it keep updating as steamID is the primary key?

Mind running this query through phpmyadmin?

"SELECT * FROM `table_name` WHERE auth = 'your authid'";

[sneaK]

Here is a partial screenshot of the database (with personal info blocked, of course):



Every new connection from the player creates a new entry, the primary key is ID. I did a sample export of a couple rows in my player analytics database, here's the pastebin: http://pastebin.com/5BqU1RH0

I guess the plugin would need to find all entries for the player's auth and add the duration together, and spit it out in a legible format.

[OSWO]

"SELECT SUM(duration) AS total FROM `table_name` WHERE auth = '%s'", yourauthid);

Hook that into a TQuery on when the command is run, then format the seconds.

PHP Code:

if (SQL_FetchRow(hndl)) {
    int I_Months, I_Weeks, I_Days, I_Hours, I_Minutes, I_Seconds;
    I_Seconds = SQL_FetchInt(hndl, 0);

    //Formating Seconds > Months ... etc

    //Months
    if (I_Seconds >= 2628000) {
        I_Months = RoundToFloor(I_Seconds / 2628000.0);
        I_Seconds = I_Seconds % 2628000;
    }

    //Weeks
    if (I_Seconds >= 604800) {
        I_Weeks = RoundToFloor(I_Seconds / 604800.0);
        I_Seconds = I_Seconds % 604800;
    }

    //Days
    if (I_Seconds >= 86400) {
        I_Days = RoundToFloor(I_Seconds / 86400.0);
        I_Seconds = I_Seconds % 86400;
    }

    //Hours
    if (I_Seconds >= 3600) {
        I_Hours = RoundToFloor(I_Seconds / 3600.0);
        I_Seconds = I_Seconds % 3600;
    }

    //Minutes
    if (I_Seconds >= 60) {
        I_Minutes = RoundToFloor(I_Seconds / 60.0);
        I_Seconds = I_Seconds % 60;
    }
} 


Messy code but I think you know what to do.

[sneaK]

Originally Posted by OSWO "SELECT SUM(duration) AS total FROM `table_name` WHERE auth = '%s'", yourauthid); Hook that into a TQuery on when the command is run, then format the seconds.

Interesting, anyone able to do this?

[AeroAcrobat]

Any news on this?

[Arkarr]

Oh wow... haha... I guess I forgot this thread. I'll see what I can do.

[Deathknife]

Try this. Uses mysql config 'timeplayed'

EDIT:
You might want to use the following: https://forums.alliedmods.net/showpo...6&postcount=17
Won't show invalid command in console anymore https://forums.alliedmods.net/showpo...1&postcount=18