[amirwolf]

Hello, I am going to use sql, how to read the information of the vault file and enter it in the database?

[fysiks]

I would assume you'd probably have to write a plugin or some other code that reads the vault and then runs the SQL queries to insert the data into the database. Fairly straight forward, especially since the vault code already exists and the SQL queries need to be written for the new method anyways. The only difference is that this is a one-time plugin.

[bigdaddy424]

All credits go to bugsy for his amazing work
Get example.vault at https://forums.alliedmods.net/showthread.php?t=66657

upload.sql

INSERT INTO `example` VALUES (`id`, `data`, `timestamp`) VALUES 'Entry 1', 'This is the value for entry 1', 1202241361)
INSERT INTO `example` VALUES (`id`, `data`, `timestamp`) VALUES 'Entry 2', 'This is the value for entry 2', 1202241363)
INSERT INTO `example` VALUES (`id`, `data`, `timestamp`) VALUES 'Entry 3', 'This is the value for entry 3', 1202241364)
INSERT INTO `example` VALUES (`id`, `data`, `timestamp`) VALUES 'Entry with no value', '', 1202241365)
INSERT INTO `example` VALUES (`id`, `data`, `timestamp`) VALUES 'Permanent Entry', 'because there\'s no timestamp', 0)

PHP Code:

#include <amxmodx>
#include <amxmisc>
#include <sqlx>

#pragma ctrlchar '\'

new vault[] = "example"
new Array:g_aArray

const MaxKeyLen  = 255;     //Max 255
const MaxValLen  = 512;     //Max 65535
const DataBuffer = 128;     //Make this the greater of (MaxKeyLen / 4) or (MaxValLen / 4)

enum _: eData{
    szString[32],
    iValue[256],
    iTime
}

public plugin_init()
{
    register_srvcmd("f", "srvcmd_f")
    g_aArray = ArrayCreate( eData )
}

public srvcmd_f()
{
    new Data[eData], buffer_id[64], buffer_data[512]
    new total = ReadVault(vault)
    new iSize = ArraySize(g_aArray)
    new text[512]
    
    server_print("%s - total entries: %d", vault, total)
    for (new i; i < iSize; i++)
    {
        ArrayGetArray( g_aArray, i, Data );
        SQL_QuoteStringFmt(Empty_Handle, buffer_id, charsmax(buffer_id), "%s", Data[szString])
        SQL_QuoteStringFmt(Empty_Handle, buffer_data, charsmax(buffer_data), "%s", Data[iValue])
        formatex(text, charsmax(text), "INSERT INTO `%s` VALUES (`id`, `data`, `timestamp`) VALUES \'%s\', \'%s\', %d)", vault, buffer_id, buffer_data, Data[iTime])
        write_file("upload.sql", text)
    }
}

public ReadVault( const szVault[])
{
    new szFile[ 128 ];
    new iVaultMagic , iVaultVersion , iVaultEntries;
    new iKeyLen , iValLen , iTimeStamp;
    new szKey[ MaxKeyLen + 1 ] , szVal[ MaxValLen + 1 ] , RawData[ DataBuffer ];
    
    formatex( szFile[ get_datadir( szFile , charsmax( szFile ) ) ] , charsmax( szFile ) , "/vault/%s.vault" , szVault );
    
    new const iFile = fopen( szFile , "rb" );

    if ( iFile ){
        // Vault Magic
        fread_raw( iFile , RawData , 1 , BLOCK_INT );
        iVaultMagic = RawData[ 0 ];
        
        // Vault Version
        fread_raw( iFile , RawData , 1 , BLOCK_SHORT );
        iVaultVersion = RawData[ 0 ] & 0xFFFF;

        // Vault Entries
        fread_raw( iFile , RawData , 1 , BLOCK_INT );
        iVaultEntries = RawData[ 0 ];

        for ( new iEntry = 0 ; iEntry < iVaultEntries ; iEntry++ )
        {
            // TimeStamp
            fread_raw( iFile , RawData , 1 , BLOCK_INT );
            iTimeStamp = RawData[ 0 ];
            
            // Key Length
            fread_raw( iFile , RawData , 1 , BLOCK_BYTE );
            iKeyLen = RawData[ 0 ] & 0xFF;
            
            // Val Length
            fread_raw( iFile , RawData , 1 , BLOCK_SHORT );
            iValLen = RawData[ 0 ] & 0xFFFF;
            
            // Key Data
            fread_raw( iFile , RawData , iKeyLen , BLOCK_CHAR );
            ReadString( szKey , iKeyLen , charsmax( szKey ) , RawData );
        
            // Val Data
            fread_raw( iFile , RawData , iValLen , BLOCK_CHAR );
            ReadString( szVal , iValLen , charsmax( szVal ) , RawData );

            WrapItUp(szKey, szVal, iTimeStamp);
        }
        
        fclose( iFile );
        return iVaultEntries;
    }
}

