[quark]

PHP Code:

public Load_Status(id)
{
    new szSteamId[32], szTemp[512]
    get_user_authid(id, szSteamId, charsmax(szSteamId))
    
    new Data[1]
    Data[0] = id
    
    format(szTemp,charsmax(szTemp),"SELECT * FROM `%s` WHERE steamID = ^"%s^";",Table,szSteamId)
    SQL_ThreadQuery(g_SqlTuple,"Load_Status2",szTemp,Data,1)
}

public Load_Status2(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(FailState == TQUERY_CONNECT_FAILED)
    {
        log_amx("Load - Could not connect to SQL database.  [%d] %s", Errcode, Error)
    }
    else if(FailState == TQUERY_QUERY_FAILED)
    {
        log_amx("Load Query failed. [%d] %s", Errcode, Error)
    }
    
    new id
    id = Data[0]
    
    if(SQL_NumResults(Query) == 0) 
    {
        //create table bla bla bla , i will make it soon.
    } 
    else 
    {
        SQL_ReadResult(Query, 0, nick[id])
        SQL_ReadResult(Query, 1, Skill[id])
    }
    
    return PLUGIN_HANDLED
} 


So Nick is on Column 1 and Skill in Column 2 on SQL Table.
BUt this don't work, why?

[Neeeeeeeeeel.-]

Show how you make the connection.
Do you get any error?

Use formatex instead of format.

[quark]

No errors.

Here is my connection:

PHP Code:

public MySql_Init()
{
    g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db)
    
    new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))
    
    if(SqlConnection == Empty_Handle) set_fail_state(g_Error)
    
    SQL_FreeHandle(SqlConnection)   
} 


[claudiuhks]

http://forums.alliedmods.net/showthread.php?t=197059

PHP Code:

SELECT * FROM table WHERE steam = 'string'
// SELECT * FROM table WHERE steam = "string" // maybe wrong? 


PHP Code:

new String[ 33 ][ 32 ];
new Numeric[ 33 ];
new PlayerId;

SQL_ReadResult( hQuery, 0, String[ PlayerId ], charsmax( String[ PlayerId ] ) ); // For string variables like name/steam/ip address
Numeric[ PlayerId ] = SQL_ReadResult( hQuery, 1 ); // For numeric values like frags/score/deaths 


[quark]

hmmmmmmmmmm I will try, thanks.

[Neeeeeeeeeel.-]

Now I see the error... you don't pass the fourth argument.

PHP Code:

SQL_ReadResult( Query, 0, nick[ id ], charsmax( nick[ ] ) );
SQL_ReadResult( Query, 1, Skill[ id ], charsmax( Skill[ ] ) ); 


[quark]

Originally Posted by Neeeeeeeeeel.- Now I see the error... you don't pass the fourth argument. PHP Code: SQL_ReadResult( Query, 0, nick[ id ], charsmax( nick[ ] ) ); SQL_ReadResult( Query, 1, Skill[ id ], charsmax( Skill[ ] ) );

Don't work.

Originally Posted by claudiuhks http://forums.alliedmods.net/showthread.php?t=197059 PHP Code: SELECT * FROM table WHERE steam = 'string' // SELECT * FROM table WHERE steam = "string" // maybe wrong?  PHP Code: new String[ 33 ][ 32 ]; new Numeric[ 33 ]; new PlayerId; SQL_ReadResult( hQuery, 0, String[ PlayerId ], charsmax( String[  PlayerId ] ) ); // For string variables like name/steam/ip address Numeric[ PlayerId ] = SQL_ReadResult( hQuery, 1 ); // For numeric values like frags/score/deaths

So i am using Hattrick, how can I get user name from database:

PHP Code:

public ReadData( Player ) {
  if( is_user_connected( Player ) ) {
    new File = fopen( "addons/QueryResult.ini", "r" );

    if( File ) {
      new Frags[ 10 ], Deaths[ 10 ], Buffer[ 1024 ];

      fgets( File, Buffer, 1023 );

      trim( Buffer );

      if( !strlen( Buffer ) ) {
        server_cmd( "Query %s \"INSERT INTO players VALUES ( '%s', 0, 0 )\"", gConnectionData, gName[ Player ] );

        gFrags[ Player ] = 0;
        gDeaths[ Player ] = 0;

        return;
      }

      //here but how? :|

      parse( Buffer, Frags, 9, Deaths, 9 );

      gFrags[ Player ] = str_to_num( Frags );
      gDeaths[ Player ] = str_to_num( Deaths );

      fclose( File );
    }
  }
}