Thread: [INC] SQLVault
View Single Post
EpicMonkey
buttmonkey
Join Date: Feb 2012
Old 04-06-2012 , 16:40   Re: [INC] SQLVault
Reply With Quote #53

Would this be a simple way for converting

Nvault:
PHP Code:
public LoadTimeid 
{
    new 
vault nvault_open("Played_Time")
    
    new 
szAuthID[33];
    new 
vaultkey[64], vaultdata[64];
    
    
get_user_authid(idszAuthIDcharsmax(szAuthID));
    
    
format(vaultkey63"PLAYEDTIME%s"szAuthID);
    
    
nvault_get(vaultvaultkeyvaultdata63);
    
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(idszAuthIDcharsmax(AuthID))
    
    
format(vaultkey63"PLAYEDTIME%s"szAuthID); 
    
format(vaultdata63"%d"PlayedTime); 
    
    
nvault_set(vaultvaultkeyvaultdata);
    
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(idszAuthIDcharsmax(szAuthID))
    
    
format(szKeycharsmax(szKey), "PT%s"szAuthID); 
    
format(szDatacharsmax(szData), "%d"PlayedTime); 
    
    
sqlv_set_data(g_hVaultszKeyszData)
    
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(idszAuthIDcharsmax(szAuthID));
    
    
format(szKeycharsmax(szKey), "PT%s"szAuthID);
    
    
sqlv_get_data(g_hVaultszKeyszDatacharsmax(szData))
    
    
sqlv_close(g_hVault)
    return 
str_to_num(szData);

Just testing it on Alka Played time plugin

Last edited by EpicMonkey; 04-06-2012 at 16:42.
EpicMonkey is offline