Page 718 of 718 FirstFirst ... 218618668708716717718
Results 7,171 to 7,178 of 7178
  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 15: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 17: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.
    ____

 

 

Posting Permissions

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