ReadString( szDestString[] , iLen , iMaxLen , SourceData[] )
{
    new iStrPos = -1;
    new iRawPos = 0;
    
    while ( ( ++iStrPos < iLen ) && ( iStrPos < iMaxLen ) && ( iRawPos < DataBuffer ) )
    {
        szDestString[ iStrPos ] = ( SourceData[ iRawPos ] >> ( ( iStrPos % 4 ) * 8 ) ) & 0xFF;
        
        if ( iStrPos && ( ( iStrPos % 4 ) == 3 ) )
            iRawPos++
    }
    
    szDestString[ iStrPos ] = EOS;
}  

public WrapItUp(name[], value[], timestamp){
    new Data[eData];
    copy( Data[ szString ], charsmax( Data[ szString ] ), name );
    copy( Data[ iValue ], charsmax( Data[ iValue ] ), value );
    Data[ iTime ] = timestamp;
    ArrayPushArray(g_aArray, Data);
} 


[Bugsy]

nVault Utility

PHP Code:

#include <amxmodx>
#include <nvault_util>

new const Version[] = "0.1";

public plugin_init() 
{
    register_plugin( "nVault to SQL" , Version , "bugsy" );
    nVault_to_SQL();
}

public nVault_to_SQL()
{
    new iVault = nvault_util_open( "yourVault" );

    nvault_util_readall( iVault , "nVault_to_SQL_Result" );
    
    nvault_util_close( iVault );
}

public nVault_to_SQL_Result( iCurrent , iTotal , const szKey[] , const szVal[] , iTimeStamp , const Data[] , iSize )
{
    new szBuffer[ 128 ];
    formatex( szBuffer , charsmax( szBuffer ) , "INSERT INTO yourTable (%s) VALUES (%s)" , szKey , szVal );
    
    //Execute SQL (szBuffer)
} 


[amirwolf]

Originally Posted by bigdaddy424 All credits go to bugsy for his amazing work Get example.vault at https://forums.alliedmods.net/showthread.php?t=66657

Warnings during compile

Copyright (c) 1997-2006 ITB CompuPhase
Copyright (c) 2004-2013 AMX Mod X Team

C:\Program Files (x86)\Steam\steamapps\common\Half-Life\cstrike\addons\amxmodx\scripting\test.sma(62) : warning 204: symbol is assigned a value that is never used: "iVaultVersion"
C:\Program Files (x86)\Steam\steamapps\common\Half-Life\cstrike\addons\amxmodx\scripting\test.sma(58) : warning 204: symbol is assigned a value that is never used: "iVaultMagic"
C:\Program Files (x86)\Steam\steamapps\common\Half-Life\cstrike\addons\amxmodx\scripting\test.sma(96) : warning 209: function "ReadVault" should return a value
Header size:            516 bytes
Code size:             2968 bytes
Data size:              716 bytes
Stack/heap size:      16384 bytes
Total requirements:   20584 bytes

3 Warnings.
Done.
<<< Process finished (PID=696). (Exit code 0)
================ READY ================

The file is created but I don't understand how to import it
I use this plagin

[amirwolf]

Originally Posted by Bugsy nVault Utility PHP Code: #include <amxmodx> #include <nvault_util> new const Version[] = "0.1"; public plugin_init()  {     register_plugin( "nVault to SQL" , Version , "bugsy" );     nVault_to_SQL(); } public nVault_to_SQL() {     new iVault = nvault_util_open( "yourVault" );     nvault_util_readall( iVault , "nVault_to_SQL_Result" );          nvault_util_close( iVault ); } public nVault_to_SQL_Result( iCurrent , iTotal , const szKey[] , const szVal[] , iTimeStamp , const Data[] , iSize ) {     new szBuffer[ 128 ];     formatex( szBuffer , charsmax( szBuffer ) , "INSERT INTO yourTable (%s) VALUES (%s)" , szKey , szVal );          //Execute SQL (szBuffer) }

All information is displayed
Now I need to transfer everything to the database

[Bugsy]

Originally Posted by amirwolf All information is displayed Now I need to transfer everything to the database

Ok, I assumed you had the DB aspect covered. What are the table and field names?

[amirwolf]

CRXRanks table name
It has 6 fields

Player
XP
Level
Next XP
Rank
Next Rank

But I want to add name to the fields

[Bugsy]

How is your data in nvault stored? I cannot write code for you without knowing these details.

key=Steamid
val=Player (is this name),XP,Level,NextXP,Rank,NextRank?

So ?
key="STEAM_0:0:123456"
val="'Bugsy',45,1,2,6,7"

[amirwolf]

I'm sorry for the late reply, I thought it was in the general section
It's like this

INSERT INTO `crxranks` (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES
('Steam_12345', 471, 3, 500, 'KilleR', 'HitMAN'),

But the name has not been added for it yet