AlliedModders - [ANY] MYSQL : Player Activity

Page 1 of 2

Show 40 post(s) from this thread on one page

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - [ANY] MYSQL : Player Activity (https://forums.alliedmods.net/showthread.php?t=312352)

Ilusion9

11-28-2018 07:05

[ANY] MYSQL : Player Activity

Description: This plugin will display informations about the players activity on the server.

Database configuration:

PHP Code:


		
			


    "playeractivity"

    {

        "driver"            "mysql"

        "host"                ""

        "database"            ""

        "user"                ""

        "pass"                ""

        //"timeout"            "0"

        //"port"            "0"

    }

Commands:

Code:

sm_activity - will show the player's activity on the server

sm_activityof <steamid> - show this steamid's activity on the server

Output example:

Code:

Activity

22 hours - past month

154 hours - total

GitHub: https://github.com/Ilusion9/player-activity-sm
Forwards and natives: https://github.com/Ilusion9/player-a...ds-and-natives

eyal282

11-28-2018 10:36

Re: [ANY] MYSQL : Time played (on record and past 2 weeks)

How about just merge data from above a month?

Ilusion9

11-29-2018 07:15

Re: [ANY] MYSQL : Time played (on record and past 2 weeks)

Quote:

Originally Posted by eyal282 (Post 2625978)

How about just merge data from above a month?

1mb per 10000 rows, in a world where facebook has trillions of data, I think you should provide your server more free space for it.
You can delete older data if you wish, but with this plugin you can develop further informations.

And of course, you can run queries to merge old data.

Bara	11-29-2018 08:04

Re: [ANY] MYSQL : Time played (on record and past 2 weeks)

What is facebook? Never saw or used it. Can i eat it?

Ilusion9

12-06-2018 10:44

Re: [ANY] MYSQL : Time played

Update:

Added timeplayed_default and timeplayed_month.
Added translations.

September

12-07-2018 06:53

Re: [ANY] MYSQL : Time played

Quote:

Originally Posted by Ilusion9 (Post 2626988)

Update:

Added timeplayed_default and timeplayed_month.
Added translations.

Maybe add a web interface?

Ilusion9

01-21-2019 06:56

Re: [ANY] MYSQL : Time played

Updated: Added the GetClientMapTime function.

Quote:

Originally Posted by September (Post 2627199)

Maybe add a web interface?

I can do that.

Ilusion9

02-09-2019 09:38

Re: [ANY] MYSQL : Time played

Updated: version 2.0

This plugin will display the total time and the past 2 weeks (exactly how steam does).
This plugin will save the data by days. Data older than 2 weeks will be merged into a single row.

The minimum value of "date" column its the join date of players. If someone wants to display this as well, I can do it easily.

alphaearth

03-18-2019 14:32

Re: [ANY] MYSQL : Time played

PHP Code:


		
			
"time"

{

    "driver"        "sqlite"

    "database"        "time"

}

does the plugin use sql? as above.

Ilusion9

03-22-2019 07:44

Re: [ANY] MYSQL : Time played

Quote:

Originally Posted by alphaearth (Post 2643936)

PHP Code:


		
			
"time"

{

    "driver"        "sqlite"

    "database"        "time"

}

does the plugin use sql? as above.

no, only mysql.

All times are GMT -4. The time now is 13:03.

Page 1 of 2

Show 40 post(s) from this thread on one page