View Single Post
Author Message
marcelowzd
Senior Member
Join Date: Feb 2011
Location: São Paulo, Brazil
Old 10-01-2019 , 18:45   Passing parameters using SQL_ThreadQuery
Reply With Quote #1

Hi guys, i'm trying to pass parameters to SQL_ThreadQuery (not the query itself), but when i try to retrieve them, i get random values

PHP Code:
enum _:eData
{
    
ACCOUNTSTEAM_MAX_SIZE ],
    
Float:TIME,
    
CATEGORY
};

public 
SQL_StartProcessszAccountSTEAM_MAX_SIZE ], Float:fTimeiCategory )
{
    new 
szQuery128 ], aDataeData ];

    
aDataACCOUNT ] = szAccount;
    
aDataTIME ] = fTime;
    
aDataCATEGORY ] = iCategory;

    
log_amx"%s %f %i"aDataACCOUNT ], aDataTIME ], aDataCATEGORY ] );

    
formatexszQuerycharsmaxszQuery ), "SELECT CD_Top, FL_Time FROM Tops WHERE NM_ACCOUNT LIKE '%s' AND NM_MAP LIKE '%s' AND CD_CATEGORY = %i"szAccountg_szMapNameiCategory  );

    
SQL_ThreadQueryg_hSqlTuple"SearchResult"szQueryaDatasizeof aData );
}

public 
SearchResultiFailStateHandle:hQueryszError[ ], aDataeData ], iSize )
{
    if( 
iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED )
    {
        new 
szLogFile64 ];

        
formatexszLogFilecharsmaxszLogFile ), "events/TopsSQL.txt" );

        
log_to_fileszLogFile"[Tops SQL] Erro identificado" );
        
log_to_fileszLogFile"[Tops SQL] %s"szError );

        return 
PLUGIN_CONTINUE;
    }

    new 
szAccountSTEAM_MAX_SIZE ], Float:fTimeiCategory;

    
szAccount aDataACCOUNT ];
    
fTime aDataTIME ];
    
iCategory aDataCATEGORY ];

    
log_amx"%s %f %i"aDataACCOUNT ], aDataTIME ], aDataCATEGORY ] );

    return 
PLUGIN_CONTINUE;

Outputs
Code:
L 10/01/2019 - 19:36:49: [Test.amxx] STEAM_0:1:39264654 15.058460 5 // FIRST LOG
L 10/01/2019 - 19:36:49: [Test.amxx]  0.000000 95 // SECOND LOG
Am i doing something wrong?

Thanks in advance.
__________________

Last edited by Bugsy; 10-08-2019 at 20:28.
marcelowzd is offline