Transporto krovimas

[Jimmy.]

Kas čia blogai, kad mašinas krauna bet neišgauna jų kintamųjų:

 

stock LoadVehicle( playerid )
{
    new
        Query[ 256 ],
        tmp[ 32 ];

    format( Query, 256, "SELECT * FROM `vehicles` WHERE `Owner` ='%s'", GetName( playerid ) );
    mysql_query( Query );
    mysql_store_result( );

    new rows = mysql_num_rows( ), count = 0;
    if( rows > 0 )
    {
        for(new z = 0; z < rows; z++)
        {
            for(new i = 0; i < MAX_VEHICLE; i++)
            {

                mysql_fetch_field_row( tmp,"vid" ); vInfo[ i ][ vid ] = strval( tmp );
                mysql_fetch_field_row( tmp,"ModelsID" ); vInfo[ i ][ modelsid ] = strval( tmp );
                mysql_fetch_field_row( tmp,"Colour1" ); vInfo[ i ][ colour1 ] = strval( tmp );
                mysql_fetch_field_row( tmp,"Colour2" ); vInfo[ i ][ colour2 ] = strval( tmp );
                mysql_fetch_field_row( tmp,"X" ); vInfo[ i ][ posx ] = floatstr( tmp );
                mysql_fetch_field_row( tmp,"Y" ); vInfo[ i ][ posy ] = floatstr( tmp );
                mysql_fetch_field_row( tmp,"Z" ); vInfo[ i ][ posz ] = floatstr( tmp );
                mysql_fetch_field_row( tmp,"A" ); vInfo[ i ][ posa ] = floatstr( tmp );
                mysql_fetch_field_row( vInfo[ i ][ owner ],"Owner" );

                  vInfo[ i ][ vid ] = CreateVehicle( vInfo[ i ][ modelsid ], vInfo[ i ][ posx ], vInfo[ i ][ posy ], vInfo[ i ][ posz ], vInfo[ i ][ posa ], vInfo[ i ][ colour1 ], vInfo[ i ][ colour2 ], -1 );
                count++;
                break;
            }
        }
    }
    printf( "Loaded %d vehicles from %s", count, GetName( playerid ) );
    return 1;
}

MySQL:

[13:15:15] CMySQLHandler::Query(SELECT * FROM `vehicles` WHERE `Owner` ='Asdas_Sadsa') - Successfully executed.

[13:15:15] >> mysql_store_result( Connection handle: 1 )

[13:15:15] CMySQLHandler::StoreResult() - Result was stored.

[13:15:15] >> mysql_num_rows( Connection handle: 1 )

[13:15:15] CMySQLHandler::NumRows() - Returned 2 row(s)

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("vid") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("ModelsID") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Colour1") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Colour2") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("X") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Y") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Z") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("A") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Owner") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("vid") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("ModelsID") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Colour1") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Colour2") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("X") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Y") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Z") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("A") -

[13:15:15] >> mysql_fetch_field_row( Connection handle: 1 )

[13:15:15] CMySQLHandler::FetchField("Owner") -

[MartynasK]

Pvz. iš mano modo:

format( query, 250, "select * from "VEHICLE" where Savininkas = '%s'", Vardas( p ) );
mysql_query( query );
mysql_store_result( );
mysql_retrieve_row( );
	    
if( mysql_num_rows( ) )
{
  new Float:vhealth,
  Float:pos[4];
	    
  mysql_fetch_field_row( fetch, "Bukle" ); vhealth = floatstr( fetch );
	        
  if( vhealth > 250.0 )
  {
    // užkraunam poziciją, modelį, spalvą ir t.t. Viską ko reikia transporto sukūrimui
    mysql_fetch_field_row( fetch, "Modelis" ); Modelis = strval( fetch );
    mysql_fetch_field_row( fetch, "X" ); pos[0] = floatstr( fetch );
    mysql_fetch_field_row( fetch, "Y" ); pos[1] = floatstr( fetch );
    mysql_fetch_field_row( fetch, "Z" ); pos[2] = floatstr( fetch );
    mysql_fetch_field_row( fetch, "Angle" ); pos[3] = floatstr( fetch );
    mysql_fetch_field_row( fetch, "Spalva1" ); Spalva[0] = strval( fetch );
    mysql_fetch_field_row( fetch, "Spalva2" ); Spalva[1] = strval( fetch );

    new SukurtasTransportas = CreateVehicle( Modelis, pos[0], pos[1], pos[2], pos[3], Spalva[0], Spalva[1], -1 );
    vDB[ SukurtasTransportas ][ rakinta ] = true;
    vDB[ SukurtasTransportas ][ pirkta ] = true;
    vDB[ SukurtasTransportas ][ variklis ] = false;
    vDB[ SukurtasTransportas ][ sviesos ] = false;
    // ir t.t. Transporto ID dabar bus "SukurtasTransportas".
  }
}
mysql_free_result();

tingėjau aiškint ir daryt pavyzdį, tai daviau savo kodą. Jei ko nesuprasi sakyk.

Redaguota Balandžio 19, 2015, nario MartynasK

[Jimmy.]

Mano biškį kitokia sistema. Darau sistemą, kad bet kiek galima turėt būtų mašinų. Bet jau po ilgų kančių su vieno žmogau pagalba susitvarkiau