local _ = function(k, ...) return ImportPackage("i18n").t(GetPackageName(), k, ...) end
PlayerData = {}

local TIMER_PERIODIC_CHECK_DEV_MODE = 15

function OnPackageStart()
    -- Save all player data automatically
    CreateTimer(function()
        for k, v in pairs(GetAllPlayers()) do
            SavePlayerAccount(v)
            CheckForBansFromOutside(v)
        end
    end, 30000)

    PeriodicCheckAllowedToPlay()
end
AddEvent("OnPackageStart", OnPackageStart)

AddEvent("OnPackageStop", function()
    for k, v in pairs(GetAllPlayers()) do
        SavePlayerAccount(v)
    end
    print("All accounts have been saved !")
end)

function OnPlayerJoin(player)
    SetPlayerSpawnLocation(player, 227603, -65590, 400, 90)
end
AddEvent("OnPlayerJoin", OnPlayerJoin)

function OnPlayerSteamAuth(player)
    print('JOINING â†’ ', GetPlayerSteamId(player))
    
    CreatePlayerData(player)
    PlayerData[player].steamname = GetPlayerName(player)
    
    -- First check if there is an account for this player
    local query = mariadb_prepare(sql, "SELECT id FROM accounts WHERE steamid = '?' LIMIT 1;",
        tostring(GetPlayerSteamId(player)))
    
    mariadb_async_query(sql, query, OnAccountLoadId, player)
end
AddEvent("OnPlayerSteamAuth", OnPlayerSteamAuth)

function OnPlayerQuit(player)
    PlayerData[player].is_online = 0
    SavePlayerAccount(player)
    GatheringCleanPlayerActions(player)-- â†’ Gathering
    DestroyPlayerData(player)
end
AddEvent("OnPlayerQuit", OnPlayerQuit)

function OnAccountLoadId(player)
    if (mariadb_get_row_count() == 0) then
        --There is no account for this player, continue by checking if their IP was banned
        local query = mariadb_prepare(sql, "SELECT FROM_UNIXTIME(bans.ban_time), bans.reason FROM bans WHERE bans.steamid = ?;",
            tostring(GetPlayerSteamId(player)))
        
        mariadb_async_query(sql, query, OnAccountCheckBan, player)
    else
        --There is an account for this player, continue by checking if it's banned
        PlayerData[player].accountid = mariadb_get_value_index(1, 1)
        
        local query = mariadb_prepare(sql, "SELECT FROM_UNIXTIME(bans.ban_time), bans.reason FROM bans WHERE bans.steamid = ?;",
            tostring(GetPlayerSteamId(player)))
        
        mariadb_async_query(sql, query, OnAccountCheckBan, player)
    end
end

function OnAccountCheckBan(player)
    if (mariadb_get_row_count() == 0) then
        --No ban found for this account
        CheckForIPBan(player)
    else
        --There is a ban in the database for this account
        local result = mariadb_get_assoc(1)
        
        print("Kicking " .. GetPlayerName(player) .. " because their account was banned")
        
        KickPlayer(player, _("banned_for", result['reason'], result['FROM_UNIXTIME(bans.ban_time)']))
    end
end

function CheckForIPBan(player)
    local query = mariadb_prepare(sql, "SELECT ipbans.reason FROM ipbans WHERE ipbans.ip = '?' LIMIT 1;",
        GetPlayerIP(player))
    
    mariadb_async_query(sql, query, OnAccountCheckIpBan, player)
end

function OnAccountCheckIpBan(player)
    if (mariadb_get_row_count() == 0) then
        --No IP ban found for this account
        if (PlayerData[player].accountid == 0) then
            CreatePlayerAccount(player)
        else
            LoadPlayerAccount(player)
        end
    else
        print("Kicking " .. GetPlayerName(player) .. " because their IP was banned")
        
        local result = mariadb_get_assoc(1)
        
        KickPlayer(player, "ðŸš¨ You have been banned from the server.")
    end
end

function CreatePlayerAccount(player)
    local query = mariadb_prepare(sql, "INSERT INTO `accounts` (`id`, `steamid`, `name`, `clothing`, `police`, `medic`, `inventory`, `position`, `admin`, `health`, `armor`, `thirst`, `hunger`, `bank_balance`, `created`, `phone_number`, `driver_license`, `gun_license`, `helicopter_license`, `drug_knowledge`, `job`, `is_cuffed`, `age`) VALUES (NULL, '?', 'Unregistered', '[]', '0', '0', '[]', '[]', '0', '100', '0', '100', '100', '4900', '0', NULL, '0', '0', '0', '[]', NULL, '0', '0');",
        tostring(GetPlayerSteamId(player)))
    
    mariadb_query(sql, query, OnAccountCreated, player)
