Raised This Month: $12 Target: $400
 3% 

[ANY] MYSQL : Player Activity


Post New Thread Reply   
 
Thread Tools Display Modes
Author
Ilusion9
Veteran Member
Join Date: Jun 2018
Location: Romania
Plugin ID:
6352
Plugin Version:
Plugin Category:
General Purpose
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Display informations about the players activity on the server.
    Old 11-28-2018 , 07:05   [ANY] MYSQL : Player Activity
    Reply With Quote #1

    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
    __________________

    Last edited by Ilusion9; 02-09-2020 at 15:41.
    Ilusion9 is offline
    eyal282
    Veteran Member
    Join Date: Aug 2011
    Old 11-28-2018 , 10:36   Re: [ANY] MYSQL : Time played (on record and past 2 weeks)
    Reply With Quote #2

    How about just merge data from above a month?
    __________________
    I am available to make plugins for pay.

    Discord: Eyal282#1334
    eyal282 is offline
    Ilusion9
    Veteran Member
    Join Date: Jun 2018
    Location: Romania
    Old 11-29-2018 , 07:15   Re: [ANY] MYSQL : Time played (on record and past 2 weeks)
    Reply With Quote #3

    Quote:
    Originally Posted by eyal282 View Post
    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.
    __________________

    Last edited by Ilusion9; 11-29-2018 at 07:24.
    Ilusion9 is offline
    Bara
    AlliedModders Donor
    Join Date: Apr 2012
    Location: Germany
    Old 11-29-2018 , 08:04   Re: [ANY] MYSQL : Time played (on record and past 2 weeks)
    Reply With Quote #4

    What is facebook? Never saw or used it. Can i eat it?
    __________________
    Discord (Bara#5006) | My Plugins (GitHub)
    You like my work? Support is not a crime.
    Bara is offline
    Ilusion9
    Veteran Member
    Join Date: Jun 2018
    Location: Romania
    Old 12-06-2018 , 10:44   Re: [ANY] MYSQL : Time played
    Reply With Quote #5

    Update:

    Added timeplayed_default and timeplayed_month.
    Added translations.
    __________________
    Ilusion9 is offline
    September
    Senior Member
    Join Date: Jul 2015
    Location: Russian Federation
    Old 12-07-2018 , 06:53   Re: [ANY] MYSQL : Time played
    Reply With Quote #6

    Quote:
    Originally Posted by Ilusion9 View Post
    Update:

    Added timeplayed_default and timeplayed_month.
    Added translations.
    Maybe add a web interface?
    September is offline
    Send a message via Skype™ to September
    Ilusion9
    Veteran Member
    Join Date: Jun 2018
    Location: Romania
    Old 01-21-2019 , 06:56   Re: [ANY] MYSQL : Time played
    Reply With Quote #7

    Updated: Added the GetClientMapTime function.

    Quote:
    Originally Posted by September View Post
    Maybe add a web interface?
    I can do that.
    __________________
    Ilusion9 is offline
    Ilusion9
    Veteran Member
    Join Date: Jun 2018
    Location: Romania
    Old 02-09-2019 , 09:38   Re: [ANY] MYSQL : Time played
    Reply With Quote #8

    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.
    __________________

    Last edited by Ilusion9; 02-09-2019 at 09:42.
    Ilusion9 is offline
    alphaearth
    Senior Member
    Join Date: Feb 2018
    Location: Turkey
    Old 03-18-2019 , 14:32   Re: [ANY] MYSQL : Time played
    Reply With Quote #9

    PHP Code:
    "time"
    {
        
    "driver"        "sqlite"
        "database"        "time"


    does the plugin use sql? as above.
    __________________
    alphaearth is offline
    Ilusion9
    Veteran Member
    Join Date: Jun 2018
    Location: Romania
    Old 03-22-2019 , 07:44   Re: [ANY] MYSQL : Time played
    Reply With Quote #10

    Quote:
    Originally Posted by alphaearth View Post
    PHP Code:
    "time"
    {
        
    "driver"        "sqlite"
        "database"        "time"


    does the plugin use sql? as above.
    no, only mysql.
    __________________
    Ilusion9 is offline
    Reply


    Thread Tools
    Display Modes

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off

    Forum Jump


    All times are GMT -4. The time now is 19:35.


    Powered by vBulletin®
    Copyright ©2000 - 2024, vBulletin Solutions, Inc.
    Theme made by Freecode