[crnova]

As the title says, player's data randomly wipes, it is unknown when, i'm using SQLite to save & load player data

[Black Rose]

What you should do is set up a bunch of server_print() or log_amx() at all the locations saving data, enter as much information as possible in them. For example, which function is calling and what data it is saving. You will easily find the problem.

This seems kind of weird though. Why would you free it before saving? As far as I can see, it does not reconnect before trying to save. But maybe I misunderstood the functions. I'm not very well trained in the arts of SQL.

public plugin_end()
{
    if( g_SqlConnection != Empty_Handle )
    {
        SQL_FreeHandle(g_SqlConnection)
    }
    
    SaveAll_SQLite()
}

[crnova]

Originally Posted by Black Rose What you should do is set up a bunch of server_print() or log_amx() at all the locations saving data, enter as much information as possible in them. For example, which function is calling and what data it is saving. You will easily find the problem. This seems kind of weird though. Why would you free it before saving? As far as I can see, it does not reconnect before trying to save. But maybe I misunderstood the functions. I'm not very well trained in the arts of SQL. public plugin_end() {     if( g_SqlConnection != Empty_Handle )     {         SQL_FreeHandle(g_SqlConnection)     }         SaveAll_SQLite() }

I'll try that, but i'm guessing the problem is,

public plugin_end()
{
    if( g_SqlConnection != Empty_Handle )
    {
        SQL_FreeHandle(g_SqlConnection)
    }
    
    SaveAll_SQLite()
}

Should be

public plugin_end()
{
    SaveAll_SQLite()

    if( g_SqlConnection != Empty_Handle )
    {
        SQL_FreeHandle(g_SqlConnection)
    }
}

[crnova]

Okay i've solved the problem

The problem was when a map change occurs, all the players disconnect, and when they disconnect this happens:

public artifacts_disconnect(id)
{
    Save_SQLite(id)
    
    g_Crates[id] = 0
    g_Keys[id] = 0
    g_M4A1[id] = 0
    g_AK47[id] = 0
    g_DEAGLE[id] = 0
    g_AWP[id] = 0
    g_KNIFE[id] = 0
}

As you can see above, the player's data save, and then it's set to 0, then when the Plugin ends!, all player's data is saved, Which means the "0" from above, is saved also, because on map change, plugin end occurs after disconnect.

Thank you Black Rose! putting log_amx to see the problem helped me alot

[Black Rose]

I'm glad you found the problem. Good job!