end

function OnAccountCreated(player)
    PlayerData[player].accountid = mariadb_get_insert_id()
    
    CallRemoteEvent(player, "InitWelcome", false)
    ServerCharacterCreation(player)
    
    SetPlayerLoggedIn(player)
    SetAvailablePhoneNumber(player)
    setPositionAndSpawn(player, nil)
    CheckDevMode(player)
    
    print("Account ID " .. PlayerData[player].accountid .. " created for " .. player)
end

function LoadPlayerAccount(player)
    local query = mariadb_prepare(sql, "SELECT * FROM accounts WHERE id = ?;",
        PlayerData[player].accountid)
    
    mariadb_async_query(sql, query, OnAccountLoaded, player)
end

function LoadPlayerPhoneContacts(player)
    local query = mariadb_prepare(sql, "SELECT * FROM phone_contacts WHERE phone_contacts.owner_id = ? ORDER BY phone_contacts.name;", PlayerData[player].accountid)
    
    mariadb_async_query(sql, query, OnPhoneContactsLoaded, player)
end

function OnAccountLoaded(player)
    if (mariadb_get_row_count() == 0) then
        --This case should not happen but still handle it
        KickPlayer(player, "An error occured while loading your account ðŸ˜¨")
    else
        local result = mariadb_get_assoc(1)
        PlayerData[player].admin = math.tointeger(result['admin'])
        PlayerData[player].bank_balance = math.tointeger(result['bank_balance'])
        PlayerData[player].name = tostring(result['name'])
        PlayerData[player].clothing = json_decode(result['clothing'])
        PlayerData[player].police = math.tointeger(result['police'])
        PlayerData[player].medic = math.tointeger(result['medic'])
        PlayerData[player].driver_license = math.tointeger(result['driver_license'])
        PlayerData[player].gun_license = math.tointeger(result['gun_license'])
        PlayerData[player].helicopter_license = math.tointeger(result['helicopter_license'])
        PlayerData[player].inventory = json_decode(result['inventory'])        
        PlayerData[player].created = math.tointeger(result['created'])
        PlayerData[player].position = json_decode(result['position'])
        PlayerData[player].drug_knowledge = json_decode(result['drug_knowledge'])
        PlayerData[player].job = result['job']
        PlayerData[player].is_cuffed = math.tointeger(result['is_cuffed'])
        PlayerData[player].age = math.tointeger(result['age'])
        PlayerData[player].health = math.tointeger(result['health'])
        
        if result['phone_number'] and result['phone_number'] ~= "" then
            PlayerData[player].phone_number = tostring(result['phone_number'])
        else
            SetAvailablePhoneNumber(player)
        end
        
        SetPlayerArmor(player, tonumber(result['armor']))
        setPlayerThirst(player, tonumber(result['thirst']))
        setPlayerHunger(player, tonumber(result['hunger']))

        CallEvent("job:onspawn", player)-- Trigger the loading of jobs when player is fully loaded (have to be set up for each jobs)
        
        PlayerData[player].is_online = 1
        
        SetPlayerLoggedIn(player)

        if PlayerData[player].created == 0 then
            CallRemoteEvent(player, "InitWelcome", false)
            ServerCharacterCreation(player)
        else
            CallRemoteEvent(player, "InitWelcome", true)
            SetPlayerName(player,PlayerData[player].accountid)
            UpdateClothes(player)
            DisplayPlayerBackpack(player)
        end

        setPositionAndSpawn(player)

        LoadPlayerPhoneContacts(player)
        print("Account ID " .. PlayerData[player].accountid .. " loaded for " .. GetPlayerIP(player))
        CheckDevMode(player)
    end
end

function CheckDevMode(player)
    CallRemoteEvent(player, "account:checkdevmode")    
end

AddRemoteEvent("account:checkdevmode:result", function(player, result)    
    if result == true and PlayerData[player].admin ~= 1 then
        KickDevMode(player)
    else
        PlayerData[player].allowed_to_play = true        
    end
end)

