For example i have:
PHP Code:
public MySqlFunction( FailState, Handle:Query, Error[ ], Errcode, Data[ ], DataSize )
{
switch( FailState )
{
case TQUERY_CONNECT_FAILED:
{
set_fail_state( "TQUERY_CONNECT_FAILED" )
}
case TQUERY_QUERY_FAILED:
{
set_fail_state( "TQUERY_QUERY_FAILED" )
}
}
if( Errcode )
{
set_fail_state( "ERRCODE" )
}
new id
id = Data[ 0 ]
if( ~IsConnected( id ) )
return PLUGIN_HANDLED
if( SQL_NumResults( Query ) < 1 )
{
// do something else
}
else
{
g_iPlayerValue[ id ] = SQL_ReadResult( Query, SQL_FieldNameToNum( Query, "player_value" ) )
}
return PLUGIN_CONTINUE
}
will not better if i cached value for
SQL_FieldNameToNum ? (for optimization) Example:
PHP Code:
public MySqlFunction( FailState, Handle:Query, Error[ ], Errcode, Data[ ], DataSize )
{
switch( FailState )
{
case TQUERY_CONNECT_FAILED:
{
set_fail_state( "TQUERY_CONNECT_FAILED" )
}
case TQUERY_QUERY_FAILED:
{
set_fail_state( "TQUERY_QUERY_FAILED" )
}
}
if( Errcode )
{
set_fail_state( "ERRCODE" )
}
new id
id = Data[ 0 ]
if( ~IsConnected( id ) )
return PLUGIN_HANDLED
if( SQL_NumResults( Query ) < 1 )
{
// do something else
}
else
{
static iValue
if( !iValue ) iValue = SQL_FieldNameToNum( Query, "player_value" )
g_iPlayerValue[ id ] = SQL_ReadResult( Query, iValue )
}
return PLUGIN_CONTINUE
}
but i don't know why sometimes when used method 2 (with cached value
iValue) i get error:
Code:
[MySQL] Invalid column: -1
[AMXX] Run time error 10: native error (native "SQL_ReadResult")
Thanks.