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
{
ACCOUNT[ STEAM_MAX_SIZE ],
Float:TIME,
CATEGORY
};
public SQL_StartProcess( szAccount[ STEAM_MAX_SIZE ], Float:fTime, iCategory )
{
new szQuery[ 128 ], aData[ eData ];
aData[ ACCOUNT ] = szAccount;
aData[ TIME ] = fTime;
aData[ CATEGORY ] = iCategory;
log_amx( "%s %f %i", aData[ ACCOUNT ], aData[ TIME ], aData[ CATEGORY ] );
formatex( szQuery, charsmax( szQuery ), "SELECT CD_Top, FL_Time FROM Tops WHERE NM_ACCOUNT LIKE '%s' AND NM_MAP LIKE '%s' AND CD_CATEGORY = %i", szAccount, g_szMapName, iCategory );
SQL_ThreadQuery( g_hSqlTuple, "SearchResult", szQuery, aData, sizeof aData );
}
public SearchResult( iFailState, Handle:hQuery, szError[ ], aData[ eData ], iSize )
{
if( iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED )
{
new szLogFile[ 64 ];
formatex( szLogFile, charsmax( szLogFile ), "events/TopsSQL.txt" );
log_to_file( szLogFile, "[Tops SQL] Erro identificado" );
log_to_file( szLogFile, "[Tops SQL] %s", szError );
return PLUGIN_CONTINUE;
}
new szAccount[ STEAM_MAX_SIZE ], Float:fTime, iCategory;
szAccount = aData[ ACCOUNT ];
fTime = aData[ TIME ];
iCategory = aData[ CATEGORY ];
log_amx( "%s %f %i", aData[ ACCOUNT ], aData[ TIME ], aData[ CATEGORY ] );
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.
__________________