local timer
function PeriodicCheckAllowedToPlay() 
    print('â†’ PERIODIC CHECK FOR DEV MODE FOOLS INITIALIZED')
    timer = CreateTimer(function()
        for k,v in pairs(GetAllPlayers()) do
            if PlayerData[v] ~= nil then
                if PlayerData[v].is_online ~= 1 then return end
                if PlayerData[v].admin ~= nil and PlayerData[v].admin == 1 then return end
                if PlayerData[v].allowed_to_play == nil then return end
                if PlayerData[v].allowed_to_play ~= true then
                    KickDevMode(v)
                end
            end
        end
    end, TIMER_PERIODIC_CHECK_DEV_MODE * 1000)
end

function KickDevMode(player)
    KickPlayer(player, _("disable_dev_mode"))
    
    local message = "â†’ KICKING "..player.." â†’ "..GetPlayerSteamId(player).." BECAUSE DEV MODE"
    if PlayerData[player] ~= nil then
        message = message .. " - Name : "..PlayerData[player].name
    end
    print(message)
end

function setPositionAndSpawn(player)
    if PlayerData[player].created == 0 then
        CallRemoteEvent(player, "askClientCreation")
    else
        local position = PlayerData[player].position
        
        if position == nil or position.x == nil or position.y == nil or position.z == nil then
            PlayerData[player].position.x = 227603
            PlayerData[player].position.y = -65590
            PlayerData[player].position.z = 400
        end
        
        SetPlayerLocation(player, PlayerData[player].position.x, PlayerData[player].position.y, PlayerData[player].position.z + 250) -- To be "sure" you won't spawn under the map
        SetPlayerHeading(player, 180)
        SavePlayerAccount()
    end
end

AddRemoteEvent("setPositionAndSpawn", setPositionAndSpawn)

function SetAvailablePhoneNumber(player)
    -- Generate a random phone number
    local phone_number = "555" .. tostring(math.random(100000, 999999))
    
    local query = mariadb_prepare(sql, "SELECT id FROM accounts WHERE phone_number = ?;",
        phone_number)
    
    mariadb_async_query(sql, query, OnPhoneNumberChecked, player, phone_number)
end

function OnPhoneNumberChecked(player, phone_number)
    if (mariadb_get_row_count() == 0) then
        -- If phone number is available
        local query = mariadb_prepare(sql, "UPDATE accounts SET phone_number = ? WHERE id = ?", phone_number, PlayerData[player].accountid)
        
        PlayerData[player].phone_number = phone_number
        
        mariadb_async_query(sql, query)
    else
        -- Retry with a new phone number if the generated one is already allowed to another account
        SetAvailablePhoneNumber(player)
    end
end

function OnPhoneContactsLoaded(player)
    for i = 1, mariadb_get_row_count() do
        local contact = mariadb_get_assoc(i)
        if contact['id'] then
            PlayerData[player].phone_contacts[i] = {id = tostring(contact['id']), name = contact['name'], phone = contact['phone']}
        end
    end
    
    print("Phone contacts loaded for " .. PlayerData[player].accountid)
end

function CreatePlayerData(player)
    PlayerData[player] = {}
    
    PlayerData[player].accountid = 0
    PlayerData[player].name = ""
    PlayerData[player].clothing = {}
    PlayerData[player].police = 0
    PlayerData[player].medic = 0
    PlayerData[player].inventory = {cash = 100}
    PlayerData[player].driver_license = 0
    PlayerData[player].gun_license = 0
    PlayerData[player].helicopter_license = 0
    PlayerData[player].logged_in = false
    PlayerData[player].admin = 0
    PlayerData[player].created = 0
    PlayerData[player].steamid = GetPlayerSteamId(player)
    PlayerData[player].steamname = ""
    PlayerData[player].thirst = 100
    PlayerData[player].hunger = 100
    PlayerData[player].health = 100
    PlayerData[player].bank_balance = 7000 -- For BETA 3
    PlayerData[player].job_vehicle = nil
    PlayerData[player].job = ""
    PlayerData[player].phone_contacts = {}
    PlayerData[player].phone_number = {}
    PlayerData[player].position = {}
    PlayerData[player].backpack = nil
    PlayerData[player].drug_knowledge = {}
    PlayerData[player].is_cuffed = 0
    PlayerData[player].age = 30
    
    print("Data created for : " .. player)
end

