SQL_Function LoadPersonalVehicleInfo( playerid )
{
if ( !IsPlayerConnected( playerid ) )
return ( 0 );
new Field[ 25 ], Rows, Fields;
cache_get_data( Rows, Fields, g_Handle );
if( Rows )
{
PlayerInfo[ playerid ][ CarID ] = cache_get_field_content_int( 0,"ID" );
PlayerInfo[ playerid ][ car_X ] = cache_get_field_content_float( 0, "Veh_LocX" );
PlayerInfo[ playerid ][ car_Y ] = cache_get_field_content_float( 0, "Veh_LocY" );
PlayerInfo[ playerid ][ car_Z ] = cache_get_field_content_float( 0, "Veh_LocZ" );
PlayerInfo[ playerid ][ car_A ] = cache_get_field_content_float( 0,"Veh_LocA" );
PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked" );
PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1" );
PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2" );
PlayerInfo[ playerid ][ spoilerid ] = cache_get_field_content_int( 0, "Spoiler" );
PlayerInfo[ playerid ][ neonid ] = cache_get_field_content_int( 0, "Plate" );
cache_get_field_content( 0, "Plate", Field, g_Handle );
format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );
PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );
format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );
if ( PlayerInfo[ playerid ][ neonid ] != 0 )
OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );
if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );
format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
}
return ( 1 );
}