[TheBladerX]

Hello, is it possible to somehow extract content from file .vault into mysql db? Just for reading (every day for example)

[Bugsy]

Yes, use nVault Utility to read the vault and SQL statements to insert into the DB.

[TheBladerX]

Thank you! But which sql statements do you exactly mean?

[PTE]

Insert into ?

[Bugsy]

Yes, INSERT INTO [table] ([fields]) VALUES ([values])

[TheBladerX]

Okay, thank you. But now I have this problem:
I have one vault entry like this:

josey-10-cod470524#98#100#100#100#100#50#3112#50

, which is

[1307 of 1322] Key=josey-10-cod Val=470524#98#100#100#100#100#50#3112#50 Timestamp=1547216339

Is it possible to extract name josey-10-cod with those values assigned to something? For example val 470524 would be assigned to $doswiadczenie_gracza[id], val 98 would be assigned to $poziom_gracza[id], which I can later use to insert into database?

Also this is the vault:

format(vaultkey,63,"%s-%i-cod", nazwa_gracza[id], klasa_gracza[id]);
	format(vaultdata,255,"%i#%i#%i#%i#%i#%i#%i#%i#%i", doswiadczenie_gracza[id], poziom_gracza[id], inteligencja_gracza[id], zdrowie_gracza[id], wytrzymalosc_gracza[id], kondycja_gracza[id], bonus_gracza[id], monety[id], ochrona_gracza[id]);

[Bugsy]

PHP Code:

#include <amxmodx>
#include <nvault>

const MaxNumberLength = 6;

enum VaultValues
{
    doswiadczenie, 
    poziom, 
    inteligencja,
    zdrowie, 
    wytrzymalosc, 
    kondycja,
    bonus,
    monety, 
    ochrona
}

new iPlayerData[ MAX_PLAYERS + 1 ][ VaultValues ];

public Test( id )
{
    new szKey[ 32 ] , szData[ 64 ] , iVault;
    
    new iLen = nvault_get( iVault , szKey , szData , charsmax( szData ) );
    ParsePlayerData( id , szData , iLen );
}

public ParsePlayerData( id , szVaultData[] , iLen ) 
{
    new szNumbers[ VaultValues ][ MaxNumberLength + 1 ] , VaultValues:vvIndex = VaultValues:-1 , iPos = 0;
    
    replace_all( szVaultData , iLen , "#" , " " );
    
    while ( ( iPos > -1 ) && ( ++vvIndex < VaultValues:sizeof( szNumbers ) ) )
    {
        iPos = argparse( szVaultData , iPos , szNumbers[ vvIndex ] , charsmax( szNumbers[] ) );
        
        iPlayerData[ id ][ VaultValues:vvIndex ] = str_to_num( szNumbers[ vvIndex ] );
        
        server_print( "Found [%d]" , iPlayerData[ id ][ VaultValues:vvIndex ] );
    }
} 


[TheBladerX]

Originally Posted by Bugsy PHP Code: #include <amxmodx> #include <nvault> const MaxNumberLength = 6; enum VaultValues {     doswiadczenie,      poziom,      inteligencja,     zdrowie,      wytrzymalosc,      kondycja,     bonus,     monety,      ochrona } new iPlayerData[ MAX_PLAYERS + 1 ][ VaultValues ]; public Test( id ) {     new szKey[ 32 ] , szData[ 64 ] , iVault;          new iLen = nvault_get( iVault , szKey , szData , charsmax( szData ) );     ParsePlayerData( id , szData , iLen ); } public ParsePlayerData( id , szVaultData[] , iLen )  {     new szNumbers[ VaultValues ][ MaxNumberLength + 1 ] , VaultValues:vvIndex = VaultValues:-1 , iPos = 0;          replace_all( szVaultData , iLen , "#" , " " );          while ( ( iPos > -1 ) && ( ++vvIndex < VaultValues:sizeof( szNumbers ) ) )     {         iPos = argparse( szVaultData , iPos , szNumbers[ vvIndex ] , charsmax( szNumbers[] ) );                  iPlayerData[ id ][ VaultValues:vvIndex ] = str_to_num( szNumbers[ vvIndex ] );                  server_print( "Found [%d]" , iPlayerData[ id ][ VaultValues:vvIndex ] );     } }

Found [0]
also had to change argparse to parse, it did not want to compile.

[eat1k]

From AES:

PHP Code:

mysql_escape_string(dest[],len)
{
    //copy(dest, len, source);
    replace_all(dest,len,"\\","\\\\");
    replace_all(dest,len,"\0","\\0");
    replace_all(dest,len,"\n","\\n");
    replace_all(dest,len,"\r","\\r");
    replace_all(dest,len,"\x1a","\Z");
    replace_all(dest,len,"'","''");
    replace_all(dest,len,"^"","^"^"");
} 


[TheBladerX]

Originally Posted by eat1k From AES: PHP Code: mysql_escape_string(dest[],len) {     //copy(dest, len, source);     replace_all(dest,len,"\\","\\\\");     replace_all(dest,len,"\0","\\0");     replace_all(dest,len,"\n","\\n");     replace_all(dest,len,"\r","\\r");     replace_all(dest,len,"\x1a","\Z");     replace_all(dest,len,"'","''");     replace_all(dest,len,"^"","^"^""); }

That is for what?