function DestroyPlayerData(player)
    if (PlayerData[player] == nil) then
        return
    end
    
    -- if PlayerData[player].job_vehicle ~= nil then
    --     DestroyVehicle(PlayerData[player].job_vehicle)
    --     DestroyVehicleData(PlayerData[player].job_vehicle)
    --     PlayerData[player].job_vehicle = nil
    -- end

    local attachedObjects = { "backpack", "mask_1", "mask_2", "mask_3", "mask_4" }

    for k, itemToRemove in pairs(attachedObjects) do
        if PlayerData[player][itemToRemove] ~= nil then
            DestroyObject(PlayerData[player][itemToRemove])
            PlayerData[player][itemToRemove] = nil
        end
    end
    
    print("Player disconnected : " .. PlayerData[player].accountid)
    PlayerData[player] = nil
    print("Data destroyed for : " .. player)
end

function SavePlayerAccount(player)
    if (PlayerData[player] == nil) then
        return
    end
    
    if (PlayerData[player].accountid == 0 or PlayerData[player].logged_in == false) then
        return
    end
    
    PlayerData[player].health = GetPlayerHealth(player)
    
    -- Sauvegarde de la position du joueur
    local x, y, z = GetPlayerLocation(player)
    PlayerData[player].position = {x = x, y = y, z = z}
    
    local query = mariadb_prepare(sql, "UPDATE accounts SET admin = ?, bank_balance = ?, health = ?, armor = ?, hunger = ?, thirst = ?, name = '?', clothing = '?', inventory = '?', created = '?', position = '?', driver_license = ?, gun_license = ?, helicopter_license = ?, drug_knowledge = '?', job = '?', is_cuffed = ?, age = ?, is_online = '?' WHERE id = ? LIMIT 1;",
        PlayerData[player].admin,
        PlayerData[player].bank_balance,
        PlayerData[player].health,
        GetPlayerArmor(player),
        PlayerData[player].hunger,
        PlayerData[player].thirst,
        PlayerData[player].name,
        json_encode(PlayerData[player].clothing),
        json_encode(PlayerData[player].inventory),
        PlayerData[player].created,
        json_encode(PlayerData[player].position),
        PlayerData[player].driver_license,
        PlayerData[player].gun_license,
        PlayerData[player].helicopter_license,
        json_encode(PlayerData[player].drug_knowledge),
        PlayerData[player].job or "",
        PlayerData[player].is_cuffed or 0,
        PlayerData[player].age or 30,
        PlayerData[player].is_online or 0,
        PlayerData[player].accountid
    )
    mariadb_query(sql, query)
end

function SetPlayerLoggedIn(player)
    PlayerData[player].logged_in = true
end

function IsAdmin(player)
    return PlayerData[player].admin
end

function SetPlayerBusy(player)-- Shortcut to set a player in a busy state
    local result = SetPlayerPropertyValue(player, "PlayerIsBusy", true, true)
    return result
end
AddRemoteEvent("account:setplayerbusy", SetPlayerBusy)-- To do it clientside

function SetPlayerNotBusy(player)-- Shortcut to set a player in a not busy state
    local result = SetPlayerPropertyValue(player, "PlayerIsBusy", false, true)
    return result
end
AddRemoteEvent("account:setplayernotbusy", SetPlayerNotBusy)-- To do it clientside

function GetPlayerBusy(player)-- Shortcut to get the busy state of the player
    local result = GetPlayerPropertyValue(player, "PlayerIsBusy") or false
    return result
end

function CheckForBansFromOutside(player)
    local query = mariadb_prepare(sql, "SELECT steamid, reason FROM bans WHERE steamid = '?' LIMIT 1;",
        tostring(GetPlayerSteamId(player)))
    
    mariadb_async_query(sql, query, OnBansChecked, player)
end

function OnBansChecked(player)
    if mariadb_get_row_count() > 0 then
        local ban = mariadb_get_assoc(1)
        KickPlayer(player, _("banned_from_intranet", ban["reason"]))
    end
end

-- Exports
AddFunctionExport("isAdmin", IsAdmin)
AddFunctionExport("SetPlayerBusy", SetPlayerBusy)
AddFunctionExport("SetPlayerNotBusy", SetPlayerNotBusy)
AddFunctionExport("GetPlayerBusy", GetPlayerBusy)

-- TO REMOVE
function GetPlayerData(player)
    return PlayerData[player]
end
AddFunctionExport("GetPlayerData", GetPlayerData)
