Am1L

forward LoadGPS(gpsid,  name[], value[]);
public LoadGPS(gpsid, name[], value[]) {
	INI_String("Naziv",gpsInfo, 128);
	INI_Float("X",gpsInfo);
    INI_Float("Y",gpsInfo);
    INI_Float("Z",gpsInfo);
	return (1);
}
////////////////////////////////////////////////////////
stock SaveGPS(gpsid) {
	new kFile;
    format(kFile, sizeof(kFile), GPS_FILE, gpsid);
	new INI:File = INI_Open(kFile);
	INI_WriteString(File,"Naziv",gpsInfo);
    INI_WriteFloat(File,"X",gpsInfo);
    INI_WriteFloat(File,"Y",gpsInfo);
    INI_WriteFloat(File,"Z",gpsInfo);
	INI_Close(File);
	return (1);
}

protected mSQL_CreateFuelStation( createID )
{
	static q;
    mysql_format( mSQL, q, sizeof( q ),
    
		"INSERT INTO `fuel_stations` ( fsBussinesID, fsFuelPrice, fsPos1, fsPos2, fsPos3 ) \
		VALUES( '%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f' )",

        FuelStation[ createID ][ fsBussinesID ], FuelStation[ createID ][ fsFuelPrice ], FuelStation[ createID ][ fsPos ][ 0 ], FuelStation[ createID ][ fsPos ][ 1 ], FuelStation[ createID ][ fsPos ][ 2 ] );

    mysql_tquery( mSQL, q, "OnFuelStationCreated", "i", createID );
	return(true);
}
protected OnFuelStationCreated( createID )
{
	FuelStation[ createID ][ fsSQLID ] = cache_insert_id();
	return(true);
}

[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] mysql_format - no value for specifier "%f" available
[11:20:02 10/22/21] CMySQLQuery::Execute - (error #1136) Column count doesn't match value count at row 1 (Query: "INSERT INTO `fuel_stations` ( fsBussinesID, fsFuelPrice, fsPos1, fsPos2, fsPos3 ) VALUES( '7', '2', '1148904002', '-999769157', '1110002024', '', '', '' )")

//

//

protected CheckPlayerAccount( playerid )
{
    new rows, fields;
    cache_get_data( rows, fields, mSQL );

    if( !rows )
	{
        if( !IsValidRoleplayName( ImeIgraca( playerid ) ) )
		{
			SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Dobili ste kick zbog krivo formatiranog imena." );
			SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Vase ime mora biti u formatu {FA5555}'Ime_Prezime'." );
			defer KickIgraca(playerid);
			return 1;
		}

	    if( ServerInfo[ Registracija ] == false )
		{
			SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
			SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
			defer KickIgraca(playerid);
            return 1;
	    }

	    Register(playerid);
    }
    else
	{
        cache_get_field_content( 0, "password", PlayerInfo[ playerid ][ xLozinka ], mSQL, 150 );
		PlayerInfo[ playerid ][ xRegistrovan ] = cache_get_field_content_int( 0, "registered" );
		PlayerInfo[ playerid ][ xID ] = cache_get_field_content_int( 0, "user_id" );
		PlayerInfo[ playerid ][ xLevel ] = cache_get_field_content_int( 0, "level" );
		PlayerInfo[ playerid ][ xRespekt ] = cache_get_field_content_int( 0, "exp" );
		PlayerInfo[ playerid ][ xOnlineSati ] = cache_get_field_content_int( 0, "xOnlineSati" );
		PlayerInfo[ playerid ][ xDrzava ] = cache_get_field_content_int( 0, "country" );
		PlayerInfo[ playerid ][ xNovac ] = cache_get_field_content_int( 0, "money" );
		PlayerInfo[ playerid ][ xBRacun ] = cache_get_field_content_int( 0, "xBRacun" );
		PlayerInfo[ playerid ][ xPosao ] = cache_get_field_content_int( 0, "job_id" );
		PlayerInfo[ playerid ][ xUgovor ] = cache_get_field_content_int( 0, "contract" );
		PlayerInfo[ playerid ][ xSkin ] = cache_get_field_content_int( 0, "skin_id" );
		PlayerInfo[ playerid ][ xWarn ] = cache_get_field_content_int( 0, "warn" );
		PlayerInfo[ playerid ][ xAdmin ] = cache_get_field_content_int( 0, "admin_lvl" );
		PlayerInfo[ playerid ][ xHelper ] = cache_get_field_content_int( 0, "helper_level" );
		PlayerInfo[ playerid ][ xTestAdmin ] = cache_get_field_content_int( 0, "xTestAdmin" );
		PlayerInfo[ playerid ][ xVIPLevel ] = cache_get_field_content_int( 0, "vip_level" );
		PlayerInfo[ playerid ][ xVPoen ] = cache_get_field_content_int( 0, "v_poen" );
		PlayerInfo[ playerid ][ xVCoin ] = cache_get_field_content_int( 0, "xVCoin" );
		PlayerInfo[ playerid ][ xTogStats ] = bool:cache_get_field_content_int( 0, "xTogStats" );

        if( PlayerInfo[ playerid ][ xRegistrovan ] == 1 )
		{
            new query;
			mysql_format( mSQL, query, sizeof(query), "SELECT * FROM `banned` WHERE `user_id` = '%d' LIMIT 1", PlayerInfo[ playerid ][ xID ] );
			mysql_pquery( mSQL, query, "CheckPlayerBan", "i", playerid );
		}
		else
		{
		    if( ServerInfo[ Registracija ] == false )
			{
		        SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
				SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
		        defer KickIgraca(playerid);
		        return 1;
		    }

			Register(playerid);
		}
    }
	return(true);
}

 CMySQLQuery::Execute - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Amil_Vetar' LIMIT 1")