Page 718 of 720 FirstFirst ... 218618668708716717718719720 LastLast
Results 7,171 to 7,180 of 7191
  1. #7171
    Junior Member
    Join Date
    Feb 2014
    Location
    Russia, Moscow
    Posts
    29
    As I understand it, I can add a player by editing the date of his joining to the server.
    I not found date on tbl_playerdata table. Can you tell me in which table I can find it?

  2. #7172
    Quote Originally Posted by Timm View Post
    As I understand it, I can add a player by editing the date of his joining to the server.
    I not found date on tbl_playerdata table. Can you tell me in which table I can find it?
    Code:
    SELECT    tbl_playerstats .*
    FROM
    tbl_server_player
        INNER JOIN
    tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID
    WHERE
    tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'ColColonCleaner')
    ORDER BY 
    tbl_playerstats.FirstSeenOnServer
    LIMIT 1
    You can edit the FirstSeenOnServer value on this record for the player you want able to join. Just change my name to their name.

    The update query would be
    Code:
    update tbl_playerstats set FirstSeenOnServer = '2018-10-9' where StatsID = whateveryougotpreviously
    EDIT: Added tbl_playerstats table name to the select section.
    Last edited by ColColonCleaner; 21-10-2018 at 16:07.
    ____

  3. #7173
    Junior Member
    Join Date
    Feb 2014
    Location
    Russia, Moscow
    Posts
    29
    So, SQL request must next?
    Code:
    SELECT    *
    
    FROM
    
    tbl_server_player
    
        INNER JOIN
    
    tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID
    
    WHERE
    
    tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'Player1')
    
    ORDER BY
    
    tbl_playerstats set FirstSeenOnServer = '2018-10-9' where StatsID = whateveryougotpreviously
    
    LIMIT 1

  4. #7174
    No, run this to get his StatsID.

    Code:
    SELECT  tbl_playerstats .StatsID
    FROM
    tbl_server_player
        INNER JOIN
    tbl_playerstats ON tbl_playerstats.StatsID = tbl_server_player.StatsID
    WHERE
    tbl_server_player.PlayerID = (select PlayerID from tbl_playerdata where SoldierName = 'Player1')
    ORDER BY 
    tbl_playerstats.FirstSeenOnServer
    LIMIT 1
    Plug that StatsID into this query to update when he joined.

    Code:
    UPDATE tbl_playerstats SET FirstSeenOnServer = '2018-10-9' WHERE StatsID = 999999999
    ____

  5. #7175
    Junior Member
    Join Date
    Feb 2014
    Location
    Russia, Moscow
    Posts
    29
    Sorry, but it's not help.

    On BFACP player's page his first joined date changed, but player can't join to server.

  6. #7176
    Quote Originally Posted by Timm View Post
    Sorry, but it's not help.

    On BFACP player's page his first joined date changed, but player can't join to server.
    Problem 1: That data might be cached in AdKats memory. Try rebooting your procon layer and have them join again.

    Problem 2: It might be a timezone issue. The dates are shown in UTC time so perhaps make the date they joined a little further in the past. (the format of that date is year-month-day)

    If none of those work let me know.
    Last edited by ColColonCleaner; 21-10-2018 at 18:09.
    ____

  7. #7177
    Junior Member
    Join Date
    Feb 2014
    Location
    Russia, Moscow
    Posts
    29
    So, restarting layers helped.
    Looks like cached in Adkats memory, becuase i added 1 month.

    Thank you, it's work perfect now.

  8. #7178
    Quote Originally Posted by Timm View Post
    So, restarting layers helped.
    Looks like cached in Adkats memory, becuase i added 1 month.

    Thank you, it's work perfect now.
    Cool. Yeah it doesn't expect that data to change so I have it cached to avoid extra calls to the DB. I keep player objects in memory for 2 hours after they go offline.
    ____

  9. #7179
    Procon Addict
    Join Date
    Mar 2014
    Location
    Russia, Moscow
    Posts
    502
    Two people were banned with this cause.
    KPM Ban [LIVE][5-L25-27] What does L25 mean?

  10. #7180
    Quote Originally Posted by Hodor View Post
    Two people were banned with this cause.
    KPM Ban [LIVE][5-L25-27] What does L25 mean?
    5-L25-27

    There are two durations for the LIVE KPM auto ban, low and high, 60 seconds and 120 seconds respectively.
    L here means low, so looking at the past 60 seconds of gameplay. 25 means that's how many kills they need to get to trigger the script, changes based on a few metrics.

    Your player got 27 kills in 1 minute so the script banned him.
    ____

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •