View Single Post
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 12-28-2023 , 00:01   Re: Transfer vault information to SQL
Reply With Quote #4

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_readalliVault "nVault_to_SQL_Result" );
    
    
nvault_util_closeiVault );
}

public 
nVault_to_SQL_ResultiCurrent iTotal , const szKey[] , const szVal[] , iTimeStamp , const Data[] , iSize )
{
    new 
szBuffer128 ];
    
formatexszBuffer charsmaxszBuffer ) , "INSERT INTO yourTable (%s) VALUES (%s)" szKey szVal );
    
    
//Execute SQL (szBuffer)

__________________
Bugsy is offline