[Exolent[jNr]]

NVault has that problem if you keep the vault open the whole map.
This is because NVault doesn't save any data to the file until it is closed.
While it is open, all of the data is stored in memory to be more efficient when grabbing/setting.
When the vault isn't closed due to for example a server crash, all the unsaved data is lost.

With SQLVault, it is stored in the database directly and not in memory, so you will not have this problem.

[funfel]

First of all - thanks you! Creating Tops or Ranks, etc. with nvault and arrays - slowly work, and I can't use SQL because I don't know how (I know, know, but a bit), but now - easy to do and moreover - it is SQL
But I have one question, this code:

PHP Code:

sqlv_read_ex( g_hVault, 0, szKey1, charsmax(szKey1), "level", 6, szData, charsmax(szData), iTimeStamp, "", "`data` DESC"); 


Is the same like this:

PHP Code:

sqlv_read_ex( g_hVault, 0, szKey1, charsmax(szKey1), "", 0, szData, charsmax(szData), iTimeStamp, "`key2` = 'level'", "`data` DESC"); 


I don't know, because u saved blank szKey2 in second code and you wrote key2 in szWhere. I checked it on my server for test, result is the same, but Is there a difference?


Sorry for my bad english, i am just from country, where english isn't on good level (POLAND).

@EDIT: Sorry, now I checked .inc and I analyzed it thoroughly, first code is wrong

[EpicMonkey]

Would this be a simple way for converting

Nvault:

PHP Code:

public LoadTime( id ) 
{
    new vault = nvault_open("Played_Time")
    
    new szAuthID[33];
    new vaultkey[64], vaultdata[64];
    
    get_user_authid(id, szAuthID, charsmax(szAuthID));
    
    format(vaultkey, 63, "PLAYEDTIME%s", szAuthID);
    
    nvault_get(vault, vaultkey, vaultdata, 63);
    nvault_close(vault);
    
    return str_to_num(vaultdata);
}
 
public SaveTime(id,PlayedTime)
{
    new vault = nvault_open("Played_Time")
    
    if(vault == INVALID_HANDLE)
        set_fail_state("nvault returned invalid handle")
    
    new szAuthID[33];
    new vaultkey[64], vaultdata[64];
    
    get_user_authid(id, szAuthID, charsmax(AuthID))
    
    format(vaultkey, 63, "PLAYEDTIME%s", szAuthID); 
    format(vaultdata, 63, "%d", PlayedTime); 
    
    nvault_set(vault, vaultkey, vaultdata);
    nvault_close(vault);
} 


to sqlvault

PHP Code:

public SaveTime(id,PlayedTime)
{
    g_hVault = sqlv_open_local("test")
    
    new szAuthID[33];
    new szKey[64], szData[64];
    
    get_user_authid(id, szAuthID, charsmax(szAuthID))
    
    format(szKey, charsmax(szKey), "PT%s", szAuthID); 
    format(szData, charsmax(szData), "%d", PlayedTime); 
    
    sqlv_set_data(g_hVault, szKey, szData)
    sqlv_close(g_hVault)
}
 
public LoadTime(id) 
{
    g_hVault = sqlv_open_local("test")
    sqlv_connect(g_hVault);
    
    new szAuthID[33];
    new szKey[64], szData[64];
    
    get_user_authid(id, szAuthID, charsmax(szAuthID));
    
    format(szKey, charsmax(szKey), "PT%s", szAuthID);
    
    sqlv_get_data(g_hVault, szKey, szData, charsmax(szData))
    
    sqlv_close(g_hVault)
    return str_to_num(szData);
} 


Just testing it on Alka Played time plugin

[Exolent[jNr]]

You don't want to open multiple times with SQLVault.
Open it on plugin start and close on plugin end.
Since you are doing 1 save at a time, you don't even need to manually connect.

[EpicMonkey]

Originally Posted by Exolent[jNr] You don't want to open multiple times with SQLVault. Open it on plugin start and close on plugin end. Since you are doing 1 save at a time, you don't even need to manually connect.

would it be safe to open it on plugin start and close it on plugin end?

[Exolent[jNr]]

Yes.

[EpicMonkey]

is there a way to make a top15 rank system with sqlvault?

[Exolent[jNr]]

Use the sqlv_read_set() and sort by value.

[EpicMonkey]

Originally Posted by Exolent[jNr] Use the sqlv_read_set() and sort by value.

i see , ok ill do my end of the job and see if it works , thanks anyways

[EpicMonkey]

would this be the right way to save and load?
Just an ex :

PHP Code:

#include <amxmodx>
#include <amxmisc>
#include <sqlvault>

#define PLUGIN "Random"
#define VERSION "1.0"
#define AUTHOR "Epic"

new randomdata[33], SQLVault:g_hVault;

public plugin_init() 
{
    register_plugin(PLUGIN, VERSION, AUTHOR)
    g_hVault = sqlv_open_local("Test")
}

public plugin_end()
{
    sqlv_close(g_hVault)
}

public client_disconnect(id)
{
    Save(id)
}

public client_putinserver(id)
{
    Load(id)
}

public Save(id)
{    
    new szAuthID[35], szKey[64],szData[256];
    get_user_authid(id, szAuthID, charsmax(szAuthID))
    
    format(szKey, charsmax(szKey), "R%s", szAuthID); 
    format(szData, charsmax(szData), "%d", randomdata[id]);
    
    sqlv_set_data(g_hVault, szKey, szData)
    
    return PLUGIN_CONTINUE
}

public Load(id)
{    
    new szAuthID[35], szKey[64],szData[256];
    get_user_authid(id, szAuthID, charsmax(szAuthID))
    
    format(szKey, charsmax(szKey), "R%s", szAuthID);
    sqlv_get_data(g_hVault, szKey, szData, charsmax(szData))
    
    return str_to_num(szData);
}